Chapter 5. MySQL Server Administration

Table of Contents

5.1. The MySQL Server

5.1.1. Server Option and Variable Reference

5.1.2. Server Configuration Defaults

5.1.3. Server Command Options

5.1.4. Server System Variables

5.1.5. Using System Variables

5.1.6. Server Status Variables

5.1.7. Server SQL Modes

5.1.8. Server Plugins

5.1.9. IPv6 Support

5.1.10. Server-Side Help

5.1.11. Server Response to Signals

5.1.12. The Shutdown Process

5.2. MySQL Server Logs

5.2.1. Selecting General Query and Slow Query Log Output Destinations

5.2.2. The Error Log

5.2.3. The General Query Log

5.2.4. The Binary Log

5.2.5. The Slow Query Log

5.2.6. Server Log Maintenance

5.3. Managing Disk I/O and File Space for InnoDB Tables

5.3.1. InnoDB Disk I/O

5.3.2. File Space Management

5.3.3. InnoDB Checkpoints

5.3.4. Defragmenting a Table

5.4. Creating and Using InnoDB Tables and Indexes

5.4.1. Managing InnoDB Tablespaces

5.4.2. Grouping DML Operations with Transactions

5.4.3. Converting Tables from MyISAM toInnoDB

5.4.4. AUTO_INCREMENT Handling in InnoDB

5.4.5. InnoDB and FOREIGN KEY Constraints

5.4.6. Working with InnoDB Compressed Tables

5.4.7. InnoDB File-Format Management

5.4.8. How InnoDB Stores Variable-Length Columns

5.5. Online DDL for InnoDB Tables

5.5.1. Overview of Online DDL

5.5.2. Performance and Concurrency Considerations for Online DDL

5.5.3. SQL Syntax for Online DDL

5.5.4. Combining or Separating DDL Statements

5.5.5. Examples of Online DDL

5.5.6. Implementation Details of Online DDL

5.5.7. How Crash Recovery Works with Online DDL

5.5.8. DDL for Partitioned Tables

5.5.9. Limitations of Online DDL

5.6. Running Multiple MySQL Instances on One Machine

5.6.1. Setting Up Multiple Data Directories

5.6.2. Running Multiple MySQL Instances on Windows

5.6.3. Running Multiple MySQL Instances on Unix

5.6.4. Using Client Programs in a Multiple-Server Environment

5.7. Tracing mysqld Using DTrace

5.7.1. mysqld DTrace Probe Reference