High Performance MySQL (2012)

High Performance MySQL (2012)

Foreword

Preface

Chapter 1. MySQL Architecture and History

Chapter 2. Benchmarking MySQL

Chapter 3. Profiling Server Performance

Chapter 4. Optimizing Schema and Data Types

Chapter 5. Indexing for High Performance

Chapter 6. Query Performance Optimization

Chapter 7. Advanced MySQL Features

Chapter 8. Optimizing Server Settings

Chapter 9. Operating System and Hardware Optimization

Chapter 10. Replication

Chapter 11. Scaling MySQL

Chapter 12. High Availability

Chapter 13. MySQL in the Cloud

Chapter 14. Application-Level Optimization

Chapter 15. Backup and Recovery

Chapter 16. Tools for MySQL Users

Appendix A. Forks and Variants of MySQL

Appendix B. MySQL Server Status

Appendix C. Transferring Large Files

Appendix D. Using EXPLAIN

Appendix E. Debugging Locks

Appendix F. Using Sphinx with MySQL