I created droplet in Digital Ocean With Debian 7. After 10 Days Mysql Server Stop Very Frequently in Digital Ocean Every day. I also use command service mysql restart
and nothing happened.
So i try this solution
root@myserver:~# dd if=/dev/zero of=/swap.dat bs=1024 count=512k
root@myserver:~# mkswap /swap.dat
root@myserver:~# swapon /swap.dat
root@myserver:~# nano /etc/fstab
And edit fstab, add the following code
/swap.dat none swap sw 0 0
And add this under [mysqld]
innodb_buffer_pool_size=64M
Finally reload mysql
root@myserver:~# service mysql reload
Thanks i hope this will help you.. :D
Mysql Server Stops Very Frequently in Digital Ocean Droplet