SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 982 | 8.58 s | 990.51 ms | |
background | wait/io/file/innodb/innodb_data_file | 2552 | 3.84 s | 243.24 ms | |
background | wait/io/file/innodb/innodb_temp_file | 100 | 404.54 ms | 29.88 ms | |
background | wait/io/file/sql/binlog_index | 36 | 49.36 ms | 29.74 ms | |
background | wait/io/file/sql/binlog | 37 | 43.41 ms | 24.37 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.36 ms | 564.96 us | |
background | wait/io/file/sql/casetest | 15 | 1.20 ms | 1.13 ms | |
background | wait/io/file/mysys/cnf | 5 | 633.16 us | 618.34 us | |
background | wait/io/file/mysys/charset | 3 | 274.76 us | 260.92 us | |
background | wait/io/file/sql/pid | 3 | 62.01 us | 37.67 us | |
background | wait/io/file/sql/misc | 1 | 14.04 us | 14.04 us | |
root | wait/io/file/myisam/dfile | 169 | 785.85 ms | 783.73 ms | |
root | wait/io/file/innodb/innodb_data_file | 566 | 215.96 ms | 19.23 ms | |
root | wait/io/file/innodb/innodb_temp_file | 16 | 209.93 ms | 39.79 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 45.15 ms | 10.36 ms | |
root | wait/io/file/sql/io_cache | 328 | 15.00 ms | 6.38 ms | |
root | wait/io/file/csv/metadata | 8 | 10.53 ms | 9.80 ms | |
root | wait/io/file/sql/binlog | 241 | 2.38 ms | 378.43 us | |
root | wait/io/file/myisam/kfile | 12 | 1.32 ms | 533.12 us | |
root | wait/io/file/csv/data | 10 | 1.27 ms | 1.12 ms | |
root | wait/io/file/sql/binlog_index | 2 | 822.73 us | 820.76 us |
|