LouZai
Author

LouZai

10 years of front‑line experience at leading firms (Xiaomi, Baidu, Meituan) in development, architecture, and management; discusses technology and life.

35
Articles
0
Likes
3
Views
0
Comments
Recent Articles

Latest from LouZai

35 recent articles
LouZai
LouZai
Oct 24, 2023 · Databases

Understanding MySQL SQL Execution Process with a Single Diagram

This article provides a step‑by‑step walkthrough of MySQL’s execution pipeline—from the client connection and parsing, through optimization, execution, undo/redo logging, change buffer handling, and binlog recording—illustrated with diagrams and detailed explanations of each component.

InnoDBMySQLSQL execution
0 likes · 11 min read
Understanding MySQL SQL Execution Process with a Single Diagram
LouZai
LouZai
Oct 19, 2023 · Backend Development

How to Diagnose and Fix 502 Bad Gateway Errors

This article explains what a 502 Bad Gateway error means, why it is usually generated by a reverse‑proxy like nginx, and provides step‑by‑step methods to identify common causes such as backend timeouts, process crashes, and misconfigured upstream servers.

502 Bad GatewayHTTP status codesNginx
0 likes · 15 min read
How to Diagnose and Fix 502 Bad Gateway Errors
LouZai
LouZai
Oct 17, 2023 · Interview Experience

How I Earned a Level‑17 Promotion: 4 Practical Tips and Mindset Shifts

The author shares a step‑by‑step account of preparing a promotion presentation at Xiaomi, covering material structuring, rehearsal techniques, Q&A planning, and the “reset” mindset that helped turn a 4‑week effort into a successful Level‑17 promotion.

Xiaomicareer advicemindset
0 likes · 8 min read
How I Earned a Level‑17 Promotion: 4 Practical Tips and Mindset Shifts
LouZai
LouZai
Oct 11, 2023 · Backend Development

Designing High-Concurrency Systems: Key Strategies and Best Practices

This article walks through essential techniques for building high‑concurrency systems, covering page static‑generation, CDN acceleration, caching layers, asynchronous processing with thread pools and MQ, sharding, connection pooling, read/write splitting, indexing, batch queries, clustering, load‑balancing, rate limiting, service degradation, failover, multi‑active deployment, stress testing, and monitoring.

CachingMonitoringasynchronous processing
0 likes · 25 min read
Designing High-Concurrency Systems: Key Strategies and Best Practices
LouZai
LouZai
Oct 7, 2023 · Backend Development

How Spring Resolves Circular Dependencies – In‑Depth Interview Guide

This article walks through Spring's three‑level cache mechanism and source‑code flow that break circular dependencies, illustrating each step with a concrete demo, explaining the role of AOP, and showing why each cache level is necessary.

AOPBeanFactoryCircular Dependency
0 likes · 14 min read
How Spring Resolves Circular Dependencies – In‑Depth Interview Guide