SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/sql/binlog | 722 | 1853438582160 | 2567089272 | 35814492384 | |
root | wait/io/file/innodb/innodb_data_file | 949 | 1359169952976 | 1432212672 | 48367607904 | |
root | wait/lock/metadata/sql/mdl | 1 | 1152968324112 | 1152968324112 | 1152968324112 | |
root | wait/io/file/innodb/innodb_temp_file | 84 | 762879000048 | 9081892776 | 31583146848 | |
root | wait/io/table/sql/handler | 678751 | 646185423840 | 951984 | 41400061296 | |
root | wait/io/file/sql/ERRMSG | 60 | 47548255392 | 792470712 | 3317225472 | |
root | wait/io/file/myisam/kfile | 19 | 16838215152 | 886221600 | 14419430784 | |
root | wait/io/file/csv/metadata | 8 | 1205713872 | 150714168 | 463253472 | |
root | wait/lock/table/sql/handler | 700 | 1164690912 | 1663728 | 127848864 | |
root | wait/io/file/myisam/dfile | 15 | 781895664 | 52126272 | 634035600 | |
root | wait/io/file/csv/data | 4 | 640484064 | 160121016 | 570563664 | |
root | wait/io/file/sql/misc | 17 | 373526208 | 21971928 | 131890176 | |
root | wait/io/file/sql/binlog_index | 2 | 4784208 | 2392104 | 3057120 |
|