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 | 88 | 789646166496 | 8973251760 | 42151847232 | |
root | wait/io/table/sql/handler | 980498 | 534063328128 | 544632 | 4667752848 | |
root | wait/io/file/innodb/innodb_data_file | 503 | 207451415424 | 412428192 | 46736263728 | |
root | wait/io/file/sql/binlog | 634 | 203873696928 | 321567312 | 123608327040 | |
root | wait/io/file/sql/ERRMSG | 60 | 35456007312 | 590933376 | 4883879616 | |
root | wait/io/file/csv/metadata | 8 | 5177281296 | 647160096 | 2322560064 | |
root | wait/lock/table/sql/handler | 1314 | 1630101792 | 1240536 | 4946304 | |
root | wait/io/file/myisam/kfile | 4 | 594403392 | 148600848 | 573683616 | |
root | wait/io/file/sql/misc | 5 | 195207936 | 39041376 | 132475728 | |
root | wait/io/file/csv/data | 4 | 35457312 | 8864328 | 13111296 | |
root | wait/io/file/myisam/dfile | 2 | 8039328 | 4019664 | 7733616 | |
root | wait/io/file/sql/binlog_index | 2 | 4867632 | 2433816 | 3316896 |
|