SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 20 | 219.57 ms | 10.98 ms | 47.57 ms | |
root | wait/io/file/sql/binlog | 448 | 143.26 ms | 319.78 us | 18.32 ms | |
root | wait/io/file/innodb/innodb_data_file | 135 | 71.82 ms | 532.01 us | 19.43 ms | |
root | wait/io/file/sql/ERRMSG | 35 | 23.67 ms | 676.41 us | 2.43 ms | |
root | wait/io/table/sql/handler | 195 | 11.45 ms | 58.71 us | 4.25 ms | |
root | wait/io/file/myisam/kfile | 122 | 4.72 ms | 38.66 us | 1.39 ms | |
root | wait/io/file/sql/io_cache | 48 | 3.17 ms | 66.06 us | 1.34 ms | |
root | wait/io/file/sql/SDI | 33 | 2.33 ms | 70.55 us | 1.43 ms | |
root | wait/io/file/myisam/dfile | 136 | 537.33 us | 3.95 us | 96.76 us | |
root | wait/lock/table/sql/handler | 186 | 232.33 us | 1.25 us | 3.75 us | |
root | wait/io/file/sql/misc | 1 | 23.68 us | 23.68 us | 23.68 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.62 us | 2.31 us | 2.75 us |
|