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 | 18 | 172608980016 | 9589387632 | 32355777696 | |
root | wait/io/file/innodb/innodb_data_file | 190 | 98128155312 | 516463728 | 22960832928 | |
root | wait/io/file/sql/binlog | 203 | 95803477968 | 471938280 | 19101525696 | |
root | wait/io/table/sql/handler | 740 | 34639766304 | 46810368 | 4816365840 | |
root | wait/io/file/sql/ERRMSG | 40 | 28320802752 | 708020016 | 1946284032 | |
root | wait/io/file/sql/misc | 1 | 1851366528 | 1851366528 | 1851366528 | |
root | wait/io/file/myisam/kfile | 4 | 891668976 | 222917112 | 874080768 | |
root | wait/io/file/myisam/dfile | 80 | 521410032 | 6517368 | 486203520 | |
root | wait/lock/table/sql/handler | 337 | 491269152 | 1457544 | 10191984 | |
root | wait/io/file/sql/binlog_index | 2 | 4255152 | 2127576 | 2551824 |
|