SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 26 | 300.66 ms | 11.56 ms | 53.92 ms | |
root | wait/io/file/innodb/innodb_data_file | 404 | 176.20 ms | 436.15 us | 21.29 ms | |
root | wait/io/file/sql/io_cache | 282 | 91.62 ms | 324.90 us | 66.66 ms | |
root | wait/io/file/sql/binlog | 514 | 55.94 ms | 108.82 us | 20.67 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 42.07 ms | 701.16 us | 6.23 ms | |
root | wait/io/table/sql/handler | 164 | 11.47 ms | 69.93 us | 3.88 ms | |
root | wait/io/file/csv/metadata | 8 | 2.76 ms | 344.86 us | 1.59 ms | |
root | wait/io/file/myisam/kfile | 12 | 2.42 ms | 201.62 us | 1.43 ms | |
root | wait/lock/table/sql/handler | 231 | 258.03 us | 1.12 us | 2.93 us | |
root | wait/io/file/csv/data | 7 | 106.68 us | 15.24 us | 37.33 us | |
root | wait/io/file/sql/misc | 2 | 92.64 us | 46.32 us | 80.32 us | |
root | wait/io/file/myisam/dfile | 6 | 32.04 us | 5.34 us | 11.46 us | |
root | wait/io/file/sql/binlog_index | 2 | 6.72 us | 3.36 us | 4.82 us |
|