SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2393 | 13.28 s | 117.76 ms | |
background | wait/io/file/innodb/innodb_data_file | 4030 | 6.00 s | 208.38 ms | |
background | wait/io/file/innodb/innodb_temp_file | 87 | 418.59 ms | 93.01 ms | |
background | wait/io/file/sql/binlog_index | 36 | 53.08 ms | 33.07 ms | |
background | wait/io/file/sql/binlog | 37 | 32.08 ms | 15.93 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.26 ms | 524.47 us | |
background | wait/io/file/mysys/cnf | 5 | 1.07 ms | 1.05 ms | |
background | wait/io/file/sql/casetest | 15 | 903.75 us | 835.51 us | |
background | wait/io/file/mysys/charset | 3 | 241.21 us | 224.98 us | |
background | wait/io/file/sql/pid | 3 | 15.23 us | 10.75 us | |
background | wait/io/file/sql/misc | 1 | 3.76 us | 3.76 us | |
root | wait/io/file/innodb/innodb_data_file | 707 | 1.08 s | 50.48 ms | |
root | wait/io/file/sql/binlog | 550 | 443.48 ms | 27.95 ms | |
root | wait/io/file/innodb/innodb_temp_file | 8 | 121.47 ms | 37.80 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 44.12 ms | 4.32 ms | |
root | wait/io/file/sql/io_cache | 52 | 10.16 ms | 8.21 ms | |
root | wait/io/file/myisam/kfile | 16 | 5.67 ms | 3.12 ms | |
root | wait/io/file/csv/metadata | 8 | 4.16 ms | 1.84 ms | |
root | wait/io/file/csv/data | 6 | 1.30 ms | 1.23 ms | |
root | wait/io/file/myisam/dfile | 122 | 588.13 us | 380.85 us | |
root | wait/io/file/sql/binlog_index | 2 | 193.63 us | 191.52 us | |
root | wait/io/file/sql/misc | 7 | 118.72 us | 31.59 us |
|