Books & Videos

Table of Contents

  1. Chapter 1 MySQL History and Architecturel

    1. MySQL History

    2. MySQL Architecture

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

    1. Unix Shell

    2. BitKeeper

    3. Preparing the System to Build MySQL from BitKeeper Tree

    4. Building MySQL from BitKeeper Tree

    5. Building from Source Distribution

    6. Installing MySQL into a System Directory

    7. Source Code Directory Layout

    8. Preparing the System to Run MySQL in a Debugger

    9. Debugger-Guided Source Tour

    10. Basics of Working with gdb

    11. Finding Things in the Source

    12. Interesting Breakpoints and Variables

    13. Making a Source Modification

    14. Coding Guidelines

    15. Keeping Your BitKeeper Repository Up to Date

    16. Submitting a Patch

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

    1. THD

    2. NET

    3. TABLE

    4. Field

    5. Utility API Calls

    6. Preprocessor Macros

    7. Global Variables

  4. Chapter 4 Client/Server Communication

    1. Protocol Overview

    2. Packet Format

    3. Relationship Between MySQL Protocol and OS Layer

    4. Authenticating Handshake

    5. Command Packet

    6. Server Responses

  5. Chapter 5 Configuration Variables

    1. Configuration Variables Tutorial

    2. Interesting Aspects of Specific Configuration Variables

  6. Chapter 6 Thread-Based Request Handling

    1. Threads Versus Processes

    2. Implementation of Request Handling

    3. Thread Programming Issues

  7. Chapter 7 The Storage Engine Interface

    1. The handler Class

    2. Adding a Custom Storage Engine to MySQL

  8. Chapter 8 Concurrent Access and Locking

    1. Table Lock Manager

  9. Chapter 9 Parser and Optimizer

    1. Parser

    2. Optimizer

  10. Chapter 10 Storage Engines

    1. Shared Aspects of Architecture

    2. InnoDB

    3. Memory (Heap)

    4. MyISAM Merge

    5. NDB

    6. Archive

    7. Federated

  11. Chapter 11 Transactions

    1. Overview of Transactional Storage Engine Implementation

    2. Implementing the handler Subclass

    3. Defining the handlerton

    4. Working with the Query Cache

    5. Working with the Replication Binary Log

    6. Avoiding Deadlocks

  12. Chapter 12 Replication

    1. Overview

    2. Statement-Based Versus Row-Based Replication

    3. Two-Threaded Slave

    4. Multi-Master

    5. SQL Commands to Help Understand Replication

    6. Binary Log Format

    7. Creating a Custom Replication Utility

  1. Colophon