Home Page Icon
Home Page
Table of Contents for
Title
Close
Title
by Charles Bell
Expert MySQL, Second Edition
Title
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewers
Acknowledgments
Introduction
Part 1: Getting Started with MySQL Development
Chapter 1: MySQL and The Open Source Revolution
What Is Open Source Software?
Developing with MySQL
A Real-World Example: TiVo
Summary
Chapter 2: The Anatomy of a Database System
Types of Database Systems
Relational Database System Architecture
The MySQL Database System
Summary
Chapter 3: A Tour of the MySQL Source Code
Getting Started
The MySQL Source Code
Coding Guidelines
Building the System for the First Time
Summary
Chapter 4: Test-Driven MySQL Development
Background
MySQL Testing
Summary
Part 2: Extending MySQL
Chapter 5: Debugging
Debugging Explained
Approaches to Debugging
External Debuggers
Debugging MySQL
Debugging in Linux
Debugging in Windows
Summary
Chapter 6: Embedded MySQL
Building Embedded Applications
What Is an Embedded System?
Types of Embedded Systems
Embedded Database Systems
Embedding MySQL
Methods of Embedding MySQL
Resource Requirements
Security Concerns
Advantages of MySQL Embedding
Limitations of MySQL Embedding
The MySQL C API
Getting Started
Most Commonly Used Functions
Creating an Embedded Server
Initializing the Server
Setting Options
Connecting to the Server
Running Queries
Retrieving Results
Cleanup
Disconnecting from and Finalizing the Server
Putting It All Together
Error Handling
Building Embedded MySQL Applications
Compiling the Library (libmysqld)
What About Debugging?
What About the Data?
Creating a Basic Embedded Server
What About Error Handling?
Embedded Server Application
Managed vs. unmanaged code
Summary
Chapter 7: Adding Functions and Commands to MySQL
Adding User-Defined Functions
Adding Native Functions
Compiling and Testing the New Native Function
Adding SQL Commands
Adding to the Information Schema
Summary
Chapter 8: Extending MySQL High Availability
What is Replication?
Basic Replication Setup
The Binary Log
Replication Architecture
A Brief Tour of the Replication Source Code
Extending Replication
Summary
Chapter 9: Developing MySQL Plugins
MySQL Plugins Explained
The RFID Authentication Plugin
Summary
Chapter 10: Building Your Own Storage Engine
MySQL Storage Engine Overview
Storage Engine Development Process
Source Files Needed
Unexpected Help
The Handlerton
The Handler Class
A Brief Tour of a MySQL Storage Engine
The Spartan Storage Engine
Getting Started
Stage 1: Stubbing the Engine
Testing Stage 1 of the Spartan Engine
Stage 2: Working with Tables
Testing Stage 2 of the Spartan Engine
Stage 3: Reading and Writing Data
Testing Stage 3 of the Spartan Engine
Stage 4: Updating and Deleting Data
Testing Stage 4 of the Spartan Engine
Stage 5: Indexing the Data
Testing Stage 5 of the Spartan Engine
Stage 6: Adding Transaction Support
Summary
Part 3: Advanced Database Internals
Chapter 11: Database System Internals
Query Execution
Exploring MySQL Internals
The Database System Internals Experiment
Summary
Chapter 12: Internal Query Representation
The Query Tree
Implementing DBXP Query Trees in MySQL
Summary
Chapter 13: Query Optimization
Types of Query Optimizers
Cost-Based Optimizers
Heuristic Optimization Revisited
The DBXP Query Optimizer
Stubbing the DBXP_SELECT Command
Important MySQL Structures and Classes
Compiling and Testing the Code
Summary
Chapter 14: Query Execution
Query Execution Revisited
DBXP Query Execution
Summary
Appendix
Bibliography
Sample Database
Chapter Exercise Notes
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Copyright
Expert MySQL
Second Edition
Charles Bell
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset