Gerenciar tabelas abertas e definições de tabelas abertas
Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
MySQL | PostgreSQL | SQL Server
Nesta página, descrevemos como gerenciar instâncias com um número alto de tabelas abertas e um número alto de definições de tabelas abertas. Esse recomendador é chamado de Gerenciar tabelas abertas.
Todos os dias, esse recomendador analisa métricas disto:
O número de tabelas abertas ou definições de tabelas abertas para uma instância conforme a seguir:
Se o número de tabelas abertas ou definições de tabelas abertas aumentar em uma tabela a cada dois segundos ou mais rápido durante as últimas 24 horas.
Se o número de tabelas abertas ou definições de tabelas abertas for igual ou maior que o valor de table_open_cache e table_definition_cache, respectivamente.
Se uma dessas condições for verdadeira, o recomendador aconselhará que você aumente o valor de table_open_cache ou table_definition_cache.
Para mais informações sobre como aumentar o valor de table_open_cache e table_definition_cache, consulte Limite de tabelas.
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Substitua:
PROJECT_ID: ID do projeto;
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
Ver insights e recomendações detalhadas
Para ver insights e recomendações detalhadas, siga estas etapas:
Console
Escolha uma destas opções:
Na página Recomendações de desempenho, clique no card Recomendações de desempenho e depois em Gerenciar tabelas abertas. O painel de recomendações é exibido, contendo insights e recomendações detalhadas para a instância.
Na página Instâncias, clique em Gerenciar tabelas abertas.
A lista de instâncias exibe apenas aquelas às quais a recomendação se aplica.
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Substitua:
PROJECT_ID: ID do projeto;
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
Aplicar a recomendação
Para implementar essa recomendação, realize uma destas ações:
Para um número alto de tabelas abertas, aumente o valor de table_open_cache em 500 até que a recomendação desapareça.
Para um número alto de definições de tabelas abertas, aumente o valor de table_definition_cache em 500 até que a recomendação desapareça.
Essa recomendação é atualizada diariamente. Por isso, depois de aumentar o valor de table_open_cache ou table_definition_cache, aguarde 24 horas antes de verificá-la novamente. Para mais informações sobre como aumentar o valor de table_open_cache e table_definition_cache, consulte Limite de tabelas.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-04 UTC."],[],[],null,["# Manage open tables and open table definitions\n\n\u003cbr /\u003e\n\nMySQL \\| PostgreSQL \\| SQL Server\n\n\u003cbr /\u003e\n\n|\n| **Preview\n| --- [Gemini in Databases](/gemini/docs/overview)**\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 how to manage instances with a high number of open tables\nand a high number of open table definitions. This [recommender](/recommender/docs/recommenders) is called **Manage open tables**.\n\nEvery day, this recommender analyzes metrics for the following:\n\n- The number of open tables or open table definitions for an instance as follows:\n - If the number of open tables or open table definitions increases by 1 table every 2 seconds, or faster, during the previous 24 hours.\n - If the number of open tables or open table definitions is equal to or more than the value of `table_open_cache` and `table_definition_cache`, respectively. If either of these are true, then the recommender advises you to increase the value of `table_open_cache` or `table_definition_cache`.\n\nFor more information on increasing the value of `table_open_cache` and\n`table_definition_cache`, see [Table limit](/sql/docs/quotas#table_limit).\n\nPricing\n-------\n\nThe **Manage open tables** recommender is in the *Standard*\n[Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\n[Enable the Recommender API](/recommender/docs/enabling).\n\n### Required roles and permissions\n\nTo get the permissions to view and work with insights and recommendations,\nensure that you have the required [Identity and Access Management (IAM) roles](/sql/docs/mysql/project-access-control#roles).\n\nFor 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\u003cbr /\u003e\n\nList the recommendations\n------------------------\n\nTo list the recommendations, follow these steps: \n\n### Console\n\nTo list recommendations about instance performance, 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. On the **Improve instance health by investigating issues and acting on\n recommendations** banner, click **Expand Details** .\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\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n2. In the **All recommendations** card, click **Performance** .\n\n### gcloud\n\nRun the [`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list) command 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_RECONFIG_OPEN_TABLES\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\nCall the [`recommendations.list`](/recommender/docs/reference/rest/v1/projects.locations.recommenders.recommendations/list) method 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\nView insights and detailed recommendations\n------------------------------------------\n\nTo view insights and detailed recommendations, follow these steps: \n\n### Console\n\nDo one of the following:\n\n- On the **Performance Recommendations** page, click the **Performance\n recommendations** card and then click **Manage open tables**. The\n recommendation panel appears, which contains insights and detailed\n recommendations for the instance.\n\n- On the **Instances** page, click **Manage open tables**.\n The list of instances displays only those instances for which the\n recommendation applies.\n\n### gcloud\n\nRun the [`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list) command as follows: \n\n```\n\ngcloud recommender insights list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.PerformanceInsight \\\n--filter=insightSubtype=INSIGHT_SUBTYPE\n\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- \u003cvar translate=\"no\"\u003eINSIGHT_SUBTYPE\u003c/var\u003e: set this parameter to one of the following:\n - `MYSQL_HIGH_NUMBER_OF_OPEN_TABLES`: display insights for the number of open tables for your instance\n - `MYSQL_HIGH_NUMBER_OF_OPEN_TABLE_DEFINITIONS`: display insights for the number of open table definitions for your instance\n\n### API\n\nCall the [`insights.list`](/recommender/docs/reference/rest/v1/projects.locations.insightTypes.insights/list) method as follows: \n\n```\n\nGET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights\n\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 the recommendation\n------------------------\n\nTo implement this recommendation, do one of the following:\n\n- For a high number of open tables, increase the value of `table_open_cache` by\n 500 until the recommendation disappears.\n\n- For a high number of open table definitions, increase the value of\n `table_definition_cache` by 500 until the recommendation disappears.\n\n| **Note:** Increasing `table_open_cache` or`table_definition_cache` requires more memory. After increasing these flags, monitor the memory usage .\n\nThis recommendation is updated daily, so after you increase the value of either\n`table_open_cache` or `table_definition_cache`, wait for 24 hours before\nchecking the recommendation again. For more information on increasing the value\nof `table_open_cache` and `table_definition_cache`, see [Table limit](/sql/docs/quotas#table_limit).\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)"]]
