This forum post has been removed
Number of replies: 6Re: MySql 5.6 upgrade to 5.7 and 8.0 - abysmal performance noted
If you were on Linux, I'd highly recommend installing and running MySQLTuner (perl based) to see what it might recommend for tweaks to DB server config. From 5.6 -> 5.7 or 8.0 things have changed ... some config tweaks that were needed for moodles on a 5.6 aren't needed with 5.7-> as those things are now defaults. Having some of those tweaks still active in my.cnf had actually had an adverse affect on DB performance.
Output of Tuner:
[OK] Maximum reached memory usage: 2.0G (26.83% of installed RAM)
[OK] Maximum possible memory usage: 2.2G (28.90% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/85M)
There is one that (from what you've described) probably needs checking:
From a sandbox server running multiple versions of Moodle and a WP blog:
[OK] InnoDB buffer pool / data size: 2.0G/255.1M
[OK] InnoDB buffer pool instances: 2
On a dedicated DB box, one could try to get all of the databases loaded into memory ... buffer pool and other related tweaks ... but the best I've ever been able to achieve is about 65% ... still though, that means less IO. ;)
'SoS', Ken
This forum post has been removed
Re: MySql 5.6 upgrade to 5.7 and 8.0 - abysmal performance noted
Am not aware of a tool like MySQLTuner on Windows, but here's a wild idea ... who says the dedicated DB server has to be Windows? Might be the perfect time to spin up a fairly beefy Ubuntu Linux server to use strictly as DB host for your moodles/WP's.
The other items ... for a dedicated MySQL DB server one would restrict access to it and it's databases to only the IP address of the code server. One could then turn off networking ... mysql does a DNS look up on every query.
Sometimes change is good!
'SoS', Ken
This forum post has been removed
Re: MySql 5.6 upgrade to 5.7 and 8.0 - abysmal performance noted
Ok. Understand now.
Did a google search ...
https://github.com/pmachapman/mysqltuner
For Windows!
'SoS', Ken