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 | 933 | 1648383766128 | 1766756376 | 105740748432 | |
192.168.30.20 | wait/io/file/sql/binlog | 785 | 1570468404384 | 2000596488 | 28630096176 | |
192.168.30.20 | wait/io/table/sql/handler | 281999 | 737674234704 | 2615712 | 105818381856 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 42 | 460873845168 | 10973186664 | 107473396272 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 85 | 69907129776 | 822436560 | 6354713376 | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 2 | 28637394720 | 14318697360 | 27993889968 | |
192.168.30.20 | wait/io/file/myisam/dfile | 8447 | 11323936272 | 1340328 | 5570260080 | |
192.168.30.20 | wait/io/file/sql/io_cache | 204 | 5665112640 | 27770160 | 1325993328 | |
192.168.30.20 | wait/io/file/myisam/kfile | 183 | 4965646752 | 27134448 | 1235376912 | |
192.168.30.20 | wait/io/file/sql/misc | 21 | 2792767824 | 132988944 | 2018942640 | |
192.168.30.20 | wait/io/file/sql/SDI | 33 | 1976946048 | 59907408 | 533228256 | |
192.168.30.20 | wait/lock/table/sql/handler | 1505 | 1846246512 | 1226544 | 25344528 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 724485696 | 90560712 | 387658128 | |
192.168.30.20 | wait/io/file/csv/data | 15 | 495368544 | 33024552 | 415276752 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 6012864 | 3006432 | 3936768 | |
background | wait/io/file/innodb/innodb_log_file | 2933 | 17161277661792 | 5851100376 | 213675444048 | |
background | wait/io/file/innodb/innodb_data_file | 5355 | 10476756528480 | 1956443544 | 213384328608 | |
background | wait/io/file/innodb/innodb_temp_file | 273 | 393128637792 | 1440031560 | 32209064976 | |
background | wait/io/file/sql/binlog_index | 36 | 63674849568 | 1768745616 | 44336284080 | |
background | wait/io/file/sql/binlog | 37 | 33799236768 | 913492800 | 16069610304 | |
background | wait/io/file/sql/ERRMSG | 5 | 1419778272 | 283955496 | 544420800 | |
background | wait/io/file/sql/casetest | 15 | 801702528 | 53446800 | 734592672 | |
background | wait/io/file/mysys/cnf | 5 | 562605648 | 112521024 | 546815280 | |
background | wait/io/file/mysys/charset | 3 | 278735952 | 92911896 | 267215520 | |
background | wait/io/file/sql/pid | 3 | 46019952 | 15339984 | 36588816 |
|