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 | 356 | 381515419296 | 1071672360 | 34102106544 | |
root | wait/io/file/sql/io_cache | 84 | 207843118032 | 2474322576 | 154451139216 | |
root | wait/io/file/sql/binlog | 398 | 119216711856 | 299539416 | 22468554768 | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 77520336432 | 12920055984 | 29979728592 | |
root | wait/io/table/sql/handler | 1734 | 69977645232 | 40356096 | 11932955760 | |
root | wait/io/file/sql/ERRMSG | 50 | 53580851808 | 1071616920 | 6684514848 | |
root | wait/io/file/csv/metadata | 8 | 9036982944 | 1129622736 | 8195029392 | |
root | wait/io/file/myisam/kfile | 16 | 3467920896 | 216745056 | 1197951216 | |
root | wait/io/file/csv/data | 10 | 1858439616 | 185843856 | 1607968032 | |
root | wait/lock/table/sql/handler | 302 | 1001483472 | 3316104 | 433983264 | |
root | wait/io/file/myisam/dfile | 11 | 668266896 | 60751416 | 550290048 | |
root | wait/io/file/sql/misc | 1 | 558676272 | 558676272 | 558676272 | |
root | wait/io/file/sql/binlog_index | 2 | 5344944 | 2672472 | 3890304 |
|