Cloud SQL
Cloud SQL Right Sizing
This recommendation identifies low memory/cpuu utilization of Cloud SQL that can be stoped or deleted.
Recommendation Logic
Trigger when:
- CPU utilization < X% (default 30%).
- Memory usage < Y% (default 30%).
- Spare Capacity < X% (default 30%).
- Instance running but no connections, user_connections = 0.
Estimated Savings
Current instance cost – recommended instance cost.
- The Cloud SQL Admin API must be enabled on the GCP project.
1. Open the Google Cloud Console [API Library] (https://console.cloud.google.com/apis/library).
2. Select your target project from the top drop-down menu.
3. Search for "Cloud SQL Admin API" in the search bar.
4. Click on the Cloud SQL Admin API result.
5. Click the blue ENABLE button. - Predefined role :roles/cloudsql.viewer.
- If you are using a custom IAM role instead of predefined roles, the individual permissions to add are:
1. cloudsql.instances.list
2. cloudsql.tiers.list
- Days To Check, default=30 days.
- CPU Utilization Threshold (%), default=30.
- CPU Spare Capacity (%), default=30.
- Memory Utilization Threshold (%), default=30.
- Memory Spare Capacity (%), default=5.
Umbrella.
No.
Updated about 1 month ago
Did this page help you?
