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 | 822 | 1671292150704 | 2033202072 | 51033163104 | |
root | wait/io/file/sql/binlog | 170 | 407657007648 | 2397982224 | 31911387024 | |
root | wait/io/table/sql/handler | 54392 | 216137059248 | 3973464 | 44265248016 | |
root | wait/io/file/innodb/innodb_temp_file | 20 | 189837429408 | 9491871312 | 35099890320 | |
root | wait/io/file/sql/ERRMSG | 45 | 40616615424 | 902591448 | 6504460512 | |
root | wait/io/file/myisam/dfile | 8312 | 4483609680 | 539352 | 418168080 | |
root | wait/io/file/csv/metadata | 8 | 4031047680 | 503880960 | 2474274000 | |
root | wait/io/file/myisam/kfile | 16 | 3748198608 | 234262248 | 1381314000 | |
root | wait/io/file/csv/data | 12 | 791256048 | 65937960 | 660887040 | |
root | wait/lock/table/sql/handler | 224 | 278732256 | 1244232 | 8657616 | |
root | wait/io/file/sql/misc | 2 | 23560416 | 11780208 | 11887392 | |
root | wait/io/file/sql/binlog_index | 2 | 5217696 | 2608848 | 3504864 |
|