SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1024703 | 600607233600 | 586080 | 3164871600 | |
root | wait/io/file/innodb/innodb_data_file | 561 | 192231153312 | 342658008 | 22065636912 | |
root | wait/io/file/sql/binlog | 130 | 73927847664 | 568675536 | 36492156096 | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 60572371200 | 10095395112 | 26583935136 | |
root | wait/io/file/sql/ERRMSG | 45 | 29052673584 | 645614904 | 2943712992 | |
root | wait/io/file/myisam/dfile | 15 | 2544691248 | 169645872 | 1706949024 | |
root | wait/io/file/csv/metadata | 8 | 2069956944 | 258744552 | 1145535600 | |
root | wait/io/file/myisam/kfile | 12 | 1426334448 | 118860984 | 570005040 | |
root | wait/lock/table/sql/handler | 513 | 600364512 | 1170048 | 12649824 | |
root | wait/io/file/sql/misc | 2 | 218451552 | 109225776 | 206063088 | |
root | wait/io/file/csv/data | 13 | 142945440 | 10995600 | 65738112 | |
root | wait/io/file/sql/binlog_index | 2 | 4171728 | 2085864 | 2935152 |
|