SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2523 | 13.11 s | 919.74 ms | |
background | wait/io/file/innodb/innodb_data_file | 3533 | 5.74 s | 223.26 ms | |
background | wait/io/file/innodb/innodb_temp_file | 634 | 436.28 ms | 56.99 ms | |
background | wait/io/file/sql/binlog_index | 36 | 48.41 ms | 24.83 ms | |
background | wait/io/file/sql/binlog | 37 | 38.50 ms | 18.15 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 2.25 ms | 1.32 ms | |
background | wait/io/file/sql/casetest | 15 | 1.05 ms | 983.42 us | |
background | wait/io/file/mysys/cnf | 5 | 993.95 us | 974.27 us | |
background | wait/io/file/mysys/charset | 3 | 183.88 us | 168.49 us | |
background | wait/io/file/sql/pid | 3 | 65.13 us | 39.29 us | |
background | wait/io/file/sql/misc | 1 | 11.23 us | 11.23 us | |
root | wait/io/file/sql/binlog | 602 | 1.04 s | 26.26 ms | |
root | wait/io/file/innodb/innodb_temp_file | 54 | 506.72 ms | 31.31 ms | |
root | wait/io/file/innodb/innodb_data_file | 739 | 398.52 ms | 31.71 ms | |
root | wait/io/file/sql/io_cache | 585 | 76.03 ms | 57.09 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 40.94 ms | 3.20 ms | |
root | wait/io/file/sql/misc | 16 | 2.08 ms | 1.71 ms | |
root | wait/io/file/csv/metadata | 4 | 914.36 us | 552.10 us | |
root | wait/io/file/csv/data | 2 | 582.60 us | 548.52 us | |
root | wait/io/file/myisam/kfile | 4 | 269.51 us | 198.16 us | |
root | wait/io/file/sql/binlog_index | 2 | 173.51 us | 171.98 us | |
root | wait/io/file/myisam/dfile | 4 | 30.99 us | 12.07 us |
|