In this book, Sasha Pachev - a former member of the MySQL Development Team - provides a comprehensive tour of MySQL 5 that shows you how to know the inner workings of this powerful database. You will go straight to the heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and more. The core of Understanding MySQL starts with the Internal Architecture Overview that provides a brief introduction about how the different components of MySQL work together. Another part of this book include: Core server classes, structures, and API communication protocol between the client and the server configuration variables, the control server, including tutorials on how to add your own handling of requests based Threads - understanding threads and how they are used in the Review of MySQL storage engines MySQL storage engine interface for integrating storage third-party engines Manager Table Locks parser and optimizer to improve performance Integrating transactional MySQL storage engine to MySQL The internal replication Understanding MySQL Internal unprecedented opportunity for developers, DBAs, database application programmers, IT departments, software vendors, and computer science for students to learn about the inner workings of this enterprise-proven database.