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 | 1221 | 3189109796928 | 51387668640 | |
192.168.30.20 | wait/io/file/sql/binlog | 4671 | 2619454516800 | 61534179696 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 20 | 196603083072 | 36049510464 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 70 | 42045534960 | 3969533040 | |
192.168.30.20 | wait/io/file/myisam/kfile | 19 | 2080275648 | 636580032 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 948906288 | 581527056 | |
192.168.30.20 | wait/io/file/sql/misc | 38 | 545327904 | 34984224 | |
192.168.30.20 | wait/io/file/myisam/dfile | 17 | 399364416 | 222774288 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 33869088 | 10942800 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4813248 | 3029664 | |
background | wait/io/file/innodb/innodb_log_file | 6295 | 30931440199440 | 108282811296 | |
background | wait/io/file/innodb/innodb_data_file | 7137 | 13169430750432 | 758223855312 | |
background | wait/io/file/innodb/innodb_temp_file | 90 | 297782084160 | 19524872928 | |
background | wait/io/file/sql/binlog_index | 36 | 53307032064 | 30585015648 | |
background | wait/io/file/sql/binlog | 37 | 29571747216 | 15172046208 | |
background | wait/io/file/sql/casetest | 15 | 1313801808 | 1243717200 | |
background | wait/io/file/sql/ERRMSG | 5 | 1306606224 | 529914000 | |
background | wait/io/file/mysys/cnf | 5 | 621844608 | 598622112 | |
background | wait/io/file/mysys/charset | 3 | 225250080 | 205140144 | |
background | wait/io/file/sql/pid | 3 | 18029088 | 13862112 | |
background | wait/io/file/sql/misc | 1 | 4781568 | 4781568 |
|