SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 1899 | 6.56 s | 3.46 ms | 457.09 ms | |
root | wait/io/file/sql/binlog | 567 | 2.17 s | 3.83 ms | 32.52 ms | |
root | wait/lock/metadata/sql/mdl | 6 | 1.62 s | 269.64 ms | 597.16 ms | |
root | wait/io/table/sql/handler | 267440 | 427.20 ms | 1.60 us | 26.61 ms | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 76.21 ms | 7.62 ms | 16.90 ms | |
root | wait/io/file/sql/io_cache | 344 | 41.28 ms | 120.00 us | 12.85 ms | |
root | wait/io/file/sql/ERRMSG | 35 | 28.01 ms | 800.28 us | 5.66 ms | |
root | wait/io/file/myisam/kfile | 9 | 16.38 ms | 1.82 ms | 15.79 ms | |
root | wait/io/file/csv/metadata | 8 | 3.71 ms | 463.57 us | 2.24 ms | |
root | wait/io/file/sql/misc | 6 | 553.68 us | 92.28 us | 263.25 us | |
root | wait/lock/table/sql/handler | 404 | 386.20 us | 955.94 ns | 4.20 us | |
root | wait/io/file/myisam/dfile | 7 | 45.55 us | 6.51 us | 12.28 us | |
root | wait/io/file/csv/data | 4 | 40.95 us | 10.24 us | 17.53 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.12 us | 2.06 us | 2.70 us |
|