mysql keeps crashing, how to solve it?

I am using a very simple digitalocean basic server with 512mb RAM, and using Ubuntu 12.04 64bits

I tried the recommendations here:

https://www.digitalocean.com/community/questions/mysql-on-ubuntu-keeps-crashing

But still keeps crashing, so I have looked for further information, and this one seems to be a good guide to tweak the server, both apache and mysql:

https://library.linode.com/troubleshooting/memory-networking#sph_apache-2-low-memory-settings

I think that the key point for me is that I chose Ubuntu 64 bits without being aware that 64 bits Ubuntu takes around 50% more memory than 32 bits

So now I guess the solution is to downgrade to a 32bit server, which will be a bit of a pain… but if this solves the performance issue, then I will surely do it.

 

 

Advertisements

4 thoughts on “mysql keeps crashing, how to solve it?

    • I have not been able to solve it properly in 64bit. It has only improved when I installed the WP Super Cache plugin, but if I deactivate it it will crash again. But I am planning to downgrade to 32bit as soon as I find a bit of time…
      Let me know if you find a better solution.

      • Hi Tyler, i have seen that the problem is highly related to ram. With the entry 512mb plan of DigitalOcean is not enough, and even less if the Ubuntu version is 64bit. I reinstalled a 32bit that is less memory demanding, and raised to 1giga ram. It does not crash now. Using cache plugins for wordpress did also help!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s