Host
Operating system Ubuntu Linux 22.04.2
Webmin version 2.013
Usermin version 1.861
Virtualmin version 7.5
Using --LEMP (Nginx webserver)
Processor information AMD EPYC Processor (with IBPB), 4 cores
Running processes 229 CPU load averages 0.27 (1 min) 0.25 (5 mins) 0.20 (15 mins)
Real memory 2.44 GiB used / 1.11 GiB cached / 3.83 GiB total
Virtual memory 20.37 MiB used / 1023.99 MiB total
50-server.cnf (set by install script for large 4G system)
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
innodb_file_per_table = 1
max_allowed_packet = 64M
query_cache_size = 4M
thread_cache_size = 512
myisam_sort_buffer_size = 256M
read_rnd_buffer_size = 1M
read_buffer_size = 512K
sort_buffer_size = 4M
table_open_cache = 6000
key_buffer_size = 256M
This is a new server that I just set up a week or two ago. Everything works well, but for the first week, the ram usage would slowly climb after a boot (several hours to most of a day), until MariaDB crashed. I added swap, and it hasn’t crashed since, but this morning, both real and virtual memory were mostly used up. I rebooted, and it went back to low levels, and slowly started climbing again.
Previous installations had Mysql. This is the first using MariaDB. There are no logs under /var/log/mysql, and I haven’t found any other location for MariaDB logs.
It is possible that I am running too many virtual servers for this install, but I only added a few more from previous installs, and none are that busy. I don’t understand why memory usage would simply slowly climb.
Can anyone point me in the right direction for performance tuning MariaDB as it is set up on a Virtualmin box?
Here is what I get with htop:
Here is what I have turned on for reatures and plugins: