Enter your mobile number or email address 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.

  • Apple
  • Android
  • Windows Phone
  • Android

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

High Performance MySQL: Optimization, Backups, and Replication Third Edition Edition

4.7 out of 5 stars 35 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.
Sell yours for a Gift Card
We'll buy it for $9.01
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$22.85 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$35.47 On clicking this link, a new layer will be open
More Buying Choices
43 New from $27.72 26 Used from $18.85
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$35.47 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

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: $121.61
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


Product Details

  • Paperback: 826 pages
  • Publisher: O'Reilly Media; Third Edition 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 (35 customer reviews)
  • Amazon Best Sellers Rank: #147,266 in Books (See Top 100 in Books)

More About the Authors

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

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 10 of 10 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 of 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 of 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 of 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 of 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 wound up in a spot where google wasn't helping and stackoverflow turned up blank. thankfully i had this laying around from school, and it helped me narrow my thoughts and come up with the right questions.

chapters (don't mind my spelling): mysql architecture and history; benchmarking mysql; profiling server performance; optimizing schema and data types; indexing for high performance; query performance optimization; advanced mysql features; optimizing server settings; operating system and hardware optimization; replication; scaling mysql; high availability; mysql in the cloud; application level optimization; backup and recovery; tools for mysql users.
appendixes: forks and variants of mysql; mysql server status; transferring large files; using explain; debugging locks; using sphinx with mysql.
Comment 1 of 1 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: 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 of 4 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
By Djames on November 1, 2013
Format: Kindle Edition Verified Purchase
This is the first technical book that I can to read the first to the last page. Thanks this book I could to understand important stuffs about MySQL administration, configs composition, profiling and benchmarks. I could to change a database using MyISAM as engine for a newer version using InnoDB and I earned a lot of performance, it's unbelievable!
Comment 1 of 1 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

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
High Performance MySQL: Optimization, Backups, and Replication
This item: High Performance MySQL: Optimization, Backups, and Replication
Price: $35.47
Ships from and sold by Amazon.com

Want to discover more products? Check out these pages to see more: mysql performance, mysql administration, sql o'reilly