Tagged articles
Connection Management
32 articles · Page 1 of 1
This article details PostgreSQL daily operations including connection management, slow query analysis using pg_stat_statements, and VACUUM maintenance for dead tuple cleanup, offering practical SQL queries, configuration guidance, and a checklist for DBAs and DevOps engineers.
Autovacuum TuningConnection ManagementDevOps
0 likes · 29 min read

A midnight alert revealed latency jumping from 20 ms to 200 ms despite healthy CPU and memory, leading to an investigation that uncovered TCP connection handling—handshake delays, TIME_WAIT buildup, and CPU overhead—as the hidden bottleneck, and explains why short connections must evolve into pooled, globally managed connections at tens of millions of QPS.
Connection ManagementTCPconnection pool
0 likes · 18 min read

This guide walks through MySQL’s core memory, I/O, connection, and system variable settings—explaining each parameter’s role, recommended values, and example commands—so you can systematically adjust the configuration, monitor key metrics, and achieve up to three‑fold performance gains.
Connection ManagementDatabase ConfigurationInnoDB
0 likes · 9 min read

Netty services can accumulate CLOSE_WAIT sockets when the server fails to close its side of the socket, leading to resource exhaustion and potential service collapse; this article explains the TCP state machine, common code pitfalls, kernel tuning, defensive handlers, and a comprehensive checklist to prevent and resolve the issue.
Connection ManagementJavaNetty
0 likes · 8 min read

This article explains how smart-socket manages connections through AioSession objects, a detailed session state machine, state event listeners, built‑in MonitorPlugin for real‑time statistics, custom plugins for connection limiting and blacklisting, session attribute handling, and network monitoring via NetMonitor, concluding with best‑practice recommendations.
Connection ManagementJavamonitoring
0 likes · 12 min read

This comprehensive tutorial explains TCP's connection establishment and termination processes, covering protocol features, key flag definitions, step‑by‑step three‑way handshake and four‑way teardown, common interview questions, TIME_WAIT details, abnormal scenarios, and a Wireshark packet‑capture walkthrough.
Connection ManagementTCPhandshake
0 likes · 11 min read

This article explains how cloud‑native game services can achieve precise, state‑aware connection management and graceful shutdown by combining OpenKruiseGame with a cloud‑native API gateway, detailing the challenges of seven‑layer networking, the custom lifecycle hooks, deployment steps, and the benefits of zero‑downtime configuration changes.
API GatewayConnection ManagementOpenKruiseGame
0 likes · 11 min read

TIME_WAIT is a TCP state that appears on the side actively closing a connection; when many sockets linger in this state, ports are exhausted, causing connection failures, and the article explains typical scenarios, underlying causes, kernel limits, and practical client‑ and server‑side solutions.
Connection ManagementLinuxTCP
0 likes · 5 min read

KeyDB, a Redis fork, replaces the single‑threaded design with a multi‑threaded architecture using a main thread and worker I/O threads, SO_REUSEPORT, per‑thread connection lists, fastlock spin‑lock mechanisms, asynchronous pipelines, and active‑replica support, enabling higher concurrency while remaining 100 % Redis‑compatible.
Connection ManagementKeyDBMultithreading
0 likes · 8 min read

Learn how to efficiently configure and manage database connections in FastAPI, covering synchronous and asynchronous setups, dependency injection, session handling, and testing strategies, to prevent leaks, boost performance, and ensure scalable, reliable applications.
Connection ManagementFastAPISQLAlchemy
0 likes · 8 min read

This article explains MySQL's memory architecture, why memory usage often stays high after spikes, and provides practical steps—including connection checks, slow query analysis, workload scaling, and switching to jemalloc—to diagnose and reduce memory consumption on 360's internal cloud platform.
Connection ManagementDatabase PerformanceMySQL
0 likes · 7 min read

KeyDB, a Redis fork, replaces the single‑threaded architecture with a multi‑threaded model using a main thread and worker I/O threads, SO_REUSEPORT, per‑thread connection management, fastlock spin‑lock mechanisms, and active‑replica support, enabling concurrent data access and improved performance.
Connection ManagementKeyDBRedis
0 likes · 9 min read

This article explains the TCP state machine, details the four-way handshake, analyzes why the TIME_WAIT state lasts for two MSL intervals, and illustrates two critical problems caused by delayed packets and missing ACKs, providing examples and code snippets for deeper understanding.
Connection ManagementMSLTCP
0 likes · 11 min read

TCP (Transmission Control Protocol) is a connection-oriented, reliable, byte-stream transport layer protocol that ensures ordered, error-free data delivery through mechanisms such as three-way handshake, four-way termination, flow control, and congestion control, making it essential for web browsing, email, and online gaming.
Connection ManagementNetworkingTCP
0 likes · 4 min read

This article examines Spring Boot 2.7.10’s embedded Tomcat configuration, detailing default connection queue sizes, thread pool parameters, key Tomcat settings such as AcceptCount and MaxConnections, internal thread components, and practical testing results that reveal how connection limits affect client‑server handshakes.
Connection ManagementEmbedded ServerPerformance Tuning
0 likes · 15 min read

This article provides a comprehensive overview of the transport layer, explaining how TCP and UDP differ in reliability, connection management, port usage, handshake processes, sequence numbers, acknowledgments, retransmission, window and flow control, as well as congestion handling.
Connection ManagementPort NumbersUDP
0 likes · 23 min read

This article introduces a Spring Boot library that uses a configuration annotation to enable WebSocket load balancing across microservice instances, explains its abstract design, connection management, message routing, and provides usage examples with code snippets while also mentioning related promotional content.
Connection ManagementJavaSpring Boot
0 likes · 14 min read

This guide explains what pt‑kill is, how it works within Percona Toolkit to kill MySQL connections based on execution time and various filters, demonstrates command‑line usage, victim‑selection modes, filtering options, source‑code logic, and common patterns such as logging and daemonizing.
Connection ManagementMySQLPT-kill
0 likes · 12 min read

This article provides an in‑depth tutorial on TCP, covering its header structure, three‑way handshake, reasons for three handshakes, four‑way termination, TIME_WAIT, SYN attacks, Linux kernel parameters, and practical socket programming examples, all illustrated with diagrams and code snippets.
Connection ManagementNetworkingTCP
0 likes · 43 min read

This article explains how the ZhiZhi RPC framework SCF handles connection lifecycle, including establishment timing, connection pooling versus multiplexing, keep‑alive mechanisms, automatic recovery, and graceful shutdown, providing practical guidance for designing robust RPC protocols.
Connection ManagementKeep-AliveNetty
0 likes · 11 min read

This article explains TCP fundamentals, covering its role in the OSI model, header structure, three‑way handshake, four‑way termination, typical connection problems, and how various TCP states transition, providing a solid foundation for both client and server developers.
Connection ManagementTCPhandshake
0 likes · 22 min read


ITPUBApr 21, 2021 · Fundamentals
This article explains TCP's connection‑oriented behavior, detailing the three‑way handshake for establishing a connection, the four‑step termination process, various state transitions, half‑open/half‑close scenarios, simultaneous open/close, initial sequence numbers, and the role of RST and TIME_WAIT.
Connection ManagementTCPfour-way termination
0 likes · 19 min read

This article explains HTTP’s key characteristics, compares short‑lived and persistent connections, and explores related concepts such as head‑of‑line blocking, concurrency, and domain sharding, providing readers with a comprehensive understanding of how HTTP manages connections and performance.
Connection ManagementHTTPLong Connection
0 likes · 17 min read

This article explains the core characteristics of the HTTP protocol—including its flexibility, reliability, application‑layer nature, request‑response model, and statelessness—and then details short and long connection management, related header fields, head‑of‑line blocking, and practical performance‑enhancing techniques such as concurrent connections and domain sharding.
Connection ManagementHTTPLong Connection
0 likes · 17 min read

This article explains HTTP's core characteristics—flexibility, reliability, application‑layer nature, request‑response model, and statelessness—then dives into short‑ and long‑connection management, head‑of‑line blocking, and practical optimization techniques such as concurrent connections and domain sharding.
Connection ManagementHTTPLong Connection
0 likes · 17 min read

This article explains MySQL’s internal workflow, covering the Server layer components, Storage Engine layer, connection handling, query cache behavior, lexical and syntax parsing, optimization decisions, and execution steps, including tips for long‑connection management and common pitfalls.
Connection ManagementDatabase InternalsMySQL
0 likes · 9 min read

This article explains how HTTP relies on TCP/IP, describes the browser's steps to open a TCP connection, details TCP segment and IP packet structures, outlines socket API calls, and discusses TCP handshake, slow start, and HTTP connection techniques such as parallel, persistent, and pipelined connections.
Connection ManagementHTTPNetworking
0 likes · 13 min read

This article explains how KeyDB, a Redis fork, redesigns the single‑threaded architecture into a multi‑threaded model with worker threads, per‑thread connection management, a custom fastlock mechanism, and an active‑replica mode that enables writable replicas and conflict‑resolution using timestamps.
Connection ManagementKeyDBLock
0 likes · 7 min read

This article provides a comprehensive examination of DBLE's backend connection module, detailing its design philosophy, data structures, initialization process, connection acquisition logic, and release mechanisms, while walking through key Java source code snippets to clarify how connections are managed within the middleware.
Connection ManagementDBLEJava
0 likes · 23 min read

This article explains the layered architecture, connection management, high‑availability design, security mechanisms, and performance‑boosting techniques of NetEase's instant‑messaging cloud platform, illustrating how the system handles massive concurrent connections and ensures stable, fast, and secure message delivery.
Connection Managementcloud servicesinstant messaging
0 likes · 18 min read

This article explains common MongoDB connection problems, authentication mechanisms, read‑preference tuning, index types and creation, query‑plan analysis, pagination techniques, and array handling, offering practical tips to improve performance and reliability for developers.
AuthenticationConnection ManagementIndex Optimization
0 likes · 9 min read

This article explains MySQL’s internal architecture, covering the client connector, connection management, SQL processing layers—including parsing, optimization, and caching—and the pluggable storage engine, as well as system management tools such as backup, recovery, security, and replication.
Connection ManagementMySQLSQL Optimization
0 likes · 3 min read
