“High Performance MySQL” by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko; O’Reilly Media

Jun 2, 2013

—

Peter and Vadim are long-term contributors to MySQL open source code base and are the founders of Percona, MySQL consultancy. This is really THE book about MySQL written by engineers who have spent more than a decade working on MySQL code.

The book is equally valuable to devops and DB admins, as well as software developers. It assumes that you have a good working knowledge of MySQL, as it dives straight into the intricate details of the system architecture and performance fine-tuning.

I have first-hand experience using second edition of this book, and I can say that it paid itself back many times over when I was debugging critical performance issues I came across in HeiaHeia.com operations. Now this third edition (published in 2012) covers also new features in MySQL version 5.5.

In this new edition authors make real effort to explain not only how MySQL works, but why certain features in MySQL work the way they do.

Case studies peppered throughout the book are particularly interesting, as they give insight into how to deal with MySQL in large scale setups with high load and demand for high availability.

This book covers a lot of very complex topics from replication, clustering and sharding to high availability. Practical advice on how to profile your server, find and fix the bottlenecks in server setup as well as on the application side in SQL queries is invaluable.

I very much liked that book is organized in such a way that it can easily be used as a reference.

This is a must read for anyone who has a somewhat significant load on their MySQL DB server or is considering moving from a single server setup to a cluster.

Get your copy of the book at O’Reilly.

Comments

3 responses to ““High Performance MySQL” by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko; O’Reilly Media”

blue waffles blue waffles

October 21, 2016

Useful info. Fortunate me I found your website accidentally, and I’m shocked
why this accident did not came about in advance! I bookmarked it.
seven link

December 24, 2016

Wow! Thank you! I permanently wanted to write on my website
something like that. Can I take a fragment of your
post to my blog? https://www.zotero.org/groups/openwindow2122
Buddyskele

March 27, 2025

I was skeptical not far from CBD at initial, but after tiresome them like https://joyorganics.com/products/organic-cbd-gummies , I’m absolutely impressed. They present a convenient and enjoyable way to take CBD without any hassle. I’ve noticed a calming object, primarily in the evenings, which has helped with both significance and sleep. The finery as regards is the pre-measured dosage, so there’s no guessing involved. If you’re looking for an easy and tasty course of action to acquaintance CBD, gummies are plainly value in view of—nothing but modify steady to gain from a reputable disgrace!