ngosangns Knowledge Base

Core Concepts

Pages

  • SQL Optimization
    Practical SQL query tuning guide covering execution order, indexing, keyset pagination, prepared statements, CTEs, and a MariaDB slow-pagination case study.
  • Storage Engines
    Comparison of MySQL storage engines (MyISAM, InnoDB, MEMORY) and a deep dive into InnoDB pages, rows, row-size limits, and off-page storage formats.