I want to know how to check disk, cpu and RAM usage of the managed MySQL and Postgresql database cluster?
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!
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,
To view performance metrics, click the name of the database to go to its Overview page, then click the Insights tab. The Select object drop-down menu lists the cluster itself and all the databases in the cluster. Choose the database cluster name instead of database name to view its metrics like CPU, Disk, RAM utilization.
For more information on Postgresql database, please refer: https://docs.digitalocean.com/products/databases/postgresql/how-to/monitor-databases/
For more information on MySQL database, please refer: https://docs.digitalocean.com/products/databases/mysql/how-to/monitor-clusters/
Regards Priyanka
Hi there,
A quick update here, DigitalOcean has introduced scrapable metrics for Managed PostgreSQL, MySQL, Redis, and Kafka. These metrics provide specific insights into database performance and can be exported to monitoring stacks like Prometheus.
PostgreSQL:
How-to Guide: Monitor PostgreSQL Database Cluster Performance
How To Guide: Monitor PostgreSQL Database Performance
MySQL:
How-to Guide: Monitor MySQL Database Cluster Performance
How To Guide: Monitor MySQL Database Performance
Redis:
How-to Guide: Monitor Redis Database Cluster Performance
How To Guide: Monitor Redis Database Performance
Kafka:
How-to Guide: Monitor Kafka Database Cluster Performance
How To Guide: Monitor Kafka Database Performance
The available metrics include:
Hope that this helps!
Best,
Bobby