Description Although My SQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it.
In this book, Sasha Pachev -- a former member of the My SQL Development Team -- provides a comprehensive tour of My SQL 5 that shows you how to figure out the inner workings of this powerful database.
You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.
The core of Understanding My SQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of My SQL work together.
You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure.
Other sections of the book cover: Core server classes, structures, and APIThe communication protocol between the client and the server Configuration variables, the controls of the server; includes a tutorial on how to add your own Thread-based request handling -- understanding threads and how they are used in My SQLAn overview of My SQL storage engines The storage engine interface for integrating third-party storage engines The table lock manager The parser and optimizer for improving My SQL's performance Integrating a transactional storage engine into My SQLThe internals of replication Understanding My SQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database.
With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals.
It's your guide to discovering and improving a great database.
About the author Sasha Pachev graduated from the Brigham Young University in 1998 with a degree in Computer Science, worked on the My SQ.
| Cover | Core server classes structures and |
|---|
Oreilly Media Understanding mysql internals: discovering and improving a great database, paperback/sasha pachev
