Keep running out of memory, mysql dies

December 24, 2014 2.2k views

My site needs more memory because mysql keeps dying from memory issues (according to syslog). I have a swap file but it doesn't seem to help. I also have a 1gb droplet -- how can I get more memory? Should I resize? Basic wordpress site, ~3000 visits/day

  • Have you considered lowering your droplet tier level, then setting up load balancing. Spinning up droplets as needed during high volume traffic. Then destroying them when traffic is low enough to be handled by a single droplet.

  • How big is your swap ??

    Try to reduce the swap down to 512MB if its larger in size, and since its wordpress consider caching, plug ins like W3TC may help lowering the load

  • I have the same problem and tried a number of suggestions, including upgrading to a 1GB droplet, adding a swap file etc.. same problem.

    I ended up creating an account here , transferred a copy of my site and it cleared up the problem, improved the performance dramatically and provided us with 24/7 support. This is one of those things where you get what you pay for.

1 Answer

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

WordPress is a popular and powerful CMS (content management system) platform. Its popularity can bring unwanted attention in the form of malicious traffic specially targeted at a WordPress site. There are many instances where a server that has not been protected or optimized could experience issues or errors after receiving a small amount of malicious traffic. This guide will show you how to protect WordPress from XML-RPC attacks on an Ubuntu 14.04 system.
Have another answer? Share your knowledge.