SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1207 | 6.27 s | 121.09 ms | |
background | wait/io/file/innodb/innodb_data_file | 2884 | 2.68 s | 247.88 ms | |
background | wait/io/file/innodb/innodb_temp_file | 654 | 648.00 ms | 172.76 ms | |
background | wait/io/file/sql/binlog_index | 36 | 63.71 ms | 46.46 ms | |
background | wait/io/file/sql/binlog | 37 | 32.42 ms | 16.34 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.14 ms | 473.00 us | |
background | wait/io/file/sql/casetest | 15 | 916.72 us | 852.41 us | |
background | wait/io/file/mysys/cnf | 5 | 322.85 us | 302.52 us | |
background | wait/io/file/mysys/charset | 3 | 244.35 us | 230.78 us | |
background | wait/io/file/sql/pid | 3 | 13.04 us | 10.76 us | |
background | wait/io/file/sql/misc | 1 | 12.51 us | 12.51 us | |
root | wait/io/file/innodb/innodb_temp_file | 58 | 480.78 ms | 26.71 ms | |
root | wait/io/file/innodb/innodb_data_file | 320 | 329.65 ms | 109.08 ms | |
root | wait/io/file/sql/binlog | 119 | 89.87 ms | 18.64 ms | |
root | wait/io/file/sql/io_cache | 759 | 52.95 ms | 14.58 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 32.37 ms | 6.36 ms | |
root | wait/io/file/csv/metadata | 8 | 729.88 us | 341.30 us | |
root | wait/io/file/csv/data | 8 | 421.63 us | 390.05 us | |
root | wait/io/file/myisam/kfile | 4 | 198.46 us | 171.24 us | |
root | wait/io/file/sql/binlog_index | 2 | 189.47 us | 187.59 us | |
root | wait/io/file/sql/misc | 3 | 34.10 us | 12.36 us | |
root | wait/io/file/myisam/dfile | 3 | 19.20 us | 12.77 us |
|