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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
