3/06/2011

Understanding MySQL Internals - PDF

Understanding MySQL InternalsBook 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  engines and configuration options, and much more.

The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction  of how the different components of MySQL 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 API
  • The 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 MySQL
  • An overview of MySQL storage engines
  • The storage engine interface for integrating third-party storage engines
  • The table lock manager
  • The parser and optimizer for improving MySQL's performance
  • Integrating a transactional storage engine into MySQL
  • The internals of replication

Understanding MySQL 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.

Book Details

  • Paperback: 256 pages
  • Publisher: O'Reilly Media (April, 2007)
  • Language: English
  • ISBN-10: 0596009577
  • ISBN-13: 978-0596009571
  • File Size: 1.7 MiB
  • Hits: 2,222 times