SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 22020 | 1.22 m | 246.00 ms | |
background | wait/io/file/innodb/innodb_data_file | 7813 | 14.55 s | 216.96 ms | |
background | wait/io/file/innodb/innodb_temp_file | 126 | 530.14 ms | 135.55 ms | |
background | wait/io/file/sql/binlog_index | 36 | 50.74 ms | 29.38 ms | |
background | wait/io/file/sql/binlog | 37 | 39.50 ms | 20.15 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.56 ms | 605.34 us | |
background | wait/io/file/sql/casetest | 15 | 724.41 us | 662.81 us | |
background | wait/io/file/mysys/cnf | 5 | 623.36 us | 603.09 us | |
background | wait/io/file/mysys/charset | 3 | 290.91 us | 279.06 us | |
background | wait/io/file/sql/pid | 3 | 19.62 us | 15.64 us | |
background | wait/io/file/sql/misc | 1 | 9.73 us | 9.73 us | |
root | wait/io/file/innodb/innodb_data_file | 4031 | 12.47 s | 159.11 ms | |
root | wait/io/file/sql/binlog | 1449 | 5.87 s | 106.77 ms | |
root | wait/io/file/innodb/innodb_temp_file | 30 | 260.17 ms | 29.89 ms | |
root | wait/io/file/sql/ERRMSG | 90 | 62.82 ms | 8.76 ms | |
root | wait/io/file/sql/io_cache | 430 | 48.05 ms | 23.16 ms | |
root | wait/io/file/myisam/dfile | 8318 | 5.25 ms | 360.64 us | |
root | wait/io/file/csv/metadata | 4 | 4.52 ms | 2.41 ms | |
root | wait/io/file/sql/misc | 5 | 2.05 ms | 1.80 ms | |
root | wait/io/file/myisam/kfile | 16 | 1.86 ms | 815.82 us | |
root | wait/io/file/csv/data | 2 | 72.30 us | 57.65 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.15 us | 3.40 us |
|