Nov 13, 2022 · Databases

Inside MySQL: How the Server Handles Connections, Parsing, and Storage Engines

This article explains MySQL's client‑server architecture and walks through the three main stages—connection handling, query parsing and optimization, and storage engine selection—detailing protocols, authentication, cache behavior, optimizer mechanics, and engine characteristics with practical commands and examples.

Connection HandlingDatabase InternalsStorage Engine

0 likes · 21 min read

Inside MySQL: How the Server Handles Connections, Parsing, and Storage Engines

Tencent Database Technology

Oct 20, 2021 · Databases

Percona Thread Pool Implementation and TXSQL Optimizations: Architecture, Dynamic Switching, Load Balancing, and Disconnection Handling

This article explains the background, principles, architecture, and detailed implementation of Percona's thread pool, and describes TXSQL's dynamic thread‑pool activation, load‑balancing strategies, disconnection optimizations, related configuration parameters, status variables, and a concise summary.

Connection HandlingPerconaTXSQL

0 likes · 27 min read

Percona Thread Pool Implementation and TXSQL Optimizations: Architecture, Dynamic Switching, Load Balancing, and Disconnection Handling