SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 349 | 1.99 s | 176.08 ms | |
background | wait/io/file/innodb/innodb_data_file | 1862 | 1.70 s | 233.60 ms | |
background | wait/io/file/innodb/innodb_temp_file | 168 | 349.30 ms | 27.13 ms | |
background | wait/io/file/sql/binlog_index | 36 | 40.96 ms | 23.83 ms | |
background | wait/io/file/sql/binlog | 37 | 30.94 ms | 17.03 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 2.25 ms | 1.33 ms | |
background | wait/io/file/sql/casetest | 15 | 1.04 ms | 980.29 us | |
background | wait/io/file/mysys/cnf | 5 | 800.36 us | 783.26 us | |
background | wait/io/file/mysys/charset | 3 | 266.39 us | 255.73 us | |
background | wait/io/file/sql/pid | 3 | 19.20 us | 14.18 us | |
background | wait/io/file/sql/misc | 1 | 13.55 us | 13.55 us | |
root | wait/io/file/innodb/innodb_data_file | 231 | 80.10 ms | 4.67 ms | |
root | wait/io/file/innodb/innodb_temp_file | 4 | 41.13 ms | 20.56 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 30.84 ms | 2.52 ms | |
root | wait/io/file/sql/io_cache | 46 | 18.22 ms | 16.94 ms | |
root | wait/io/file/sql/binlog | 416 | 2.51 ms | 162.61 us | |
root | wait/io/file/myisam/dfile | 28 | 1.66 ms | 1.64 ms | |
root | wait/io/file/sql/binlog_index | 2 | 708.53 us | 706.24 us | |
root | wait/io/file/myisam/kfile | 4 | 263.65 us | 243.56 us |
|