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 | 94 | 953890577376 | 10147771920 | 37460349696 | |
root | wait/io/file/sql/binlog | 604 | 568636705824 | 941451456 | 187911599040 | |
root | wait/io/table/sql/handler | 980214 | 539671623216 | 550440 | 21970182960 | |
root | wait/io/file/innodb/innodb_data_file | 469 | 235058361120 | 501190272 | 27231378768 | |
root | wait/io/file/sql/ERRMSG | 60 | 89340590064 | 1489009632 | 46321651728 | |
root | wait/lock/table/sql/handler | 752 | 1005803040 | 1337424 | 10663488 | |
root | wait/io/file/myisam/kfile | 4 | 351843360 | 87960840 | 337151760 | |
root | wait/io/file/csv/metadata | 4 | 282662688 | 70665672 | 185759376 | |
root | wait/io/file/csv/data | 6 | 273913200 | 45652200 | 245689488 | |
root | wait/io/file/sql/misc | 3 | 67551792 | 22517088 | 27503520 | |
root | wait/io/file/myisam/dfile | 2 | 9941184 | 4970592 | 7236768 | |
root | wait/io/file/sql/binlog_index | 2 | 5625312 | 2812656 | 3879216 |
|