SELECT * FROM `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 | 90 | 851.25 ms | 9.46 ms | 29.24 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 528 | 163.87 ms | 310.36 us | 30.98 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 417 | 110.83 ms | 265.78 us | 14.13 ms | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 3 | 110.45 ms | 36.82 ms | 58.81 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 604 | 96.79 ms | 160.25 us | 32.23 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 27.71 ms | 615.88 us | 2.82 ms | |
192.168.30.20 | wait/io/table/sql/handler | 1554 | 21.10 ms | 13.58 us | 5.97 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 9.77 ms | 610.84 us | 6.90 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 424 | 481.91 us | 1.14 us | 14.69 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 179.58 us | 89.79 us | 177.98 us | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 91.25 us | 30.42 us | 68.48 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 8 | 77.87 us | 9.73 us | 30.19 us | |
background | wait/io/file/innodb/innodb_log_file | 508 | 2.96 s | 5.82 ms | 75.71 ms | |
background | wait/io/file/innodb/innodb_data_file | 2077 | 2.76 s | 1.33 ms | 269.02 ms | |
background | wait/io/file/innodb/innodb_temp_file | 300 | 469.24 ms | 1.56 ms | 157.46 ms | |
background | wait/io/file/sql/binlog_index | 36 | 44.53 ms | 1.24 ms | 26.92 ms | |
background | wait/io/file/sql/binlog | 37 | 39.60 ms | 1.07 ms | 26.01 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.27 ms | 254.51 us | 422.30 us | |
background | wait/io/file/sql/casetest | 15 | 777.30 us | 51.82 us | 703.95 us | |
background | wait/io/file/mysys/cnf | 5 | 615.34 us | 123.07 us | 592.40 us | |
background | wait/io/file/mysys/charset | 3 | 252.37 us | 84.12 us | 239.02 us | |
background | wait/io/file/sql/pid | 3 | 23.30 us | 7.77 us | 13.53 us | |
background | wait/io/file/sql/misc | 1 | 2.74 us | 2.74 us | 2.74 us |
|