High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Learn how to design schema, index, query MySQL and advanced features for maximum performance, and getting a detailed guidance for tuning the MySQL server, operating system and hardware to their full potential. The main extra included: The emphasis throughout the performance and reliability Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effect 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 query features, like full text search Four new appendix This book also includes chapters on benchmarking, profile, backup, security, and tools and techniques to help you measure, monitor, and manage your MySQL installation.