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 | 42 | 511819229856 | 12186171888 | 49191033936 | |
root | wait/io/file/sql/io_cache | 750 | 343894369104 | 458525760 | 105749784096 | |
root | wait/io/file/innodb/innodb_data_file | 475 | 215194273008 | 453040368 | 22255220064 | |
root | wait/io/table/sql/handler | 41405 | 98636065440 | 2382072 | 4299040416 | |
root | wait/io/file/sql/binlog | 408 | 46637316000 | 114306984 | 13568279472 | |
root | wait/io/file/sql/ERRMSG | 50 | 37113394032 | 742267680 | 3911589264 | |
root | wait/io/file/myisam/kfile | 8 | 1798121424 | 224765112 | 1427748960 | |
root | wait/io/file/myisam/dfile | 6 | 856023168 | 142670352 | 822652512 | |
root | wait/lock/table/sql/handler | 183 | 246363744 | 1346136 | 15105552 | |
root | wait/io/file/sql/binlog_index | 2 | 9456480 | 4728240 | 7385664 |
|