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 | 1899 | 6.56 s | 3.46 ms | 457.09 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 573 | 2.19 s | 3.82 ms | 32.52 ms | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 6 | 1.62 s | 269.64 ms | 597.16 ms | |
192.168.30.20 | wait/io/table/sql/handler | 267440 | 427.20 ms | 1.60 us | 26.61 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 10 | 76.21 ms | 7.62 ms | 16.90 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 344 | 41.28 ms | 120.00 us | 12.85 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 35 | 28.01 ms | 800.28 us | 5.66 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 9 | 16.38 ms | 1.82 ms | 15.79 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 3.71 ms | 463.57 us | 2.24 ms | |
192.168.30.20 | wait/io/file/sql/misc | 7 | 584.16 us | 83.45 us | 263.25 us | |
192.168.30.20 | wait/lock/table/sql/handler | 404 | 386.20 us | 955.94 ns | 4.20 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 7 | 45.55 us | 6.51 us | 12.28 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 40.95 us | 10.24 us | 17.53 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 4.12 us | 2.06 us | 2.70 us | |
background | wait/io/file/innodb/innodb_log_file | 8701 | 40.43 s | 4.65 ms | 480.17 ms | |
background | wait/io/file/innodb/innodb_data_file | 5486 | 9.27 s | 1.69 ms | 421.47 ms | |
background | wait/lock/metadata/sql/mdl | 4 | 1.05 s | 262.80 ms | 310.07 ms | |
background | wait/io/file/innodb/innodb_temp_file | 385 | 301.05 ms | 781.94 us | 20.46 ms | |
background | wait/io/file/sql/binlog_index | 36 | 40.24 ms | 1.12 ms | 23.43 ms | |
background | wait/io/file/sql/binlog | 37 | 28.97 ms | 782.89 us | 15.77 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.32 ms | 264.98 us | 511.43 us | |
background | wait/io/file/sql/casetest | 15 | 736.40 us | 49.09 us | 676.04 us | |
background | wait/io/file/mysys/cnf | 5 | 710.98 us | 142.20 us | 652.81 us | |
background | wait/io/file/mysys/charset | 3 | 279.94 us | 93.31 us | 269.81 us | |
background | wait/io/file/sql/pid | 3 | 20.92 us | 6.97 us | 16.03 us |
|