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 | 1160 | 2.25 s | 1.94 ms | 36.34 ms | |
192.168.30.20 | wait/io/file/sql/binlog | 516 | 1.20 s | 2.32 ms | 30.74 ms | |
192.168.30.20 | wait/io/file/innodb/innodb_temp_file | 42 | 382.47 ms | 9.11 ms | 40.09 ms | |
192.168.30.20 | wait/lock/metadata/sql/mdl | 4 | 249.16 ms | 62.29 ms | 246.83 ms | |
192.168.30.20 | wait/io/file/sql/ERRMSG | 55 | 32.22 ms | 585.90 us | 3.28 ms | |
192.168.30.20 | wait/io/file/sql/io_cache | 350 | 20.94 ms | 59.82 us | 11.73 ms | |
192.168.30.20 | wait/io/table/sql/handler | 5691 | 18.57 ms | 3.26 us | 2.06 ms | |
192.168.30.20 | wait/lock/table/sql/handler | 689 | 727.61 us | 1.06 us | 7.10 us | |
192.168.30.20 | wait/io/file/csv/metadata | 4 | 353.41 us | 88.35 us | 197.80 us | |
192.168.30.20 | wait/io/file/csv/data | 6 | 283.23 us | 47.21 us | 266.12 us | |
192.168.30.20 | wait/io/file/myisam/kfile | 4 | 241.93 us | 60.48 us | 179.73 us | |
192.168.30.20 | wait/io/file/sql/misc | 8 | 230.44 us | 28.81 us | 158.22 us | |
192.168.30.20 | wait/io/file/myisam/dfile | 4 | 27.45 us | 6.86 us | 9.10 us | |
192.168.30.20 | wait/io/file/sql/binlog_index | 2 | 11.40 us | 5.70 us | 10.13 us | |
background | wait/io/file/innodb/innodb_log_file | 4637 | 20.52 s | 4.43 ms | 62.53 ms | |
background | wait/io/file/innodb/innodb_data_file | 3906 | 4.63 s | 1.19 ms | 190.52 ms | |
background | wait/io/file/innodb/innodb_temp_file | 96 | 321.19 ms | 3.35 ms | 30.56 ms | |
background | wait/lock/metadata/sql/mdl | 1 | 86.33 ms | 86.33 ms | 86.33 ms | |
background | wait/io/file/sql/binlog | 31 | 26.81 ms | 864.92 us | 14.96 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.65 ms | 330.66 us | 544.57 us | |
background | wait/io/file/sql/binlog_index | 21 | 854.02 us | 40.67 us | 294.26 us | |
background | wait/io/file/sql/casetest | 15 | 766.09 us | 51.07 us | 685.80 us | |
background | wait/io/file/mysys/cnf | 5 | 368.28 us | 73.66 us | 352.59 us | |
background | wait/io/file/mysys/charset | 3 | 296.94 us | 98.98 us | 281.42 us | |
background | wait/io/file/sql/pid | 3 | 18.17 us | 6.06 us | 14.57 us |
|