Google Cloud SQL Resize Over-Provisioned Instances
Prerequisite: To use this check, you must set up a GCP Recommender connection.
CloudZero has identified Google Cloud SQL instances that are over-provisioned and could be resized to better match your actual workload requirements. These instances are running with more CPU and memory than needed, resulting in unnecessary costs.
Google's Overprovisioned Recommender analyzes CPU and memory utilization patterns over the past 30 days for primary instances older than 30 days. It identifies instances with low peak utilization and suggests resizing to more cost-effective machine types. Recommendations are generated daily for instances with estimated monthly savings of at least $10.
Recommendations
- Review the suggested machine types - Google's recommendations are based on your actual CPU and memory usage patterns over the past 30 days
- Test in a non-production environment first - Validate that the recommended machine type meets your database performance requirements
- Consider workload patterns - Ensure the new machine type can handle peak loads, query complexity, and connection counts
- Monitor performance after changes - Use Cloud Monitoring to verify that resizing doesn't impact database performance or query latency
- Apply changes during maintenance windows - Plan instance resizing to minimize disruption to running applications
- Note exclusions - The recommender only analyzes primary instances; read replicas and high availability configurations are excluded
Note: This recommender supports MySQL, PostgreSQL, and SQL Server instances. Resizing is particularly effective for development, testing, and workloads with predictable utilization patterns.
For more details:
Updated about 2 hours ago