SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 901 | 5.89 s | 301.54 ms | |
background | wait/io/file/innodb/innodb_data_file | 2450 | 3.56 s | 240.79 ms | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 347.07 ms | 22.90 ms | |
background | wait/io/file/sql/binlog | 98 | 52.23 ms | 26.51 ms | |
background | wait/io/file/sql/binlog_index | 36 | 48.07 ms | 24.58 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 2.20 ms | 1.27 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.04 ms | 1.02 ms | |
background | wait/io/file/sql/casetest | 15 | 1.00 ms | 944.39 us | |
background | wait/io/file/mysys/charset | 3 | 301.97 us | 287.43 us | |
background | wait/io/file/sql/pid | 3 | 49.12 us | 38.32 us | |
background | wait/io/file/sql/misc | 1 | 10.95 us | 10.95 us | |
root | wait/io/file/innodb/innodb_data_file | 380 | 167.52 ms | 21.34 ms | |
root | wait/io/file/sql/binlog | 212 | 111.43 ms | 19.94 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 34.30 ms | 2.72 ms | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 24.69 ms | 24.62 ms | |
root | wait/io/file/myisam/kfile | 8 | 2.36 ms | 1.73 ms | |
root | wait/io/file/csv/metadata | 4 | 722.58 us | 397.55 us | |
root | wait/io/file/csv/data | 8 | 320.29 us | 229.06 us | |
root | wait/io/file/myisam/dfile | 10 | 68.70 us | 36.31 us | |
root | wait/io/file/sql/misc | 3 | 53.80 us | 23.16 us | |
root | wait/io/file/sql/binlog_index | 2 | 6.20 us | 3.63 us |
|