dbConnectionPoolSize

The size of the HikariCP database connection pool.

This property controls how many database connections the plugin maintains in its connection pool. The pool size directly affects the plugin's ability to handle concurrent database operations and overall performance.

Pool Size Considerations:

• Larger pools can handle more concurrent operations

• Smaller pools use less memory and database resources

• Pool size should be balanced with server load and database capacity

• Each connection consumes memory on both client and server sides

Recommended Values:

• Small servers (1-50 players): 5-10 connections

• Medium servers (50-200 players): 10-20 connections

• Large servers (200+ players): 20-50 connections

• Very large servers: 50+ connections (monitor database performance)

Default Value: 10 connections (suitable for most small to medium servers)

Configuration Key: "database.connectionPoolSize"

Performance Impact:

• Too few connections: Bottleneck for database operations

• Too many connections: Wasted resources and potential database overload

• Optimal sizing requires monitoring actual usage patterns

Database Server Limits:

• MySQL has a maximum connection limit (default 151)

• Multiple plugins may share the same database server

• Connection pool size should not exceed server capacity