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_temp_file | 80 | 732.86 ms | 9.16 ms | 37.67 ms | |
192.168.30.20 | wait/io/table/sql/handler | 1013784 | 686.38 ms | 676.90 ns | 7.51 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 587 | 255.98 ms | 436.08 us | 21.95 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 2340 | 251.67 ms | 107.55 us | 67.84 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 318 | 237.24 ms | 746.05 us | 21.46 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 65 | 47.73 ms | 734.25 us | 4.96 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 5525 | 5.51 ms | 997.92 ns | 21.91 us | |
192.168.30.20 | wait/io/file/myisam/kfile | 16 | 1.67 ms | 104.67 us | 788.29 us | |
192.168.30.20 | wait/io/file/csv/data | 24 | 1.31 ms | 54.46 us | 851.70 us | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 1.25 ms | 156.13 us | 717.03 us | |
192.168.30.20 | wait/io/file/sql/misc | 9 | 379.86 us | 42.21 us | 251.65 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 14 | 337.83 us | 24.13 us | 291.82 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 5.21 us | 2.60 us | 3.41 us | |
background | wait/io/file/innodb/innodb_log_file | 5776 | 29.60 s | 5.12 ms | 116.20 ms | |
background | wait/io/file/innodb/innodb_data_file | 9288 | 10.63 s | 1.14 ms | 234.40 ms | |
background | wait/io/file/innodb/innodb_temp_file | 1364 | 1.53 s | 1.12 ms | 658.38 ms | |
background | wait/io/file/sql/binlog_index | 36 | 58.51 ms | 1.63 ms | 35.55 ms | |
background | wait/io/file/sql/binlog | 37 | 40.72 ms | 1.10 ms | 20.91 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.24 ms | 248.42 us | 419.45 us | |
background | wait/io/file/sql/casetest | 15 | 1.12 ms | 74.37 us | 1.05 ms | |
background | wait/io/file/mysys/cnf | 5 | 575.30 us | 115.06 us | 559.23 us | |
background | wait/io/file/mysys/charset | 3 | 297.09 us | 99.03 us | 281.40 us | |
background | wait/io/file/sql/pid | 3 | 44.13 us | 14.71 us | 34.66 us | |
background | wait/io/file/sql/misc | 1 | 6.83 us | 6.83 us | 6.83 us |
|