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