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 | 539 | 820947332430 | 101839237120 | |
192.168.30.20 | wait/io/file/sql/binlog | 276 | 495042280670 | 29343488160 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 20 | 198052061550 | 30015163520 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 39170578560 | 3627172130 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1016411210 | 486174300 | |
192.168.30.20 | wait/io/file/csv/data | 11 | 826112590 | 531012300 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 718263420 | 700563010 | |
192.168.30.20 | wait/io/file/sql/misc | 5 | 74261480 | 26443290 | |
192.168.30.20 | wait/io/file/myisam/dfile | 2 | 7943110 | 7725810 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5160080 | 3184240 | |
background | wait/io/file/innodb/innodb_log_file | 1369 | 7243240090080 | 177760704150 | |
background | wait/io/file/innodb/innodb_data_file | 2755 | 3700709044350 | 286952272460 | |
background | wait/io/file/innodb/innodb_temp_file | 88 | 407586296440 | 57388033240 | |
background | wait/io/file/sql/binlog_index | 36 | 54220099220 | 31173199210 | |
background | wait/io/file/sql/binlog | 37 | 49101904590 | 23684783100 | |
background | wait/io/file/sql/ERRMSG | 5 | 2120085330 | 1287454800 | |
background | wait/io/file/mysys/cnf | 5 | 1789749580 | 1768181230 | |
background | wait/io/file/sql/casetest | 15 | 856729630 | 791938190 | |
background | wait/io/file/mysys/charset | 3 | 285010150 | 270070510 | |
background | wait/io/file/sql/pid | 3 | 63567670 | 37927860 | |
background | wait/io/file/sql/misc | 1 | 3313560 | 3313560 |
|