Table of Contents

¢	Table of Contents
¢	Index

 

MySQL Administrator's Guide
By  MySQL AB
Publisher	: Sams Publishing
Pub Date	: July 03, 2004
ISBN	: 0-672-32634-5
Pages	: 400

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