Have you ever wondered: why does MySQL use B+Tree, Rock […]
Category： Database
Backend Performance Optimization: A Practical Guide to Database Connection Pool Tuning
The connection pool is one of the most overlooked perfo […]
Alibaba's Real-Time Data Warehouse Practice with Doris: 50 Billion Records Daily
I recently came across the real-time data warehouse pra […]
MySQL Sharding Study Notes: From Single Database to Sharding
I've been studying database sharding solutions recently […]
MySQL Index Interview Essentials: Why Is the Leftmost Prefix Match the Most Asked Question?
MySQL index interview questions always revolve around t […]
SQL Optimization Interview Guide: Practical Insights from EXPLAIN to Index Design
SQL optimization is a frequent topic in backend intervi […]
Doris vs ClickHouse: A Comparative Study of OLAP Databases
I've been studying OLAP databases recently and put toge […]
MySQL Transaction Isolation Levels Explained for Interviews: How to Distinguish Dirty Reads, Phantom Reads, and Non-Repeatable Reads?
Transaction isolation levels are almost a guaranteed qu […]
PostgreSQL or MySQL? Rethinking Database Selection in 2025
The debate between MySQL and PostgreSQL has never stopp […]