MySQL® Administrator's Bible -- About the Authors -- Credits -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Who Should Read This Book -- How This Book Is Organized -- What's on the Companion Website -- Where To Go From Here -- Part I: First Steps with MySQL -- Chapter 1: Introduction to MySQL -- MySQL Mission-Speed, Reliability, and Ease of Use -- The MySQL Community -- Summary -- Chapter 2: Installing and Upgrading MySQL Server -- Before Installation -- Installation -- Initial Configuration -- MySQL Configuration Wizard on Windows -- MySQL Post-Install Configuration on Unix -- Securing Your System -- Windows PATH Variable Configuration -- Upgrading mysqld -- Troubleshooting -- Summary -- Chapter 3: Accessing MySQL -- Accessing mysqld with Command-Line Tools -- GUI Tools -- Summary -- Part II: Developing with MySQL -- Chapter 4: How MySQL Extends and Deviates from SQL -- Learning MySQL Language Structure -- Understanding MySQL Deviations -- Using MySQL Extensions -- Summary -- Chapter 5: MySQL Data Types -- Looking at MySQL Data Types -- Character String Types -- National Character String Types -- Binary Large Object String Types -- Numeric Types -- Boolean Types -- Datetime Types -- Interval Types -- ENUM and SET Types -- Choosing SQL Modes -- Using NULL Values -- Finding an Optimal Data Type for Existing Data -- Summary -- Chapter 6: MySQL Index Types -- Looking at Keys and Indexes -- Using Indexes to Speed Up Lookups -- Creating and Dropping Key Constraints -- Using FULLTEXT Indexes -- Summary -- Chapter 7: Stored Routines, Triggers, and Events -- Comparing Stored Routines, Triggers, and Events -- Using Triggers -- Using Stored Routines -- Using Cursors -- Using Events -- Summary -- Chapter 8: MySQL Views -- Defining Views -- Changing a View Definition -- Replication and Views -- Summary.

Chapter 9: Transactions in MySQL -- Understanding ACID Compliance -- Using Transactional Statements -- Using Isolation Levels -- Explaining Locking and Deadlocks -- Recovering MySQL Transactions -- Summary -- Part III: Core MySQL Administration -- Chapter 10: MySQL Server Tuning -- Choosing Optimal Hardware -- Tuning the Operating System -- Tuning MySQL Server -- SUMMARY -- Chapter 11: Storage Engines -- Understanding Storage Engines -- Using Different Storage Engines -- Working with Storage Engines -- Summary -- Chapter 12: Caching with MySQL -- Implementing Cache Tables -- Working with the Query Cache -- Utilizing memcached -- Summary -- Chapter 13: Backups and Recovery -- Backing Up MySQL -- Copying Databases to Another Machine -- Recovering from Crashes -- Planning for Disasters -- Summary -- Chapter 14: User Management -- Learning about MySQL Users -- Managing User Accounts -- Resetting the Root Password -- Debugging User Account Problems -- Summary -- Chapter 15: Partitioning -- Learning about Partitioning -- Partitioning Tables -- MERGE Tables -- Partitioning with MySQL Cluster -- Programmatic Partitioning -- Summary -- Chapter 16: Logging and Replication -- Log Files -- Replication -- Replication Configurations -- Correcting Data Drift -- Summary -- Chapter 17: Measuring Performance -- Benchmarking -- Profiling -- Capacity Planning -- Summary -- Part IV: Extending Your Skills -- Chapter 18: Query Analysis and Index Tuning -- Using EXPLAIN -- EXPLAIN on Non-SELECT Statements -- Other Query Analysis Tools -- Optimizing Queries -- Summary -- Chapter 19: Monitoring Your Systems -- Deciding What to Monitor -- Examining Open Source Monitoring -- Examining Commercial Monitoring -- Summary -- Chapter 20: Securing MySQL -- Access Control Lists -- Accessing the Operating System -- Securing Backups and Logs -- Data Security -- Creating Security Policies.

Summary -- Chapter 21: The MySQL Data Dictionary -- Object Catalog -- System Information -- Displaying Permissions -- Storage Engine-Specific Metadata -- Custom Metadata -- Summary -- Chapter 22: Scaling and High Availability Architectures -- Replication -- SAN -- DRBD -- MySQL Proxy -- Linux-HA Heartbeat -- MySQL Cluster -- Connection Pooling -- memcached -- Summary -- Appendix A: MySQL Proxy -- Understanding MySQL Proxy -- Learning Lua Basics -- Changing the Query Backend -- Changing and Injecting Queries -- Understanding MySQL Proxy Internals -- Summary -- Appendix B: Functions and Operators -- Using Aggregation Functions -- Using Bitwise Operators -- Compressing and Encrypting Data -- Testing, Logic, and Control Flow -- Using Server-Level Functions -- Working with Data Types -- Appendix C: Resources -- Finding Paid Support -- Asking Questions -- Sharing Solutions -- Getting Documentation -- Learning More -- Index.