mariadb keeps crashing

jond1

I'm running on a 1gb VPS on DigitalOcean and mariadb keeps crashing

I tried to add supervisor to restart it, but that didn't work

any suggestions from anyone?

Endda

jond1 is your site throwing up a 'unable to connect to database' error when it happens?

I have SWAP set to 2GB on my VPS and I've been getting this lately

corus9

add swap 1gb is too less

jond1

I found these settings to be working quite effectively.

I edited /etc/mysql/conf.d/my.conf

[mysqld]
symbolic-links=0
#skip-external-locking
key_buffer_size = 32K
max_allowed_packet = 4M
table_open_cache = 8
sort_buffer_size = 128K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
net_buffer_length = 4K
thread_stack = 480K
#innodb_file_per_table
max_connections=100
max_user_connections=50
wait_timeout=50
interactive_timeout=50
long_query_time=5

Endda

jond1 I'm still getting mariadb crashes after using this .conf file
granted, they are happening less, but it's still happening

jond1

MariaDB has not crashed since implementing the above settings on my 1gb VPS, worth trying them out for you.

I use zero swap on my VPS

marty

It's amazing how much you can squeeze out of WO with a (decent) small vps.
There's also a useful thread on using MySQLTuner to optimize memory usage here:
https://community.wordops.net/d/1129-random-error-establishing-a-database-connection-but-no-errors-in-log