SitemapTable of ContentsCopyrightAbout this BookWe Want to Hear from You!Chapter 1. General Information1.1 About This Guide1.2 Overview of the MySQL Database Management System1.3 Overview of MySQL AB1.4 MySQL Support and Licensing1.5 MySQL Development Roadmap1.6 MySQL and the Future (the TODO)1.7 MySQL Information Sources1.8 MySQL Standards ComplianceChapter 2. Installing MySQL2.1 General Installation Issues2.2 Standard MySQL Installation Using a Binary Distribution2.3 MySQL Installation Using a Source Distribution2.4 Post-Installation Setup and Testing2.5 Upgrading/Downgrading MySQL2.6 Operating SystemSpecific Notes2.7 Perl Installation NotesChapter 3. Using MySQL Programs3.1 Overview of MySQL Programs3.2 Invoking MySQL Programs3.3 Specifying Program OptionsChapter 4. Database Administration4.1 The MySQL Server and Server Startup Scripts4.2 Configuring the MySQL Server4.3 General Security Issues4.4 The MySQL Access Privilege System4.5 MySQL User Account Management4.6 Disaster Prevention and Recovery4.7 MySQL Localization and International Usage4.8 The MySQL Log Files4.9 Running Multiple MySQL Servers on the Same Machine4.10 The MySQL Query CacheChapter 5. Replication in MySQL5.1 Introduction to Replication5.2 Replication Implementation Overview5.3 Replication Implementation Details5.4 How to Set Up Replication5.5 Replication Compatibility Between MySQL Versions5.6 Upgrading a Replication Setup5.7 Replication Features and Known Problems5.8 Replication Startup Options5.9 Replication FAQ5.10 Troubleshooting Replication5.11 Reporting Replication BugsChapter 6. MySQL Optimization6.1 Optimization Overview6.2 Optimizing SELECT Statements and Other Queries