使用 HikariCP 时设置连接池和溢出限制
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
配置使用 HikariCP JDBC 连接池库连接到 Cloud SQL for MySQL 时的连接池大小和溢出。
深入探索
如需查看包含此代码示例的详细文档,请参阅以下内容:
代码示例
Java
如需向 Cloud SQL for MySQL 进行身份验证,请设置应用默认凭据。如需了解详情,请参阅为本地开发环境设置身份验证。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],[],[],[],null,["# Set connection pool and overflow limits when using HikariCP\n\nConfigure the connection pool size and overflow when connecting to Cloud SQL for MySQL by using the HikariCP JDBC connection pool library.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Manage database connections](/sql/docs/mysql/manage-connections)\n\nCode sample\n-----------\n\n### Java\n\n\nTo authenticate to Cloud SQL for MySQL, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n // maximumPoolSize limits the total number of concurrent connections this pool will keep. Ideal\n // values for this setting are highly variable on app design, infrastructure, and database.\n config.setMaximumPoolSize(5);\n // minimumIdle is the minimum number of idle connections Hikari maintains in the pool.\n // Additional connections will be established to meet this value unless the pool is full.\n config.setMinimumIdle(5);\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=cloud_sql_mysql)."]]