Hi all.

I am running CentOS 8 with nginx for wordpress. I have run the mysql tuner and below are the general recommendations:

*****General recommendations:
MySQL was started within the last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Dedicate this server to your database for highest performance.
Reduce or eliminate unclosed connections and network issues
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB

Any advice on how to do this, or if they can be ignored?

My server is 2gb 1 core ( $10 on DO )

My current my.cnf in my.cnf.d is below:


querycachesize = 0
querycachetype = 0
querycachelimit = 4M
tmptablesize = 32M
maxheaptablesize = 32M
cachesize = 4
connections = 100
keybuffersize = 16M
maxallowedpacket = 1024M


Any advice would be very welcome.

Thanks in advance


Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!