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 | 476 | 1265000681472 | 2657564448 | 38570247936 | |
192.168.30.20 | wait/io/file/sql/binlog | 269 | 580418954016 | 2157691272 | 66347927184 | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 2 | 497982710016 | 248991355008 | 282531620448 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 26 | 235390140480 | 9053466840 | 34892152416 | |
192.168.30.20 | wait/io/table/sql/handler | 5170 | 45256294512 | 8753448 | 4381856688 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 43211701104 | 785667168 | 4249766400 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 5150855424 | 643856928 | 2642041776 | |
192.168.30.20 | wait/io/file/csv/data | 14 | 713247744 | 50946192 | 506541024 | |
192.168.30.20 | wait/lock/table/sql/handler | 541 | 583406208 | 1078176 | 15640944 | |
192.168.30.20 | wait/io/file/sql/misc | 8 | 213985728 | 26748216 | 94815072 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4784736 | 2392368 | 3277296 | |
background | wait/io/file/innodb/innodb_log_file | 1992 | 10221389653200 | 5131219632 | 66437238384 | |
background | wait/io/file/innodb/innodb_data_file | 2894 | 4648421924784 | 1606227216 | 217593405744 | |
background | wait/io/file/innodb/innodb_temp_file | 107 | 362384968176 | 3386775216 | 33527063856 | |
background | wait/lock/metadata/sql/mdl | 2 | 251486082144 | 125743041072 | 251456102832 | |
background | wait/io/file/sql/binlog_index | 36 | 48165156864 | 1337920848 | 27611765808 | |
background | wait/io/file/sql/binlog | 37 | 39708850368 | 1073212008 | 18815379792 | |
background | wait/io/file/sql/ERRMSG | 5 | 1242048720 | 248409744 | 444703776 | |
background | wait/io/file/mysys/cnf | 5 | 1104762384 | 220952424 | 1088533776 | |
background | wait/io/file/sql/casetest | 15 | 1044427824 | 69628416 | 979311168 | |
background | wait/io/file/mysys/charset | 3 | 189065184 | 63021552 | 172223040 | |
background | wait/io/file/sql/pid | 3 | 65158368 | 21719280 | 40934784 | |
background | wait/io/file/sql/misc | 1 | 13292400 | 13292400 | 13292400 |
|