BestHub
Sign in
Tagged articles
26 articles
Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Oct 8, 2025 · Databases

Master Druid: Configure, Monitor, and Optimize Java Database Connections in Spring Boot

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
Master Druid: Configure, Monitor, and Optimize Java Database Connections in Spring Boot
Selected Java Interview Questions
Selected Java Interview Questions
Sep 14, 2025 · Backend Development

Mastering Spring Boot with KingbaseES: Which Connection Pool Wins?

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
Mastering Spring Boot with KingbaseES: Which Connection Pool Wins?
Architect's Guide
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
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
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.

Case StudyDatabase Connection PoolLaravel
0 likes · 3 min read
Using Swoole to Implement Database Connection Pooling in Laravel
JD Tech
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 PoolJVMgc
0 likes · 8 min read
Case Study: Long GC Times Caused by Database Connection Pool Issues and Mitigation Strategies
Python Programming Learning Circle
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 PoolPython
0 likes · 17 min read
Using Python DB‑API to Operate MySQL: PyMySQL Basics, Connection Pooling, and Safe SQL Practices
Architect's Tech Stack
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 PoolDruidLoad Testing
0 likes · 12 min read
Performance Testing, Response Time Analysis, and Database Connection Pool Optimization for a Multi‑Table Query Service
Top Architect
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
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
Full-Stack Internet Architecture
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
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
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
Java Backend Technology
Java Backend Technology
Nov 19, 2020 · Backend Development

Why Long Database Transactions Crash Services and How to Prevent Them

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 Poollong transactions
0 likes · 7 min read
Why Long Database Transactions Crash Services and How to Prevent Them
Java Backend Technology
Java Backend Technology
Aug 1, 2020 · Databases

Why Smaller DB Connection Pools Boost Performance: Real-World Test Insights

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
Why Smaller DB Connection Pools Boost Performance: Real-World Test Insights
360 Quality & Efficiency
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 PoolGo
0 likes · 14 min read
Root Cause Analysis of Connection Reset by Peer in a Go Backend Service
dbaplus Community
dbaplus Community
Dec 17, 2019 · Databases

Which Database Connection Pool Performs Best? A Real-World Multi-Threaded Test

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
Which Database Connection Pool Performs Best? A Real-World Multi-Threaded Test
Programmer DD
Programmer DD
May 6, 2018 · Backend Development

Why Spring Boot 2 Picks HikariCP: Speed, Simplicity, and Reliability Explained

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.

Backend DevelopmentDatabase Connection PoolHikariCP
0 likes · 13 min read
Why Spring Boot 2 Picks HikariCP: Speed, Simplicity, and Reliability Explained
Programmer DD
Programmer DD
May 1, 2018 · Databases

Which Database Connection Pool Reigns Supreme? A Deep Dive into HikariCP, Druid, and Beyond

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
Which Database Connection Pool Reigns Supreme? A Deep Dive into HikariCP, Druid, and Beyond