Programming Books C Java PHP Python Learn more Browse Programming Books
High Performance MySQL and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player

FREE Shipping on orders over $35.

Used - Good | See details
Have one to sell? Sell yours here
Start reading High Performance MySQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

High Performance MySQL: Optimization, Backups, Replication, and More [Paperback]

by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy D. Zawodny, Arjen Lentz, Derek J. Balling
4.6 out of 5 stars  See all reviews (29 customer reviews)

Available from these sellers.

Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $22.99  
Paperback --  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more
There is a newer edition of this item:
High Performance MySQL: Optimization, Backups, and Replication High Performance MySQL: Optimization, Backups, and Replication 4.6 out of 5 stars (28)
In Stock.

Book Description

June 25, 2008 0596101716 978-0596101718 Second Edition
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include:
  • Emphasis throughout on both performance and reliability
  • Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine
  • Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views
  • A detailed discussion on how to build very large, highly scalable systems with MySQL
  • New options for backups and replication
  • Optimization of advanced querying features, such as full-text searches
  • Four new appendices
The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

Customers Who Bought This Item Also Bought

Editorial Reviews

Book Description

The Path to Optimal Queries and Robust Servers

About the Author

Baron Schwartz is a software engineer who lives in Charlottesville, Virginia and goes by the online handle of "Xaprb," which is his first name typed in QWERTY on a Dvorak keyboard. When he's not busy solving a fun programming challenge, he relaxes with his wife Lynn and dog Carbon. He blogs about software engineering at

A former manager of the High Performace Group at MySQL AB, Peter Zaitsev now runs the site. He specializes in helping administrators fix issues with Web sites handling millions of visitors a day, dealing with terabytes of data using hundreds of servers. He is used to making changes and upgrades both to hardware to software (such as query optimization) in order to find solutions. He also speaks frequently at conferences.

Vadim Tkachenko was a Performance Engineer in at MySQL AB. As an expert in multithreaded programming and synchronization, his primary tasks were benchmarks, profiling, and finding bottlenecks. He also worked on a number of features for performance monitoring and tuning, and getting MySQL to scale well on multiple CPUs.

Jeremy Zawodny and his two cats moved from Northwest Ohio to Silicon Valley in late 1999 so he could work for Yahoo!--just in time to witness the .com bubble bursting first-hand. He's been at Yahoo!® ever since, helping to put MySQL and other Open Source technologies to use in fun, interesting, and often very big ways. Starting with the popular and high-traffic Yahoo! Finance site, he worked to make MySQL part of the site's core infrastructure in large batch operations as well as real-time feed processing and serving content directly on the site. He then helped to spread "the MySQL religion" to numerous other groups within Yahoo!, including News, Personals, Sports, and Shopping. Nowadays he acts as Yahoo!'s MySQL guru, working with Yahoo!'s many engineering groups to get the most out of their MySQL deployments.

In 2000, he began writing for Linux Magazine and continues to do so today as a columnist and contributing editor. After over a year of active participation on the MySQL mailing list, he got the idea to write a book about MySQL. (How hard could it be, really?) You can still find him answering questions on the list today. Since 2001, Jeremy has been speaking about MySQL at various conferences (O'Reilly's Open Source Conference, PHPCon, The MySQL User Conference, etc.) and user groups in locations as far away as Bangalore, India. His favorite topics are performance tuning, replication, clustering, and backup/recovery. In more recent times, he's rediscovered his love of aviation, earning a Private Pilot Glider license in early 2003. Since then he's spent far too much of his free time flying gliders out of Hollister, California and Truckee, near Lake Tahoe. He hopes to soon earn his Commercial Pilot license and then go on to become a certified flight instructor someday. Occasional MySQL consulting also helps to pay for his flying addiction.

Jeremy rambles almost daily about technology and life in general on his weblog:

Arjen Lentz was born in Amsterdam but has lived in Queensland Australia since the turn of the millennium, sharing his life these days with his beautiful daughter Phoebe and black cat Figaro. Originally a C programmer, Arjen was employee #25 at MySQL AB (2001-2007). After a brief break in 2007, Arjen founded Open Query (, which develops and provides its own data management training and consulting services in the Asia Pacific region and beyond. Arjen also regularly speaks at conferences and user groups. In his abundant spare time Arjen indulges in cooking, gardening, reading, camping, and exploring the RepRap. Arjen's weblog is at

Derek J. Balling has been a Linux system administrator since 1996. He
has helped build and maintain server infrastructure for companies like
Yahoo, and institutions like Vassar College. He has also written
articles for The Perl Journal and a number of online magazines, and is
on the Program Committee for the 2008 LISA Conference. He is currently
employed as the Data Center Manager for

When not working on computer-related issues, Derek enjoys spending
time with his wife Debbie, and their posse of animals (4 cats and a
dog). He also makes his opinion known on current events or whatever is
annoying him lately on his blog at

Product Details

  • Paperback: 712 pages
  • Publisher: O'Reilly Media; Second Edition edition (June 25, 2008)
  • Language: English
  • ISBN-10: 0596101716
  • ISBN-13: 978-0596101718
  • Product Dimensions: 9.2 x 7 x 1.7 inches
  • Shipping Weight: 2.5 pounds
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (29 customer reviews)
  • Amazon Best Sellers Rank: #201,662 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

Most Helpful Customer Reviews
36 of 36 people found the following review helpful
5.0 out of 5 stars Turbo Charging MySQL November 13, 2008
Well, the first thing you want to do when you finish a book like this is go on and on about how impressed you are. This is one of the best database technology books I've read, and the best one on MySQL.

Digging into the book I would say I was an intermediate DBA. With 12 years experience on Oracle I was a seasoned DBA. And although I've used MySQL for about 10 years, I had not used all of the high end or newest 5.0 and 5.1 features. After reading this book, or while reading it, you'll be ready to dig into everything from MySQL master-master replication (not to be confused with multi-master), creating a logging server, optimizing your query cache, or even using some of the Google MySQL patches to add some much needed but missing feature to MySQL.

The book is organized pretty well. Keep in mind that this is not a beginner book. If you're looking for more general across the board MySQL book, I'd recommend the APress Pro MySQL by Kruckenberg and Pipes Pro MySQL (Expert's Voice in Open Source). It is also very good, but hits more of the beginning topics (as well as some advanced ones). So given the intermediate to advanced audience, this book dives right into benchmarking and profiling at the beginning.

Queries... those pesky SQL commands that you send to your database. They're so important to performance, yet so sadly misunderstood. This book devotes two chapters to the topic, one about schema and index optimization, and one about query performance. These two work together. You need to understand indexing to make best use of them, and how to write good queries to get only the data you need. The indexing chapter hit on index types supported by MyISAM, and ones for InnoDB.
Read more ›
Comment | 
Was this review helpful to you?
16 of 16 people found the following review helpful
5.0 out of 5 stars Huge improvement over 1st edition October 4, 2008
Format:Paperback|Verified Purchase
If you read the first edition and were underwhelmed, this is a vastly improved book. This second edition is entirely rewritten, more than twice as long, and covers a wide array of topics in depth, giving detailed advice and analysis in every chapter. The authors' advice on Innodb tuning, query optimization, and advanced replication issues is very strong. If you are responsible for a non-trivial MySQL installation, get this book.
Comment | 
Was this review helpful to you?
10 of 10 people found the following review helpful
5.0 out of 5 stars Amazing must have December 28, 2008
If you have ever so much as sneezed near a MySQL statement you must read this book. I have been using MySQL and reading other books for at least a decade but had no idea how much I didn't know (had never thought of this way). This book is very well written, very useful and practical, detailed for complex concepts but high level for noob-esk items. At first I found the structure odd but after finishing I wouldn't change it. Even if you are not looking for 'performance' there is so much useful MySQL fundamentals clearly explained it is extremely useful. Just as a case in point, I lent it to a graphics designer whoes code is abstracted by an automated framework and it still helped him to make drastic improvements by more clearly understanding the impact his requests had. He has since not only purchased the book but passed it on to several others. Did I mention he was a graphics designer recommending a book about 'that database stuff'?

Hope this helps, best regards and may your coding be bug free...
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars Excellent book for advanced users August 31, 2008
The title of this book is very appropriate. Great coverage on performance, reliability, backup & recovery. Definitely not an introductory book.

There were a couple of places where the writing was hard to follow, but I'm sure that'll be fixed in the next printing.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars Outstanding December 6, 2008
The second edition of this book is far superior to any documentation or other books on MySQL that I have read. The content is extremely useful (see the table of contents), the writing is excellent and the explanations and diagrams are so lucid and elegant. The workarounds and other nifty pieces of advice are also valuable. I often couldn't put it down, which is unbelievable for a database text!
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
4.0 out of 5 stars Good goog. December 16, 2008
Very good MySQL book for people who knows the basics and want to get deeper.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Outstanding book on tuning MySQL August 20, 2008
Format:Paperback|Verified Purchase
I work with MySQL in a web server environment every day and performance
is always an issue. This book is simply excellent. The authors are quite knowledgeable -- they not only tell you what settings to you, but also include why. They debunked a lot of misconceptions I held about getting the best performance out of the server and when to use MyISAM v. InnoDB.

I especially appreciated the deep background into server operation and how data is stored and queries processed with the different storage engines. If you are thinking of using MySQL on a large project, you need this book.

There's a good reason this is a 2nd edition -- a great book.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Very useful... just very useful. November 11, 2009
How come I did not comment on this book before? Its been some time since I got it, read it, and used it! That's what this book is... useful, very useful. We had to optimize a DB, specially a huge table with millions of numbers and managed to go from tens of seconds to milisecs. I would say it was.. well, very useful;)
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Title is dead on
I got way more than I bargained for with this book. It goes into great detail on several ways to speed up and optimize MySQL. Read more
Published 18 months ago by J. Gartin
5.0 out of 5 stars full of practical demonstrations
I have not finished reading book yet but I like it so far. I am nor expert neither newbie in MySQL. I like that authors decided to use common language to explain very complicated... Read more
Published 18 months ago by David S. James
5.0 out of 5 stars Phenomenal, Must Read
I'm a web developer, not a DBA. However, I take my study of MySQL just as seriously as any other area of development. Read more
Published 20 months ago by jimmy dean
5.0 out of 5 stars If you use mysql, buy this
This is my first review ever of anything! I'm a long time user and buyer at amazon, including dozens of technical books (I'm a serial CTO). Read more
Published on July 23, 2011 by akroston
5.0 out of 5 stars THE book to get for MySQL DBAs / developers
If you're new to MySQL, or have been using it for years but need more depth, or want to come up to speed quickly by benefiting from others' experience and make their best-practices... Read more
Published on February 26, 2011 by Impressed
3.0 out of 5 stars Worth the purchase
Great resource for learning the ins and outs of benchmarking a typical cms with a mysql db.
Published on October 7, 2010 by W Morningstar
5.0 out of 5 stars The best book about creating software with High Aviability &...
This is just the best book I've read about creating software, that needs high availability and high scalability. You think, this is book is only about MySQL? Surprise! Read more
Published on May 23, 2010 by FractalizeR
4.0 out of 5 stars Good book
Good book, with detailed explanations, but it could get more detailed (that's why only 4 stars and not 5).
Published on April 2, 2010 by Alon
4.0 out of 5 stars A good start point into high performance
It's a good start point into high performance tunning, but not a deep into every concept, which is not possible in a single book. Read more
Published on February 11, 2010 by Lucas de L. Lorenzo
A good book for developers that want more. They want to optimize their scripts and really understand how MYSQL works also behind the scene.

A must have book
Published on October 10, 2009 by F. Levanti
Search Customer Reviews
Only search this product's reviews

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category