Sitemap
High Performance MySQL
Table of Contents
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
1.1 Binary Versus Compiled-From-Source Installations
1.2 Configuration Files
1.3 The SHOW Commands
Chapter 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
Chapter 3. Benchmarking
3.1 The Importance of Benchmarking
3.2 Benchmarking Strategies
3.3 Benchmarking Tools
Chapter 4. Indexes
4.1 Indexing Basics
4.2 Index Structures
4.3 Indexes and Table Types
4.4 Index Maintenance
Chapter 5. Query Performance
5.1 Query Processing Basics
5.2 Optimizer Features and Oddities
5.3 Identifying Slow Queries
5.4 Influencing MySQL with Hints
5.5 Stupid Query Tricks
Chapter 6. Server Performance Tuning
6.1 Performance-Limiting Factors
6.2 RAID
6.3 Operating System
6.4 Techniques
Chapter 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.6 Common Problems
7.7 The Future of Replication
Chapter 8. Load Balancing and High Availability
8.1 Load Balancing Basics
8.2 Configuration Issues
8.3 Cluster Partitioning
8.4 High Availability
Chapter 9. Backup and Recovery
9.1 Why Backups?
9.2 Considerations and Tradeoffs
9.3 Tools and Techniques
9.4 Rolling Your Own Backup Script
Chapter 10. Security
10.1 Account Basics
10.2 The Grant Tables
10.3 Grant and Revoke
10.4 Operating System Security
10.5 Network Security
10.6 Data Encryption
10.7 MySQL in a chrooted Environment
Appendix A. The SHOW STATUS and SHOW INNODB STATUS Commands
A.1 SHOW STATUS
A.2 SHOW INNODB STATUS
Appendix B. mytop
B.1 Overview
B.2 Getting mytop
B.3 Configuration and Usage
B.4 Common Tasks
Appendix C. phpMyAdmin
C.1 The Basics
C.2 Practical Examples
Colophon
Index
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X