MySQL AB MySQL Administrator[ap]s Guide
![MySQL AB MySQL Administrator[ap]s Guide](/icons/blank_book.jpg "MySQL AB MySQL Administrator[ap]s Guide"){kind=icon}
- MySQL Administrator s Guide
- Table of Contents
- Copyright
- About this Book
- We Want to Hear from You
- Chapter 1. General Information
- 1.1 About This Guide
- 1.2 Overview of the MySQL Database Management System
- 1.3 Overview of MySQL AB
- 1.4 MySQL Support and Licensing
- 1.5 MySQL Development Roadmap
- 1.6 MySQL and the Future (the TODO)
- 1.7 MySQL Information Sources
- 1.8 MySQL Standards Compliance
- Chapter 2. Installing MySQL
- 2.1 General Installation Issues
- 2.2 Standard MySQL Installation Using a Binary Distribution
- 2.3 MySQL Installation Using a Source Distribution
- 2.4 Post-Installation Setup and Testing
- 2.5 UpgradingDowngrading MySQL
- 2.6 Operating SystemSpecific Notes
- 2.7 Perl Installation Notes
- Chapter 3. Using MySQL Programs
- 3.1 Overview of MySQL Programs
- 3.2 Invoking MySQL Programs
- 3.3 Specifying Program Options
- Chapter 4. Database Administration
- 4.1 The MySQL Server and Server Startup Scripts
- 4.2 Configuring the MySQL Server
- 4.3 General Security Issues
- 4.4 The MySQL Access Privilege System
- 4.5 MySQL User Account Management
- 4.6 Disaster Prevention and Recovery
- 4.7 MySQL Localization and International Usage
- 4.8 The MySQL Log Files
- 4.9 Running Multiple MySQL Servers on the Same Machine
- 4.10 The MySQL Query Cache
- Chapter 5. Replication in MySQL
- 5.1 Introduction to Replication
- 5.2 Replication Implementation Overview
- 5.3 Replication Implementation Details
- 5.4 How to Set Up Replication
- 5.5 Replication Compatibility Between MySQL Versions
- 5.6 Upgrading a Replication Setup
- 5.7 Replication Features and Known Problems
- 5.8 Replication Startup Options
- 5.9 Replication FAQ
- 5.10 Troubleshooting Replication
- 5.11 Reporting Replication Bugs
- Chapter 6. MySQL Optimization
- 6.1 Optimization Overview
- 6.2 Optimizing SELECT Statements and Other Queries
- 6.3 Locking Issues
- 6.4 Optimizing Database Structure
- 6.5 Optimizing the MySQL Server
- 6.6 Disk Issues
- Chapter 7. MySQL Client and Utility Programs
- 7.1 Overview of the Client-Side Scripts and Utilities
- 7.2 myisampack, the MySQL Compressed Read-Only Table Generator
- 7.3 mysql, the Command-Line Tool
- 7.4 mysqladmin, Administering a MySQL Server
- 7.5 The mysqlbinlog Binary Log Utility
- 7.6 mysqlcc, the MySQL Control Center
- 7.7 The mysqlcheck Table Maintenance and Repair Program
- 7.8 The mysqldump Database Backup Program
- 7.9 The mysqlhotcopy Database Backup Program
- 7.10 The mysqlimport Data Import Program
- 7.11 mysqlshow, Showing Databases, Tables, and Columns
- 7.12 perror, Explaining Error Codes
- 7.13 The replace String-Replacement Utility
- Chapter 8. MySQL Storage Engines and Table Types
- 8.1 The MyISAM Storage Engine
- 8.2 The MERGE Storage Engine
- 8.3 The MEMORY (HEAP) Storage Engine
- 8.4 The BDB (BerkeleyDB) Storage Engine
- 8.5 The ISAM Storage Engine
- Chapter 9. The InnoDB Storage Engine
- 9.1 InnoDB Overview
- 9.2 InnoDB Contact Information
- 9.3 InnoDB in MySQL 3.23
- 9.4 InnoDB Configuration
- 9.5 InnoDB Startup Options
- 9.6 Creating the InnoDB Tablespace
- 9.7 Creating InnoDB Tables
- 9.8 Adding and Removing InnoDB Data and Log Files
- 9.9 Backing Up and Recovering an InnoDB Database
- 9.10 Moving an InnoDB Database to Another Machine
- 9.11 InnoDB Transaction Model and Locking
- 9.12 InnoDB Performance Tuning Tips
- 9.13 Implementation of Multi-Versioning
- 9.14 Table and Index Structures
- 9.15 File Space Management and Disk IO
- 9.16 Error Handling
- 9.17 Restrictions on InnoDB Tables
- 9.18 InnoDB Troubleshooting
- Chapter 10. Introduction to MaxDB
- 10.1 History of MaxDB
- 10.2 Licensing and Support
- 10.3 MaxDB-Related Links
- 10.4 Basic Concepts of MaxDB
- 10.5 Feature Differences Between MaxDB and MySQL
- 10.6 Interoperability Features Between MaxDB and MySQL
- 10.7 Reserved Words in MaxDB
- Appendix A. Troubleshooting Problems with MySQL Programs
- A.1 How to Determine What Is Causing a Problem
- A.2 Common Errors When Using MySQL Programs
- A.3 Installation-Related Issues
- A.4 Administration-Related Issues
- Appendix B. Environment Variables
- Index
- index_SYMBOL
- index_A
- index_B
- index_C
- index_D
- index_E
- index_F
- index_G
- index_H
- index_I
- index_J
- index_K
- index_L
- index_M
- index_N
- index_O
- index_P
- index_Q
- index_R
- index_S
- index_T
- index_U
- index_V
- index_W
- index_X
- index_Y