Understanding MySQL Internals: Discovering and Improving a Great Database


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.

Like the bestselling "Understanding the Linux Kernel," this new guide goes to the heart of the MySQL database, another leading open source software project.

Author(s): Sasha Pachev  

ISBN 10: 0596009577
ISBN 13: 9780596009571
Pages: 258
Find this book on Amazon

 

This books is in the following lists (3)



Related YouTube Videos (add a video)

Add the YouTube URL below and submit:

To add a YouTube video, please copy the video's URL on YouTube and submit by clicking "Add".
The URL should look something like this: https://www.youtube.com/watch?v=CXQdBuuanI8
How to copy the videos URL from YouTube

No video yet, want to add one?

Related Articles (add an article)

Add an article URL below and submit:

To add an article, please paste the article's URL and submit by clicking "Add".
Below is an example of a valid URL:
How to copy and paste a webpage URL

No article found, do you know any related to this book?

Report an error with this book