SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 368 | 486.82 ms | 1.32 ms | 337.72 ms | |
root | wait/io/file/sql/binlog | 118 | 243.32 ms | 2.06 ms | 200.46 ms | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 75.31 ms | 12.55 ms | 33.30 ms | |
root | wait/io/table/sql/handler | 1295 | 45.58 ms | 35.20 us | 8.92 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 20.02 ms | 500.54 us | 1.87 ms | |
root | wait/io/file/myisam/kfile | 8 | 7.93 ms | 991.47 us | 6.80 ms | |
root | wait/io/file/sql/io_cache | 56 | 4.59 ms | 81.92 us | 2.06 ms | |
root | wait/io/file/csv/metadata | 8 | 2.37 ms | 296.28 us | 1.30 ms | |
root | wait/io/file/csv/data | 22 | 963.79 us | 43.81 us | 617.76 us | |
root | wait/lock/table/sql/handler | 465 | 549.38 us | 1.18 us | 15.34 us | |
root | wait/io/file/myisam/dfile | 60 | 473.96 us | 7.90 us | 310.25 us | |
root | wait/io/file/sql/misc | 1 | 12.82 us | 12.82 us | 12.82 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.02 us | 2.51 us | 3.07 us |
|