SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 281 | 392442344976 | 1396591944 | 35772325776 | |
root | wait/io/file/sql/binlog | 240 | 284797647024 | 1186656768 | 43269252048 | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 69484973712 | 11580828864 | 24594413712 | |
root | wait/io/file/sql/ERRMSG | 35 | 23786961264 | 679627344 | 3825380064 | |
root | wait/io/table/sql/handler | 465 | 17198286336 | 36985344 | 4399819776 | |
root | wait/io/file/sql/io_cache | 116 | 4189015776 | 36112032 | 1776255360 | |
root | wait/io/file/csv/metadata | 8 | 1502922432 | 187865304 | 503946432 | |
root | wait/lock/table/sql/handler | 652 | 911595168 | 1398144 | 19471584 | |
root | wait/io/file/csv/data | 4 | 579986352 | 144996456 | 478615104 | |
root | wait/io/file/sql/binlog_index | 2 | 228409104 | 114204552 | 226793424 | |
root | wait/io/file/sql/misc | 7 | 213338928 | 30476952 | 60496128 |
|