[FIXED] Optimization my.cnf for 100+ wp databases and low RAM usage

Issue

I have VDS: 6 cores and 10GB RAM with 150+ WordPress sites. All this things based on CentOS 7, ISPManager Web Panel with MariaDB 10.3 in Docker container. Sites are not highload, but 3 times per week container shutting down becose RAM is low. (OOM Killer killing it) What .my.cnf parametrs can you reccomend for optimal and low RAM usage? How i can stop this periodical container deaths that OOM Killer makes? Maybe some system tweaks of CentOS7? Tnx, sorry for mistakes.

Solution

There are many settings that can be decreased to help. innodb_buffer_pool_size is usually the biggest, hence the first one to tweak.

10GB of RAM -- What is in that? One MariaDB instance (with 150+ databases)? Plus WP app code?

Lower table_open_cache a little.

Please provide the GLOBAL STATUS and VARIABLEs as discussed here: http://mysql.rjweb.org/doc.php/mysql_analysis#tuning

swappiness = 1 may help.

Answered By - Rick James