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?
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
i have the same issue