SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 2448138 | 1246581540336 | 508992 | 2611917792 | |
root | wait/io/file/sql/binlog | 322 | 629466274272 | 1954864032 | 21325810176 | |
root | wait/io/file/innodb/innodb_data_file | 670 | 221204986464 | 330156552 | 30602322960 | |
root | wait/io/file/innodb/innodb_temp_file | 12 | 135837534624 | 11319794376 | 39593707824 | |
root | wait/io/file/sql/ERRMSG | 50 | 33682511808 | 673650120 | 4464514032 | |
root | wait/io/file/csv/metadata | 8 | 6078879840 | 759859848 | 5639217408 | |
root | wait/io/file/myisam/kfile | 9 | 2019940560 | 224437752 | 1379262192 | |
root | wait/io/file/myisam/dfile | 7 | 355534080 | 50790432 | 253956384 | |
root | wait/io/file/csv/data | 8 | 239009760 | 29876088 | 199275648 | |
root | wait/io/file/sql/misc | 8 | 111661440 | 13957680 | 30834144 | |
root | wait/lock/table/sql/handler | 91 | 95179392 | 1045704 | 8082096 | |
root | wait/io/file/sql/binlog_index | 2 | 18254544 | 9127272 | 15900192 |
|