This repo contains most examples used in the book Efficient MySQL Performance (O'Reilly 2021).
The examples for each chapter (which have examples) are in corresponding directories.
For example, the many examples of EXPLAIN using table elem in chapter 2 are located in ch02/.
Most file names correspond to the example numbers in the book.
Not every example or code block in the book is reproduced in this repo. Included are the examples that you can reproduce or practice; excluded are the one-off examples used to support the text rather than be reproduced.
All the examples, like the book, presume that you are an engineer who is already familiar with basic MySQL commands and usage. For most examples, you should use a test database:
CREATE DATABASE test;Then mysql test < ch02/elem.sql, for example.
To reload examples, you will need to drop the tables.
NOTE: Both chapter 2 and chapter 8 use table elem, but the table is slightly different in each. |
|---|
Output and results (EXPLAIN plans, for example) can vary between the book and your particular distribution and version of MySQL. Minor differences, especially when not relevant to the corresponding material discussed in the book, can be ignored. If you see a major difference, try using MySQL Community Server 8.0.22 or newer to obtain similar results. Percona Server and MariaDB Server have different optimizations, especially the latter.