Question

MariaDB Configuration - mysql tuner recommendations

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:

[mysqld]

query_cache_size = 0 query_cache_type = 0 query_cache_limit = 4M tmp_table_size = 32M max_heap_table_size = 32M thread_cache_size = 4 max_connections = 100 key_buffer_size = 16M max_allowed_packet = 1024M innodb_log_file_size=16M

performance_schema=ON

Any advice would be very welcome.

Thanks in advance

Colin

Subscribe
Share

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!

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.

Hi @colinshaun77Eel,

All of the mentioned recommendations would make your server only for MySQL/MariaDB and nothing else. Your MariaDB instance will take almost all of the RAM.

As for

Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1

I’m not a big fan of this, it has too many negatives as opposed to postivies so I’ll recommend leaving it out.

As for your configuration, we can’t know if it is okay. This depends on your website. If you are experiencing website issues or droplet’s issue you might need to look at changing it however if you aren’t, I’ll recommend leaving it as is.

Regards, KFSys