Understanding MySQL Internals: Discovering and Improving a Great Database by Sasha Pachev

Preface     xi
MySQL History and Architecture     1
MySQL History     1
MySQL Architecture     4
Nuts and Bolts of Working with the MySQL Source Code     19
Unix Shell     19
BitKeeper     19
Preparing the System to Build MySQL from BitKeeper Tree     22
Building MySQL from BitKeeper Tree     24
Building from Source Distribution     25
Installing MySQL into a System Directory     26
Source Code Directory Layout     27
Preparing the System to Run MySQL in a Debugger     28
Debugger-Guided Source Tour     29
Basics of Working with gdb     30
Finding Things in the Source     33
Interesting Breakpoints and Variables     34
Making a Source Modification     36
Coding Guidelines     37
Keeping Your BitKeeper Repository Up to Date     39
Submitting a Patch     40
Core Classes, Structures, Variables, and APIs     41
THD     41
Net     46
Table     48
Field     51
Utility API Calls     54
Preprocessor Macros     57
GlobalVariables     59
Client/Server Communication     62
Protocol Overview     62
Packet Format     62
Relationship Between MySQL Protocol and OS Layer     63
Authenticating Handshake     64
Command Packet     69
Server Responses     74
Configuration Variables     80
Configuration Variables Tutorial     80
Interesting Aspects of Specific Configuration Variables     88
Thread-Based Request Handling     107
Threads Versus Processes     107
Implementation of Request Handling     109
Thread Programming Issues     113
The Storage Engine Interface     119
The handler Class     120
Adding a Custom Storage Engine to MySQL     136
Concurrent Access and Locking     161
Table Lock Manager     162
Parser and Optimizer     167
Parser     167
Optimizer     170
Storage Engines     194
Shared Aspects of Architecture     195
InnoDB     202
Memory (Heap)     204
MyISAM Merge     205
NDB     205
Archive      206
Federated     207
Transactions     208
Overview of Transactional Storage Engine Implementation     208
Implementing the handler Subclass     209
Defining the handlerton     212
Working with the Query Cache     213
Working with the Replication Binary Log     214
Avoiding Deadlocks     214
Replication     216
Overview     216
Statement-Based Versus Row-Based Replication     217
Two-Threaded Slave     218
Multi-Master     219
SQL Commands to Help Understand Replication     220
Binary Log Format     223
Creating a Custom Replication Utility     227
Index     229