High Performance MySQL: Optimization, Backups, and Replication

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!

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.

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.

"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.

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.

仕事でMySQL5.5を使用することになり、日本語版の発売までに１年以上かかりそうなので英語の勉強もかねて発売直後に購入をした。 設定ファイルのチューニングの症が非常に役に立った、なんでMySQLの本体に付属する設定ファイルは内容があんなに古いんだろうか・・・ ちょっと英語が難しいけれど、非常に参考になったので英語で読む価値ありだと思います。

(1) Has a lot of useful information and well written (2) Even advanced concepts like replication and query optimization are dealt with quite well (3) But it assumes that you are familiar with mysql, atleast basic commands like insertion, updation and altering tables.

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.

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.

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.