Bug #106410 Upgraded Mysql 5.6 to Mysql 5.7. All Queries are running damn slow after upgrade

• Submitted: 8 Feb 2022 17:16
• Modified: 8 Feb 2022 19:31
• Reporter: Ravi T
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.734
• OS: Any
• CPU Architecture: Any

[8 Feb 2022 17:16] Ravi T

Description:

I upgraded Mysql 5.6 to Mysql 5.734. Queries which were running so smoothly in mysql 5.6. It is running very slow in mysql 5.734 when compared to 5.6.

All the queries are running slow. Any configuration change which i need to make to fix this.

How to repeat:
I upgraded Mysql 5.6 to Mysql 5.734. Queries which were running so smoothly in mysql 5.6. It is running very slow in mysql 5.734 when compared to 5.6.

All the queries are running slow. Any configuration which i need to make to fix this.

[8 Feb 2022 19:31] MySQL Verification Team

Hi Mr. T,

Thank you for your bug report.

However, this is a known phenomena for the single-thread queries. It makes this bug a duplicate one to many already verified bugs, like those :

https://bugs.mysql.com/bug.php?id=93360

https://bugs.mysql.com/bug.php?id=87641

https://bugs.mysql.com/bug.php?id=74472

and many others.

Yes, you can make your 5.7 running faster if you tune it properly. All info on the tuning of MySQL 5.7 can be found in our Reference Manual, which is located at http://dev.mysql.com

This is a known and hence, a duplicate bug.