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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 20 Ratings

Good, but incomplete - 2009-03-18
Reviewer Rating:
I bought this book hoping to get a detailed understanding of how to best create and use indexes for my high traffic web site. While the book does a great job of covering the pros and cons of standard indexes, it devotes only a single page to the utility of index_merge (introduced in Mysql 5.0). Combined with a general dearth of information about index_merge on the web, this was a really disappointment, since index_merge seems to afford the possibility of using multiple, smaller indexes, rather than smaller number of bulky indexes (as this book recommends).

In my eyes, a thorough analysis of indexing techniques in Mysql 5+ must discuss the strategic opportunities afforded by index_merge. It would seem to me that this gives the developer the ability to simply index the fields they want indexed, without having to sweat left-precedence of combined indexes or trying to make long indexes that include all of the possibly needed indexes in an order that will satisfy all possible query combinations.

If limitations to the utility of index_merge make some of these possibilities not feasible, the book ought to at least give a rundown of the pros and cons of index_merge vs. compound indexes.

The near-total omission of a new feature that could have profound implications upon the most optimal way to query & index makes me recommend this book with a tablespoon of salt.

Very useful... just very useful. - 2009-11-11
Reviewer Rating:
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;)

PERFECT BOOK! JUMP INTO ACTION IN FEW PAGES - 2009-10-10
Reviewer Rating:
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

I'll be surprised if I don't get a raise after mastering this book - 2009-07-30
Reviewer Rating:
For weeks, I'd been searching online, trying to find out what MySQL's slow queries log actually was. Eventually I found it.

And then I got this book, and there was an even better description than what I'd found in MySQL's online documentation.

I swear, after I've worked my way through this book, if I don't double my wages, I'll be a monkey's uncle.

A very good percpective of MySQL - 2009-06-27
Reviewer Rating:
This book helped me understand how MySQL works internally and a lot of tricks to improve the performances of both the server itself and the SQL queries I run against it.
If you want to improve the performances of MySQL related work in your applications, this book is definitively for you

Browse Similar Topics

Top Level Categories:
Databases
Operating Systems

Sub-Categories:
Databases > MySQL
Operating Systems > Linux
Linux > Applications
Operating Systems > UNIX
UNIX > Utilities And Tools