mysql 8 superslow with accounts transferred from older servers

[sahostking]

So we have around 17 servers all with cpanel. However we setup a new server a week ago which obviously got mysql 8 and not mariadb installed on it.

We then transfer some accounts over and immediately noticed extremely slow response times on wordpress sites.
New installed sites are fine on the server but older ones transferred from older servers are not.

We checked mysqladmin processlist and found tables were locked.

After a week of troubleshooting we found the following to possibly be the cause.

MYISAM tables dont work well with MySQL 8. Mariadb it does fine but not MySQL 8.

So we made the default storage engine to MYISAM in my.cnf and suddenly sites are lightning fast again.

Hope it stays that way and we will continue to monitor. But we may have to rather setup a new server with mariadb and moves all these customer accounts across again to resolve it completely.

 

[cPRex]

Hey there! That's interesting, and I'm not sure I've heard a similar report yet. MySQL even offers a MyISAM optimization guide for version 8.0 here:

MySQL :: MySQL 8.0 Reference Manual :: 8.6 Optimizing for MyISAM Tables

dev.mysql.com

so it seems like they expect it to work normally.

If you see this behavior in the future it would be worth submitting a ticket to our support team before any changes or fixes are applied so we could see the behavior in question.