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 | 560 | 786.04 ms | 1.40 ms | 39.64 ms | |
192.168.30.20 | wait/io/table/sql/handler | 981431 | 515.66 ms | 525.36 ns | 3.04 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 450 | 512.14 ms | 1.14 ms | 28.57 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 10 | 135.43 ms | 13.54 ms | 37.99 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 70 | 47.50 ms | 678.59 us | 3.23 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 10.53 ms | 1.32 ms | 8.98 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 6.92 ms | 432.20 us | 3.28 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 88 | 5.88 ms | 66.81 us | 1.99 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 638 | 692.85 us | 1.09 us | 15.20 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 676.40 us | 169.10 us | 540.29 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 245.97 us | 122.98 us | 244.38 us | |
192.168.30.20 | wait/io/file/sql/misc | 13 | 180.15 us | 13.86 us | 27.83 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 9 | 97.62 us | 10.85 us | 33.64 us | |
background | wait/io/file/innodb/innodb_log_file | 1835 | 11.48 s | 6.26 ms | 391.68 ms | |
background | wait/io/file/innodb/innodb_data_file | 3937 | 7.72 s | 1.96 ms | 263.97 ms | |
background | wait/io/file/innodb/innodb_temp_file | 85 | 383.69 ms | 4.51 ms | 41.70 ms | |
background | wait/io/file/sql/binlog_index | 36 | 60.04 ms | 1.67 ms | 39.94 ms | |
background | wait/io/file/sql/binlog | 37 | 34.76 ms | 939.59 us | 16.12 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.27 ms | 253.77 us | 423.16 us | |
background | wait/io/file/sql/casetest | 15 | 752.45 us | 50.16 us | 672.58 us | |
background | wait/io/file/mysys/cnf | 5 | 655.03 us | 131.01 us | 637.26 us | |
background | wait/io/file/mysys/charset | 3 | 283.73 us | 94.58 us | 268.70 us | |
background | wait/io/file/sql/pid | 3 | 45.56 us | 15.19 us | 36.39 us | |
background | wait/io/file/sql/misc | 1 | 12.52 us | 12.52 us | 12.52 us |
|