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 | 517 | 525.69 ms | 30.25 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 450 | 385.58 ms | 25.49 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 10 | 86.25 ms | 20.62 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 38.29 ms | 2.77 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 7.93 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 | 8 | 346.11 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 | 8 | 77.05 us | 28.14 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 | 1412 | 7.82 s | 105.87 ms | |
background | wait/io/file/innodb/innodb_data_file | 3523 | 5.50 s | 251.77 ms | |
background | wait/io/file/innodb/innodb_temp_file | 85 | 387.50 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 |
|