MySQL Internals
This is the MySQL Internals guide. Formerly, it used to be available here: http://dev.mysql.com/doc/internals/en
The guide consists of:
- A Guided Tour of the MySQL Source Code
- Coding Guidelines
- Reusable data structures, classes and templates
- Support for Plug-Ins
- Locking
- Transaction management
- The Optimizer
- How to allocate memory
- Important Algorithms and Structures
- File Formats
- How MySQL Performs Different Selects
- How MySQL Transforms Subqueries
- MySQL Client/Server Protocol
- Stored Programs
- Prepared Statements and Stored Routines Re-execution
- Result Postprocessing Procedures
- Replication
- The Binary Log
- MySQL Backup
- MyISAM Storage Engine
- InnoDB Storage Engine
- Writing a Custom Storage Engine
- Test Synchronization
- How to Create Good Tests
- Porting to Other Systems
- Error Messages
- MySQL Source Code Distribution
- InnoDB Source Code Distribution