SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 1183 | 4.11 s | 3.48 ms | 51.44 ms | |
root | wait/io/file/sql/binlog | 590 | 1.76 s | 2.98 ms | 45.21 ms | |
root | wait/io/file/innodb/innodb_temp_file | 42 | 420.16 ms | 10.00 ms | 40.31 ms | |
root | wait/io/file/sql/io_cache | 724 | 204.32 ms | 282.21 us | 115.63 ms | |
root | wait/io/table/sql/handler | 2570 | 59.20 ms | 23.04 us | 4.76 ms | |
root | wait/io/file/sql/ERRMSG | 90 | 50.21 ms | 557.86 us | 3.12 ms | |
root | wait/lock/metadata/sql/mdl | 1 | 22.01 ms | 22.01 ms | 22.01 ms | |
root | wait/io/file/csv/data | 9 | 5.16 ms | 573.10 us | 3.87 ms | |
root | wait/io/file/csv/metadata | 8 | 2.43 ms | 303.75 us | 1.14 ms | |
root | wait/io/file/myisam/kfile | 8 | 1.66 ms | 207.62 us | 1.42 ms | |
root | wait/lock/table/sql/handler | 864 | 1.51 ms | 1.74 us | 380.60 us | |
root | wait/io/file/myisam/dfile | 162 | 679.50 us | 4.19 us | 327.77 us | |
root | wait/io/file/sql/misc | 17 | 313.65 us | 18.45 us | 35.78 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.03 us | 2.52 us | 3.06 us |
|