Upgrade from MySQL 5.7 to MySQL 8.0.35 causing huge performance problems

Question

We recently upgraded MySQL 5.7 to MySQL 8.0.35 and are noticing huge performance problems in our production website.

Any insights as to what sort of queries can cause performance issues? Any config settings to be changed?
Any pointers will be very helpful to us.

thanks
WzAdmin

Phil · Accepted Answer

Well, if I am correct, your 5.7 instance is running on magnetic volumes and the 8.0 is using a very small gp2 volume. You should consider modifying that to gp3 since this volume type has baseline of 3000 IOPS
which is a lot more than the gp2 volume.

Here is a blog that explains how to think about gp2 burst performance.

https://aws.amazon.com/blogs/database/understanding-burst-vs-baseline-performance-with-amazon-rds-and-gp2/

https://docs.aws.amazon.com/ebs/latest/userguide/ebs-volume-types.html

Upgrade from MySQL 5.7 to MySQL 8.0.35 causing huge performance problems

添加回答

相关内容