SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 478 | 2.73 s | 32.13 ms | |
background | wait/io/file/innodb/innodb_data_file | 1982 | 2.20 s | 201.73 ms | |
background | wait/io/file/innodb/innodb_temp_file | 80 | 374.81 ms | 27.65 ms | |
background | wait/io/file/sql/binlog_index | 36 | 57.66 ms | 38.79 ms | |
background | wait/io/file/sql/binlog | 37 | 36.15 ms | 17.63 ms | |
background | wait/io/file/mysys/cnf | 5 | 4.25 ms | 4.23 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.25 ms | 559.38 us | |
background | wait/io/file/sql/casetest | 15 | 872.67 us | 784.12 us | |
background | wait/io/file/mysys/charset | 3 | 260.05 us | 233.56 us | |
background | wait/io/file/sql/pid | 3 | 15.40 us | 12.47 us | |
background | wait/io/file/sql/misc | 1 | 5.93 us | 5.93 us | |
root | wait/io/file/innodb/innodb_data_file | 240 | 82.01 ms | 2.84 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 37.13 ms | 3.37 ms | |
root | wait/io/file/csv/metadata | 8 | 1.53 ms | 718.93 us | |
root | wait/io/file/sql/binlog | 116 | 573.71 us | 24.44 us | |
root | wait/io/file/csv/data | 8 | 77.26 us | 36.73 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.34 us | 2.53 us |
|