instance yang tidak disediakan Pemberi rekomendasi
akan membantu Anda mendeteksi instance yang memiliki pemakaian CPU dan/atau memori tinggi.
Alat ini kemudian memberikan rekomendasi tentang cara mengoptimalkan instance tersebut.
Halaman ini menjelaskan cara kerja pemberi rekomendasi ini dan cara menggunakannya.
Cara kerja Duet AI
Jika terdeteksi pemakaian CPU dan/atau memori yang tinggi, Anda akan melihat rekomendasi untuk meningkatkan ukuran instance guna mengurangi pemakaian CPU dan/atau memori pada puncaknya.
gcloud recommender recommendations list \
--project=PROJECT_ID \
--location=LOCATION \
--recommender=google.cloudsql.instance.UnderprovisionedRecommender
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
API
Untuk menampilkan daftar rekomendasi terkait instance yang tidak disediakan menggunakan Recommendations API, panggil metode recommendations.list seperti berikut:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.UnderprovisionedRecommender/recommendations
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
Jika mendeteksi instance tidak disediakan, pemberi rekomendasi akan menampilkannya dalam
tabel. Setiap baris menampilkan nama instance, rekomendasi singkat, jenis mesin saat ini,
jenis mesin yang direkomendasikan, lokasi, dan tanggal pembaruan terakhir.
Lihat insight dan rekomendasi mendetail
Konsol
Untuk melihat insight dan rekomendasi mendetail tentang instance yang tidak disediakan menggunakan
konsolGoogle Cloud , klik tombol rekomendasi dalam daftar instance.
gcloud
Untuk melihat insight dan rekomendasi mendetail tentang instance yang tidak disediakan menggunakan gcloud, jalankan perintah
gcloud recommender insights list
seperti berikut:
gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.INSIGHT_TYPE
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
INSIGHT_TYPE: ID jenis insight adalah
UnderprovisionedCpuUsageInsight, UnderprovisionedMemoryUsageInsight, atau OomProbabilityInsight,
yang memberikan insight tentang penggunaan CPU, memori, dan probabilitas OOM.
API
Untuk melihat insight dan rekomendasi mendetail tentang instance yang tidak disediakan menggunakan
Recommendations API, panggil metode
insights.list
sebagai berikut:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/insights
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
INSIGHT_TYPE: ID jenis insight sebagai `UnderprovisionedCpuUsageInsight,
UnderprovisionedMemoryUsageInsight, atau OomProbabilityInsight,
yang memberikan insight tentang penggunaan CPU, memori, dan probabilitas OOM.
Tabel berikut berisi insight dan rekomendasi yang dapat dihasilkan oleh pemberi rekomendasi instance
yang tidak disediakan oleh Cloud SQL untuk membantu Anda menghindari bottleneck akibat penggunaan CPU dan memori
yang tinggi serta meminimalkan kemungkinan peristiwa kehabisan memori.
Subjenis terlihat di hasil gcloud dan API.
Insight
Rekomendasi
Berdasarkan tren pemakaian CPU saat ini, instance ditandai
memiliki penggunaan CPU yang tinggi.
Subjenis: HIGH_CPU_UTILIZATION
Meningkatkan ukuran CPU atau mengurangi penggunaan CPU.
Subjenis: CHANGE_INSTANCE_SIZE
Berdasarkan tren pemakaian memori saat ini, instance ditandai
memiliki penggunaan memori yang tinggi.
Subjenis: HIGH_MEMORY_UTILIZATION.
Tambah ukuran memori atau kurangi penggunaan memori.
Subjenis: CHANGE_INSTANCE_SIZE
Berdasarkan tren penggunaan saat ini, instance tersebut ditandai
sebagai berisiko menimbulkan peristiwa OOM di masa mendatang.
Subjenis: HIGH_OOM_PROBABILITY.
Tambah ukuran memori atau kurangi penggunaan memori.
Subjenis: CHANGE_INSTANCE_SIZE
Menerapkan rekomendasi
Evaluasi rekomendasi dengan cermat dan lakukan salah satu tindakan berikut:
Untuk memeriksa rekomendasi, klik Lihat instance.
Banner akan muncul di bagian atas halaman yang memberikan rekomendasi.
Untuk menolak rekomendasi agar tidak ditekankan dan tampak redup,
klik Tolak.
Untuk menutup panel tanpa menerapkan atau menolak rekomendasi, klik
Batal.
Mengoptimalkan performa instance
Untuk mengoptimalkan performa instance, lakukan hal berikut
Edit instance, jika perlu, untuk
meningkatkan vCPU atau memori. Atau, beralihlah ke jenis mesin dengan lebih banyak
vCPU dan memori yang lebih besar. Anda tidak perlu menyesuaikan ukuran instance persis seperti yang direkomendasikan. Gunakan penilaian
Anda dan ubah ukuran berdasarkan cara Anda ingin menyediakan instance.
Perlu diingat bahwa makin besar ukurannya, makin besar latensi operasionalnya.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-19 UTC."],[],[],null,["# Reduce underprovisioned Cloud SQL instances\n\n\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/recommender-underprovisioned \"View this page for the MySQL database engine\") \\| PostgreSQL \\| [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/postgres/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 CPU usage](/sql/docs/postgres/optimize-cpu-usage)\n\n- [Optimize high memory usage](/sql/docs/postgres/optimize-high-memory-usage)\n\n- [Optimize the query performance of your instance](/sql/docs/postgres/using-query-insights).\n\n- [Create read replicas](/sql/docs/postgres/replication/create-replica).\n\n | **Caution:** This operation can lead to an increase in cost.\n\n\u003c!-- --\u003e\n\n- [Edit](/sql/docs/postgres/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/postgres/using-ood-recommender)\n- [Reduce idle Cloud SQL instances](/sql/docs/postgres/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)"]]
