SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 832 | 4.24 s | 41.40 ms | |
background | wait/io/file/innodb/innodb_data_file | 2479 | 2.58 s | 229.56 ms | |
background | wait/io/file/innodb/innodb_temp_file | 621 | 1.14 s | 754.18 ms | |
background | wait/io/file/sql/binlog_index | 36 | 49.44 ms | 30.35 ms | |
background | wait/io/file/sql/binlog | 37 | 29.35 ms | 15.39 ms | |
background | wait/io/file/mysys/cnf | 5 | 2.28 ms | 2.25 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.41 ms | 481.11 us | |
background | wait/io/file/sql/casetest | 15 | 975.76 us | 890.47 us | |
background | wait/io/file/mysys/charset | 3 | 354.74 us | 334.26 us | |
background | wait/io/file/sql/pid | 3 | 15.96 us | 13.42 us | |
background | wait/io/file/sql/misc | 1 | 5.40 us | 5.40 us | |
root | wait/io/file/innodb/innodb_temp_file | 54 | 525.02 ms | 39.66 ms | |
root | wait/io/file/sql/io_cache | 934 | 242.73 ms | 85.80 ms | |
root | wait/io/file/innodb/innodb_data_file | 312 | 200.49 ms | 28.13 ms | |
root | wait/io/file/sql/binlog | 180 | 119.43 ms | 24.08 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 35.32 ms | 4.21 ms | |
root | wait/io/file/csv/metadata | 4 | 505.76 us | 459.21 us | |
root | wait/io/file/sql/binlog_index | 2 | 190.76 us | 189.05 us | |
root | wait/io/file/csv/data | 20 | 116.66 us | 21.02 us | |
root | wait/io/file/sql/misc | 4 | 51.61 us | 15.82 us |
|