SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 629 | 922.55 ms | 1.47 ms | 39.71 ms | |
root | wait/io/file/sql/binlog | 1341 | 370.76 ms | 276.48 us | 24.40 ms | |
root | wait/io/file/innodb/innodb_temp_file | 26 | 258.05 ms | 9.93 ms | 30.81 ms | |
root | wait/io/file/sql/io_cache | 69 | 65.78 ms | 953.34 us | 61.87 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 41.62 ms | 693.73 us | 4.42 ms | |
root | wait/io/table/sql/handler | 1049 | 39.71 ms | 37.85 us | 5.50 ms | |
root | wait/io/file/myisam/kfile | 12 | 2.88 ms | 240.16 us | 1.52 ms | |
root | wait/io/file/csv/metadata | 8 | 2.75 ms | 344.21 us | 1.95 ms | |
root | wait/lock/table/sql/handler | 829 | 1.12 ms | 1.35 us | 78.29 us | |
root | wait/io/file/sql/misc | 8 | 458.47 us | 57.31 us | 351.56 us | |
root | wait/io/file/csv/data | 7 | 425.58 us | 60.80 us | 371.83 us | |
root | wait/io/file/sql/binlog_index | 2 | 264.98 us | 132.49 us | 263.43 us | |
root | wait/io/file/myisam/dfile | 6 | 25.37 us | 4.23 us | 10.04 us |
|