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 | 36 | 352771258752 | 37666927056 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 502 | 172533540960 | 21946186416 | |
192.168.30.20 | wait/io/file/sql/binlog | 124 | 124234922064 | 18948885120 | |
192.168.30.20 | wait/io/file/sql/io_cache | 976 | 96219250512 | 28367353344 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 31468842240 | 4001895744 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1249043664 | 717032976 | |
192.168.30.20 | wait/io/file/csv/data | 13 | 1209024960 | 851699904 | |
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/sql/misc | 5 | 310424400 | 251651664 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5207664 | 3407184 | |
background | wait/io/file/innodb/innodb_log_file | 2792 | 14715434309136 | 116198231952 | |
background | wait/io/file/innodb/innodb_data_file | 5078 | 5543948301936 | 234395839392 | |
background | wait/io/file/innodb/innodb_temp_file | 658 | 1134209817840 | 658381239120 | |
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 |
|