Optimiza las instancias de Cloud SQL con una gran cantidad de eventos de memoria insuficiente
Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
MySQL | PostgreSQL | SQL Server
En esta página, se describe el recommender de optimización de falta de memoria (OOM) de la instancia de Cloud SQL que te ayuda a detectar instancias que tienen una gran cantidad de eventos de OOM en los últimos siete días.
Este recomendador detecta las instancias que tienen una gran cantidad de eventos de OOM. Luego, proporciona recomendaciones para optimizar esas instancias y mejorar el rendimiento. Las recomendaciones se generan a diario.
Haz clic en Rendimiento en la tarjeta Todas las recomendaciones.
gcloud CLI
A fin de enumerar las recomendaciones de optimización de OOM para una instancia con la CLI de gcloud, ejecuta el comando gcloud recommender recommendations list de la siguiente manera:
LOCATION: Es una región en la que se encuentran las instancias, como us-central1.
API
A fin de mostrar una lista de las recomendaciones de optimización de OOM para una instancia mediante la API de Recommendations, llama al método recommendations.list de la siguiente manera:
GET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Reemplaza lo siguiente:
PROJECT_ID: ID del proyecto
LOCATION: Es una región en la que se encuentran las instancias, como us-central1.
Si el recomendador detecta instancias con eventos de OOM frecuentes, las enumera en una tabla. En cada fila, se muestra el nombre de la instancia, una recomendación breve, el tipo de máquina actual, el tipo de máquina recomendado, la ubicación y la última fecha de actualización.
Visualiza las estadísticas y las recomendaciones detalladas
Puedes ver estadísticas y recomendaciones detalladas para las instancias que requieren una optimización de OOM mediante la consola de Google Cloud, gcloud CLI o la API de Recommender.
Console
Realiza una de las siguientes acciones:
En la página Recomendaciones de rendimiento, haz clic en la tarjeta Recomendaciones de rendimiento y, luego, en Práctica recomendada frecuente de falta de memoria. Aparecerá el panel de recomendaciones, que contiene estadísticas y recomendaciones detalladas para la instancia.
En la página Instancias, haz clic en Práctica recomendada sobre falta de memoria frecuente. La lista de instancias muestra solo aquellas en las que se aplica la recomendación.
gcloud CLI
Para ver estadísticas y recomendaciones detalladas sobre las instancias que requieren una optimización de OOM, ejecuta el comando gcloud recommender insights list de la siguiente manera:
LOCATION: Es una región en la que se encuentran las instancias, como us-central1.
API
Para ver estadísticas y recomendaciones detalladas sobre las instancias que requieren una optimización de OOM, usa la API de Recommendations, llama al método insights.list como lo siguiente:
GET https://recommender.googleapis.com/v1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Reemplaza lo siguiente:
PROJECT_ID: ID del proyecto
LOCATION: Es una región en la que se encuentran las instancias, como us-central1.
Aplicar recomendación
Evalúa las recomendaciones con cuidado y realiza una de las siguientes acciones:
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Información o código de muestra incorrectos","incorrectInformationOrSampleCode","thumb-down"],["Faltan la información o los ejemplos que necesito","missingTheInformationSamplesINeed","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Otro","otherDown","thumb-down"]],["Última actualización: 2025-09-08 (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)"]]
