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 | 44 | 460344478176 | 40708450992 | |
192.168.30.20 | wait/io/file/sql/binlog | 398 | 261426591360 | 34450987824 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 244 | 237982960512 | 23528240208 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 65 | 40852455600 | 3652443168 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 1509424224 | 1418429232 | |
192.168.30.20 | wait/io/file/csv/data | 16 | 286394064 | 209553696 | |
192.168.30.20 | wait/io/file/sql/misc | 6 | 150894480 | 55588368 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5363424 | 2964720 | |
background | wait/io/file/innodb/innodb_log_file | 740 | 4275488838720 | 72406413552 | |
background | wait/io/file/innodb/innodb_data_file | 2582 | 3607379983152 | 221447733936 | |
background | wait/io/file/innodb/innodb_temp_file | 105 | 427037262432 | 34079493888 | |
background | wait/io/file/sql/binlog_index | 36 | 54792241680 | 32425407168 | |
background | wait/io/file/sql/binlog | 37 | 39324470064 | 20914792800 | |
background | wait/io/file/mysys/cnf | 5 | 1287171072 | 1270249200 | |
background | wait/io/file/sql/ERRMSG | 5 | 1226343888 | 459146688 | |
background | wait/io/file/sql/casetest | 15 | 718568928 | 661350096 | |
background | wait/io/file/mysys/charset | 3 | 273280656 | 259898496 | |
background | wait/io/file/sql/pid | 3 | 54192864 | 39839184 | |
background | wait/io/file/sql/misc | 1 | 5801136 | 5801136 |
|