High performance MySQL

How can you bring out MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works a.

Using query logging.

Table of Contents; Foreword; Preface; How This Book Is Organized; A Broad Overview; Building a Solid Foundation; Configuring Your Application; MySQL as an Infrastructure Component; Miscellaneous Useful Topics; Software Versions and Availability; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Acknowledgments for the Third Edition; Acknowledgments for the Second Edition; From Baron; From Peter; From Vadim; From Arjen; Acknowledgments for the First Edition; From Jeremy; From Derek; Chapter 1. MySQL Architecture and History.

MySQL's Logical ArchitectureConnection Management and Security; Optimization and Execution; Concurrency Control; Read/Write Locks; Lock Granularity; Table locks; Row locks; Transactions; Isolation Levels; Deadlocks; Transaction Logging; Transactions in MySQL; AUTOCOMMIT; Mixing storage engines in transactions; Implicit and explicit locking; Multiversion Concurrency Control; MySQL's Storage Engines; The InnoDB Engine; InnoDB's history; InnoDB overview; The MyISAM Engine; Storage; MyISAM features; Compressed MyISAM tables; MyISAM performance; Other Built-in MySQL Engines; The Archive engine.

The Blackhole engineThe CSV…