Control Web Panel

WebPanel => Information => Topic started by: hill on March 08, 2025, 03:09:58 AM

Title: mariadbd constantly crashing [FIXED, CLICK ME]
Post by: hill on March 08, 2025, 03:09:58 AM

i have a low resource server with only a few gb memory, kept seeing database lost connection to wordpress and when running dmesg i would also see database server run out of resources, checking every area within CWP there was no area to increase memory allocation

so i edited the my.conf file found under /etc/my.confd/  and added the following under the [mysqld] area, ever since doing this its been good

hopefully it helps others having a similar problem

default-storage-engine = InnoDB
innodb_flush_method = O_DIRECT
innodb_log_file_size = 128M
innodb_buffer_pool_size = 128M
max_allowed_packet = 128M
max_connections = 200
key_buffer_size = 256M
tmp_table_size = 64M
max_heap_table_size = 64M

Title: Re: mariadbd constantly crashing [FIXED, CLICK ME]
Post by: overseer on March 08, 2025, 12:47:33 PM

Also consider MySQL tuning scripts that can recommend other parameters that may help your situation:
https://github.com/major/MySQLTuner-perl (https://github.com/major/MySQLTuner-perl)