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 | 221 | 173.70 ms | 30.25 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 146 | 86.38 ms | 24.02 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 29.74 ms | 2.77 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 12 | 6.52 ms | 5.23 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 3.68 ms | 2.42 ms | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 224.71 us | 155.44 us | |
192.168.30.20 | wait/io/file/csv/data | 6 | 77.30 us | 32.73 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 6 | 47.77 us | 23.13 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.91 us | 3.06 us | |
background | wait/io/file/innodb/innodb_log_file | 457 | 2.51 s | 105.87 ms | |
background | wait/io/file/innodb/innodb_data_file | 2023 | 1.96 s | 251.77 ms | |
background | wait/io/file/innodb/innodb_temp_file | 80 | 387.17 ms | 32.06 ms | |
background | wait/io/file/sql/binlog_index | 36 | 58.55 ms | 29.17 ms | |
background | wait/io/file/sql/binlog | 37 | 39.98 ms | 21.68 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.13 ms | 487.27 us | |
background | wait/io/file/mysys/cnf | 5 | 980.29 us | 955.26 us | |
background | wait/io/file/sql/casetest | 15 | 818.84 us | 740.49 us | |
background | wait/io/file/mysys/charset | 3 | 282.03 us | 262.71 us | |
background | wait/io/file/sql/pid | 3 | 50.02 us | 32.22 us | |
background | wait/io/file/sql/misc | 1 | 4.94 us | 4.94 us |
|