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 | 462 | 1385390697504 | 2998680960 | 715886252400 | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 23 | 353364074448 | 15363655296 | 65778165024 | |
192.168.30.20 | wait/io/file/sql/binlog | 28 | 125432145696 | 4479719376 | 41839874736 | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 176 | 66976436736 | 380547816 | 5609708544 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 60 | 40378110960 | 672968472 | 12375832128 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 4 | 31463476176 | 7865868912 | 19656650640 | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 397199088 | 99299640 | 336513408 | |
192.168.30.20 | wait/io/file/csv/data | 2 | 221022384 | 110511192 | 214909728 | |
192.168.30.20 | wait/lock/table/sql/handler | 76 | 71460576 | 940104 | 3867600 | |
192.168.30.20 | wait/io/file/sql/misc | 1 | 10134432 | 10134432 | 10134432 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5082528 | 2541264 | 3355440 | |
background | wait/io/file/innodb/innodb_log_file | 277 | 2464238356272 | 8896167192 | 873237203520 | |
background | wait/io/file/innodb/innodb_data_file | 1595 | 877443153312 | 550121088 | 243183928416 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 377351074320 | 4658655144 | 31143157584 | |
background | wait/io/file/sql/binlog_index | 36 | 55255574880 | 1534876992 | 31897800000 | |
background | wait/io/file/sql/binlog | 37 | 38932873056 | 1052239584 | 22114464768 | |
background | wait/io/file/sql/ERRMSG | 5 | 1393214064 | 278642760 | 534676560 | |
background | wait/io/file/sql/casetest | 15 | 772857888 | 51523824 | 710686416 | |
background | wait/io/file/mysys/cnf | 5 | 693462528 | 138692400 | 670223136 | |
background | wait/io/file/mysys/charset | 3 | 236616336 | 78872112 | 226064256 | |
background | wait/io/file/sql/pid | 3 | 47994672 | 15998136 | 37599936 | |
background | wait/io/file/sql/misc | 1 | 9151296 | 9151296 | 9151296 |
|