High Performance MySQL.

Book Description

As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics. Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book. In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs. Topics include:

• A review of configuration and setup options
• Storage engines and table types
• Benchmarking
• Indexes
• Query Optimization
• Application Design
• Server Performance
• Replication
• Load-balancing
• Backup and Recovery
• Security
/p>

Reviews From AMAZON.COM




A computer book actually worth reading




I read approximately 2 computer-related books a month, and have done so for the last 10 years. This book is the best computer book I have read in the last 5 years, hands down.

Not content on the basic "how to install, learn SQL, etc" route, Zawodny and company have chosen to give you real nuggets of wisdom to tune your MySQL instance with. This book is for the advanced MySQL developer/DBA/Admin, and medium to high knowledge of MySQL is a must to use this book effectively.

I would recommend this book to anyone with performance problems coming from MySQL. As always, check your code first :)

Easy Reading but lacking some things

This is a book for someone that knows MySQL and wants to give a leap forward, the book is an easy read, you start read and in an afternoon you finish it (it is not a boring book).

Despite all the explanation between the different engines, master/slaves, optimized queries, there is no answers about the topic of binary versus compiled install. The author has 2 or 3 pages about it but it doesnt say absolutely nothing