SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 1180 | 3.81 s | 3.23 ms | 99.29 ms | |
root | wait/io/file/sql/binlog | 657 | 2.14 s | 3.26 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 | 34 | 298.60 ms | 8.78 ms | 26.46 ms | |
root | wait/io/table/sql/handler | 75356 | 243.48 ms | 3.23 us | 81.01 ms | |
root | wait/io/file/sql/ERRMSG | 65 | 45.53 ms | 700.42 us | 5.23 ms | |
root | wait/io/file/myisam/dfile | 30465 | 34.93 ms | 1.15 us | 3.01 ms | |
root | wait/io/file/sql/SDI | 166 | 18.96 ms | 114.22 us | 5.42 ms | |
root | wait/io/file/myisam/kfile | 387 | 7.92 ms | 20.45 us | 1.19 ms | |
root | wait/io/file/csv/metadata | 8 | 4.01 ms | 501.62 us | 2.19 ms | |
root | wait/lock/table/sql/handler | 1706 | 2.00 ms | 1.17 us | 15.39 us | |
root | wait/io/file/sql/misc | 19 | 558.38 us | 29.39 us | 198.91 us | |
root | wait/io/file/csv/data | 11 | 106.40 us | 9.67 us | 24.11 us | |
root | wait/io/file/sql/binlog_index | 2 | 6.69 us | 3.35 us | 3.88 us |
|