MySQL Administrators Guide and Language Reference (2nd Edition)
MySQL Administrators Guide and Language Reference (2nd Edition)
ISBN: 0672328704
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 141
Pages: 141
Authors: MySQL AB
- MySQL Administrator s Guide and Language Reference
- Table of Contents
- Copyright
- Preface
- Preface
- 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
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
MySQL Administrators Guide and Language Reference (2nd Edition)
ISBN: 0672328704
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 141
Pages: 141
Authors: MySQL AB