SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 828 | 1.60 s | 1.93 ms | 43.88 ms | |
root | wait/io/file/sql/binlog | 638 | 1.14 s | 1.78 ms | 41.57 ms | |
root | wait/io/file/innodb/innodb_temp_file | 98 | 861.07 ms | 8.79 ms | 42.21 ms | |
root | wait/io/file/sql/io_cache | 1398 | 186.71 ms | 133.55 us | 86.84 ms | |
root | wait/io/table/sql/handler | 93146 | 178.20 ms | 1.91 us | 6.49 ms | |
root | wait/lock/metadata/sql/mdl | 3 | 104.41 ms | 34.80 ms | 67.40 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 30.66 ms | 557.53 us | 3.77 ms | |
root | wait/io/file/myisam/dfile | 4922 | 10.90 ms | 2.21 us | 3.56 ms | |
root | wait/io/file/myisam/kfile | 108 | 3.44 ms | 31.85 us | 594.68 us | |
root | wait/io/file/sql/binlog_index | 2 | 3.12 ms | 1.56 ms | 3.12 ms | |
root | wait/io/file/csv/data | 8 | 953.89 us | 119.24 us | 344.53 us | |
root | wait/lock/table/sql/handler | 813 | 919.03 us | 1.13 us | 15.53 us | |
root | wait/io/file/sql/SDI | 24 | 861.87 us | 35.91 us | 155.74 us | |
root | wait/io/file/sql/misc | 22 | 596.67 us | 27.12 us | 269.69 us | |
root | wait/io/file/csv/metadata | 8 | 564.95 us | 70.62 us | 287.83 us |
|