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_data_file | 2599 | 10.29 s | 3.96 ms | 60.19 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 1423 | 3.80 s | 2.67 ms | 59.37 ms | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 17 | 2.88 s | 169.41 ms | 870.39 ms | |
192.168.30.20 | wait/io/table/sql/handler | 6855 | 487.55 ms | 71.12 us | 108.90 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 76 | 416.61 ms | 5.48 ms | 36.90 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 910 | 171.61 ms | 188.58 us | 69.17 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 75 | 85.79 ms | 1.14 ms | 14.51 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 2933 | 74.50 ms | 25.40 us | 50.26 ms | |
192.168.30.20 | wait/io/file/myisam/dfile | 850 | 29.71 ms | 34.95 us | 20.04 ms | |
192.168.30.20 | wait/io/file/sql/SDI | 800 | 25.56 ms | 31.95 us | 1.86 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 2519 | 2.75 ms | 1.09 us | 16.09 us | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 788.94 us | 98.62 us | 372.77 us | |
192.168.30.20 | wait/io/file/sql/misc | 16 | 256.34 us | 16.02 us | 49.70 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 251.28 us | 62.82 us | 212.20 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 12.02 us | 6.01 us | 10.18 us | |
background | wait/io/file/innodb/innodb_log_file | 15616 | 59.22 s | 3.79 ms | 199.28 ms | |
background | wait/io/file/innodb/innodb_data_file | 9584 | 14.05 s | 1.47 ms | 343.76 ms | |
background | wait/lock/metadata/sql/mdl | 9 | 1.79 s | 199.37 ms | 532.85 ms | |
background | wait/io/file/innodb/innodb_temp_file | 766 | 591.01 ms | 771.55 us | 43.33 ms | |
background | wait/io/file/sql/binlog_index | 36 | 86.13 ms | 2.39 ms | 43.05 ms | |
background | wait/io/file/sql/binlog | 37 | 73.26 ms | 1.98 ms | 41.52 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 7.14 ms | 1.43 ms | 5.95 ms | |
background | wait/io/file/mysys/cnf | 5 | 3.08 ms | 616.78 us | 3.06 ms | |
background | wait/io/file/sql/casetest | 15 | 876.67 us | 58.44 us | 775.93 us | |
background | wait/io/file/mysys/charset | 3 | 320.63 us | 106.88 us | 289.53 us |
|