Buy new:
$67.69
FREE delivery November 20 - 22
Ships from: Online Servant
Sold by: Online Servant
$67.69
FREE delivery November 20 - 22. Details
Or fastest delivery November 19 - 21. Details
Only 1 left in stock - order soon.
$$67.69 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$67.69
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Online Servant
Ships from
Online Servant
Sold by
Online Servant
Sold by
Online Servant
Returns
Returnable until Jan 31, 2025
Returnable until Jan 31, 2025
For the 2024 holiday season, eligible items purchased between November 1 and December 31, 2024 can be returned until January 31, 2025.
Read full return policy
Returns
Returnable until Jan 31, 2025
For the 2024 holiday season, eligible items purchased between November 1 and December 31, 2024 can be returned until January 31, 2025.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$32.26
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery November 29 - December 6 on orders shipped by Amazon over $35
Or fastest delivery November 27 - December 4
$$67.69 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$67.69
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Sold by WÖLF and Fulfilled by Amazon.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Baron Schwartz
Follow
Baron Schwartz
Follow
Something went wrong. Please try your request again later.

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

by Baron Schwartz (Author), Peter Zaitsev (Author), Vadim Tkachenko (Author)
4.6 4.6 out of 5 stars 145 ratings
See all formats and editions

There is a newer edition of this item:

High Performance MySQL: Proven Strategies for Operating at Scale
High Performance MySQL: Proven Strategies for Operating at Scale
$41.49
(42)
In Stock
{"desktop_buybox_group_1":[{"displayPrice":"$67.69","priceAmount":67.69,"currencySymbol":"$","integerValue":"67","decimalSeparator":".","fractionalValue":"69","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"pfylWUGAKSH8pnqd7zrOBiTHZBVUNaDxHJyO1pqA9CfAkaMmwKpg8jnAWnw7gFWwLEmcV%2FJFBt8ohbvXZF8X4yRsRmhOhAwuwX%2Bt8UBC5zNPco9b7Ti%2FRp05WfgWJUde4zczh0U3ifrkuQu9PtVhp2qCryaXwcVKpOLxu1FTeCujCB2i6ZRepQ%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$32.26","priceAmount":32.26,"currencySymbol":"$","integerValue":"32","decimalSeparator":".","fractionalValue":"26","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"pfylWUGAKSH8pnqd7zrOBiTHZBVUNaDx9fTrwmWOIm0QnKMOdm0psUpPn7xlTeT1AAmtjJ3XbkhRogajhXZFsCSX8CarMXc1TQCI3fTcZL462CaSGGH%2BECzpQLSD6moyu%2FZdd%2B7TLXbsgP6sXjWaZxn10xpfXJaHyDAIwle3dbnIJTCf5xCpdc03UL2G1WJT","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

How can you bring out MySQLâ??s full power? With High Performance MySQL, youâ??ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQLâ??s principles in action. With this book, youâ??ll learn how to think in MySQL.

  • Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
  • Implement improvements in replication, high availability, and clustering
  • Achieve high performance when running MySQL in the cloud
  • Optimize advanced querying features, such as full-text searches
  • Take advantage of modern multi-core CPUs and solid-state disks
  • Explore backup and recovery strategiesâ??including new tools for hot online backups

Previous slide of product details
  1. ISBN-10
    1449314287
  2. ISBN-13
    978-1449314286
  3. Edition
    3rd
  4. Publisher
    O'Reilly Media
  5. Publication date
    May 1, 2012
  6. Language
    English
  7. Dimensions
    7 x 1.72 x 9.19 inches
  8. Print length
    823 pages
  9. See all details
Next slide of product details
Amazon First Reads | Editors' picks at exclusive prices

Editorial Reviews

About the Author

Baron Schwartz is Chief Performance Architect at Percona. He creates tools 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 author on the MySQLPerformanceBlog.com and SSDPerformanceBlog.com blogs. Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.

Product details

  • Publisher ‏ : ‎ O'Reilly Media; 3rd edition (May 1, 2012)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 823 pages
  • ISBN-10 ‏ : ‎ 1449314287
  • ISBN-13 ‏ : ‎ 978-1449314286
  • Item Weight ‏ : ‎ 3.07 pounds
  • Dimensions ‏ : ‎ 7 x 1.72 x 9.19 inches
  • Customer Reviews:
    4.6 4.6 out of 5 stars 145 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Baron Schwartz

    Baron Schwartz

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Baron is a prominent MySQL performance expert, community leader, speaker, author, and software engineer. After earning a degree in Computer Science and spending several years as a software engineer, Baron grew and led Percona's consulting team and practice to international prominence, then founded VividCortex to give developers and operations teams deep visibility into the behavior and performance of production database systems. Although he is most recognized for his MySQL expertise, Baron understands and appreciates many types of databases, and participates actively in several database communities as a speaker and advocate, as evidenced by his Oracle ACE award among others.

    See more on the author's page
  2. Baron Schwartz

    Baron Schwartz

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
Next page

Customer reviews

4.6 out of 5 stars
145 global ratings

Customers say

Customers find the book's information quality great, giving clear answers to complex questions. They say it's presented in an accessible way and is super in-depth. Readers also mention it's worth every penny and a valuable addition to a MySQL DBA's library.

AI-generated from the text of customer reviews

Select to learn more
Information qualityValue for money
19 customers mention "Information quality"19 positive0 negative

Customers find the book's information quality great. They say it provides clear answers to complex questions, great insights, and is presented in an accessible way. Readers also mention that the book provides thorough guidance on all aspects of MySQL performance. What's more, they say it's full of practical tips that are clearly based in the real-world.

"...The information is presented in a very accessible way though and if you are coming from another RDBMS or have a decent technical background and are..." Read more

"...to performance and some administrative tasks, there's a surprising amount of information in the text...." Read more

"The 2nd edition provided clear an thorough guidance on all aspects of MySQL performance optimization and maintenance, allowing me to achieve..." Read more

"...The writers do an excellent job of explaining how everything is working and fitting together in the background, which has certainly given me a..." Read more

4 customers mention "Value for money"4 positive0 negative

Customers find the book worth every penny, saying it's a valuable addition to a MySQL DBA's library.

"...The new edition is well worth picking up, even if you have already read the 2nd edition cover-to-cover." Read more

"...It's worth reading just because of that - and if you're writing tech books, I strongly encourage you to buy the book and copy the style ;-)" Read more

"Worth every penny! This book is your best resource if you want to learn and/or master your MySQL knowledge." Read more

"Great book. Not much fluff. Valuable addition to a MySQL DBA's library." Read more

Top reviews from the United States

Joshua Prunier
5.0 out of 5 stars A must have for any MySQL DBA or developer!
Reviewed in the United States on September 8, 2012
Verified Purchase
I am extremely pleased with my purchase of High Performance MySQL, 3rd edition. I own the 2nd edition and my company recently upgraded to 5.5 so getting the 3rd edition was a no brainer. The book is extremely well organized and more information has been added to every single chapter. The new chapter on MySQL in the cloud is a timely welcome addition. The section on solid stage storage is also an example of how the contents have been updated to reflect the latest technology and trends. The book is full of real world scenarios and solutions the folks at Percona have encountered over the years. They do a great job of noting where features and functionality differs between 5.5 and 5.1 and also make reference to known features coming in 5.6. The level of detail contained within is much deeper than you will find in the online documentation and the authors do a great job of making clear the circumstances where features, configurations, engines and hardware may help or hurt with your specific application.

If you are brand new to MySQL this is probably not the right choice for you. The information is presented in a very accessible way though and if you are coming from another RDBMS or have a decent technical background and are committed to learning more MySQL, I recommend it highly. The book is definitely biased towards Linux which the authors admit in the foreward. But even if you are running a WAMP stack you will still find tons of useful information inside. I'm constantly pulling this book off my shelf to look up something real quick; either to confirm a thought or see if the experts have anything else to add on the subject. I can't wait for the 4th edition covering 5.6!
Helpful
 Report
Adam Scott
5.0 out of 5 stars Must read for making MySQL perform
Reviewed in the United States on July 19, 2012
Verified Purchase
If you want to make MySQL perform well, understand the deeper underpinnings related to performance and some administrative tasks, there's a surprising amount of information in the text.

The authors guide you through understanding and not just provide platitudes. They show you how to profile a server and use that to help you optimize (focused performance improvement vs. tuning -- implying random tweaking) your server and environment based on their experience. Their shared experience is more than worth the price of the book.

They offer some tactics scattered throughout that may be really useful like Computing the Distance Between Points (used in mapping applications)), improving high volume counters using a counter table, and the fastest way to transfer large files.

You need this if you want to optimize MySQL. (They cover Replication, Clustering, Sharding, Backup & Recovery, HA among many other topics as well.)

11.8.2013 - Still very good. The authors provide deep insights. Must have.
Helpful
 Report
Nilendu Misra
4.0 out of 5 stars Best Practitioners' Book on MySQL out there..
Reviewed in the United States on June 17, 2017
Verified Purchase
I recently had to come up to speed with MySQL to solve some major scale issues and I relied heavily on this book. Very highly recommended for -

1. This is a practitioner's book. e.g., when it covers "clustered table", it also explains why the secondary indexes on InnoDB tables will be wider than usual. Such similar references are across the book.

2. Especially, chapter 5 and 6 are of outstanding value to grok MySQL optimization and parsing subroutines. Pair it with Charles Bell "Expert MySQL" to understand what optimizer actually does and how it is very different from other databases you have worked with (e.g., no hash join etc.)

This would be a straight 5-stars if -

3. It covered some of the newer features of MySQL 5.6 (or 5.7+)
4. Be a little laconic in most, especially earlier, chapters. e.g., does it really need another 35 pages to go over "why and what you should tune"?
5. Real-life use cases the top 1-percent of MySQL users who need to extract full juice out of it (e.g., handler interfaces).

Overall, great book, hope authors rush a 4th edition.
14 people found this helpful
Helpful
 Report
Gus
5.0 out of 5 stars Worth the upgrade
Reviewed in the United States on September 7, 2012
Verified Purchase
The 2nd edition provided clear an thorough guidance on all aspects of MySQL performance optimization and maintenance, allowing me to achieve significant gains in a very short time on a high-volume production system. The 3rd edition refines and expands upon every topic, providing up-to-date information on recent changes to MySQL and it's various forks. The new edition is well worth picking up, even if you have already read the 2nd edition cover-to-cover.
One person found this helpful
Helpful
 Report
MCT
5.0 out of 5 stars Indispensable
Reviewed in the United States on October 1, 2012
Verified Purchase
"High Performance MySQL" is required reading for anyone who needs to dig deeper than MySQL 101. It's well organized, extremely well written for a technical book, and targets its content at exactly the right level: toward people who have the MySQL basics down, but are looking to add to their understanding and knowledge of MySQL in order to tackle both everyday and more esoteric problems. The writers do an excellent job of explaining how everything is working and fitting together in the background, which has certainly given me a clearer picture of MySQL's architecture, which in turn provides a better basis for problem-solving. This book is full of practical tips that are clearly based in the real-world troubleshooting experience of the authors. Highly recommended.
One person found this helpful
Helpful
 Report
Zechariah Campbell
5.0 out of 5 stars When StackOverflow can't help, this book will save you.
Reviewed in the United States on November 10, 2016
Verified Purchase
This book is amazing! It has saved me a couple times at work. Our systems are growing and we are running into performance issues. We are hitting problems you just can't google. This book provides some amazing insight into how MySQL works which has helped us fix some pretty big production bugs quickly. Can't recommend this book highly enough. So far I've used it to better understand Indexing (which it does a great job explaining) and to understand what Deadlocks are and how they occur. I naturally search StackOverflow.com first, but when I wasn't satisfied with StackOverflow answers, I turned to this book and it doesn't disappoint. Very nice work.
18 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Emanuele Pietrobono
5.0 out of 5 stars High Performance MySQL
Reviewed in Italy on September 14, 2022
Verified Purchase
Ottimo
Report
Leopold Linhart
5.0 out of 5 stars Ausgezeichet, prime, indispensable!
Reviewed in Germany on November 10, 2017
Verified Purchase
Das Buch ist kein MySQL-Manual für Vorgeschrittene, sondern eine Referenz für DBA's und vielleicht, aber eher nicht, Entwickler. Es geht darin nicht um tweaks zum High-Performance-Gebrauch der Syntax, um besonders "schlauen" Code, zu schreiben, oder "verzwickte" Aufgaben "elegant" zu lösen, sondern auf über 800 Seiten und ca. 1,4 kg Papier um das Drehen nur jedestmöglichen Schräubchens, um die Performance zu verbessern und als DBA den Entwicklern Architekturrichtlinien vorgeben zu können.

Das Buch ist dabei nicht bloß eine Hilfe, sondern deckt erschöpfend bis in den letzten Winkel alle Möglichkeiten der aktuellen MyPHP-Version ab.

MySQL oder MariaDB sind mittlerweile bei kleineren Anwendungen im kommerziellen und kostenpflichtigen Bereich eine Alternative zu Oracle, und eine Auseinandersetzung damit lohnt sich. Wussten Sie übrigens, dass der Schöpfer beider Systeme zwei Töchter hat? Die ältere heißt My, die jüngere Maria. "MySQL" ist also nicht eine syntaktische Wortschöpfung wie in Codebeispielen, wo es schnell mal "myVar" heißt, sondern eine hommage wie die von Herrn Benz, der seine Automarke nach seiner Tochter Mercedes benannt hat:-)
Report
Stephane Grenier
5.0 out of 5 stars Book title is a perfect match
Reviewed in Canada on February 4, 2016
Verified Purchase
This book is specific to MySQL and how to get the absolute best performance out of it. There is a lot of information and you should definitely be reading this book if you plan on using MySQL in a production environment.
Report
Amazon Customer
5.0 out of 5 stars Imprescindible
Reviewed in Spain on September 22, 2014
Verified Purchase
Quizá el mejor libro de MySQL que haya leído nunca, tanto para seniors como para iniciados en la materia. Se nota que el autor no solo tiene un conocimiento muy avanzado en la materia sino también, y he aquí lo difícil, que lo sabe transmitir a un público muy amplio.
Report
Alex Dicianu
5.0 out of 5 stars Great book for people who want to know more about mysql
Reviewed in France on August 17, 2013
Verified Purchase
I've been a web developer for years, but I discovered new things I had no idea about in every chapter. If you want to really understand mysql I highly recommend this book.
Report