SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 4408945 | 2457590399616 | 557304 | 6199598592 | |
root | wait/io/file/innodb/innodb_data_file | 455 | 130096850400 | 285927048 | 6178376688 | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 90219934464 | 9021993288 | 22186519344 | |
root | wait/io/file/sql/ERRMSG | 55 | 53037191328 | 964312536 | 6159199200 | |
root | wait/io/file/myisam/kfile | 8 | 3751036080 | 468879312 | 3111078960 | |
root | wait/io/file/sql/io_cache | 120 | 2601838800 | 21681792 | 491571168 | |
root | wait/io/file/csv/metadata | 8 | 2446236144 | 305779320 | 1948232352 | |
root | wait/io/file/sql/binlog | 184 | 1018100688 | 5532912 | 29354688 | |
root | wait/lock/table/sql/handler | 703 | 655770192 | 932712 | 13519440 | |
root | wait/io/file/csv/data | 49 | 252310080 | 5149056 | 20445216 | |
root | wait/io/file/myisam/dfile | 6 | 31809360 | 5301384 | 11160336 | |
root | wait/io/file/sql/binlog_index | 2 | 4185456 | 2092728 | 2439360 |
|