ThinkerQAQ

Databases

42 notes

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

  1. MySQL Files and Durable Storagehistorical

    How database files, redo/binlog, tablespaces, filesystem caches, and fsync interact.

    1.MySQL
  2. InnoDB Pageshistorical

    Page-based B+tree storage, records, free space, page splits, and locality.

    1.MySQL
  3. MySQL Data Typeshistorical

    Choosing numeric, temporal, string, binary, JSON, and exact-value types from semantics and access patterns.

    1.MySQL
  4. 1.13 MySQL Binary Loghistorical

    MySQL server-level change logging for replication and point-in-time recovery, including statement/row formats, durability policy, and its distinction from InnoDB redo.

    1.MySQL
  5. 1.14 MySQL Architecturehistorical

    The path from a client connection through parsing, optimization, execution, and the storage-engine interface.

    1.MySQL
  6. MySQL Connections and Connectorshistorical

    Client authentication, sessions, connection pools, limits, timeouts, and protocol lifecycle.

    1.MySQL
  7. MySQL Optimizer Statisticshistorical

    Cardinality and distribution statistics used for cost-based query-plan selection.

    1.MySQL
  8. MySQL Table Access Methodshistorical

    Full scans, index scans, range access, point lookup, ref access, and plan-dependent row retrieval.

    1.MySQL
  9. MySQL Slow Query Loghistorical

    Capturing expensive statements for plan analysis and workload prioritization.

    1.MySQL
  10. MySQL SHOW PROFILEhistorical

    Historical per-query profiling and modern alternatives for diagnosing query execution.

    1.MySQL