Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

High Performance MySQL: Optimization, Backups, and Replication 3rd Edition

4.7 out of 5 stars 37 customer reviews
ISBN-13: 978-1449314286
ISBN-10: 1449314287
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.
Trade in your item
Get a $3.10
Gift Card.
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$12.98 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$20.00 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$32.44 On clicking this link, a new layer will be open
More Buying Choices
43 New from $25.49 34 Used from $10.03
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Best Books of the Year So Far
Looking for something great to read? Browse our editors' picks for the Best Books of the Year So Far in fiction, nonfiction, mysteries, children's books, and much more.
$32.44 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • High Performance MySQL: Optimization, Backups, and Replication
  • +
  • MySQL Cookbook: Solutions for Database Developers and Administrators
  • +
  • MySQL (5th Edition) (Developer's Library)
Total price: $119.72
Buy the selected items together

Editorial Reviews

Book Description

Optimization, Backups, and Replication

About the Author

Baron Schwartz is Chief Performance Architect at Percona. He createstools and techniques to make MySQL easier to use and more dependable,and speaks regularly at conferences worldwide. He lives in Virginia with his family.

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. He serves as CEO of Percona, while keeping touch with his technical roots by continuing to do consulting for key customers.

Vadim Tkachenko is the CTO and co-founder of Percona, and an authoron the MySQLPerformanceBlog.com and SSDPerformanceBlog.com blogs. Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.

NO_CONTENT_IN_FEATURE
New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 826 pages
  • Publisher: O'Reilly Media; 3 edition (April 2, 2012)
  • Language: English
  • ISBN-10: 1449314287
  • ISBN-13: 978-1449314286
  • Product Dimensions: 7 x 1.7 x 9.2 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (37 customer reviews)
  • Amazon Best Sellers Rank: #101,166 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

Format: Paperback
I've worked a lot with MySQL, over the past few years. I'm completely self-taught, however, and obviously, I've had gaps to deal with. While Google is dandy in a pinch, a book like this really fills in the blanks and provides a far more comprehensive understanding. Granted, if you're just starting out with MySQL, this is probably not the best book for you. Just looking at it from a learner's perspective, you'd better have at least a basic grasp under your belt or this book is going to be a tough one to tackle. If you've got a good background in it though, and are looking to be a real expert in the field, I'd definitely recommend this book. Even if you've already read the second edition, this third edition is definitely worth the purchase as the information is updated and the authors really expand previously presented topics. My overall take: It's well written, well organized and easy to reference when needed.
1 Comment 12 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Every chapter is very well crafted, with a precise balance between theory and practice, and full of invaluable nuggets, sometimes transcending the MySQL arena and applicable to any database! Such cases are Chapter-Benchmarking MySQL and Chapter 3-Profiling Server Performance, very solid foundations for the reading ahead.

All over the text, authors propose tools, examples of use and proven diagnostic techniques, that will greatly improve your performance firefighter skills and enhance your knowledge of MySQL internals. Nevertheless, what gives this book the five star is taking into consideration the physical part of database structures in play when speaking about performance, which is something most authors don't include; plus treatment on MySQL high availability and cloud features, which we'll increasingly see on customers.

There is something that kind of bugged me at times and was references to a specific commercial MySQL offering and tools, but after taking a look to that company web-site, found that is a great contributor to the MySQL community and you can actually use the tools!
Comment 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
'High Performance MySQL: Optimization, Backups, and Replication' is a nearly 800 page reference books that shines for doing exactly what the title says. Topics included are:

- benchmarking
- optimizing schemas
- indexing
- optimizing queries
- optimizing the server
- replication
- backup/recovery

Wonderfully written and the kind of reference material that you don't find lots of days nowadays in the computer book market. For anyone that is a MySQL developer or admin, you will be very wise to pick up this great book!!

***** HIGHLY RECOMMENDED
Comment 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
You'd be hard-pressed to find the kind of in-depth information this book contains anywhere else. This is in-depth information on complicated settings of storage engines and examples about handling race conditions and other advanced performance topics.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This is a perfect book if you're looking to improve your skills on MySQL. I'd recommend this book if you're at an intermediate level of MySQL knowledge and looking to improve on overall query performance and fine tune MySQL settings. It's a great addition to my bookshelf. Each subsequent edition adds lots of material - I currently own the 1st edition and the 3rd edition and the latter is over twice as thick as the first edition.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I turned to Chapter 4 when I got it, read 9 pages, and felt like I already got my money's worth of value. It'd take days to distill this book's information out of blogs, forums, and mailing lists on my own. I can at least feel like the authors experience has been vetted - blogs, forums, and mailing lists have dubious reliability in comparison.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
It's well-written, and told me what I needed to know to help a customer. Specifically, the customer wanted to know how to optimize MySQL databases for performance, and the book did have some good tips for that.

Although, I must add, that the tip that did my customer the most good wasn't listed in the book. Rather, I found the procedure for placing databases on separate drives by doing a Google search. But still, all-in-all, a useful book.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
As the demands on a website increase, so does the need for deeper knowledge, particularly when so much contradictory advice pervades the technical forums. I didn't rate it five stars mainly because while it's a trove of valuable information, it's not particularly well-organized in the pedantic sense. Still--if your on-line presence is growing, you need this book on the shelf.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

High Performance MySQL: Optimization, Backups, and Replication
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: High Performance MySQL: Optimization, Backups, and Replication

What Other Items Do Customers Buy After Viewing This Item?