MySQL Troubleshooting

Preface
Foreword

1. Basics
-Incorrect Syntax
-Wrong Results from a SELECT
-When the Problem May Have Been a Previous Update
-Getting Information About a Query
-Tracing Back Errors in Data
-Slow Queries
-When the Server Does Not Answer
-Issues with Solutions Specific to Storage Engines
-Permission Issues

2. You Are Not Alone: Concurrency Issues
-Locks and Transactions
-Locks
-Transactions
-Metadata Locking
-How Concurrency Affects Performance
-Other Locking Issues
-Replication and Concurrency
-Effectively Using MySQL Troubleshooting Tools

3. Effects of Server Options
-Service Options
-Variables That Are Supposed to Change the Server Behavior
-Options That Limit Hardware Resources
-Using the --no-defaults Option
-Performance Options
-Haste Makes Waste
-The SET Statement
-How to Check Whether Changes Had an Effect
-Descriptions of Variables

4. MySQL's Environment
-Physical Hardware Limits
-Operating System Limits
-Effects of Other Software

5. Troubleshooting Replication
-Displaying Slave Status
-Problems with the I/O Thread
-Problems with the SQL Thread

6. Troubleshooting Techniques and Tools
-The Query
-Effects of the Environment
-Sandboxes
-Errors and Logs
-Information-Gathering Tools
-Localizing the Problem (Minimizing the Test Case)
-General Steps to Take in Troubleshooting
-Testing Methods
-Special Testing Tools
-Maintenance Tools

7. Best Practices
-Backups
-Gathering the Information You Need
-Testing
-Prevention
-Think About It!

Appendix: Information Resources

Index