SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 1473610 | 909054369168 | 616704 | 37088524704 | |
root | wait/io/file/innodb/innodb_data_file | 593 | 861132267072 | 1452162096 | 43830549312 | |
root | wait/io/file/innodb/innodb_temp_file | 76 | 697954442064 | 9183610920 | 50268884688 | |
root | wait/io/file/sql/binlog | 512 | 464682895776 | 907583688 | 27904288896 | |
root | wait/io/file/sql/ERRMSG | 85 | 104784197760 | 1232755128 | 41455897296 | |
root | wait/io/file/sql/misc | 7 | 4054365744 | 579194880 | 2058355728 | |
root | wait/io/file/sql/io_cache | 76 | 3429721152 | 45127896 | 1682676864 | |
root | wait/lock/table/sql/handler | 1487 | 1380666672 | 928488 | 14158848 | |
root | wait/io/file/csv/metadata | 8 | 1231888944 | 153985920 | 542461920 | |
root | wait/io/file/csv/data | 8 | 1076579328 | 134572416 | 1019349408 | |
root | wait/io/file/myisam/kfile | 4 | 623650896 | 155912592 | 605203632 | |
root | wait/io/file/myisam/dfile | 28 | 253508640 | 9053880 | 222261072 | |
root | wait/io/file/sql/binlog_index | 2 | 227082768 | 113541384 | 225502464 |
|