SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1071 | 6.82 s | 205.79 ms | |
background | wait/io/file/innodb/innodb_data_file | 2667 | 4.02 s | 233.83 ms | |
background | wait/io/file/innodb/innodb_temp_file | 213 | 313.12 ms | 22.84 ms | |
background | wait/io/file/sql/binlog_index | 36 | 50.43 ms | 34.39 ms | |
background | wait/io/file/sql/binlog | 37 | 42.28 ms | 21.17 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.42 ms | 575.92 us | |
background | wait/io/file/sql/casetest | 15 | 946.16 us | 839.40 us | |
background | wait/io/file/mysys/cnf | 5 | 417.66 us | 396.07 us | |
background | wait/io/file/mysys/charset | 3 | 241.43 us | 221.81 us | |
background | wait/io/file/sql/pid | 3 | 14.27 us | 11.68 us | |
background | wait/io/file/sql/misc | 1 | 5.38 us | 5.38 us | |
root | wait/io/file/innodb/innodb_data_file | 562 | 581.54 ms | 416.03 ms | |
root | wait/io/file/innodb/innodb_temp_file | 16 | 209.31 ms | 48.39 ms | |
root | wait/io/file/sql/io_cache | 198 | 63.10 ms | 58.39 ms | |
root | wait/io/file/csv/metadata | 8 | 31.63 ms | 24.91 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 21.34 ms | 4.01 ms | |
root | wait/io/file/sql/binlog | 260 | 1.57 ms | 140.63 us | |
root | wait/io/file/myisam/kfile | 12 | 1.08 ms | 496.17 us | |
root | wait/io/file/csv/data | 45 | 871.72 us | 613.46 us | |
root | wait/io/file/myisam/dfile | 376 | 735.06 us | 215.71 us | |
root | wait/io/file/sql/binlog_index | 2 | 156.54 us | 155.10 us |
|