Kurzbeschreibung
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.
Synopsis
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; and, 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.