Expert MySQL

by Charles Bell

Overview

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.

Product Details

ISBN-13:	9781590597415
Publisher:	Apress
Publication date:	01/26/2007
Series:	Expert's Voice in Open Source Series
Edition description:	1st ed.
Pages:	600
Product dimensions:	7.52(w) x 9.25(h) x 0.06(d)

About the Author

Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is the team lead for the MySQL Utilities team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005. Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker focusing on microcontroller projects and refinement of three-dimensional printers. Dr. Bell maintains a blog on his research projects and many other interests. You can find his blog at http://drcharlesbell.blogspot.com/.

Table of Contents

Part One: MySQL and the Open Source Revolution.- The Anatomy of a Database System.- A Tour of the MySQL Code Base.- Test Driven MySQL Development.- Part Two: Debugging.- Embedded MySQL.- Building Your Own Storage Handler.- Adding Your Own SQL Commands.- Part Three: Database System Internals.- Internal Query Representation.- Query Optimization.- Query Execution.