SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_data_file | 1489 | 756.87 ms | 229.80 ms | |
background | wait/io/file/innodb/innodb_log_file | 116 | 607.97 ms | 98.86 ms | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 357.23 ms | 35.81 ms | |
background | wait/io/file/sql/binlog_index | 36 | 57.31 ms | 40.23 ms | |
background | wait/io/file/sql/binlog | 37 | 34.41 ms | 17.23 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.43 ms | 1.41 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.35 ms | 511.86 us | |
background | wait/io/file/sql/casetest | 15 | 952.96 us | 856.50 us | |
background | wait/io/file/mysys/charset | 3 | 271.85 us | 228.88 us | |
background | wait/io/file/sql/pid | 3 | 12.93 us | 10.37 us | |
background | wait/io/file/sql/misc | 1 | 3.41 us | 3.41 us | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 26.33 ms | 26.27 ms | |
root | wait/io/file/innodb/innodb_data_file | 94 | 25.84 ms | 2.19 ms | |
root | wait/io/file/sql/ERRMSG | 25 | 8.61 ms | 1.81 ms | |
root | wait/io/file/myisam/kfile | 4 | 1.61 ms | 1.59 ms | |
root | wait/io/file/sql/binlog | 140 | 816.14 us | 28.78 us | |
root | wait/io/file/myisam/dfile | 29 | 565.96 us | 537.87 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.55 us | 2.71 us |
|