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 | 484 | 132.93 ms | 3.56 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 15.57 ms | 3.89 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 8.17 ms | 5.75 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 3.20 ms | 2.31 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 112 | 580.18 us | 27.13 us | |
192.168.30.20 | wait/io/file/csv/data | 25 | 370.67 us | 142.32 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 39 | 334.03 us | 270.28 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.65 us | 3.05 us | |
background | wait/io/file/innodb/innodb_log_file | 781 | 4.51 s | 117.14 ms | |
background | wait/io/file/innodb/innodb_data_file | 2300 | 3.10 s | 224.41 ms | |
background | wait/io/file/innodb/innodb_temp_file | 80 | 384.25 ms | 31.65 ms | |
background | wait/io/file/sql/binlog_index | 36 | 55.19 ms | 29.42 ms | |
background | wait/io/file/sql/binlog | 37 | 40.50 ms | 23.02 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.33 ms | 561.37 us | |
background | wait/io/file/mysys/cnf | 5 | 1.10 ms | 1.08 ms | |
background | wait/io/file/sql/casetest | 15 | 836.29 us | 755.94 us | |
background | wait/io/file/mysys/charset | 3 | 333.86 us | 318.01 us | |
background | wait/io/file/sql/pid | 3 | 56.95 us | 36.71 us | |
background | wait/io/file/sql/misc | 1 | 12.81 us | 12.81 us |
|