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

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 I/O

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

index_Z