I had the same issue, with a 2GB droplet size. Tried everything and eventually discovered it was an XML-RPC attack (Wordpress related).

Check this article for help:
How To Protect WordPress from XML-RPC Attacks on Ubuntu 14.04

Most likely this due to running out of memory. Take a look through /var/log/syslog for any messages from the kernel’s Out Of Memory (OOM) killer.

MySql logs are sometimes also found in /var/log/mysql.log and /var/log/mysql.err instead of the /var/log/mysql/ directory. They might provide some hints.

If you haven’t done so already, you should add a swap file to give yourself some leeway when your memory consumption grows.

Perhaps try specifying a log file in /etc/mysql/my.cnf as follows:

general_log_file      = /var/log/mysql/mysql.log
general_log             = 1

I’m also guessing memory issues.

Currently having this problem as well. Just added swap, but now my 512MB droplet has become seriously slow and my site wont even open.

Will try the other stuff adityars suggested.

Hi,

We are having the same issue here. I find lots of forum posts about the same issue, but no ‘official’ recommendation… just 'try this’, 'could be that’, 'perhaps its..’.

PLEASE is there any procedure to follow in order to know 1) what´s causing the issue and 2) take proper action?

thks for your time.

I had mysql crashing every 30 minutes exactly. Turns out mysql installs on Windows still default the flushtime to 1800 seconds (on nix boxes this value defaults to 0). Normally this is not a problem, but because I was using federated tables it was a problem. I guess mysql doesn’t know how to flush federated tables, therefore crash. So I set flushtime = 0 in my.ini and the problem went away.

This bug has been reported here: https://bugs.mysql.com/bug.php?id=47525&thanks=3&notify=87

Hello,

What you can also do is to use the MySQLTuner script.

The MySQLTuner is a script written in Perl and allows you to quickly test your MySQL configuration and it gives you suggestions for adjustments to increase performance and stability.

According to the official GitHub page, it supports 300 indicators for MySQL/MariaDB/Percona Server in this last version.

To run the script you could do the following:

• SSH to your Droplet
• Download the script:

wget http://mysqltuner.pl/ -O mysqltuner.pl

• Then execute it:

perl mysqltuner.pl

The script would run multiple checks against your MySQL instance, all checks done by MySQLTuner are documented here.

Also as stated in the official documentation, it is still extremely important for you to fully understand each change you make to a MySQL database server. If you don’t understand portions of the script’s output, or if you don’t understand the recommendations, you should consult a knowledgeable DBA or system administrator that you trust.

As a good practice make sure to always test your changes on staging environments before implementing them on your production database.

On the same note, if you want to have a worry-free MySQL hosting and focus on your application, I would recommend trying out the DigitalOcean Managed Databases:

https://www.digitalocean.com/products/managed-databases-mysql/

This was mini tutorial was posted from @bobbyiliev in this question in our community: https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability

Hope that this helps!
Regards,
Alex