SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 4899419 | 2708825950512 | 552816 | 6199598592 | |
root | wait/io/file/innodb/innodb_data_file | 524 | 158302453056 | 302103912 | 6178376688 | |
root | wait/io/file/innodb/innodb_temp_file | 14 | 140733334368 | 10052380800 | 28236125808 | |
root | wait/io/file/sql/ERRMSG | 55 | 53037191328 | 964312536 | 6159199200 | |
root | wait/io/file/myisam/kfile | 12 | 4338735984 | 361561200 | 3111078960 | |
root | wait/io/file/sql/io_cache | 210 | 3983152272 | 18967344 | 491571168 | |
root | wait/io/file/csv/metadata | 8 | 2446236144 | 305779320 | 1948232352 | |
root | wait/io/file/myisam/dfile | 173 | 2001304272 | 11568216 | 1847676336 | |
root | wait/io/file/sql/binlog | 316 | 1724138592 | 5456088 | 29354688 | |
root | wait/lock/table/sql/handler | 1153 | 1150592784 | 997656 | 13519440 | |
root | wait/io/file/csv/data | 49 | 252310080 | 5149056 | 20445216 | |
root | wait/io/file/sql/binlog_index | 2 | 4185456 | 2092728 | 2439360 |
|