Question

Managed MYSQL high memory usage

Is it normal for a managed mysql database to have memory usage of 89% all the time? We have 4GB of RAM and the CPU is idle but the memory is high.

Is it possible to restart the managed mysql process to see if it frees up the memory? If so how?

Subscribe
Share

i have the same issue


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

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.

Hi there,

I believe that this is quite standard for MySQL servers, both managed and unmanaged. When MySQL starts, it allocates buffers and caches directly into memory. That way it improves the performance of database operations.

Here are a couple of useful commands that you could use to check your server status and storage engine status:

  • Show your storage engine status:
SHOW ENGINE INNODB STATUS\G
  • Check the server status:
SHOW GLOBAL STATUS \G

The two commands will give you a better overview of the status of your cluster.

You can also check your current query process list with the following command in order to see if your cluster is busy:

SHOW [FULL] PROCESSLIST;

For more information on the server status variables, I would suggest going through the official MySQL documentation here:

https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html

Hope that this helps. Regards, Bobby