SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1273 | 6.66 s | 121.09 ms | |
background | wait/io/file/innodb/innodb_data_file | 2960 | 2.84 s | 247.88 ms | |
background | wait/io/file/innodb/innodb_temp_file | 745 | 654.14 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 | 66 | 542.79 ms | 26.71 ms | |
root | wait/io/file/innodb/innodb_data_file | 327 | 389.81 ms | 109.08 ms | |
root | wait/io/file/sql/binlog | 125 | 113.05 ms | 21.80 ms | |
root | wait/io/file/sql/io_cache | 915 | 75.10 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 |
|