Expert MySQL, 2nd Edition

03/23/2013 · No Responses

Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code.

Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You’ll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL.

Shows how to customize MySQL and its storage and authentication engines
Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting
Covers high-end features such as high-availability and replication

What you’ll learn

Learn the inner workings of MySQL
Diagnose and improve poorly performing queries
Implement high-availablity solutions and replication
Modify and debug the server code
Build your own pluggable storage engines and authentication modules
Implement new SQL functions and syntax
Build your own query optimizer

Who this book is for
Expert MySQL is written for systems integrators, software developers, and database administrators who are using MySQL and desire a deeper knowledge of MySQL internals in support of high-end work such as performance troubleshooting, customization of the engine and its plugins, query optimizaion, building of high-availability environments, replication of data, and so forth.

Table of Contents
Part 1: Getting Started with MySQL Development
Chapter 1. MySQL and The Open Source Revolution
Chapter 2. The Anatomy of a Database System
Chapter 3. A Tour of the MySQL Source Code
Chapter 4. Test-Driven MySQL Development

Part 2: Extending MySQL
Chapter 5. Debugging
Chapter 6. Embedded MySQL
Chapter 7. Adding Functions and Commands to MySQL
Chapter 8. Extending MySQL High Availability
Chapter 9. Developing MySQL Plugins
Chapter 10. Building Your Own Storage Engine

Part 3: Advanced Database Internals
Chapter 11. Database System Internals
Chapter 12. Internal Query Representation
Chapter 13. Query Optimization
Chapter 14. Query Execution