SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1472204 | 851.01 ms | 577.90 ns | 2.71 ms | |
root | wait/io/file/innodb/innodb_temp_file | 48 | 506.59 ms | 10.55 ms | 34.25 ms | |
root | wait/io/file/innodb/innodb_data_file | 478 | 296.60 ms | 620.50 us | 33.53 ms | |
root | wait/io/file/sql/binlog | 368 | 153.37 ms | 416.76 us | 28.48 ms | |
root | wait/io/file/sql/io_cache | 364 | 52.39 ms | 143.93 us | 33.04 ms | |
root | wait/io/file/sql/ERRMSG | 75 | 34.79 ms | 463.87 us | 3.03 ms | |
root | wait/io/file/myisam/dfile | 23 | 16.12 ms | 700.77 us | 15.17 ms | |
root | wait/io/file/myisam/kfile | 16 | 2.59 ms | 161.72 us | 1.29 ms | |
root | wait/lock/table/sql/handler | 738 | 834.06 us | 1.13 us | 15.09 us | |
root | wait/io/file/csv/metadata | 4 | 562.55 us | 140.64 us | 446.37 us | |
root | wait/io/file/csv/data | 14 | 377.49 us | 26.96 us | 307.79 us | |
root | wait/io/file/sql/misc | 3 | 37.99 us | 12.66 us | 13.44 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.99 us | 3.00 us | 4.40 us |
|