SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 1396 | 4.49 s | 3.21 ms | 99.29 ms | |
root | wait/io/file/sql/binlog | 790 | 2.43 s | 3.08 ms | 30.76 ms | |
root | wait/lock/metadata/sql/mdl | 3 | 654.96 ms | 218.32 ms | 254.78 ms | |
root | wait/io/file/innodb/innodb_temp_file | 66 | 589.06 ms | 8.93 ms | 26.46 ms | |
root | wait/io/file/sql/io_cache | 788 | 308.50 ms | 391.49 us | 175.25 ms | |
root | wait/io/table/sql/handler | 101850 | 268.45 ms | 2.64 us | 81.01 ms | |
root | wait/io/file/myisam/dfile | 56875 | 49.60 ms | 871.99 ns | 3.01 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 47.42 ms | 677.39 us | 5.23 ms | |
root | wait/io/file/sql/SDI | 178 | 19.15 ms | 107.58 us | 5.42 ms | |
root | wait/io/file/myisam/kfile | 415 | 8.16 ms | 19.65 us | 1.19 ms | |
root | wait/lock/table/sql/handler | 1980 | 5.66 ms | 2.86 us | 1.68 ms | |
root | wait/io/file/csv/metadata | 8 | 4.01 ms | 501.62 us | 2.19 ms | |
root | wait/io/file/sql/misc | 22 | 1.55 ms | 70.34 us | 713.58 us | |
root | wait/io/file/csv/data | 14 | 504.65 us | 36.05 us | 378.63 us | |
root | wait/io/file/sql/binlog_index | 2 | 6.69 us | 3.35 us | 3.88 us |
|