SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
pma | wait/lock/metadata/sql/mdl | 2 | 42400020670 | 21200010335 | 23534624030 | |
root | wait/io/file/sql/binlog | 504 | 964828316580 | 1914341715 | 24965003930 | |
root | wait/io/file/innodb/innodb_data_file | 751 | 964783155280 | 1284664615 | 39136972850 | |
root | wait/io/file/innodb/innodb_temp_file | 92 | 920658916880 | 10007162140 | 50358433360 | |
root | wait/lock/metadata/sql/mdl | 7 | 175263544490 | 25037649175 | 42673173660 | |
root | wait/io/file/sql/ERRMSG | 65 | 45235959510 | 695937700 | 4914132440 | |
root | wait/io/table/sql/handler | 368 | 16238201480 | 44125415 | 5991072300 | |
root | wait/io/file/myisam/kfile | 9 | 2281449130 | 253494230 | 1812070530 | |
root | wait/io/file/csv/metadata | 8 | 1912088420 | 239010920 | 646862880 | |
root | wait/io/file/myisam/dfile | 33 | 1283031420 | 38879740 | 634869510 | |
root | wait/io/file/csv/data | 4 | 495522440 | 123880610 | 410407090 | |
root | wait/lock/table/sql/handler | 246 | 307702630 | 1250800 | 13517120 | |
root | wait/io/file/sql/misc | 8 | 90883870 | 11360285 | 22108950 | |
root | wait/io/file/sql/binlog_index | 2 | 4251660 | 2125830 | 2368570 |
|