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 | 70 | 728220964944 | 10403156544 | 37460349696 | |
root | wait/io/file/sql/binlog | 440 | 529597233792 | 1203629856 | 187911599040 | |
root | wait/io/file/innodb/innodb_data_file | 455 | 233772182160 | 513784920 | 27231378768 | |
root | wait/io/file/sql/ERRMSG | 60 | 89340590064 | 1489009632 | 46321651728 | |
root | wait/io/table/sql/handler | 905 | 38492329920 | 42532776 | 21970182960 | |
root | wait/lock/table/sql/handler | 614 | 791750256 | 1289376 | 8632800 | |
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 |
|