SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1157170 | 882843196224 | 762696 | 66784184544 | |
root | wait/io/file/innodb/innodb_temp_file | 48 | 421125192048 | 8773441248 | 26800500672 | |
root | wait/io/file/innodb/innodb_data_file | 542 | 247702715568 | 457015944 | 35124104400 | |
root | wait/io/file/sql/io_cache | 590 | 38872059072 | 65884632 | 15745989072 | |
root | wait/io/file/sql/ERRMSG | 60 | 33527841072 | 558797184 | 2189803440 | |
root | wait/io/file/sql/binlog | 216 | 5444190576 | 25204344 | 1913970960 | |
root | wait/io/file/csv/metadata | 8 | 2268563088 | 283570320 | 1225922016 | |
root | wait/io/file/myisam/kfile | 4 | 525265488 | 131316240 | 505851984 | |
root | wait/lock/table/sql/handler | 483 | 494346864 | 1023264 | 15246528 | |
root | wait/io/file/csv/data | 8 | 414571872 | 51821352 | 340529376 | |
root | wait/io/file/sql/binlog_index | 2 | 12194688 | 6097344 | 10609104 | |
root | wait/io/file/myisam/dfile | 2 | 9267984 | 4633992 | 8946432 |
|