SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 777 | 1.30 s | 1.68 ms | 43.88 ms | |
root | wait/io/file/sql/binlog | 570 | 997.48 ms | 1.75 ms | 41.57 ms | |
root | wait/io/file/innodb/innodb_temp_file | 94 | 825.93 ms | 8.79 ms | 42.21 ms | |
root | wait/io/file/sql/io_cache | 1398 | 186.71 ms | 133.55 us | 86.84 ms | |
root | wait/io/table/sql/handler | 93110 | 178.08 ms | 1.91 us | 6.49 ms | |
root | wait/lock/metadata/sql/mdl | 3 | 104.41 ms | 34.80 ms | 67.40 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 30.66 ms | 557.53 us | 3.77 ms | |
root | wait/io/file/myisam/dfile | 4921 | 10.90 ms | 2.21 us | 3.56 ms | |
root | wait/io/file/myisam/kfile | 108 | 3.44 ms | 31.85 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/csv/data | 8 | 953.89 us | 119.24 us | 344.53 us | |
root | wait/io/file/sql/SDI | 24 | 861.87 us | 35.91 us | 155.74 us | |
root | wait/lock/table/sql/handler | 762 | 837.34 us | 1.10 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 | 17 | 517.95 us | 30.47 us | 269.69 us |
|