MySQL® Administrator’s Bible

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