SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 585 | 3.86 s | 419.34 ms | |
background | wait/io/file/innodb/innodb_data_file | 2199 | 3.13 s | 200.60 ms | |
background | wait/io/file/innodb/innodb_temp_file | 301 | 496.23 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 | 72 | 1.25 s | 411.91 ms | |
root | wait/io/file/innodb/innodb_data_file | 327 | 241.40 ms | 22.47 ms | |
root | wait/io/file/sql/binlog | 464 | 162.58 ms | 20.24 ms | |
root | wait/io/file/sql/io_cache | 480 | 29.07 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 |
|