Tagged articles
Database Connection Pool
28 articles · Page 1 of 1
An API's sudden latency spike from 200ms to 8 seconds was traced not to slow SQL but to database connection pool exhaustion caused by @Transactional methods holding connections during external HTTP calls to a payment service; splitting transactions and moving external calls outside the transaction boundary resolved the issue.
Database Connection PoolHikariCPObservability
0 likes · 15 min read

This article explains why HikariCP is the default Spring Boot connection pool, details the required dependencies, walks through essential configuration parameters, shows how to use HikariTemplate, monitor pool metrics, avoid common pitfalls, and compares HikariCP with other popular pools.
ConfigurationDatabase Connection PoolHikariCP
0 likes · 6 min read

This guide explains Druid—Alibaba's Java database connection pool—covering its core concepts, Maven dependencies, property configuration, built‑in filters, SQL and slow‑SQL monitoring, Spring AOP integration, ad removal, and how to retrieve runtime statistics via DruidStatManagerFacade, all with complete code examples.
Database Connection PoolDruidJava
0 likes · 16 min read

This article explains the importance of database connection pools in Spring Boot projects using KingbaseES, compares four popular pools (DBCP, C3P0, Druid, HikariCP), provides configuration examples, highlights common pitfalls, and offers practical tuning and monitoring guidance for optimal performance.
Database Connection PoolDruidHikariCP
0 likes · 18 min read

This article explains Java object pooling using Commons Pool 2 and HikariCP, covering their core classes, configuration parameters, practical examples with Redis and JDBC, interview questions, and JMH performance benchmarks that demonstrate significant throughput improvements.
Commons Pool 2Database Connection PoolHikariCP
0 likes · 14 min read

This guide explains the need for JDBC connection pools, compares popular pools like HikariCP and Druid, and provides step‑by‑step configurations for both custom property files and Spring Boot auto‑configuration, helping you efficiently manage database connections in Java applications.
Database Connection PoolDruidHikariCP
0 likes · 20 min read

This course provides an in‑depth exploration of integrating Swoole with Laravel to create and manage a database connection pool, covering fundamental concepts, integration steps, performance optimization, real‑world case studies, and best practices for both Laravel and Swoole developers.
Database Connection PoolLaravelcase study
0 likes · 3 min read

This article provides a detailed overview of Druid, a high‑performance Java database connection pool, covering its core concepts, Maven dependencies, extensive configuration options, monitoring filters, SQL slow‑query logging, and methods to customize or remove the built‑in advertisement page.
Database Connection PoolDruidSQL
0 likes · 14 min read


JD TechApr 18, 2023 · Backend Development
This article analyzes a production incident where excessive Full GC pauses during a high‑traffic promotion were traced to stale database connections in the DBCP pool, explains the investigation steps, root cause, and presents several JVM and connection‑pool configuration solutions to prevent similar performance degradations.
Database Connection PoolGCJVM
0 likes · 8 min read

This article introduces Python's DB‑API, lists supported databases, demonstrates how to install and use PyMySQL for basic CRUD operations, shows techniques for preventing SQL injection, and explains two connection‑pooling models with DBUtils, including code examples and a brief promotional note at the end.
DB-APIDatabase Connection PoolMySQL
0 likes · 17 min read

This article explains how to integrate Alibaba's Druid database connection pool into a Spring Boot application, covering Maven dependencies, YAML configuration, built‑in filters, monitoring pages, ad removal techniques, and programmatic access to Druid statistics for comprehensive backend performance management.
ConfigurationDatabase Connection PoolDruid
0 likes · 14 min read


政采云技术Jun 14, 2022 · Backend Development
This article presents a comprehensive performance testing case study of a multi‑table database query interface, detailing common performance metrics, response‑time classifications, step‑by‑step load‑test results, root‑cause analysis of CPU, memory, and connection‑pool bottlenecks, and demonstrates how tuning Druid’s maxActive and maxWait parameters optimizes throughput and reduces latency.
Database Connection PoolDruidMyBatis
0 likes · 12 min read

The article explains why database connections in Java applications usually rely on connection pools instead of IO multiplexing, discusses the blocking nature of JDBC, outlines how non‑blocking drivers could be built, and examines the practical and architectural reasons that prevent IO multiplexing from becoming the default.
Database Connection PoolIO MultiplexingJDBC
0 likes · 7 min read

This article explains the fundamentals of Alibaba Druid as a Java database connection pool, shows how to add Maven dependencies, configure properties and filters in Spring Boot, set up monitoring pages, remove built‑in ads, and retrieve runtime statistics via DruidStatManagerFacade.
ConfigurationDatabase Connection PoolDruid
0 likes · 15 min read

The article investigates the misconception that ThreadLocal can isolate database connections in a pool, demonstrates through a single‑connection Druid test that connections are effectively exclusive to a thread, and explains the underlying pool mechanics and proper use of ThreadLocal for routing data.
ConcurrencyDatabase Connection PoolDruid
0 likes · 10 min read

This article provides a comprehensive guide on integrating the Alibaba Druid JDBC connection pool into a Spring Boot application, covering its components, powerful monitoring features, password encryption, SQL parsing, Maven and YAML configuration, filter setup, and how to access the Druid monitoring console.
ConfigurationDatabase Connection PoolDruid
0 likes · 11 min read

This article explains the fundamental differences between database connection pools and ThreadLocal, how each is used in Java to improve performance and enable cross‑method transaction control, and provides practical code examples and best‑practice guidelines for managing connections in multi‑threaded applications.
Database Connection PoolJavaThreadLocal
0 likes · 7 min read

The article explains how HikariCP outperforms other JDBC pools by using bytecode‑generated proxies, a custom FastList, and a thread‑local ConcurrentBag, delivering superior speed, low resource use, and easy migration, making it the default high‑performance connection pool for Spring Boot 2.0.
Concurrent ProgrammingConcurrentBagDatabase Connection Pool
0 likes · 14 min read

The article explains how long‑running database transactions can exhaust connection pools, block threads, and cause widespread service failures, then offers practical strategies—including keeping transactions short, removing RPC calls, enhancing monitoring, and reviewing code—to detect and prevent these high‑risk issues.
Backend PerformanceDatabase Connection PoolSpring
0 likes · 7 min read

Through a series of Oracle and PostgreSQL benchmarks, this article demonstrates that reducing database connection pool size can dramatically lower request latency—from around 100 ms to just 3 ms—by aligning pool size with CPU cores and I/O characteristics, and provides a practical formula for sizing.
Database Connection PoolI/O BottleneckSQL latency
0 likes · 10 min read

This article explains why a smaller database connection pool often yields better latency and throughput, illustrates the effect with Oracle and PostgreSQL benchmarks, and provides a practical formula (connections = (CPU cores × 2) + effective disks) for sizing pools in production systems.
Database Connection PoolHikariCPPerformance Tuning
0 likes · 10 min read

This article details a production incident where a Go backend service returned "connection reset by peer" due to exhausted process file descriptors caused by a saturated database connection pool, and describes the step‑by‑step troubleshooting, socket internals, and the eventual fix.
Backend DebuggingDatabase Connection PoolGo
0 likes · 14 min read

This article explains how reducing the size of a database connection pool can dramatically lower request latency and improve throughput, using HikariCP performance experiments, a simple sizing formula, and practical guidelines for configuring pools on modern hardware.
Database Connection PoolHikariCPSQL latency
0 likes · 10 min read

This article explains what Druid is, how to add the Druid dependency, configure it in Spring Boot's application.yml, set up monitoring with a custom DruidConfig class, and resolve common errors such as property binding failures and login issues.
ConfigurationDatabase Connection PoolDruid
0 likes · 7 min read

This article presents a comprehensive multi‑threaded performance and safety evaluation of four popular database connection pools—Druid, JNDI, Tomcat, and Oracle UCP—across Tomcat, WebSphere, and JWS servers, detailing test setup, methodology, results, and best‑practice recommendations for proper pool usage.
Database Connection PoolDruidJDBC
0 likes · 9 min read

This article debunks the myth that larger database connection pools always improve performance, explains how CPU, disk, and network I/O affect optimal pool size, presents real‑world test results, and provides a practical formula for calculating the right number of connections.
CPUDatabase Connection PoolPostgreSQL
0 likes · 10 min read

This article compiles and translates key information about HikariCP, detailing why Spring Boot 2 adopts it as the default JDBC pool, comparing its performance and stability against BoneCP, C3P0, Tomcat and Druid, and providing practical configuration steps for quick integration.
Database Connection PoolHikariCPJava
0 likes · 13 min read

This article reviews mainstream Java database connection pools—including C3P0, DBCP, Tomcat JDBC, BoneCP, Druid, and HikariCP—compares their features and performance, explores an even faster Scala async pool, discusses future middleware trends, and examines Sharding-JDBC's evolution toward a Database Mesh architecture.
Database Connection PoolDruidHikariCP
0 likes · 11 min read
