SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 554 | 3.65 s | 419.34 ms | |
background | wait/io/file/innodb/innodb_data_file | 2165 | 2.97 s | 200.60 ms | |
background | wait/io/file/innodb/innodb_temp_file | 300 | 496.20 ms | 73.90 ms | |
background | wait/io/file/sql/binlog_index | 36 | 49.85 ms | 34.22 ms | |
background | wait/io/file/sql/binlog | 37 | 43.73 ms | 30.27 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.33 ms | 441.03 us | |
background | wait/io/file/sql/casetest | 15 | 975.73 us | 873.08 us | |
background | wait/io/file/mysys/cnf | 5 | 595.58 us | 572.48 us | |
background | wait/io/file/mysys/charset | 3 | 332.26 us | 298.17 us | |
background | wait/io/file/sql/pid | 3 | 14.20 us | 11.45 us | |
background | wait/io/file/sql/misc | 1 | 6.19 us | 6.19 us | |
root | wait/io/file/innodb/innodb_temp_file | 70 | 1.21 s | 411.91 ms | |
root | wait/io/file/innodb/innodb_data_file | 255 | 220.91 ms | 22.47 ms | |
root | wait/io/file/sql/binlog | 436 | 162.44 ms | 20.24 ms | |
root | wait/io/file/sql/io_cache | 406 | 27.70 ms | 16.79 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 26.63 ms | 2.15 ms | |
root | wait/io/file/sql/misc | 5 | 622.93 us | 271.11 us | |
root | wait/io/file/sql/binlog_index | 2 | 6.56 us | 4.33 us |
|