Charles Bell 
Expert MySQL 

Expert My SQL is the leading reference for learning, understanding, and extending the My SQL 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 My SQL that have taken engineers years to master.
Expert My SQL is a must have book for all systems integrators, engineers, and software developers working with the My SQL server code.

Expert My SQL is also a wealth of information on key aspects of My SQL 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 My SQL a must-have book for anyone doing high-end work involving My SQL.

• Shows how to customize My SQL 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

Table of Content

Part One – Getting Started with My SQL Development: My SQL and the Open Source Revolution

Part One: Getting Started with My SQL Development: The Anatomy of a Database System

Part One: Getting Started with My SQL Development: A Tour of the My SQL Source Code

Part One – Getting Started with My SQL Development: Test-Driven My SQL Development

Part Two – Extending My SQL: Debugging

Part Two – Extending My SQL: Embedded My SQL

Part Two – Extending My SQL: Adding Functions and Commands to My SQL

Part Two – Extending My SQL: Extending My SQL High Availability

Part Two – Extending My SQL: My SQL Pluggable Authentication

Part Two – Extending My SQL: Building Your Own Storage Engine

Part Three – Advanced Database Internals: Database Systems Internals

Part Three – Advanced Database Internals: Internal Query Representation

Part Three – Advanced Database Internals: Query Optimization

Part Three – Advanced Database Internals: Query Execution

About the author

Charles Bell conducts research in emerging technologies. He is a member of the Oracle My SQL Development team and is the team lead for the My SQL Utilities team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker focusing on microcontroller projects and refinement of three-dimensional printers. Dr. Bell maintains a blog on his research projects and many other interests. You can find his blog at http://drcharlesbell.blogspot.com/.