SELECT * FROM `waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 989481 | 632.42 ms | 638.88 ns | 7.51 ms | |
root | wait/io/file/innodb/innodb_temp_file | 16 | 182.84 ms | 11.43 ms | 37.67 ms | |
root | wait/io/file/innodb/innodb_data_file | 462 | 122.93 ms | 266.08 us | 10.69 ms | |
root | wait/io/file/sql/binlog | 80 | 34.61 ms | 432.67 us | 14.70 ms | |
root | wait/io/file/sql/ERRMSG | 35 | 21.94 ms | 626.99 us | 4.00 ms | |
root | wait/io/file/sql/io_cache | 266 | 9.16 ms | 34.44 us | 4.43 ms | |
root | wait/lock/table/sql/handler | 1450 | 1.44 ms | 991.85 ns | 21.91 us | |
root | wait/io/file/csv/metadata | 8 | 1.25 ms | 156.13 us | 717.03 us | |
root | wait/io/file/myisam/kfile | 4 | 814.14 us | 203.54 us | 788.29 us | |
root | wait/io/file/myisam/dfile | 8 | 314.02 us | 39.25 us | 291.82 us | |
root | wait/io/file/csv/data | 4 | 312.11 us | 78.03 us | 279.37 us | |
root | wait/io/file/sql/misc | 2 | 27.31 us | 13.66 us | 15.01 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.21 us | 2.60 us | 3.41 us |
|