GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.UnderprovisionedRecommender/recommendations
다음을 바꿉니다.
PROJECT_ID: 프로젝트 ID입니다.
LOCATION: 리전(예: us-central1)
추천자에서 과소 프로비저닝된 인스턴스를 감지하면 테이블에 나열합니다. 각 행에는 인스턴스 이름, 간단한 권장사항, 현재 머신 유형, 권장 머신 유형, 위치, 마지막 새로고침 날짜가 표시됩니다.
통계 및 자세한 권장사항 보기
콘솔
Google Cloud 콘솔을 사용하여 초과 프로비저닝된 인스턴스에 대한 통계와 자세한 추천을 보려면 인스턴스 목록에서 추천 버튼을 클릭합니다.
gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.INSIGHT_TYPE
다음을 바꿉니다.
PROJECT_ID: 프로젝트 ID입니다.
LOCATION: 리전(예: us-central1)
INSIGHT_TYPE: 통계 유형의 ID는 UnderprovisionedCpuUsageInsight, UnderprovisionedMemoryUsageInsight, OomProbabilityInsight이며, 각각 CPU 사용률, 메모리, OOM 확률에 대한 통계를 제공합니다.
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/insights
다음을 바꿉니다.
PROJECT_ID: 프로젝트 ID입니다.
LOCATION: 리전(예: us-central1)
INSIGHT_TYPE: 통계 유형의 ID는 UnderprovisionedCpuUsageInsight, UnderprovisionedMemoryUsageInsight, OomProbabilityInsight이며, 각각 CPU 사용률, 메모리, OOM 확률에 대한 통계를 제공합니다.
다음 표에서는 Cloud SQL 과소 프로비저닝 인스턴스 추천자가 높은 CPU 및 메모리 사용률로 인한 병목 현상을 방지하고 메모리 부족 이벤트의 가능성을 최소화하는 데 도움이 될 수 있는 인사이트 및 추천을 보여줍니다.
하위 유형은 gcloud 및 API 결과에 표시됩니다.
통계
추천
현재 CPU 사용률 추세를 기준으로 인스턴스의 CPU 사용률이 높은 것으로 플래그 지정됩니다.
하위 유형: HIGH_CPU_UTILIZATION
CPU 크기를 늘리거나 CPU 사용률을 줄입니다.
하위 유형: CHANGE_INSTANCE_SIZE
현재 메모리 사용률 추세를 기준으로 인스턴스가 메모리 사용률이 높은 것으로 플래그 지정됩니다.
하위 유형: HIGH_MEMORY_UTILIZATION.
메모리 크기를 늘리거나 메모리 사용률을 줄입니다.
하위 유형: CHANGE_INSTANCE_SIZE
현재 사용률 추세를 기준으로 인스턴스가 향후 OOM 이벤트가 발생할 위험이 있는 것으로 플래그 지정됩니다.
하위 유형: HIGH_OOM_PROBABILITY.
메모리 크기를 늘리거나 메모리 사용률을 줄입니다.
하위 유형: CHANGE_INSTANCE_SIZE
필요한 경우 인스턴스를 수정하여 vCPU 또는 메모리를 늘립니다. 또는 vCPU와 메모리가 더 많은 머신 유형으로 전환합니다. 인스턴스 크기를 올바르게 조정할 필요는 없습니다. 인스턴스 프로비저닝 방법에 따라 인스턴스 크기를 판단하여 조정합니다.
크기가 클수록 운영 지연 시간이 길어집니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-08-13(UTC)"],[],[],null,["# Reduce underprovisioned Cloud SQL instances\n\n\u003cbr /\u003e\n\nMySQL \\| [PostgreSQL](/sql/docs/postgres/recommender-underprovisioned \"View this page for the PostgreSQL database engine\") \\| [SQL Server](/sql/docs/sqlserver/recommender-underprovisioned \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThe underprovisioned instance [recommender](/recommender/docs/overview)\nhelps you detect instances that have high CPU and/or memory utilization.\nIt then provides recommendations for how to optimize the instance.\nThis page describes how this recommender works and how to use it.\n\nHow it works\n------------\n\nWhen there is high CPU and/or memory utilization detected, you see a recommendation to increase the size of your instance to reduce CPU and/or memory utilization at peak.\n| **Note:** Recommendations are generated daily.\n\nPricing\n-------\n\nThe underprovisioned instance recommender is in the Standard\n[Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\nBefore you can view recommendations and insights, do the following:\n\n- Ensure that you have the required [roles](/sql/docs/mysql/project-access-control#roles) so that you have permission to view and work with insights and recommendations.\n\n For more information about roles, see [understanding roles](/iam/docs/understanding-roles) and [granting IAM permissions](/iam/docs/granting-changing-revoking-access).\n-\n\n\n Enable the Recommender API.\n\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=recommender.googleapis.com)\n\nList underprovisioned instance recommendations\n----------------------------------------------\n\n### Console\n\nTo list recommendations about underprovisioned instances, follow these steps:\n\n1. Go to the **Cloud SQL Instances** page.\n\n [Go to Cloud SQL Instances](https://console.cloud.google.com/sql/instances)\n2. Click **View all** on the resize Cloud SQL instance recommender banner.\n\nAlternatively, follow these steps:\n\n1. Go to the **Recommendation Hub**.\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n\n For more information, see\n [Getting started with Recommendation Hub](/recommender/docs/recommendation-hub/identify-configuration-problems).\n2. In the **Resize Cloud SQL instances to improve performance** card, click **View all**.\n\n3. Click the instances with the **Resize Cloud SQL instance** recommendation.\n\n### gcloud\n\nTo list recommendations about underprovisioned instances, run the\n[`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list)\ncommand as follows: \n\n```\ngcloud recommender recommendations list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--recommender=google.cloudsql.instance.UnderprovisionedRecommender\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n\n### API\n\nTo list recommendations about underprovisioned instances by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.UnderprovisionedRecommender/recommendations\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n\nIf the recommender detects underprovisioned instances, it lists them in a\ntable. Each row shows the instance name, a brief recommendation, the current machine type,\nthe recommended machine type, the location, and the last refresh date.\n\nView insights and detailed recommendations\n------------------------------------------\n\n### Console\n\nTo view insights and detailed recommendations about an underprovisioned instance by using the\nGoogle Cloud console, click the recommendation button in the list of instances.\n\n### gcloud\n\nTo view insights and detailed recommendations about underprovisioned instances by using `gcloud`, run the\n[`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list)\ncommand as follows: \n\n```\ngcloud recommender insights list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.INSIGHT_TYPE\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n- \u003cvar translate=\"no\"\u003eINSIGHT_TYPE\u003c/var\u003e: The ID of the insight type is `UnderprovisionedCpuUsageInsight`, `UnderprovisionedMemoryUsageInsight`, or `OomProbabilityInsight`, which provide insights about CPU usage, memory, and OOM probability, respectively.\n\n### API\n\nTo view insights and detailed recommendations about underprovisioned instances by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/insights\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n- \u003cvar translate=\"no\"\u003eINSIGHT_TYPE\u003c/var\u003e: The ID of the insight type as \\``UnderprovisionedCpuUsageInsight`, `UnderprovisionedMemoryUsageInsight`, or `OomProbabilityInsight`, which provide insights about CPU usage, memory, and OOM probability, respectively.\n\nThe following table lists the insights and recommendations that the Cloud SQL\nunderprovisioned instance recommender might generate to help you avoid bottlenecks from high CPU and memory\nusage and minimize the likelihood of out-of-memory events.\nThe subtypes are visible in the `gcloud` and API results.\n\nApply recommendations\n---------------------\n\nEvaluate the recommendations carefully and do any of the following:\n\n- To examine the recommendation, click **View instance**.\n\n A banner appears at the top of the page providing a recommendation.\n- To dismiss the recommendation so that it's de-emphasized and appears dimmed,\n click **Dismiss**.\n\n- To close the panel without applying or dismissing the recommendation, click\n **Cancel**.\n\n### Optimize the performance of your instance\n\nTo optimize your instance's performance, do the following:\n\n- [Optimize high memory usage](/sql/docs/mysql/optimize-high-memory-usage)\n\n- [Optimize high CPU usage](/sql/docs/mysql/optimize-cpu-usage)\n\n- [Create read replicas](/sql/docs/mysql/replication/create-replica).\n\n | **Caution:** This operation can lead to an increase in cost.\n\n\u003c!-- --\u003e\n\n- [Edit](/sql/docs/mysql/edit-instance) the instance, if required, to\n increase the vCPUs or memory. Alternatively, switch to a machine type with more\n vCPUs and more memory. You don't need to rightsize the instance exactly as recommended. Use your\n judgement and resize based on how you intend to provision the instance.\n Keep in mind that the bigger the size, the greater the operational latency.\n\n | **Caution:** This operation can lead to an increase in cost. Additionally, it triggers a restart, which brings downtime to the instance.\n\nYou can also [export these recommendations to BigQuery](/recommender/docs/bq-export/export-recommendations-to-bq)\nand then examine them using [Looker Studio](/bigquery/docs/visualize-looker-studio) or [Looker](/bigquery/docs/looker).\n\nWhat's next\n-----------\n\n- [Monitor disk availability](/sql/docs/mysql/using-ood-recommender)\n- [Reduce idle Cloud SQL instances](/sql/docs/mysql/recommender-sql-idle)\n- [Blog: Maximize your Cloud ROI](https://cloud.google.com/blog/products/management-tools/active-assist-comes-to-google-cloud)\n- [Blog: Do more with less](https://cloud.google.com/blog/products/databases/reduce-cloud-sql-costs-with-optimizations-by-active-assist)\n- [Google Cloud recommenders](/recommender/docs/recommenders)"]]
