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 | 185 | 56337209280 | 2230466304 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 6 | 52821230352 | 19384507296 | |
192.168.30.20 | wait/io/file/sql/binlog | 202 | 29673438960 | 22624848048 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 28477333632 | 2431143264 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 1318728576 | 1035302928 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 545467824 | 545467824 | |
192.168.30.20 | wait/io/file/csv/data | 2 | 43269600 | 30068016 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4482720 | 2867568 | |
background | wait/io/file/innodb/innodb_log_file | 441 | 2194328332416 | 69460488768 | |
background | wait/io/file/innodb/innodb_data_file | 1961 | 1664978070624 | 236989496832 | |
background | wait/io/file/innodb/innodb_temp_file | 83 | 372569788800 | 28895705520 | |
background | wait/io/file/sql/binlog_index | 36 | 52514602800 | 32431751616 | |
background | wait/io/file/sql/binlog | 37 | 35869022640 | 17042975664 | |
background | wait/io/file/mysys/cnf | 5 | 1484811504 | 1459366656 | |
background | wait/io/file/sql/casetest | 15 | 1296065760 | 1223740848 | |
background | wait/io/file/sql/ERRMSG | 5 | 1245299088 | 477199008 | |
background | wait/io/file/mysys/charset | 3 | 340026192 | 320246784 | |
background | wait/io/file/sql/pid | 3 | 47488848 | 37332240 | |
background | wait/io/file/sql/misc | 1 | 13064304 | 13064304 |
|