High Performance MySQL
High Performance MySQL, Second Edition Optimization, Backups, Replication, and More By Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek J. Balling
June 2008
Pages: 708

| Table of Contents | Colophon

Table of Contents

  1. Chapter 1 MySQL Architecture

    1. MySQL's Logical Architecture

    2. Concurrency Control

    3. Transactions

    4. Multiversion Concurrency Control

    5. MySQL's Storage Engines

  2. Chapter 2 Finding Bottlenecks: Benchmarking and Profiling

    1. Why Benchmark?

    2. Benchmarking Strategies

    3. Benchmarking Tactics

    4. Benchmarking Tools

    5. Benchmarking Examples

    6. Profiling

    7. Operating System Profiling

  3. Chapter 3 Schema Optimization and Indexing

    1. Choosing Optimal Data Types

    2. Indexing Basics

    3. Indexing Strategies for High Performance

    4. An Indexing Case Study

    5. Index and Table Maintenance

    6. Normalization and Denormalization

    7. Speeding Up ALTER TABLE

    8. Notes on Storage Engines

  4. Chapter 4 Query Performance Optimization

    1. Slow Query Basics: Optimize Data Access

    2. Ways to Restructure Queries

    3. Query Execution Basics

    4. Limitations of the MySQL Query Optimizer

    5. Optimizing Specific Types of Queries

    6. Query Optimizer Hints

    7. User-Defined Variables

  5. Chapter 5 Advanced MySQL Features

    1. The MySQL Query Cache

    2. Storing Code Inside MySQL

    3. Cursors

    4. Prepared Statements

    5. User-Defined Functions

    6. Views

    7. Character Sets and Collations

    8. Full-Text Searching

    9. Foreign Key Constraints

    10. Merge Tables and Partitioning

    11. Distributed (XA) Transactions

  6. Chapter 6 Optimizing Server Settings

    1. Configuration Basics

    2. General Tuning

    3. Tuning MySQL's I/O Behavior

    4. Tuning MySQL Concurrency

    5. Workload-Based Tuning

    6. Tuning Per-Connection Settings

  7. Chapter 7 Operating System and Hardware Optimization

    1. What Limits MySQL's Performance?

    2. How to Select CPUs for MySQL

    3. Balancing Memory and Disk Resources

    4. Choosing Hardware for a Slave

    5. RAID Performance Optimization

    6. Storage Area Networks and Network-Attached Storage

    7. Using Multiple Disk Volumes

    8. Network Configuration

    9. Choosing an Operating System

    10. Choosing a Filesystem

    11. Threading

    12. Swapping

    13. Operating System Status

  8. Chapter 8 Replication

    1. Replication Overview

    2. Setting Up Replication

    3. Replication Under the Hood

    4. Replication Topologies

    5. Replication and Capacity Planning

    6. Replication Administration and Maintenance

    7. Replication Problems and Solutions

    8. How Fast Is Replication?

    9. The Future of MySQL Replication

  9. Chapter 9 Scaling and High Availability

    1. Terminology

    2. Scaling MySQL

    3. Load Balancing

    4. High Availability

  10. Chapter 10 Application-Level Optimization

    1. Application Performance Overview

    2. Web Server Issues

    3. Caching

    4. Extending MySQL

    5. Alternatives to MySQL

  11. Chapter 11 Backup and Recovery

    1. Overview

    2. Considerations and Tradeoffs

    3. Managing and Backing Up Binary Logs

    4. Backing Up Data

    5. Recovering from a Backup

    6. Backup and Recovery Speed

    7. Backup Tools

    8. Scripting Backups

  12. Chapter 12 Security

    1. Terminology

    2. Account Basics

    3. Operating System Security

    4. Network Security

    5. Data Encryption

    6. MySQL in a chrooted Environment

  13. Chapter 13 MySQL Server Status

    1. System Variables

    2. SHOW STATUS

    3. SHOW INNODB STATUS

    4. SHOW PROCESSLIST

    5. SHOW MUTEX STATUS

    6. Replication Status

    7. INFORMATION_SCHEMA

  14. Chapter 14 Tools for High Performance

    1. Interface Tools

    2. Monitoring Tools

    3. Analysis Tools

    4. MySQL Utilities

    5. Sources of Further Information

  1. Appendix Transferring Large Files

    1. Copying Files

    2. File Copy Benchmarks

  2. Appendix Using EXPLAIN

    1. Invoking EXPLAIN

    2. The Columns in EXPLAIN

    3. Visual EXPLAIN

  3. Appendix Using Sphinx with MySQL

    1. Overview: A Typical Sphinx Search

    2. Why Use Sphinx?

    3. Architectural Overview

    4. Special Features

    5. Practical Implementation Examples

    6. Conclusion

  4. Appendix Debugging Locks

    1. Lock Waits at the Server Level

    2. Lock Waits in Storage Engines

  5. Colophon

Return to High Performance MySQL