SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1035 | 6.44 s | 265.67 ms | |
background | wait/io/file/innodb/innodb_data_file | 2535 | 2.62 s | 213.56 ms | |
background | wait/io/file/innodb/innodb_temp_file | 250 | 330.02 ms | 25.72 ms | |
background | wait/io/file/sql/binlog_index | 36 | 44.83 ms | 28.98 ms | |
background | wait/io/file/sql/binlog | 37 | 32.28 ms | 18.22 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.45 ms | 1.43 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.41 ms | 522.61 us | |
background | wait/io/file/sql/casetest | 15 | 757.75 us | 686.74 us | |
background | wait/io/file/mysys/charset | 3 | 290.87 us | 262.68 us | |
background | wait/io/file/sql/pid | 3 | 13.03 us | 10.48 us | |
background | wait/io/file/sql/misc | 1 | 2.87 us | 2.87 us | |
root | wait/io/file/innodb/innodb_temp_file | 94 | 881.96 ms | 35.67 ms | |
root | wait/io/file/innodb/innodb_data_file | 433 | 122.64 ms | 20.65 ms | |
root | wait/io/file/sql/io_cache | 2314 | 122.46 ms | 26.35 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 31.66 ms | 3.42 ms | |
root | wait/io/file/sql/binlog | 444 | 28.73 ms | 23.52 ms | |
root | wait/io/file/csv/metadata | 8 | 3.17 ms | 1.98 ms | |
root | wait/io/file/myisam/kfile | 8 | 1.16 ms | 530.01 us | |
root | wait/io/file/csv/data | 9 | 788.45 us | 699.99 us | |
root | wait/io/file/myisam/dfile | 4 | 122.43 us | 71.70 us | |
root | wait/io/file/sql/binlog_index | 2 | 15.19 us | 10.07 us |
|