Chapter 1.
MySQL and MariaDB Overview

1.1 Status
1.2 Differences from commercial RDBMS
1.3 The Importance of MySQL and MariaDB Tuning
1.4 In conclusion

Chapter 2. Intuitively Understanding SQL Tuning Terminology

2.1 Physics Engine and Object Terminology
2.2 Logical SQL Concept Terminology
2.3 Conceptual Tuning Terminology
2.4 In conclusion

Chapter 3. Digging into SQL Tuning's Execution Plans

3.1 Setting up the practice environment
3.2 Executing the execution plan
3.3 Profiling
3.4 In conclusion

Chapter 4.
Escape the Beginner's Path with Malicious SQL Tuning

4.1 Preparing for SQL Tuning
4.2 Creating Good Queries by Simply Modifying SQL Statements
4.3 Creating Good Queries by Changing Table Join Settings
4.4 In conclusion

Chapter 5.
Become an expert with malicious SQL tuning

5.1 Create good queries by rewriting SQL statements
5.2 Creating Good Queries with Index Tuning
5.3 Creating Good Queries with Appropriate Table and Column Properties
5.4 In conclusion

Structure of this book

Chapter 1: Overview of MySQL and MariaDB
We'll explore the background and market share of MySQL and MariaDB, the differences between them and commercial DBMSs, and the importance of tuning MySQL and MariaDB, both open-source DBMSs.

Chapter 2: Intuitively Understanding SQL Tuning Terminology

Before performing SQL tuning, learn about the structure of the physics engine, terms related to DB objects, terms related to writing logical queries, and conceptually common tuning terms.

Chapter 3: Understanding SQL Tuning Execution Plans

Let's set up a hands-on environment required to perform SQL tuning.
We'll look at how execution plans are executed to determine the direction of tuning, what the output means, and understand profiling, which is physical time-unit information.

Chapter 4: Escape the Beginner's Path with Malicious SQL Tuning

This hands-on exercise involves tuning a given SQL statement by making simple text changes. We'll explore examples of query tuning achieved by changing specific syntax or table join methods in a SQL statement.

Chapter 5: Becoming an Expert with Malicious SQL Tuning

This hands-on exercise involves tuning a given SQL statement by rewriting the query or modifying objects using the DDL data definition language. We'll explore examples of query tuning that involve rewriting the entire SQL statement, adjusting indexes, and modifying table and column properties.