Since the enormous number of new 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. Youll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. Youll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 3 Ratings

An advanced MySQL and DBMS book - 2007-03-07
Reviewer Rating:
This is an advanced book.
You can use it to learn the internals of MySQL as well as the internals of a Database Management System (DBMS).
It will teach you how to make changes to the MySQL source code.
An alternative name for the book could have been "MySQL internals".
I really like it and I find it very useful.

PS. It contains C++ code.

Move your knowledge of MySQL ahead with this book - 2008-02-05
Reviewer Rating:
Expert MySQL starts with a section on the anatomy of a database system including the common types of systems. This is often missing in database books and a very important part to understand if you going to use one to its fullest potential. Other sections include one on the source code and one on extending and debugging MySQL. The author devotes a chapter to embedded MySQL including building embedded MySQL applications as well as one on adding functions and commands. The third and final part of the book covers advanced database internals and includes a good section on query optimization.

Throughout Expert MySQL the author has included notes embedded with the text, sidebars offset by a different shading, and other notes, diagrams, and illustrations as appropriate to help the reader understand the text. There are also plenty of coding examples. My book had some printing problems towards the back with pages that had a vertical black line running down the center of the page. This sort of problem is highly unusual with Apress but occurred in my copy nonetheless. Chapters 10, 11 and 12 have exercises at the end to help ensure that you understand the concepts. The answers to the questions are included in the appendix.

This is not really the best book for the person new to MySQL but is more appropriate to the person who understands MySQL and wants to extend its functionality into new areas. Expert MySQL is recommended to those people who want to learn how to modify and extend MySQL.

Expert MySQL Lives Up to Its Title - 2007-09-04
Reviewer Rating:
This book lives up to its title by offering expert advice on how to use MySQL to its fullest. Expert MySQL goes deeper than just syntax and samples, offering useful information on the internals of MySQL. Even though there are a lot of titles on MySQL, this book would make a worthy addition to the library of any MySQL developer or DBA.

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > MySQL