How to find out the best MySQL 8 settings should I set in my.cnf
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?
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.×