Understanding MySQL Internals
August 5th, 2010 by CGI & PHP.com
Product Description
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. 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 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 engin… More >>
Popularity: 5% [?]
Beginning PHP 6, Apache, MySQL 6 Web Development
Java: An Eventful Approach
Web Application Design and Implementation: Apache 2, PHP5, MySQL, JavaScript, and Linux/UNIX
Java
MySQL Administrator's Guide
MySQL 5.0 Certification Study Guide
August 5th, 2010 at 7:22 am
Sasha Pachev's UNDERSTANDING MYSQL INTERNALS: DISCOVERING AND IMPROVING A GREAT DATABASE provides clear insights into one of the most popular open source codes on the market. It comes from a former member of the MySQL development team, so offers the author's own insights into the program's creation and use, covering everything from communication protocols between client and server to the parser and optimizer that execute SQL commands, advantages and disadvantages of using threads, and more technical insights.
Rating: 5 / 5
August 5th, 2010 at 8:26 am
The book was for a son. It arrived very quickly and in perfect condition.
Rating: 5 / 5
August 5th, 2010 at 10:22 am
Sasha knows the mysql code well, and he has done a fantastic job of presenting it. This is an important book for anyone who would like an enhanced understanding of mysql, including DBAs who might need a detailed understanding of locking or replication to. And it's a must-have for anyone working on a storage engine.
Rating: 4 / 5
August 5th, 2010 at 10:39 am
An excellent overview of the MySQL codebase, philosophy, and the design decisions that have made MySQL what it is today. Even though I have never touched the MySQL source before (it can be a daunting beast for the uninitiated), Sasha's explanations made me comfortable with the 'internals' and finally lifted the 'magic veil' off the engine. 'MySQL internals' has a perfect balance of high-level explanations, and low-level code samples to help you understand the inner workings of the database.
After reading this book you should be comfortable enough to tackle the source, and you'll also have deep understanding of the storage engines and how to configure them, how the query parser works, how the optimizer decides on the execution plan, and much more. This is a must read for any DBA, or a programmer who wants to see a great example of a high-performance, reliable UNIX server.
Rating: 5 / 5
August 5th, 2010 at 12:43 pm
I have been working on a project to make some changes to MySQL server
operation. Learned a lot through code review & trial and error! Recently
purchased this book and it is excellent! Wish we had it months ago.
The author knows what he's talking about. Provides a great overview of the
architecture, file and subsystem layout. Also provides great information on using the 'built in' debug capability of the server — very useful!
I was expecting to be disappointed, I was not. The content was right
on the mark for those folks interested on working on server internals.
Rating: 5 / 5