Hi everyone

I have a $10 droplet running on NGINX and MariaDB 10.3 for my own Wordpress blog. I might in the future add 1 more blog to the server, but that will be the maximum.

Anyhow, I need to create a my.cnf file for my.cnf.d

When I used CentOS 7 I could just use the my.medium or large etc, but with 8 I need to create my own.

Does anyone have a my.cnf I can use that will be a good place to start for my server?

I want it to be set so my blog can cope with a decent amount of traffic.

I am going to run MySQL tuner once set up and left for a few days, but just need a file to get started

Thanks in advance

Colin

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.

×
1 answer

Hi @colinshaun77Eel,

The 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 script’s 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.

Other than that, it’s not possible to suggest valid values as this depends on the traffic you get, on the queries you are executing and how often are they executed.

Regards,
KDSys

Submit an Answer