Understanding MySQL Internals

Description

Understanding MySQL Internals; Who This Book Is For; Conventions Used in This Book; Using Code Examples; Comments and Questions; Safari® Enabled; Acknowledgments; 1. MySQL History and Architecturel; 1.2. MySQL Architecture; 1.2.2. Interaction of the Core Modules; 1.2.3. Detailed Look at the Core Modules; 1.2.3.2. Connection Manager; 1.2.3.3. Thread Manager; 1.2.3.4. Connection Thread; 1.2.3.5. User Authentication Module; 1.2.3.6. Access Control Module; 1.2.3.7. Parser; 1.2.3.8. Command Dispatcher; 1.2.3.9. Query Cache Module; 1.2.3.10. Optimizer; 1.2.3.11. Table Manager.;Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. This book provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner-workings of this powerful database. You'll learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.