Now that MySQL has proven to be a robust product for large, demanding environments, both programmers and administrators want more information on how to get the most out of it. High Performance MySQL goes beyond the basics to explain how MySQL works "under the hood" so that experienced users can understand why it's fast and, conversely, what can slow it down.

In this new edition, you'll learn how to maximize the speed and robustness of MySQL through advanced configuration, and methods to optimize everything from schemas, queries, server settings and applications to operating systems, and hardware -- topics that typical MySQL books don't cover very well. Other requirements for scaling MySQL, such as replication, backups, and load balancing, are thoroughly discussed as well.

This is not a book on MySQL theory -- it's a collection of hands-on methods for solving real-world problems, by authors who have the experience to back it up.

High Performance MySQL includes:

• Clustering solutions
• Impacts of new features of MySQL 5.0/5.1, including stored procedures, partitioned databases, triggers, and views
• Expanded comparisons of storage engines and optimization techniques specific to each one
• Federation (scaling by dividing data among different servers or different clusters)
• Optimization of subqueries
• Use of the new information schema to retrieve data about the server and your databases
• Optimization of advanced querying features, such as full text searches and the use of cursors

With this book, you'll discover good practices for large demanding environments, and learn about MySQL's weaknesses and how to work around them. High Performance MySQL offers the advanced solutions you need to ensure a smoothly functioning database-driven website.

See larger cover