SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 96 | 863.56 ms | 9.00 ms | 39.61 ms | |
root | wait/io/file/sql/io_cache | 1969 | 792.36 ms | 402.42 us | 509.48 ms | |
root | wait/io/file/innodb/innodb_data_file | 558 | 213.14 ms | 381.97 us | 33.53 ms | |
root | wait/io/file/sql/binlog | 346 | 163.35 ms | 472.10 us | 22.79 ms | |
root | wait/io/table/sql/handler | 44893 | 119.25 ms | 2.66 us | 4.45 ms | |
root | wait/io/file/sql/ERRMSG | 65 | 31.10 ms | 478.43 us | 3.97 ms | |
root | wait/lock/metadata/sql/mdl | 4 | 26.00 ms | 6.50 ms | 23.01 ms | |
root | wait/io/file/sql/misc | 4 | 2.29 ms | 572.36 us | 2.22 ms | |
root | wait/lock/table/sql/handler | 744 | 1.04 ms | 1.39 us | 11.51 us | |
root | wait/io/file/csv/metadata | 4 | 466.98 us | 116.74 us | 293.99 us | |
root | wait/io/file/csv/data | 29 | 430.01 us | 14.83 us | 302.40 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.15 us | 2.57 us | 3.40 us |
|