Search -
High Performance MySQL: Optimization, Backups, Replication, and More
High Performance MySQL Optimization Backups Replication and More Author:Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek Balling 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, ... more »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.« less