|
High Performance MySQL 2nd Edition
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.
|
