SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1994 | 8.79 s | 77.79 ms | |
background | wait/io/file/innodb/innodb_data_file | 3044 | 4.01 s | 329.23 ms | |
background | wait/io/file/innodb/innodb_temp_file | 183 | 592.48 ms | 288.85 ms | |
background | wait/io/file/sql/binlog_index | 36 | 48.03 ms | 32.19 ms | |
background | wait/io/file/sql/binlog | 37 | 39.55 ms | 25.06 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.38 ms | 418.09 us | |
background | wait/io/file/sql/casetest | 15 | 895.38 us | 817.83 us | |
background | wait/io/file/mysys/cnf | 5 | 509.22 us | 488.28 us | |
background | wait/io/file/mysys/charset | 3 | 347.54 us | 318.22 us | |
background | wait/io/file/sql/pid | 3 | 17.26 us | 13.29 us | |
background | wait/io/file/sql/misc | 1 | 4.86 us | 4.86 us | |
root | wait/io/file/sql/binlog | 4248 | 527.30 ms | 37.05 ms | |
root | wait/io/file/innodb/innodb_temp_file | 26 | 268.38 ms | 25.66 ms | |
root | wait/io/file/innodb/innodb_data_file | 763 | 239.02 ms | 26.54 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 37.44 ms | 4.02 ms | |
root | wait/io/file/sql/io_cache | 48 | 13.11 ms | 11.89 ms | |
root | wait/io/file/csv/metadata | 8 | 2.94 ms | 1.81 ms | |
root | wait/io/file/myisam/kfile | 9 | 1.32 ms | 589.22 us | |
root | wait/io/file/myisam/dfile | 7 | 623.12 us | 539.26 us | |
root | wait/io/file/csv/data | 4 | 63.02 us | 34.75 us | |
root | wait/io/file/sql/misc | 1 | 10.67 us | 10.67 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.08 us | 2.79 us |
|