SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
pma | wait/lock/metadata/sql/mdl | 3 | 34460097408 | 11486699136 | 27089113392 | |
root | wait/io/file/innodb/innodb_data_file | 883 | 1841168132496 | 2085127968 | 40020084192 | |
root | wait/io/file/sql/binlog | 3307 | 1539054411312 | 465392664 | 40185303840 | |
root | wait/io/file/innodb/innodb_temp_file | 20 | 195071599008 | 9753579792 | 30247074528 | |
root | wait/lock/metadata/sql/mdl | 6 | 95000872032 | 15833478672 | 27157181568 | |
root | wait/io/file/sql/ERRMSG | 60 | 45960312288 | 766004976 | 3614040672 | |
root | wait/io/table/sql/handler | 334 | 14619433488 | 43770672 | 4095881856 | |
root | wait/io/file/sql/io_cache | 144 | 5668905792 | 39367152 | 2931083760 | |
root | wait/io/file/csv/metadata | 8 | 1627961280 | 203495160 | 573347808 | |
root | wait/io/file/myisam/dfile | 4 | 682840752 | 170710056 | 636099024 | |
root | wait/io/file/sql/misc | 26 | 617176032 | 23737296 | 241826640 | |
root | wait/io/file/myisam/kfile | 4 | 479943552 | 119985888 | 310747008 | |
root | wait/lock/table/sql/handler | 205 | 254034528 | 1238952 | 14019456 | |
root | wait/io/file/csv/data | 8 | 145219536 | 18152376 | 40557264 | |
root | wait/io/file/sql/binlog_index | 2 | 5049264 | 2524632 | 3060816 |
|