| | Copyright |
| | |
| | |
| | Chapter 1. General Information |
| | | Section 1.1. About This Manual |
| | | Section 1.2. Conventions Used in This Manual |
| | | Section 1.3. Overview of MySQL AB |
| | | Section 1.4. Overview of the MySQL Database Management System |
| | | Section 1.5. Overview of the MaxDB Database Management System |
| | | Section 1.6. MySQL Development Roadmap |
| | | Section 1.7. MySQL Information Sources |
| | | Section 1.8. How to Report Bugs or Problems |
| | | Section 1.9. MySQL Standards Compliance |
| | Chapter 2. Installing and Upgrading MySQL |
| | | Section 2.1. General Installation Issues |
| | | Section 2.2. Standard MySQL Installation Using a Binary Distribution |
| | | Section 2.3. Installing MySQL on Windows |
| | | Section 2.4. Installing MySQL on Linux |
| | | Section 2.5. Installing MySQL on Mac OS X |
| | | Section 2.6. Installing MySQL on NetWare |
| | | Section 2.7. Installing MySQL on Other Unix-Like Systems |
| | | Section 2.8. MySQL Installation Using a Source Distribution |
| | | Section 2.9. Post-Installation Setup and Testing |
| | | Section 2.10. Upgrading MySQL |
| | | Section 2.11. Downgrading MySQL |
| | | Section 2.12. Operating SystemSpecific Notes |
| | | Section 2.13. Perl Installation Notes |
| | Chapter 3. Using MySQL Programs |
| | | Section 3.1. Overview of MySQL Programs |
| | | Section 3.2. Invoking MySQL Programs |
| | | Section 3.3. Specifying Program Options |
| | Chapter 4. Database Administration |
| | | Section 4.1. Overview of Server-Side Programs |
| | | Section 4.2. mysqldThe MySQL Server |
| | | Section 4.3. The mysqld-max Extended MySQL Server |
| | | Section 4.4. MySQL Server Startup Programs |
| | | Section 4.5. mysqlmanagerThe MySQL Instance Manager |
| | | Section 4.6. Installation-Related Programs |
| | | Section 4.7. General Security Issues |
| | | Section 4.8. The MySQL Access Privilege System |
| | | Section 4.9. MySQL User Account Management |
| | | Section 4.10. Backup and Recovery |
| | | Section 4.11. MySQL Localization and International Usage |
| | | Section 4.12. MySQL Server Logs |
| | | Section 4.13. Running Multiple MySQL Servers on the Same Machine |
| | | Section 4.14. The MySQL Query Cache |
| | Chapter 5. Replication |
| | | Section 5.1. Introduction to Replication |
| | | Section 5.2. Replication Implementation Overview |
| | | Section 5.3. Row-Based Replication |
| | | Section 5.4. Replication Implementation Details |
| | | Section 5.5. How to Set Up Replication |
| | | Section 5.6. Replication Compatibility Between MySQL Versions |
| | | Section 5.7. Upgrading a Replication Setup |
| | | Section 5.8. Replication Features and Known Problems |
| | | Section 5.9. Replication Startup Options |
| | | Section 5.10. How Servers Evaluate Replication Rules |
| | | Section 5.11. Replication FAQ |
| | | Section 5.12. Comparison of Statement-Based Versus Row-Based Replication |
| | | Section 5.13. Troubleshooting Replication |
| | | Section 5.14. How to Report Replication Bugs or Problems |
| | | Section 5.15. Auto-Increment in Multiple-Master Replication |
| | Chapter 6. Optimization |
| | | Section 6.1. Optimization Overview |
| | | Section 6.2. Optimizing SELECT and Other Statements |
| | | Section 6.3. Locking Issues |
| | | Section 6.4. Optimizing Database Structure |
| | | Section 6.5. Optimizing the MySQL Server |
| | | Section 6.6. Disk Issues |
| | Chapter 7. Client and Utility Programs |
| | | Section 7.1. Overview of Client and Utility Programs |
| | | Section 7.2. myisamchkMyISAM Table-Maintenance Utility |
| | | Section 7.3. myisamlogDisplay MyISAM Log File Contents |
| | | Section 7.4. myisampackGenerate Compressed, Read-Only MyISAM Tables |
| | | Section 7.5. mysqlThe MySQL Command-Line Tool |
| | | Section 7.6. mysqlaccessClient for Checking Access Privileges |
| | | Section 7.7. mysqladminClient for Administering a MySQL Server |
| | | Section 7.8. mysqlbinlogUtility for Processing Binary Log Files |
| | | Section 7.9. mysqlcheckA Table Maintenance and Repair Program |
| | | Section 7.10. mysqldumpA Database Backup Program |
| | | Section 7.11. mysqlhotcopyA Database Backup Program |
| | | Section 7.12. mysqlimportA Data Import Program |
| | | Section 7.13. mysqlshowDisplay Database, Table, and Column Information |
| | | Section 7.14. mysql_zapKill Processes That Match a Pattern |
| | | Section 7.15. perrorExplain Error Codes |
| | | Section 7.16. replaceA String-Replacement Utility |
| | Chapter 8. Storage Engines and Table Types |
| | | Section 8.1. The MyISAM Storage Engine |
| | | Section 8.2. The InnoDB Storage Engine |
| | | Section 8.3. The MERGE Storage Engine |
| | | Section 8.4. The MEMORY (HEAP) Storage Engine |
| | | Section 8.5. The BDB (BerkeleyDB) Storage Engine |
| | | Section 8.6. The EXAMPLE Storage Engine |
| | | Section 8.7. The FEDERATED Storage Engine |
| | | Section 8.8. The ARCHIVE Storage Engine |
| | | Section 8.9. The CSV Storage Engine |
| | | Section 8.10. The BLACKHOLE Storage Engine |
| | Chapter 9. MySQL Cluster |
| | | Section 9.1. MySQL Cluster Overview |
| | | Section 9.2. Basic MySQL Cluster Concepts |
| | | Section 9.3. Simple Multi-Computer How-To |
| | | Section 9.4. MySQL Cluster Configuration |
| | | Section 9.5. Process Management in MySQL Cluster |
| | | Section 9.6. Management of MySQL Cluster |
| | | Section 9.7. MySQL Cluster Replication |
| | | Section 9.8. Using High-Speed Interconnects with MySQL Cluster |
| | | Section 9.9. Known Limitations of MySQL Cluster |
| | | Section 9.10. MySQL Cluster Development Roadmap |
| | | Section 9.11. MySQL Cluster FAQ |
| | | Section 9.12. MySQL Cluster Glossary |
| | Index |