SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 148 | 1458830802000 | 9856964832 | 93578508672 | |
root | wait/io/file/innodb/innodb_data_file | 818 | 1086563493312 | 1328317056 | 50330190240 | |
root | wait/io/table/sql/handler | 888614 | 709364187312 | 798072 | 46786797024 | |
root | wait/io/file/sql/binlog | 982 | 373303535088 | 380146008 | 23875880688 | |
root | wait/io/file/sql/io_cache | 1321 | 105560925360 | 79909632 | 23056226688 | |
root | wait/io/file/sql/ERRMSG | 75 | 61423771728 | 818983440 | 6102010992 | |
root | wait/io/file/csv/metadata | 8 | 12546053520 | 1568256624 | 11617078704 | |
root | wait/io/file/myisam/kfile | 16 | 1822841856 | 113927616 | 626501040 | |
root | wait/io/file/csv/data | 18 | 1226097312 | 68116488 | 635244720 | |
root | wait/lock/table/sql/handler | 599 | 1145471712 | 1912152 | 418822272 | |
root | wait/io/file/sql/binlog_index | 2 | 343799280 | 171899640 | 341608080 | |
root | wait/io/file/myisam/dfile | 9 | 112449744 | 12494328 | 40568880 | |
root | wait/io/file/sql/misc | 2 | 39295872 | 19647936 | 29628720 |
|