Expert MySQL (Expert's Voice in Open Source) [Paperback]

Dr. Charles A. Bell (Author)

Book Description

ISBN-10: 1590597419 | ISBN-13: 978-1590597415 | Publication Date: January 26, 2007 | Edition: 1

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.

Editorial Reviews

About the Author

Dr. Charles A. Bell conducts research in emerging technologies. He is an adjunct professor at Virginia Commonwealth University, where he teaches graduate-level computer science courses and recently joined MySQL AB as a senior software developer. He lives in a small town in rural Virginia with his loving wife. He received his Ph.D. in engineering from Virginia Commonwealth University in 2005. His research interests include database systems, versioning systems, semantic web, and agile software development.

Product Details

• Paperback: 600 pages
• Publisher: Apress; 1 edition (January 26, 2007)
• Language: English
• ISBN-10: 1590597419
• ISBN-13: 978-1590597415
• Product Dimensions: 9.3 x 7.1 x 1.2 inches
• Shipping Weight: 2.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,379,608 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Move your knowledge of MySQL ahead with this book, February 4, 2008

By 

Harold McFarland (Florida) - See all my reviews
(HALL OF FAME REVIEWER)    (VINE VOICE)    (REAL NAME)   

This review is from: Expert MySQL (Expert's Voice in Open Source) (Paperback)

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.

7 of 8 people found the following review helpful:

5.0 out of 5 stars An advanced MySQL and DBMS book, March 7, 2007

By 

M. Tsoukalos "Programming Dashboard Widgets" (Greece) - See all my reviews
(REAL NAME)   

This review is from: Expert MySQL (Expert's Voice in Open Source) (Paperback)

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.

3 of 4 people found the following review helpful:

4.0 out of 5 stars Expert MySQL Lives Up to Its Title, September 4, 2007

By 

Data Guy (Texas) - See all my reviews

This review is from: Expert MySQL (Expert's Voice in Open Source) (Paperback)

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.