New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

mariadbd constantly crashing [FIXED, CLICK ME]

Started by hill, March 08, 2025, 03:09:58 AM

Previous topic - Next topic

hill

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

overseer

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