mariadbd constantly crashing [FIXED, CLICK ME]

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

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