SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 814 | 5.29 s | 167.99 ms | |
background | wait/io/file/innodb/innodb_data_file | 2475 | 3.88 s | 234.33 ms | |
background | wait/io/file/innodb/innodb_temp_file | 83 | 313.73 ms | 30.24 ms | |
background | wait/io/file/sql/binlog_index | 36 | 40.89 ms | 25.60 ms | |
background | wait/io/file/sql/binlog | 37 | 33.69 ms | 20.33 ms | |
background | wait/io/file/sql/casetest | 15 | 1.44 ms | 1.34 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.20 ms | 517.74 us | |
background | wait/io/file/mysys/cnf | 5 | 538.61 us | 521.39 us | |
background | wait/io/file/mysys/charset | 3 | 247.64 us | 229.00 us | |
background | wait/io/file/sql/pid | 3 | 12.57 us | 9.98 us | |
background | wait/io/file/sql/misc | 1 | 3.54 us | 3.54 us | |
root | wait/io/file/innodb/innodb_data_file | 449 | 249.29 ms | 32.20 ms | |
root | wait/io/file/sql/binlog | 745 | 105.93 ms | 23.71 ms | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 62.39 ms | 27.32 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 35.38 ms | 2.97 ms | |
root | wait/io/file/csv/metadata | 8 | 1.97 ms | 883.82 us | |
root | wait/io/file/sql/misc | 3 | 570.62 us | 535.83 us | |
root | wait/io/file/myisam/dfile | 80 | 344.34 us | 317.73 us | |
root | wait/io/file/myisam/kfile | 4 | 318.93 us | 301.53 us | |
root | wait/io/file/csv/data | 12 | 50.70 us | 10.70 us | |
root | wait/io/file/sql/binlog_index | 2 | 6.42 us | 4.33 us |
|