Introduction .xxvii Part I First Steps with MySQL Chapter 1: Introduction to MySQL 3 Chapter 2: Installing and Upgrading MySQL Server .9 Chapter 3: Accessing MySQL 49 Part II Developing with MySQL Chapter 4: How MySQL Extends and Deviates from SQL 87 Chapter 5: MySQL Data Types .159 Chapter 6: MySQL Index Types .219 Chapter 7: Stored Routines, Triggers, and Events .241 Chapter 8: MySQL Views 301 Chapter 9: Transactions in MySQL 319 Part III Core MySQL Administration Chapter 10: MySQL Server Tuning 349 Chapter 11: Storage Engines .375 Chapter 12: Caching with MySQL .423 Chapter 13: Backups and Recovery 439 Chapter 14: User Management .473 Chapter 15: Partitioning 495 Chapter 16: Logging and Replication .517 Chapter 17: Measuring Performance 545 Part IV Extending Your Skills Chapter 18: Query Analysis and Index Tuning .589 Chapter 19: Monitoring Your Systems .633 Chapter 20: Securing MySQL .649 Chapter 21: The MySQL Data Dictionary 667 Chapter 22: Scaling and High Availability Architectures .727 Appendix A: MySQL Proxy .749 Appendix B: Functions and Operators .783 Appendix C: Resources .813 Index 821