SELECT * FROM `x$waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 145 | 130965917808 | 903213168 | 35124104400 | |
192.168.30.20 | wait/io/table/sql/handler | 159 | 74519735136 | 468677352 | 66784184544 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 2 | 21241068288 | 10620534144 | 21195194592 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 20 | 10173166080 | 508658304 | 2189803440 | |
192.168.30.20 | wait/io/file/sql/binlog | 40 | 2086794336 | 52169832 | 1913970960 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 1630236432 | 407558976 | 1225922016 | |
192.168.30.20 | wait/io/file/sql/io_cache | 30 | 1258378176 | 41945904 | 656307168 | |
192.168.30.20 | wait/lock/table/sql/handler | 90 | 101826384 | 1131240 | 6302208 | |
192.168.30.20 | wait/io/file/csv/data | 2 | 42926400 | 21463200 | 30791376 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 12194688 | 6097344 | 10609104 | |
background | wait/io/file/innodb/innodb_log_file | 308 | 1780280887968 | 5780132688 | 162283831248 | |
background | wait/io/file/innodb/innodb_data_file | 1662 | 1103845484016 | 664166712 | 224570539248 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 386620991328 | 4773098616 | 37811261136 | |
background | wait/io/file/sql/binlog_index | 36 | 54814463616 | 1522623960 | 33632951088 | |
background | wait/io/file/sql/binlog | 37 | 40162537008 | 1085473752 | 19488955728 | |
background | wait/io/file/mysys/cnf | 5 | 2969337888 | 593867472 | 2936046432 | |
background | wait/io/file/sql/ERRMSG | 5 | 1379104320 | 275820864 | 540386352 | |
background | wait/io/file/sql/casetest | 15 | 1127330688 | 75155256 | 1065339792 | |
background | wait/io/file/mysys/charset | 3 | 332358048 | 110786016 | 318021264 | |
background | wait/io/file/sql/pid | 3 | 59897376 | 19965792 | 49323120 | |
background | wait/io/file/sql/misc | 1 | 13021008 | 13021008 | 13021008 |
|