6.4 Optimizing Database Structure
6.5 Optimizing the MySQL Server
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.3 The MEMORY (HEAP) Storage Engine
8.4 The BDB (BerkeleyDB) Storage Engine
Chapter 9. The InnoDB Storage Engine
9.2 InnoDB Contact Information
9.6 Creating the InnoDB Tablespace
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 I/O
9.17 Restrictions on InnoDB Tables
Chapter 10. Introduction to MaxDB
10.5 Feature Differences Between MaxDB and MySQL
10.6 Interoperability Features Between MaxDB and MySQL
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