Alright, so after spending a week migrating to a new server, fixing all the configuration issues, tuning Apache for the traffic we're getting, I'm now at the step of optimizing websites and apps that now run SUPER SLOW compared to the old server and this is not normal since the new hardware is much faster than the old one, so it should not run slow.
I've spent yesterday isolating the issue and I'm 100% sure it's MySQL 8.0 InnoDB related. Any query, even a simple SELECT with indexes on all columns that are mentioned in the WHERE statement, no join, no sub-query, will take between 10 to 20 SECONDS (yes, twenty) where as the same query run under MySQL 5.7 will take 0.1s (zero point one second)
So clearly, something is way off with MySQL 8.0 or the configuration that came with WHM 116.0.9.
I went to phpMyAdmin and simply switched that table from InnoDB to MyISAM and the same query now takes 0.1s like it did as InnoDB under MySQL 5.7 before. So MyISAM looks to be running smoothly under MySQL 8.0 but InnoDB is absolutely not.
I would like to know what could be done apart from switching every single table of every domain on this server from InnoDB to MyISAM and never using InnoDB ever again under MySQL 8.0.36?
Please sign in to leave a comment.