SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 502 | 2.93 s | 58.75 ms | |
background | wait/io/file/innodb/innodb_data_file | 2058 | 2.52 s | 249.24 ms | |
background | wait/io/file/innodb/innodb_temp_file | 83 | 379.59 ms | 42.51 ms | |
background | wait/io/file/sql/binlog_index | 36 | 52.46 ms | 32.00 ms | |
background | wait/io/file/sql/binlog | 37 | 41.85 ms | 20.98 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.85 ms | 1.83 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.28 ms | 388.78 us | |
background | wait/io/file/sql/casetest | 15 | 981.54 us | 924.14 us | |
background | wait/io/file/mysys/charset | 3 | 313.86 us | 300.17 us | |
background | wait/io/file/sql/pid | 3 | 51.98 us | 37.58 us | |
background | wait/io/file/sql/misc | 1 | 13.02 us | 13.02 us | |
root | wait/io/file/sql/binlog | 214 | 234.51 ms | 19.81 ms | |
root | wait/io/file/innodb/innodb_data_file | 305 | 162.99 ms | 21.45 ms | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 61.05 ms | 27.84 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 21.66 ms | 2.04 ms | |
root | wait/io/file/myisam/kfile | 4 | 1.27 ms | 1.20 ms | |
root | wait/io/file/sql/binlog_index | 2 | 171.22 us | 169.54 us | |
root | wait/io/file/myisam/dfile | 2 | 29.53 us | 26.26 us | |
root | wait/io/file/sql/misc | 1 | 12.17 us | 12.17 us |
|