SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 922 | 1.84 s | 1.99 ms | 43.88 ms | |
root | wait/io/file/sql/binlog | 906 | 1.34 s | 1.48 ms | 41.57 ms | |
root | wait/io/file/innodb/innodb_temp_file | 128 | 1.14 s | 8.87 ms | 42.21 ms | |
root | wait/io/file/sql/io_cache | 1948 | 195.83 ms | 100.53 us | 86.84 ms | |
root | wait/io/table/sql/handler | 95491 | 193.93 ms | 2.03 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 | 65 | 36.84 ms | 566.84 us | 3.77 ms | |
root | wait/io/file/myisam/dfile | 5303 | 13.17 ms | 2.48 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/lock/table/sql/handler | 1620 | 1.79 ms | 1.10 us | 16.39 us | |
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/io/file/sql/misc | 28 | 683.13 us | 24.40 us | 269.69 us | |
root | wait/io/file/csv/metadata | 8 | 564.95 us | 70.62 us | 287.83 us |
|