SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2589 | 12.68 s | 372.77 ms | |
background | wait/io/file/innodb/innodb_data_file | 3603 | 5.73 s | 232.31 ms | |
background | wait/io/file/innodb/innodb_temp_file | 311 | 345.30 ms | 22.58 ms | |
background | wait/io/file/sql/binlog_index | 36 | 52.92 ms | 37.40 ms | |
background | wait/io/file/sql/binlog | 37 | 29.73 ms | 15.78 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.59 ms | 1.57 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.29 ms | 601.46 us | |
background | wait/io/file/sql/casetest | 15 | 886.18 us | 810.50 us | |
background | wait/io/file/mysys/charset | 3 | 242.32 us | 223.30 us | |
background | wait/io/file/sql/pid | 3 | 12.66 us | 10.00 us | |
background | wait/io/file/sql/misc | 1 | 4.95 us | 4.95 us | |
root | wait/io/file/innodb/innodb_temp_file | 112 | 1.07 s | 39.58 ms | |
root | wait/io/file/sql/binlog | 690 | 709.53 ms | 24.36 ms | |
root | wait/io/file/innodb/innodb_data_file | 674 | 418.76 ms | 28.69 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 67.18 ms | 14.31 ms | |
root | wait/io/file/sql/io_cache | 164 | 35.19 ms | 23.59 ms | |
root | wait/io/file/csv/metadata | 8 | 1.41 ms | 811.01 us | |
root | wait/io/file/myisam/kfile | 4 | 1.18 ms | 1.08 ms | |
root | wait/io/file/sql/binlog_index | 2 | 203.71 us | 201.33 us | |
root | wait/io/file/csv/data | 4 | 53.15 us | 28.65 us | |
root | wait/io/file/sql/misc | 4 | 52.33 us | 23.50 us | |
root | wait/io/file/myisam/dfile | 4 | 51.15 us | 25.29 us |
|