MySQL® Administrator's Guide and Language Reference
By
MySQL AB
...............................................
Publisher:
MySQL Press
Pub Date:
April 27, 2006
Print ISBN-10:
0-672-32870-4
Print ISBN-13:
978-0-672-32870-1
Pages:
888
Table of Contents
|
Index
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