High Performance MySQL
High Performance MySQL Optimization, Backups, Replication, Load Balancing & More By Jeremy Zawodny, Derek J. Balling
April 2004
Pages: 294

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  1. Chapter 1 Back To Basics

    1. Binary Versus Compiled-From-Source Installations

    2. Configuration Files

    3. The SHOW Commands

  2. Chapter 2 Storage Engines (Table Types)

    1. MySQL Architecture

    2. Locking and Concurrency

    3. Transactions

    4. Selecting the Right Engine

    5. The Storage Engines

  3. Chapter 3 Benchmarking

    1. The Importance of Benchmarking

    2. Benchmarking Strategies

    3. Benchmarking Tools

  4. Chapter 4 Indexes

    1. Indexing Basics

    2. Index Structures

    3. Indexes and Table Types

    4. Index Maintenance

  5. Chapter 5 Query Performance

    1. Query Processing Basics

    2. Optimizer Features and Oddities

    3. Identifying Slow Queries

    4. Influencing MySQL with Hints

    5. Stupid Query Tricks

  6. Chapter 6 Server Performance Tuning

    1. Performance-Limiting Factors

    2. RAID

    3. Operating System

    4. Techniques

  7. Chapter 7 Replication

    1. Replication Overview

    2. Configuring Replication

    3. Under the Hood

    4. Replication Architectures

    5. Administration and Maintenance

    6. Common Problems

    7. The Future of Replication

  8. Chapter 8 Load Balancing and High Availability

    1. Load Balancing Basics

    2. Configuration Issues

    3. Cluster Partitioning

    4. High Availability

  9. Chapter 9 Backup and Recovery

    1. Why Backups?

    2. Considerations and Tradeoffs

    3. Tools and Techniques

    4. Rolling Your Own Backup Script

  10. Chapter 10 Security

    1. Account Basics

    2. The Grant Tables

    3. Grant and Revoke

    4. Operating System Security

    5. Network Security

    6. Data Encryption

    7. MySQL in a chrooted Environment

  1. Appendix A The SHOW STATUS and SHOW INNODB STATUS Commands

    1. SHOW STATUS

    2. SHOW INNODB STATUS

  2. Appendix B mytop

    1. Overview

    2. Getting mytop

    3. Configuration and Usage

    4. Common Tasks

  3. Appendix C phpMyAdmin

    1. The Basics

    2. Practical Examples

  4. Colophon

Return to High Performance MySQL