• Table of Contents
• Index
• Reviews
• Reader Reviews
• Errata
• Academic
High Performance MySQL
By Derek J. Balling, Jeremy Zawodny
Publisher: OReilly
Pub Date: April 2004
ISBN: 0-596-00306-4
Pages: 294
Slots: 1.0
Copyright
Preface
The Basic Layout of This Book
Software Versions and Availability
Conventions Used in This Book
Using Code Examples
How to Contact Us
Acknowledgments
Chapter 1. Back To Basics
Section 1.1. Binary Versus Compiled-From-Source Installations
Section 1.2. Configuration Files
Section 1.3. The SHOW Commands
Chapter 2. Storage Engines (Table Types)
Section 2.1. MySQL Architecture
Section 2.2. Locking and Concurrency
Section 2.3. Transactions
Section 2.4. Selecting the Right Engine
Section 2.5. The Storage Engines
Chapter 3. Benchmarking
Section 3.1. The Importance of Benchmarking
Section 3.2. Benchmarking Strategies
Section 3.3. Benchmarking Tools
Chapter 4. Indexes
Section 4.1. Indexing Basics
Section 4.2. Index Structures
Section 4.3. Indexes and Table Types
Section 4.4. Index Maintenance
Chapter 5. Query Performance
Section 5.1. Query Processing Basics
Section 5.2. Optimizer Features and Oddities
Section 5.3. Identifying Slow Queries
Section 5.4. Influencing MySQL with Hints
Section 5.5. Stupid Query Tricks
Chapter 6. Server Performance Tuning
Section 6.1. Performance-Limiting Factors
Section 6.2. RAID
Section 6.3. Operating System
Section 6.4. Techniques
Chapter 7. Replication
Section 7.1. Replication Overview
Section 7.2. Configuring Replication
Section 7.3. Under the Hood
Section 7.4. Replication Architectures
Section 7.5. Administration and Maintenance
Section 7.6. Common Problems
Section 7.7. The Future of Replication
Chapter 8. Load Balancing and High Availability
Section 8.1. Load Balancing Basics
Section 8.2. Configuration Issues
Section 8.3. Cluster Partitioning
Section 8.4. High Availability
Chapter 9. Backup and Recovery
Section 9.1. Why Backups?
Section 9.2. Considerations and Tradeoffs
Section 9.3. Tools and Techniques
Section 9.4. Rolling Your Own Backup Script
Chapter 10. Security
Section 10.1. Account Basics
Section 10.2. The Grant Tables
Section 10.3. Grant and Revoke
Section 10.4. Operating System Security
Section 10.5. Network Security
Section 10.6. Data Encryption
Section 10.7. MySQL in a chrooted Environment
Appendix A. The SHOW STATUS and SHOW INNODB STATUS Commands
Section A.1. SHOW STATUS
Section A.2. SHOW INNODB STATUS
Appendix B. mytop
Section B.1. Overview
Section B.2. Getting mytop
Section B.3. Configuration and Usage
Section B.4. Common Tasks
Appendix C. phpMyAdmin
Section C.1. The Basics
Section C.2. Practical Examples
Colophon
Index