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_temp_file | 110 | 1079233254270 | 50358433360 | |
192.168.30.20 | wait/io/file/sql/binlog | 638 | 1006570983550 | 24965003930 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 759 | 965957333710 | 39136972850 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 70 | 48464110540 | 4914132440 | |
192.168.30.20 | wait/io/file/myisam/kfile | 9 | 2281449130 | 1812070530 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1912088420 | 646862880 | |
192.168.30.20 | wait/io/file/myisam/dfile | 33 | 1283031420 | 634869510 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 495522440 | 410407090 | |
192.168.30.20 | wait/io/file/sql/misc | 8 | 90883870 | 22108950 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4251660 | 2368570 | |
background | wait/io/file/innodb/innodb_log_file | 3103 | 14224800528930 | 351821772450 | |
background | wait/io/file/innodb/innodb_data_file | 3734 | 5517821324960 | 214812562130 | |
background | wait/io/file/innodb/innodb_temp_file | 144 | 344158995880 | 29846131680 | |
background | wait/io/file/sql/binlog_index | 36 | 53620123320 | 34403962610 | |
background | wait/io/file/sql/binlog | 37 | 32329762560 | 14934225520 | |
background | wait/io/file/sql/ERRMSG | 5 | 1786259530 | 694573480 | |
background | wait/io/file/sql/casetest | 15 | 934076770 | 872332300 | |
background | wait/io/file/mysys/cnf | 5 | 827676620 | 801718280 | |
background | wait/io/file/mysys/charset | 3 | 314239120 | 300212670 | |
background | wait/io/file/sql/pid | 3 | 41736970 | 33211390 | |
background | wait/io/file/sql/misc | 1 | 5005850 | 5005850 |
|