SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 869 | 5706792899280 | 6567080256 | 167994228864 | |
wait/io/file/innodb/innodb_data_file | 2999 | 4497651166800 | 1499716944 | 234328560576 | |
wait/io/file/innodb/innodb_temp_file | 108 | 441362766768 | 4086692280 | 34822049328 | |
wait/io/file/sql/binlog | 914 | 140330503632 | 153534216 | 23706014112 | |
wait/io/file/sql/binlog_index | 38 | 40893159120 | 1076135544 | 25595118912 | |
wait/io/table/sql/handler | 6297 | 39429054720 | 6261552 | 4593090480 | |
wait/io/file/sql/ERRMSG | 65 | 36580902336 | 562783056 | 2972907696 | |
wait/io/file/csv/metadata | 8 | 1969210320 | 246151224 | 883821312 | |
wait/io/file/sql/casetest | 15 | 1436957280 | 95797152 | 1344542496 | |
wait/lock/table/sql/handler | 721 | 846450528 | 1173744 | 26651328 | |
wait/io/file/sql/misc | 4 | 574160928 | 143540232 | 535831296 | |
wait/io/file/mysys/cnf | 5 | 538613856 | 107722560 | 521390496 | |
wait/io/file/myisam/dfile | 80 | 344342064 | 4304256 | 317726112 | |
wait/io/file/myisam/kfile | 4 | 318934176 | 79733544 | 301526544 | |
wait/io/file/mysys/charset | 3 | 247640976 | 82546992 | 229002048 | |
wait/io/file/csv/data | 12 | 50696448 | 4224528 | 10700976 | |
wait/io/file/sql/pid | 3 | 12569568 | 4189680 | 9978672 |
|