Skip to content
Tagged articles

Connection Pool

233 articles · Page 2 of 3
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 PoolFault Tolerancemonitoring
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.

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

BackendConnection PoolPHP
0 likes · 5 min read
How to Properly Close MySQL Connection Pools in PHP
Nullbody Notes
Nullbody Notes
Jan 25, 2024 · Backend Development

Building a Redis Connection Pool in Go: Design and Implementation

This article walks through the design and Go implementation of a reusable Redis connection pool, covering the pool data structure, object acquisition and release logic, handling of active limits and waiting queues, and an extended per‑IP socket pool for distributed Redis clusters.

BackendConcurrencyConnection Pool
0 likes · 10 min read
Building a Redis Connection Pool in Go: Design and Implementation
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.

BackendConcurrencyConnection Pool
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 PoolDruidJava
0 likes · 24 min read
Detailed Walkthrough of Druid Connection Pool Lifecycle and Configuration
政采云技术
政采云技术
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.

Connection PoolDatabase DriverNIO
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.

ArthasConnection PoolDebugging
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 PoolJedisPoolPerformance Tuning
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 PoolDebuggingOptimization
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.

Connection PoolUDPbackend development
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.

BackendConnection PoolIO Multiplexing
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 PoolIO MultiplexingJDBC
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 PoolNode.jsUDP
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 PoolNode.jsSocket
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
Architecture Digest
Architecture Digest
May 29, 2023 · Fundamentals

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

This article explains the OSI seven‑layer model, the principles and handshake processes of TCP and UDP, the differences between them, the concept of long‑living socket connections with heartbeats, custom application‑layer protocols, and how to implement a reusable socket connection pool in Node.js.

Connection PoolNode.jsSocket
0 likes · 16 min read
Understanding Network Protocols, TCP/UDP Handshakes, Socket Long Connections, and Socket Connection Pools
MaGe Linux Operations
MaGe Linux Operations
May 28, 2023 · Fundamentals

Master TCP/UDP, Sockets & Connection Pools: From OSI Model to Node.js

This article walks developers through network protocol fundamentals, explaining the OSI seven‑layer model, TCP three‑handshake and four‑teardown processes, UDP characteristics, long‑vs‑short connections, heartbeat mechanisms, custom protocol design, and a practical Node.js socket connection‑pool implementation.

Connection PoolNode.jsOSI model
0 likes · 16 min read
Master TCP/UDP, Sockets & Connection Pools: From OSI Model to Node.js
Architect
Architect
May 25, 2023 · Fundamentals

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

This article explains the OSI seven‑layer model, the differences between TCP and UDP, the three‑way handshake and four‑step termination processes, long‑living socket connections, heartbeat mechanisms, custom application‑layer protocols, and how to implement a socket connection pool using Node.js.

Connection PoolSocketTCP
0 likes · 17 min read
Understanding Network Protocols, TCP/UDP Handshakes, and Socket Connection Pools
JD Cloud Developers
JD Cloud Developers
May 25, 2023 · Backend Development

Why Does Full GC Stall During Sales Peaks? A Deep Dive into DB Connection Pool Issues

During a major sales promotion, an API suffered timeouts due to Full GC pauses over 500 ms, which were traced to stale MySQL connections in the DBCP pool accumulating in the old generation; the article details the investigation steps, root cause, and mitigation strategies such as switching to G1 GC and adjusting eviction settings.

Connection PoolGCJava
0 likes · 6 min read
Why Does Full GC Stall During Sales Peaks? A Deep Dive into DB Connection Pool Issues
Architect's Tech Stack
Architect's Tech Stack
May 24, 2023 · Backend Development

Understanding Java Connection Pools: 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 details the configuration and advantages of the high‑performance HikariCP database connection pool.

Commons-PoolConnection PoolHikariCP
0 likes · 17 min read
Understanding Java Connection Pools: Commons Pool 2, Jedis, and HikariCP
Java Architect Essentials
Java Architect Essentials
Apr 16, 2023 · Databases

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

This article introduces Alibaba's Druid database connection pool, explains its core features and filters, shows how to add the Maven starter, configure properties and filters in Spring Boot, demonstrates the built‑in monitoring pages, slow‑SQL logging, Spring AOP integration, and provides methods to remove the default advertisement and retrieve monitoring data via code.

Connection PoolDruidSQL
0 likes · 16 min read
Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization
37 Interactive Technology Team
37 Interactive Technology Team
Feb 10, 2023 · Backend Development

Analysis of Golang SQL Connection Pool Mechanism and Usage

The article examines Go’s database/sql connection pool implementation, showing how reusing connections cuts latency, explains idle/in‑use/closed state transitions, details configuration parameters such as MaxIdleConns and MaxOpenConns, demonstrates metric collection via Gorm DBStats for monitoring, and provides a stress‑test illustrating the impact of proper tuning.

Connection PoolGORMMetrics
0 likes · 10 min read
Analysis of Golang SQL Connection Pool Mechanism and Usage
Code Ape Tech Column
Code Ape Tech Column
Dec 22, 2022 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing (Java Interview Question)

The article explains why Java applications typically use traditional database connection pools instead of IO multiplexing, covering JDBC’s blocking design, session management, ecosystem maturity, and the complexity of integrating non‑blocking I/O with existing frameworks, while noting that a non‑blocking implementation is technically feasible.

BackendConnection PoolIO Multiplexing
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing (Java Interview Question)
Su San Talks Tech
Su San Talks Tech
Sep 28, 2022 · Databases

Why MySQL Queries Slow Down and How to Speed Them Up

This article explains the common reasons MySQL queries become sluggish—beyond missing indexes—including connection limits, buffer pool size, and query cache, and provides practical solutions such as profiling, adjusting connection pools, tuning InnoDB settings, and using force index.

Buffer PoolConnection PoolIndexing
0 likes · 16 min read
Why MySQL Queries Slow Down and How to Speed Them Up
IT Services Circle
IT Services Circle
Sep 21, 2022 · Backend Development

Understanding HikariCP's ConcurrentBag: A Deep Dive into Lock‑Free Connection Pooling

This article explains how HikariCP's lock‑free ConcurrentBag manages database connections using ThreadLocal caches, a CopyOnWriteArrayList, AtomicInteger waiters, and a SynchronousQueue, and walks through the key code for borrowing and returning connections to improve Java multithreaded performance.

ConcurrencyConcurrentBagConnection Pool
0 likes · 11 min read
Understanding HikariCP's ConcurrentBag: A Deep Dive into Lock‑Free Connection Pooling
Top Architect
Top Architect
Aug 29, 2022 · Mobile Development

Understanding OkHttp: Request Flow, Dispatcher, Interceptors, Connection Reuse, and Design Patterns

This article provides a comprehensive overview of OkHttp, covering its overall request process, the role of the dispatcher, how application and network interceptors work, TCP connection reuse via the connection pool, idle‑connection cleanup, key advantages, and the design patterns employed in the framework.

AndroidConnection PoolDesign Patterns
0 likes · 15 min read
Understanding OkHttp: Request Flow, Dispatcher, Interceptors, Connection Reuse, and Design Patterns
Java High-Performance Architecture
Java High-Performance Architecture
Aug 12, 2022 · Backend Development

Mastering Java Connection Pools: From Commons Pool to HikariCP Performance Secrets

This article explains why pooling costly resources like database connections improves performance, introduces the Commons Pool 2 library and its core classes, demonstrates a Jedis pool with JMH benchmarks showing a 5× throughput boost, and dives into HikariCP's optimizations, configuration tips, and common interview questions.

Commons-PoolConnection PoolHikariCP
0 likes · 15 min read
Mastering Java Connection Pools: From Commons Pool to HikariCP Performance Secrets
FunTester
FunTester
Jul 18, 2022 · Databases

Why MySQL’s MysqlConnectionPoolDataSource Isn’t a Real Connection Pool (And How to Use It)

The article examines the MySQL class com.mysql.cj.jdbc.MysqlConnectionPoolDataSource, revealing that despite its name it creates new connections each request and only recycles idle ones, provides a practical Groovy example, highlights pitfalls such as duplicate setURL methods, and concludes it’s unsuitable as a true pool for testing.

Connection PoolGroovyJava
0 likes · 5 min read
Why MySQL’s MysqlConnectionPoolDataSource Isn’t a Real Connection Pool (And How to Use It)
dbaplus Community
dbaplus Community
Jul 11, 2022 · Databases

Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them

This article explains why MySQL queries can become sluggish, covering the full query execution flow, profiling techniques, index pitfalls, connection‑pool limits, buffer‑pool sizing, and additional performance tricks, while providing concrete commands and code examples for each optimization step.

Buffer PoolConnection Poolindex optimization
0 likes · 16 min read
Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them
Top Architect
Top Architect
Jul 1, 2022 · Databases

Analyzing the Time Cost of Establishing MySQL Database Connections in Java Web Applications

This article examines how a MySQL connection is created from a Java web application, breaking down the TCP handshake, authentication, and variable‑setting steps with Wireshark captures, measuring latency, and demonstrating why connection pooling is essential to avoid hundreds of milliseconds of overhead per request.

Connection PoolDatabase ConnectionJava
0 likes · 7 min read
Analyzing the Time Cost of Establishing MySQL Database Connections in Java Web Applications
FunTester
FunTester
Jun 27, 2022 · Backend Development

Implementing a Custom MySQL Connection Pool with Apache Commons Pool2 in Java

The article explains how to build a reusable MySQL connection pool in Java using Apache Commons Pool2, detailing the creation of a poolable object, a factory class, the pool configuration, and a simple API wrapper for borrowing and returning connections while providing full source code examples.

Connection PoolJavacommons-pool2
0 likes · 7 min read
Implementing a Custom MySQL Connection Pool with Apache Commons Pool2 in Java
Baidu Geek Talk
Baidu Geek Talk
Jun 22, 2022 · Databases

Analyzing Go SQL Connection Pool Resource Release and Transaction Management

The article explains how Go's database/sql pool retains connections until Rows, Stmt, or Tx objects are explicitly closed or a timeout context is cancelled, demonstrates experiments showing blocked goroutines when resources aren't released, and offers practical guidelines—using QueryContext with timeouts, deferring Close/Cancel, and always committing or rolling back transactions—to prevent pool exhaustion and improve MySQL reliability.

Connection PoolGoSQL
0 likes · 19 min read
Analyzing Go SQL Connection Pool Resource Release and Transaction Management
Su San Talks Tech
Su San Talks Tech
Jun 6, 2022 · Databases

Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them

This article explores the various reasons MySQL queries become slow—including index misuse, insufficient connection pools, small InnoDB buffer pools, and query cache limitations—while providing practical solutions such as optimizing indexes, adjusting max_connections, enlarging buffer pools, and configuring connection pools for better performance.

Connection PoolInnoDBPerformance Tuning
0 likes · 16 min read
Why Is MySQL Query Slow? Hidden Factors Beyond Indexes and How to Fix Them
ITPUB
ITPUB
Apr 29, 2022 · Databases

How to Fix MySQL 500 Errors by Tuning wait_timeout and autoReconnect

After deploying a project, a 500 Server Error appears the next day due to MySQL closing idle connections after the default 8‑hour wait_timeout, and the article explains how to verify the issue, adjust wait_timeout, use autoReconnect, and properly configure the HikariCP connection pool to prevent the failure.

BackendConnection PoolHikariCP
0 likes · 7 min read
How to Fix MySQL 500 Errors by Tuning wait_timeout and autoReconnect
Open Source Linux
Open Source Linux
Apr 25, 2022 · Backend Development

Master TCP/UDP, Sockets & Connection Pools in Node.js – From Basics to Advanced

This article walks developers through the fundamentals of the OSI model, TCP three‑way handshake and UDP characteristics, explains socket concepts, demonstrates Node.js server and client implementations with heartbeats and custom protocols, and details how to build and use a socket connection pool with the generic‑pool library.

Connection PoolNode.jsSocket
0 likes · 39 min read
Master TCP/UDP, Sockets & Connection Pools in Node.js – From Basics to Advanced
MaGe Linux Operations
MaGe Linux Operations
Apr 4, 2022 · Backend Development

Mastering gRPC Connection Pools: Design Principles and Tuning Tips

This article explains how to design a gRPC connection pool, covering scaling rules, idle‑connection timeout and keep‑alive, pool‑full handling, core gRPC features, and practical tuning parameters to achieve high performance in high‑concurrency backend services.

BackendConnection PoolgRPC
0 likes · 13 min read
Mastering gRPC Connection Pools: Design Principles and Tuning Tips
NiuNiu MaTe
NiuNiu MaTe
Mar 30, 2022 · Databases

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

This article explains why MySQL queries can become sluggish beyond missing indexes, covering the full query execution flow, profiling tools, index pitfalls, connection‑pool limits, InnoDB buffer‑pool sizing, and practical steps to diagnose and accelerate database performance.

Buffer PoolConnection PoolIndexing
0 likes · 16 min read
Why Is MySQL Query Slow? Hidden Factors and Proven Speed‑Up Tricks
Code Ape Tech Column
Code Ape Tech Column
Mar 17, 2022 · Databases

Understanding the Druid Connection Pool Lifecycle and Management

This article provides a comprehensive walkthrough of Druid's connection pool lifecycle, detailing how getConnection initiates the process, the role of initialization, filter chains, connection validation, thread‑blocking strategies, and the various guardian threads that add, evict, and recycle connections to ensure performance and stability.

Connection PoolDruidJava
0 likes · 24 min read
Understanding the Druid Connection Pool Lifecycle and Management
IT Services Circle
IT Services Circle
Mar 15, 2022 · Backend Development

Understanding Pooling Techniques: Thread Pools, Memory Pools, Database Connection Pools, and HttpClient Pools in Java

This article explains the concept of pooling technology, its advantages, and its practical applications in Java—including thread pools, memory pools, database connection pools, and HttpClient connection pools—while highlighting how these techniques improve performance, resource utilization, and system stability.

Connection PoolJavamemory pool
0 likes · 10 min read
Understanding Pooling Techniques: Thread Pools, Memory Pools, Database Connection Pools, and HttpClient Pools in Java
IT Services Circle
IT Services Circle
Feb 20, 2022 · Databases

Understanding and Optimizing Database Connection Pools with Go and MySQL

This article explains how improper use of database connection pools can cause service timeouts, demonstrates with Go and MySQL how to configure and test connection pooling, shows performance improvements through reuse, and encourages developers to implement their own pools for better efficiency.

Connection Poolgolang
0 likes · 8 min read
Understanding and Optimizing Database Connection Pools with Go and MySQL
Top Architect
Top Architect
Feb 8, 2022 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing

The article explains why traditional Java database connection pools rely on blocking I/O instead of IO multiplexing, covering JDBC's design, session management, resource constraints, and the practical challenges of adopting non‑blocking approaches in mainstream backend systems.

Connection PoolJDBCJava
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing
FunTester
FunTester
Jan 24, 2022 · Backend Development

Custom Java DNS Resolver with Apache HttpClient: InMemoryDnsResolver and SystemDefaultDnsResolver

This article demonstrates how to implement custom DNS resolvers in Java using Apache HttpClient's InMemoryDnsResolver and SystemDefaultDnsResolver classes, provides sample code for each, shows integration with a connection pool manager, and includes a simple test to verify hostname resolution.

Apache HttpClientConnection PoolCustom Resolver
0 likes · 7 min read
Custom Java DNS Resolver with Apache HttpClient: InMemoryDnsResolver and SystemDefaultDnsResolver
Programmer DD
Programmer DD
Jan 21, 2022 · Databases

Why Java DB Connection Pools Skip IO Multiplexing (And What It Means)

This article explains why Java database connection pools typically use blocking I/O and connection pooling instead of IO multiplexing, covering JDBC's design, session management, ecosystem constraints, and the trade‑offs between performance and code complexity.

Connection PoolIO MultiplexingJDBC
0 likes · 8 min read
Why Java DB Connection Pools Skip IO Multiplexing (And What It Means)
Architect's Tech Stack
Architect's Tech Stack
Jan 11, 2022 · Backend Development

Diagnosing Redis Connection Pool Blocking in a Spring Boot Application

The article details a week‑long investigation of unresponsive APIs in a sandbox environment, tracing the root cause to Redis connection pool blocking in a Spring Boot service, and presents step‑by‑step debugging, code analysis, configuration fixes, and best‑practice recommendations for proper Redis usage.

ArthasConnection PoolDebugging
0 likes · 9 min read
Diagnosing Redis Connection Pool Blocking in a Spring Boot Application
Top Architect
Top Architect
Jan 2, 2022 · Backend Development

Debugging Redis Connection Pool Blocking Issues in a Spring Backend Application

The article details a step‑by‑step investigation of a Spring‑based backend where API requests hung due to Redis connection pool misconfiguration, showing how thread dumps, jstack, and Arthas were used to pinpoint blocking in Jedis pool acquisition, and provides corrected configuration and proper connection handling recommendations.

Connection PoolDebuggingJedis
0 likes · 9 min read
Debugging Redis Connection Pool Blocking Issues in a Spring Backend Application
New Oriental Technology
New Oriental Technology
Dec 29, 2021 · Databases

Understanding HikariCP: Architecture, Core Components, and Usage

This article explains how HikariCP, the default Spring Boot 2.x connection pool, improves database performance through byte‑code optimization, custom containers, and streamlined code, and it details the internal classes, lifecycle methods, configuration, monitoring, and practical usage examples.

Connection PoolHikariCPJava
0 likes · 21 min read
Understanding HikariCP: Architecture, Core Components, and Usage
政采云技术
政采云技术
Oct 28, 2021 · Backend Development

HikariCP Overview (Part 1): Initialization, Core Components, Monitoring and Configuration

This article provides a detailed analysis of HikariCP’s initialization, core components, startup flow, connection acquisition logic, monitoring metrics, and key configuration parameters, illustrating how Spring Boot 2.x leverages this high‑performance JDBC connection pool and offering guidance for tuning and extending it.

Connection PoolHikariCPJava
0 likes · 14 min read
HikariCP Overview (Part 1): Initialization, Core Components, Monitoring and Configuration
dbaplus Community
dbaplus Community
Oct 24, 2021 · Backend Development

Fixing 18B Daily Dubbo Calls: Solving Redis Connection Pool Exhaustion

When a Dubbo interface handling 18 billion daily requests began failing due to thread‑pool exhaustion, a systematic investigation uncovered traffic spikes, Redis request overload, and mis‑configured connection‑pool parameters, leading to a series of targeted fixes—including timeout adjustments, Redis scaling, and pool‑parameter tuning—that restored stability and dramatically reduced error rates.

Connection PoolDubboJava
0 likes · 16 min read
Fixing 18B Daily Dubbo Calls: Solving Redis Connection Pool Exhaustion
FunTester
FunTester
Sep 2, 2021 · Backend Development

How to Build a Robust Redis Connection Pool Wrapper in Java for Performance Testing

This article walks through creating a reusable Redis connection‑pool manager and a functional wrapper class in Java, explaining pooling concepts, resource recycling, and providing ready‑to‑use methods for common Redis commands to support efficient performance testing with the FunTester framework.

Connection PoolJavaRedis
0 likes · 18 min read
How to Build a Robust Redis Connection Pool Wrapper in Java for Performance Testing
vivo Internet Technology
vivo Internet Technology
Jul 7, 2021 · Databases

Lettuce vs Jedis: Features, Usage, and Comparison of Java Redis Clients

Lettuce, a thread‑safe, Netty‑based Java Redis client supporting synchronous, asynchronous, reactive, Cluster, Sentinel, pipelining and custom codecs, outperforms Jedis’s non‑thread‑safe pooled connections by reducing resource consumption, simplifying Spring integration, and offering advanced features like read‑write splitting, topology refresh, and optional pooling for high‑throughput applications.

Connection PoolJavaJedis
0 likes · 15 min read
Lettuce vs Jedis: Features, Usage, and Comparison of Java Redis Clients
Programmer DD
Programmer DD
Jun 23, 2021 · Backend Development

Why Spring Boot APIs Hang: Debugging a Redis Connection Pool Deadlock

A week‑long API freeze in a sandbox environment was traced to Redis connection pool deadlocks caused by missing pool configuration and improper connection handling, and the article walks through the diagnosis with top, jstack, Arthas, and the code changes needed to fix it.

ArthasConnection PoolDebugging
0 likes · 9 min read
Why Spring Boot APIs Hang: Debugging a Redis Connection Pool Deadlock
vivo Internet Technology
vivo Internet Technology
Jun 16, 2021 · Backend Development

Troubleshooting Dubbo Thread Pool Exhaustion: A Redis Performance Optimization Case Study

The case study details how a high‑traffic Dubbo service handling 1.8 billion daily requests suffered periodic circuit‑breaks due to thread‑pool exhaustion, traced to a cache‑bypass bug, Redis setex spikes, and an improperly warmed commons‑pool2 connection pool, and resolved by fixing the bug, scaling Redis, and tuning or downgrading the pool configuration to enable pre‑warming via minEvictableIdleTimeMillis.

Circuit BreakingConnection PoolDubbo
0 likes · 13 min read
Troubleshooting Dubbo Thread Pool Exhaustion: A Redis Performance Optimization Case Study
IT Xianyu
IT Xianyu
Jun 16, 2021 · Databases

Understanding Database Connection Pools vs. ThreadLocal in Java

This article explains the fundamental differences between database connection pools and ThreadLocal‑cached connections in Java, illustrating how connection pools improve performance while ThreadLocal enables sharing a single connection across methods within the same thread for consistent transaction control, and discusses practical usage patterns.

Connection PoolJavaThreadLocal
0 likes · 7 min read
Understanding Database Connection Pools vs. ThreadLocal in Java
Java Backend Technology
Java Backend Technology
Jun 12, 2021 · Databases

Why My Spring API Stalled: Debugging Redis Connection Pool Blocking

A Spring‑based service repeatedly hung because Redis connections were never returned to the pool, leading to thread starvation; the article walks through the investigation using top, jstack, Arthas, and code analysis, then shows the proper way to use RedisCallback and release connections to prevent the deadlock.

Connection PoolDebuggingJava
0 likes · 9 min read
Why My Spring API Stalled: Debugging Redis Connection Pool Blocking
Java Interview Crash Guide
Java Interview Crash Guide
Jun 8, 2021 · Backend Development

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

After a week of intermittent API hangs in an internal sandbox, we traced the issue to Redis connection pool blocking caused by missing max‑wait configuration, leading to threads waiting indefinitely; by adjusting Jedis pool settings, using proper connection release, and avoiding unsupported commands, the deadlock was resolved.

Connection PoolDebuggingJava
0 likes · 9 min read
Why Did Our Spring API Hang? Uncovering Redis Connection Pool Blocking
Youzan Coder
Youzan Coder
May 31, 2021 · Backend Development

16 TCP Network Programming Best Practices for Building Robust Applications

The article presents sixteen practical TCP network‑programming best practices—from setting SO_REUSEADDR and defining port standards to using application‑layer heartbeats, exponential backoff, connection limits, client‑side load balancing, periodic DNS refresh, optimal buffer sizing, configurable timeouts, proper connection‑pool sizing, and comprehensive metrics—to help developers build stable, reliable applications.

Connection PoolLoad BalancingNetwork Monitoring
0 likes · 28 min read
16 TCP Network Programming Best Practices for Building Robust Applications
macrozheng
macrozheng
May 17, 2021 · Databases

Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested

This article introduces the importance of database connections, compares three popular Java connection pools (DBCP, C3P0, Druid) with code examples, runs performance tests inserting 100 k and 1 M rows on MySQL, Oracle and PostgreSQL, and concludes with recommendations on the most stable pool and optimal databases.

Connection PoolDruidJava
0 likes · 11 min read
Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested
Java Backend Technology
Java Backend Technology
May 16, 2021 · Backend Development

Why ThreadLocal and Connection Pools Differ: Master Transaction Management in Java

This article explains the fundamental differences between database connection pools and ThreadLocal in Java, showing how pools improve performance while ThreadLocal enables sharing a single connection across a thread for seamless transaction control, and clarifies common misconceptions with code examples and practical insights.

Connection PoolJavaThreadLocal
0 likes · 6 min read
Why ThreadLocal and Connection Pools Differ: Master Transaction Management in Java
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 7, 2021 · Databases

Resolving MySQL wait_timeout Issues with Druid Connection Pool Configuration

This article analyzes the root causes of MySQL 'wait_timeout' related exceptions in a backend system using MHA read/write separation, explains how oversized connection pool timeout settings and MySQL wait_timeout lead to idle connections being closed, and provides practical Druid configuration adjustments and alternative solutions to eliminate the errors.

BackendConnection PoolDruid
0 likes · 7 min read
Resolving MySQL wait_timeout Issues with Druid Connection Pool Configuration
Laravel Tech Community
Laravel Tech Community
Feb 25, 2021 · Databases

Python Database Operations: Using DB-API, PyMySQL, and Connection Pools

This article introduces Python's DB-API for interacting with various databases, explains how to use PyMySQL and MySQLdb for MySQL operations, demonstrates basic CRUD examples, shows techniques to prevent SQL injection, and presents connection pooling solutions with DBUtils for multi‑threaded applications.

Connection PoolDB-APIPyMySQL
0 likes · 14 min read
Python Database Operations: Using DB-API, PyMySQL, and Connection Pools
Code Ape Tech Column
Code Ape Tech Column
Feb 24, 2021 · Databases

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

This article translates and expands on a HikariCP wiki post, explaining why smaller database connection pools often yield better performance, presenting benchmark videos and data, describing the underlying CPU, disk, and network constraints, and offering a simple formula to calculate an optimal pool size for typical server configurations.

Connection PoolDatabase PerformanceHikariCP
0 likes · 9 min read
Understanding HikariCP Connection Pool Sizing: Principles, Experiments, and Practical Guidelines
NiuNiu MaTe
NiuNiu MaTe
Feb 8, 2021 · Databases

Estimating MySQL TCP Connections for 100 Writes/sec Over 5 Seconds

This article analyzes how many TCP connections MySQL will open when writing data at 100 rows per second for five seconds, examining MySQL processing capacity and connection‑pool configuration to illustrate the key factors that affect connection count.

Connection PoolTCP connectionsmysql
0 likes · 8 min read
Estimating MySQL TCP Connections for 100 Writes/sec Over 5 Seconds
Sohu Tech Products
Sohu Tech Products
Jan 20, 2021 · Mobile Development

OkOne: An Unintrusive OkHttp Performance Optimization Framework for Android

This article introduces OkOne, a lightweight framework built on OkHttp that centralizes client management to reduce redundant instances, demonstrates step‑by‑step integration, shows performance gains through instance and connection reuse, and explores advanced features such as pre‑connect and detailed internal mechanisms.

Connection PoolOkHttpOkOne
0 likes · 13 min read
OkOne: An Unintrusive OkHttp Performance Optimization Framework for Android
MaGe Linux Operations
MaGe Linux Operations
Sep 29, 2020 · Databases

Master Python Database Access: From DB‑API to Connection Pools

This article introduces Python's DB‑API for interacting with various databases, explains how to use PyMySQL and SQLAlchemy for MySQL, demonstrates basic CRUD operations, safeguards against SQL injection, and shows how to implement thread‑safe connection pools with DBUtils for scalable backend applications.

Connection PoolDBAPIDBUtils
0 likes · 17 min read
Master Python Database Access: From DB‑API to Connection Pools
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 29, 2020 · Backend Development

Analyzing and Fixing Netty FixedChannelPool Connection Timeout Bugs

This article investigates a recurring Netty connection‑pool timeout bug caused by missing acquire‑timeout handling, explains the internal workings of FixedChannelPool's acquire and release mechanisms, and presents a corrected implementation that configures an AcquireTimeoutAction, adjusts pool sizes, and removes premature timeout calls.

Connection PoolFixedChannelPoolJava
0 likes · 29 min read
Analyzing and Fixing Netty FixedChannelPool Connection Timeout Bugs