1. Introduction.

   1.1  History of MySQL

   1.2  The Main Features of MySQL

   1.3  Architecture of MySQL

2. MySQL Installation.

    2.1  RPM  Installation

    2.2  Generic Binaries  Installation

    2.3  Source Code  Installation

3. Initialization of MySQL Related Programs.

    3.1  mysql_install_db ― Initialize MySQL Data Directory

    3.2  mysql_secure_installation ― Improve MySQL Installation Security

    3.3  mysql_tzinfo_to_sql ― Load the Time Zone Tables

4. MySQL Server-Startup Scripts.

            4.1  mysqld_safe ― MySQL Server Startup Script

            4.2  mysql.server ― MySQL Server Startup Script

            4.3  mysqld ― The MySQL Server

            4.3 mysqld_multi ― Manage Multiple MySQL Servers

5. MySQL User Account Management.

    5.5.1 User Names and Passwords

    5.5.2 Adding User Accounts

    5.5.3 Removing User Accounts

    5.5.4 Setting Account Resource Limits

    5.5.5 Assigning Account Passwords

6. MySQL Storage Engines.

    6.1  MyISAM Storage Engine

    6.2  InnoDB Storage Engine

    6.3  MERGE Storage Engine

    6.4  MEMORY Storage Engine

    6.5  EXAMPLE Storage Engine

    6.6  FEDERATED Storage Engine

    6.7  ARCHIVE Storage Engine

    6.8  CSV Storage Engine

    6.9  BLACKHOLE Storage Engine

7. MySQL Clients.

    7.1  mysql ― The MySQL Command-Line Tool

    7.2  mysqladmin ― Client for Administering a MySQL Server

    7.3  mysqlcheck ― A Table Maintenance Program

    7.4  mysqldump ― A Database Backup Program

    7.5  mysqlimport ― A Data Import Program

    7.6  mysqlshow ― Display Database, Table, and Column Information

    7.7  mysqlslap ― Load Emulation Client

8. MySQL Administrative and Utilities.

    8.1  myisamchk ― MyISAM Table-Maintenance Utility

    8.2  myisampack ― Generate Compressed, Read-Only MyISAM Tables

    8.3  mysqlaccess ― Client for Checking Access Privileges

    8.4  mysqlbinlog ― Utility for Processing Binary Log Files

    8.5  mysqlhotcopy ― A Database Backup Program

    8.6  mysql_convert_table_format ― Convert Tables to Use a Given Storage Engine

9. MySQL Server Administration.

    9.1  Server System Variables

    9.2  Server Status Variables

    9.3  Server SQL Modes

10. MySQL Server Logs.

    10.1  Error Log

    10.2  General Query Log

    10.3  Binary Log

    10.4  Slow Query Log

11. Backup and Recovery.

    11.1  Backup and Recovery Types

    11.2  Database Backup Methods

    11.3  Using mysqldump for Backups

             11.3.1  Dumping Data in SQL Format

             11.3.2  Dumping Data in Delimited-Text Format

             11.3.3  Reloading SQL-Format Backups

             11.3.4  Backing Up and Recovering an InnoDB Database

    11.4 Incremental Backups

12. Running Multiple MySQL Instances on One Machine.

    12.1  Setting Up Multiple Data Directories

    12.2  Running Multiple MySQL Instances on Unix

    12.3  Using mysqld_multi for Managing Multiple MySQL Servers

13. Optimization.

    13.1  Optimization Overview

    13.2  Query Execution Plan Information

              13.2.1  Optimizing Queries with EXPLAIN

              13.2.2  Optimizing SELECT Statements

    13.3  Tuning Server Parameters

14. MySQL Partitions.

    14.1  Partitioning Types

             14.1.1  RANGE Partition

             14.1.2  LIST Partition

             14.1.3  HASH Partition

             14.1.4  KEY Partition

             14.1.5  Sub partition

   14.2  Restrictions and Limitations on Partitions

15. INFORMATION_SCHEMA Tables.

15.1    INFORMATION_SCHEMA TABLES Table

15.2    INFORMATION_SCHEMA COLUMNS Table

15.3    INFORMATION_SCHEMA VIEWS Table

15.4    INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

15.5    INFORMATION_SCHEMA ROUTINES Table

15.6    INFORMATION_SCHEMA TRIGGERS Table

15.7    INFORMATION_SCHEMA STATISTICS Table

15.8    INFORMATION_SCHEMA USER_PRIVILEGES Table

15.9    INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table

15.10  INFORMATION_SCHEMA TABLE_PRIVILEGES Table

15.11  INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

15.12  INFORMATION_SCHEMA CHARACTER_SETS Table

15.13  INFORMATION_SCHEMA COLLATIONS Table

15.14  INFORMATION_SCHEMA PROFILING Table

16. Buffering and Caching.

    16.1  MyISAM Key Cache

    16.2  InnoDB Buffer Pool

    16.3  MySQL Query Cache

17. Locking Issues.

    17.1  Internal Locking Methods

    17.2  Table Locking Issues

    17.3  Concurrent Inserts

    17.4  External Locking

18. High Availability and Scalability.

    18.1 Replication

            18.1.1  Replication Configuration

            18.1.2  Replication Formats

            18.1.3  Replication and Binary Logging Options and Variables