GCP Cloud Spanner Connection Pooling implementing Spring Boot Application
Quick question that's been bugging me - I've been researching this but I'm not sure how to approach This might be a silly question, but I'm working with issues with connection pooling in my Spring Boot application when connecting to Google Cloud Spanner. I am using the `spring-cloud-gcp-starter-data-spanner` library version 2.0.0 and have configured the connection settings in my `application.yml`. Despite configuring the connection pool size, I keep working with `com.google.cloud.spanner.SpannerException: Too many requests`. My current pool settings are: ```yaml spring: cloud: gcp: spanner: instance-id: my-instance database-id: my-database connection-pool: min-size: 5 max-size: 20 idle-timeout: 30000 ``` I've verified that my Spanner instance doesn't have any quota limits being hit, and I have enabled the `GCP Cloud Spanner JDBC` driver, yet I continue to run into this scenario under load. To troubleshoot, I have tried increasing the `max-size` of the pool to 100 but still get the same behavior. Additionally, I have ensured that the application is correctly closing connections after use, but I still see a high number of active connections on the Spanner console. Is there a recommended approach or best practice for optimizing connection pooling for GCP Cloud Spanner with Spring Boot, especially under high load scenarios? Any insights or advice on how to alleviate this scenario would be greatly appreciated. My development environment is macOS. Thanks, I really appreciate it! I'd love to hear your thoughts on this. Has anyone dealt with something similar?