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 | 60 | 603631627104 | 10060527048 | 38947734144 | |
root | wait/io/file/innodb/innodb_data_file | 290 | 95706491232 | 330022176 | 6115199376 | |
root | wait/io/file/sql/ERRMSG | 65 | 42002295456 | 646189104 | 2485668768 | |
root | wait/io/file/sql/binlog | 312 | 32553809376 | 104338872 | 17616157152 | |
root | wait/io/table/sql/handler | 429 | 30369773808 | 70791864 | 12182615808 | |
root | wait/io/file/csv/metadata | 8 | 972855312 | 121606848 | 528152592 | |
root | wait/io/file/csv/data | 4 | 331166880 | 82791720 | 298958880 | |
root | wait/lock/table/sql/handler | 257 | 237268416 | 923208 | 5574624 | |
root | wait/io/file/sql/misc | 2 | 24342384 | 12171192 | 12649296 | |
root | wait/io/file/sql/binlog_index | 2 | 5375568 | 2687784 | 3444144 |
|