SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 10 | 119.17 ms | 11.92 ms | 42.21 ms | |
root | wait/io/file/sql/io_cache | 215 | 95.82 ms | 445.67 us | 86.84 ms | |
root | wait/io/file/innodb/innodb_data_file | 215 | 91.35 ms | 424.91 us | 19.13 ms | |
root | wait/io/file/sql/binlog | 60 | 33.71 ms | 561.81 us | 17.90 ms | |
root | wait/io/table/sql/handler | 182 | 16.14 ms | 88.66 us | 5.23 ms | |
root | wait/io/file/sql/ERRMSG | 25 | 12.87 ms | 514.72 us | 3.77 ms | |
root | wait/io/file/sql/binlog_index | 2 | 3.12 ms | 1.56 ms | 3.12 ms | |
root | wait/io/file/myisam/kfile | 12 | 1.60 ms | 133.23 us | 594.68 us | |
root | wait/io/file/csv/data | 4 | 625.43 us | 156.36 us | 344.53 us | |
root | wait/io/file/csv/metadata | 8 | 564.95 us | 70.62 us | 287.83 us | |
root | wait/io/file/sql/misc | 1 | 269.69 us | 269.69 us | 269.69 us | |
root | wait/lock/table/sql/handler | 53 | 69.54 us | 1.31 us | 9.71 us | |
root | wait/io/file/myisam/dfile | 6 | 57.12 us | 9.52 us | 22.67 us |
|