BestHub
Sign in
Tagged articles

Connection Pool

202 articles · Page 1 of 3
MaGe Linux Operations
MaGe Linux Operations
Jul 5, 2026 · Databases

Why MySQL Connections Spike: When Traffic Isn’t the Real Culprit

This article walks through a systematic, step‑by‑step troubleshooting guide for MySQL "Too many connections" errors, showing how to verify the symptom, inspect server variables, analyze connection status, identify common root causes such as connection‑pool misconfiguration, leaked connections, and long‑running queries, and apply safe fixes and preventive measures.

Connection PoolDatabaseMySQL
0 likes · 35 min read
Why MySQL Connections Spike: When Traffic Isn’t the Real Culprit
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jun 12, 2026 · Databases

PostgreSQL Migration Pitfalls: From Rough Practices to Stable Management

The article analyzes common mistakes when moving from MySQL to PostgreSQL—such as oversized connection pools, blind max_connections tweaks, oversized transactions, idle‑in‑transaction connections, and indiscriminate indexing—and offers concrete, step‑by‑step guidance to achieve a stable, well‑tuned PostgreSQL deployment.

Connection PoolIndex OptimizationPerformance Tuning
0 likes · 14 min read
PostgreSQL Migration Pitfalls: From Rough Practices to Stable Management
Architect's Guide
Architect's Guide
Jun 6, 2026 · Fundamentals

Mastering TCP, HTTP, Sockets, and Socket Connection Pools

This article walks through the OSI model, explains TCP three‑way handshake and four‑way termination, contrasts TCP with UDP, discusses TIME_WAIT issues, describes long vs short socket connections, shows how to design a custom protocol and implements a reusable Socket connection pool in Node.js.

Connection PoolHTTPNode.js
0 likes · 14 min read
Mastering TCP, HTTP, Sockets, and Socket Connection Pools
IT Services Circle
IT Services Circle
May 25, 2026 · Backend Development

Druid vs HikariCP: Which Connection Pool Wins?

This article compares Druid and HikariCP, the two most popular Java database connection pools, by explaining how connection pools work, presenting benchmark results, dissecting HikariCP's lock‑free design and bytecode optimizations, detailing Druid's rich monitoring and security features, and offering a practical decision framework for different scenarios.

Connection PoolDruidHikariCP
0 likes · 19 min read
Druid vs HikariCP: Which Connection Pool Wins?
Su San Talks Tech
Su San Talks Tech
May 21, 2026 · Backend Development

Druid vs HikariCP: Which Java Connection Pool Wins?

The article compares Alibaba’s Druid and Spring Boot’s default HikariCP connection pools, explaining how connection pooling works, presenting benchmark results that show HikariCP’s lower latency and higher TPS, detailing HikariCP’s lock‑free ConcurrentBag and bytecode optimizations, and highlighting Druid’s rich monitoring, SQL firewall and leak detection features to help developers choose the right pool for different scenarios.

Connection PoolDruidHikariCP
0 likes · 18 min read
Druid vs HikariCP: Which Java Connection Pool Wins?
Architect's Guide
Architect's Guide
May 12, 2026 · Fundamentals

Mastering TCP, HTTP, Sockets, and Socket Connection Pools

This article walks developers through the OSI model, explains TCP's three‑way handshake and four‑way termination, contrasts TCP with UDP, addresses common networking questions, and details how to implement long‑lived socket connections and a reusable socket connection pool in Node.js.

Connection PoolNetwork ProtocolsNode.js
0 likes · 15 min read
Mastering TCP, HTTP, Sockets, and Socket Connection Pools
MaGe Linux Operations
MaGe Linux Operations
Apr 30, 2026 · Databases

How a Redis Connection Saturation Triggered a Service Avalanche – A Detailed Investigation

An online education platform experienced a massive outage when Redis hit its maxclients limit, causing authentication, session, and cache services to fail, which cascaded into a business avalanche; the article walks through the connection mechanism, root‑cause analysis, rapid mitigation steps, and long‑term safeguards.

Connection PoolJedisOperations
0 likes · 20 min read
How a Redis Connection Saturation Triggered a Service Avalanche – A Detailed Investigation
Top Architect
Top Architect
Apr 13, 2026 · Backend Development

Why Did a Forgotten Transaction Block Payments? A Deep Dive into Spring’s Transaction Management

An online payment service suffered invisible data loss and lock timeouts because a newly deployed business branch failed to commit its transaction, leading to polluted connections that were reused by other services, and the article explains the root cause, debugging steps, code fixes, and preventive measures.

Connection PoolDatabaseSpring
0 likes · 11 min read
Why Did a Forgotten Transaction Block Payments? A Deep Dive into Spring’s Transaction Management
Ops Community
Ops Community
Apr 10, 2026 · Databases

How to Diagnose and Fix MySQL Too Many Connections Errors in Production

When MySQL reports 'Too many connections', this guide walks you through emergency assessment, step‑by‑step diagnostics, quick mitigation scripts, root‑cause analysis of slow queries, connection leaks, short‑connection spikes, and long‑term solutions including parameter tuning, connection‑pool configuration, and Prometheus‑based monitoring to prevent future outages.

AlertmanagerConnection PoolConnection leak
0 likes · 40 min read
How to Diagnose and Fix MySQL Too Many Connections Errors in Production
Top Architect
Top Architect
Apr 3, 2026 · Backend Development

Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring

A mysterious payment failure where orders appeared successful but were never persisted was traced to a missing transaction commit in a special code path, leading to polluted connections that silently broke subsequent transactions, and the article explains the root cause, debugging steps, fix, and preventive measures.

Connection PoolDatabaseMySQL
0 likes · 11 min read
Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring
Alibaba Cloud Observability
Alibaba Cloud Observability
Mar 30, 2026 · Mobile Development

Why Your Android App’s Network Requests Stall and How RUM Reveals the Fix

The article explains how mobile network performance issues—especially long connection‑pool wait times—cause slow page loads in Android apps, demonstrates how to interpret Alibaba Cloud RUM’s Resource event metrics and timing data, walks through a real‑world case study with detailed stage‑by‑stage analysis, and provides concrete diagnostic steps and optimization recommendations for OkHttp connection‑pool configuration and other common bottlenecks.

AndroidConnection PoolMobile Development
0 likes · 16 min read
Why Your Android App’s Network Requests Stall and How RUM Reveals the Fix
Raymond Ops
Raymond Ops
Mar 17, 2026 · Operations

Boost Nginx Performance: 10‑Minute Guide to Reverse Proxy Timeout and Connection Pool Tuning

This step‑by‑step guide shows how to optimize Nginx reverse‑proxy timeouts and enable connection‑pool reuse on Linux servers, covering prerequisites, configuration changes, kernel tuning, load‑testing, monitoring with Prometheus, security hardening, troubleshooting, rollback procedures, and best‑practice recommendations.

Connection PoolNGINXPerformance Tuning
0 likes · 26 min read
Boost Nginx Performance: 10‑Minute Guide to Reverse Proxy Timeout and Connection Pool Tuning
Senior Xiao Ying
Senior Xiao Ying
Feb 24, 2026 · Databases

Mastering MySQL Performance: Connection Pool Tuning, Built‑in Cache, and Application‑Level Caching

This guide walks through three defensive layers for MySQL performance—optimizing the connection pool, configuring the query cache and memory tables, and designing multi‑level application caches (including Cache‑Aside, Write‑Through, and Redis integration) with concrete code examples and best‑practice recommendations.

Cache DesignConnection PoolMemory Table
0 likes · 13 min read
Mastering MySQL Performance: Connection Pool Tuning, Built‑in Cache, and Application‑Level Caching
Top Architect
Top Architect
Feb 15, 2026 · Backend Development

Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring

A payment service failed to insert orders despite successful payments, showing no errors, occasional lock timeouts, and intermittent success, which was traced to a missing transaction commit that polluted reused connections, causing unrelated business failures until the bug was fixed and preventive measures were added.

Connection PoolDatabaseSpring
0 likes · 11 min read
Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring
Architect's Guide
Architect's Guide
Feb 14, 2026 · Backend Development

Master TCP/UDP, Socket Long Connections, and Build a Node.js Socket Pool

This tutorial walks through the OSI model, explains TCP three‑way handshake and four‑way termination, compares TCP and UDP, addresses common TCP tuning questions, describes long versus short socket connections with heartbeats, and shows how to design a custom protocol and implement a reusable Socket connection pool in Node.js.

Connection PoolNetwork ProtocolsNode.js
0 likes · 15 min read
Master TCP/UDP, Socket Long Connections, and Build a Node.js Socket Pool
Java Companion
Java Companion
Feb 10, 2026 · Backend Development

Why Successful Payments Vanished: MyBatis Connection‑Pool Pitfalls Explained

A production incident where payment orders appeared successful but were not persisted was traced to a missing commit in a special‑case branch, causing a polluted connection to be reused by Spring's transaction manager, leading to intermittent failures that were resolved by fixing the commit logic and adding connection‑pool health checks.

Connection PoolDatabase MonitoringHikariCP
0 likes · 10 min read
Why Successful Payments Vanished: MyBatis Connection‑Pool Pitfalls Explained
DevOps Coach
DevOps Coach
Jan 21, 2026 · Operations

How I Turned a 3‑Day Latency Nightmare into a 30‑Second Debugging Tool

After a late‑night PagerDuty alert revealed a p95 latency over 5 seconds despite normal CPU, memory, and database metrics, the author spent three days tracing the issue to a tiny thread‑pool configuration, then built an open‑source CLI that automates the entire diagnosis in seconds.

Connection PoolGrafanalatency debugging
0 likes · 17 min read
How I Turned a 3‑Day Latency Nightmare into a 30‑Second Debugging Tool
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jan 16, 2026 · Backend Development

Why Bigger Connection Pools Fail Under High Concurrency and What to Do Instead

Increasing a database connection pool size often worsens performance under massive traffic because the bottleneck lies in hardware limits and management overhead, so developers must adopt async processing, read‑write splitting, caching, sharding, and proper pool tuning to sustain high concurrency.

Backend PerformanceConnection PoolHigh concurrency
0 likes · 4 min read
Why Bigger Connection Pools Fail Under High Concurrency and What to Do Instead
macrozheng
macrozheng
Dec 30, 2025 · Backend Development

Mastering Druid Connection Pool in Spring Boot: Advanced Optimization Guide

This comprehensive guide walks through preparing the environment, fine‑tuning core Druid pool parameters, building a robust monitoring system, strengthening security, detecting connection leaks, applying advanced runtime tweaks, and avoiding common pitfalls to achieve high performance and stability in production Spring Boot applications.

Connection PoolDruidPerformance Tuning
0 likes · 12 min read
Mastering Druid Connection Pool in Spring Boot: Advanced Optimization Guide
Java Web Project
Java Web Project
Dec 25, 2025 · Databases

How to Super‑Optimize Druid Connection Pool in Spring Boot for Production

This guide walks through preparing the environment, fine‑tuning core Druid parameters, managing connection lifecycles, building a monitoring stack, hardening security, detecting leaks, applying advanced runtime tweaks, and avoiding common pitfalls to achieve stable, high‑performance database pooling in Spring Boot.

Connection PoolDruidPerformance Tuning
0 likes · 12 min read
How to Super‑Optimize Druid Connection Pool in Spring Boot for Production
Java Companion
Java Companion
Dec 25, 2025 · Backend Development

Druid Crashed in Production? How to Optimize the Spring Boot Connection Pool

The article explains why Druid can fail in a live Spring Boot service and provides a comprehensive, step‑by‑step optimization guide covering core pool parameters, monitoring setup, security hardening, leak detection, dynamic tuning, and best‑practice pitfalls to achieve stable, high‑performance database connections.

Connection PoolDruidPerformance Tuning
0 likes · 12 min read
Druid Crashed in Production? How to Optimize the Spring Boot Connection Pool
Architecture Digest
Architecture Digest
Dec 24, 2025 · Databases

Mastering Druid: Extreme Performance and Security Tuning in Spring Boot

This guide walks through step‑by‑step how to prepare the environment, fine‑tune core Druid connection‑pool parameters, set up comprehensive monitoring, harden security, detect leaks, and apply advanced runtime optimizations to achieve stable, high‑throughput database access in Spring Boot applications.

Connection PoolDruidPerformance Tuning
0 likes · 13 min read
Mastering Druid: Extreme Performance and Security Tuning in Spring Boot
Code Wrench
Code Wrench
Dec 13, 2025 · Databases

Mastering Database Internals for Go Interviews: Indexes, Transactions, Locks, MVCC & Connection Pools

This article equips Go backend developers with deep, interview‑ready knowledge of database internals—covering how indexes truly work, why queries can still be slow, transaction isolation levels, lock types, MVCC mechanics, and connection‑pool tuning—to avoid performance pitfalls and stand out in technical interviews.

Connection PoolGoIndexes
0 likes · 12 min read
Mastering Database Internals for Go Interviews: Indexes, Transactions, Locks, MVCC & Connection Pools
php Courses
php Courses
Dec 8, 2025 · Backend Development

How to Properly Close MySQL Connection Pools in PHP

This guide explains why closing MySQL connection pools in PHP is essential for performance, describes the basics of connection pooling, and provides step‑by‑step code examples for creating, using, and safely releasing connections, including a destructor‑based cleanup method.

Connection PoolMySQLMySQLi
0 likes · 5 min read
How to Properly Close MySQL Connection Pools in PHP
Java Tech Enthusiast
Java Tech Enthusiast
Dec 6, 2025 · Databases

6 Critical MySQL Pitfalls and How to Avoid Them

Learn how to prevent six frequent MySQL problems—including index misuse, transaction isolation anomalies, inefficient pagination, charset and collation errors, risky foreign-key cascades, and misconfigured connection pools—through detailed explanations, code examples, and practical mitigation strategies.

CharsetConnection PoolDatabase Performance
0 likes · 22 min read
6 Critical MySQL Pitfalls and How to Avoid Them
Java Backend Technology
Java Backend Technology
Nov 17, 2025 · Databases

Why a Single MySQL Connection Can Cost Over 200 ms – A Deep Dive

This article examines the detailed steps and timing of establishing a MySQL connection from a Java web application, measuring network round‑trips and total latency, and demonstrates how even a minimal connection can consume hundreds of milliseconds, making connection pooling essential for high‑traffic services.

Connection PoolDatabase ConnectionMySQL
0 likes · 8 min read
Why a Single MySQL Connection Can Cost Over 200 ms – A Deep Dive
Xiao Liu Lab
Xiao Liu Lab
Nov 12, 2025 · Operations

Why TIME_WAIT Isn't a Problem and How to Optimize It

TIME_WAIT is a normal TCP state designed to prevent stray packets, but high volumes can indicate inefficient connection handling; this guide explains its mechanics, common causes, monitoring commands, and practical kernel and application-level tuning strategies to reduce TIME_WAIT buildup in high‑traffic services.

Connection PoolLinuxNetwork
0 likes · 12 min read
Why TIME_WAIT Isn't a Problem and How to Optimize It
21CTO
21CTO
Nov 10, 2025 · Databases

MySQL vs PostgreSQL: Which Database Wins the Ingestion and Query Battle?

This article presents a detailed performance benchmark comparing MySQL 9.0 and PostgreSQL 17.0, measuring data‑ingestion latency, throughput, saturation, CPU and memory usage, as well as query efficiency, and concludes which open‑source database delivers superior write and read performance.

BenchmarkConnection PoolDatabase Performance
0 likes · 10 min read
MySQL vs PostgreSQL: Which Database Wins the Ingestion and Query Battle?
php Courses
php Courses
Oct 24, 2025 · Backend Development

Boost PHP Database Performance: Persistent Connections, Connection Pools, and Caching

Learn how to accelerate PHP database operations by employing persistent connections, implementing a connection pool, and caching query results, with clear code examples for mysqli, PDO, and Memcached that illustrate each optimization technique and its impact on reducing latency and resource usage.

CachingConnection PoolMemcached
0 likes · 5 min read
Boost PHP Database Performance: Persistent Connections, Connection Pools, and Caching
MaGe Linux Operations
MaGe Linux Operations
Oct 11, 2025 · Databases

How a Single Slow SQL Crashed Redis Pools and Triggered a Microservice Avalanche

In a microservice‑based e‑commerce platform, a seemingly harmless slow MySQL query exhausted the database connection pool, blocked Redis connections, and caused a chain reaction that filled the Redis connection pool, leading to widespread service timeouts and a full‑scale system avalanche during a high‑traffic promotion.

Connection PoolDatabase PerformanceSlow Query
0 likes · 34 min read
How a Single Slow SQL Crashed Redis Pools and Triggered a Microservice Avalanche
Cognitive Technology Team
Cognitive Technology Team
Sep 21, 2025 · Databases

How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes

An unexpected data loss issue in a ShardingSphere‑JDBC setup was traced to Druid’s poolPreparedStatements cache, which reuses PreparedStatement objects across different shards, bypassing dynamic routing; disabling the cache or switching to HikariCP restores correct sharding behavior with minimal performance impact.

Connection PoolDruidPerformance Tuning
0 likes · 12 min read
How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes
Architect's Guide
Architect's Guide
Sep 6, 2025 · Fundamentals

Mastering TCP/UDP, HTTP, and Socket Connection Pools: A Complete Guide

This article walks developers through the OSI model, explains TCP three‑way handshake and four‑way termination, compares TCP and UDP, discusses socket long connections, heartbeat mechanisms, custom application‑layer protocols, and implements a Node.js socket connection pool for high‑concurrency scenarios.

Connection PoolNetwork ProtocolsOSI model
0 likes · 17 min read
Mastering TCP/UDP, HTTP, and Socket Connection Pools: A Complete Guide
Architect
Architect
Jul 20, 2025 · Databases

Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot

This guide explains how to integrate Alibaba Druid as a Java database connection pool, add Maven dependencies, configure core properties, enable SQL and slow‑SQL monitoring, set up WebStatFilter and Spring AOP monitoring, remove the built‑in advertisement, and retrieve monitoring data via DruidStatManagerFacade.

Connection PoolDatabase MonitoringDruid
0 likes · 15 min read
Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot
Code Wrench
Code Wrench
Jul 16, 2025 · Backend Development

Build Scalable Multi‑Tenant SQL Server Pools in Go with GORM Optimizations

This guide details a complete solution for building multi‑tenant SQL Server connection pools in Go microservices, covering YAML tenant configuration, a thread‑safe pool factory, Gin middleware integration, advanced GORM query techniques, high‑concurrency optimizations, monitoring, slow‑query logging, and circuit‑breaker safeguards.

Connection PoolGORMMicroservices
0 likes · 8 min read
Build Scalable Multi‑Tenant SQL Server Pools in Go with GORM Optimizations
Cognitive Technology Team
Cognitive Technology Team
Jul 12, 2025 · Backend Development

Mastering Apache HttpClient Connection Pool: Limits, Pitfalls, and Optimization

This article explores Apache HttpClient’s connection pool mechanism, detailing key parameters such as maxConnTotal, maxConnPerRoute, and timeToLive, explains how connections are allocated and reused, highlights common misconfigurations, and provides best‑practice tuning recommendations for high‑concurrency Java applications.

Apache HttpClientConnection PoolPerformance Tuning
0 likes · 9 min read
Mastering Apache HttpClient Connection Pool: Limits, Pitfalls, and Optimization
Python Programming Learning Circle
Python Programming Learning Circle
Jun 19, 2025 · Databases

Master Python Database Access: From DB‑API Basics to Connection Pooling with PyMySQL

This guide walks you through Python's DB‑API, lists supported databases, shows how to install and use PyMySQL for basic CRUD operations, demonstrates retrieving auto‑increment IDs, prevents SQL injection, and explains thread‑safe connection pooling with DBUtils, including code examples for both locked and lock‑free scenarios.

Connection PoolDB-APIDatabase
0 likes · 15 min read
Master Python Database Access: From DB‑API Basics to Connection Pooling with PyMySQL
ITPUB
ITPUB
May 25, 2025 · Databases

MySQL vs PostgreSQL: Which Database Handles High‑Throughput Writes Faster?

A detailed benchmark comparing MySQL 9.0 and PostgreSQL 17.0 evaluates ingestion latency, throughput, saturation, and connection‑pool behavior, revealing that PostgreSQL consistently delivers lower write latency, higher QPS, better CPU and memory efficiency, and superior disk storage efficiency across both write and read workloads.

Connection PoolDatabase IngestionLatency
0 likes · 9 min read
MySQL vs PostgreSQL: Which Database Handles High‑Throughput Writes Faster?
Sohu Tech Products
Sohu Tech Products
Feb 19, 2025 · Backend Development

Using Apache Commons Pool for Object Pooling and Jedis Connection Pool in Java

The article explains how to use Apache Commons Pool to create reusable object pools in Java—showing Maven setup, a custom PooledObjectFactory, pool configuration, borrowing and returning objects, and demonstrates a Redis Jedis connection pool built on the same framework while detailing the pool’s initialization, borrowing, and return mechanisms.

Connection PoolJedisRedis
0 likes · 8 min read
Using Apache Commons Pool for Object Pooling and Jedis Connection Pool in Java
Sohu Tech Products
Sohu Tech Products
Jan 15, 2025 · Backend Development

Deep Dive into Druid Connection Pool: Initialization, Retrieval, and Recycling Explained

This technical guide breaks down Alibaba's Druid JDBC connection pool, detailing its initialization process, how connections are fetched and returned, the internal threads and condition‑signal coordination, execution handling, recommended configurations, and monitoring integration, all illustrated with code snippets and diagrams.

ConfigurationConnection PoolDatabase
0 likes · 23 min read
Deep Dive into Druid Connection Pool: Initialization, Retrieval, and Recycling Explained
Zhuanzhuan Tech
Zhuanzhuan Tech
Jan 9, 2025 · Databases

Understanding Druid Connection Pool: Initialization, Connection Acquisition, Execution, and Recycling

This article provides a comprehensive technical walkthrough of the Druid database connection pool, covering its architecture, initialization flow, connection acquisition and release mechanisms, execution and exception handling, as well as recommended configurations and monitoring practices for optimal performance.

Connection PoolDatabaseDruid
0 likes · 23 min read
Understanding Druid Connection Pool: Initialization, Connection Acquisition, Execution, and Recycling
Java Architect Essentials
Java Architect Essentials
Dec 25, 2024 · Backend Development

Understanding Java Connection Pools: Commons Pool 2, Jedis, and HikariCP Performance

This article explains the principles of object pooling in Java, introduces the Commons Pool 2 library and its use in Redis client Jedis, compares pool and non‑pool performance with JMH benchmarks, and details the fast HikariCP database connection pool along with configuration tips and interview questions.

Commons-PoolConnection PoolHikariCP
0 likes · 15 min read
Understanding Java Connection Pools: Commons Pool 2, Jedis, and HikariCP Performance
Java Backend Technology
Java Backend Technology
Nov 15, 2024 · Databases

How a MySQL Connection Takes 200ms+ and Why You Need a Pool

This article dissects the MySQL connection process using Java and Wireshark, revealing that establishing a single connection can consume over 200 ms, which scales to hours of latency for high‑traffic sites, highlighting the necessity of connection pooling and related optimizations.

Connection PoolDatabase ConnectionMySQL
0 likes · 7 min read
How a MySQL Connection Takes 200ms+ and Why You Need a Pool
Java Tech Enthusiast
Java Tech Enthusiast
Nov 9, 2024 · Databases

Java Connection Pool Optimization with HikariCP

The article examines Java connection pool technologies, comparing Commons Pool 2 with HikariCP and showing through JMH benchmarks that HikariCP delivers up to five‑times higher throughput, while detailing lifecycle management, configuration, eviction strategies, sizing best practices, and real‑world uses such as database, HTTP, and RPC connections.

Connection PoolDatabaseHikariCP
0 likes · 12 min read
Java Connection Pool Optimization with HikariCP
php Courses
php Courses
Nov 5, 2024 · Backend Development

Optimizing Database Connection Speed in PHP: Persistent Connections, Connection Pools, and Query Caching

This article explains how to speed up PHP database interactions by using persistent connections, implementing a connection pool, and caching query results, providing code examples for mysqli, PDO, and Memcached, and discusses when each technique is appropriate for improving backend performance.

Backend DevelopmentCachingConnection Pool
0 likes · 6 min read
Optimizing Database Connection Speed in PHP: Persistent Connections, Connection Pools, and Query Caching
Architect's Guide
Architect's Guide
Aug 18, 2024 · Backend Development

Why HikariCP Is So Fast: An In‑Depth Look at Its Design and Implementation

This article explains the core concepts of connection‑pool technology, details the architectural choices behind HikariCP such as dual HikariPool instances, FastList, custom ConcurrentBag, ThreadLocal caching, and byte‑code generation, and walks through the key source code that makes the pool exceptionally fast.

Backend DevelopmentConnection PoolHikariCP
0 likes · 15 min read
Why HikariCP Is So Fast: An In‑Depth Look at Its Design and Implementation
Deepin Linux
Deepin Linux
Aug 8, 2024 · Databases

Understanding Database Connection Pools: Principles, Mechanisms, and Popular Implementations

This article explains the concept of database connection pools, why they are needed, their core principles and runtime mechanisms, compares traditional direct connections with pooled connections, and reviews major Java pool implementations such as DBCP, C3P0, Druid and HikariCP along with configuration tips and best‑practice considerations.

C3P0Connection PoolDBCP
0 likes · 27 min read
Understanding Database Connection Pools: Principles, Mechanisms, and Popular Implementations
Programmer XiaoFu
Programmer XiaoFu
Aug 8, 2024 · Databases

Why Is MySQL Slow? Beyond Index Issues and Practical Fixes

The article walks through MySQL’s query execution flow, shows how to profile slow statements, explains index‑related pitfalls, connection‑pool limits, and InnoDB buffer‑pool sizing, and provides concrete commands and examples to diagnose and speed up sluggish queries.

Connection PoolEXPLAINIndex Optimization
0 likes · 15 min read
Why Is MySQL Slow? Beyond Index Issues and Practical Fixes
Su San Talks Tech
Su San Talks Tech
Jul 29, 2024 · Databases

Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks

This article explores why MySQL queries can become sluggish beyond just missing indexes, covering the full query execution flow, profiling tools, index pitfalls, connection limits, buffer pool sizing, and practical configuration tips to dramatically improve performance.

Buffer PoolConnection PoolIndex Optimization
0 likes · 15 min read
Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks
IT Services Circle
IT Services Circle
Jul 28, 2024 · Backend Development

Root Cause Analysis of Repeated Backend Service Outages: Connection Pool Exhaustion and Slow SQL

During a Monday incident where the backend service became unavailable three times, the author details step-by-step investigations—checking frontend responses, container status, JVM and thread pool metrics, and database connection pool usage—ultimately identifying a slow, unindexed SQL query that exhausted connections, and describes the remediation and lessons learned.

Connection Poolbackenddebugging
0 likes · 10 min read
Root Cause Analysis of Repeated Backend Service Outages: Connection Pool Exhaustion and Slow SQL
FunTester
FunTester
Jul 16, 2024 · Backend Development

Mastering JDBC: Best Practices for Secure and Efficient Java Database Access

This guide explains how to set up JDBC drivers, construct connection URLs, use PreparedStatement instead of Statement, iterate ResultSet safely, manage resources with try‑with‑resources, handle transactions, employ connection pools, and properly process SQLExceptions for robust Java database applications.

Connection PoolDatabaseJDBC
0 likes · 15 min read
Mastering JDBC: Best Practices for Secure and Efficient Java Database Access
Selected Java Interview Questions
Selected Java Interview Questions
Jun 24, 2024 · Backend Development

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

This article provides a comprehensive guide on integrating Alibaba's Druid connection pool into Spring Boot applications, covering its advantages, dependency setup, detailed configuration properties, built‑in filters, monitoring pages, ad removal techniques, and programmatic access to runtime statistics.

Connection PoolDruidSpring Boot
0 likes · 13 min read
Using Alibaba Druid Connection Pool in Spring Boot: Configuration, Monitoring, and Customization
IT Architects Alliance
IT Architects Alliance
Jun 23, 2024 · Databases

Configuring Druid DataSource Monitoring and Filters in Spring Boot

This guide explains the fundamentals of Druid as a Java database connection pool, how to add required Maven dependencies, configure various Druid properties and filters for SQL and web monitoring, enable slow‑SQL logging, integrate Spring AOP monitoring, remove the default Alibaba advertisement, and retrieve monitoring data via the DruidStatManagerFacade API.

Connection PoolDatabase MonitoringDruid
0 likes · 14 min read
Configuring Druid DataSource Monitoring and Filters in Spring Boot
Architect
Architect
Jun 22, 2024 · Backend Development

Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources

This guide explains how to integrate Alibaba's Druid connection pool into Spring Boot, covering basic concepts, Maven dependencies, essential configuration properties, built‑in filters, monitoring pages, SQL and slow‑query logging, Spring AOP monitoring, ad removal, and programmatic access to Druid statistics.

Connection PoolDatabase MonitoringDruid
0 likes · 16 min read
Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Apr 25, 2024 · Backend Development

Design and Implementation of a Generic Connection Pool in Go (Conecta)

This article explains the motivation, design principles, and implementation details of Conecta, a lightweight, configurable Go library that provides a universal connection pool for various services such as databases, TCP/UDP, and custom connections, complete with extensible callbacks and background health checks.

Backend DevelopmentConnection PoolGo
0 likes · 19 min read
Design and Implementation of a Generic Connection Pool in Go (Conecta)
Architect's Guide
Architect's Guide
Apr 8, 2024 · Backend Development

Why HikariCP Is So Fast: A Deep Dive into Its Implementation

This article examines why HikariCP, the default Spring Boot 2.0 connection pool, achieves high performance by exploring its design concepts such as dual HikariPool instances, FastList, custom ConcurrentBag, thread‑local caching, and bytecode optimization, and includes sample Maven configuration and Java code.

Connection PoolHikariCPPerformance
0 likes · 14 min read
Why HikariCP Is So Fast: A Deep Dive into Its Implementation
Ops Development & AI Practice
Ops Development & AI Practice
Mar 27, 2024 · Backend Development

How to Choose the Right Redis PoolSize in Go for Optimal Performance

This article explains why correctly configuring the Redis client PoolSize in Go is crucial for performance and stability, outlines key factors such as concurrency, latency, and resource limits, and provides practical strategies, benchmarking methods, and sample code to help developers determine the optimal pool size.

Connection PoolGoRedis
0 likes · 5 min read
How to Choose the Right Redis PoolSize in Go for Optimal Performance
dbaplus Community
dbaplus Community
Mar 26, 2024 · Backend Development

Why Java Apps Still Prefer Connection Pools Over IO Multiplexing for Database Access

Although IO multiplexing can boost performance, most Java applications continue to use connection pools like c3p0 or Tomcat because JDBC is blocking, DB protocols require multiple sessions, and integrating NIO drivers into existing web containers adds significant complexity and ecosystem constraints.

Connection PoolDatabase AccessIO Multiplexing
0 likes · 9 min read
Why Java Apps Still Prefer Connection Pools Over IO Multiplexing for Database Access
Architecture & Thinking
Architecture & Thinking
Mar 5, 2024 · Databases

How Database Middleware Solves High‑Traffic Challenges: Connection Pools, Sharding, and More

This article examines how database middleware tackles the demanding needs of large‑scale internet services by providing centralized connection‑pool management, transparent read‑write splitting, diverse load‑balancing algorithms, sharding support, automatic failover, security controls, comprehensive monitoring, and flexible backup‑recovery mechanisms.

Connection PoolMySQLSharding
0 likes · 9 min read
How Database Middleware Solves High‑Traffic Challenges: Connection Pools, Sharding, and More
Java Architect Essentials
Java Architect Essentials
Feb 20, 2024 · Backend Development

Why Did Our API Hang? Uncovering Redis Connection Pool Blocking in Spring Boot

A week‑long API freeze in a sandbox environment was traced to Redis connection pool misconfiguration, where threads waited indefinitely for a Jedis resource, leading to Tomcat request threads blocking and 500 errors, and the issue was resolved by adjusting pool settings and using proper connection release patterns.

Connection PoolJedisRedis
0 likes · 9 min read
Why Did Our API Hang? Uncovering Redis Connection Pool Blocking in Spring Boot
php Courses
php Courses
Feb 5, 2024 · Databases

How to Properly Close MySQL Connection Pools in PHP

This article explains the concept of MySQL connection pools in PHP, demonstrates how to create, use, and correctly close both individual connections and pooled connections using mysqli functions and a custom pool class, and highlights the importance of releasing resources to maintain application performance.

Connection PoolDatabaseMySQL
0 likes · 5 min read
How to Properly Close MySQL Connection Pools in PHP
Selected Java Interview Questions
Selected Java Interview Questions
Jan 22, 2024 · Backend Development

Why HikariCP Is So Fast: An In‑Depth Source Code Exploration

This article examines the design and implementation details of HikariCP—Spring Boot's default JDBC connection pool—explaining how its dual‑pool architecture, FastList collection, custom ConcurrentBag, bytecode‑level optimizations, and efficient connection acquisition and release mechanisms together deliver exceptional performance for Java backend applications.

Connection PoolHikariCPPerformance
0 likes · 14 min read
Why HikariCP Is So Fast: An In‑Depth Source Code Exploration
Architect
Architect
Dec 16, 2023 · Databases

Detailed Walkthrough of Druid Connection Pool Lifecycle and Configuration

This article provides an in‑depth analysis of Druid's connection‑pool lifecycle, covering initialization, connection acquisition, validation, eviction, keep‑alive, and recycling processes, while offering performance‑related configuration recommendations and code examples for Java developers.

Connection PoolDruidThread Management
0 likes · 24 min read
Detailed Walkthrough of Druid Connection Pool Lifecycle and Configuration
Architect's Guide
Architect's Guide
Dec 10, 2023 · Fundamentals

Understanding Network Protocols, TCP/UDP Handshakes, and Socket Connection Pools

This article explains the OSI seven‑layer model, the mechanics of TCP three‑way handshake and four‑way termination, differences between TCP and UDP, long‑living socket connections, custom protocol design, and how to implement a socket connection pool for high‑concurrency backend services.

Connection PoolNetwork ProtocolsOSI model
0 likes · 14 min read
Understanding Network Protocols, TCP/UDP Handshakes, and Socket Connection Pools
政采云技术
政采云技术
Nov 7, 2023 · Databases

Sharding-JDBC Startup Optimization: Analyzing and Tuning max.connections.size.per.query

This article investigates why Sharding-JDBC takes over half of the application startup time to load metadata, explains the role of the max.connections.size.per.query setting, demonstrates how adjusting it speeds up startup, and discusses the trade‑offs and potential dead‑lock risks of increasing the value.

Connection PoolDatabase ConfigurationPerformance Tuning
0 likes · 7 min read
Sharding-JDBC Startup Optimization: Analyzing and Tuning max.connections.size.per.query
DeWu Technology
DeWu Technology
Nov 1, 2023 · Backend Development

Evolution of the Rainbow Bridge Architecture: From BIO to NIO with Custom Database Driver and Connection Pool

The article chronicles the Rainbow Bridge proxy’s shift from a blocking BIO JDBC driver to a custom Netty‑based NIO driver with an event‑loop‑affine connection pool, detailing optimizations such as codec skipping and lock‑free queues that yield up to 67% higher throughput, 37% lower load, and a 98% reduction in thread usage.

AsynchronousConnection PoolDatabase Driver
0 likes · 11 min read
Evolution of the Rainbow Bridge Architecture: From BIO to NIO with Custom Database Driver and Connection Pool
ITPUB
ITPUB
Oct 30, 2023 · Databases

Why MySQL Queries Slow Down and How to Speed Them Up

This article explores common reasons MySQL queries become sluggish—beyond missing indexes—including connection limits, insufficient InnoDB buffer pool size, and query cache issues, and provides practical steps such as profiling, using FORCE INDEX, adjusting max_connections, enlarging the buffer pool, and tuning connection pools to improve performance.

Connection PoolIndexingMySQL
0 likes · 16 min read
Why MySQL Queries Slow Down and How to Speed Them Up
Architecture Digest
Architecture Digest
Oct 26, 2023 · Backend Development

Diagnosing and Resolving Redis Connection Pool Blocking in a Spring Boot Application

The article details a week‑long investigation of a sandbox environment where Spring Boot APIs became unresponsive due to Redis connection pool blocking, describing the use of system tools, JVM thread analysis, and code inspection to identify mis‑configured pool settings and recommending proper connection handling with Spring's RedisTemplate.

Connection PoolJedisPerformance
0 likes · 8 min read
Diagnosing and Resolving Redis Connection Pool Blocking in a Spring Boot Application
37 Interactive Technology Team
37 Interactive Technology Team
Oct 23, 2023 · Backend Development

Investigation of Go HTTP Client Connection Pool Not Reusing Connections

The investigation revealed that the Go http.Client was not reusing connections because response bodies were closed before being fully read, causing the underlying connections to be marked dead; fully reading the bodies restored pooling, eliminated DNS‑resolution timeouts and dramatically lowered query‑per‑second spikes.

Connection PoolDNSGo
0 likes · 9 min read
Investigation of Go HTTP Client Connection Pool Not Reusing Connections
ITPUB
ITPUB
Oct 16, 2023 · Databases

Why Did Our Redis Calls Take 1.2 Seconds? A Deep Dive into JedisPool Tuning

A load test revealed Redis latency soaring to 1.2 seconds, and a systematic investigation traced the root cause to mis‑configured JedisPool parameters, leading to excessive connection wait times and churn, which were fixed by aligning pool settings and enabling proper eviction, dramatically improving latency.

Connection PoolJedisPoolLatency
0 likes · 8 min read
Why Did Our Redis Calls Take 1.2 Seconds? A Deep Dive into JedisPool Tuning
php Courses
php Courses
Oct 9, 2023 · Backend Development

Debugging and Optimizing Database Connections in PHP

This article explains how to debug and optimize PHP database connections using PDO and mysqli, demonstrates error handling and logging techniques, and presents performance improvements such as persistent connections, connection pooling, and query optimization with practical code examples.

Connection PoolDatabaseOptimization
0 likes · 6 min read
Debugging and Optimizing Database Connections in PHP
Architect's Guide
Architect's Guide
Sep 23, 2023 · Backend Development

Understanding Network Protocols, TCP/UDP Handshakes, Socket Long Connections, and Socket Connection Pools

This article explains the fundamentals of network protocols—including the OSI model, TCP three‑way handshake and four‑way termination, UDP characteristics, long versus short socket connections, custom application‑layer protocols, and how to implement a reusable socket connection pool in Node.js.

Backend DevelopmentConnection PoolUDP
0 likes · 17 min read
Understanding Network Protocols, TCP/UDP Handshakes, Socket Long Connections, and Socket Connection Pools
Architect
Architect
Jul 11, 2023 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing

The article explains that database connection pools remain based on blocking I/O because JDBC was designed for BIO, managing session state per connection, and the ecosystem lacks a unified non‑blocking driver, making IO multiplexing technically possible but practically complex and rarely needed.

Connection PoolIO MultiplexingJDBC
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing
Top Architect
Top Architect
Jul 6, 2023 · Databases

Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines

This article translates and expands on HikariCP's pool‑sizing guidance, explaining why smaller database connection pools often yield better performance, presenting real‑world benchmark data for various pool sizes, and offering a simple formula to calculate an optimal pool size based on CPU cores and effective disks.

Connection PoolHikariCPPostgreSQL
0 likes · 10 min read
Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines
Java Architect Essentials
Java Architect Essentials
Jun 30, 2023 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing in Java

Although IO multiplexing can improve performance, Java applications typically use traditional connection pools like c3p0 or Tomcat because JDBC is built on blocking I/O, DB sessions require separate connections, and integrating NIO would complicate program architecture, making connection pools the pragmatic, mature solution.

Connection PoolDatabaseIO Multiplexing
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing in Java
JD Cloud Developers
JD Cloud Developers
Jun 28, 2023 · Backend Development

How testOnBorrow Guarantees Reliable DB Connections in Apache Commons DBCP

This article examines the testOnBorrow mechanism in Apache Commons DBCP, detailing how validation occurs at each layer—from the commons‑pool framework through the DBCP implementation down to the MySQL driver—to ensure robust and high‑availability database connections.

Apache Commons DBCPConnection PoolDatabase Connectivity
0 likes · 7 min read
How testOnBorrow Guarantees Reliable DB Connections in Apache Commons DBCP
Java Architect Essentials
Java Architect Essentials
Jun 11, 2023 · Backend Development

Understanding Java Object Pooling: Commons Pool 2, Jedis Integration, and HikariCP Performance

This article explains Java object pooling concepts, introduces the Commons Pool 2 library, demonstrates its use with Redis via Jedis, compares performance with JMH benchmarks, and discusses the high‑performance HikariCP database connection pool, including configuration tips and common interview questions.

Connection PoolHikariCPJMH
0 likes · 15 min read
Understanding Java Object Pooling: Commons Pool 2, Jedis Integration, and HikariCP Performance
Liangxu Linux
Liangxu Linux
Jun 9, 2023 · Backend Development

Master TCP/UDP, Socket Long Connections, and a Node.js Socket Pool

This tutorial walks developers through the OSI model, explains TCP three‑way handshake and four‑step teardown, compares TCP and UDP, addresses common TCP questions, and shows how to implement long‑living socket connections and a reusable socket connection pool in Node.js.

Connection PoolNetwork ProtocolsNode.js
0 likes · 16 min read
Master TCP/UDP, Socket Long Connections, and a Node.js Socket Pool
21CTO
21CTO
Jun 6, 2023 · Backend Development

Mastering TCP/UDP, Sockets, and Connection Pools: From OSI Model to Node.js

This comprehensive guide walks you through the OSI seven‑layer model, explains TCP and UDP fundamentals, details the three‑way handshake and four‑way termination, compares long and short connections, introduces heartbeat packets, and demonstrates how to build a custom protocol and a socket connection pool in Node.js.

Connection PoolNetwork ProtocolsNode.js
0 likes · 16 min read
Mastering TCP/UDP, Sockets, and Connection Pools: From OSI Model to Node.js
Selected Java Interview Questions
Selected Java Interview Questions
Jun 2, 2023 · Backend Development

Java Connection Pooling: Commons Pool 2, Jedis, and HikariCP

This article explains the principles of object pooling in Java, introduces the Commons Pool 2 library, demonstrates its use with Redis client Jedis, compares performance with JMH benchmarks, and discusses the high‑performance HikariCP database connection pool, including configuration tips and interview questions.

Commons-PoolConnection PoolHikariCP
0 likes · 14 min read
Java Connection Pooling: Commons Pool 2, Jedis, and HikariCP