Expert MySQL

Description

Since the enormous number of features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks.

Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. You'll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. You'll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.

CONTENTS:

Part 1 Getting Started with MySQL Development
Chapter 1 MySQL and the Open Source Revolution
Chapter 2 The Anatomy of a Database System
Chapter 3 A Tour of the MySQL Source Code
Chapter 4 Test-Driven MySQL Development

Part 2 Extending MySQL
Chapter 5 Debugging
Chapter 6 Embedded MySQL
Chapter 7 Building Your Own Storage Engine
Chapter 8 Adding Functions and Commands to MySQL

Part 3 Advanced Database Internals
Chapter 9 Database System Internals
Chapter 10 Internal Query Representation
Chapter 11 Query Optimization

Chapter 12 Query Execution