I recently upgraded from a Gen 3 to Gen 4 GoDaddy VPS, and now all of mySQL queries are all taking about 3 times longer to run.
I’ve tried the following:
Are there any configurations I might be missing that could affect how fast mySQL processes queries, and/or are there any specific issues I could ask GoDaddy to look at to improve speeds on their end?
I’ve tried the following:
- I’ve tested sites using the exact same versions of mySQL(5.7) PHP(7.3) .
- I’ve gone through all of the WHM tweak settings and they are all the same (except for where features are new or no longer exist which I left as default).
- I’ve provisioned everything to use the exact same PHP/Ruby extensions using Easyapache.
- I’ve verified the site migration tool did not drop any Indexes, Keys, Datatypes, etc when bringing my tables over.
- I’ve verified that mySQL is using the same configurations between servers in the my.conf file.
- I’ve tried disabling Munin and ImnuifyAV which were not on the old server.
- I've tried running queries from phpMyAdmin to rule out application level issues, but phpMyAdmin is seeing the same slowdown issue.
- I've tried running a number of different queries to see if it's only affecting certain kinds of queries, and it seems to be all queries are running slower.
- Non-mySQL related tasks on the new server all seem to be running as fast or faster than the old one.
- The New server is running Cent OS 7.9 instead 6.10
- The New server is running WHM/cPanel v92.0.11 instead of v86.0.37
- The New server has twice as much memory and twice as many processors as the old one. (The server is not having any major memory or processor spikes; so, I'm not running out of system resources.)
- I've run network speed tests and the new server's internet connection is about 3 times as fast.
Are there any configurations I might be missing that could affect how fast mySQL processes queries, and/or are there any specific issues I could ask GoDaddy to look at to improve speeds on their end?