MySQL Administrators Guide [Electronic resources] نسخه متنی

• 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 SystemSpecific 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