SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 608 | 3962854119840 | 6517851912 | 125345993520 | |
wait/io/file/innodb/innodb_data_file | 2343 | 3226927664400 | 1377263184 | 212448793920 | |
wait/io/file/innodb/innodb_temp_file | 131 | 684874303872 | 5228047968 | 43840240752 | |
wait/lock/metadata/sql/mdl | 1 | 254182826304 | 254182826304 | 254182826304 | |
wait/io/file/sql/binlog | 757 | 225226441440 | 297524832 | 27133951152 | |
wait/io/file/sql/binlog_index | 38 | 54171776208 | 1425572808 | 34925882640 | |
wait/io/file/sql/ERRMSG | 65 | 44121477312 | 678791784 | 3892895424 | |
wait/io/table/sql/handler | 262 | 6815303616 | 26012448 | 1771725120 | |
wait/io/file/mysys/cnf | 5 | 884434320 | 176886864 | 862491696 | |
wait/io/file/sql/casetest | 15 | 711160560 | 47410704 | 652884672 | |
wait/lock/table/sql/handler | 299 | 505048896 | 1689072 | 4982208 | |
wait/io/file/mysys/charset | 3 | 295128768 | 98376168 | 281382288 | |
wait/io/file/sql/misc | 6 | 76801824 | 12800304 | 24477024 | |
wait/io/file/sql/pid | 3 | 41827632 | 13942368 | 32765568 |
|