ThinkerQAQ

Databases

42 notes

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

  1. MySQL System Databaseshistorical

    Purpose of mysql, information_schema, performance_schema, and sys metadata/diagnostic schemas.

    1.MySQL
  2. MySQL SQL Parsinghistorical

    Lexing, parsing, semantic resolution, and the boundary between parsing and optimization.

    1.MySQL
  3. MySQL Query Executorhistorical

    Executing an optimizer-selected plan through iterators/operators and storage-engine row access.

    1.MySQL
  4. Diagnosing MySQL Production Problemshistorical

    A symptom-first workflow for latency, CPU, I/O, locks, connections, replication, and query-plan regressions.

    1.MySQL
  5. MySQL Load Testinghistorical

    Benchmarking database throughput, latency, concurrency, and saturation with realistic datasets and transactions.

    1.MySQL
  6. Managed Cloud MySQLhistorical

    Operational trade-offs of managed MySQL: HA, backups, monitoring, scaling, limits, and provider-specific behavior.

    1.MySQL
  7. MySQL InnoDB Buffer Poolhistorical

    Caching InnoDB data and index pages, dirty-page management, eviction, and working-set behavior.

    1.MySQL
  8. MySQL Performance Tuninghistorical

    Evidence-driven tuning across schema, SQL, indexes, memory, concurrency, I/O, and architecture.

    1.MySQL
  9. Canal and MySQL Binlog CDChistorical

    Capturing MySQL changes from the binary log for downstream synchronization and event pipelines.

    1.MySQL / canal
  10. 1.29 InnoDB Buffer Poolhistorical

    How InnoDB caches data and index pages, tracks free/dirty/cached pages, evicts cold pages, and decouples logical writes from data-file flushing.

    1.MySQL / InnoDB