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_temp_file | 50 | 547682044272 | 10953640632 | 42518041632 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 486 | 372079863408 | 765596304 | 44834860224 | |
192.168.30.20 | wait/io/file/sql/binlog | 372 | 266278044384 | 715801152 | 37416358848 | |
192.168.30.20 | wait/io/file/sql/io_cache | 291 | 86491910208 | 297222816 | 74938409040 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 37712013504 | 685672944 | 2824118352 | |
192.168.30.20 | wait/io/table/sql/handler | 863 | 13180800864 | 15273192 | 2176791408 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2197926192 | 274740576 | 1292414112 | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 1809897936 | 113118456 | 674303520 | |
192.168.30.20 | wait/lock/table/sql/handler | 702 | 1341094128 | 1910304 | 166136256 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 665567760 | 166391808 | 602982336 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 254490720 | 127245360 | 252027600 | |
192.168.30.20 | wait/io/file/sql/misc | 4 | 94135536 | 23533752 | 34704384 | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 56456400 | 7056984 | 27806064 | |
background | wait/io/file/innodb/innodb_log_file | 919 | 5263139327952 | 5727028560 | 66252141648 | |
background | wait/io/file/innodb/innodb_data_file | 2674 | 3788942320416 | 1416956640 | 238437168816 | |
background | wait/io/file/innodb/innodb_temp_file | 228 | 461713221024 | 2025057936 | 91521852048 | |
background | wait/io/file/sql/binlog_index | 36 | 52944513072 | 1470680904 | 28980230400 | |
background | wait/io/file/sql/binlog | 37 | 35636374752 | 963145128 | 16196209920 | |
background | wait/io/file/sql/ERRMSG | 5 | 1272382848 | 254476464 | 512995296 | |
background | wait/io/file/sql/casetest | 15 | 721327728 | 48088392 | 650074656 | |
background | wait/io/file/mysys/cnf | 5 | 474758592 | 94951560 | 456456528 | |
background | wait/io/file/mysys/charset | 3 | 285612624 | 95204208 | 270948480 | |
background | wait/io/file/sql/pid | 3 | 68445168 | 22814880 | 50582928 | |
background | wait/io/file/sql/misc | 1 | 13080672 | 13080672 | 13080672 |
|