SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 32 | 318.10 ms | 9.94 ms | 47.57 ms | |
root | wait/io/file/sql/binlog | 856 | 276.20 ms | 322.67 us | 27.40 ms | |
root | wait/io/file/innodb/innodb_data_file | 323 | 176.41 ms | 546.15 us | 21.63 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 33.61 ms | 672.21 us | 2.43 ms | |
root | wait/io/table/sql/handler | 517 | 17.74 ms | 34.31 us | 4.25 ms | |
root | wait/io/file/myisam/kfile | 126 | 5.47 ms | 43.40 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/lock/table/sql/handler | 602 | 755.78 us | 1.26 us | 4.83 us | |
root | wait/io/file/myisam/dfile | 166 | 664.76 us | 4.00 us | 96.76 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 |
|