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 | 589 | 788.89 ms | 84.24 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 74 | 743.02 ms | 32.68 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 572 | 397.24 ms | 41.05 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 331 | 113.46 ms | 94.12 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 40.08 ms | 4.72 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1.42 ms | 796.12 us | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 754.29 us | 737.84 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 681.47 us | 634.97 us | |
192.168.30.20 | wait/io/file/sql/misc | 10 | 122.05 us | 30.83 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 6.10 us | 3.56 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 2 | 6.06 us | 5.69 us | |
background | wait/io/file/innodb/innodb_log_file | 1529 | 8.48 s | 54.66 ms | |
background | wait/io/file/innodb/innodb_data_file | 3304 | 6.84 s | 790.19 ms | |
background | wait/io/file/innodb/innodb_temp_file | 151 | 464.73 ms | 38.04 ms | |
background | wait/io/file/sql/binlog_index | 36 | 67.10 ms | 45.20 ms | |
background | wait/io/file/sql/binlog | 37 | 58.42 ms | 35.28 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.13 ms | 460.55 us | |
background | wait/io/file/mysys/cnf | 5 | 1.12 ms | 1.10 ms | |
background | wait/io/file/sql/casetest | 15 | 896.27 us | 823.65 us | |
background | wait/io/file/mysys/charset | 3 | 307.04 us | 294.58 us | |
background | wait/io/file/sql/pid | 3 | 66.07 us | 40.68 us | |
background | wait/io/file/sql/misc | 1 | 13.83 us | 13.83 us |
|