SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 120 | 1.25 s | 10.45 ms | 42.28 ms | |
root | wait/io/file/sql/binlog | 772 | 568.35 ms | 736.21 us | 35.46 ms | |
root | wait/io/file/sql/io_cache | 1141 | 488.59 ms | 428.21 us | 195.59 ms | |
root | wait/io/file/innodb/innodb_data_file | 686 | 219.33 ms | 319.72 us | 32.06 ms | |
root | wait/io/file/sql/ERRMSG | 65 | 36.28 ms | 558.20 us | 6.13 ms | |
root | wait/io/table/sql/handler | 902 | 20.22 ms | 22.41 us | 3.24 ms | |
root | wait/io/file/csv/metadata | 4 | 1.88 ms | 469.43 us | 1.77 ms | |
root | wait/lock/table/sql/handler | 559 | 617.38 us | 1.10 us | 14.47 us | |
root | wait/io/file/myisam/kfile | 4 | 390.77 us | 97.69 us | 332.02 us | |
root | wait/io/file/sql/misc | 6 | 93.33 us | 15.56 us | 26.94 us | |
root | wait/io/file/myisam/dfile | 4 | 32.73 us | 8.18 us | 14.29 us | |
root | wait/io/file/csv/data | 2 | 29.14 us | 14.57 us | 22.68 us | |
root | wait/io/file/sql/binlog_index | 2 | 7.03 us | 3.52 us | 4.55 us |
|