Understanding MySQL Internals and over one million other books are available for Amazon Kindle. Learn more

Understanding MySQL Internals 1st Edition

7 customer reviews
ISBN-13: 978-0596009571
ISBN-10: 0596009577
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $4.99
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent
$22.24
Buy used
$33.43
Buy new
$36.06
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, April 17, 2007
"Please retry"
$36.06
$23.49 $18.99
More Buying Choices
28 New from $23.49 16 Used from $18.99
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks
$36.06 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Understanding MySQL Internals + High Performance MySQL: Optimization, Backups, and Replication + MySQL High Availability: Tools for Building Robust Data Centers
Price for all three: $114.50

Buy the selected items together

Editorial Reviews

Book Description

Discovering and Improving a Great Database

About the Author

Sasha Pachev graduated from the Brigham Young University in 1998 with a degree in Computer Science, worked on the MySQL development team in 2000-2002, and was the original developer of replication in MySQL. In 2003 he wrote his first book MySQL Enterprise Solutions. He currently lives in Provo, Utah with his wife Sarah and his five children working as an independent consultant with the emphasis onMySQL.

In spite of his great interest in computers, Sasha is equallypassionate about distance running. He has won a number of marathons, has a personal best of 2:24:47, and is attempting to qualify for the US Olympic Trials. He feels it is important to help other runners reach their potential, and operates a web site http://FastRunningBlog.Com dedicated to that purpose.

NO_CONTENT_IN_FEATURE


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 258 pages
  • Publisher: O'Reilly Media; 1 edition (April 20, 2007)
  • Language: English
  • ISBN-10: 0596009577
  • ISBN-13: 978-0596009571
  • Product Dimensions: 7 x 0.6 x 9.2 inches
  • Shipping Weight: 15.2 ounces (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #720,319 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

15 of 16 people found the following review helpful By Adrien Lamothe on May 25, 2007
Format: Paperback
MySQL is assuming increased importance as an enterprise database and has become the de-facto standard with web hosting companies. A number of books have appeared in recent years, covering various aspects of MySQL. In Understanding MySQL Internals, Sasha Pachev, a MySQL-focused consultant and former member of the MySQL development team, takes us on a tour of how MySQL works and how it is built.

Starting with an overview of MySQL history and architecture, the book quickly moves us through working with the source code to build and run the product in a debugger. Drawing on his deep experience with the software, Mr. Pachev explains the coding conventions used to develop MySQL and why you should use them when modifying the software yourself.

The author delineates the different functional "modules" (a term he coined himself to better explain the database, technically speaking there are no defined modules in MySQL's architecture) of MySQL and how they interrelate. Herein lies the key to how this book teaches the reader the vast intricacy of such a complex piece of software. The author recognizes the subject is huge and the source code changing. What he does in the book is serve as our tour guide, driving us through the various areas and explaining as much relevant information as he reasonably can. He constantly illustrates key pieces of source code and data structures; but perhaps more importantly he makes reference to the actual source files utilized by each functional component of the system, while encouraging us to explore further on our own. His approach is very much "top down".

As he takes us on this tour, the author explains many of the design decisions behind the various MySQL components, often imparting the historical perspective behind them.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By John Murtari on August 20, 2008
Format: Paperback Verified Purchase
I have been working on a project to make some changes to MySQL server
operation. Learned a lot through code review & trial and error! Recently
purchased this book and it is excellent! Wish we had it months ago.

The author knows what he's talking about. Provides a great overview of the
architecture, file and subsystem layout. Also provides great information on using the 'built in' debug capability of the server -- very useful!

I was expecting to be disappointed, I was not. The content was right
on the mark for those folks interested on working on server internals.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 6 people found the following review helpful By Ilya Grigorik on December 31, 2007
Format: Paperback Verified Purchase
An excellent overview of the MySQL codebase, philosophy, and the design decisions that have made MySQL what it is today. Even though I have never touched the MySQL source before (it can be a daunting beast for the uninitiated), Sasha's explanations made me comfortable with the 'internals' and finally lifted the 'magic veil' off the engine. 'MySQL internals' has a perfect balance of high-level explanations, and low-level code samples to help you understand the inner workings of the database.

After reading this book you should be comfortable enough to tackle the source, and you'll also have deep understanding of the storage engines and how to configure them, how the query parser works, how the optimizer decides on the execution plan, and much more. This is a must read for any DBA, or a programmer who wants to see a great example of a high-performance, reliable UNIX server.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 3 people found the following review helpful By Baggu on December 24, 2013
Format: Paperback Verified Purchase
I bought this book to learn about the storage engine, query engine architecture and some internal stuff, but this book isn't about that. This book is for DBAs and consultants who want to implement the MySQL solution.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Understanding MySQL Internals
This item: Understanding MySQL Internals
Price: $36.06
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?