Joining is easy.
Subscribe to our announce list. We'll send you a confirmation email in reply. Come back, enter the confirmation password, and you're done!
Reviewed by Major Keary
This is a valuable companion text to High Performance MySQL, also published by O'Reilly.
The author of MySQL Internals, Sasha Pachev, was a member of the MySQL development team and the original developer of replication in MySQL. The book was written when MySQL 5.0 was the stable version and 5.1 was in beta, so—even though published in 2007—it is still relevant. In the preface the author says, "Fortunately, most of the code tends to remain intact, so the book has a shot at not becoming obsolete before it is published".
Mentioned in the Who This Book is For section are "developers trying to extend MySQL in some way", DBA or database application programmers interested in how MySQL queries are run, computer science students, anyone curious about what is inside MySQL, and those "who want to look smart by having a book on MySQL internals" on their bookshelf.
MySQL Internals contains information that won't be found in many other MySQL books. For example, instructions on how one finds things in the source, and coding guidelines for those who want to modify the source. The text is supported by extensive code examples.
There is a remarkably extensive collection of detailed tables that should be a valuable look-up resource in their own right. A random selection indicates their scope:
Chapter headings indicate the book's scope:
The author has packed a surprising amount of material into a small space (just over 200 pages) without sacrificing readability. The book is not the kind of thing one might read on the bus, or browse; it is a tool to be used for "discovering and improving a great database" (the book's sub-title). It deserves a place in any library with holdings on database technology, and should be considered for computer science reading lists.
Sasha Pachev: Understanding MySQL Internals
Published by O'Reilly, 234 pp., RRP AU$ 105.00
O'Reilly books are distributed in Australia by Woodslane www.woodslane.com.au