Mengoptimalkan instance Cloud SQL dengan jumlah peristiwa kehabisan memori yang tinggi
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
MySQL | PostgreSQL | SQL Server
Halaman ini menjelaskan pemberi rekomendasi pengoptimalan kehabisan memori (OOM) instance Cloud SQL yang membantu Anda mendeteksi instance yang memiliki sejumlah besar peristiwa OOM dalam tujuh hari terakhir.
Pemberi rekomendasi ini mendeteksi instance yang memiliki
jumlah peristiwa OOM yang tinggi. Kemudian, bagian ini memberikan rekomendasi tentang cara mengoptimalkan instance tersebut dan meningkatkan performa. Rekomendasi dibuat setiap hari.
Harga
Pemberi rekomendasi pengoptimalan OOM Cloud SQL berada dalam Tingkat harga pemberi rekomendasiStandar.
Sebelum memulai
Sebelum Anda dapat melihat rekomendasi dan insight, lakukan tindakan berikut:
Untuk mencantumkan rekomendasi pengoptimalan OOM untuk instance menggunakan gcloud CLI, jalankan perintah
gcloud recommender recommendations list
sebagai berikut:
GET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Ganti kode berikut:
PROJECT_ID: Project ID Anda.
LOCATION: Region tempat instance Anda berada, seperti us-central1.
Jika pemberi rekomendasi mendeteksi instance dengan peristiwa OOM yang sering terjadi, pemberi rekomendasi akan mencantumkannya 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
Anda dapat melihat insight dan rekomendasi mendetail untuk instance
yang memerlukan pengoptimalan OOM menggunakan konsol Google Cloud ,
gcloud CLI, atau Recommender API.
Konsol
Lakukan salah satu hal berikut:
Di halaman Rekomendasi Performa, klik kartu Rekomendasi performa, lalu klik Praktik Terbaik Sering Terjadi Masalah Kehabisan Memori. Panel rekomendasi akan muncul, yang berisi insight dan rekomendasi mendetail untuk instance.
Di halaman Instances, klik Frequent Out-of-Memory Best Practice. Daftar instance hanya menampilkan instance yang berlaku untuk rekomendasi.
gcloud CLI
Untuk melihat insight dan rekomendasi mendetail tentang instance yang memerlukan pengoptimalan OOM, jalankan perintah
gcloud recommender insights list
sebagai berikut:
LOCATION: Region tempat instance Anda berada, seperti us-central1.
API
Untuk melihat insight dan rekomendasi mendetail tentang instance yang memerlukan pengoptimalan OOM, gunakan
Recommendations API, panggil metode
insights.list
sebagai berikut:
GET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Ganti kode berikut:
PROJECT_ID: Project ID Anda.
LOCATION: Region tempat instance Anda berada, seperti us-central1.
Terapkan rekomendasi
Evaluasi rekomendasi tersebut dengan cermat dan lakukan salah satu tindakan berikut:
[[["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,["# Optimize Cloud SQL instances with high number of out-of-memory events\n\n\u003cbr /\u003e\n\nMySQL \\| PostgreSQL \\| SQL Server\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| You can process personal data for this feature as outlined in the\n| [Cloud Data Processing\n| Addendum](/terms/data-processing-addendum), subject to the obligations and restrictions described in the agreement under\n| which you access Google Cloud.\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\nThis page describes the Cloud SQL instance out-of-memory (OOM) optimization [recommender](/recommender/docs/overview) which helps you detect instances that have a high number of OOM events within the last seven days.\n\nThis recommender detects instances that have\na high number of OOM events. It then provides recommendations on how to optimize such\ninstances and improve performance. Recommendations are generated daily.\n\nPricing\n-------\n\nThe Cloud SQL OOM optimization 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- To get the permissions to view and work with insights and recommendations, ensure that you have the required [Identity and Access Management (IAM) roles](/sql/docs/mysql/project-access-control#roles).\n\n For more information about IAM roles, see [IAM basic and predefined roles reference](/iam/docs/understanding-roles) and [Manage access to projects, folders, and organizations](/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 OOM optimization recommendations for an instance\n-----------------------------------------------------\n\nYou can list OOM optimization recommendations for an instance\nusing the Google Cloud console, [gcloud CLI](/sdk/gcloud), or the Recommender API. \n\n### Console\n\nTo list recommendations about instance performance by using the\n\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)\n\n1. Click **Expand Details** on the **Improve instance health by investigating issues and acting on recommendations** banner.\n\nAlternatively, follow these steps:\n\n1. Go to the **Recommendation Hub** . See also [Find and apply recommendations with the Recommendations](/recommender/docs/recommendation-hub/identify-configuration-problems).\n\n2. Click **Performance** in the **All recommendations** card.\n\n### gcloud CLI\n\nTo list OOM optimization recommendations for an instance using gcloud CLI, 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.PerformanceRecommender \\\n--filter=recommenderSubtype=MYSQL_FREQUENT_OUT_OF_MEMORY_BEST_PRACTICE\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 where your instances are located, such as `us-central1`.\n\n### API\n\nTo list OOM optimization recommendations for an instance using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/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 where your instances are located, such as `us-central1`.\n\nIf the recommender detects instances with frequent OOM events, it lists them in a table. Each row shows the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.\n\nView insights and detailed recommendations\n------------------------------------------\n\nYou can view insights and detailed recommendations for instances\nthat require an OOM optimization using the Google Cloud console,\n[gcloud CLI](/sdk/gcloud), or the Recommender API. \n\n### Console\n\nDo one of the following:\n\n- On the **Performance Recommendations** page, click **Performance recommendations** card, click **Frequent Out-of-Memory Best Practice**. The recommendation panel appears, which contains insights and detailed recommendations for the instance.\n\n- On the **Instances** page, click **Frequent Out-of-Memory Best Practice**. The list of instances displays only those instances for which the recommendation applies.\n\n### gcloud CLI\n\nTo view insights and detailed recommendations about instances that require an OOM optimization, 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.PerformanceInsight \\\n--filter=insightSubtype=MYSQL_FREQUENT_OUT_OF_MEMORY\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 where your instances are located, such as `us-central1`.\n\n### API\n\nTo view insights and detailed recommendations about instances that require an OOM optimization, use the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/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 where your instances are located, such as `us-central1`.\n\nApply recommendation\n--------------------\n\nEvaluate the recommendation carefully and do any of the following:\n\n- For more information, see [Optimize instance high memory usage](/sql/docs/mysql/optimize-high-memory-usage).\n- To dismiss the recommendation so that it's de-emphasized and appears dimmed, click **Dismiss**.\n- To close the panel without applying or dismissing the recommendation, click **Cancel**.\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)\n- [About database observability](/sql/docs/mysql/observability)"]]
