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 | 499 | 1549115439168 | 3104439624 | 793615210608 | |
192.168.30.20 | wait/io/file/sql/binlog | 1222 | 1028866505568 | 841952760 | 34704849696 | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 26 | 236820944448 | 9108497640 | 29320161552 | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 75 | 57384650400 | 765128496 | 3815955264 | |
192.168.30.20 | wait/io/table/sql/handler | 2444 | 51706904304 | 21156432 | 6107153712 | |
192.168.30.20 | wait/io/file/myisam/kfile | 12 | 3233929776 | 269494104 | 2376409200 | |
192.168.30.20 | wait/io/file/myisam/dfile | 117 | 2888691168 | 24689544 | 1998775152 | |
192.168.30.20 | wait/lock/table/sql/handler | 1190 | 1536065520 | 1290696 | 14773968 | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 913074096 | 114134064 | 543631440 | |
192.168.30.20 | wait/io/file/sql/misc | 6 | 784246848 | 130707720 | 667332864 | |
192.168.30.20 | wait/io/file/csv/data | 4 | 33719136 | 8429784 | 14346816 | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4950000 | 2475000 | 3264624 | |
background | wait/io/file/innodb/innodb_log_file | 1750 | 9683952320592 | 5533686840 | 89332613040 | |
background | wait/io/file/innodb/innodb_data_file | 3499 | 6102244226496 | 1743996408 | 202219958688 | |
background | wait/io/file/innodb/innodb_temp_file | 96 | 300494418048 | 3130150056 | 19701543312 | |
background | wait/io/file/sql/binlog_index | 36 | 75441505392 | 2095597152 | 37931873232 | |
background | wait/io/file/sql/binlog | 37 | 38443503648 | 1039013448 | 19659028224 | |
background | wait/io/file/sql/ERRMSG | 5 | 1294938480 | 258987696 | 421593744 | |
background | wait/io/file/mysys/cnf | 5 | 1056267168 | 211253328 | 1037219040 | |
background | wait/io/file/sql/casetest | 15 | 909359088 | 60623904 | 847976976 | |
background | wait/io/file/mysys/charset | 3 | 346492080 | 115497360 | 333808992 | |
background | wait/io/file/sql/pid | 3 | 14447664 | 4815888 | 11730048 | |
background | wait/io/file/sql/misc | 1 | 4651152 | 4651152 | 4651152 |
|