Upgrade from MySQL 5.7 to MySQL 8.0.35 causing huge performance problems

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

主題: 資料庫
標籤: MySQL
語言: English

WzAdmin

已提問 2 年前檢視次數 980 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

已接受的答案

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

管理員

Phil

已回答 2 年前

專家

Adeleke Adebowale .J.

已審閱 2 年前

WzAdmin
2 年前
You are right about the magnetic and the gp2 volumes. Will try and let you know how it goes. thanks for your help, WzAdmin

Upgrade from MySQL 5.7 to MySQL 8.0.35 causing huge performance problems

新增您的答案

相關內容