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 | 465 | 229806498768 | 25311449856 | |
192.168.30.20 | wait/io/file/sql/binlog | 744 | 94880383488 | 19630806624 | |
192.168.30.20 | wait/io/file/sql/io_cache | 52 | 71845831728 | 68819972496 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 8 | 65998088112 | 22284514560 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 44697120864 | 5960653248 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 229032144 | 197698512 | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 36700224 | 14229072 | |
192.168.30.20 | wait/io/file/myisam/dfile | 2 | 5775264 | 5464272 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5207136 | 3428832 | |
background | wait/io/file/innodb/innodb_log_file | 617 | 4004857702560 | 461783247552 | |
background | wait/io/file/innodb/innodb_data_file | 2173 | 2894959209120 | 250014560928 | |
background | wait/io/file/innodb/innodb_temp_file | 90 | 400687684320 | 27479858208 | |
background | wait/io/file/sql/binlog_index | 36 | 49031886816 | 30243192144 | |
background | wait/io/file/sql/binlog | 37 | 35683566336 | 19257524352 | |
background | wait/io/file/mysys/cnf | 5 | 2075101248 | 2053369824 | |
background | wait/io/file/sql/ERRMSG | 5 | 1451402304 | 545018496 | |
background | wait/io/file/sql/casetest | 15 | 796121568 | 711903984 | |
background | wait/io/file/mysys/charset | 3 | 273689856 | 262362144 | |
background | wait/io/file/sql/pid | 3 | 55093632 | 40372464 | |
background | wait/io/file/sql/misc | 1 | 15127200 | 15127200 |
|