Dedicated to sharing Java backend technical experience and original tutorials, offering career transition advice and resume editing. Recognized as a rising star in CSDN's Java backend community and ranked Top 3 in the 2022 New Star Program for Java backend.
This guide explains MySQL stored procedures, functions, and triggers—from core concepts and syntax to practical examples, debugging techniques, real‑world use cases, and best‑practice recommendations for naming, error handling, transaction management, and performance monitoring.
This guide explains MySQL's transaction architecture—from the ACID properties and their implementation with undo/redo logs and MVCC, through isolation levels and common concurrency anomalies, to detailed lock types, deadlock detection, and practical performance‑tuning strategies.
This article compares InnoDB and MyISAM across transaction support, MVCC, storage structures, indexing, caching, and typical use cases, explains why InnoDB became the default engine in MySQL 5.5+, and provides concrete migration steps and performance‑tuning guidance.
This article explains MySQL’s query execution pipeline—from parsing to the storage engine—details the cost‑based optimizer’s model, shows how it evaluates index choices versus full‑table scans, demonstrates using optimizer hints and FORCE INDEX, and provides monitoring commands and best‑practice recommendations for effective query tuning.
This guide explains MySQL’s B+‑tree index architecture, compares clustered and secondary indexes, demonstrates covering and prefix indexes, outlines design principles such as high‑selectivity columns and the left‑most prefix rule, and shows how to use EXPLAIN and real‑world examples to diagnose and improve query performance.
This article reviews MySQL's GROUP BY fundamentals, highlights its limitations and execution order, then demonstrates how window functions—including ROW_NUMBER, RANK, DENSE_RANK, cumulative totals, moving averages, and TOP N techniques—can overcome those gaps for richer analytical queries.
This article explains MySQL join types, demonstrates inner, left, right, and self joins with sample tables, shows how to write subqueries (correlated and non‑correlated) and UNION/UNION ALL, compares their performance, and provides practical indexing and query‑writing tips.
The article explains MySQL’s full range of data types—from integers and floating‑point numbers to strings, binary and temporal types—along with constraint options such as NOT NULL, UNIQUE, CHECK, primary keys and AUTO_INCREMENT, and offers practical guidelines on character sets, collations, and best‑practice selection to ensure data integrity, consistency, and optimal storage and query performance.
This guide explains why solid MySQL design matters, walks through the three normal forms with concrete SQL examples, covers primary keys, foreign keys, indexes, various table relationships, an online‑store case study, design recommendations, and performance‑tuning techniques.
This guide walks through installing MySQL on Windows, Linux and macOS, configuring security settings, creating the first database and tables, and demonstrates basic queries, updates and deletions with concrete command‑line examples.
