书名: Understanding MySql Internals

作者: Sasha Pachev

出版社： O'Reilly

出版日期: 2007年5月

文档格式: PDF

文档大小: 1.66M

内容简介: 书如其名，这本书并不侧重SQL语句语法或者怎样写一条语句来执行查询，而是努力让读者理解MySql内在工作机制，例如MySql如何完成存储，如何完成查询，跟深入的探讨了这一系列动作背后的真相。作者有一段介绍很恰入其分:

Thus, in order to appreciate the inner workings of MySQL, you need to get close to the places where that devil is being subdued. Somewhere in the dark depths of the optimizer or inside the B-tree, there is music to be heard as you study the code. It will take some work to hear that music, but once you do, you can feel its beauty.

看一下目录就可以大概了解起内容:

Chapter 1, MySQL History and Architecture

 Introduces the major modules in the source code and their purpose.

Chapter 2, Nuts and Bolts of Working with the MySQL Source Code

Tells you how to download the source code and build a server from scratch.

Chapter 3, Core Classes, Structures, Variables, and APIs

Lists the basic data structures, functions, and macros you need for later reference.

Chapter 4, Client/Server Communication

Lays out the formats of the data sent between client and server, and the main functions that perform the communication.

Chapter 5, Configuration Variables

Discusses how MySQL handles configuration in general, as well as the effects of many particular configuration variables, and shows you a framework for adding a new configuration variable.

Chapter 6, Thread-Based Request Handling

Explains MySQL’s reasons for using threads and the main variables, such as locks, related to threads.

Chapter 7, The Storage Engine Interface

Describes the relation of individual storage engines (formerly known as table types) to the MySQL core, and shows you a framework for adding a new storage engine.

Chapter 8, Concurrent Access and Locking

Explains the different types of locks available in MySQL, and how each storage engine uses locks.

Chapter 9, Parser and Optimizer

Explains the major activities that go into optimizing queries.

Chapter 10, Storage Engines

Briefly describes the most important MySQL storage engines and some of the

tree structures and other data structures they employ.

Chapter 11, Transactions

Lists the main issues required to support transactions, and uses InnoDB to illustrate the typical architecture used to provide that support.

Chapter 12, Replication

Gives on overview of replication with an emphasis on issues of implementation.

下载链接: