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 | 332 | 138.79 ms | 21.52 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 1348 | 116.67 ms | 22.61 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 10 | 111.52 ms | 29.43 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 70 | 37.51 ms | 3.35 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 2.05 ms | 655.13 us | |
192.168.30.20 | wait/io/file/sql/io_cache | 50 | 884.88 us | 68.92 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 35.46 us | 9.70 us | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 25.62 us | 25.62 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 12.89 us | 11.47 us | |
background | wait/io/file/innodb/innodb_log_file | 529 | 2.83 s | 29.56 ms | |
background | wait/io/file/innodb/innodb_data_file | 2239 | 2.52 s | 235.99 ms | |
background | wait/io/file/innodb/innodb_temp_file | 88 | 385.37 ms | 31.55 ms | |
background | wait/io/file/sql/binlog_index | 36 | 45.77 ms | 26.50 ms | |
background | wait/io/file/sql/binlog | 37 | 36.37 ms | 16.78 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.11 ms | 435.27 us | |
background | wait/io/file/sql/casetest | 15 | 713.74 us | 648.13 us | |
background | wait/io/file/mysys/cnf | 5 | 570.63 us | 553.92 us | |
background | wait/io/file/mysys/charset | 3 | 280.13 us | 262.16 us | |
background | wait/io/file/sql/pid | 3 | 42.04 us | 27.42 us | |
background | wait/io/file/sql/misc | 1 | 12.77 us | 12.77 us |
|