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 | 148 | 40.09 ms | 270.85 us | 4.70 ms | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 23.89 ms | 11.95 ms | 23.89 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 40 | 15.47 ms | 386.74 us | 2.12 ms | |
192.168.30.20 | wait/io/table/sql/handler | 105 | 5.72 ms | 54.49 us | 1.06 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 36 | 603.86 us | 16.77 us | 297.67 us | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 580.11 us | 145.03 us | 564.84 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 28 | 236.97 us | 8.46 us | 203.96 us | |
192.168.30.20 | wait/lock/table/sql/handler | 62 | 80.28 us | 1.29 us | 2.98 us | |
background | wait/io/file/innodb/innodb_log_file | 178 | 993.77 ms | 5.58 ms | 64.96 ms | |
background | wait/io/file/innodb/innodb_data_file | 1513 | 887.87 ms | 586.83 us | 341.64 ms | |
background | wait/io/file/innodb/innodb_temp_file | 80 | 386.10 ms | 4.83 ms | 33.95 ms | |
background | wait/io/file/sql/binlog_index | 36 | 58.30 ms | 1.62 ms | 32.75 ms | |
background | wait/io/file/sql/binlog | 37 | 33.43 ms | 903.52 us | 18.28 ms | |
background | wait/io/file/mysys/cnf | 5 | 2.17 ms | 434.14 us | 2.15 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.53 ms | 305.15 us | 578.57 us | |
background | wait/io/file/sql/casetest | 15 | 880.17 us | 58.68 us | 805.85 us | |
background | wait/io/file/mysys/charset | 3 | 344.48 us | 114.83 us | 313.46 us | |
background | wait/io/file/sql/pid | 3 | 16.99 us | 5.66 us | 13.52 us | |
background | wait/io/file/sql/misc | 1 | 6.36 us | 6.36 us | 6.36 us |
|