SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 72 | 642.45 ms | 8.92 ms | 42.21 ms | |
root | wait/io/file/sql/binlog | 394 | 483.96 ms | 1.23 ms | 41.57 ms | |
root | wait/io/file/innodb/innodb_data_file | 416 | 167.47 ms | 402.58 us | 19.13 ms | |
root | wait/io/table/sql/handler | 92839 | 165.90 ms | 1.79 us | 6.49 ms | |
root | wait/io/file/sql/io_cache | 966 | 142.27 ms | 147.28 us | 86.84 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 23.23 ms | 580.78 us | 3.77 ms | |
root | wait/io/file/myisam/dfile | 4842 | 8.17 ms | 1.69 us | 3.56 ms | |
root | wait/io/file/myisam/kfile | 104 | 3.20 ms | 30.79 us | 594.68 us | |
root | wait/io/file/sql/binlog_index | 2 | 3.12 ms | 1.56 ms | 3.12 ms | |
root | wait/io/file/sql/SDI | 24 | 861.87 us | 35.91 us | 155.74 us | |
root | wait/io/file/csv/data | 4 | 625.43 us | 156.36 us | 344.53 us | |
root | wait/lock/table/sql/handler | 529 | 567.30 us | 1.07 us | 15.53 us | |
root | wait/io/file/csv/metadata | 8 | 564.95 us | 70.62 us | 287.83 us | |
root | wait/io/file/sql/misc | 11 | 431.80 us | 39.25 us | 269.69 us |
|