MySQL, MariaDB, and Percona Reference Library

This document contains a curated list of official documentation, engineering blogs, and expert deep-dives for MySQL, MariaDB, and Percona Server. It serves as a solid baseline for all database performance tuning, security hardening, and SQL modeling practices implemented in MySQLTuner-perl.

---

🏛️ Official Documentations by Topic

1. Memory Management & Connection Tuning

• MySQL: Memory Usage Tuning - Understanding global vs. per-thread buffers.
• MySQL: How MySQL Uses Memory - Detailed breakdown of join buffers, sort buffers, and thread caches.
• MySQL: Thread Cache Tuning - Optimizing connection management and thread reuse.
• MariaDB: Connection & Thread Cache KB - Thread pooling and system variables.

2. Table Cache & File Descriptors

• MySQL: Table Cache Configuration - Tuning table_open_cache and table_definition_cache.
• MySQL: How MySQL Opens and Closes Tables - Diagnostic details for file descriptor exhaustion.
• MariaDB: Table Design and Performance KB - Optimizing file usage.

3. Temporary Tables & Performance Schema

• MySQL: Internal Temporary Table Use - Memory vs. disk tmp tables (tmp_table_size, max_heap_table_size).
• MySQL: Performance Schema Startup Configuration - Enabling wait events and query statistics.
• MariaDB: Memory Storage Engine KB - Dynamic memory allocations.

4. Storage Engine Architecture & Metrics

• MySQL: InnoDB Performance & Tuning - Redo log capacity, flushing algorithms, buffer pools.
• MySQL: MyISAM Key Buffer Tuning - In-memory indexing configurations for MyISAM.
• MariaDB: Aria Storage Engine KB - Checking page caches and crash recovery.
• Percona: MyRocks Engine Documentation - Log-structured merge-tree (LSM) storage tuning.

5. SQL Modeling & Schema Design

• MySQL: Primary Key Optimization - Surrogate keys, UUID indexing, and index traversal efficiency.
• MySQL: JSON Datatype Indexing - Secondary indexing via virtual generated columns.
• MariaDB: Invisible Indexes KB - Hiding indexes to test query planner changes.
• MySQLTuner-perl Specification: Naming Conventions & Style Compatibility - Summary of naming styles.

6. Replication, High Availability & Clustering

• MySQL: Group Replication & InnoDB Cluster - Multi-primary setups and flow control.
• MySQL: GTID Replication Guide - Ensuring transactional consistency.
• MariaDB: Galera Cluster Flow Control KB - Managing queue sizes and replica threads.
• Percona: Percona XtraDB Cluster (PXC) Guide - High availability synchronous replication.

7. Security, Authentication & Access Control

• MySQL: Authentication Plugins Reference - Cryptographic hashing algorithms and client validation.
• MySQL: caching_sha2_password Transition Guide - Migration from historical SHA-1 plugins.
• MariaDB: User Security & Authentication KB - Socket, Ed25519, and PARSEC plugin specifications.
• Percona: MySQL Security Hardening Checklist - Auditing privileges, anonymous accounts, and SSL/TLS cipher suites.

---

🏎️ Engineering & Product Blogs

• MySQL Server Engineering Blog - Direct insights from the Oracle MySQL development team.
• MariaDB Foundation Blog - Technical developments and ecosystem announcements.
• Percona Performance Blog - Deep dives, benchmark reports, and operational troubleshooting guides.

---

🔬 Deep Dive Expert Articles

InnoDB Internals & Performance

• InnoDB Flushing Mechanisms Explained - Adaptive flushing under write pressure.
• Dynamic Redo Log Capacity (MySQL 8.0.30+) - Sizing redo log capacity without server restarts.
• Primary Key Optimization Guidelines - Real-world comparison of surrogate vs. composite PKs.

Advanced Clusters & Galera

• Galera Advanced Performance Tuning - Troubleshooting brute-force aborts and certification delays.
• MySQL Shell AdminAPI Mastery - Managing sandbox and production InnoDB Clusters.
• MySQL Router Bootstrapping & Routing - High availability client redirection.

---

👨‍💻 Community Databases & Experts

• lefred.be - Frédéric Descamps (MySQL Evangelist, InnoDB and backup performance).
• jfg-mysql.blogspot.com - Jean-François Gagné (Deep dives into replication lag and Performance Schema wait events).
• dasini.net - Olivier Dasini (MySQL certification roadmap and enterprise setups).