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 bancos de dados com um alto número de conexões simultâneas de clientes e um alto número de linhas de execução da conexão do banco de dados. Esse recomendador é chamado de Redefinir configurações de conexão.
Todos os dias, esse recomendador analisa métricas disto:
O número máximo de conexões de banco de dados rastreando o valor da flag max_used_connections. Se o número máximo de conexões desde a reinicialização do servidor for 80% do valor max_connections, redefinir configurações de conexão recomendará que você aumente o valor de max_connections.
O número de novas linhas de execução da conexão do banco de dados em comparação com o número de linhas de execução da conexão do banco de dados que já existem. Se mais de 50% das conexões resultarem em novas linhas de execução em vez de reutilizar aquelas armazenadas em cache, ou se o valor de thread_cache_size for definido como 0, Redefinir configurações de conexão recomendará que você aumente o valor de thread_cache_size.
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 Redefinir configurações de conexão.
O painel de recomendações é exibido, contendo insights e recomendações detalhadas para a instância.
Na página Instâncias, clique em Redefinir configurações de conexão.
A lista de instâncias exibe apenas aquelas às quais a recomendação se aplica.
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
INSIGHT_SUBTYPE: define esse parâmetro com um dos seguintes valores:
MYSQL_HIGH_NUMER_OF_CONNECTIONS: exibe insights sobre o número de conexões de banco de dados da instância.
MYSQL_HIGH_THREAD_CACHE_MISS_RATE: exibe insights sobre o número de novas linhas de execução da conexão do banco de dados sem usar o cache de linhas de execução na sua instância.
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 aplicar a recomendação ao tamanho do cache de linhas de execução da conexão, realize uma destas ações:
Se o valor de thread_cache_size for definido como 0, ative o cache de linhas de execução configurando essa flag com um valor maior que 0.
Se o valor de thread_cache_size for maior que 0, aumente o valor dessa flag. thread_cache_size precisa ser equivalente ao número médio de conexões com o banco de dados. Aumente o valor de thread_cache_size se o número de novas linhas de execução for maior do que a configuração atual.
Para aplicar a recomendação da conexão do banco de dados, aumente o valor da flag max_connections. A recomendação é atualizada diariamente. Portanto, depois de aumentar o valor dessa flag, aguarde 24 horas antes de verificar a recomendação novamente. Para mais informações sobre como aumentar o valor de max_connections, consulte Máximo de conexões simultâneas.
[[["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,["# Reconfigure connection settings\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 how to manage databases with a high number of simultaneous\nclient connections and a high number of database connection threads. This\n[recommender](/recommender/docs/recommenders) is called\n**Reconfigure connection settings**.\n\nEvery day, this recommender analyzes metrics for the following:\n\n- The peak number of database connections by tracking the value of\n the `max_used_connections` flag. If the maximum number of connections since\n the server restarted is 80% of the value `max_connections`, **Reconfigure\n connection settings** recommends that you increase the value of\n `max_connections` .\n\n For more information on increasing the value of `max_connections`, see\n [Maximum concurrent connections](/sql/docs/quotas#maximum_concurrent_connections).\n- The number of new database connection threads compared to the number of\n existing database connection threads. If more than 50% of connections result\n in new threads instead of reusing cached ones, or if the value of\n `thread_cache_size` is set to 0, then **Reconfigure connection settings**\n recommends that you increase the value of `thread_cache_size`.\n\n For more information on increasing the value of `max_connections`, see\n [Optimize high CPU utilization in instances](/sql/docs/mysql/optimize-cpu-usage).\n This feature is in [Preview](/products#product-launch-stages).\n\nPricing\n-------\n\nThe **Reconfigure connection settings** 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_CONNECTIONS\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 **Reconfigure connection settings**.\n The recommendation panel appears, which contains insights and detailed\n recommendations for the instance.\n\n- On the **Instances** page, click **Reconfigure connection settings**.\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_NUMER_OF_CONNECTIONS`: display insights for the number of database connections for your instance\n - `MYSQL_HIGH_THREAD_CACHE_MISS_RATE`: display insights for the number of new database connection threads without using the thread cache 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- To apply the recommendation for the connection thread cache size, do one of\n the following:\n\n - If the value of `thread_cache_size` is set to 0, then enable the thread\n cache by setting this flag to a value greater than 0.\n\n - If the value of `thread_cache_size` is greater than 0, then increase the\n value of this flag. `thread_cache_size` should be equivalent to the average\n number of connections to the database. Increase the value of\n `thread_cache_size` if the number of new threads is higher than the current\n setting.\n\n- To apply the database connection recommendation, increase the value of the\n `max_connections` flag. The recommendation is updated daily, so after you\n increase the value of this flag, wait for 24 hours before checking the recommendation again. For more information on\n increasing the value of `max_connections`, see [Maximum concurrent connections](/sql/docs/quotas#maximum_concurrent_connections).\n\n| **Note:** Increasing `thread_cache_size` and `max_connections` requires more memory. After increasing these flags, monitor the memory usage.\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)"]]
