SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 664 | 3.57 s | 121.09 ms | |
background | wait/io/file/innodb/innodb_data_file | 2246 | 1.67 s | 247.88 ms | |
background | wait/io/file/innodb/innodb_temp_file | 549 | 645.16 ms | 172.76 ms | |
background | wait/io/file/sql/binlog_index | 36 | 63.71 ms | 46.46 ms | |
background | wait/io/file/sql/binlog | 37 | 32.42 ms | 16.34 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.14 ms | 473.00 us | |
background | wait/io/file/sql/casetest | 15 | 916.72 us | 852.41 us | |
background | wait/io/file/mysys/cnf | 5 | 322.85 us | 302.52 us | |
background | wait/io/file/mysys/charset | 3 | 244.35 us | 230.78 us | |
background | wait/io/file/sql/pid | 3 | 13.04 us | 10.76 us | |
background | wait/io/file/sql/misc | 1 | 12.51 us | 12.51 us | |
root | wait/io/file/innodb/innodb_temp_file | 30 | 263.62 ms | 26.71 ms | |
root | wait/io/file/innodb/innodb_data_file | 292 | 215.54 ms | 109.08 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 29.70 ms | 6.36 ms | |
root | wait/io/file/sql/io_cache | 487 | 23.02 ms | 11.49 ms | |
root | wait/io/file/sql/binlog | 34 | 18.65 ms | 12.84 ms | |
root | wait/io/file/csv/metadata | 4 | 413.81 us | 341.30 us | |
root | wait/io/file/sql/binlog_index | 2 | 189.47 us | 187.59 us | |
root | wait/io/file/csv/data | 2 | 16.42 us | 10.65 us | |
root | wait/io/file/sql/misc | 1 | 12.36 us | 12.36 us |
|