MySQL and MariaDB handle more production workloads than any other open-source database, yet most developers never read a book about them. They learn enough SQL to get by, then spend years wondering why queries that worked fine in development bring production to its knees at scale. These books fix that.
This list covers both MySQL 8.x and MariaDB 11.x because the two have diverged enough that generic advice no longer applies to both. Every title below is current, in print, and written by engineers with real production experience. For hands-on installation, see our guides on installing MariaDB on Rocky Linux and MariaDB on Ubuntu/Debian.
Last reviewed: March 2026. All links and availability verified.
High Performance MySQL, 4th Edition
Silvia Botros and Jeremy Tinley rewrote this classic from scratch for MySQL 8.x, dropping all legacy coverage. The result is a book that assumes you already have MySQL running and jumps straight into what breaks under load: query optimization, indexing strategies, InnoDB internals, replication topologies, and reliability engineering at scale. The chapters on schema design and indexing alone will change how you think about database performance.
If your MySQL instance handles real traffic and you have ever stared at a slow query log wondering where to start, this is the book.
- Authors: Silvia Botros, Jeremy Tinley
- Published: 2022 (O’Reilly, 4th Edition)
- Best for: DBAs and backend engineers tuning production MySQL 8.x
- Amazon: Buy on Amazon
MySQL Cookbook, 4th Edition
At 971 pages, calling this a “cookbook” undersells it. Sveta Smirnova and Alkin Tezuysal cover virtually every MySQL task you will encounter in production: data types, JSON handling, window functions, stored procedures, security hardening, replication setup, and performance diagnostics. Each recipe is self-contained with a problem statement, a working solution, and an explanation of why it works. You will not read it cover to cover, but you will reach for it constantly when you need to do something specific and do it correctly.
- Authors: Sveta Smirnova, Alkin Tezuysal
- Published: September 2022 (O’Reilly, 4th Edition)
- Pages: 971
- Best for: Developers and DBAs who want a searchable reference for everyday MySQL tasks
- Amazon: Buy on Amazon
Efficient MySQL Performance
Daniel Nichter wrote this to bridge the gap between “I can write SQL” and “I can make MySQL fast.” The entire book is organized around one metric: query response time. You learn how to measure it properly, how to read EXPLAIN output without guessing, and how to fix the actual bottlenecks rather than throwing hardware at the problem. At roughly 350 pages, it is tighter and more focused than High Performance MySQL, which makes it a faster read when you need specific performance wins.
Nichter has over 15 years of MySQL experience, and the book reads like advice from a senior DBA sitting next to you. It pairs well with High Performance MySQL: Nichter goes deeper on query analysis while Botros and Tinley go wider on architecture.
- Author: Daniel Nichter
- Published: January 2022 (O’Reilly)
- Best for: Engineers moving from basic SQL to serious query optimization
- Amazon: Buy on Amazon
Learning MySQL, 2nd Edition
This is where you start if you have never administered a MySQL server. Vinicius Grippa and Sergey Kuzmichev walk through installation, basic SQL, schema design, user management, backups, replication, and monitoring. It covers MySQL 8.0 and includes chapters on cloud deployments that older introductory books skip. The writing assumes no prior database experience, but it builds toward real administration skills rather than just teaching SELECT statements.
Read this first, then move to Efficient MySQL Performance when you are ready to optimize. The other books on this list assume the foundation this one builds.
- Authors: Vinicius M. Grippa, Sergey Kuzmichev
- Published: October 2021 (O’Reilly, 2nd Edition)
- Best for: Beginners and junior DBAs learning MySQL administration from scratch
- Amazon: Buy on Amazon
MariaDB 11 Essentials
Most MySQL books barely mention MariaDB, which is a problem since the two have diverged significantly. Rocky Linux, Debian, and many other distributions ship MariaDB by default, and features like system versioning, temporal tables, Oracle compatibility mode, and the ColumnStore engine are MariaDB-only. Neil Smyth’s book (April 2025) targets MariaDB 11 specifically and covers these unique capabilities alongside standard administration tasks.
If your stack uses MariaDB (check with mariadb --version), a MySQL-only book will leave gaps. This fills them.
- Author: Neil Smyth
- Published: April 2025
- Best for: Admins and developers working specifically with MariaDB 11.x
- Amazon: Buy on Amazon
Which book should you pick?
| Goal | Book | Database |
|---|---|---|
| Learn MySQL from scratch | Learning MySQL, 2nd Ed | MySQL 8.0 |
| Quick solutions to specific problems | MySQL Cookbook, 4th Ed (971 pages) | MySQL 8.0 |
| Make slow queries fast | Efficient MySQL Performance | MySQL 8.0 |
| Run MySQL at scale in production | High Performance MySQL, 4th Ed | MySQL 8.0 |
| MariaDB-specific features and admin | MariaDB 11 Essentials | MariaDB 11 |
Most people should start with Learning MySQL, then move to Efficient MySQL Performance when they need speed. High Performance MySQL is for when you are managing production workloads with real traffic. Keep the Cookbook within reach throughout because you will look things up in it constantly. If you run MariaDB specifically, add MariaDB 11 Essentials to fill the gaps the MySQL books leave.
