I have recently purchased a 1GB DigitalOcean Ubuntu 14.04 VPS and it is running a blog written in Python and Django.
I have installed NGINX and MySQL on the same machine.
My problem is that MySQL is consuming a lot of RAM, which is causing the system to crash. I know it's because of low RAM, but for now I want to continue with these configurations.
I read many posts about optimizing MySQL to use less memory, or about increasing the swap space.
I am using InnoDB storage engine.
Can you suggest what options I have or how I can reduce the amount of RAM used by MySQL .
Here is the screenshot of htop on the server:
