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!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $100 of credit to try our products over 60 days!