Expert MySQL

Front Cover
Apress, Apr 1, 2007 - Computers - 600 pages

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.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

MySQL and the Open Source Revolution
3
The Anatomy of a Database System
25
A Tour of the MySQL Source Code
63
TestDriven MySQL Development
121
Debugging
153
Embedded MySQL
193
Building Your Own Storage Engine
255
Adding Functions and Commands to MySQL
357
Database System Internals
393
Internal Query Representation
403
Query Optimization
439
Query Execution
489
Appendix
535
Index
545
Copyright

Other editions - View all

Common terms and phrases

About the author (2007)

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/.

Bibliographic information