Pemberi rekomendasi instance Cloud SQL yang tidak aktif membantu
Anda mendeteksi instance yang mungkin tidak aktif serta memberikan
insight dan rekomendasi untuk membantu Anda mengurangi biaya. Halaman ini menjelaskan cara
kerja pemberi rekomendasi ini dan cara menggunakannya.
Cara kerjanya
Pemberi rekomendasi instance Cloud SQL yang tidak aktif menganalisis metrik penggunaan
instance utama yang lebih dari 30 hari. Untuk setiap instance, pemberi rekomendasi
mempertimbangkan nilai metrik tertentu
dalam periode observasi yang mencakup 30 hari terakhir. Pemberi rekomendasi tidak
menganalisis replika baca.
Jika level aktivitas dalam periode observasi di bawah batas tertentu,
pemberi rekomendasi akan memperkirakan bahwa instance tersebut tidak aktif. Rekomendasi
dibuat setiap 24 jam untuk mematikan instance tersebut.
Di kartu Kurangi biaya instance Cloud SQL, klik Lihat semua.
Klik tab Matikan instance.
gcloud
Untuk mencantumkan rekomendasi tentang instance yang tidak aktif menggunakan gcloud, jalankan perintah
gcloud recommender recommendations list
sebagai berikut:
gcloud recommender recommendations list \
--project=PROJECT_ID \
--location=LOCATION \
--recommender=google.cloudsql.instance.RECOMMENDER
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
RECOMMENDER: ID pemberi rekomendasi sebagai IdleRecommender.
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.RECOMMENDER/recommendations
Ganti kode berikut:
PROJECT_ID: ID Project Anda.
LOCATION: Region, seperti us-central1.
RECOMMENDER: ID pemberi rekomendasi sebagai IdleRecommender.
Jika mendeteksi instance yang tidak aktif, pemberi rekomendasi akan mencantumkannya dalam
tabel. Setiap baris menampilkan nama instance, rekomendasi singkat, lokasi,
dan tanggal pembaruan terakhir.
Lihat insight dan rekomendasi mendetail
Anda dapat melihat insight dan rekomendasi mendetail tentang instance yang tidak aktif dengan
menggunakan konsol Google Cloud , gcloud, atau Recommender API.
Konsol
Untuk melihat insight tentang instance yang tidak aktif menggunakan
konsolGoogle Cloud , klik tombol rekomendasi dalam daftar instance.
gcloud
Untuk melihat insight dan rekomendasi mendetail tentang instance yang tidak aktif 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 dari jenis insight ActivityInsight.
API
Untuk melihat insight dan rekomendasi mendetail tentang instance yang tidak aktif 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 dari jenis insight ActivityInsight.
Panel yang menampilkan insight tentang instance yang tidak aktif akan muncul. Kategori informasi
berikut disediakan beserta beberapa diagram pendukung.
Kolom
Deskripsi dan metrik terkait
Penggunaan disk (perubahan byte)
Pemakaian data dalam byte. Dibuat sampelnya setiap 60 detik.
Berlaku untuk database/disk/bytes_used.
Pemakaian CPU maksimum
Pemakaian CPU maksimum dalam persentase.
Berlaku untuk database/cpu/utilization.
Pemakaian memori maksimum
Pemakaian memori maksimum dalam persentase.
Berlaku untuk database/memory/utilization.
Jumlah operasi baca disk maksimum
Jumlah maksimum operasi baca.
Berlaku untuk database/disk/read_ops_count.
Jumlah operasi tulis disk maksimum
Jumlah maksimum operasi tulis.
Berlaku untuk database/disk/write_ops_count.
Tanggal mulai dan berakhirnya pengamatan
Tanggal mulai dan berakhirnya periode observasi 30 hari.
Tabel berikut mencantumkan insight dan rekomendasi yang mungkin dihasilkan oleh
pemberi rekomendasi instance tidak aktif Cloud SQL untuk membantu Anda mengurangi biaya. Subjenis
akan terlihat di hasil gcloud dan API.
Insight
Rekomendasi
Instance telah menunjukkan level aktivitas yang rendah
selama periode observasi.
Subjenis: LOW_ACTIVITY
Selidiki untuk memeriksa apakah instance dapat
dimatikan untuk mengurangi biaya.
Subjenis: SHUTDOWN_INSTANCE
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.
Anda mungkin mendapati bahwa instance sengaja tidak aktif dan Anda tidak perlu
mematikannya. Jika tidak ada aktivitas yang tidak disengaja, Anda dapat menghentikan
dan menghapus instance. Memberhentikan
instance akan menangguhkan biaya instance. Data instance tidak akan terpengaruh,
serta biaya untuk penyimpanan dan alamat IP akan terus berlaku.
[[["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-09-04 UTC."],[],[],null,["# Identify idle Cloud SQL instances\n\n\u003cbr /\u003e\n\nMySQL \\| [PostgreSQL](/sql/docs/postgres/recommender-sql-idle \"View this page for the PostgreSQL database engine\") \\| [SQL Server](/sql/docs/sqlserver/recommender-sql-idle \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\nThe Cloud SQL idle instance [recommender](/recommender/docs/overview) helps\nyou detect instances that might be idle and provides you\ninsights and recommendations to help you reduce costs. This page describes how\nthis recommender works and how to use it.\n\nHow it works\n------------\n\nThe Cloud SQL idle instance recommender analyzes the usage metrics of primary\ninstances that are older than 30 days. For each instance, the recommender\nconsiders the values of certain [metrics](/monitoring/api/metrics_gcp_c#gcp-cloudsql)\nwithin an observation period spanning the last 30 days. The recommender does not\nanalyze read replicas.\n\nIf the activity level within the observation period is below a certain\nthreshold, the recommender estimates that the instance is idle. Recommendations are\ngenerated every 24 hours for shutting down such instances.\n| **Warning:** It's highly recommended that you evaluate the insights and in-context charts. Consult with the appropriate team to determine whether the flagged instance is inadvertently idle and can be deleted.\n\nPricing\n-------\n\nThe Cloud SQL idle instance recommender is in the *Standard* [Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\nBefore you can view recommendations and insights, do the following:\n\n- To get the permissions to view and work with insights and recommendations, ensure that you have the required [roles](/sql/docs/mysql/project-access-control#roles).\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 idle Cloud SQL instance recommendations\n--------------------------------------------\n\nYou can list idle instance recommendations by\nusing the Google Cloud console, `gcloud`, or the Recommender API. \n\n### Console\n\nTo list recommendations about idle instances by using the\nGoogle Cloud console, 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 idle instance recommendations 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 **Reduce Cloud SQL instance cost** card, click **View all**.\n\n3. Click the **Shut down instance** tab.\n\n### gcloud\n\nTo list recommendations about idle instances by using `gcloud`, 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.RECOMMENDER\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\"\u003eRECOMMENDER\u003c/var\u003e: The ID of the recommender as `IdleRecommender`.\n\n### API\n\nTo list recommendations about idle 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.RECOMMENDER/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- \u003cvar translate=\"no\"\u003eRECOMMENDER\u003c/var\u003e: The ID of the recommender as `IdleRecommender`.\n\nIf the recommender detects idle instances, it lists them in a\ntable. Each row shows the instance name, a brief recommendation, the location,\nand the last refresh date.\n\nView insights and detailed recommendations\n------------------------------------------\n\nYou can view insights and detailed recommendations about idle instances by\nusing the Google Cloud console, `gcloud`, or the Recommender API. \n\n### Console\n\nTo view insights about an idle 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 idle 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 as `ActivityInsight`.\n\n### API\n\nTo view insights and detailed recommendations about idle 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 `ActivityInsight`.\n\nA panel appears showing insights about the idle instance. The following\ncategories of information are provided along with some supporting charts.\n\nThe following table lists the insight and recommendation that the Cloud SQL\nidle instance recommender might generate to help you reduce costs. The subtypes\nare 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\n You might find that the instance is intentionally idle and you don't need to shut\n it down. If it's inadvertently idle, you can [stop](/sql/docs/mysql/start-stop-restart-instance#stop)\n and [delete](/sql/docs/mysql/delete-instance) the instance. Stopping an\n instance suspends instance charges. The instance data is unaffected,\n and charges for storage and IP addresses continue to apply.\n\n Exercise caution when [stopping](/sql/docs/mysql/start-stop-restart-instance#stop)\n or [deleting](/sql/docs/mysql/delete-instance) an instance. To avoid\n the loss of data, [create a backup](/sql/docs/mysql/backup-recovery/backing-up#on-demand) first.\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\nYou can also [export these recommendations to BigQuery](/recommender/docs/bq-export/export-recommendations-to-bq)\nand examine them by 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 overprovisioned Cloud SQL instances](/sql/docs/mysql/recommender-sql-overprovisioned)\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)"]]
