SELECT * FROM `x$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 | 649 | 1478174335440 | 45530987568 | |
192.168.30.20 | wait/io/file/sql/binlog | 208 | 509000073120 | 28611997392 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 20 | 175184394000 | 21607058880 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 50 | 27107210064 | 4210302096 | |
192.168.30.20 | wait/io/file/sql/io_cache | 38 | 2156244288 | 1234757040 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 1185037392 | 1182945456 | |
192.168.30.20 | wait/io/file/sql/misc | 4 | 707083872 | 411104496 | |
background | wait/io/file/innodb/innodb_log_file | 1984 | 10175626084272 | 101935124544 | |
background | wait/io/file/innodb/innodb_data_file | 3046 | 4245430894320 | 247828061712 | |
background | wait/io/file/innodb/innodb_temp_file | 129 | 414373414224 | 42082922640 | |
background | wait/io/file/sql/binlog_index | 36 | 55396661760 | 35810654352 | |
background | wait/io/file/sql/binlog | 37 | 33153790560 | 17249311728 | |
background | wait/io/file/sql/ERRMSG | 5 | 1182747984 | 482896656 | |
background | wait/io/file/mysys/cnf | 5 | 922050096 | 905268672 | |
background | wait/io/file/sql/casetest | 15 | 717402576 | 659876976 | |
background | wait/io/file/mysys/charset | 3 | 268474800 | 255227280 | |
background | wait/io/file/sql/pid | 3 | 14660448 | 11764368 | |
background | wait/io/file/sql/misc | 1 | 13143504 | 13143504 |
|