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_data_file | 551 | 1.85 s | 922.96 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 38 | 560.48 ms | 225.84 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 275 | 519.27 ms | 23.60 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 118.71 ms | 72.66 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 459 | 63.09 ms | 25.50 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 11.12 ms | 10.10 ms | |
192.168.30.20 | wait/io/file/myisam/dfile | 7911 | 7.39 ms | 2.20 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 2.31 ms | 1.44 ms | |
192.168.30.20 | wait/io/file/csv/data | 4 | 1.67 ms | 1.64 ms | |
192.168.30.20 | wait/io/file/sql/misc | 12 | 374.33 us | 177.10 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 153.68 us | 151.80 us | |
background | wait/io/file/innodb/innodb_log_file | 1665 | 9.89 s | 1.06 s | |
background | wait/io/file/innodb/innodb_data_file | 3431 | 6.35 s | 793.02 ms | |
background | wait/io/file/innodb/innodb_temp_file | 564 | 328.85 ms | 36.31 ms | |
background | wait/io/file/sql/binlog_index | 36 | 44.80 ms | 29.26 ms | |
background | wait/io/file/sql/binlog | 37 | 28.48 ms | 15.25 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.34 ms | 504.15 us | |
background | wait/io/file/mysys/cnf | 5 | 1.03 ms | 999.54 us | |
background | wait/io/file/sql/casetest | 15 | 730.67 us | 661.42 us | |
background | wait/io/file/mysys/charset | 3 | 246.79 us | 231.69 us | |
background | wait/io/file/sql/pid | 3 | 16.17 us | 10.99 us | |
background | wait/io/file/sql/misc | 1 | 5.13 us | 5.13 us |
|