SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 122 | 1.04 s | 8.51 ms | 27.92 ms | |
root | wait/io/file/sql/binlog | 698 | 798.66 ms | 1.14 ms | 27.80 ms | |
root | wait/io/file/innodb/innodb_data_file | 614 | 619.90 ms | 1.01 ms | 99.98 ms | |
root | wait/io/table/sql/handler | 274366 | 428.71 ms | 1.56 us | 4.60 ms | |
root | wait/io/file/sql/io_cache | 1666 | 363.68 ms | 218.30 us | 75.01 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 17.73 ms | 354.61 us | 1.72 ms | |
root | wait/lock/table/sql/handler | 7591 | 8.39 ms | 1.10 us | 89.94 us | |
root | wait/io/file/myisam/kfile | 8 | 1.59 ms | 198.25 us | 1.39 ms | |
root | wait/io/file/sql/misc | 13 | 1.33 ms | 102.62 us | 591.07 us | |
root | wait/io/file/csv/metadata | 8 | 967.67 us | 120.96 us | 540.39 us | |
root | wait/io/file/myisam/dfile | 30 | 284.53 us | 9.48 us | 247.02 us | |
root | wait/io/file/csv/data | 4 | 33.03 us | 8.26 us | 10.96 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.84 us | 2.42 us | 3.11 us |
|