SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 550 | 891932842416 | 1621696032 | 50330190240 | |
root | wait/io/file/innodb/innodb_temp_file | 64 | 617343688896 | 9645995040 | 33971757600 | |
root | wait/io/table/sql/handler | 221526 | 284961657024 | 1286208 | 46786797024 | |
root | wait/io/file/sql/binlog | 296 | 252830520096 | 854156952 | 23875880688 | |
root | wait/io/file/sql/ERRMSG | 50 | 37522482096 | 750449568 | 3059356080 | |
root | wait/io/file/sql/io_cache | 199 | 36138167472 | 181598736 | 13312831488 | |
root | wait/io/file/csv/metadata | 8 | 12546053520 | 1568256624 | 11617078704 | |
root | wait/io/file/csv/data | 13 | 1198046784 | 92157384 | 635244720 | |
root | wait/io/file/myisam/kfile | 4 | 595144704 | 148786176 | 543237024 | |
root | wait/io/file/sql/binlog_index | 2 | 343799280 | 171899640 | 341608080 | |
root | wait/lock/table/sql/handler | 139 | 178979328 | 1287528 | 4926240 | |
root | wait/io/file/myisam/dfile | 2 | 41831328 | 20915664 | 40568880 | |
root | wait/io/file/sql/misc | 2 | 39295872 | 19647936 | 29628720 |
|