MySQL crashing now and then. Can u help me with log?

Hello, I’m facing some MySQL crashes. I’m on a Ubuntu 12.04.5 LTS X64 (The most basic droplet) and using “SELECT VERSION();” I got MySQL version 5.5.38-0ubuntu0.12.04.1

I have Zpanel installed, because for now I don’t have that many customers to use something as good as Cpanel. I have 3 sites on that server, my newest.

I don’t know what’s causing this crashes and maybe you guys could help out seeing the log. Can you? Please?

Log file:

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hello, @jntslvdrt

I will recommend you to examine the MySQL error_log as well, because this is likely to give you a more verbose error and point you in the right direction to see what exactly is causing the issue here.

The location of the error_log should be:

/var/log/mysqld.log or /var/log/mysql/error.log

If you’re unable to locate the error_log in this two locations you can double check your my.cnf file and see if the error_log is saved somewhere else.

What you can do is to examine the last logged entries in the log using tail

You can use either:

tail -f /var/log/mysqld.log and tail -f /var/log/mysql/error.log


tail -n 100 /var/log/mysqld.log and tail -n 100 /var/log/mysql/error.log

You can share the output of the log here so we can have a look.

You can also create a simple bash script to check if MySQL is running and if not to restart it.


# Check if MySQL is running
sudo service mysql status > /dev/null 2>&1

# Restart the MySQL service if it's not running.
if [ $? != 0 ]; then
    sudo service mysql restart

Run this script every 5 minutes using a cron job like this one:

 */5 * * * * /home/user/scripts/ > /dev/null 2>&1

Hope that this helps! Regards, Alex

Fuc* me! That’s why I do need to learn more about MySQL I don’t figured out nothing you said about it.

I’m planning to put each service (email, DB’s, Apache) into separated droplets as you advice. But actually I’m on Zpanel and this system is almost abandoned in favor of Sentora. So I can’t get support by now to split up these services into different droplets using Zpanel (Now Sentora). I’ll wait for official Sentora release.

I did resize my 512MB to 1GB (10$ bucks plan). But I still experiencing some crashes. I’m doing stress tests with and my droplet crashes about 20 simultaneous visitors. It seems that Apache is taking as much as RAM as MySQL. For now I’ll add swap into my 1GB droplet and see if it helps at all.