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?
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?
add swap 1gb is too less
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
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
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
Hosted by VirtuBox