SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 9346 | 44.48 s | 703.00 ms | |
background | wait/io/file/innodb/innodb_data_file | 13779 | 12.24 s | 220.60 ms | |
background | wait/io/file/innodb/innodb_temp_file | 1051 | 316.25 ms | 29.54 ms | |
background | wait/io/file/sql/binlog_index | 36 | 51.26 ms | 26.93 ms | |
background | wait/io/file/sql/binlog | 37 | 28.94 ms | 15.31 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.89 ms | 1.84 ms | |
background | wait/io/file/sql/casetest | 15 | 1.33 ms | 1.25 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.31 ms | 564.92 us | |
background | wait/io/file/mysys/charset | 3 | 291.23 us | 270.16 us | |
background | wait/io/file/sql/pid | 3 | 22.27 us | 14.12 us | |
background | wait/io/file/sql/misc | 1 | 5.10 us | 5.10 us | |
root | wait/io/file/innodb/innodb_temp_file | 122 | 1.04 s | 27.92 ms | |
root | wait/io/file/sql/binlog | 698 | 798.66 ms | 27.80 ms | |
root | wait/io/file/innodb/innodb_data_file | 620 | 620.67 ms | 99.98 ms | |
root | wait/io/file/sql/io_cache | 1666 | 363.68 ms | 75.01 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 17.73 ms | 1.72 ms | |
root | wait/io/file/myisam/kfile | 8 | 1.59 ms | 1.39 ms | |
root | wait/io/file/sql/misc | 13 | 1.33 ms | 591.07 us | |
root | wait/io/file/csv/metadata | 8 | 967.67 us | 540.39 us | |
root | wait/io/file/myisam/dfile | 30 | 284.53 us | 247.02 us | |
root | wait/io/file/csv/data | 4 | 33.03 us | 10.96 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.84 us | 3.11 us |
|