ThinkerQAQ

Databases

42 notes

Some notes are currently available only in Chinese. English translations are shown when available.

  1. 1. MySQLhistorical

    A map of the MySQL notes: architecture, storage engines, indexing, transactions, replication, diagnostics, and performance work.

    1.MySQL
  2. 1.1 MySQL EXPLAINhistorical

    A practical guide to reading MySQL execution plans: access type, chosen indexes, row estimates, join order, covering access, filesort, temporary work, and EXPLAIN ANALYZE.

    1.MySQL
  3. 1.2 MySQL Primary-Replica Replicationhistorical

    MySQL binlog-based replication, relay logs, replication lag, parallel apply, semi-sync, GTID/position waiting, and stale-read trade-offs.

    1.MySQL
  4. 1.3 MySQL SQL Tuninghistorical

    A measurement-first SQL tuning workflow covering slow-query identification, execution plans, indexing, query rewrites, pagination, and joins.

    1.MySQL
  5. Installing and Configuring MySQLhistorical

    A version-aware checklist for installation, initialization, security, durability, memory, and observability.

    1.MySQL
  6. 1.5 MySQL Query Optimizerhistorical

    Logical rewrites, cost-based physical planning, access paths, join ordering, statistics, optimizer trace, and execution-plan selection.

    1.MySQL
  7. MySQL Storage Engineshistorical

    The storage-engine abstraction and why InnoDB is the normal transactional choice.

    1.MySQL
  8. 1.7 MySQL Lockshistorical

    MySQL and InnoDB locking from global/metadata locks to record, gap, and next-key locks, plus how access paths determine lock scope.

    1.MySQL
  9. 1.8 MySQL Indexeshistorical

    InnoDB primary and secondary B+ tree indexes, composite indexes, covering indexes, leftmost prefixes, selectivity, range scans, and index-design trade-offs.

    1.MySQL
  10. MySQL Index Implementationhistorical

    B+tree organization, clustered and secondary indexes, page locality, and lookup complexity.

    1.MySQL