By heNMJ
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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.