Database Connection Pool

Architect's Guide

Mar 16, 2025 · Backend Development

Understanding Java Object Pooling with Commons Pool 2 and HikariCP: Concepts, Configuration, and Performance Testing

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

Understanding Java Object Pooling with Commons Pool 2 and HikariCP: Concepts, Configuration, and Performance Testing

macrozheng

Feb 12, 2025 · Databases

Mastering Spring Boot Database Connection Pools: HikariCP vs Druid

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

Mastering Spring Boot Database Connection Pools: HikariCP vs Druid

php中文网 Courses

Aug 13, 2024 · Backend Development

Using Swoole to Implement Database Connection Pooling in Laravel

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.

Backend DevelopmentCase StudyDatabase Connection Pool

0 likes · 3 min read

Using Swoole to Implement Database Connection Pooling in Laravel

Selected Java Interview Questions

Dec 6, 2023 · Databases

Comprehensive Guide to Configuring Druid DataSource in Spring Boot

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 PoolDruidMonitoring

0 likes · 14 min read

Comprehensive Guide to Configuring Druid DataSource in Spring Boot

JD Tech

Apr 18, 2023 · Backend Development

Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies

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

Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies

Python Programming Learning Circle

Aug 15, 2022 · Databases

Using Python DB‑API to Operate MySQL: PyMySQL Basics, Connection Pooling, and Safe SQL Practices

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

Using Python DB‑API to Operate MySQL: PyMySQL Basics, Connection Pooling, and Safe SQL Practices

Architect's Tech Stack

Jun 28, 2022 · Backend Development

Using Alibaba Druid Connection Pool with Spring Boot: Dependencies, Configuration, Monitoring, and Customization

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

Using Alibaba Druid Connection Pool with Spring Boot: Dependencies, Configuration, Monitoring, and Customization

政采云技术

Jun 14, 2022 · Backend Development

Performance Testing, Response Time Analysis, and Database Connection Pool Optimization for a Multi‑Table Query Service

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

Performance Testing, Response Time Analysis, and Database Connection Pool Optimization for a Multi‑Table Query Service

Top Architect

Apr 2, 2022 · Backend Development

Can IO Multiplexing Replace Connection Pools for Database Access?

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

Can IO Multiplexing Replace Connection Pools for Database Access?

Java Architect Essentials

Feb 28, 2022 · Databases

Configuring Alibaba Druid DataSource and Monitoring in Spring Boot

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

Configuring Alibaba Druid DataSource and Monitoring in Spring Boot

Top Architect

Feb 19, 2022 · Databases

Comprehensive Guide to Configuring Druid DataSource in Spring Boot

This article provides a detailed tutorial on Druid, the Alibaba‑developed Java database connection pool, covering its core concepts, Maven dependencies, extensive Spring Boot configuration options, filter setup, monitoring UI, SQL and slow‑query logging, ad removal techniques, and programmatic access to monitoring data.

Database Connection PoolDruidJava

0 likes · 15 min read

Full-Stack Internet Architecture

Jul 8, 2021 · Databases

Why ThreadLocal Cannot Isolate Database Connections in a Connection Pool

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

Why ThreadLocal Cannot Isolate Database Connections in a Connection Pool

Full-Stack Internet Architecture

Jul 5, 2021 · Databases

Integrating Alibaba Druid Connection Pool with Spring Boot: Configuration and Monitoring Guide

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

Integrating Alibaba Druid Connection Pool with Spring Boot: Configuration and Monitoring Guide

Top Architect

May 18, 2021 · Databases

Understanding Database Connection Pools and ThreadLocal in Java for Transaction Management

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.

Backend DevelopmentDatabase Connection PoolJava

0 likes · 7 min read

Understanding Database Connection Pools and ThreadLocal in Java for Transaction Management

vivo Internet Technology

Jan 20, 2021 · Databases

Why HikariCP Is the Fastest Database Connection Pool: A Deep Dive

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

Why HikariCP Is the Fastest Database Connection Pool: A Deep Dive

Top Architect

Jun 29, 2020 · Databases

How to Size Database Connection Pools: Lessons from HikariCP and Real‑World Performance Tests

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 PoolHikariCPbackend

0 likes · 10 min read

How to Size Database Connection Pools: Lessons from HikariCP and Real‑World Performance Tests

360 Quality & Efficiency

Apr 24, 2020 · Backend Development

Root Cause Analysis of Connection Reset by Peer in a Go Backend Service

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.

Connection ResetDatabase Connection PoolLinux tools

0 likes · 14 min read

Root Cause Analysis of Connection Reset by Peer in a Go Backend Service

Wukong Talks Architecture

Mar 3, 2020 · Databases

Using Druid DataSource in Spring Boot: Configuration, Monitoring, and Troubleshooting

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

Using Druid DataSource in Spring Boot: Configuration, Monitoring, and Troubleshooting