Home / server / Questions / 701656
In Process
Hemant_Negi
Asked: 2015-06-26 08:53:32 +0800 CST

Reduce the amount of RAM used by MySQL

  • 772

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:

Htop snapshot

mysql

1 Answers

    1. Edit the my.cnf file and specify the amount of RAM MySQL is allowed to use
    2. Change the ib_data file to ensure that all databases create their own file. That way reading the database does not take as much RAM

    All these edits should be done in /etc/mysql/my.cnf.

    • -2