SELECT * FROM `waits_by_host_by_latency`
|
host | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
192.168.30.20 | wait/io/table/sql/handler | 4413838 | 2.16 s | 488.66 ns | 12.42 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 534 | 571.60 ms | 1.07 ms | 337.72 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 194 | 273.87 ms | 1.41 ms | 200.46 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 14 | 129.89 ms | 9.28 ms | 33.30 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 45 | 25.01 ms | 555.88 us | 2.63 ms | |
192.168.30.20 | wait/io/file/myisam/kfile | 12 | 10.10 ms | 841.98 us | 6.80 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 56 | 4.59 ms | 81.92 us | 2.06 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2.37 ms | 296.28 us | 1.30 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 1650 | 1.75 ms | 1.06 us | 15.34 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 373 | 1.04 ms | 2.78 us | 358.33 us | |
192.168.30.20 | wait/io/file/csv/data | 22 | 963.79 us | 43.81 us | 617.76 us | |
192.168.30.20 | wait/io/file/sql/misc | 3 | 36.41 us | 12.14 us | 12.82 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.02 us | 2.51 us | 3.07 us | |
background | wait/io/file/innodb/innodb_log_file | 1379 | 8.65 s | 6.27 ms | 373.29 ms | |
background | wait/io/file/innodb/innodb_data_file | 3126 | 4.65 s | 1.49 ms | 231.27 ms | |
background | wait/io/file/innodb/innodb_temp_file | 89 | 412.44 ms | 4.63 ms | 39.44 ms | |
background | wait/io/file/sql/binlog | 37 | 41.38 ms | 1.12 ms | 19.25 ms | |
background | wait/io/file/sql/binlog_index | 36 | 41.19 ms | 1.14 ms | 23.10 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.39 ms | 278.42 us | 490.99 us | |
background | wait/io/file/mysys/cnf | 5 | 1.02 ms | 204.61 us | 998.96 us | |
background | wait/io/file/sql/casetest | 15 | 952.47 us | 63.50 us | 886.99 us | |
background | wait/io/file/mysys/charset | 3 | 238.61 us | 79.54 us | 225.84 us | |
background | wait/io/file/sql/pid | 3 | 34.68 us | 11.56 us | 27.53 us | |
background | wait/io/file/sql/misc | 1 | 12.85 us | 12.85 us | 12.85 us |
|