SELECT * FROM `host_summary_by_file_io_type`
|
host | event_name | total | total_latency | max_latency | |
---|---|---|---|---|---|
192.168.30.20 | wait/io/file/sql/binlog | 380 | 452.32 ms | 35.79 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 554 | 162.55 ms | 17.81 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 6 | 63.82 ms | 24.31 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 31.65 ms | 4.45 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 9 | 2.36 ms | 1.49 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1.65 ms | 580.46 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 9 | 380.71 us | 266.39 us | |
192.168.30.20 | wait/io/file/csv/data | 10 | 104.65 us | 39.13 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.90 us | 2.79 us | |
background | wait/io/file/innodb/innodb_log_file | 1871 | 8.43 s | 197.51 ms | |
background | wait/io/file/innodb/innodb_data_file | 2716 | 3.06 s | 242.47 ms | |
background | wait/io/file/innodb/innodb_temp_file | 83 | 379.37 ms | 30.21 ms | |
background | wait/io/file/sql/binlog_index | 36 | 60.65 ms | 40.56 ms | |
background | wait/io/file/sql/binlog | 37 | 42.88 ms | 23.58 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.17 ms | 478.66 us | |
background | wait/io/file/sql/casetest | 15 | 731.47 us | 663.50 us | |
background | wait/io/file/mysys/cnf | 5 | 467.78 us | 452.01 us | |
background | wait/io/file/mysys/charset | 3 | 270.75 us | 251.07 us | |
background | wait/io/file/sql/pid | 3 | 47.90 us | 37.78 us | |
background | wait/io/file/sql/misc | 1 | 12.47 us | 12.47 us |
|