I’m using the WordPress One-Click droplet (https://marketplace.digitalocean.com/apps/wordpress) with 2 cores and 4GB of RAM, and it’s running MySQL version 8.0.29, but unlike the previous setup found with Ubuntu 16.04 and MySQL 5.7, the my.cnf is pretty much empty.
This is the only thing in the my.cnf of mysql 8:
[mysqld]
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log
I’ve been having some mysql high cpu usage, and I want to make sure that I’m not missing any configuration.
So, how do I find out which are the right settings that I should be using for WordPress site?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi @mhweb,
We’ll the optimization of MySQL is usually a trial and error kind of stuff however there are different tools that can help you out. Me personally, I’ll recommend checking out the ‘MySQL Tunner’ one. The MySQLTunerscript assesses your MySQL installation, and then outputs suggestions for increasing your server’s performance and stability.
1.Download the MySQLTuner script:
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
Change the scripts permissions to be executable:
chmod +x mysqltuner.pl
Run the mysqltuner.pl script. You will be prompted to enter in your MySQL administrative login and password:
./mysqltuner.pl
The script will return results/suggestions which you can follow the optimize your MySQL.
Regards, KDSys
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.