SELECT * FROM `x$waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/table/sql/handler | 1868595 | 1432543149312 | 766392 | 66784184544 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 104 | 1070133970224 | 10289749536 | 210583685136 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 667 | 301900739712 | 452624568 | 35124104400 | |
192.168.30.20 | wait/io/file/sql/io_cache | 996 | 45164779968 | 45345960 | 15745989072 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 65 | 37418048976 | 575662032 | 2189803440 | |
192.168.30.20 | wait/io/file/sql/binlog | 452 | 7302189312 | 16155216 | 1913970960 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2268563088 | 283570320 | 1225922016 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 1995569136 | 124722840 | 601094736 | |
192.168.30.20 | wait/lock/table/sql/handler | 832 | 1203839472 | 1446720 | 358143456 | |
192.168.30.20 | wait/io/file/csv/data | 13 | 453690336 | 34899216 | 340529376 | |
192.168.30.20 | wait/io/file/myisam/dfile | 9 | 87269952 | 9696456 | 29321952 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 12194688 | 6097344 | 10609104 | |
background | wait/io/file/innodb/innodb_log_file | 1426 | 7615763916816 | 5340647664 | 162283831248 | |
background | wait/io/file/innodb/innodb_data_file | 3362 | 4491126895728 | 1335849504 | 224570539248 | |
background | wait/io/file/innodb/innodb_temp_file | 640 | 416171357184 | 650267640 | 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 |
|