MySQL Forums
Forum List  »  Performance

Re: MySQL 8.0 performance degrades compared to 5.7
Posted by: Peter Brawley
Date: August 23, 2022 11:38PM

Many such reports, eg see https://bugs.mysql.com/bug.php?id=93734, you'll want to check out the various settings and workarounds discussed there.

And of course, 8.0 does more, so it needs more resources, and it does some things differently therefore needs its own customisations, so you'll need to configure 8.0 taking that into account. Best look for alerted status values in phpMyAdmin (eg https://dba.stackexchange.com/questions/291744/mysql-8-0-tuning-advice-needed-slow-locking-various-issues) or under "optimisation cheatsheet" at https://www.artfulsoftware.com/infotree/mysqltips.php.



Edited 1 time(s). Last edit at 08/23/2022 11:48PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8.0 performance degrades compared to 5.7
42
August 23, 2022 11:38PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.