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 | 330 | 87056363328 | 6229020864 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 25 | 18487719360 | 4001895744 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 2 | 15827416176 | 15777628944 | |
192.168.30.20 | wait/io/file/sql/binlog | 24 | 2027061168 | 1906698816 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1249043664 | 717032976 | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 814141152 | 788288688 | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 314023248 | 291816096 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 312106080 | 279365328 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5207664 | 3407184 | |
background | wait/io/file/innodb/innodb_log_file | 451 | 2484317475552 | 116198231952 | |
background | wait/io/file/innodb/innodb_data_file | 1875 | 1154881277088 | 234395839392 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 400482308688 | 32882566464 | |
background | wait/io/file/sql/binlog_index | 36 | 58510163712 | 35547195024 | |
background | wait/io/file/sql/binlog | 37 | 40720473552 | 20914536192 | |
background | wait/io/file/sql/ERRMSG | 5 | 1242099408 | 419447952 | |
background | wait/io/file/sql/casetest | 15 | 1115546784 | 1050804480 | |
background | wait/io/file/mysys/cnf | 5 | 575300880 | 559230144 | |
background | wait/io/file/mysys/charset | 3 | 297092400 | 281397600 | |
background | wait/io/file/sql/pid | 3 | 44132352 | 34663728 | |
background | wait/io/file/sql/misc | 1 | 6831264 | 6831264 |
|