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 | 369 | 226.14 ms | 34.89 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 24 | 215.76 ms | 30.06 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 132 | 101.80 ms | 26.98 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 40 | 45.15 ms | 10.24 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 828.58 us | 452.21 us | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 307.35 us | 307.35 us | |
192.168.30.20 | wait/io/file/csv/data | 9 | 74.52 us | 16.69 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.18 us | 3.26 us | |
background | wait/io/file/innodb/innodb_log_file | 662 | 3.88 s | 48.74 ms | |
background | wait/io/file/innodb/innodb_data_file | 2398 | 3.71 s | 233.94 ms | |
background | wait/io/file/innodb/innodb_temp_file | 91 | 337.26 ms | 26.99 ms | |
background | wait/io/file/sql/binlog_index | 36 | 47.35 ms | 27.80 ms | |
background | wait/io/file/sql/binlog | 37 | 32.12 ms | 16.25 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.31 ms | 535.60 us | |
background | wait/io/file/sql/casetest | 15 | 831.16 us | 762.65 us | |
background | wait/io/file/mysys/cnf | 5 | 401.15 us | 368.37 us | |
background | wait/io/file/mysys/charset | 3 | 226.88 us | 210.25 us | |
background | wait/io/file/sql/pid | 3 | 20.55 us | 16.57 us | |
background | wait/io/file/sql/misc | 1 | 5.97 us | 5.97 us |
|