MySQL 实验室 因为专注,所以专业。

  • 首页
  • 博客
  • 下载
  • 文档
  • 工具
  • 知识库
  • 培训及服务
  • MySQL 5.1 Reference Manual :: Option Index
    • MySQL 5.1 Reference Manual
    • Preface, Notes, Licenses
    • 1 General Information
    • 2 Installing and Upgrading MySQL
    • 3 Tutorial
    • 4 MySQL Programs
    • 5 MySQL Server Administration
    • 6 Backup and Recovery
    • 7 Optimization
    • 8 Language Structure
    • 9 Internationalization and Localization
    • 10 Data Types
    • 11 Functions and Operators
    • 12 SQL Statement Syntax
    • 13 Storage Engines
    • 14 High Availability and Scalability
    • 15 MySQL Enterprise Monitor
    • 16 Replication
    • 17 MySQL Cluster NDB 6.X/7.X
    • 18 Partitioning
    • 19 Stored Programs and Views
    • 20 INFORMATION_SCHEMA Tables
    • 21 Connectors and APIs
    • 22 Extending MySQL
    • A MySQL 5.1 Frequently Asked Questions
    • B Errors, Error Codes, and Common Problems
    • C MySQL Change History
    • D Restrictions and Limits
    • Index
    • Standard Index
    • C Function Index
    • Command Index
    • Function Index
    • INFORMATION_SCHEMA Index
    • Transaction Isolation Level Index
    • JOIN Types Index
    • Operator Index
    • Option Index
    • Privileges Index
    • SQL Modes Index
    • Status Variable Index
    • Statement/Syntax Index
    • System Variable Index

    Option Index

    -

    Section 12.1.1, “ALTER DATABASE Syntax”
    Section 12.4.1.3, “GRANT Syntax”
    Section 11.5.1, “Arithmetic Operators”
    Section 11.8.2, “Boolean Full-Text Searches”
    Section 10.6, “Choosing the Right Type for a Column”
    Section 11.6, “Date and Time Functions”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 8.1.2, “Numbers”
    Section 10.2, “Numeric Types”
    Section 10.1.1, “Overview of Numeric Types”
    Section 11.4.2, “Regular Expressions”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 5.4.3, “Specifying Account Names”
    Section 4.2.3.1, “Using Options on the Command Line”

    -#

    Section 22.5.3, “The DBUG Package”

    -# [debug_options]

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    -# [debug_options]

    Section 5.1.2, “Server Command Options”

    -# debug_options

    Section 4.6.3.1, “myisamchk General Options”
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    -#...

    Section 22.5.3, “The DBUG Package”

    -#D,20

    Section 22.5.3, “The DBUG Package”

    -#debug_options

    Description

    --

    Section 1.8.5.5, “'--' as the Start of a Comment”
    Description

    --HELP

    Section 4.6.3.1, “myisamchk General Options”

    --Information

    Description

    --abort-slave-event-count

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --add-drop-database

    Description
    Section 6.4.1, “Dumping Data in SQL Format with mysqldump”

    --add-drop-table

    Description

    --add-locks

    Description

    --add-user

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --addtodest

    Description

    --all

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --all-databases

    Description
    Description
    Description
    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
    Section 8.2.3, “Mapping of Identifiers to File Names”
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 6.4.2, “Reloading SQL-Format Backups”

    --all-in-1

    Description

    --all-tablespaces

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --allow-keywords

    Description

    --allow-suspicious-udfs

    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 22.3.2.6, “User-Defined Function Security Precautions”

    --allowold

    Description

    --analyze

    Section 4.6.3.1, “myisamchk General Options”
    Section 6.6.4, “MyISAM Table Optimization”
    Description
    Section 4.6.3.4, “Other myisamchk Options”

    --angel-pid-file

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --angel-pid-file=file_name

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --ansi

    Section 1.8.3, “Running MySQL in ANSI Mode”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --apply-slave-statements

    Description

    --auto-generate-sql

    Description

    --auto-generate-sql-add-autoincrement

    Description

    --auto-generate-sql-execute-number=N

    Description

    --auto-generate-sql-guid-primary

    Description

    --auto-generate-sql-load-type=type

    Description

    --auto-generate-sql-secondary-indexes=N

    Description

    --auto-generate-sql-select-columns=str

    Description

    --auto-generate-sql-unique-query-number=N

    Description

    --auto-generate-sql-unique-write-number=N

    Description

    --auto-generate-sql-write-number

    Description

    --auto-generate-sql-write-number=N

    Description

    --auto-rehash

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”

    --auto-repair

    Description

    --auto-vertical-output

    Section 4.5.1.1, “mysql Options”

    --autoclose

    Description

    --backup

    Section 4.6.3.3, “myisamchk Repair Options”
    Description

    --backup_history_log

    Section 5.1.2, “Server Command Options”

    --backup_progress_log

    Section 5.1.2, “Server Command Options”

    --base64-output

    Description

    --base64-output=DECODE-ROWS

    Section 4.6.7.2, “mysqlbinlog Row Event Display”

    --base64-output=NEVER

    Section 4.6.7.2, “mysqlbinlog Row Event Display”

    --base64-output[=value]

    Description

    --basedir

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Description
    Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.4, “Server System Variables”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 2.3.2, “Typical configure Options”
    Section 2.13.1, “Unix Post-Installation Procedures”

    --basedir=path

    Description
    Description
    Description
    Description
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”

    --batch

    Section 4.5.1.1, “mysql Options”

    --bdb-logdir

    Section 5.1.4, “Server System Variables”

    --bdb-logdir=file_name

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    --bdb-no-recover

    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”

    --bdb-shared-data

    Section 5.1.4, “Server System Variables”

    --bdb-tmpdir=path

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    --big-tables

    Section B.5.2.12, “The table is full”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 5.1.2, “Server Command Options”

    --bind-address

    Description
    Description
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    --bind-address=127.0.0.1

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.6.10.4, “Instance Manager User and Password Management”

    --bind-address=IP

    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.1.2, “Server Command Options”

    --binlog-do-db

    Section 16.1.3.4, “Binary Log Options and Variables”
    Description
    Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
    Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.2.4, “The Binary Log”

    --binlog-do-db=db1

    Section 16.1.3.4, “Binary Log Options and Variables”

    --binlog-do-db=db_name

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --binlog-do-db=mysql

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --binlog-do-db=sales

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”

    --binlog-format

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 17.6.2, “MySQL Cluster Replication: Assumptions and General Requirements”

    --binlog-format=MIXED

    Section 5.2.4.1, “Binary Logging Formats”
    Section 17.6.2, “MySQL Cluster Replication: Assumptions and General Requirements”
    Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
    Section 17.1.5.6, “Unsupported or Missing Features in MySQL Cluster”

    --binlog-format=ROW

    Section 5.2.4.1, “Binary Logging Formats”
    Section 17.6.2, “MySQL Cluster Replication: Assumptions and General Requirements”
    Section 17.1.5.6, “Unsupported or Missing Features in MySQL Cluster”

    --binlog-format=STATEMENT

    Section 5.2.4.1, “Binary Logging Formats”
    Section 17.6.2, “MySQL Cluster Replication: Assumptions and General Requirements”

    --binlog-format=type

    Section 5.2.4.2, “Setting The Binary Log Format”

    --binlog-format={ROW|STATEMENT|MIXED}

    Section 5.1.2, “Server Command Options”

    --binlog-ignore-db

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
    Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.2.4, “The Binary Log”

    --binlog-ignore-db=db_name

    Section 16.1.3.4, “Binary Log Options and Variables”

    --binlog-ignore-db=mysql

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --binlog-ignore-db=sales

    Section 16.1.3.4, “Binary Log Options and Variables”

    --binlog-row-event-max-size

    Section 5.2.4.2, “Setting The Binary Log Format”

    --binlog-row-event-max-size=N

    Section 16.1.3.4, “Binary Log Options and Variables”

    --blob-info

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

    --block-search=offset

    Section 4.6.3.4, “Other myisamchk Options”

    --bootstrap

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Description
    Section 5.1.2, “Server Command Options”
    Section 2.3.2, “Typical configure Options”

    --brief

    Description

    --build=x86_64-pc-solaris2.10

    Section 2.3, “MySQL Installation Using a Source Distribution”

    --burnin

    Description

    --cflags

    Description

    --character-set-client-handshake

    Section 5.1.2, “Server Command Options”
    Section 9.1.13.7.1, “The cp932 Character Set”

    --character-set-filesystem=charset_name

    Section 5.1.2, “Server Command Options”

    --character-set-server

    Section 9.5, “Character Set Configuration”
    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.4.1.2, “Replication and Character Sets”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 5.1.2, “Server Command Options”
    Section 8.4, “User-Defined Variables”

    --character-set-server=charset_name

    Section 5.1.2, “Server Command Options”

    --character-set-server=latin1

    Section 9.1.3.1, “Server Character Set and Collation”

    --character-sets-dir

    Section B.5.2.17, “Can't initialize character set”
    Section 9.5, “Character Set Configuration”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”

    --character-sets-dir=path

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.1.2, “Server Command Options”

    --charset=path

    Description

    --check

    Section 4.6.3.2, “myisamchk Check Options”
    Description

    --check-only-changed

    Section 4.6.3.2, “myisamchk Check Options”
    Description

    --check-password-file

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --check-upgrade

    Description
    Description

    --checkpoint

    Description

    --checkpoint=db_name.tbl_name

    Description

    --chroot

    Description

    --chroot=path

    Description
    Section 5.1.2, “Server Command Options”

    --clean-password-file

    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --collation-server

    Section 9.5, “Character Set Configuration”
    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.4.1.2, “Replication and Character Sets”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 5.1.2, “Server Command Options”

    --collation-server=collation_name

    Section 5.1.2, “Server Command Options”

    --collation-server=latin1_swedish_ci

    Section 9.1.3.1, “Server Character Set and Collation”

    --column-names

    Section 4.5.1.1, “mysql Options”
    Section 4.2.3.2, “Program Option Modifiers”

    --column-type-info

    Section 4.5.1.1, “mysql Options”

    --columns=column_list

    Description

    --comments

    Section 4.5.1.1, “mysql Options”
    Description

    --commit

    Description

    --commit=N

    Description

    --comp

    Section 4.2.3, “Specifying Program Options”

    --compact

    Description

    --compatible

    Description

    --compatible=name

    Description

    --compatible=oracle

    Description

    --complete-insert

    Description

    --compr

    Section 4.2.3, “Specifying Program Options”

    --compress

    Section 4.5.1.1, “mysql Options”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 5.5.6.1, “Basic SSL Concepts”
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.2.3, “Specifying Program Options”

    --concurrency=N

    Description

    --config-cache

    Section 17.3.2, “MySQL Cluster Configuration Files”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --config-file

    Description
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 1.5, “What Is New in MySQL 5.1”

    --config-file=file_name

    Description
    Description

    --config-file=path_name

    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”

    --configdir

    Section 17.3.2, “MySQL Cluster Configuration Files”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --configinfo

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --configinfo --xml

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --connect-string

    MySQL 4.1 FAQ: MySQL Cluster

    --console

    Section 13.6.13.3, “InnoDB General Troubleshooting”
    Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
    Section 13.6.2.3, “Creating the InnoDB Tablespace”
    Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
    Section 5.1.2, “Server Command Options”
    Section 2.5.5.4, “Starting the Server for the First Time”
    Section 5.2.2, “The Error Log”

    --copy

    Description

    --core-file

    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section 5.1.2, “Server Command Options”

    --core-file-size

    Section 5.1.2, “Server Command Options”

    --core-file-size=size

    Description

    --correct-checksum

    Section 4.6.3.3, “myisamchk Repair Options”

    --count

    Description
    Description
    Description

    --count=N

    Description

    --create

    Description

    --create-options

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --create-schema=value

    Description

    --create=value

    Description

    --csv[=file_name]

    Description

    --daemon

    Description

    --data-file-length=len

    Section 4.6.3.3, “myisamchk Repair Options”

    --database

    Description

    --database=db_name

    Section 4.5.1.1, “mysql Options”
    Description

    --databases

    Section 6.4.5.2, “Copy a Database from one Server to Another”
    Description
    Description
    Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
    Section 6.4.5.1, “Making a Copy of a Database”
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 6.4.2, “Reloading SQL-Format Backups”

    --datadir

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 2.5.5.2, “Creating an Option File”
    Description
    Description
    Section 5.1.4, “Server System Variables”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 2.3.2, “Typical configure Options”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 4.2.3.3, “Using Option Files”

    --datadir=path

    Description
    Description
    Description
    Description
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 5.1.2, “Server Command Options”

    --db=db_name

    Description

    --debug

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Description
    Description
    Description
    Section 5.1.4, “Server System Variables”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 22.5.3, “The DBUG Package”

    --debug-check

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    --debug-info

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    --debug-sync-timeout=N

    Section 5.1.4, “Server System Variables”
    Section 2.3.2, “Typical configure Options”

    --debug-sync-timeout[=N]

    Section 5.1.2, “Server Command Options”

    --debug="..."

    Section 22.5.3, “The DBUG Package”

    --debug="d,parser_debug"

    Section 5.1.2, “Server Command Options”
    Section 2.3.2, “Typical configure Options”

    --debug=+P

    Section 5.1.2, “Server Command Options”

    --debug=N

    Description

    --debug=T

    Section 5.1.2, “Server Command Options”

    --debug=d,general,query

    Section 5.4.7, “Causes of Access-Denied Errors”

    --debug=debug_options

    Section 4.6.3.1, “myisamchk General Options”
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --debug[=debug_options]

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.1.2, “Server Command Options”

    --default-character-set

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 9.1.4, “Connection Character Sets and Collations”
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 8.4, “User-Defined Variables”

    --default-character-set=charset_name

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Section 5.1.2, “Server Command Options”

    --default-character-set=system_character_set

    Section 9.5, “Character Set Configuration”

    --default-character-set=utf8

    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 4.5.1.4, “Executing SQL Statements from a Text File”

    --default-collation

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”

    --default-collation=collation_name

    Section 5.1.2, “Server Command Options”

    --default-mysqld-path=/usr/sbin/mysqld

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --default-mysqld-path=path

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --default-storage-engine

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 13.3, “Setting the Storage Engine”
    Chapter 13, Storage Engines

    --default-storage-engine=type

    Section 5.1.2, “Server Command Options”

    --default-table-type

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Chapter 13, Storage Engines

    --default-table-type=InnoDB

    Section 12.4.5.17, “SHOW ENGINES Syntax”

    --default-table-type=type

    Section 5.1.2, “Server Command Options”

    --default-time-zone

    Section 16.4.1.26, “Replication and Time Zones”
    Section 5.1.4, “Server System Variables”

    --default-time-zone=timezone

    Section 9.6, “MySQL Server Time Zone Support”
    Section 5.1.2, “Server Command Options”

    --default.key_buffer_size=256K

    Section 5.1.5.1, “Structured System Variables”

    --defaults-extra-file

    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Description
    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --defaults-extra-file=file_name

    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Description
    Description

    --defaults-extra-file=path

    Description
    Section 4.2.3.3, “Using Option Files”

    --defaults-file

    Section 13.6.2, “InnoDB Configuration”
    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 4.6.10.7, “MySQL Instance Manager Commands”
    Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
    Section 21.8.3, “Options with the Embedded Server”
    Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    --defaults-file=file_name

    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    --defaults-file=option_file_name

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --defaults-group-suffix

    Section 2.14, “Environment Variables”

    --defaults-group-suffix=_other

    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”

    --defaults-group-suffix=str

    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”

    --defaults-group-suffix=suffix

    Description

    --delay-key-write

    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    --delay-key-write-for-all-tables

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”

    --delay-key-write=ALL

    Section 13.5.1, “MyISAM Startup Options”
    Section 7.3.4, “External Locking”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.4.4, “Replication FAQ”
    Section 5.1.2, “Server Command Options”

    --delay-key-write=OFF

    Section 7.3.4, “External Locking”
    Section 5.1.2, “Server Command Options”

    --delay-key-write[={OFF|ON|ALL}]

    Section 5.1.2, “Server Command Options”

    --delay_key_write=1

    Section 5.1.4, “Server System Variables”
    Section 5.1.5, “Using System Variables”

    --delay_key_write=ON

    Section 5.1.4, “Server System Variables”
    Section 5.1.5, “Using System Variables”

    --delayed-insert

    Description

    --delayed-start=N

    Description

    --delete

    Description

    --delete-master-logs

    Description

    --delimiter

    Description

    --delimiter=str

    Section 4.5.1.1, “mysql Options”
    Description

    --demangle

    Section 22.5.1.5, “Using a Stack Trace”

    --des-key-file

    Section 12.4.6.3, “FLUSH Syntax”
    Section 11.11.2, “Encryption and Compression Functions”

    --des-key-file=file_name

    Section 5.1.2, “Server Command Options”

    --description

    Section 4.6.3.4, “Other myisamchk Options”

    --detach=N

    Description

    --disable

    Section 4.2.3.2, “Program Option Modifiers”

    --disable-auto-rehash

    Section 4.5.1.1, “mysql Options”

    --disable-community-features

    Section 2.3.2, “Typical configure Options”

    --disable-debug-sync

    Section 2.3.2, “Typical configure Options”

    --disable-dtrace

    Section 2.3.2, “Typical configure Options”

    --disable-grant-options

    Description
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.3.2, “Typical configure Options”

    --disable-keys

    Description

    --disable-log-bin

    Description

    --disable-named-commands

    Section 4.5.1.1, “mysql Options”

    --disable-plugin_name

    Section 5.1.3, “Server Options for Loading Plugins”

    --disable-profiling

    Section 2.3.2, “Typical configure Options”

    --disable-shared

    Section 2.3.2, “Typical configure Options”

    --disconnect-slave-event-count

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --drop-user

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --dryrun

    Description

    --dump

    Description

    --dump-date

    Description

    --dump-slave

    Description

    --dump-slave[=value]

    Description

    --edit-user

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --embedded

    Description
    Description

    --enable-community-features

    Section 2.3.2, “Typical configure Options”

    --enable-debug-sync

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.3.2, “Typical configure Options”

    --enable-dtrace

    Section 2.3.2, “Typical configure Options”

    --enable-local-infile

    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

    --enable-locking

    Section 7.3.4, “External Locking”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”

    --enable-named-pipe

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 4.2.2, “Connecting to the MySQL Server”
    Section 2.5.5.3, “Selecting a MySQL Server Type”
    Section 5.1.2, “Server Command Options”

    --enable-plugin_name

    Section 5.1.3, “Server Options for Loading Plugins”

    --enable-profiling

    Section 2.3.2, “Typical configure Options”

    --enable-pstack

    Section 5.1.2, “Server Command Options”

    --enable-thread-safe-client

    Section 2.3.2, “Typical configure Options”

    --engine-condition-pushdown

    Section 7.2.7, “Condition Pushdown Optimization”

    --engine-condition-pushdown=1

    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”

    --engine=engine_name

    Description

    --err-log=file_name

    Description
    Section 5.2.2, “The Error Log”

    --event-scheduler

    Section 5.1.2, “Server Command Options”

    --event-scheduler=DISABLED

    Section 5.1.2, “Server Command Options”

    --event-scheduler[=value]

    Section 5.1.2, “Server Command Options”

    --events

    Description
    Section 6.4.5.3, “Dumping Stored Programs”
    Section 6.4.5.4, “Dumping Table Definitions and Content Separately”

    --example

    Description

    --exclude-databases

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --exclude-missing-columns

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --exclude-tables

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --exe-suffix=suffix

    Description

    --execute

    Section 4.2.3.1, “Using Options on the Command Line”
    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    --execute=statement

    Section 4.5.1.1, “mysql Options”

    --exit-info[=flags]

    Section 5.1.2, “Server Command Options”

    --extend-check

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.3, “myisamchk Repair Options”

    --extended

    Description

    --extended-insert

    Description

    --external-locking

    Section 13.5.1, “MyISAM Startup Options”
    Section 7.3.4, “External Locking”
    Section 2.3.5, “MIT-pthreads Notes”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 7.5.2, “System Factors and Startup Parameter Tuning”

    --extra-file=file_name

    Description

    --extra-node-info

    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

    --extra-partition-info

    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

    --fast

    Section 4.6.3.2, “myisamchk Check Options”
    Description

    --federated

    Section 13.11, “The FEDERATED Storage Engine”

    --fields-enclosed-by

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --fields-enclosed-by=...

    Description
    Description

    --fields-enclosed-by=char

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --fields-escaped-by=...

    Description
    Description

    --fields-escaped-by=char

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --fields-optionally-enclosed-by=...

    Description
    Description

    --fields-optionally-enclosed-by=char

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --fields-terminated-by=...

    Description
    Description

    --fields-terminated-by=str

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --fields-xxx

    Description

    --first-slave

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --fix-db-names

    Description

    --fix-table-names

    Description

    --flush

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    --flush-logs

    Section 6.3.1, “Backup Policy”
    Description

    --flush-privileges

    Description

    --flush_time=val

    Section 22.1.1, “MySQL Threads”

    --flushlog

    Description

    --force

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 22.1.2, “MySQL Test Suite”
    Section 3.5, “Using mysql in Batch Mode”

    --force-read

    Description

    --gdb

    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section 5.1.2, “Server Command Options”

    --general-log

    Section 5.1.2, “Server Command Options”

    --general-log[={0|1}]

    Section 5.1.2, “Server Command Options”

    --general_log

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 5.2.3, “The General Query Log”

    --general_log[={0|1}]

    Section 5.2.3, “The General Query Log”

    --general_log_file

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --general_log_file=file_name

    Section 5.1.2, “Server Command Options”
    Section 5.2.3, “The General Query Log”

    --header_file=file_name

    Description

    --help

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.1.2, “Server Command Options”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 7.5.3, “Tuning Server Parameters”
    Chapter 3, Tutorial
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 4.2.3.3, “Using Option Files”
    Section 4.2.3.1, “Using Options on the Command Line”

    --hex-blob

    Description

    --hexdump

    Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
    Description

    --host

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Section 4.2.1, “Invoking MySQL Programs”
    Section 2.3.5, “MIT-pthreads Notes”
    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
    Section 1.2, “Typographical and Syntax Conventions”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --host=--user

    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”

    --host=127.0.0.1

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --host=host_name

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --host=localhost

    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
    Section 4.2.3.3, “Using Option Files”
    Section 4.2.3.1, “Using Options on the Command Line”

    --howto

    Description

    --html

    Section 4.5.1.1, “mysql Options”

    --i-am-a-dummy

    Section 4.5.1.1, “mysql Options”
    Section 4.5.1.5.2, “Using the --safe-updates Option”

    --ignore

    Description

    --ignore-builtin-innodb

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --ignore-lines=N

    Description

    --ignore-spaces

    Section 4.5.1.1, “mysql Options”

    --ignore-sql-errors

    Description

    --ignore-table=db_name.tbl_name

    Description

    --in_file=file_name

    Description

    --include

    Description

    --include-databases

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --include-master-host-port

    Description

    --include-tables

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --info

    Description
    Description

    --information

    Section 4.6.3.2, “myisamchk Check Options”

    --init-file

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
    Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
    Section 5.1.4, “Server System Variables”
    Section 13.9, “The MEMORY (HEAP) Storage Engine”
    Section 2.3.2, “Typical configure Options”

    --init-file=file_name

    Section 5.1.2, “Server Command Options”

    --init_connect="SET NAMES 'utf8'"

    Section 9.1.5, “Configuring the Character Set and Collation for Applications”

    --initial

    Section 17.5.11.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Description
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.3.2, “MySQL Cluster Configuration Files”
    Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.5.10.3, “MySQL Cluster Disk Data Storage Requirements”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    Section 17.5.1, “Summary of MySQL Cluster Start Phases”

    --initial-start

    Description

    --innodb

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --innodb-autoinc-lock-mode

    Section 13.6.4.3.2, “Configurable InnoDB Auto-Increment Locking”

    --innodb-safe-binlog

    Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
    Section 5.1.2, “Server Command Options”
    Section 5.2.4, “The Binary Log”

    --innodb-status-file

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --innodb-status-file=1

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --innodb-xxx

    Section 5.1.2, “Server Command Options”

    --innodb[=value]

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --innodb_checksums

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --innodb_file_per_table

    Section 5.1.2, “Server Command Options”
    Section 13.6.2.1, “Using Per-Table Tablespaces”
    Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

    --innodb_locks_unsafe_for_binlog

    Section 16.1.3.4, “Binary Log Options and Variables”

    --innodb_rollback_on_timeout

    Section 13.6.12, “InnoDB Error Handling”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --innodb_support_xa

    Section 5.2.4, “The Binary Log”

    --insert-ignore

    Description

    --install

    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    --install-manual

    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    --iterations=N

    Description

    --join=big_tbl_name

    Description

    --keep_files_on_create

    Section 12.1.17, “CREATE TABLE Syntax”

    --keepold

    Description

    --key_buffer_size=32M

    Section 5.1.2, “Server Command Options”

    --keys

    Description

    --keys-used=val

    Section 4.6.3.3, “myisamchk Repair Options”

    --label=str

    Description

    --language

    Section C.1.33, “Changes in MySQL 5.1.21 (16 August 2007)”
    Section 5.1.2, “Server Command Options”
    Section 9.2, “Setting the Error Message Language”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --language=lang_name, -L lang_name

    Section 5.1.2, “Server Command Options”

    --large-pages

    Section 7.5.9, “Enabling Large Page Support”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --lc-messages

    Section 5.1.2, “Server Command Options”
    Section 9.2, “Setting the Error Message Language”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --lc-messages-dir

    Section 5.1.2, “Server Command Options”
    Section 9.2, “Setting the Error Message Language”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --lc-messages-dir=path

    Section 5.1.2, “Server Command Options”

    --lc-messages=locale_name

    Section 5.1.2, “Server Command Options”

    --ldata=path

    Description

    --ledir

    Description

    --ledir=path

    Description

    --length

    Description

    --libmysqld-libs

    Description

    --libs

    Description

    --libs_r

    Description

    --line-numbers

    Section 4.5.1.1, “mysql Options”

    --lines-terminated-by

    Description

    --lines-terminated-by="\r\n"

    Description

    --lines-terminated-by=...

    Description
    Description

    --lines-terminated-by=str

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --list-users

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --local

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Description
    Section 22.1.2, “MySQL Test Suite”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

    --local-infile

    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

    --local-infile=0

    Section 4.5.1.1, “mysql Options”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”
    Section 5.3.4, “Security-Related mysqld Options”

    --local-infile=1

    Section 4.5.1.1, “mysql Options”

    --local-infile[=1]

    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

    --local-infile[={0|1}]

    Section 4.5.1.1, “mysql Options”
    Section 5.3.4, “Security-Related mysqld Options”

    --local-load

    Description

    --local-load=path

    Description

    --local-service

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    --lock-all-tables

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --lock-directory

    Description

    --lock-directory=path

    Description

    --lock-tables

    Description
    Description

    --log

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.2.6, “Server Log Maintenance”
    Section 5.1.4, “Server System Variables”
    Section 5.2.3, “The General Query Log”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

    --log-backup-output[=value,...]

    Section 5.1.2, “Server Command Options”

    --log-bin

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
    Section 6.3.1, “Backup Policy”
    Section 6.3.3, “Backup Strategy Summary”
    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 19.7, “Binary Logging of Stored Programs”
    Section 6.2, “Database Backup Methods”
    Section 16.4.6, “How to Report Replication Bugs or Problems”
    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
    Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
    Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
    Section 16.4.4, “Replication FAQ”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.1.2, “Server Command Options”
    Section 5.2.6, “Server Log Maintenance”
    Section 5.1.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”
    Section 5.2.3, “The General Query Log”
    Section 16.4.5, “Troubleshooting Replication”
    Section 16.4.3, “Upgrading a Replication Setup”
    Section 6.3.2, “Using Backups for Recovery”

    --log-bin-index

    Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”

    --log-bin-index[=file_name]

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.2.4, “The Binary Log”

    --log-bin-trust-function-creators

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 19.7, “Binary Logging of Stored Programs”
    Section 1.5, “What Is New in MySQL 5.1”

    --log-bin-trust-function-creators=1

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 19.7, “Binary Logging of Stored Programs”

    --log-bin-trust-function-creators[={0|1}]

    Section 16.1.3.4, “Binary Log Options and Variables”

    --log-bin-trust-routine-creators

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 19.7, “Binary Logging of Stored Programs”
    Section 1.5, “What Is New in MySQL 5.1”

    --log-bin-trust-routine-creators=1

    Section 19.7, “Binary Logging of Stored Programs”

    --log-bin-trust-routine-creators[={0|1}]

    Section 16.1.3.4, “Binary Log Options and Variables”

    --log-bin=base_name.extension

    Section 5.2.4, “The Binary Log”

    --log-bin=log_name

    Section 6.3.3, “Backup Strategy Summary”

    --log-bin=old_host_name-bin

    Section B.5.8.2, “Additional Known Issues”
    Section B.5.8.1, “Open Issues in MySQL”

    --log-bin[=base_name]

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.2.4, “The Binary Log”

    --log-bin[=file_name]

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    --log-error

    Section 12.4.6.3, “FLUSH Syntax”
    Description
    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
    Section 5.1.2, “Server Command Options”
    Section 5.2.6, “Server Log Maintenance”
    Section 5.2.2, “The Error Log”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --log-error my-errors

    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”

    --log-error=file_name

    Description
    Description
    Section 5.2.2, “The Error Log”

    --log-error[=file_name]

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”
    Section 5.2.2, “The Error Log”

    --log-isam=file_name

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    --log-isam[=file_name]

    Section 5.1.2, “Server Command Options”

    --log-long-format

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 5.2.5, “The Slow Query Log”

    --log-output

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.2.3, “The General Query Log”
    Section 5.2.5, “The Slow Query Log”

    --log-output=FILE

    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”

    --log-output=TABLE

    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --log-output=TABLE,FILE

    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”

    --log-output[=value,...]

    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”

    --log-queries-not-using-indexes

    Section 5.1.2, “Server Command Options”
    Section 5.2.5, “The Slow Query Log”

    --log-short-format

    Section 5.1.2, “Server Command Options”
    Section 5.2.5, “The Slow Query Log”

    --log-slave-updates

    Section 16.4.6, “How to Report Replication Bugs or Problems”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 16.4.4, “Replication FAQ”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.2.4, “The Binary Log”

    --log-slow-admin-statements

    Section 5.1.2, “Server Command Options”
    Section 5.2.5, “The Slow Query Log”

    --log-slow-queries

    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.2.6, “Server Log Maintenance”
    Section 5.1.4, “Server System Variables”
    Section 5.2.5, “The Slow Query Log”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

    --log-slow-queries[=file_name]

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”
    Section 5.2.5, “The Slow Query Log”

    --log-slow-slave-statements

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.2.5, “The Slow Query Log”

    --log-tc-size

    Section 5.1.6, “Server Status Variables”

    --log-tc-size=size

    Section 5.1.2, “Server Command Options”

    --log-tc=file_name

    Section 5.1.2, “Server Command Options”

    --log-update

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.2.6, “Server Log Maintenance”

    --log-update[=file_name]

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”

    --log-warnings

    Section B.5.2.11, “Communication Errors and Aborted Connections”
    Section 16.1.1, “How to Set Up Replication”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 5.2.2, “The Error Log”

    --log-warnings=0

    Section 5.1.2, “Server Command Options”

    --log-warnings=2

    Section B.5.2.9, “MySQL server has gone away”

    --log-warnings[=level]

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.1.2, “Server Command Options”

    --log=file_name

    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --log[=file_name]

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”
    Section 5.2.3, “The General Query Log”

    --loose

    Section 4.2.3.2, “Program Option Modifiers”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --loose-opt_name

    Section 4.2.3.3, “Using Option Files”

    --loose-skip-innodb

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --low-priority

    Description

    --low-priority-updates

    Section 12.2.5, “INSERT Syntax”
    Section 7.3.3, “Concurrent Inserts”
    Section 16.4.4, “Replication FAQ”
    Section 5.1.2, “Server Command Options”
    Section 7.3.2, “Table Locking Issues”

    --lower-case-table-names=0

    Section 8.2.2, “Identifier Case Sensitivity”

    --malloc-lib

    Description

    --malloc-lib=

    Description

    --malloc-lib=/path/to/some/library

    Description

    --malloc-lib=[lib_name]

    Description

    --malloc-lib=tcmalloc

    Description

    --master-bind

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”

    --master-connect-retry

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.2, “Replication Implementation”
    Section 7.5.6.6, “Replication Slave I/O Thread States”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.16, “Replication and Master or Slave Shutdowns”

    --master-connect-retry=seconds

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-data

    Section 6.3.1, “Backup Policy”
    Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
    Description

    --master-data[=value]

    Description

    --master-host

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-host=host_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-info-file

    Section 16.2.2.2, “The Slave Status Files”

    --master-info-file=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-password

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-password=password

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-port

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-port=port_number

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-retry-count

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-retry-count=count

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl*

    Section 5.5.6.3, “SSL Command Options”

    --master-ssl-ca

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-ca=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-capath

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-capath=directory_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-cert

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-cert=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-cipher

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-cipher=cipher_list

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-key

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-ssl-key=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-user

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-user=user_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --master-xxx

    Section 1.5, “What Is New in MySQL 5.1”

    --max

    Section 4.2.3.4, “Using Options to Set Program Variables”

    --max-binlog-dump-events=N

    Section 16.1.3.4, “Binary Log Options and Variables”

    --max-binlog-size

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --max-record-length

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    --max-record-length=len

    Section 4.6.3.3, “myisamchk Repair Options”

    --max-relay-log-size

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --max-relay-log-size=size

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --max-seeks-for-key=1000

    Section 7.2.19, “How to Avoid Table Scans”
    Section B.5.6, “Optimizer-Related Issues”

    --max_a

    Section 4.2.3.4, “Using Options to Set Program Variables”

    --max_connect_errors=999999999

    Section 12.4.6.3, “FLUSH Syntax”

    --max_join_size

    Section 4.5.1.5.2, “Using the --safe-updates Option”

    --max_sort_length=N

    Section 10.4.3, “The BLOB and TEXT Types”

    --maximum

    Section 4.2.3.2, “Program Option Modifiers”

    --maximum-query_cache_size=32M

    Section 7.5.5.3, “Query Cache Configuration”
    Section 5.1.5, “Using System Variables”

    --maximum-query_cache_size=4M

    Section 4.2.3.2, “Program Option Modifiers”

    --maximum-var_name=value

    Section 5.1.2, “Server Command Options”
    Section 5.1.5, “Using System Variables”

    --medium-check

    Section 4.6.3.2, “myisamchk Check Options”
    Description

    --memlock

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”

    --method=command

    Description

    --min-examined-row-limit=number

    Section 5.1.2, “Server Command Options”

    --monitoring-interval=seconds

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --mutex-deadlock-detector

    Section 5.1.2, “Server Command Options”

    --myisam-block-size

    Section 7.4.5.5, “Key Cache Block Size”

    --myisam-block-size=N

    Section 5.1.2, “Server Command Options”

    --myisam-recover

    Section 13.5.1, “MyISAM Startup Options”
    Section 7.2.24, “Other Optimization Tips”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    Section B.5.2.19, “Table-Corruption Issues”
    Section 13.5, “The MyISAM Storage Engine”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

    --myisam-recover-options

    Section 13.5.1, “MyISAM Startup Options”
    Section 7.2.24, “Other Optimization Tips”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    Section B.5.2.19, “Table-Corruption Issues”
    Section 13.5, “The MyISAM Storage Engine”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

    --myisam-recover-options=BACKUP,FORCE

    Section 5.1.4, “Server System Variables”

    --myisam-recover-options=mode

    Section 13.5.1, “MyISAM Startup Options”

    --myisam-recover-options[=option[,option]...]]

    Section 5.1.2, “Server Command Options”

    --myisam-recover=BACKUP,FORCE

    Section 5.1.4, “Server System Variables”

    --myisam-recover=mode

    Section 13.5.1, “MyISAM Startup Options”

    --myisam-recover[=option[,option]...]]

    Section 5.1.2, “Server Command Options”

    --mysql-backup[={0|1}]

    Section 5.1.2, “Server Command Options”

    --mysqladmin=prog_name

    Description

    --mysqld

    Description
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --mysqld-safe-compatible

    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    --mysqld-version

    Description
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --mysqld-version=debug

    Description

    --mysqld-version=max

    Description

    --mysqld-version=suffix

    Description

    --mysqld=mysqld_safe

    Description

    --mysqld=prog_name

    Description
    Description

    --name_file=file_name

    Description

    --named-commands

    Section 4.5.1.1, “mysql Options”

    --ndb

    Description

    --ndb-batch-size

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    --ndb-batch-size=#

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    --ndb-cluster

    The mysqld-max Extended MySQL Server

    --ndb-cluster-connection-pool

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

    --ndb-cluster-connection-pool=#

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    --ndb-cluster-connection-pool=4

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    --ndb-connectstring

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”

    --ndb-connectstring=connect_string

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    --ndb-force-send=1

    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”

    --ndb-index-stat-enable=0

    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”

    --ndb-log-empty-epochs

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --ndb-log-orig

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”

    --ndb-log-update-as-write

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    --ndb-log-update-as-write=0

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    --ndb-log-update-as-write=OFF

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    --ndb-log-updated-only

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    --ndb-nodeid

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Description

    --ndb-nodeid=#

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    --ndb-use-exact-count=0

    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”

    --ndb_optimized_node_selection

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.3.4.3, “MySQL Cluster System Variables”

    --ndbcluster

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 12.4.5.17, “SHOW ENGINES Syntax”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.3, “MySQL Cluster Configuration”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
    The mysqld-max Extended MySQL Server
    Section 17.5.8, “The ndbinfo MySQL Cluster Information Database”

    --ndbcluster --ndb-connectstring=management_host

    Section 17.5.9.2, “MySQL Cluster and MySQL Privileges”

    --ndbinfo-database=name

    Section 17.3.4.3, “MySQL Cluster System Variables”

    --ndbinfo-table-prefix

    Section 17.3.4.3, “MySQL Cluster System Variables”

    --new

    Section 8.1.4, “Hexadecimal Values”
    Section 10.1.2, “Overview of Date and Time Types”
    Section 5.1.2, “Server Command Options”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 4.2.3.3, “Using Option Files”

    --nice=priority

    Description

    --no-auto-rehash

    Section 4.5.1.1, “mysql Options”

    --no-autocommit

    Description

    --no-beep

    Section 4.5.1.1, “mysql Options”
    Description

    --no-create-db

    Description

    --no-create-info

    Description
    Section 6.4.5.4, “Dumping Table Definitions and Content Separately”

    --no-data

    Description
    Section 6.4.5.4, “Dumping Table Definitions and Content Separately”

    --no-debug

    Description

    --no-defaults

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Description
    Description
    Description

    --no-embedded

    Description

    --no-log

    Description

    --no-named-commands

    Section 4.5.1.1, “mysql Options”
    Section 1.5, “What Is New in MySQL 5.1”

    --no-pager

    Section 4.5.1.1, “mysql Options”
    Section 1.5, “What Is New in MySQL 5.1”

    --no-set-names

    Description

    --no-symlinks

    Section 4.6.3.3, “myisamchk Repair Options”

    --no-tablespaces

    Description

    --no-tee

    Section 4.5.1.1, “mysql Options”
    Section 1.5, “What Is New in MySQL 5.1”

    --nodaemon

    Description

    --nodeid

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    --noindices

    Description

    --nostart

    Description

    --nowait-nodes

    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Description
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

    --nowait-nodes=3

    Description

    --nowait-nodes=3,5

    Description

    --nowait-nodes=node_id_1[, node_id_2[, ...]]

    Description

    --number-blob-cols=str

    Description

    --number-char-cols=N

    Description

    --number-int-cols=N

    Description

    --number-of-queries=N

    Description

    --numeric-dump-file=file_name

    Description

    --offset=N

    Description

    --old

    Section 12.4.2.4, “CHECKSUM TABLE Syntax”

    --old-alter-table

    Section 5.1.2, “Server Command Options”

    --old-passwords

    Section B.5.2.4, “Client does not support authentication protocol”
    Section 5.3.2.3, “Password Hashing in MySQL”
    Section 16.4.1.11, “Replication and System Functions”
    Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --old-protocol

    Section B.5.2.15, “Ignoring user”
    Section 21.9.3.52, “mysql_real_connect()”
    Section 5.1.2, “Server Command Options”

    --old-style-user-limits

    Section 5.1.2, “Server Command Options”
    Section 5.5.4, “Setting Account Resource Limits”

    --old_server

    Description
    Description

    --one-database

    Section 4.5.1.1, “mysql Options”

    --one-thread

    Section 5.1.2, “Server Command Options”

    --only-debug

    Description

    --only-print

    Description

    --open-files-limit

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 2.5.9, “MySQL on Windows Compared to MySQL on Unix”
    Section 5.1.4, “Server System Variables”

    --open-files-limit=count

    Description
    Section 5.1.2, “Server Command Options”

    --opt

    Section 13.6.13.1, “InnoDB Performance Tuning Tips”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Description
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --opt_name

    Section 4.2.3.3, “Using Option Files”

    --opt_name=value

    Section 4.2.3.3, “Using Option Files”

    --optimize

    Description

    --order-by-primary

    Description

    --out_dir=path

    Description

    --out_file=file_name

    Description

    --packlength=len

    Description

    --pager

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”

    --pager[=command]

    Section 4.5.1.1, “mysql Options”

    --parallel-recover

    Section 4.6.3.3, “myisamchk Repair Options”

    --partition[=value]

    Section 5.1.2, “Server Command Options”

    --passwd

    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --password

    Section 4.5.1.1, “mysql Options”
    Section 5.5.2, “Adding User Accounts”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.3.2.2, “End-User Guidelines for Password Security”
    Section 6.3, “Example Backup and Recovery Strategy”
    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section B.5.2.5, “Password Fails When Entered Interactively”
    Section 5.5.1, “User Names and Passwords”
    Section 4.2.3.1, “Using Options on the Command Line”

    --password-file

    Section 4.6.10.4, “Instance Manager User and Password Management”

    --password-file=file_name

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --password=

    Section 4.2.2, “Connecting to the MySQL Server”

    --password=pass_val

    Section 4.2.3.1, “Using Options on the Command Line”

    --password=password

    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --password=your_pass

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 5.3.2.2, “End-User Guidelines for Password Security”

    --password[=pass_val]

    Section 4.2.2, “Connecting to the MySQL Server”

    --password[=password]

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    --pid-file

    Description
    Section 5.1.4, “Server System Variables”

    --pid-file=file_name

    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    --pid-file=path

    Section 5.1.2, “Server Command Options”

    --pipe

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Section 2.5.5.7, “Testing The MySQL Installation”

    --plan

    Description

    --plugin

    Section 5.1.2, “Server Command Options”

    --plugin-innodb_file_per_table

    Section 5.1.2, “Server Command Options”

    --plugin-load

    Section 12.4.3.4, “INSTALL PLUGIN Syntax”
    Section 22.2.4.1, “General Plugin Data Structures and Functions”
    Section 12.4.3.1, “Installing and Uninstalling Plugins”
    Section 22.2.2, “Plugin API Components”
    Section 5.1.2, “Server Command Options”

    --plugin-load=plugin_list

    Section 5.1.2, “Server Command Options”

    --plugin-sql-mode

    Section 5.1.2, “Server Command Options”

    --plugin-xxx

    Section 5.1.2, “Server Command Options”

    --plugin_dir=path

    Section 22.2.2, “Plugin API Components”

    --plugin_name

    Section 5.1.3, “Server Options for Loading Plugins”

    --plugin_name=0

    Section 5.1.3, “Server Options for Loading Plugins”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --plugin_name=1

    Section 5.1.3, “Server Options for Loading Plugins”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --plugin_name=FORCE

    Section 5.1.3, “Server Options for Loading Plugins”

    --plugin_name=OFF

    Section 5.1.3, “Server Options for Loading Plugins”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --plugin_name=ON

    Section 5.1.3, “Server Options for Loading Plugins”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --plugin_name[=ON]

    Section 5.1.3, “Server Options for Loading Plugins”

    --plugindir

    Description

    --plugins=max

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    --plugins=max-no-innodb

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    --plugins=ndbcluster

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    --port

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Section 4.2.1, “Invoking MySQL Programs”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 5.1.4, “Server System Variables”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --port-open-timeout=num

    Section 5.1.2, “Server Command Options”

    --port=port_num

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”

    --port=port_number

    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --position

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    --position=N

    Description

    --post-query=value

    Description

    --post-system=str

    Description

    --pre-query=value

    Description

    --pre-system=str

    Description

    --prefix

    Section 2.3.3, “Installing from the Development Source Tree”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 22.2.5, “Writing Plugins”

    --preserve-schema

    Description

    --preview

    Description

    --print-defaults

    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 2.4.1, “Upgrading MySQL”

    --print-password-line

    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --prompt

    Section 4.5.1.2, “mysql Commands”

    --prompt=format_str

    Section 4.5.1.1, “mysql Options”

    --protocol

    Section 4.2.2, “Connecting to the MySQL Server”
    Description

    --protocol=MEMORY

    Section 2.5.5.4, “Starting the Server for the First Time”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --protocol=PIPE

    Section 4.2.2, “Connecting to the MySQL Server”
    Section 2.5.5.7, “Testing The MySQL Installation”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --protocol=SOCKET

    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --protocol=TCP

    Section 4.2.2, “Connecting to the MySQL Server”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --protocol={TCP|SOCKET|PIPE|MEMORY}

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.6.2, “Running Multiple Servers on Unix”

    --query

    Description

    --query-cache-size=0

    Section 7.3.4, “External Locking”

    --query=value

    Description

    --quick

    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Section B.5.2.8, “Out of memory”
    Description
    Description
    Description
    Section 6.6.1, “Using myisamchk for Crash Recovery”
    Section 4.2.3.3, “Using Option Files”

    --quiet

    Description

    --quote-names

    Description
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --raw

    Section 4.5.1.1, “mysql Options”

    --read-from-remote-server

    Description

    --read-only

    Section 4.6.3.2, “myisamchk Check Options”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --reconnect

    Section 4.5.1.1, “mysql Options”

    --record_log_pos

    Description

    --record_log_pos=db_name.tbl_name

    Description

    --recover

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.3, “myisamchk Repair Options”

    --regexp=expr

    Description

    --regexp=pattern

    Description

    --relative

    Description

    --relay-log

    Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.2.2.1, “The Slave Relay Log”

    --relay-log-index

    Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.2.2.1, “The Slave Relay Log”

    --relay-log-index=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log-info-file

    Section 16.2.2.2, “The Slave Status Files”

    --relay-log-info-file=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log-purge={0|1}

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log-recovery

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log-recovery={0|1}

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log-space-limit

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log-space-limit=size

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --relay-log=myhost-bin

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”

    --relay-log=relay_log_index

    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”

    --relnotes

    Description

    --reload

    Section 17.5.11.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.3.2, “MySQL Cluster Configuration Files”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    --remove

    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    --repair

    Description

    --replace

    Description
    Description

    --replicate-*

    Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
    Section 16.2.3.3, “Replication Rule Application”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-*-db

    Section 16.2.3.3, “Replication Rule Application”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

    --replicate-*-do-*

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

    --replicate-*-ignore-*

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

    --replicate-*-table

    Section 19.7, “Binary Logging of Stored Programs”
    Section 16.2.3.3, “Replication Rule Application”

    --replicate-[do|ignore]-table

    Section 13.14, “The BLACKHOLE Storage Engine”

    --replicate-do-*

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --replicate-do-db

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
    Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.22, “Replication and Reserved Words”
    Section 16.4.1.19, “Replication and Temporary Tables”
    Section 5.2.4, “The Binary Log”

    --replicate-do-db=db1

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-do-db=db_name

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-do-db=mysql

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --replicate-do-db=sales

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-do-table

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
    Section 16.2.3.3, “Replication Rule Application”
    Section 16.4.1.22, “Replication and Reserved Words”
    Section 16.4.1.19, “Replication and Temporary Tables”

    --replicate-do-table=db_name.tbl_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-do-table=mysql.ndb_apply_status

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --replicate-ignore-*

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --replicate-ignore-db

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
    Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
    Section 16.2.3.3, “Replication Rule Application”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.22, “Replication and Reserved Words”
    Section 5.2.4, “The Binary Log”

    --replicate-ignore-db=db_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-ignore-db=mysql

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --replicate-ignore-db=sales

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-ignore-table

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
    Section 16.4.1.22, “Replication and Reserved Words”
    Section 16.4.1.19, “Replication and Temporary Tables”

    --replicate-ignore-table=db_name.tbl_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-ignore-table=mysql.ndb_apply_status

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”

    --replicate-rewrite-db

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”

    --replicate-rewrite-db="db1->db3"

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

    --replicate-rewrite-db="db2->db3"

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

    --replicate-rewrite-db=from_name->to_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-same-server-id

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-do-table

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.19, “Replication and Temporary Tables”

    --replicate-wild-do-table=db_name.%

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-do-table=db_name.tbl_name

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

    --replicate-wild-do-table=foo%.%

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-do-table=foo%.bar%

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-do-table=my\\_own\\%db

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-do-table=my\_own\%db

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-ignore-table

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.19, “Replication and Temporary Tables”

    --replicate-wild-ignore-table=db_name.%

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-ignore-table=db_name.tbl_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-ignore-table=foo%.bar%

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --replicate-wild-ignore-table=mysql.%

    Section 16.4.4, “Replication FAQ”

    --replicate-wild-ignore-table=norep%

    Section 16.4.1.19, “Replication and Temporary Tables”

    --report-host

    Section 5.1.4, “Server System Variables”

    --report-host=host_name

    Section 12.4.5.35, “SHOW SLAVE HOSTS Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    --report-password

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.1.4, “Server System Variables”

    --report-password=password

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --report-port

    Section 5.1.4, “Server System Variables”

    --report-port=slave_port_num

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --report-user

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.1.4, “Server System Variables”

    --report-user=user_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --resetmaster

    Description

    --resetslave

    Description

    --restore-epoch

    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”

    --restore_epoch

    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”

    --result-file=file_name

    Description

    --result-file=name

    Description

    --rhost=host_name

    Description

    --rollback

    Description

    --routines

    Description
    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 6.4.5.3, “Dumping Stored Programs”
    Section 6.4.5.4, “Dumping Table Definitions and Content Separately”

    --rows=N

    Description

    --rpm

    Description

    --run-as-service

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --safe-mode

    Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
    Section 22.5.1, “Debugging a MySQL Server”
    Section 5.1.2, “Server Command Options”

    --safe-recover

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.3, “myisamchk Repair Options”

    --safe-show-database

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --safe-updates

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”
    Section 4.5.1.5.2, “Using the --safe-updates Option”

    --safe-user-create

    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --secure-auth

    Section 4.5.1.1, “mysql Options”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --secure-backup-file-priv

    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --secure-backup-file-priv=path

    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --secure-file-priv

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.3.1, “Source Installation Overview”

    --secure-file-priv=path

    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --select_limit

    Section 4.5.1.5.2, “Using the --safe-updates Option”

    --server-id

    Section 16.1.3, “Replication and Binary Logging Options and Variables”
    Section 5.1.4, “Server System Variables”
    Section 16.4.5, “Troubleshooting Replication”

    --server-id=id

    Description

    --server-id=value

    Section 12.4.5.35, “SHOW SLAVE HOSTS Syntax”

    --service-startup-timeout=file_name

    Description

    --set-auto-increment[=value]

    Section 4.6.3.4, “Other myisamchk Options”

    --set-character-set=name

    Section 4.6.3.3, “myisamchk Repair Options”

    --set-charset

    Description

    --set-charset=charset_name

    Description

    --set-collation

    Section 4.6.3.3, “myisamchk Repair Options”

    --set-collation=name

    Section 4.6.3.3, “myisamchk Repair Options”

    --set-random-seed=value

    Description

    --set-variable

    Section 4.5.1.1, “mysql Options”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Description
    Description
    Section 4.2.3.4, “Using Options to Set Program Variables”

    --set-variable=option=value

    Section 4.2.3.4, “Using Options to Set Program Variables”

    --set-variable=var_name=value

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 7.5.3, “Tuning Server Parameters”
    Section 4.2.3.3, “Using Option Files”

    --shared-memory

    Section 4.2.2, “Connecting to the MySQL Server”
    Section 5.1.2, “Server Command Options”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
    Section 2.5.5.4, “Starting the Server for the First Time”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --shared-memory-base-name

    Section 21.9.3.49, “mysql_options()”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --shared-memory-base-name=name

    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”

    --short-form

    Description

    --show-slave-auth-info

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --show-table-type

    Description

    --show-warnings

    Section 4.5.1.1, “mysql Options”

    --sigint-ignore

    Section 4.5.1.1, “mysql Options”

    --silent

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

    --single-transaction

    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 6.3.1, “Backup Policy”
    Section 6.2, “Database Backup Methods”
    Description

    --skip

    Description
    Section 4.2.3.2, “Program Option Modifiers”
    Section 5.1.2, “Server Command Options”

    --skip-add-drop-table

    Description

    --skip-add-locks

    Description

    --skip-auto-rehash

    Section 4.5.1.1, “mysql Options”
    Section 13.6.13.4, “Troubleshooting InnoDB Data Dictionary Operations”

    --skip-base64-output

    Description

    --skip-bdb

    Section 16.4.4, “Replication FAQ”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --skip-character-set-client-handshake

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 9.1.13.7.1, “The cp932 Character Set”

    --skip-column-names

    Section 4.5.1.1, “mysql Options”

    --skip-comments

    Description

    --skip-compact

    Description

    --skip-concurrent-insert

    Section 5.1.2, “Server Command Options”

    --skip-delay-key-write

    Section 5.1.2, “Server Command Options”

    --skip-disable-keys

    Description

    --skip-dump-date

    Description

    --skip-engine_name

    Section 12.4.5.17, “SHOW ENGINES Syntax”
    The mysqld-max Extended MySQL Server

    --skip-event-scheduler

    Section 5.1.2, “Server Command Options”

    --skip-events

    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 6.4.5.3, “Dumping Stored Programs”

    --skip-extended-insert

    Description

    --skip-external-locking

    Section 7.3.4, “External Locking”
    Section 7.5.6.2, “General Thread States”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 7.5.2, “System Factors and Startup Parameter Tuning”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    --skip-grant-tables

    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 12.4.3.4, “INSTALL PLUGIN Syntax”
    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Description
    Description
    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 12.4.3.1, “Installing and Uninstalling Plugins”
    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 2.3.2, “Typical configure Options”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 5.4.6, “When Privilege Changes Take Effect”

    --skip-host-cache

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 7.5.11, “How MySQL Uses DNS”
    Section 5.1.2, “Server Command Options”

    --skip-innodb

    Section 13.6.2, “InnoDB Configuration”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 12.4.5.17, “SHOW ENGINES Syntax”
    Section 16.4.4, “Replication FAQ”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    The mysqld-max Extended MySQL Server
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --skip-innodb-checksums

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --skip-innodb_adaptive_hash_index

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --skip-innodb_checksums

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --skip-innodb_doublewrite

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    --skip-isam

    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --skip-kill-mysqld

    Description

    --skip-line-numbers

    Section 4.5.1.1, “mysql Options”

    --skip-lock-tables

    Description

    --skip-locking

    Section 7.3.4, “External Locking”
    Section 1.5, “What Is New in MySQL 5.1”

    --skip-log-warnings

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --skip-merge

    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 13.8, “The MERGE Storage Engine”

    --skip-mutex-deadlock-detector

    Section 5.1.2, “Server Command Options”

    --skip-name-resolve

    Section 5.4.7, “Causes of Access-Denied Errors”
    Description
    Section 7.5.11, “How MySQL Uses DNS”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.5.5.7, “Testing The MySQL Installation”

    --skip-named-commands

    Section 4.5.1.1, “mysql Options”
    Section 1.5, “What Is New in MySQL 5.1”

    --skip-ndbcluster

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.3.4.3, “MySQL Cluster System Variables”

    --skip-networking

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section B.5.2.9, “MySQL server has gone away”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 7.5.11, “How MySQL Uses DNS”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 16.4.3, “Upgrading a Replication Setup”

    --skip-new

    Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
    Section 22.5.1, “Debugging a MySQL Server”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    --skip-opt

    Description
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --skip-pager

    Section 4.5.1.1, “mysql Options”
    Section 1.5, “What Is New in MySQL 5.1”

    --skip-partition

    Chapter 18, Partitioning
    Section 5.1.2, “Server Command Options”

    --skip-plugin-innodb_file_per_table

    Section 5.1.2, “Server Command Options”

    --skip-plugin_name

    Section 5.1.3, “Server Options for Loading Plugins”

    --skip-quick

    Description

    --skip-quote-names

    Description
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --skip-reconnect

    Section 4.5.1.1, “mysql Options”
    Section 21.9.11, “Controlling Automatic Reconnection Behavior”
    Section 4.5.1.5.3, “Disabling mysql Auto-Reconnect”

    --skip-routines

    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 6.4.5.3, “Dumping Stored Programs”

    --skip-safemalloc

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 5.1.2, “Server Command Options”

    --skip-set-charset

    Description

    --skip-show-database

    Section 12.4.5.15, “SHOW DATABASES Syntax”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --skip-slave-start

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 12.5.2.7, “START SLAVE Syntax”
    Section 16.1.1, “How to Set Up Replication”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.1.1.8, “Setting Up Replication with Existing Data”
    Section 16.4.5, “Troubleshooting Replication”
    Section 16.4.3, “Upgrading a Replication Setup”

    --skip-ssl

    Section 5.5.6.3, “SSL Command Options”

    --skip-stack-trace

    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section 5.1.2, “Server Command Options”

    --skip-super-large-pages

    Section 7.5.9, “Enabling Large Page Support”
    Section 5.1.2, “Server Command Options”

    --skip-symbolic-links

    Section 12.1.17, “CREATE TABLE Syntax”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”
    Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”

    --skip-symlink

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”

    --skip-syslog

    Description
    Section 5.2.2, “The Error Log”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --skip-tee

    Section 4.5.1.1, “mysql Options”
    Section 1.5, “What Is New in MySQL 5.1”

    --skip-thread-priority

    Section 5.1.2, “Server Command Options”

    --skip-triggers

    Description
    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 6.4.5.3, “Dumping Stored Programs”

    --skip-tz-utc

    Description

    --skip-use-db

    Description

    --skip-write-binlog

    Description
    Description

    --skip-xxx

    Description

    --skip_grant_tables

    Section 4.2.3.1, “Using Options on the Command Line”

    --slave

    Description

    --slave-allow-batching

    Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.1”
    Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

    --slave-load-tmpdir

    Section 6.2, “Database Backup Methods”
    Section 16.2.2.2, “The Slave Status Files”

    --slave-load-tmpdir=file_name

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --slave-net-timeout

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --slave-net-timeout=seconds

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --slave-skip-errors

    Section 16.4.1.23, “Slave Errors During Replication”

    --slave-skip-errors=[err_code1,err_code2,...|all]

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --slave_compressed_protocol={0|1}

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --sleep

    Description

    --sleep=delay

    Description

    --slow-query-log

    Section 5.1.2, “Server Command Options”

    --slow-query-log[={0|1}]

    Section 5.1.2, “Server Command Options”

    --slow_query_log

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 5.2.5, “The Slow Query Log”

    --slow_query_log[={0|1}]

    Section 5.2.5, “The Slow Query Log”

    --slow_query_log_file

    Section 5.1.4, “Server System Variables”

    --slow_query_log_file=file_name

    Section 5.1.2, “Server Command Options”
    Section 5.2.5, “The Slow Query Log”

    --socket

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 2.5.5.7, “Testing The MySQL Installation”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --socket=/path/to/socket

    Section B.5.2.2, “Can't connect to [local] MySQL server”

    --socket=file_name

    Section 4.2.2, “Connecting to the MySQL Server”
    Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

    --socket=path

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”

    --sort-index

    Section 6.6.4, “MyISAM Table Optimization”
    Section 4.6.3.4, “Other myisamchk Options”

    --sort-records=N

    Section 4.6.3.4, “Other myisamchk Options”

    --sort-records=index_num

    Section 6.6.4, “MyISAM Table Optimization”

    --sort-recover

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.3, “myisamchk Repair Options”

    --sort_buffer_size=16M

    Section 4.6.3.6, “myisamchk Memory Usage”

    --spassword

    Description

    --spassword[=password]

    Description

    --sporadic-binlog-dump-fail

    Section 16.1.3.4, “Binary Log Options and Variables”

    --sql-bin-update-same

    Section 1.5, “What Is New in MySQL 5.1”

    --sql-mode

    Section 5.1.2, “Server Command Options”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --sql-mode=""

    Section 5.1.7, “Server SQL Modes”

    --sql-mode="mode_value"

    Section 1.8.2, “Selecting SQL Modes”

    --sql-mode="modes"

    Section 5.1.7, “Server SQL Modes”

    --sql-mode=IGNORE_SPACE

    Chapter 11, Functions and Operators

    --sql-mode=MAXDB

    Section 10.3.1.1, “TIMESTAMP Properties”

    --sql-mode=NO_UNSIGNED_SUBTRACTION

    Section 11.9, “Cast Functions and Operators”

    --sql-mode=value[,value[,value...]]

    Section 5.1.2, “Server Command Options”

    --sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --srcdir=path

    Description

    --ssl

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.5.6.3, “SSL Command Options”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.5.6.2, “Using SSL Connections”

    --ssl*

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”

    --ssl-ca

    Section 12.4.1.3, “GRANT Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.5.6.3, “SSL Command Options”
    Section 5.5.6.2, “Using SSL Connections”

    --ssl-ca=file_name

    Section 5.5.6.3, “SSL Command Options”

    --ssl-capath

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.5.6.3, “SSL Command Options”

    --ssl-capath=directory_name

    Section 5.5.6.3, “SSL Command Options”

    --ssl-cert

    Section 12.4.1.3, “GRANT Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.5.6.3, “SSL Command Options”
    Section 5.5.6.2, “Using SSL Connections”

    --ssl-cert=file_name

    Section 5.5.6.3, “SSL Command Options”

    --ssl-cipher

    Section 16.1.3.3, “Replication Slave Options and Variables”

    --ssl-cipher=cipher_list

    Section 5.5.6.3, “SSL Command Options”

    --ssl-key

    Section 12.4.1.3, “GRANT Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.5.6.3, “SSL Command Options”
    Section 5.5.6.2, “Using SSL Connections”

    --ssl-key=file_name

    Section 5.5.6.3, “SSL Command Options”

    --ssl-verify-server-cert

    Section 5.5.6.3, “SSL Command Options”

    --ssl-xxx

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 5.5.6.2, “Using SSL Connections”

    --ssl=0

    Section 5.5.6.3, “SSL Command Options”

    --standalone

    Section 22.5.1.2, “Creating Trace Files”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.1.2, “Server Command Options”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”

    --start-datetime

    Description
    Section 6.5.1, “Point-in-Time Recovery Using Event Times”

    --start-datetime=datetime

    Description

    --start-position

    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 6.5.2, “Point-in-Time Recovery Using Event Positions”

    --start-position=N

    Description

    --start_row=N

    Description

    --statefile=file_name

    Description

    --stats

    Description

    --status

    Description

    --stop-datetime

    Description
    Section 6.5.1, “Point-in-Time Recovery Using Event Times”

    --stop-datetime=datetime

    Description

    --stop-position

    Section 6.5.2, “Point-in-Time Recovery Using Event Positions”

    --stop-position=N

    Description

    --suffix=str

    Description

    --super-large-pages

    Section 7.5.9, “Enabling Large Page Support”
    Section 5.1.2, “Server Command Options”

    --superuser=user_name

    Description

    --symbolic-links

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

    --symbols-file=file_name

    Description

    --sysdate-is-now

    Section 11.6, “Date and Time Functions”
    Section 16.4.1.11, “Replication and System Functions”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --syslog

    Description
    Section 5.2.2, “The Error Log”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --syslog-tag=tag

    Description
    Section 5.2.2, “The Error Log”

    --tab

    Section 6.1, “Backup and Recovery Types”
    Section 6.2, “Database Backup Methods”
    Description
    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
    Section 6.4, “Using mysqldump for Backups”

    --tab=dir_name

    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”

    --tab=path

    Description

    --table

    Section 4.5.1.1, “mysql Options”
    Description

    --table_cache

    Section 7.4.8, “How MySQL Opens and Closes Tables”

    --table_open_cache

    Section 7.4.8, “How MySQL Opens and Closes Tables”

    --tables

    Description
    Description

    --tc-heuristic-recover={COMMIT|ROLLBACK}

    Section 5.1.2, “Server Command Options”

    --tcp-ip

    Description

    --tee

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”

    --tee=file_name

    Section 4.5.1.1, “mysql Options”

    --temp-pool

    Section 5.1.2, “Server Command Options”

    --test

    Description

    --thread_cache_size=5'

    Section 22.5.1.4, “Debugging mysqld under gdb”

    --thread_handling=no-threads

    Section 5.1.2, “Server Command Options”

    --thread_handling=one-thread-per-connection

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”

    --thread_handling=pool-of-threads

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”

    --thread_pool_size=N

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”

    --thread_stack=N

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”

    --timer-length=N

    Description

    --timezone

    Section 9.6, “MySQL Server Time Zone Support”
    Section 5.1.4, “Server System Variables”
    Section B.5.4.6, “Time Zone Problems”

    --timezone=timezone

    Description

    --timezone=timezone_name

    Section 9.6, “MySQL Server Time Zone Support”
    Section 16.4.1.26, “Replication and Time Zones”
    Section B.5.4.6, “Time Zone Problems”

    --tmp_table_size=val

    Section B.5.2.12, “The table is full”

    --tmpdir

    Section 4.6.3.3, “myisamchk Repair Options”
    Section B.5.2.13, “Can't create/write to file”
    Section 5.1.2, “Server Command Options”
    Section B.5.4.4, “Where MySQL Stores Temporary Files”

    --tmpdir=path

    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.3, “myisamchk Repair Options”
    Description
    Description
    Description
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.1.2, “Server Command Options”

    --to-last-log

    Description

    --transaction-isolation

    Section 13.6.8, “The InnoDB Transaction Model and Locking”

    --transaction-isolation=SERIALIZABLE

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --transaction-isolation=level

    Section 12.3.6, “SET TRANSACTION Syntax”
    Section 5.1.2, “Server Command Options”

    --triggers

    Description
    Section 6.4.5.3, “Dumping Stored Programs”

    --type=engine_name

    Description

    --tz-utc

    Description

    --unbuffered

    Section 4.5.1.1, “mysql Options”

    --unpack

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 13.5.3, “MyISAM Table Storage Formats”
    Description

    --update-state

    Section 4.6.3.2, “myisamchk Check Options”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 13.5, “The MyISAM Storage Engine”

    --upgrade-system-tables

    Description

    --use-frm

    Description

    --use-manager

    Description

    --use-mysqld_safe

    Description

    --use-symbolic-links

    Section 1.5, “What Is New in MySQL 5.1”

    --use-threads

    Description

    --use-threads=N

    Description

    --user

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Description
    Description
    Description
    Section 6.3, “Example Backup and Recovery Strategy”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.9, “Installing MySQL on i5/OS”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
    Section 5.1.2, “Server Command Options”
    Section 2.3.1, “Source Installation Overview”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 5.5.1, “User Names and Passwords”
    Section 4.2.3.3, “Using Option Files”

    --user=mysql

    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
    Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”

    --user=root

    Section 5.3.6, “How to Run MySQL as a Normal User”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 5.1.2, “Server Command Options”

    --user=user_name

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.3.6, “How to Run MySQL as a Normal User”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --user={user_name|user_id}

    Description
    Section 5.1.2, “Server Command Options”

    --username

    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --username=user_name

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --var_name=value

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Description
    Description
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 7.5.3, “Tuning Server Parameters”

    --verbose

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Section 4.6.7.2, “mysqlbinlog Row Event Display”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.5.1.4, “Executing SQL Statements from a Text File”
    Section 4.6.3.4, “Other myisamchk Options”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 7.5.3, “Tuning Server Parameters”
    Section 4.2.3.3, “Using Option Files”
    Section 4.2.3.1, “Using Options on the Command Line”

    --version

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.1.2, “Server Command Options”
    Section 4.2.3.1, “Using Options on the Command Line”

    --vertical

    Section 4.5.1.1, “mysql Options”
    Description
    Section 1.7, “How to Report Bugs or Problems”

    --wait

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description

    --wait-timeout=N

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    --wait[=count]

    Description

    --warnings

    Section B.5.2.11, “Communication Errors and Aborted Connections”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”

    --where='where_condition'

    Description

    --windows

    Description

    --with

    Section 2.3.2, “Typical configure Options”

    --with-archive-storage-engine

    Section 13.12, “The ARCHIVE Storage Engine”

    --with-bdb

    The mysqld-max Extended MySQL Server

    --with-berkeley-db

    Section 2.1.2.2, “Choosing a Distribution Format”

    --with-big-tables

    Section 13.8.2, “MERGE Table Problems”
    Section 5.1.4, “Server System Variables”
    Section 13.5, “The MyISAM Storage Engine”
    Section 2.3.2, “Typical configure Options”

    --with-blackhole-storage-engine

    The mysqld-max Extended MySQL Server
    Section 13.14, “The BLACKHOLE Storage Engine”

    --with-charset

    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 2.3.2, “Typical configure Options”

    --with-charset=MYSET

    Section 9.3, “Adding a New Character Set”

    --with-charset=charset_name

    Section B.5.2.17, “Can't initialize character set”

    --with-collation

    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 2.3.2, “Typical configure Options”

    --with-comment

    Section 5.1.4, “Server System Variables”

    --with-csv-storage-engine

    Section 13.13, “The CSV Storage Engine”

    --with-debug

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 22.5.2, “Debugging a MySQL Client”
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 5.1.2, “Server Command Options”
    Section 2.3.2, “Typical configure Options”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    --with-debug=full

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 22.5.2, “Debugging a MySQL Client”
    Description
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 5.1.2, “Server Command Options”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    --with-debug[=full]

    Section 2.1.2.2, “Choosing a Distribution Format”

    --with-embedded-privilege-control

    Section 21.8, “libmysqld, the Embedded MySQL Server Library”

    --with-embedded-server

    Section 21.8.1, “Compiling Programs with libmysqld”
    Section 2.3.2, “Typical configure Options”

    --with-example-storage-engine

    The mysqld-max Extended MySQL Server
    Section 13.10, “The EXAMPLE Storage Engine”

    --with-extra-charsets=LIST

    Section 2.3.2, “Typical configure Options”

    --with-extra-charsets=charset_name

    Section B.5.2.17, “Can't initialize character set”

    --with-extra-charsets=complex

    Section B.5.2.17, “Can't initialize character set”

    --with-federated-storage-engine

    Section 13.11, “The FEDERATED Storage Engine”

    --with-innodb

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    The mysqld-max Extended MySQL Server

    --with-libevent

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    Section 5.1.4, “Server System Variables”
    Section 2.3.2, “Typical configure Options”

    --with-libwrap

    Section 2.1.2.2, “Choosing a Distribution Format”

    --with-low-memory

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    --with-max-indexes=N

    Section 13.5, “The MyISAM Storage Engine”

    --with-mit-threads

    Section 2.3.5, “MIT-pthreads Notes”

    --with-mysqld-ldflags=-all-static

    Section 22.3.2, “Adding a New User-Defined Function”

    --with-mysqld-ldflags=-rdynamic

    Section 22.3.2, “Adding a New User-Defined Function”

    --with-named-z-libs

    Section 2.1.2.2, “Choosing a Distribution Format”

    --with-ndb-sci=/opt/DIS

    Section 17.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”

    --with-ndb-sci=/your/path/to/SCI

    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    --with-ndb-shm

    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”

    --with-ndbcluster

    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    The mysqld-max Extended MySQL Server

    --with-openssl

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 5.5.6.2, “Using SSL Connections”

    --with-partition

    Chapter 18, Partitioning

    --with-plugin-PLUGIN

    Section 2.3.2, “Typical configure Options”

    --with-plugins

    Section 2.3.2, “Typical configure Options”

    --with-plugins=max

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

    --with-plugins=max-no-innodb

    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

    --with-plugins=ndbcluster

    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

    --with-pstack

    Section 5.1.2, “Server Command Options”

    --with-raid

    Section 12.1.17, “CREATE TABLE Syntax”
    Section 2.1.2.2, “Choosing a Distribution Format”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    --with-server-suffix=-max

    The mysqld-max Extended MySQL Server

    --with-ssl

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 5.5.6.2, “Using SSL Connections”

    --with-ssl=path

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --with-tcp-port

    Section 2.3.3, “Installing from the Development Source Tree”

    --with-unix-socket-path

    Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
    Section 2.3.3, “Installing from the Development Source Tree”

    --with-vio

    Section 5.5.6.2, “Using SSL Connections”

    --with-yassl

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    --with-zlib-dir=no|bundled|DIR

    Section 2.3.2, “Typical configure Options”

    --without

    Section 2.3.2, “Typical configure Options”

    --without-libevent

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    Section 2.3.2, “Typical configure Options”

    --without-plugin-PLUGIN

    Section 2.3.2, “Typical configure Options”

    --without-query-cache

    Section 7.5.5, “The MySQL Query Cache”

    --without-server

    Section 2.3.5, “MIT-pthreads Notes”
    Section 2.3.2, “Typical configure Options”

    --write-binlog

    Description
    Description

    --xml

    Section 4.5.1.1, “mysql Options”
    Description
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 11.10, “XML Functions”

    -0

    Section B.5.5.8, “Problems with Floating-Point Values”

    -1

    Section 1.8.5.5, “'--' as the Start of a Comment”
    Section 11.12.1, “GROUP BY (Aggregate) Functions”
    Section 18.2.3, “HASH Partitioning”
    Section 11.2.3, “Comparison Functions and Operators”
    Description
    Section 11.5.2, “Mathematical Functions”
    Section 11.11.4, “Miscellaneous Functions”
    Section 11.4.1, “String Comparison Functions”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    -?

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.1.2, “Server Command Options”
    Section 4.2.3.1, “Using Options on the Command Line”

    -A

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Section B.5.8.1, “Open Issues in MySQL”

    -A[value]

    Section 4.6.3.4, “Other myisamchk Options”

    -B

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description

    -C

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description

    -C charset_name

    Section 5.1.2, “Server Command Options”

    -C path

    Description

    -D

    Description
    Description
    Section 21.9.16.1, “Problems Linking with the C API”

    -D db_name

    Section 4.5.1.1, “mysql Options”

    -D len

    Section 4.6.3.3, “myisamchk Repair Options”

    -D path

    Description

    -DBIG_TABLES

    Section 2.3.2, “Typical configure Options”

    -DHAVE_rts_threads

    Section 22.5.4, “Comments about RTS Threads”

    -DUSE_ALARM_THREAD

    Section 22.1.1, “MySQL Threads”

    -DUSE_SYMDIR

    Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

    -E

    Section 4.5.1.1, “mysql Options”
    Description
    Description

    -F

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.2, “mysql Commands”
    Description
    Description

    -F file_name

    Description

    -F str

    Description

    -G

    Section 4.5.1.1, “mysql Options”

    -H

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description

    -H file_name

    Description

    -H host_name

    Description

    -I

    Section 21.9.16, “Building Client Programs”
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    -I/usr/local/mysql/include

    Section 21.9.16, “Building Client Programs”

    -K

    Description

    -L

    Section 4.5.1.1, “mysql Options”
    Section 21.9.16, “Building Client Programs”
    Description
    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”
    Section 9.2, “Setting the Error Message Language”

    -L/lib

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    -L/usr/lib

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    -L/usr/lib/gcc-lib/... -lgcc

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    -L/usr/local/mysql/lib -lmysqlclient -lz

    Section 21.9.16, “Building Client Programs”

    -N

    Section 4.5.1.1, “mysql Options”
    Description

    -N file_name

    Description

    -O var_name=value

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.2, “Server Command Options”
    Section 7.5.3, “Tuning Server Parameters”

    -O file_name

    Description

    -O0

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    -O3

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

    -O6

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

    -P

    Section 4.2.2, “Connecting to the MySQL Server”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    -P port_num

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.1.2, “Server Command Options”

    -P[password]

    Description

    -Q

    Description

    -R

    Description
    Description

    -R N

    Section 4.6.3.4, “Other myisamchk Options”

    -R index_num

    Section 6.6.4, “MyISAM Table Optimization”

    -R record_pos_file record_pos

    Description

    -S

    Section 4.5.1.2, “mysql Commands”
    Section 6.6.4, “MyISAM Table Optimization”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 4.6.3.4, “Other myisamchk Options”

    -S file_name

    Section 4.2.2, “Connecting to the MySQL Server”
    Description

    -S path

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    -T

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description

    -T [flags]

    Section 5.1.2, “Server Command Options”

    -T path

    Description
    Description

    -U

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.1, “mysql Options”

    -U user_name

    Description

    -V

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 5.1.2, “Server Command Options”
    Section 4.2.3.1, “Using Options on the Command Line”

    -W

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description

    -W [level]

    Section 5.1.2, “Server Command Options”

    -X

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”
    Description

    -Y

    Description
    Section 1.5, “What Is New in MySQL 5.1”

    -a

    Section 6.6.4, “MyISAM Table Optimization”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Description
    Description
    Description
    Section 4.6.3.4, “Other myisamchk Options”

    -b

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description

    -b path

    Section 5.1.2, “Server Command Options”

    -b offset

    Section 4.6.3.4, “Other myisamchk Options”

    -c

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.1, “mysql Options”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Description
    Description
    Description
    Description
    MySQL 4.1 FAQ: MySQL Cluster

    -c N

    Description
    Description
    Description

    -c column_list

    Description

    -c file_name

    Description

    -d

    Section 4.6.3.1, “myisamchk General Options”
    Description
    Description
    Description
    Description
    Description
    Section 4.6.3.4, “Other myisamchk Options”

    -d db_name

    Description
    Description

    -e

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.3, “myisamchk Repair Options”
    Description
    Description
    Section 6.6.2, “How to Check MyISAM Tables for Errors”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
    Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    -e engine_name

    Description

    -e file_name

    Description

    -e num

    Description

    -e statement

    Section 4.5.1.1, “mysql Options”

    -eis

    Section 4.6.3.5, “myisamchk Table Information”

    -f

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster

    -f N

    Description

    -felide-constructors

    Section 2.3, “MySQL Installation Using a Source Distribution”

    -fno-exceptions

    Section 2.3, “MySQL Installation Using a Source Distribution”

    -fno-inline

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    -fno-rtti

    Section 2.3, “MySQL Installation Using a Source Distribution”

    -fomit-frame-pointer

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 22.5.1.5, “Using a Stack Trace”

    -fomit-frame-pointer -ffixed-ebp

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

    -g

    Section 4.5.1.1, “mysql Options”
    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Description

    -g pattern

    Description

    -g suffix

    Description

    -h

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Section 4.2.1, “Invoking MySQL Programs”
    Section 2.3.5, “MIT-pthreads Notes”
    Section 1.2, “Typographical and Syntax Conventions”

    -h host_name

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    -h localhost

    Section 4.2.3.1, “Using Options on the Command Line”

    -h path

    Section 5.1.2, “Server Command Options”

    -hlocalhost

    Section 4.2.3.1, “Using Options on the Command Line”

    -i

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.1, “mysql Options”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Description
    Description
    Description
    Description
    Description
    Section 6.6.2, “How to Check MyISAM Tables for Errors”
    Section 22.5.1.3, “Using pdb to create a Windows crashdump”

    -i N

    Description

    -i delay

    Description

    -i name

    Description

    -j N

    Description

    -j big_tbl_name

    Description

    -k

    Description

    -k val

    Section 4.6.3.3, “myisamchk Repair Options”

    -l

    Section 4.6.3.3, “myisamchk Repair Options”
    Description
    Description
    Description
    Description
    Section 5.2.3, “The General Query Log”

    -l [file_name]

    Section 5.1.2, “Server Command Options”
    Section 5.2.3, “The General Query Log”

    -l path

    Description

    -lg++

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    -libmysqlclient

    Section 21.9.2, “C API Function Overview”

    -libmysqld

    Section 21.9.2, “C API Function Overview”

    -lm

    Section 21.9.16.1, “Problems Linking with the C API”

    -lmysqlclient

    Section 21.9.3.39, “mysql_library_end()”
    Section 21.9.9, “C API Embedded Server Function Descriptions”

    -lmysqlclient -lz

    Section 21.9.16, “Building Client Programs”

    -lmysqld

    Section 21.9.3.39, “mysql_library_end()”
    Section 21.9.9, “C API Embedded Server Function Descriptions”

    -lz

    Section 21.8.1, “Compiling Programs with libmysqld”
    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    -m

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.5.1.1, “mysql Options”
    Description
    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”

    -m64

    Section 2.3, “MySQL Installation Using a Source Distribution”

    -max

    Section 2.5.5.3, “Selecting a MySQL Server Type”

    -mcpu=v8 -Wa,-xarch=v8plusa

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

    -n

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Description
    Description
    Description
    Description
    Description

    -n N

    Description

    -n file_name

    Description

    -nt

    Section 2.5.5.3, “Selecting a MySQL Server Type”

    -o

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Section 21.8.1, “Compiling Programs with libmysqld”
    Description
    Section 5.1.2, “Server Command Options”

    -o async

    Section 7.6, “Disk Issues”

    -o N

    Description

    -o noatime

    Section 7.6, “Disk Issues”

    -o offset

    Description

    -o udf_example.so

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”

    -p

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 5.5.2, “Adding User Accounts”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 4.2.2, “Connecting to the MySQL Server”
    Section 3.3.1, “Creating and Selecting a Database”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 5.3.2.2, “End-User Guidelines for Password Security”
    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.2.1, “Invoking MySQL Programs”
    Section B.5.2.5, “Password Fails When Entered Interactively”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
    Section 2.5.5.7, “Testing The MySQL Installation”
    Section 2.5.7, “Upgrading MySQL on Windows”
    Section 5.5.1, “User Names and Passwords”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 2.5.8, “Windows Post-Installation Procedures”

    -p N

    Description

    -p len

    Description

    -p num

    Description

    -p password

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    -p[pass_val]

    Section 4.2.2, “Connecting to the MySQL Server”

    -p[password]

    Section 4.5.1.1, “mysql Options”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description

    -ppass_val

    Section 4.2.3.1, “Using Options on the Command Line”

    -ppassword

    Description

    -pyour_pass

    Section 5.3.2.2, “End-User Guidelines for Password Security”

    -q

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Description
    Description
    Description

    -q value

    Description

    -r

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.5.1.1, “mysql Options”
    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Description
    Description
    Description
    Description
    Description
    Section 6.6.3, “How to Repair MyISAM Tables”

    -r -q

    Section 6.6.3, “How to Repair MyISAM Tables”

    -r file_name

    Description

    -r name

    Description

    -r path

    Section 5.1.2, “Server Command Options”

    -rdynamic

    Section 22.3.2, “Adding a New User-Defined Function”

    -s

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 6.6.2, “How to Check MyISAM Tables for Errors”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

    -s at

    Description

    -s file_name

    Description

    -s num

    Description

    -s sort_type

    Description

    -server

    Section 2.6.1, “Installing MySQL from RPM Packages on Linux”

    -signal

    Description

    -skip-auto-rehash

    Section 4.5.1.1, “mysql Options”

    -slow_query_log_file

    Section 5.1.2, “Server Command Options”

    -ss

    Section 4.6.3.1, “myisamchk General Options”

    -static

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

    -t

    Section 4.5.1.1, “mysql Options”
    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Description
    Description
    Description
    Description
    Description
    Description

    -t N

    Description

    -t path

    Section 4.6.3.3, “myisamchk Repair Options”
    Description
    Section 5.1.2, “Server Command Options”

    -u

    Section 4.6.3.3, “myisamchk Repair Options”
    Description
    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 2.5.5.7, “Testing The MySQL Installation”
    Section 5.5.1, “User Names and Passwords”

    -u root

    Section 2.5.8, “Windows Post-Installation Procedures”

    -u {user_name|user_id}

    Section 5.1.2, “Server Command Options”

    -u root

    Section 2.5.8, “Windows Post-Installation Procedures”

    -u user_name

    Section 4.5.1.1, “mysql Options”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    -v

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.5, “myisamchk Table Information”
    Section 4.5.1.1, “mysql Options”
    Section 4.6.7.2, “mysqlbinlog Row Event Display”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 6.6.2, “How to Check MyISAM Tables for Errors”
    Section 5.1.2, “Server Command Options”
    Section 4.2.3.1, “Using Options on the Command Line”

    -v -v -v

    Section 4.5.1.1, “mysql Options”

    -vv

    Section 4.6.3.1, “myisamchk General Options”

    -vvv

    Section 4.6.3.1, “myisamchk General Options”

    -w

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.5.1.1, “mysql Options”
    Description

    -w 'where_condition'

    Description

    -w write_file

    Description

    -w[count]

    Description

    -x

    Description

    -x N

    Description

    -y

    Description

    -y N

    Description

    -–ndb-log-update-as-write=OFF

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    -–ndb-log-updated-only

    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”

    /3GB

    Section D.7.3, “Windows Platform Limitations”

    /i

    Section 2.5.3.2, “Installing MySQL Automatically using MSI”

    /passive

    Section 2.5.3.2, “Installing MySQL Automatically using MSI”

    /quiet

    Section 2.5.3.2, “Installing MySQL Automatically using MSI”

    /uninstall

    Section 2.5.3.2, “Installing MySQL Automatically using MSI”

    /x

    Section 2.5.3.2, “Installing MySQL Automatically using MSI”

    Aborted_connects

    Section B.5.2.11, “Communication Errors and Aborted Connections”

    Arbitration

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 17.1.4, “MySQL Cluster Development History”

    ArbitrationDelay

    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”

    ArbitrationRank

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.1”

    ArbitrationTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    AutoReconnect

    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

    BackupDataBufferSize

    Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.5.3.4, “MySQL Cluster Backup Troubleshooting”

    BackupDataDir

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    BackupLogBufferSize

    Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.5.3.4, “MySQL Cluster Backup Troubleshooting”

    BackupMaxWriteSize

    Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    BackupMemory

    Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.5.3.4, “MySQL Cluster Backup Troubleshooting”

    BackupReportFrequency

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4, “MySQL Cluster Development History”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

    BackupWriteSize

    Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    BatchByteSize

    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

    BatchSize

    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

    BatchSizePerLocalScan

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    Checksum

    Section 12.4.5.38, “SHOW TABLE STATUS Syntax”
    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”
    Section 20.2, “The INFORMATION_SCHEMA TABLES Table”

    Com_dealloc_sql

    Section 5.1.6, “Server Status Variables”

    Com_delete

    Section 5.1.6, “Server Status Variables”

    Com_execute_sql

    Section 5.1.6, “Server Status Variables”

    Com_insert

    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
    Section 5.1.6, “Server Status Variables”

    Com_prepare_sql

    Section 5.1.6, “Server Status Variables”

    Com_select

    Section 7.5.5.1, “How the Query Cache Operates”
    Section 7.5.5.4, “Query Cache Status and Maintenance”
    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
    Section 5.1.6, “Server Status Variables”

    Com_stmt_close

    Section 5.1.6, “Server Status Variables”

    Com_stmt_execute

    Section 5.1.6, “Server Status Variables”

    Com_stmt_fetch

    Section 5.1.6, “Server Status Variables”

    Com_stmt_prepare

    Section 5.1.6, “Server Status Variables”

    Com_stmt_reprepare

    Section 12.6.4, “Automatic Prepared Statement Repreparation”
    Section 5.1.6, “Server Status Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    Com_stmt_reset

    Section 5.1.6, “Server Status Variables”

    Com_stmt_send_long_data

    Section 5.1.6, “Server Status Variables”

    CompressedBackup

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    CompressedLCP

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    DataDir

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Description
    Section 17.5.4, “Event Reports Generated in MySQL Cluster”
    Section 17.5, “Management of MySQL Cluster”
    Section 17.5.10.1, “MySQL Cluster Disk Data Objects”
    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
    Section 17.3.1, “Quick Test Setup of MySQL Cluster”
    Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”
    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    DataMemory

    Section B.5.2.12, “The table is full”
    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.5.10.3, “MySQL Cluster Disk Data Storage Requirements”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 17.5.8.6, “The ndbinfo memoryusage Table”

    DiskCheckpointSpeed

    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    DiskCheckpointSpeedInRestart

    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    DiskIOThreadPool

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    DiskPageBufferMemory

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    DiskSyncSize

    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    Diskless

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ExecuteOnComputer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”

    FileSystemPath

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    FileSystemPathDD

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”

    FileSystemPathDataFiles

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”

    FileSystemPathUndoFiles

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”

    FragmentLogFileSize

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    HELP

    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Help-Table Metadata

    HeartbeatIntervalDbApi

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    HeartbeatIntervalDbDb

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    HeartbeatThreadPriority

    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

    Host1SciId0

    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    Host1SciId1

    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    Host2SciId0

    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    Host2SciId1

    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    HostName

    Section 17.3.2.4, “Defining Computers in a MySQL Cluster”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 17.2, “MySQL Cluster Multi-Computer How-To”
    Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”
    Section 17.3.1, “Quick Test Setup of MySQL Cluster”

    Id

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 12.4.5.5, “SHOW COLLATION Syntax”
    Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
    Section 21.9.1, “C API Data Structures”
    Section 9.4.2, “Choosing a Collation ID”
    Section 17.3.2.4, “Defining Computers in a MySQL Cluster”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 7.5.6, “Examining Thread Information”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
    Section 20.10, “The INFORMATION_SCHEMA COLLATIONS Table”
    Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

    IndexMemory

    Section B.5.2.12, “The table is full”
    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.5.8.6, “The ndbinfo memoryusage Table”

    InitFragmentLogFiles

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    InitialLogFileGroup

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    InitialNoOfOpenFiles

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    InitialTablespace

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    LockExecuteThreadToCPU

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LockMaintThreadsToCPU

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LockPagesInMainMemory

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogDestination

    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 17.5.4, “Event Reports Generated in MySQL Cluster”
    Section 17.5, “Management of MySQL Cluster”

    LogLevelCheckpoint

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelCongestion

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelConnection

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelError

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelInfo

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelNodeRestart

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelShutdown

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelStartup

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LogLevelStatistic

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    LongMessageBuffer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxAllocate

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

    MaxBufferedEpochs

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

    MaxLCPStartDelay

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfAttributes

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfConcurrentIndexOperations

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfConcurrentOperations

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”

    MaxNoOfConcurrentScans

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfConcurrentSubOperations

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfConcurrentTransactions

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfExecutionThreads

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    MaxNoOfFiredTriggers

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfLocalOperations

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”

    MaxNoOfLocalScans

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfOpenFiles

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfOrderedIndexes

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”

    MaxNoOfSavedMessages

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfSubscribers

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfSubscriptions

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfTables

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”

    MaxNoOfTriggers

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    MaxNoOfUniqueHashIndexes

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”

    MaxScanBatchSize

    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

    MemReportFrequency

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    Name

    Section 12.4.5.1, “SHOW AUTHORS Syntax”
    Section 12.4.5.7, “SHOW CONTRIBUTORS Syntax”
    Section 12.4.5.16, “SHOW ENGINE Syntax”
    Section 12.4.5.19, “SHOW EVENTS Syntax”
    Section 12.4.5.27, “SHOW PLUGINS Syntax”
    Section 12.4.5.38, “SHOW TABLE STATUS Syntax”
    Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
    Section 20.17, “The INFORMATION_SCHEMA PLUGINS Table”
    Section 17.5.8, “The ndbinfo MySQL Cluster Information Database”

    Ndb_cluster_node_id

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

    NoOfDiskPagesToDiskAfterRestartACC

    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    NoOfDiskPagesToDiskAfterRestartTUP

    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    NoOfDiskPagesToDiskDuringRestartACC

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    NoOfDiskPagesToDiskDuringRestartTUP

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    NoOfFragmentLogFiles

    Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.5.1, “Summary of MySQL Cluster Start Phases”

    NoOfReplicas

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”

    NodeGroup

    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    NodeId1

    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    NodeId2

    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    ODirect

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ON

    Section 3.3.4.9, “Using More Than one Table”

    OverloadLimit

    Section 17.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”

    PortNumber

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”

    Queries

    Section 5.1.6, “Server Status Variables”

    Questions

    Section 5.1.6, “Server Status Variables”

    RealtimeScheduler

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    ReceiveBufferMemory

    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”

    RedoBuffer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ReservedSendBufferMemory

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    RestartOnErrorInsert

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    SchedulerExecutionTimer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    SchedulerSpinTimer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    SendBufferMemory

    Section 17.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”

    SendLimit

    Section 17.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    SendSignalId

    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    ServerPort

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    SharedBufferSize

    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”

    SharedGlobalMemory

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ShmKey

    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”

    ShmSize

    Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”

    Slave_running

    Section 5.1.6, “Server Status Variables”

    StartFailureTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    StartPartialTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Description

    StartPartitionedTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Description

    StartupStatusReportFrequency

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    StopOnError

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    MySQL 4.1 FAQ: MySQL Cluster

    StringMemory

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TcpBind_INADDR_ANY

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    Text in this style

    Section 1.2, “Typographical and Syntax Conventions”

    TimeBetweenEpochs

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

    TimeBetweenEpochsTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

    TimeBetweenGlobalCheckpoints

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TimeBetweenInactiveTransactionAbortCheck

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TimeBetweenLocalCheckpoints

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TimeBetweenWatchDogCheck

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TimeBetweenWatchDogCheckInitial

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TotalSendBufferMemory

    Section 17.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”

    TransactionBufferMemory

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    TransactionDeadlockDetectionTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 16.4.1.25, “Replication Retries and Timeouts”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    TransactionInactiveTimeout

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 16.4.1.25, “Replication Retries and Timeouts”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    UndoDataBuffer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    UndoIndexBuffer

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    \G

    Section 4.5.1.1, “mysql Options”
    Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Description
    Section 1.7, “How to Report Bugs or Problems”
    Section 5.1.4, “Server System Variables”

    \P

    Section 4.5.1.2, “mysql Commands”

    \c

    Section 4.5.1.2, “mysql Commands”
    Section 3.2, “Entering Queries”

    \q

    Section 4.5.1.1, “mysql Options”
    Section 3.1, “Connecting to and Disconnecting from the Server”

    \s

    Section 4.5.1.2, “mysql Commands”
    Section 4.2.3.3, “Using Option Files”
    Section 5.5.6.2, “Using SSL Connections”

    \t

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 8.1.1, “Strings”
    Section 4.2.3.3, “Using Option Files”

    \w

    Section 4.5.1.2, “mysql Commands”

    all

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 7.2.1, “Optimizing Queries with EXPLAIN”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 2.3.2, “Typical configure Options”

    analyze

    Section 12.4.2.1, “ANALYZE TABLE Syntax”

    ansi

    Description

    auto_increment_increment

    Section 16.1.3.2, “Replication Master Options and Variables”

    auto_increment_offset

    Section 16.1.3.2, “Replication Master Options and Variables”

    automatic_sp_privileges

    Section 12.1.26, “DROP PROCEDURE and DROP FUNCTION Syntax”

    backup

    Section 12.4.2.2, “BACKUP TABLE Syntax”

    basedir

    Section 2.5.4.13, “Creating an Instance from the Command Line”
    Section 2.5.5.2, “Creating an Option File”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”

    c

    Section 12.1.7, “ALTER TABLE Syntax”
    Section 12.1.17, “CREATE TABLE Syntax”
    Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
    Description
    Section 8.2.1, “Identifier Qualifiers”
    Section 3.3.4.7, “Pattern Matching”
    Section 11.4.2, “Regular Expressions”
    Section 9.1.13.1, “Unicode Character Sets”

    character_set_client

    Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

    character_set_connection

    Section 9.1.7.4, “Collation of Expressions”

    charset

    Section 9.1.4, “Connection Character Sets and Collations”

    check

    Section 12.4.2.3, “CHECK TABLE Syntax”
    Section 22.2.4.3, “Plugin Status and System Variables”

    col

    Section 16.1.3.2, “Replication Master Options and Variables”

    collation_connection

    Section 9.1.7.4, “Collation of Expressions”
    Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

    compress

    Section 21.9.3.49, “mysql_options()”
    Section B.5.3.1, “Problems Linking to the MySQL Client Library”

    connect

    Section B.5.3.1, “Problems Linking to the MySQL Client Library”

    connect_timeout

    Section 4.5.1.1, “mysql Options”
    Description

    count

    Section 12.4.5.16, “SHOW ENGINE Syntax”
    Section 8.2.4, “Function Name Parsing and Resolution”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    Section 5.1.7, “Server SQL Modes”

    csv

    Section 2.3.2, “Typical configure Options”

    d

    Section 12.1.7, “ALTER TABLE Syntax”
    Section 7.2.9, “LEFT JOIN and RIGHT JOIN Optimization”
    Section 11.4.2, “Regular Expressions”
    Section 22.5.3, “The DBUG Package”
    Section 9.1.13.1, “Unicode Character Sets”

    daemon

    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”

    data

    Section 21.9.7.25, “mysql_stmt_send_long_data()”
    Section 18.3.1, “Management of RANGE and LIST Partitions”
    Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
    Section 12.3.7.1, “XA Transaction SQL Syntax”

    datadir

    Section 2.5.5.2, “Creating an Option File”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
    Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
    Section D.7.3, “Windows Platform Limitations”

    date

    Section 11.6, “Date and Time Functions”

    db

    Section 12.4.1.3, “GRANT Syntax”
    Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
    Section 21.9.3.3, “mysql_change_user()”
    Section 21.9.3.8, “mysql_create_db()”
    Section 21.9.3.11, “mysql_drop_db()”
    Section 21.9.3.52, “mysql_real_connect()”
    Section 21.9.3.60, “mysql_select_db()”
    Section 5.4.5, “Access Control, Stage 2: Request Verification”
    Section 5.5.2, “Adding User Accounts”
    Section 21.9.1, “C API Data Structures”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Description
    Section 7.5.6, “Examining Thread Information”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section D.6, “Restrictions on Character Sets”
    Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”
    Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
    Section 2.13.1, “Unix Post-Installation Procedures”

    debug

    Section 21.9.3.49, “mysql_options()”
    Description

    decode_bits

    Section 4.6.3.1, “myisamchk General Options”

    default-storage-engine

    Section 13.3, “Setting the Storage Engine”
    Chapter 13, Storage Engines

    default-table-type

    Chapter 13, Storage Engines

    defaults-extra-file

    Section 4.2.3.3, “Using Option Files”

    delimiter

    Section 12.1.11, “CREATE EVENT Syntax”
    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 19.1, “Defining Stored Programs”

    description

    Section 12.8.3, “HELP Syntax”

    e

    Section B.5.5.1, “Case Sensitivity in String Searches”
    Section 21.2.4.8, “Tutorial: Using MySqlScript”

    exit

    Section 22.5.3, “The DBUG Package”

    extended-status

    Description

    fields

    Section 13.6.13.2.3, “InnoDB Table Monitor Output”

    flush-backup-logs

    Description

    flush-hosts

    Section 12.4.6.3, “FLUSH Syntax”
    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    flush-logs

    Section 12.4.6.3, “FLUSH Syntax”
    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    flush-privileges

    Section 12.4.6.3, “FLUSH Syntax”
    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    flush-status

    Section 12.4.6.3, “FLUSH Syntax”
    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    flush-tables

    Section 12.4.6.3, “FLUSH Syntax”
    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    flush-threads

    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    ft_max_word_len

    Section 4.6.3.1, “myisamchk General Options”

    ft_min_word_len

    Section 4.6.3.1, “myisamchk General Options”

    ft_stopword_file

    Section 4.6.3.1, “myisamchk General Options”

    gci

    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”

    general_log

    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.4, “Server System Variables”

    have_partition_engine

    Chapter 18, Partitioning
    Section 5.1.4, “Server System Variables”

    have_profiling

    Section 5.1.4, “Server System Variables”

    help

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.3, “mysql Server-Side Help”
    Section 1.5, “What Is New in MySQL 5.1”

    host

    Section 12.4.1.3, “GRANT Syntax”
    Section 21.9.3.7, “mysql_connect()”
    Section 21.9.3.52, “mysql_real_connect()”
    Section 5.4.5, “Access Control, Stage 2: Request Verification”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 3.1, “Connecting to and Disconnecting from the Server”
    Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Description
    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section 2.13.1, “Unix Post-Installation Procedures”

    ibmdb2i_assume_exclusive_use

    Section 13.7.2, “Configuration Options”

    ibmdb2i_async_enabled

    Section 13.7.2, “Configuration Options”

    ibmdb2i_compat_opt_allow_zero_date_vals

    Section 13.7.2, “Configuration Options”
    Section 13.7.7, “Notes and Limitations”

    ibmdb2i_compat_opt_blob_cols

    Section 13.7.2, “Configuration Options”

    ibmdb2i_compat_opt_time_as_duration

    Section 13.7.2, “Configuration Options”

    ibmdb2i_compat_opt_year_as_int

    Section 13.7.2, “Configuration Options”

    ibmdb2i_create_index_option

    Section 13.7.2, “Configuration Options”

    ibmdb2i_create_time_columns_as_tod

    Section 13.7.2, “Configuration Options”

    ibmdb2i_lob_alloc_size

    Section 13.7.2, “Configuration Options”

    ibmdb2i_map_blob_to_varchar

    Section 13.7.2, “Configuration Options”

    ibmdb2i_max_read_buffer_size

    Section 13.7.2, “Configuration Options”

    ibmdb2i_max_write_buffer_size

    Section 13.7.2, “Configuration Options”

    ibmdb2i_propagate_default_col_val

    Section 13.7.2, “Configuration Options”

    ibmdb2i_propagate_default_col_vals

    Section 13.7.2, “Configuration Options”

    ibmdb2i_rdb_name

    Section 13.7.2, “Configuration Options”
    Section 13.7.7, “Notes and Limitations”

    ibmdb2i_system_trace_level

    Section 13.7.2, “Configuration Options”

    ibmdb2i_transaction_unsafe

    Section 13.7.2, “Configuration Options”

    ignore-builtin-innodb

    Section 13.6, “The InnoDB Storage Engine”

    init-file

    Section 7.4.5.2, “Multiple Key Caches”

    initial

    Section 17.5.5.1, “MySQL Cluster: Messages in the Cluster Log”

    innodb

    Section 5.1.3, “Server Options for Loading Plugins”
    Section 13.6, “The InnoDB Storage Engine”

    innodb-safe-binlog

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 16.1.1, “How to Set Up Replication”

    innodb-status-file=1

    Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”

    innodb_file_per_table

    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 13.6.11.2, “File Space Management”
    Section 5.1.2, “Server Command Options”

    innodb_support_xa

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_table_locks

    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    interactive_timeout

    Section 21.2.6, “Connector/NET Connection String Options Reference”

    key_buffer_size

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.3, “myisamchk Repair Options”

    language

    Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

    ledir

    Description
    Description

    length

    Section 21.9.3.34, “mysql_hex_string()”
    Section 21.9.3.53, “mysql_real_escape_string()”
    Section 21.9.3.54, “mysql_real_query()”
    Section 21.9.7.11, “mysql_stmt_fetch()”
    Section 21.9.7.20, “mysql_stmt_prepare()”
    Section 21.9.7.25, “mysql_stmt_send_long_data()”
    Section 21.9.1, “C API Data Structures”
    Section 21.9.5, “C API Prepared Statement Data Structures”
    Section 22.2.4.2.1, “Full-Text Parser Plugin Data Structures and Functions”
    Section 22.2.5, “Writing Plugins”

    local

    Section 5.1.5.1, “Structured System Variables”

    local-infile

    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

    log

    Section 2.3.3, “Installing from the Development Source Tree”

    log-bin

    Section 16.1.1, “How to Set Up Replication”

    log-slave-updates

    Section 17.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”

    log_backup_output

    Section 5.1.4, “Server System Variables”

    log_bin_trust_routine_creators

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 19.7, “Binary Logging of Stored Programs”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.4, “Server System Variables”

    max_allowed_packet

    Section 4.5.1.1, “mysql Options”
    Description
    Section 16.4.1.17, “Replication and max_allowed_packet”
    Section 4.2.3.4, “Using Options to Set Program Variables”

    max_connections

    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.5.4, “Setting Account Resource Limits”

    max_user_connections

    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.5.4, “Setting Account Resource Limits”

    multi_range_count

    Section 17.3.4.3, “MySQL Cluster System Variables”
    Section 5.1.4, “Server System Variables”

    myisam_block_size

    Section 4.6.3.1, “myisamchk General Options”

    myisam_max_extra_sort_file_size

    Section 1.5, “What Is New in MySQL 5.1”

    myisam_stats_method

    Section 4.6.3.1, “myisamchk General Options”

    myisamchk

    Description
    Section 4.6.3.4, “Other myisamchk Options”

    mysql

    Section 4.5.1.1, “mysql Options”
    Section 4.5.1.3, “mysql Server-Side Help”
    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 12.1.16, “CREATE SERVER Syntax”
    Section 12.4.1.1, “CREATE USER Syntax”
    Section B.5.2.4, “Client does not support authentication protocol”
    Section 12.4.3.3, “DROP FUNCTION Syntax”
    Section 12.4.1.2, “DROP USER Syntax”
    Section 12.4.6.3, “FLUSH Syntax”
    Section 12.4.1.3, “GRANT Syntax”
    Section 12.8.3, “HELP Syntax”
    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section B.5.2.9, “MySQL server has gone away”
    Section 12.4.1.4, “RENAME USER Syntax”
    Section 12.4.1.5, “REVOKE Syntax”
    Section 12.4.1.6, “SET PASSWORD Syntax”
    Section 12.4.5.22, “SHOW GRANTS Syntax”
    Section 21.9.3.3, “mysql_change_user()”
    Section 21.9.3.5, “mysql_close()”
    Section 21.9.3.14, “mysql_errno()”
    Section 21.9.3.15, “mysql_error()”
    Section 21.9.3.33, “mysql_get_ssl_cipher()”
    Section 21.9.3.36, “mysql_init()”
    Section 21.9.3.53, “mysql_real_escape_string()”
    Section 21.9.3.60, “mysql_select_db()”
    Section 21.9.3.67, “mysql_ssl_set()”
    Section 21.9.7.10, “mysql_stmt_execute()”
    Section 21.9.7.11, “mysql_stmt_fetch()”
    Section 21.9.7.25, “mysql_stmt_send_long_data()”
    Section 5.4.4, “Access Control, Stage 1: Connection Verification”
    Section 12.4.1, “Account Management Statements”
    Section 5.5.2, “Adding User Accounts”
    Section 5.3.2.1, “Administrator Guidelines for Password Security”
    Section 5.5.5, “Assigning Account Passwords”
    Section 6.3.1, “Backup Policy”
    Section 21.9.14, “C API Prepared Statement Handling of Date and Time Values”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 9.1.4, “Connection Character Sets and Collations”
    Chapter 21, Connectors and APIs
    Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 3.3, “Creating and Using a Database”
    Section 8.2, “Schema Object Names”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Description
    Description
    Description
    Description
    Section 2.4.2, “Downgrading MySQL”
    Section 7.5.9, “Enabling Large Page Support”
    Section 5.3.1, “General Security Guidelines”
    Section 7.5.5.1, “How the Query Cache Operates”
    Section 16.1.1, “How to Set Up Replication”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 2.8, “Installing MySQL on Solaris”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 5.2.4.4, “Logging Format for Changes to mysql Database Tables”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 17.3.4.3, “MySQL Cluster System Variables”
    Section 17.5.9.2, “MySQL Cluster and MySQL Privileges”
    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”
    Section 21.10, “MySQL PHP API”
    Section 9.6, “MySQL Server Time Zone Support”
    Section 12.3.5.3, “Other Table-Locking Notes”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.3.2.3, “Password Hashing in MySQL”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section 16.4.4, “Replication FAQ”
    Section 16.4.1.10, “Replication and FLUSH”
    Section 16.4.1.20, “Replication of the mysql System Database”
    Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
    Section 13.6.14, “Restrictions on InnoDB Tables”
    Section D.6, “Restrictions on Character Sets”
    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.1.8, “Server-Side Help”
    Section 5.5.4, “Setting Account Resource Limits”
    Section 2.3.1, “Source Installation Overview”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 12.3.3, “Statements That Cause an Implicit Commit”
    Section 9.6.1, “Staying Current with Time Zone Changes”
    Section 5.4, “The MySQL Access Privilege System”
    Section 22.2, “The MySQL Plugin API”
    Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 2.4.1, “Upgrading MySQL”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 5.5.1, “User Names and Passwords”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”
    Section 5.5.6.2, “Using SSL Connections”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
    Section 19.2, “Using Stored Routines (Procedures and Functions)”
    Section 2.5.8, “Windows Post-Installation Procedures”

    mysql-server

    Chapter 17, MySQL Cluster NDB 6.X/7.X

    mysqlaccess

    Description

    mysqladmin

    Section 9.1.4, “Connection Character Sets and Collations”
    Description

    mysqlbinlog

    Section 12.4.5.3, “SHOW BINLOG EVENTS Syntax”
    Description
    Section 5.2.4, “The Binary Log”

    mysqlcheck

    Section 9.1.4, “Connection Character Sets and Collations”
    Description

    mysqld

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 21.9.2, “C API Function Overview”
    Description
    Description
    Section 13.11.1, “FEDERATED Storage Engine Overview”
    Section 2.9, “Installing MySQL on i5/OS”
    Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
    Section 4.6.10.7, “MySQL Instance Manager Commands”
    Section 5.1.1, “Server Option and Variable Reference”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
    Section 5.2.2, “The Error Log”
    Section 16.2.2.2, “The Slave Status Files”
    Section 22.5.1.3, “Using pdb to create a Windows crashdump”

    mysqld-path

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    mysqld-path=path-to-mysqld-binary

    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    mysqld_safe

    Description
    Description
    Section 5.2.2, “The Error Log”

    mysqldump

    Description

    mysqldumpslow

    Description

    mysqlhotcopy

    Description

    mysqlimport

    Section 9.1.4, “Connection Character Sets and Collations”
    Description

    mysqlshow

    Section 9.1.4, “Connection Character Sets and Collations”
    Description

    mysqlslap

    Description

    ndb-connectstring

    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.2.2, “MySQL Cluster Multi-Computer Configuration”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    Section 17.6.5, “Preparing the MySQL Cluster for Replication”

    ndb_autoincrement_prefetch_sz

    Section 17.3.4.3, “MySQL Cluster System Variables”

    ndb_log_bin

    Section 17.3.4.3, “MySQL Cluster System Variables”

    ndb_log_binlog_index

    Section 17.3.4.3, “MySQL Cluster System Variables”

    ndb_optimization_delay

    Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”

    ndb_table_no_logging

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    ndb_table_temporary

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

    net_retry_count

    Section 16.2.1, “Replication Implementation Details”

    net_write_timeout

    Section 16.2.1, “Replication Implementation Details”

    nice

    Description

    nodes

    Section 17.5.8.7, “The ndbinfo nodes Table”

    nonguarded

    Description

    offset

    Section 21.9.3.9, “mysql_data_seek()”
    Section 21.9.3.23, “mysql_field_seek()”
    Section 21.9.3.58, “mysql_row_seek()”
    Section 21.9.7.7, “mysql_stmt_data_seek()”
    Section 21.9.7.12, “mysql_stmt_fetch_column()”
    Section 21.9.7.23, “mysql_stmt_row_seek()”

    old-alter-table

    Section 12.1.7, “ALTER TABLE Syntax”

    open-files-limit

    Section B.5.2.7, “Too many connections”

    open_files_limit

    Description
    Section D.7.3, “Windows Platform Limitations”

    opt

    Section 22.2.4.3, “Plugin Status and System Variables”

    optimize

    Section 12.4.2.5, “OPTIMIZE TABLE Syntax”

    p

    Section 12.2.1, “CALL Syntax”
    Section 18.2.6, “How MySQL Partitioning Handles NULL”
    Section 19.2.1, “Stored Routine Syntax”
    Section 22.5.3, “The DBUG Package”

    partition

    Chapter 18, Partitioning

    password

    Description

    performance_schema

    Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
    Section 12.4.5.16, “SHOW ENGINE Syntax”
    Description
    Section 7.5.5.1, “How the Query Cache Operates”

    pid-file

    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 5.2.4, “The Binary Log”

    ping

    Description
    Section 16.4.5, “Troubleshooting Replication”

    pipe

    Section 21.9.3.49, “mysql_options()”
    Section 21.2.6, “Connector/NET Connection String Options Reference”

    plugin

    Section 12.4.3.4, “INSTALL PLUGIN Syntax”
    Section 22.2.2, “Plugin API Components”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 22.2, “The MySQL Plugin API”

    plugin-load

    Section 13.6, “The InnoDB Storage Engine”

    port

    Section 21.9.3.52, “mysql_real_connect()”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    print

    Section 11.4.2, “Regular Expressions”

    processlist

    Description

    prompt

    Section 4.5.1.2, “mysql Commands”

    purge-backup-logs

    Description

    query_cache_type

    Section 5.1.4, “Server System Variables”

    quick

    Section 4.2.3.3, “Using Option Files”

    quit

    Section 4.5.1.1, “mysql Options”

    raw

    Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”

    read_buffer_size

    Section 4.6.3.1, “myisamchk General Options”

    reconnect

    Section B.5.2.9, “MySQL server has gone away”
    Section 21.9.3.52, “mysql_real_connect()”
    Section 21.9.2, “C API Function Overview”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    record_buffer

    Section 7.5.8, “How MySQL Uses Memory”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.4, “Server System Variables”
    Section 7.5.3, “Tuning Server Parameters”

    refresh

    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    rehash

    Section 4.5.1.1, “mysql Options”
    Section B.5.8.1, “Open Issues in MySQL”

    reload

    Description
    Section 5.4.1, “Privileges Provided by MySQL”

    repair

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    replication-ignore-table

    Section 16.4.1.29, “Replication and Views”

    resolve_stack_dump

    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    rows

    Section 18.3.4, “Obtaining Information About Partitions”
    Section 7.2.1, “Optimizing Queries with EXPLAIN”

    s

    Description
    Section 11.4.2, “Regular Expressions”
    Section 9.1.13.1, “Unicode Character Sets”

    select_limit

    Section 4.5.1.1, “mysql Options”

    server-id

    Section 16.1.1, “How to Set Up Replication”
    Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
    Section 16.1.3.2, “Replication Master Options and Variables”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.1.1.8, “Setting Up Replication with Existing Data”
    Section 16.1.1.1, “Setting the Replication Master Configuration”
    Section 16.1.1.2, “Setting the Replication Slave Configuration”

    server-id=3

    Section 16.1.3.3, “Replication Slave Options and Variables”

    server-id=id

    Section 17.6.2, “MySQL Cluster Replication: Assumptions and General Requirements”

    set-variable

    Section 4.2.3.3, “Using Option Files”

    set-variable=option=value

    Section 4.2.3.4, “Using Options to Set Program Variables”

    shutdown

    Description

    shutdown_timeout

    Description

    skip-innodb

    Section 13.6.2, “InnoDB Configuration”

    skip-networking

    Section 16.4.4, “Replication FAQ”
    Section 16.1.1.1, “Setting the Replication Master Configuration”
    Section 16.4.5, “Troubleshooting Replication”

    skip-slave-start

    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
    Section 17.6.5, “Preparing the MySQL Cluster for Replication”
    Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

    slave

    Section 1.2, “Typographical and Syntax Conventions”

    slave_type_conversions

    Section 16.4.1.6.2, “Replication of Columns Having Different Data Types”

    slow_query_log

    Section 5.1.4, “Server System Variables”

    socket

    Section 21.2.6, “Connector/NET Connection String Options Reference”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”

    sort

    Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”

    sort_buffer_size

    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.3, “myisamchk Repair Options”

    sort_key_blocks

    Section 4.6.3.1, “myisamchk General Options”

    source

    Section 4.5.1.4, “Executing SQL Statements from a Text File”
    Section 6.4.2, “Reloading SQL-Format Backups”
    Section 3.5, “Using mysql in Batch Mode”

    sql-mode=""

    Section 5.1.7, “Server SQL Modes”

    sql-mode="modes"

    Section 5.1.7, “Server SQL Modes”

    sql_big_tables

    Section B.5.2.12, “The table is full”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 5.1.4, “Server System Variables”

    sql_log_update

    Section 1.5, “What Is New in MySQL 5.1”

    sql_low_priority_updates

    Section 5.1.4, “Server System Variables”

    sql_max_join_size

    Section 5.1.4, “Server System Variables”

    ssl_cipher

    Section 5.5.2, “Adding User Accounts”
    Section 5.4.2, “Privilege System Grant Tables”

    start-slave

    Description

    stats_method

    Section 4.6.3.1, “myisamchk General Options”

    status

    Section 4.5.1.2, “mysql Commands”
    Section 12.4.2.1, “ANALYZE TABLE Syntax”
    Section 12.4.2.2, “BACKUP TABLE Syntax”
    Section 12.4.2.3, “CHECK TABLE Syntax”
    Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
    Section 12.4.2.6, “REPAIR TABLE Syntax”
    Section 12.4.2.7, “RESTORE TABLE Syntax”
    Description
    Section 17.5.6, “MySQL Cluster Single User Mode”
    Section 4.6.10.5, “MySQL Server Instance Status Monitoring”
    Section 17.5.8.7, “The ndbinfo nodes Table”
    Section 17.5.8.10, “The ndbinfo transporters Table”

    stop-slave

    Description

    syslog

    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Description
    Section 17.5.4, “Event Reports Generated in MySQL Cluster”
    Section 17.5.4.1, “MySQL Cluster Logging Management Commands”
    Section 5.2.2, “The Error Log”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    system

    Chapter 20, INFORMATION_SCHEMA Tables

    tab

    Section 11.4.2, “Regular Expressions”

    table

    Section 21.9.1, “C API Data Structures”
    Section 7.2.1, “Optimizing Queries with EXPLAIN”
    Section 12.2.9.8, “Subqueries in the FROM Clause”

    table_type

    Section 1.5, “What Is New in MySQL 5.1”

    test

    Section 12.2.2, “DELETE Syntax”
    Section 7.2.20, “INFORMATION_SCHEMA Optimization”
    Section 13.6.13.2.3, “InnoDB Table Monitor Output”
    Section 12.4.5.19, “SHOW EVENTS Syntax”
    Section 9.1.7.8, “Collation and INFORMATION_SCHEMA Searches”
    Section 11.3, “Control Flow Functions”
    Section 13.6.4, “Creating and Using InnoDB Tables”
    Section 3.3, “Creating and Using a Database”
    Description
    Description
    Section 6.4.5.4, “Dumping Table Definitions and Content Separately”
    Section 3.6, “Examples of Common Queries”
    Section 8.2.4, “Function Name Parsing and Resolution”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 19.2.1, “Stored Routine Syntax”
    Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 2.5.8, “Windows Post-Installation Procedures”

    timeout

    Section 21.9.3.49, “mysql_options()”

    tmpdir

    Section 2.5, “Installing MySQL on Windows”

    type

    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 13.6.13.2.3, “InnoDB Table Monitor Output”
    Section 21.9.1, “C API Data Structures”
    Section 22.2.4.2.1, “Full-Text Parser Plugin Data Structures and Functions”
    Section 22.2.4.1, “General Plugin Data Structures and Functions”
    Section 7.2.19, “How to Avoid Table Scans”
    Section 7.2.6, “Index Merge Optimization”
    Section 7.2.1, “Optimizing Queries with EXPLAIN”
    Section 22.2.4.3, “Plugin Status and System Variables”
    Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”

    update

    Section 7.5.6.3, “Delayed-Insert Thread States”
    Description
    Section 22.2.4.3, “Plugin Status and System Variables”

    use-manager

    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    user

    Section 12.4.1.2, “DROP USER Syntax”
    Section B.5.2.15, “Ignoring user”
    Section 21.9.3.49, “mysql_options()”
    Section 21.9.3.52, “mysql_real_connect()”
    Section 5.4.4, “Access Control, Stage 1: Connection Verification”
    Section 5.4.5, “Access Control, Stage 2: Request Verification”
    Section 5.5.2, “Adding User Accounts”
    Section 5.3.2.1, “Administrator Guidelines for Password Security”
    Section 5.5.5, “Assigning Account Passwords”
    Section 5.5.8, “Auditing MySQL Account Activity”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 3.1, “Connecting to and Disconnecting from the Server”
    Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Description
    Section 11.11.2, “Encryption and Compression Functions”
    Section 5.3.1, “General Security Guidelines”
    Section 5.3.6, “How to Run MySQL as a Normal User”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 5.3.2.3, “Password Hashing in MySQL”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section D.6, “Restrictions on Character Sets”
    Section 5.1.2, “Server Command Options”
    Section 5.5.4, “Setting Account Resource Limits”
    Section 5.4.3, “Specifying Account Names”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 5.5.1, “User Names and Passwords”
    Section 5.5.6.2, “Using SSL Connections”
    Section 11.10, “XML Functions”

    v

    Section 12.1.20, “CREATE VIEW Syntax”
    Section 16.4.1.11, “Replication and System Functions”

    variables

    Description

    version

    Description
    Section 22.2.4.1, “General Plugin Data Structures and Functions”

    wait_timeout

    Section 21.2.6, “Connector/NET Connection String Options Reference”

    write

    Section 22.5.4, “Comments about RTS Threads”
    Description

    write_buffer_size

    Section 4.6.3.1, “myisamchk General Options”