SELECT * FROM `host_summary_by_file_io_type`
|
host | event_name | total | total_latency | max_latency | |
---|---|---|---|---|---|
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 52 | 570.61 ms | 42.28 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 562 | 356.04 ms | 195.59 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 312 | 101.51 ms | 9.34 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 362 | 53.10 ms | 19.12 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 28.50 ms | 2.82 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 1.88 ms | 1.77 ms | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 40.91 us | 14.54 us | |
192.168.30.20 | wait/io/file/csv/data | 2 | 29.14 us | 22.68 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 7.03 us | 4.55 us | |
background | wait/io/file/innodb/innodb_log_file | 463 | 3.24 s | 211.84 ms | |
background | wait/io/file/innodb/innodb_data_file | 1958 | 2.26 s | 152.42 ms | |
background | wait/io/file/innodb/innodb_temp_file | 311 | 791.30 ms | 470.80 ms | |
background | wait/io/file/sql/binlog_index | 36 | 51.38 ms | 36.01 ms | |
background | wait/io/file/sql/binlog | 37 | 29.31 ms | 15.60 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.19 ms | 518.18 us | |
background | wait/io/file/mysys/cnf | 5 | 1.18 ms | 1.16 ms | |
background | wait/io/file/sql/casetest | 15 | 987.53 us | 887.42 us | |
background | wait/io/file/mysys/charset | 3 | 483.99 us | 462.34 us | |
background | wait/io/file/sql/pid | 3 | 18.49 us | 11.83 us | |
background | wait/io/file/sql/misc | 1 | 4.68 us | 4.68 us |
|