Book description
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include:
- A review of configuration and setup options
- Storage engines and table types
- Benchmarking
- Indexes
- Query Optimization
- Application Design
- Server Performance
- Replication
- Load-balancing
- Backup and Recovery
- Security
Publisher resources
Table of contents
- Preface
- 1. Back To Basics
-
2. Storage Engines (Table Types)
- 2.1. MySQL Architecture
- 2.2. Locking and Concurrency
- 2.3. Transactions
- 2.4. Selecting the Right Engine
- 2.5. The Storage Engines
- 3. Benchmarking
- 4. Indexes
- 5. Query Performance
- 6. Server Performance Tuning
-
7. Replication
- 7.1. Replication Overview
- 7.2. Configuring Replication
- 7.3. Under the Hood
- 7.4. Replication Architectures
-
7.5. Administration and Maintenance
- 7.5.1. Monitoring
- 7.5.2. Log Rotation
- 7.5.3. Changing Masters
-
7.5.4. Tools
- 7.5.4.1. mysqlbinlog: Viewing data in logs
- 7.5.4.2. check_repl: Ensuring that replication takes place
- 7.5.4.3. fix_repl: Skipping a bad query to continue replication
- 7.5.4.4. purge_binary_logs: Reclaiming space used by binary logs
- 7.5.4.5. mysqldiff: Replication sanity checks
- 7.5.4.6. write_heartbeat: Generating a periodic health check heartbeat
- 7.5.4.7. read_heartbeat: Measuring replication log using heartbeat
- 7.6. Common Problems
- 7.7. The Future of Replication
- 8. Load Balancing and High Availability
- 9. Backup and Recovery
- 10. Security
- A. The SHOW STATUS and SHOW INNODB STATUS Commands
- B. mytop
- C. phpMyAdmin
- About the Authors
- Colophon
- Copyright
Product information
- Title: High Performance MySQL
- Author(s):
- Release date: April 2004
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596003067
You might also like
book
High Performance MySQL, 3rd Edition
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques …
book
High Performance MySQL, 2nd Edition
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by …
book
Efficient MySQL Performance
You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because …
book
MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds
Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue …