SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 2225104 | 1.33 s | 598.49 ns | 20.11 ms | |
root | wait/io/file/innodb/innodb_temp_file | 30 | 308.23 ms | 10.27 ms | 27.48 ms | |
root | wait/io/file/innodb/innodb_data_file | 557 | 133.63 ms | 239.90 us | 6.26 ms | |
root | wait/io/file/sql/io_cache | 866 | 121.83 ms | 140.68 us | 31.25 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 41.01 ms | 820.17 us | 7.88 ms | |
root | wait/io/file/sql/binlog | 1350 | 40.37 ms | 29.91 us | 17.50 ms | |
root | wait/io/file/csv/metadata | 8 | 11.12 ms | 1.39 ms | 9.45 ms | |
root | wait/io/file/myisam/kfile | 16 | 3.80 ms | 237.43 us | 2.39 ms | |
root | wait/io/file/myisam/dfile | 6040 | 2.64 ms | 437.45 ns | 599.52 us | |
root | wait/io/file/csv/data | 4 | 1.35 ms | 337.67 us | 1.31 ms | |
root | wait/lock/table/sql/handler | 695 | 731.09 us | 1.05 us | 13.31 us | |
root | wait/io/file/sql/misc | 1 | 17.37 us | 17.37 us | 17.37 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.46 us | 2.73 us | 3.43 us |
|