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_temp_file | 20 | 253.84 ms | 54.69 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 193 | 52.30 ms | 4.11 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 25 | 15.09 ms | 2.52 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 3.38 ms | 1.91 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 60 | 2.74 ms | 1.75 ms | |
192.168.30.20 | wait/io/file/csv/data | 2 | 18.08 us | 11.59 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.00 us | 3.15 us | |
background | wait/io/file/innodb/innodb_log_file | 385 | 1.85 s | 31.70 ms | |
background | wait/io/file/innodb/innodb_data_file | 1925 | 1.47 s | 195.97 ms | |
background | wait/io/file/innodb/innodb_temp_file | 245 | 835.67 ms | 283.30 ms | |
background | wait/io/file/sql/binlog_index | 36 | 55.33 ms | 28.89 ms | |
background | wait/io/file/sql/binlog | 37 | 36.50 ms | 20.12 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.26 ms | 413.38 us | |
background | wait/io/file/sql/casetest | 15 | 895.85 us | 813.22 us | |
background | wait/io/file/mysys/cnf | 5 | 423.62 us | 405.87 us | |
background | wait/io/file/mysys/charset | 3 | 305.53 us | 288.99 us | |
background | wait/io/file/sql/pid | 3 | 12.03 us | 9.71 us | |
background | wait/io/file/sql/misc | 1 | 4.78 us | 4.78 us |
|