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 | 50 | 466.69 ms | 9.33 ms | 30.91 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 462.34 ms | 8.41 ms | 433.41 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 501 | 363.35 ms | 725.24 us | 24.44 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_data_file | 354 | 353.01 ms | 997.20 us | 40.91 ms | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 3 | 81.37 ms | 27.12 ms | 28.45 ms | |
192.168.30.20 | wait/io/table/sql/handler | 1155 | 41.31 ms | 35.77 us | 8.37 ms | |
192.168.30.20 | wait/io/file/csv/metadata | 8 | 2.29 ms | 286.72 us | 1.36 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 36 | 939.85 us | 26.11 us | 254.47 us | |
192.168.30.20 | wait/lock/table/sql/handler | 599 | 781.65 us | 1.30 us | 16.75 us | |
192.168.30.20 | wait/io/file/csv/data | 4 | 618.03 us | 154.51 us | 509.95 us | |
192.168.30.20 | wait/io/file/sql/misc | 10 | 452.50 us | 45.25 us | 332.75 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 11.22 us | 5.61 us | 9.40 us | |
background | wait/io/file/innodb/innodb_log_file | 916 | 5.94 s | 6.49 ms | 613.06 ms | |
background | wait/io/file/innodb/innodb_data_file | 2571 | 3.96 s | 1.54 ms | 209.04 ms | |
background | wait/io/file/innodb/innodb_temp_file | 134 | 375.79 ms | 2.80 ms | 31.01 ms | |
background | wait/io/file/sql/binlog_index | 36 | 55.21 ms | 1.53 ms | 34.13 ms | |
background | wait/io/file/sql/binlog | 37 | 36.70 ms | 991.78 us | 18.16 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.32 ms | 263.42 us | 1.29 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.29 ms | 258.75 us | 395.48 us | |
background | wait/io/file/sql/casetest | 15 | 913.43 us | 60.90 us | 852.84 us | |
background | wait/io/file/mysys/charset | 3 | 241.19 us | 80.40 us | 230.00 us | |
background | wait/io/file/sql/pid | 3 | 47.58 us | 15.86 us | 36.90 us | |
background | wait/io/file/sql/misc | 1 | 12.44 us | 12.44 us | 12.44 us |
|