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 | 70 | 770321893440 | 11004598440 | 88774804800 | |
root | wait/io/file/innodb/innodb_data_file | 412 | 314174600784 | 762559512 | 25745437872 | |
root | wait/io/file/sql/binlog | 420 | 151817322096 | 361469592 | 20982659280 | |
root | wait/io/file/sql/ERRMSG | 65 | 57563625504 | 885594072 | 9878099616 | |
root | wait/io/table/sql/handler | 1604 | 17115791088 | 10670616 | 10729399824 | |
root | wait/io/file/sql/io_cache | 276 | 10670517792 | 38661216 | 2452498224 | |
root | wait/io/file/myisam/kfile | 8 | 2097751920 | 262218792 | 1799262432 | |
root | wait/io/file/csv/metadata | 4 | 656342016 | 164085504 | 540836736 | |
root | wait/lock/table/sql/handler | 363 | 401795856 | 1106688 | 13202640 | |
root | wait/io/file/sql/misc | 6 | 387700368 | 64616640 | 312686352 | |
root | wait/io/file/sql/binlog_index | 2 | 317903520 | 158951760 | 316098288 | |
root | wait/io/file/myisam/dfile | 4 | 51550752 | 12887688 | 28551600 | |
root | wait/io/file/csv/data | 2 | 39830208 | 19915104 | 32494176 |
|