Option Index

-

Section 12.1.1, “ALTER DATABASE Syntax”
Section 11.18.2, “DECIMAL Data Type Changes”
Section 12.7.1.3, “GRANT Syntax”
Section 11.6.1, “Arithmetic Operators”
Section 11.9.2, “Boolean Full-Text Searches”
Section 10.6, “Choosing the Right Type for a Column”
Section 11.7, “Date and Time Functions”
Section 10.2.2, “Fixed-Point Types (Exact Value)”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 8.1.2, “Number Literals”
Section 10.1.1, “Numeric Type Overview”
Section 11.5.2, “Regular Expressions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 5.4.3, “Specifying Account Names”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
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 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 15.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-drop-trigger

Description

--add-locks

Description

--addtodest

Description

--all

Section 1.4, “What Is New in MySQL 5.5”

--all-databases

Description
Description
Description
Section 2.11.2.1, “Downgrading to MySQL 5.1”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump
Section 8.2.3, “Mapping of Identifiers to File Names”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 6.4.2, “Reloading SQL-Format Backups”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”

--all-in-1

Description

--all-tablespaces

Description
Section 1.4, “What Is New in MySQL 5.5”

--allow-keywords

Description

--allow-suspicious-udfs

Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
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”

--ansi

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

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

--autocommit=0

Section 5.1.3, “Server System Variables”

--back_log=50

Section 2.6, “Installing MySQL on Solaris and OpenSolaris”

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Description

--base64-output

Description

--base64-output=ALWAYS

Description

--base64-output=AUTO

Description

--base64-output=DECODE-ROWS

Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

--base64-output=NEVER

Section 4.6.7.2, “mysqlbinlog Row Event Display”

--base64-output[=value]

Description

--basedir

Description
Description
Section 2.9.4, “MySQL Source-Configuration Options”
Section 16.1.6.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 16.1.6.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 Instances on One Machine”
Section 5.1.3, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.10.1, “Unix Postinstallation Procedures”

--basedir=path

Description
Description
Description
Description
Description
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”

--batch

Section 4.5.1.3, “mysql History File”
Section 4.5.1.1, “mysql Options”

--bdb-logdir

Section 5.1.3, “Server System Variables”

--bdb-logdir=file_name

Section 5.6, “Running Multiple MySQL Instances on One Machine”

--bdb-no-recover

Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”

--bdb-shared-data

Section 5.1.3, “Server System Variables”

--bdb-tmpdir=path

Section 5.6, “Running Multiple MySQL Instances on One Machine”

--big-tables

Section 5.1.2, “Server Command Options”

--bind-address

Description
Description
Section 5.6, “Running Multiple MySQL Instances on One Machine”

--bind-address=127.0.0.1

Section C.5.2.2, “Can't connect to [local] MySQL server
Section 5.4.7, “Causes of Access-Denied Errors”

--bind-address=IP

Section 5.1.2, “Server Command Options”

--bind-address=ip_address

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

--binlog-do-db

Section 15.1.3.4, “Binary Log Options and Variables”
Description
Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-do-db=db1

Section 15.1.3.4, “Binary Log Options and Variables”

--binlog-do-db=db_name

Section 15.1.3.4, “Binary Log Options and Variables”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--binlog-do-db=mysql

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--binlog-do-db=sales

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

--binlog-format

Section 15.1.3.4, “Binary Log Options and Variables”
Section 16.6.2, “General Requirements for MySQL Cluster Replication”

--binlog-format=MIXED

Section 5.2.4.1, “Binary Logging Formats”
Section 16.6.2, “General Requirements for MySQL Cluster Replication”
Section 16.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
Section 16.1.6.6, “Unsupported or Missing Features in MySQL Cluster”

--binlog-format=ROW

Section 5.2.4.1, “Binary Logging Formats”
Section 16.6.2, “General Requirements for MySQL Cluster Replication”
Section 16.1.6.6, “Unsupported or Missing Features in MySQL Cluster”

--binlog-format=STATEMENT

Section 5.2.4.1, “Binary Logging Formats”
Section 16.6.2, “General Requirements for MySQL Cluster Replication”

--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 15.1.3.4, “Binary Log Options and Variables”
Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-ignore-db=db_name

Section 15.1.3.4, “Binary Log Options and Variables”

--binlog-ignore-db=mysql

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--binlog-ignore-db=sales

Section 15.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 15.1.3.4, “Binary Log Options and Variables”

--binlog_format=STATEMENT

Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

--block-search=offset

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Description
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.2, “Server Command Options”

--brief

Description

--cflags

Section 2.9.5, “Dealing with Problems Compiling MySQL”
Description

--character-set-client-handshake

Section 5.1.2, “Server Command Options”
Section 9.1.14.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 15.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 1.4, “What Is New in MySQL 5.5”

--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 C.5.2.17, “Can't initialize character set
Section 9.5, “Character Set Configuration”
Section 16.1.6.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”

--character_set_server

Section 2.9.4, “MySQL Source-Configuration 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-upgrade

Description
Description

--checkpoint

Description

--checkpoint=db_name.tbl_name

Description

--chroot

Description

--chroot=path

Description
Section 5.1.2, “Server Command Options”

--collation-server

Section 9.5, “Character Set Configuration”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 15.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 1.4, “What Is New in MySQL 5.5”

--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”

--collation_server

Section 2.9.4, “MySQL Source-Configuration Options”

--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.8.1, “Basic SSL Concepts”
Description
Description
Description
Description
Description
Description
Section 4.2.3, “Specifying Program Options”

--concurrency=N

Description

--config-cache

Section 16.3.2, “MySQL Cluster Configuration Files”

--config-file

Description
Section 16.2.4, “Initial Startup of MySQL Cluster”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 1.4, “What Is New in MySQL 5.5”

--config-file=file_name

Description
Description

--config-file=path_name

Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”

--configdir

Section 16.3.2, “MySQL Cluster Configuration Files”

--console

Section 13.3.14.3, “InnoDB General Troubleshooting”
Section 13.3.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.3.3.2, “Creating the InnoDB Tablespace”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.2, “Server Command Options”
Section 2.3.6.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-and-drop-schema

Description

--create-and-drop-schema=value

Description

--create-options

Description
Section 1.4, “What Is New in MySQL 5.5”

--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.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 6.4.2, “Reloading SQL-Format Backups”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”

--datadir

Section 2.3.6.2, “Creating an Option File”
Description
Description
Description
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 4.2.3.3, “Using Option Files”

--datadir=path

Description
Description
Description
Description
Description
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.2, “Server Command Options”
Section 5.6.1, “Setting Up Multiple Data Directories”

--db=db_name

Description

--debug

Section 22.5.1.1, “Compiling MySQL for Debugging”
Description
Description
Section 5.1.3, “Server System Variables”
Section 2.3.6.5, “Starting MySQL from the Windows Command Line”
Section 2.10.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 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”

--debug-sync-timeout[=N]

Section 5.1.2, “Server Command Options”

--debug="..."

Section 22.5.3, “The DBUG Package”

--debug="d,parser_debug"

Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.2, “Server Command 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

--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-auth

Section 4.5.1.1, “mysql Options”
Section 21.9.10, “C API Client Plugin Functions”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.5.6.1, “The Native Authentication Plugins”
Section 22.2.4.9.3, “Using the Authentication Plugins”

--default-auth=plugin

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

--default-auth=plugin_name

Section 5.5.6, “Pluggable Authentication”

--default-character-set

Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 9.1.4, “Connection Character Sets and Collations”
Description
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 5.5.1, “User Names and Passwords”
Section 1.4, “What Is New in MySQL 5.5”

--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=latin1

Section 9.1.4, “Connection Character Sets and Collations”

--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.5, “Executing SQL Statements from a Text File”

--default-collation

Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--default-collation=collation_name

Section 5.1.2, “Server Command Options”

--default-storage-engine

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.2, “Configuring InnoDB
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 13.1, “Setting the Storage Engine”
Chapter 13, Storage Engines
Section 1.4, “What Is New in MySQL 5.5”

--default-storage-engine=type

Section 5.1.2, “Server Command Options”

--default-table-type

Chapter 13, Storage Engines
Section 1.4, “What Is New in MySQL 5.5”

--default-table-type=type

Section 5.1.2, “Server Command Options”

--default-time-zone

Section 15.4.1.28, “Replication and Time Zones”
Section 5.1.3, “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.4.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.4, “What Is New in MySQL 5.5”

--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 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 13.3.2, “Configuring InnoDB
Description
Section 21.8.3, “Options with the Embedded Server”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.6.7, “Starting MySQL as a Windows Service”
Section 2.3.5.1, “Starting the MySQL Server Instance Configuration Wizard”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--defaults-file=file_name

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Description
Description
Section 5.3.2.2, “End-User Guidelines for Password Security”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 2.3.6.7, “Starting MySQL as a Windows Service”

--defaults-group-suffix

Section 2.12, “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 C.5.4.2, “What to Do If MySQL Keeps Crashing”

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

Section 1.4, “What Is New in MySQL 5.5”

--delay-key-write=ALL

Section 13.5.1, “MyISAM Startup Options”
Section 7.10.5, “External Locking”
Section 15.4.4, “Replication FAQ”
Section 1.4, “What Is New in MySQL 5.5”

--delay-key-write=OFF

Section 7.10.5, “External Locking”

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

Section 5.1.2, “Server Command Options”

--delay_key_write=1

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

--delay_key_write=ON

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

--delayed-insert

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.7.6.3, “FLUSH Syntax”
Section 11.13, “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.9.4, “MySQL Source-Configuration Options”

--disable-debug-sync

Section 2.9.4, “MySQL Source-Configuration Options”

--disable-grant-options

Description
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--disable-keys

Description

--disable-log-bin

Description

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-plugin_name

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--disable-profiling

Section 2.9.4, “MySQL Source-Configuration Options”

--disable-shared

Section 2.9.4, “MySQL Source-Configuration Options”

--disconnect-slave-event-count

Section 15.1.3.3, “Replication Slave Options and Variables”

--dryrun

Description

--dump

Description

--dump-date

Description

--dump-slave

Description

--dump-slave[=value]

Description

--embedded

Description

--enable-community-features

Section 2.9.4, “MySQL Source-Configuration Options”

--enable-debug-sync

Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--enable-local-infile

Section 5.3.5, “Security Issues with LOAD DATA LOCAL

--enable-locking

Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--enable-named-pipe

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

--enable-plugin_name

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--enable-profiling

Section 2.9.4, “MySQL Source-Configuration Options”

--enable-pstack

Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--enable-thread-safe-client

Section 2.9.4, “MySQL Source-Configuration Options”

--engine-condition-pushdown=1

Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”

--engine=engine_name

Description

--event-scheduler

Section 5.1.2, “Server Command Options”

--event-scheduler=DISABLED

Section 18.4.2, “Event Scheduler Configuration”
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

--execute

Section 4.5.1.3, “mysql History File”
Section 4.2.3.1, “Using Options on the Command Line”
Section 16.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.10.5, “External Locking”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 7.11.1, “System Factors and Startup Parameter Tuning”
Section 1.4, “What Is New in MySQL 5.5”

--extra-file=file_name

Description

--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.4, “What Is New in MySQL 5.5”

--fix-db-names

Description

--fix-table-names

Description

--flush

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

--flush-logs

Description
Section 6.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”

--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, “The MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

Description

--foreground

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.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.3, “Server System Variables”

--general_log_file=file_name

Section 5.6, “Running Multiple MySQL Instances on One Machine”
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
Description
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.2, “Server Command Options”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 7.11.2, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 2.10.1, “Unix Postinstallation 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 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.6.4, “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.4, “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.4, “Using Client Programs in a Multiple-Server Environment”

--host=localhost

Section 5.6.4, “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.6.2, “Using the --safe-updates Option”

--ignore

Description

--ignore-builtin-innodb

Section 13.3.4, “InnoDB Startup Options and System Variables”

--ignore-lines=N

Description

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table=db_name.tbl_name

Description

--in_file=file_name

Description

--include

Description

--include-master-host-port

Description

--info

Description
Description

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-file

Section 2.9.4, “MySQL Source-Configuration Options”
Section 20.2.3, “Performance Schema Runtime Configuration”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.3, “Server System Variables”
Section 13.6, “The MEMORY Storage Engine”

--init-file=file_name

Section 20.2.3, “Performance Schema Runtime Configuration”
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 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Description
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 16.1.6.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 16.3.2, “MySQL Cluster Configuration Files”
Section 16.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
Section 16.5.11.3, “MySQL Cluster Disk Data Storage Requirements”
Section 16.3.3.2, “MySQL Cluster Management Node Configuration Parameters”
Section 16.3.3.3, “MySQL Cluster SQL Node and API Node Configuration Parameters”
Section 16.3.3.4, “Other MySQL Cluster Configuration Parameters”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
Section 16.5.1, “Summary of MySQL Cluster Start Phases”

--initial-start

Description

--innodb

Section 13.3.4, “InnoDB Startup Options and System Variables”

--innodb-autoinc-lock-mode

Section 13.3.5.3.2, “Configurable InnoDB Auto-Increment Locking”

--innodb-safe-binlog

Section 15.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.3.4, “InnoDB Startup Options and System Variables”

--innodb-status-file=1

Section 13.3.4, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.2, “Server Command Options”

--innodb=OFF

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.2, “Configuring InnoDB

--innodb[=value]

Section 13.3.4, “InnoDB Startup Options and System Variables”

--innodb_checksums

Section 13.3.4, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

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

--innodb_locks_unsafe_for_binlog

Section 15.1.3.4, “Binary Log Options and Variables”

--innodb_rollback_on_timeout

Section 13.3.13, “InnoDB Error Handling”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--innodb_support_xa

Section 5.2.4, “The Binary Log”

--insert-ignore

Description

--install

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.6.7, “Starting MySQL as a Windows Service”

--install [service_name]

Section 5.1.2, “Server Command Options”

--install-manual

Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.6.7, “Starting MySQL as a Windows Service”

--install-manual [service_name]

Section 5.1.2, “Server Command Options”

--install[=name]

Description

--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”

--language

Section 5.1.2, “Server Command Options”
Section 9.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--language=lang_name, -L lang_name

Section 5.1.2, “Server Command Options”

--large-pages

Section 7.11.4.2, “Enabling Large Page Support”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--lc-messages

Section 5.1.2, “Server Command Options”
Section 9.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--lc-messages-dir

Section 5.1.2, “Server Command Options”
Section 9.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

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

--local

Section 12.2.6, “LOAD DATA INFILE Syntax”
Description
Section 5.3.5, “Security Issues with LOAD DATA LOCAL

--local-infile

Section 2.9.4, “MySQL Source-Configuration Options”

--local-infile=0

Section 4.5.1.1, “mysql Options”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.2.7, “LOAD XML 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=OFF

Section 12.2.7, “LOAD XML Syntax”

--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.3.6.7, “Starting MySQL as a Windows Service”

--lock-all-tables

Description
Section 1.4, “What Is New in MySQL 5.5”

--lock-directory

Description

--lock-directory=path

Description

--lock-tables

Description
Description

--log

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.3, “Server System Variables”
Section 5.2.3, “The General Query Log”

--log-bin

Section 12.4.2.1, “CHANGE MASTER TO Syntax”
Section 12.4.1.1, “PURGE BINARY LOGS Syntax”
Section 6.3.3, “Backup Strategy Summary”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 6.2, “Database Backup Methods”
Section 6.3.1, “Establishing a Backup Policy”
Section 15.4.6, “How to Report Replication Bugs or Problems”
Section 16.1.6.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 15.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”
Section 15.4.5, “Troubleshooting Replication”
Section 15.4.3, “Upgrading a Replication Setup”
Section 6.3.2, “Using Backups for Recovery”

--log-bin-index

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

--log-bin-index[=file_name]

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

--log-bin-trust-function-creators

Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 1.4, “What Is New in MySQL 5.5”

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

Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”

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

Section 15.1.3.4, “Binary Log Options and Variables”

--log-bin-trust-routine-creators

Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 1.4, “What Is New in MySQL 5.5”

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

Section 18.7, “Binary Logging of Stored Programs”

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

Section 15.1.3.4, “Binary Log Options and Variables”

--log-bin-use-v1-events

Section 15.1.3.4, “Binary Log Options and Variables”

--log-bin-use-v1-row-events

Section 15.1.3.4, “Binary Log Options and Variables”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--log-bin-use-v1-row-events[={0|1}]

Section 15.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 C.5.8, “Known Issues in MySQL”

--log-bin[=base_name]

Section 15.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 Instances on One Machine”

--log-error

Section 12.7.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.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--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 Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.2.2, “The Error Log”

--log-isam[=file_name]

Section 5.1.2, “Server Command Options”

--log-long-format

Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--log-output

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”
Section 1.4, “What Is New in MySQL 5.5”

--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.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--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”

--log-slave-updates

Section 15.4.6, “How to Report Replication Bugs or Problems”
Section 15.3.5, “Improving Replication Performance”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.3.6, “Switching Masters During Failover”
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.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

--log-slow-queries[=file_name]

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

--log-slow-slave-statements

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

--log-tc-size

Section 5.1.5, “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.4, “What Is New in MySQL 5.5”

--log-warnings

Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.1.2, “Server Command Options”
Section 5.2.2, “The Error Log”
Section 1.4, “What Is New in MySQL 5.5”

--log-warnings=0

Section 5.1.2, “Server Command Options”

--log-warnings=2

Section C.5.2.9, “MySQL server has gone away

--log-warnings[=level]

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

--log=file_name

Description

--log[=file_name]

Section 5.6, “Running Multiple MySQL Instances on One 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.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--loose-opt_name

Section 4.2.3.3, “Using Option Files”

--loose-skip-innodb

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--low-priority

Description

--low-priority-updates

Section 12.2.5, “INSERT Syntax”
Section 7.10.3, “Concurrent Inserts”
Section 15.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 7.10.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-connect-retry

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 7.12.5.6, “Replication Slave I/O Thread States”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.16, “Replication and Master or Slave Shutdowns”
Section 1.4, “What Is New in MySQL 5.5”

--master-connect-retry=seconds

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-data

Section 15.1.1.5, “Creating a Data Snapshot Using mysqldump
Description
Section 6.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”

--master-data=2

Description

--master-data[=value]

Description

--master-host

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-host=host_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-info-file

Section 15.2.2.2, “Slave Status Logs”

--master-info-file=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-password

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-password=password

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-port

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-port=port_number

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-retry-count

Section 12.4.2.1, “CHANGE MASTER TO Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”

--master-retry-count=count

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-ssl

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-ssl*

Section 5.5.8.3, “SSL Command Options”

--master-ssl-ca

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-ssl-ca=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-ssl-capath=directory_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-ssl-cert=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-ssl-cipher=cipher_list

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-ssl-key=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-user

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--master-user=user_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-xxx

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.5”

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-binlog-dump-events=N

Section 15.1.3.4, “Binary Log Options and Variables”

--max-binlog-size

Section 15.1.3.3, “Replication Slave Options and Variables”

--max-record-length

Section 12.7.2.5, “REPAIR TABLE Syntax”

--max-record-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--max-relay-log-size

Section 15.1.3.3, “Replication Slave Options and Variables”

--max-relay-log-size=size

Section 15.1.3.3, “Replication Slave Options and Variables”

--max-seeks-for-key=1000

Section 7.2.1.4, “How to Avoid Full Table Scans”
Section C.5.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.4, “Using Options to Set Program Variables”

--max_connect_errors=999999999

Section 12.7.6.3, “FLUSH Syntax”

--max_join_size

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

--maximum

Section 4.2.3.2, “Program Option Modifiers”

--maximum-query_cache_size=32M

Section 7.9.3.3, “Query Cache Configuration”
Section 5.1.4, “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.4, “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.3, “Server System Variables”
Section 13.3.3.1, “Using Raw Devices for the Shared Tablespace”

--method=command

Description

--min-examined-row-limit=number

Section 5.1.2, “Server Command Options”

--my-plugin=ON

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--my-print-defaults=path

Description

--my_plugin=ON

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--myisam-block-size

Section 7.9.2.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.5, “Other Optimization Tips”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section C.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.6.1, “Optimizing MyISAM Queries”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section C.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.3, “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.3, “Server System Variables”

--myisam-recover=mode

Section 13.5.1, “MyISAM Startup Options”

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

Section 5.1.2, “Server Command Options”

--mysqladmin=prog_name

Description

--mysqld

Description
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--mysqld-version

Description
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--mysqld-version=debug

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=path

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 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-blob-read-batch-bytes=bytes

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-blob-write-batch-bytes=bytes

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-cluster-connection-pool

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-cluster-connection-pool=#

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-cluster-connection-pool=4

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-connectstring

Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”

--ndb-connectstring=connect_string

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-connectstring=management_host

Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”

--ndb-force-send=1

Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”

--ndb-index-stat-enable=0

Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”

--ndb-log-apply-status

Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-log-empty-epochs

Section 15.1.3.3, “Replication Slave Options and Variables”

--ndb-log-orig

Section 16.6.4, “MySQL Cluster Replication Schema and Tables”

--ndb-log-transaction-id

Section 15.1.3.4, “Binary Log Options and Variables”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-log-update-as-write

Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

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

Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

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

Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

--ndb-log-updated-only

Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

--ndb-nodeid

Description
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-nodeid=#

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-use-exact-count=0

Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”

--ndb-wait-connected=seconds

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb-wait-setup=seconds

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb_optimization_delay=milliseconds

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--ndb_optimized_node_selection

Section 16.3.4.3, “MySQL Cluster System Variables”

--ndbcluster

Section 12.7.5.17, “SHOW ENGINES Syntax”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.3, “MySQL Cluster Configuration”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”

--ndbcluster --ndb-connectstring=management_host

Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”

--ndbinfo-database=name

Section 16.3.4.3, “MySQL Cluster System Variables”

--ndbinfo-table-prefix

Section 16.3.4.3, “MySQL Cluster System Variables”

--new

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
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--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-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
Description

--no-log

Description

--no-named-commands

Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.5”

--no-pager

Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.5”

--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.4, “What Is New in MySQL 5.5”

--nodaemon

Description

--nodeid

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--noindices

Description

--nostart

Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Description

--nowait-nodes

Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Description

--nowait-nodes=3

Description

--nowait-nodes=3,4

Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”

--nowait-nodes=3,5

Description

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

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-alter-table

Section 5.1.2, “Server Command Options”

--old-passwords

Section C.5.2.4, “Client does not support authentication protocol
Section 5.3.2.3, “Password Hashing in MySQL”
Section 5.3.4, “Security-Related mysqld Options”
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-print

Description

--open-files-limit

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.4.3.1, “How MySQL Opens and Closes Tables”
Section 5.1.3, “Server System Variables”

--open-files-limit=count

Description
Section 5.1.2, “Server Command Options”

--opt

Section 13.3.14.1, “InnoDB Performance Tuning Tips”
Section 7.5.4, “Bulk Data Loading for InnoDB Tables”
Description

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

--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”

--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.2.1, “Invoking MySQL Programs”
Section C.5.2.5, “Password Fails When Entered Interactively”
Section 5.5.6, “Pluggable Authentication”
Section 5.5.6.6, “The Test Authentication Plugin”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”

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

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

--performance_schema_max_mutex_classes=200

Section 20.5, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_classes=N

Section 20.5, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances=N

Section 20.5, “Performance Schema Status Monitoring”

--pid-file

Description
Section 5.1.3, “Server System Variables”

--pid-file=file_name

Description
Description
Section 5.6, “Running Multiple MySQL Instances on One 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.3.6.8, “Testing The MySQL Installation”

--plan

Description

--plugin

Section 5.1.2, “Server Command Options”

--plugin-dir

Section 21.9.10, “C API Client Plugin Functions”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Description
Section E.9, “Restrictions on Pluggable Authentication”
Section 22.2.4.9.3, “Using the Authentication Plugins”

--plugin-dir=dir_name

Section 5.5.6, “Pluggable Authentication”

--plugin-dir=path

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

--plugin-dir=path_name

Section 5.5.6.2.1, “Installing the PAM Authentication Plugin”
Section 5.5.6.3.1, “Installing the Windows Authentication Plugin”
Section 7.11.6.1, “Thread Pool Components and Installation”

--plugin-ini=file_name

Description

--plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--plugin-load

Section 12.7.3.3, “INSTALL PLUGIN Syntax”
Description
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.5.6.2.1, “Installing the PAM Authentication Plugin”
Section 5.5.6.3.1, “Installing the Windows Authentication Plugin”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.5.6, “Pluggable Authentication”
Section 22.2.2, “Plugin API Components”
Section 22.2.4.2, “Plugin Data Structures”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 22.2, “The MySQL Plugin API”
Section 7.11.6.1, “Thread Pool Components and Installation”
Section 22.2.4.9.3, “Using the Authentication Plugins”

--plugin-load=auth_simple.so

Section 22.2.4.9.3, “Using the Authentication Plugins”

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

Section 2.9.4, “MySQL Source-Configuration Options”

--plugin_dir=path

Section 22.2.2, “Plugin API Components”

--plugin_name

Description
Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=0

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--plugin_name=1

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--plugin_name=FORCE

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--plugin_name=FORCE_PLUS_PERMANENT

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--plugin_name=OFF

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--plugin_name=ON

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--plugin_name[=ON]

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugindir

Description

--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 2.9.4, “MySQL Source-Configuration Options”
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.6.4, “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 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”

--port=port_number

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

--position

Description
Section 1.4, “What Is New in MySQL 5.5”

--position=N

Description

--post-query=value

Description

--post-system=str

Description

--pre-query=value

Description

--pre-system=str

Description

--prefix

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 22.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”

--preserve-schema

Description

--preview

Description

--print-defaults

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

--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.3.6.4, “Starting the Server for the First Time”
Section 5.6.4, “Using Client Programs in a Multiple-Server Environment”

--protocol=PIPE

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

--protocol=SOCKET

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

--protocol=TCP

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.6.4, “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.3, “Running Multiple MySQL Instances on Unix”

--query

Description

--query-cache-size=0

Section 7.10.5, “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 C.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

--raw

Section 4.5.1.1, “mysql Options”

--read-from-remote-server

Description

--read-only

Section 4.6.3.2, “myisamchk Check Options”
Section 15.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 15.3.5, “Improving Replication Performance”
Section 15.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 15.1.3.3, “Replication Slave Options and Variables”
Section 15.2.2.1, “The Slave Relay Log”

--relay-log-index

Section 15.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.2.2.1, “The Slave Relay Log”

--relay-log-index=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--relay-log-info-file

Section 15.2.2.2, “Slave Status Logs”

--relay-log-info-file=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--relay-log-space-limit

Section 15.1.3.3, “Replication Slave Options and Variables”

--relay-log-space-limit=size

Section 15.1.3.3, “Replication Slave Options and Variables”

--relay-log=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--relay-log=myhost-bin

Section 12.4.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 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.1.6.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 16.3.2, “MySQL Cluster Configuration Files”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”

--remove

Description
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.6.7, “Starting MySQL as a Windows Service”

--remove [service_name]

Section 5.1.2, “Server Command Options”

--remove[=name]

Description

--repair

Description

--replace

Description
Description

--replicate-*

Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 15.2.3.3, “Replication Rule Application”
Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-*-db

Section 15.2.3.3, “Replication Rule Application”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section E.1, “Restrictions on Stored Programs”

--replicate-*-table

Section 18.7, “Binary Logging of Stored Programs”
Section 15.2.3.3, “Replication Rule Application”

--replicate-[do|ignore]-table

Section 13.9, “The BLACKHOLE Storage Engine”

--replicate-do-*

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-do-db

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 15.3.4, “Replicating Different Databases to Different Slaves”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.22, “Replication and Reserved Words”
Section 15.4.1.19, “Replication and Temporary Tables”
Section 5.2.4, “The Binary Log”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-do-db=db1

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-do-db=db_name

Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-do-db=dbx

Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”

--replicate-do-db=mysql

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-do-db=sales

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-do-table

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
Section 15.2.3.3, “Replication Rule Application”
Section 15.4.1.22, “Replication and Reserved Words”
Section 15.4.1.19, “Replication and Temporary Tables”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-do-table=db_name.tbl_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-do-table=mysql.ndb_apply_status

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-ignore-*

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-ignore-db

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 15.2.3.3, “Replication Rule Application”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.22, “Replication and Reserved Words”
Section 5.2.4, “The Binary Log”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-db=db_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-ignore-db=mysql

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-ignore-db=sales

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-ignore-table

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
Section 15.4.1.22, “Replication and Reserved Words”
Section 15.4.1.19, “Replication and Temporary Tables”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-table=db_name.tbl_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-ignore-table=mysql.ndb_apply_status

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-rewrite-db

Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-same-server-id

Section 12.4.2.1, “CHANGE MASTER TO Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-do-table

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 15.3.4, “Replicating Different Databases to Different Slaves”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.19, “Replication and Temporary Tables”

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

Section 15.3.4, “Replicating Different Databases to Different Slaves”

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

Section 15.3.4, “Replicating Different Databases to Different Slaves”

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

Section 15.3.4, “Replicating Different Databases to Different Slaves”

--replicate-wild-do-table=db%.t1

Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”
Section E.1, “Restrictions on Stored Programs”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table

Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.19, “Replication and Temporary Tables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

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

Section 15.4.4, “Replication FAQ”

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

Section 15.4.1.19, “Replication and Temporary Tables”

--report-host

Section 15.1.4.1, “Checking Replication Status”
Section 5.1.3, “Server System Variables”

--report-host=host_name

Section 12.7.5.34, “SHOW SLAVE HOSTS Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”

--report-password

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

--report-password=password

Section 15.1.3.3, “Replication Slave Options and Variables”

--report-port

Section 5.1.3, “Server System Variables”

--report-port=slave_port_num

Section 15.1.3.3, “Replication Slave Options and Variables”

--report-user

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

--report-user=user_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--resetmaster

Description

--resetslave

Description

--restore-epoch

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

--restore_epoch

Section 16.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.11.2.1, “Downgrading to MySQL 5.1”
Section 6.4.5.3, “Dumping Stored Programs”
Section 6.4.5.4, “Dumping Table Definitions and Content Separately”

--rows=N

Description

--rpm

Description

--safe-mode

Section 12.7.2.4, “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 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--safe-updates

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.6.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.3, “Server System Variables”

--secure-file-priv

Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.1.3, “Server System Variables”
Section 2.10.1, “Unix Postinstallation Procedures”

--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.6.2, “Using the --safe-updates Option”

--server-id

Section 15.1.3, “Replication and Binary Logging Options and Variables”
Section 5.1.3, “Server System Variables”
Section 15.4.5, “Troubleshooting Replication”

--server-id-bits

Description
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--server-id-bits=#

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--server-id-bits=N

Description

--server-id=id

Description
Section 16.6.2, “General Requirements for MySQL Cluster Replication”

--server-id=value

Section 12.7.5.34, “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-variable

Section 4.5.1.1, “mysql Options”
Description
Description

--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”
Description
Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--shared-memory

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.6.4, “Starting the Server for the First Time”

--shared-memory-base-name

Section 21.9.3.49, “mysql_options()
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 5.6.4, “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 Instances on One Machine”
Section 5.1.2, “Server Command Options”

--short-form

Description

--show-slave-auth-info

Section 15.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.3.7, “Backing Up and Recovering an InnoDB Database”
Section 6.2, “Database Backup Methods”
Description
Section 6.3.1, “Establishing a Backup Policy”

--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 13.3.14.4, “Troubleshooting InnoDB Data Dictionary Operations”

--skip-base64-output

Description

--skip-bdb

Section 15.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-character-set-client-handshake

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 9.1.14.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-disable-keys

Description

--skip-dump-date

Description

--skip-engine_name

Section 12.7.5.17, “SHOW ENGINES Syntax”

--skip-event-scheduler

Section 5.1.2, “Server Command Options”

--skip-events

Section 2.11.2.1, “Downgrading to MySQL 5.1”
Section 6.4.5.3, “Dumping Stored Programs”

--skip-extended-insert

Description

--skip-external-locking

Section 7.10.5, “External Locking”
Section 7.12.5.2, “General Thread States”
Section 5.1.2, “Server Command Options”
Section 7.11.1, “System Factors and Startup Parameter Tuning”
Section 1.4, “What Is New in MySQL 5.5”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

--skip-grant-tables

Section 12.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Description
Description
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 2.11.2.1, “Downgrading to MySQL 5.1”
Section 18.4.2, “Event Scheduler Configuration”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.5.6, “Pluggable Authentication”
Section 2.10.1.1, “Problems Running mysql_install_db
Section C.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.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
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.11.5.2, “How MySQL Uses DNS”
Section 5.1.2, “Server Command Options”

--skip-innodb

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 12.7.5.17, “SHOW ENGINES Syntax”
Section 13.3.2, “Configuring InnoDB
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 15.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”

--skip-innodb-checksums

Section 13.3.4, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 13.3.4, “InnoDB Startup Options and System Variables”

--skip-innodb_checksums

Section 13.3.4, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 13.3.4, “InnoDB Startup Options and System Variables”

--skip-kill-mysqld

Description

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-lock-tables

Description

--skip-locking

Section 1.4, “What Is New in MySQL 5.5”

--skip-log-warnings

Section 15.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.3, “Server System Variables”
Section 13.10, “The MERGE Storage Engine”

--skip-name-resolve

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

--skip-named-commands

Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.5”

--skip-ndbcluster

Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

--skip-networking

Section C.5.2.2, “Can't connect to [local] MySQL server
Section C.5.2.9, “MySQL server has gone away
Section 5.4.7, “Causes of Access-Denied Errors”
Section 7.11.5.2, “How MySQL Uses DNS”
Section 5.5.6, “Pluggable Authentication”
Section C.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 5.1.3, “Server System Variables”
Section 15.4.3, “Upgrading a Replication Setup”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

--skip-new

Section 12.7.2.4, “OPTIMIZE TABLE Syntax”
Section 22.5.1, “Debugging a MySQL Server”
Section 5.1.3, “Server System Variables”

--skip-opt

Description

--skip-pager

Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.5”

--skip-partition

Chapter 17, 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.7.1, “Installing and Uninstalling Plugins”

--skip-quick

Description

--skip-quote-names

Description

--skip-reconnect

Section 4.5.1.1, “mysql Options”
Section 21.9.12, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.6.3, “Disabling mysql Auto-Reconnect”

--skip-routines

Section 2.11.2.1, “Downgrading to MySQL 5.1”
Section 6.4.5.3, “Dumping Stored Programs”

--skip-safemalloc

Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 5.1.2, “Server Command Options”

--skip-set-charset

Description

--skip-show-database

Section 12.7.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.4.2.1, “CHANGE MASTER TO Syntax”
Section 12.4.2.5, “START SLAVE Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.3.7, “Setting Up Replication Using SSL”
Section 15.1.1.8, “Setting Up Replication with Existing Data”
Section 15.4.5, “Troubleshooting Replication”
Section 15.4.3, “Upgrading a Replication Setup”

--skip-ssl

Section 5.5.8.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.11.4.2, “Enabling Large Page Support”
Section 1.4.4, “Enhanced Solaris 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 5.1.2, “Server Command Options”
Section 7.11.3.1.3, “Using Symbolic Links for Databases on Windows”
Section 7.11.3.1.2, “Using Symbolic Links for Tables on Unix”
Section 1.4, “What Is New in MySQL 5.5”

--skip-symlink

Section 1.4, “What Is New in MySQL 5.5”

--skip-syslog

Description
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--skip-tee

Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.5”

--skip-thread-priority

Section 5.1.2, “Server Command Options”

--skip-triggers

Description
Section 2.11.2.1, “Downgrading to MySQL 5.1”
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-load-tmpdir

Section 15.3.1.2, “Backing Up Raw Data from a Slave”
Section 6.2, “Database Backup Methods”

--slave-load-tmpdir=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section 15.1.3.3, “Replication Slave Options and Variables”

--slave-net-timeout=seconds

Section 15.1.3.3, “Replication Slave Options and Variables”

--slave-skip-errors

Section 15.4.1.24, “Slave Errors During Replication”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--slave_compressed_protocol={0|1}

Section 15.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-start-timeout=timeout

Section 5.1.2, “Server Command Options”

--slow_query_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.3, “Server System Variables”

--slow_query_log_file=file_name

Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--socket

Section C.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 C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.6.8, “Testing The MySQL Installation”
Section 5.6.4, “Using Client Programs in a Multiple-Server Environment”

--socket=/path/to/socket

Section C.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.4, “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 5.6, “Running Multiple MySQL Instances on One 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 15.1.3.4, “Binary Log Options and Variables”

--sql-bin-update-same

Section 1.4, “What Is New in MySQL 5.5”

--sql-mode

Section 5.1.2, “Server Command Options”

--sql-mode=""

Section 5.1.6, “Server SQL Modes”

--sql-mode="mode_value"

Section 1.8.2, “Selecting SQL Modes”

--sql-mode="modes"

Section 5.1.6, “Server SQL Modes”

--sql-mode=IGNORE_SPACE

Chapter 11, Functions and Operators

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

Section 5.1.2, “Server Command Options”

--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--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 15.1.3.3, “Replication Slave Options and Variables”
Section 5.5.8.3, “SSL Command Options”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.5.8.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.7.1.3, “GRANT Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.5.8.3, “SSL Command Options”
Section 5.5.8.2, “Using SSL Connections”

--ssl-ca=file_name

Section 5.5.8.3, “SSL Command Options”

--ssl-capath

Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.5.8.3, “SSL Command Options”

--ssl-capath=directory_name

Section 5.5.8.3, “SSL Command Options”

--ssl-cert

Section 12.7.1.3, “GRANT Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.5.8.3, “SSL Command Options”
Section 5.5.8.2, “Using SSL Connections”

--ssl-cert=file_name

Section 5.5.8.3, “SSL Command Options”

--ssl-cipher

Section 15.1.3.3, “Replication Slave Options and Variables”

--ssl-cipher=cipher_list

Section 5.5.8.3, “SSL Command Options”

--ssl-key

Section 12.7.1.3, “GRANT Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.5.8.3, “SSL Command Options”
Section 5.5.8.2, “Using SSL Connections”

--ssl-key=file_name

Section 5.5.8.3, “SSL Command Options”

--ssl-verify-server-cert

Section 5.5.8.3, “SSL Command Options”

--ssl-xxx

Section 12.4.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.3, “Server System Variables”
Section 5.5.8.2, “Using SSL Connections”

--ssl=0

Section 5.5.8.3, “SSL Command Options”

--standalone

Section 22.5.1.2, “Creating Trace Files”
Section 5.1.2, “Server Command Options”
Section 2.3.6.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 6.5.2, “Point-in-Time Recovery Using Event Positions”
Section 1.4, “What Is New in MySQL 5.5”

--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.11.4.2, “Enabling Large Page Support”
Section 1.4.4, “Enhanced Solaris Support”
Section 5.1.2, “Server Command Options”

--superuser=user_name

Description

--symbolic-links

Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--symbols-file=file_name

Description

--sysconfdir

Section 4.2.3.3, “Using Option Files”

--sysdate-is-now

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 11.7, “Date and Time Functions”
Section 15.4.1.11, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--syslog

Description
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--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.3.1, “How MySQL Opens and Closes Tables”

--table_open_cache

Section 7.4.3.1, “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_stack=N

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

--timezone

Section 9.6, “MySQL Server Time Zone Support”
Section 5.1.3, “Server System Variables”
Section C.5.4.6, “Time Zone Problems”

--timezone=timezone

Description

--timezone=timezone_name

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

--tmpdir

Section 4.6.3.3, “myisamchk Repair Options”
Section C.5.2.13, “Can't create/write to file
Section 5.1.2, “Server Command Options”
Section C.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 Instances on One Machine”
Section 5.1.2, “Server Command Options”

--to-last-log

Description

--transaction-isolation

Section 5.1.3, “Server System Variables”
Section 13.3.9, “The InnoDB Transaction Model and Locking”

--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.4, “What Is New in MySQL 5.5”

--use-threads

Description

--use-threads=N

Description

--user

Section C.5.2.18, “'File' Not Found and Similar Errors”
Description
Description
Description
Section 6.3, “Example Backup and Recovery Strategy”
Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.5.6, “Pluggable Authentication”
Section 5.1.2, “Server Command Options”
Section 5.5.6.5, “The Socket Peer-Credential Authentication Plugin”
Section 5.5.6.6, “The Test Authentication Plugin”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.3, “Using Option Files”

--user=mysql

Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section C.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”

--user=valerie

Section 5.5.6.5, “The Socket Peer-Credential Authentication Plugin”

--user={user_name|user_id}

Description
Section 5.1.2, “Server Command Options”

--var_name=value

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--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”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.2, “Server Command Options”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 7.11.2, “Tuning Server Parameters”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
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
Description
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[=count]

Description

--warnings

Section 1.4, “What Is New in MySQL 5.5”

--where='where_condition'

Description

--windows

Description

--with

Section 2.9.4, “MySQL Source-Configuration Options”

--with-archive-storage-engine

Section 13.8, “The ARCHIVE Storage Engine”

--with-berkeley-db

Section 2.1.2.2, “Choosing a Distribution Format”

--with-big-tables

Section 13.10.2, “MERGE Table Problems”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”
Section 13.5, “The MyISAM Storage Engine”

--with-blackhole-storage-engine

Section 13.9, “The BLACKHOLE Storage Engine”

--with-charset

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 9.1.3.1, “Server Character Set and Collation”

--with-charset=MYSET

Section 9.3, “Adding a Character Set”

--with-charset=charset_name

Section C.5.2.17, “Can't initialize character set

--with-collation

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 9.1.3.1, “Server Character Set and Collation”

--with-comment

Section 5.1.3, “Server System Variables”

--with-csv-storage-engine

Section 13.7, “The CSV Storage Engine”

--with-debug

Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.5.2, “Debugging a MySQL Client”
Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.2, “Server Command Options”
Section C.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 5.1.2, “Server Command Options”
Section C.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.9.4, “MySQL Source-Configuration Options”

--with-example-storage-engine

Section 13.12, “The EXAMPLE Storage Engine”

--with-extra-charsets=LIST

Section 2.9.4, “MySQL Source-Configuration Options”

--with-extra-charsets=charset_name

Section C.5.2.17, “Can't initialize character set

--with-extra-charsets=complex

Section C.5.2.17, “Can't initialize character set

--with-federated-storage-engine

Section 13.11, “The FEDERATED Storage Engine”

--with-libwrap

Section 2.1.2.2, “Choosing a Distribution Format”

--with-low-memory

Section 2.9.5, “Dealing with Problems Compiling MySQL”

--with-max-indexes=N

Section 13.5, “The MyISAM Storage Engine”

--with-mysql-sock[=DIR]

Section 21.10.4, “MySQL Functions (PDO_MYSQL)”

--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 16.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”

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

Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

--with-ndb-shm

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”

--with-ndbcluster

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”

--with-openssl

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--with-partition

Chapter 17, Partitioning

--with-pdo-mysql[=DIR]

Section 21.10.4, “MySQL Functions (PDO_MYSQL)”

--with-plugin-PLUGIN

Section 2.9.4, “MySQL Source-Configuration Options”

--with-plugins

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 2.9.4, “MySQL Source-Configuration Options”

--with-plugins=max

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Chapter 17, Partitioning

--with-plugins=max-no-innodb

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”

--with-plugins=ndbcluster

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”

--with-pstack

Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

--with-ssl

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 5.5.8.2, “Using SSL Connections”

--with-ssl=path

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

--with-tcp-port

Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”

--with-unix-socket-path

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

--with-vio

Section 5.5.8.2, “Using SSL Connections”

--with-yassl

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

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

Section 2.9.4, “MySQL Source-Configuration Options”

--with-zlib-dir[=DIR]

Section 21.10.4, “MySQL Functions (PDO_MYSQL)”

--without

Section 2.9.4, “MySQL Source-Configuration Options”

--without-plugin-PLUGIN

Section 2.9.4, “MySQL Source-Configuration Options”

--without-query-cache

Section 7.9.3, “The MySQL Query Cache”

--without-server

Section 2.9.4, “MySQL Source-Configuration Options”

--write-binlog

Description
Description

--xml

Section 4.5.1.1, “mysql Options”
Section 12.2.7, “LOAD XML Syntax”
Description
Section 11.11, “XML Functions”

-0

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

-1

Section 1.8.5.5, “'--' as the Start of a Comment”
Section 17.2.4, “HASH Partitioning”
Section 21.9.3.1, “mysql_affected_rows()
Section 11.3.2, “Comparison Functions and Operators”
Description
Section 11.6.2, “Mathematical Functions”
Section 11.15, “Miscellaneous Functions”
Section 11.5.1, “String Comparison Functions”

-?

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
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 C.5.8, “Known 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.17.1, “Problems Linking to the MySQL Client Library”

-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.9.4, “MySQL Source-Configuration Options”

-DBUILD_CONFIG=mysql_release

Section 2.9.2, “Installing MySQL from a Standard Source Distribution”

-DCMAKE_BUILD_TYPE=Debug

Section 2.9.4, “MySQL Source-Configuration Options”

-DCMAKE_INSTALL_PREFIX=dir_name

Section 2.9.2, “Installing MySQL from a Standard Source Distribution”

-DCPACK_MONOLITHIC_INSTALL=1

Section 2.9.2, “Installing MySQL from a Standard Source Distribution”

-DDEFAULT_CHARSET=MYSET

Section 9.3, “Adding a Character Set”

-DDEFAULT_CHARSET=charset_name

Section C.5.2.17, “Can't initialize character set

-DENABLED_LOCAL_INFILE=1

Section 5.3.5, “Security Issues with LOAD DATA LOCAL

-DENABLE_DEBUG_SYNC=0

Section 2.9.4, “MySQL Source-Configuration Options”

-DENABLE_DEBUG_SYNC=1

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

-DENABLE_DTRACE=0

Section 5.7, “Tracing mysqld Using DTrace”

-DENABLE_DTRACE=1

Section 5.7, “Tracing mysqld Using DTrace”

-DINSTALL_SQLBENCHDIR=

Section 2.9.4, “MySQL Source-Configuration Options”

-DSAFEMALLOC

Appendix A, Licenses for Third-Party Components

-DUSE_ALARM_THREAD

Section 22.1.1, “MySQL Threads”

-DWITHOUT_PERFSCHEMA_STORAGE_ENGINE=1

Section 20.2.1, “Performance Schema Build Configuration”

-DWITH_ARCHIVE_STORAGE_ENGINE

Section 13.8, “The ARCHIVE Storage Engine”

-DWITH_BLACKHOLE_STORAGE_ENGINE

Section 13.9, “The BLACKHOLE Storage Engine”

-DWITH_DEBUG=1

Section 2.1.2.2, “Choosing a Distribution Format”
Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.5.2, “Debugging a MySQL Client”
Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.2, “Server Command Options”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

-DWITH_EMBEDDED_SERVER=1

Section 21.8.1, “Compiling Programs with libmysqld

-DWITH_EXAMPLE_STORAGE_ENGINE

Section 13.12, “The EXAMPLE Storage Engine”

-DWITH_EXTRA_CHARSETS=all

Section C.5.2.17, “Can't initialize character set

-DWITH_EXTRA_CHARSETS=charset_name

Section C.5.2.17, “Can't initialize character set

-DWITH_FEDERATED_STORAGE_ENGINE

Section 13.11, “The FEDERATED Storage Engine”

-DWITH_LIBWRAP=1

Section 2.1.2.2, “Choosing a Distribution Format”

-DWITH_PARTITION_STORAGE_ENGINE

Chapter 17, Partitioning

-DWITH_SSL=system

Section 5.5.8.2, “Using SSL Connections”

-DWITH_ZLIB={system|bundled}

Section 2.1.2.2, “Choosing a Distribution Format”

-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.17, “Building Client Programs”
Description
Description
Description
Description
Description
Description

-I/usr/local/mysql/include

Section 21.9.17, “Building Client Programs”

-K

Description

-L

Section 4.5.1.1, “mysql Options”
Section 21.9.17, “Building Client Programs”
Description
Section 2.13.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.13.3, “Problems Using the Perl DBI/DBD Interface”

-L/usr/lib

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

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

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

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

Section 21.9.17, “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”
Description
Section 5.1.2, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.5”

-O file_name

Description

-O0

Section 2.9.5, “Dealing with Problems Compiling MySQL”

-P

Section 4.2.2, “Connecting to the MySQL Server”
Description
Section 4.2.1, “Invoking MySQL Programs”

-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
Description
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.4, “What Is New in MySQL 5.5”

-a

Section 6.6.4, “MyISAM Table Optimization”
Section 16.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”

-b path

Description

-c

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”

-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

-d path

Description

-debug

Section 5.1.3, “Server System Variables”

-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”
Section 12.2.7, “LOAD XML Syntax”
Description
Description
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 4.2.3.1, “Using Options on the Command Line”
Section 16.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, “Obtaining Table Information with myisamchk

-f

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Description
Description
Description
Section 16.2.4, “Initial Startup of MySQL Cluster”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”

-f N

Description

-felide-constructors

Section 2.9, “Installing MySQL from Source”
Section 2.9.4, “MySQL Source-Configuration Options”

-fno-exceptions

Section 2.9, “Installing MySQL from Source”
Section 2.9.4, “MySQL Source-Configuration Options”

-fno-inline

Section 2.9.5, “Dealing with Problems Compiling MySQL”

-fno-rtti

Section 2.9, “Installing MySQL from Source”
Section 2.9.4, “MySQL Source-Configuration Options”

-fomit-frame-pointer

Section 22.5.1.5, “Using a Stack Trace”

-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 C.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 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 16.5.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
Section 22.5.1.3, “Using pdb to create a Windows crashdump”

-i N

Description

-i delay

Description

-i file_name

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.9.5, “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.17.1, “Problems Linking to the MySQL Client Library”

-lmysqlclient

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

-lmysqlclient -lz

Section 21.9.17, “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.13.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 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”

-n

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

-n N

Description

-n file_name

Description

-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

-o async

Section 7.11.3, “Optimizing Disk I/O”

-o N

Description

-o noatime

Section 7.11.3, “Optimizing Disk I/O”

-o offset

Description

-p

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 17.2.5, “KEY Partitioning”
Section 16.5.12.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
Description
Section 5.3.2.2, “End-User Guidelines for Password Security”
Section 4.2.1, “Invoking MySQL Programs”
Section C.5.2.5, “Password Fails When Entered Interactively”
Section 2.10.2, “Securing the Initial MySQL Accounts”
Section 2.3.6.7, “Starting MySQL as a Windows Service”
Section 2.3.6.5, “Starting MySQL from the Windows Command Line”
Section 2.3.6.8, “Testing The MySQL Installation”
Section 2.3.8, “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.3.9, “Windows Postinstallation Procedures”

-p N

Description

-p num

Description

-p path

Description

-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”
Description
Description
Description
Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”

-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”
Description
Description
Description
Description
Description
Section 6.6.3, “How to Repair MyISAM Tables”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”

-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”
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 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
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

-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”

-t

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”

-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.2.1, “Invoking MySQL Programs”
Section 2.3.6.8, “Testing The MySQL Installation”
Section 5.5.1, “User Names and Passwords”

-u {user_name|user_id}

Section 5.1.2, “Server Command Options”

-u root

Section 2.3.9, “Windows Postinstallation 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

-v

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 6.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.3.5, “Obtaining Table Information with myisamchk
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 16.6.11, “MySQL Cluster Replication Conflict Resolution”

-–ndb-log-updated-only

Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

/i

Section 2.3.4.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/passive

Section 2.3.4.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/quiet

Section 2.3.4.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/uninstall

Section 2.3.4.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/x

Section 2.3.4.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

Arbitration

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 16.1.4, “MySQL Cluster Development History”

ArbitrationDelay

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

ArbitrationRank

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”

ArbitrationTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”

AutoReconnect

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

BackupDataBufferSize

Section 16.5.3.3, “Configuration for MySQL Cluster Backups”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.3.4, “MySQL Cluster Backup Troubleshooting”

BackupDataDir

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

BackupLogBufferSize

Section 16.5.3.3, “Configuration for MySQL Cluster Backups”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.3.4, “MySQL Cluster Backup Troubleshooting”

BackupMaxWriteSize

Section 16.5.3.3, “Configuration for MySQL Cluster Backups”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

BackupMemory

Section 16.5.3.3, “Configuration for MySQL Cluster Backups”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.3.4, “MySQL Cluster Backup Troubleshooting”

BackupReportFrequency

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4, “MySQL Cluster Development History”

BackupWriteSize

Section 16.5.3.3, “Configuration for MySQL Cluster Backups”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

BatchByteSize

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

BatchSize

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

BatchSizePerLocalScan

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

BuildIndexThreads

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

CMAKE_INSTALL_PREFIX

Section 22.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”

Checksum

Section 12.7.5.37, “SHOW TABLE STATUS Syntax”
Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”
Section 19.22, “The INFORMATION_SCHEMA TABLES Table”

Com_alter_event

Section 18.4.6, “The Event Scheduler and MySQL Privileges”

Com_create_event

Section 18.4.6, “The Event Scheduler and MySQL Privileges”

Com_dealloc_sql

Section 5.1.5, “Server Status Variables”

Com_delete

Section 5.1.5, “Server Status Variables”

Com_drop_event

Section 18.4.6, “The Event Scheduler and MySQL Privileges”

Com_execute_sql

Section 5.1.5, “Server Status Variables”

Com_insert

Section E.1, “Restrictions on Stored Programs”
Section 5.1.5, “Server Status Variables”

Com_prepare_sql

Section 5.1.5, “Server Status Variables”

Com_select

Section 7.9.3.1, “How the Query Cache Operates”
Section 7.9.3.4, “Query Cache Status and Maintenance”
Section E.1, “Restrictions on Stored Programs”
Section 5.1.5, “Server Status Variables”

Com_show_create_event

Section 18.4.6, “The Event Scheduler and MySQL Privileges”

Com_show_events

Section 18.4.6, “The Event Scheduler and MySQL Privileges”

Com_stmt_close

Section 5.1.5, “Server Status Variables”

Com_stmt_execute

Section 5.1.5, “Server Status Variables”

Com_stmt_fetch

Section 5.1.5, “Server Status Variables”

Com_stmt_prepare

Section 5.1.5, “Server Status Variables”

Com_stmt_reprepare

Section 12.5.4, “Automatic Prepared Statement Repreparation”
Section 5.1.5, “Server Status Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

Com_stmt_reset

Section 5.1.5, “Server Status Variables”

Com_stmt_send_long_data

Section 5.1.5, “Server Status Variables”

CompressedBackup

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

CompressedLCP

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ConnectCheckIntervalDelay

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

CrashOnCorruptedTuple

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”

DEFAULT_CHARSET

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

DEFAULT_COLLATION

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

DISABLE_GRANT_OPTIONS

Description
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

DataDir

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Description
Section 16.5.5, “Event Reports Generated in MySQL Cluster”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.5, “Management of MySQL Cluster”
Section 16.5.11.1, “MySQL Cluster Disk Data Objects”
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 16.3.1, “Quick Test Setup of MySQL Cluster”
Section 16.5.11.2, “Using Symbolic Links with Disk Data Objects”
Section 16.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

DataMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section E.10.3, “Limits on Table Size”
Section 16.5, “Management of MySQL Cluster”
Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 16.5.11.3, “MySQL Cluster Disk Data Storage Requirements”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 16.5.9.7, “The ndbinfo memoryusage Table”

DefaultOperationRedoProblemAction

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

DictTrace

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

DiskCheckpointSpeed

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

DiskCheckpointSpeedInRestart

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

DiskIOThreadPool

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

DiskPageBufferMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.11.3, “MySQL Cluster Disk Data Storage Requirements”
Section 16.5.9.4, “The ndbinfo diskpagebuffer Table”

DiskSyncSize

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

Diskless

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ExecuteOnComputer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”

FileSystemPath

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

FileSystemPathDD

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.11.2, “Using Symbolic Links with Disk Data Objects”

FileSystemPathDataFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.11.2, “Using Symbolic Links with Disk Data Objects”

FileSystemPathUndoFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.11.2, “Using Symbolic Links with Disk Data Objects”

FragmentLogFileSize

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

HAVE_EMBEDDED_PRIVILEGE_CONTROL

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

HELP

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

HeartbeatIntervalDbApi

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.3, “MySQL Cluster Hardware, Software, and Networking Requirements”

HeartbeatIntervalDbDb

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”
Section 16.1.3, “MySQL Cluster Hardware, Software, and Networking Requirements”

HeartbeatOrder

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

HeartbeatThreadPriority

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

Host1SciId0

Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

Host1SciId1

Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

Host2SciId0

Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

Host2SciId1

Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

HostName

Section 16.3.2.4, “Defining Computers in a MySQL Cluster”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.2, “MySQL Cluster Installation”
Section 16.5.10.1, “MySQL Cluster Security and Networking Issues”
Section 16.3.1, “Quick Test Setup of MySQL Cluster”

HostName1

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.2.9, “MySQL Cluster TCP/IP Connections Using Direct Connections”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

Id

Section 12.7.5.5, “SHOW COLLATION Syntax”
Section 12.7.5.30, “SHOW PROCESSLIST Syntax”
Section 21.9.1, “C API Data Structures”
Section 9.4.2, “Choosing a Collation ID”
Section 5.7.1.1, “Connection Probes”
Section 16.3.2.4, “Defining Computers in a MySQL Cluster”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 7.12.5, “Examining Thread Information”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 5.7.1.6, “Query Execution Probes”
Section 5.7.1.3, “Query Probes”
Section 19.2, “The INFORMATION_SCHEMA COLLATIONS Table”
Section 19.15, “The INFORMATION_SCHEMA PROCESSLIST Table”

IndexMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section E.10.3, “Limits on Table Size”
Section 16.5.9.7, “The ndbinfo memoryusage Table”

InitFragmentLogFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

InitialLogFileGroup

Section 12.1.3, “ALTER LOGFILE GROUP Syntax”
Section 12.1.14, “CREATE LOGFILE GROUP Syntax”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

InitialNoOfOpenFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

InitialTablespace

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

Innodb_buffer_pool_read_ahead_rnd

Section 1.4, “What Is New in MySQL 5.5”

Innodb_buffer_pool_read_ahead_seq

Section 1.4, “What Is New in MySQL 5.5”

LockExecuteThreadToCPU

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LockMaintThreadsToCPU

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LockPagesInMainMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogDestination

Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 16.5.5, “Event Reports Generated in MySQL Cluster”
Section 16.5, “Management of MySQL Cluster”

LogLevelCheckpoint

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelCongestion

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelConnection

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelError

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelInfo

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelNodeRestart

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelShutdown

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelStartup

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LogLevelStatistic

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

LongMessageBuffer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MYSQL_MAINTAINER_MODE

Section 2.9.5, “Dealing with Problems Compiling MySQL”

MYSQL_TCP_PORT

Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”

MYSQL_UNIX_ADDR

Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”

MaxAllocate

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxBufferedEpochs

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”

MaxDMLOperationsPerTransaction

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxLCPStartDelay

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfAttributes

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentIndexOperations

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentOperations

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”

MaxNoOfConcurrentScans

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentSubOperations

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentTransactions

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfExecutionThreads

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”

MaxNoOfFiredTriggers

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfLocalOperations

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”

MaxNoOfLocalScans

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”

MaxNoOfOpenFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfOrderedIndexes

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”

MaxNoOfSavedMessages

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfSubscribers

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfSubscriptions

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfTables

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”

MaxNoOfTriggers

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MaxNoOfUniqueHashIndexes

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”

MaxParallelScansPerFragment

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”

MaxScanBatchSize

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

MaxStartFailRetries

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MemReportFrequency

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

MinFreePct

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

Name

Section 12.7.5.1, “SHOW AUTHORS Syntax”
Section 12.7.5.7, “SHOW CONTRIBUTORS Syntax”
Section 12.7.5.16, “SHOW ENGINE Syntax”
Section 12.7.5.19, “SHOW EVENTS Syntax”
Section 12.7.5.26, “SHOW PLUGINS Syntax”
Section 12.7.5.37, “SHOW TABLE STATUS Syntax”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.14, “The INFORMATION_SCHEMA PLUGINS Table”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”

Ndb_cluster_node_id

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

Ndb_conflict_fn_epoch

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_fn_epoch_trans

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_fn_max

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_fn_old

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_trans_conflict_commit_count

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_trans_detect_iter_count

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_trans_reject_count

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_trans_row_conflict_count

Section 16.3.4.4, “MySQL Cluster Status Variables”

Ndb_conflict_trans_row_reject_count

Section 16.3.4.4, “MySQL Cluster Status Variables”

NoOfDiskPagesToDiskAfterRestartACC

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskAfterRestartTUP

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskDuringRestartACC

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskDuringRestartTUP

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

NoOfFragmentLogFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.5.1, “Summary of MySQL Cluster Start Phases”

NoOfReplicas

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”

NodeGroup

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

NodeId

Section 16.3.2.4, “Defining Computers in a MySQL Cluster”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

NodeId1

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

NodeId2

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

Numa

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ODirect

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ON

Section 3.3.4.9, “Using More Than one Table”

OverloadLimit

Section 16.3.2.12, “Configuring MySQL Cluster Send Buffer Parameters”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”

PREFIX

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”

Performance_schema_locker_lost

Section 20.5, “Performance Schema Status Monitoring”
Section 20.9, “Performance Schema Status Variables”

PortNumber

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”

Queries

Section 5.1.5, “Server Status Variables”

Questions

Section 5.1.5, “Server Status Variables”

RealtimeScheduler

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ReceiveBufferMemory

Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”

RedoBuffer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

RedoOverCommitCounter

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

RedoOverCommitLimit

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”

ReservedSendBufferMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

RestartOnErrorInsert

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

SYSCONFDIR

Section 4.2.3.3, “Using Option Files”

SchedulerExecutionTimer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

SchedulerSpinTimer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

SendBufferMemory

Section 16.3.2.12, “Configuring MySQL Cluster Send Buffer Parameters”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”

SendLimit

Section 16.3.2.12, “Configuring MySQL Cluster Send Buffer Parameters”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

SendSignalId

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

ServerPort

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”

SharedBufferSize

Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”

SharedGlobalMemory

Section 12.1.3, “ALTER LOGFILE GROUP Syntax”
Section 12.1.14, “CREATE LOGFILE GROUP Syntax”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”

ShmKey

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”

ShmSize

Section 16.3.2.10, “MySQL Cluster Shared-Memory Connections”

StartFailRetryDelay

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

StartFailureTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

StartNoNodeGroupTimeout

Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

StartPartialTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Description

StartPartitionedTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Description

StartupStatusReportFrequency

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

StopOnError

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

StringMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

TcpBind_INADDR_ANY

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

TimeBetweenEpochs

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

TimeBetweenEpochsTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”

TimeBetweenGlobalCheckpoints

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”

TimeBetweenInactiveTransactionAbortCheck

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

TimeBetweenLocalCheckpoints

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

TimeBetweenWatchDogCheck

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

TimeBetweenWatchDogCheckInitial

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

TotalSendBufferMemory

Section 16.3.2.12, “Configuring MySQL Cluster Send Buffer Parameters”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”

TransactionBufferMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

TransactionDeadlockDetectionTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 15.4.1.26, “Replication Retries and Timeouts”
Section 15.1.3.3, “Replication Slave Options and Variables”

TransactionInactiveTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 15.4.1.26, “Replication Retries and Timeouts”
Section 15.1.3.3, “Replication Slave Options and Variables”

UndoDataBuffer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

UndoIndexBuffer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

WITH_COMMENT

Section 5.1.3, “Server System Variables”

WITH_DEBUG

Section 2.9.4, “MySQL Source-Configuration Options”

WITH_NDBCLUSTER_STORAGE_ENGINE

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”

WITH_PERFSCHEMA_STORAGE_ENGINE

Section 20.2.1, “Performance Schema Build Configuration”

WITH_ZLIB

Section 2.9.4, “MySQL Source-Configuration Options”

\#

Section 4.5.1.2, “mysql Commands”

\G

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 13.3.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.7.5.35, “SHOW SLAVE STATUS Syntax”
Description
Section 1.7, “How to Report Bugs or Problems”
Section 5.1.3, “Server System Variables”

\P

Section 4.5.1.2, “mysql Commands”

\W

Section 4.5.1.2, “mysql Commands”

\c

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

\e

Section 4.5.1.2, “mysql Commands”

\q

Section 4.5.1.2, “mysql Commands”
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.8.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, “String Literals”
Section 4.2.3.3, “Using Option Files”

\u db_name

Section 4.5.1.2, “mysql Commands”

\w

Section 4.5.1.2, “mysql Commands”

all

Section 7.8.2, “EXPLAIN Output Format”
Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 15.1.3.3, “Replication Slave Options and Variables”

analyze

Section 12.7.2.1, “ANALYZE TABLE Syntax”

ansi

Description

antonio

Section 5.5.6.2.2.3, “Unix Password Authentication with Proxy Users and Group Mapping”

auto_increment_increment

Section 15.1.3.2, “Replication Master Options and Variables”

auto_increment_offset

Section 15.1.3.2, “Replication Master Options and Variables”

automatic_sp_privileges

Section 12.1.26, “DROP PROCEDURE and DROP FUNCTION Syntax”

basedir

Section 2.3.6.2, “Creating an Option File”
Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.7, “Troubleshooting a MySQL Installation Under Windows”

binlog_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”

c

Section 12.1.7.3, “ALTER TABLE Examples”
Section 12.1.17.1, “CREATE TABLE ... SELECT Syntax”
Section 11.16.3, “GROUP BY and HAVING with Hidden Columns”
Section 17.2.3.1, “RANGE COLUMNS partitioning”
Description
Section 8.2.1, “Identifier Qualifiers”
Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section 9.1.14.1, “Unicode Character Sets”

character-sets-dir=path

Section 21.9.3.49, “mysql_options()

character_set_client

Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”

character_set_server

Section 11.9.4, “Full-Text Stopwords”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

charset

Section 9.1.4, “Connection Character Sets and Collations”

check

Section 12.7.2.2, “CHECK TABLE Syntax”
Section 22.2.4.2.2, “Server Plugin Status and System Variables”

clear

Section 4.5.1.2, “mysql Commands”

col

Section 15.1.3.2, “Replication Master Options and Variables”

collation_server

Section 11.9.4, “Full-Text Stopwords”

compress

Section 21.9.3.49, “mysql_options()
Section 21.9.17.1, “Problems Linking to the MySQL Client Library”

connect

Section 21.9.17.1, “Problems Linking to the MySQL Client Library”

connect_timeout

Section 4.5.1.1, “mysql Options”
Description

count

Section 12.7.5.16, “SHOW ENGINE Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 5.1.6, “Server SQL Modes”

csv

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.9.4, “MySQL Source-Configuration Options”

d

Section 12.1.7.3, “ALTER TABLE Examples”
Section 7.13.5, “LEFT JOIN and RIGHT JOIN Optimization”
Section 17.2.3.1, “RANGE COLUMNS partitioning”
Section 11.18.5, “Precision Math Examples”
Section 11.5.2, “Regular Expressions”
Section 22.5.3, “The DBUG Package”
Section 9.1.14.1, “Unicode Character Sets”

daemon

Section 16.3.2.5, “Defining a MySQL Cluster Management Server”

database

Section 5.7.1.11, “Filesort Probes”
Section 5.7.1.9, “Index Probes”
Section 5.7.1.10, “Lock Probes”
Section 5.7.1.6, “Query Execution Probes”
Section 5.7.1.3, “Query Probes”
Section 5.7.1.8, “Read Row Probes”
Section 5.7.1.7, “Row-Level Probes”

datadir

Section 2.3.6.2, “Creating an Option File”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.7, “Troubleshooting a MySQL Installation Under Windows”
Section E.10.5, “Windows Platform Limitations”

date

Section 11.7, “Date and Time Functions”

db

Section 12.7.5.30, “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”
Description
Section 7.12.5, “Examining Thread Information”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section E.7, “Restrictions on Character Sets”
Section 19.12, “The INFORMATION_SCHEMA PARAMETERS Table”
Section 19.15, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 2.10.1, “Unix Postinstallation 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.1, “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 4.5.1.2, “mysql Commands”
Section 12.6.1, “BEGIN ... END Compound-Statement Syntax”
Section 12.1.11, “CREATE EVENT Syntax”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 18.1, “Defining Stored Programs”

description

Section 12.8.3, “HELP Syntax”

e

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

edit

Section 4.5.1.2, “mysql Commands”

ego

Section 4.5.1.2, “mysql Commands”

engine_condition_pushdown

Section 7.8.4.2, “Controlling Switchable Optimizations”
Section 5.1.3, “Server System Variables”

event-scheduler=DISABLED

Section 18.4.2, “Event Scheduler Configuration”

event_scheduler

Section 12.7.5.30, “SHOW PROCESSLIST Syntax”

exit

Section 4.5.1.2, “mysql Commands”
Section 22.5.3, “The DBUG Package”

extended-status

Description

external_user

Section 22.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 5.5.7, “Proxy Users”
Section 22.2.4.9.1, “Writing the Server-Side Authentication Plugin”

fields

Section 13.3.14.2.3, “InnoDB Table Monitor Output”

flush-hosts

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

flush-logs

Section 12.7.6.3, “FLUSH Syntax”
Description
Section 5.2, “MySQL Server Logs”
Section 5.4.1, “Privileges Provided by MySQL”

flush-privileges

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

flush-status

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

flush-tables

Section 12.7.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 16.6.4, “MySQL Cluster Replication Schema and Tables”

general_log

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

have_partition_engine

Chapter 17, Partitioning
Section 5.1.3, “Server System Variables”

have_profiling

Section 5.1.3, “Server System Variables”

help

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.4, “mysql Server-Side Help”

host

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 5.7.1.2, “Command Probes”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 5.7.1.1, “Connection Probes”
Section 13.3.5.2, “Converting Tables from Other Storage Engines to InnoDB
Description
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.7.1.6, “Query Execution Probes”
Section 5.7.1.3, “Query Probes”
Section 2.10.1, “Unix Postinstallation Procedures”

init-file

Section 7.9.2.2, “Multiple Key Caches”

initial

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

innodb

Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 20.4, “Performance Schema Instrument Naming Conventions”

innodb-safe-binlog

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb-status-file=1

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

innodb_buffer_pool_instances

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.9.1, “The InnoDB Buffer Pool”

innodb_buffer_pool_size

Section 13.3.4, “InnoDB Startup Options and System Variables”
Section 7.9.1, “The InnoDB Buffer Pool”

innodb_file_io_threads

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

innodb_file_per_table

Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 13.3.12.2, “File Space Management”
Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
Section 5.1.2, “Server Command Options”
Section 13.3.3, “Using Per-Table Tablespaces”

innodb_flush_method

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_io_capacity

Section 13.3.4, “InnoDB Startup Options and System Variables”

innodb_support_xa

Section 13.3.4, “InnoDB Startup Options and System Variables”

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”
Section 7.6.3, “Speed of REPAIR TABLE Statements”

language

Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 1.4, “What Is New in MySQL 5.5”

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.21, “mysql_stmt_prepare()
Section 21.9.7.26, “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.4, “Writing Full-Text Parser Plugins”

license

Section 22.2.4.2.3, “Client Plugin Descriptors”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”

local

Section 5.1.4.1, “Structured System Variables”

local-infile

Section 5.3.5, “Security Issues with LOAD DATA LOCAL

lock

Section 20.7.3.1, “The events_waits_current Table”

log

Section 2.9.3, “Installing MySQL from a Development Source Tree”

log-slave-updates

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

log_bin_trust_routine_creators

Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

lower_case_table_names

Section 5.1.3, “Server System Variables”

master-xxx

Section 15.1.3.3, “Replication Slave Options and Variables”

max_allowed_packet

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

max_binlog_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”

max_binlog_stmt_cache_size

Section 15.1.3.4, “Binary Log Options and 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”

mode

Section 21.9.3.2, “mysql_autocommit()
Section 22.2.4.4, “Writing Full-Text Parser Plugins”

multi_range_count

Section 16.3.4.3, “MySQL Cluster System Variables”

myisam_block_size

Section 4.6.3.1, “myisamchk General Options”

myisam_max_extra_sort_file_size

Section 1.4, “What Is New in MySQL 5.5”

myisam_stats_method

Section 4.6.3.1, “myisamchk General Options”

myisamchk

Description

mysql

Section 4.5.1.1, “mysql Options”
Section 4.5.1.4, “mysql Server-Side Help”
Section 12.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.1.16, “CREATE SERVER Syntax”
Section 12.7.1.1, “CREATE USER Syntax”
Section C.5.2.4, “Client does not support authentication protocol
Section 12.7.3.2, “DROP FUNCTION Syntax”
Section 12.7.1.2, “DROP USER Syntax”
Section 12.7.6.3, “FLUSH Syntax”
Section 12.7.1.3, “GRANT Syntax”
Section 12.8.3, “HELP Syntax”
Section C.5.2.9, “MySQL server has gone away
Section 12.7.1.4, “RENAME USER Syntax”
Section 12.7.1.5, “REVOKE Syntax”
Section 12.7.1.6, “SET PASSWORD Syntax”
Section 12.7.5.22, “SHOW GRANTS Syntax”
Section 21.9.3.3, “mysql_change_user()
Section 21.9.10.1, “mysql_client_find_plugin()
Section 21.9.10.2, “mysql_client_register_plugin()
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.10.3, “mysql_load_plugin()
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.26, “mysql_stmt_send_long_data()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 12.7.1, “Account Management Statements”
Section 5.5.2, “Adding User Accounts”
Section 5.3.2.1, “Administrator Guidelines for Password Security”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 5.5.5, “Assigning Account Passwords”
Section 21.9.15, “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.3.5.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Description
Description
Description
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 2.11.2, “Downgrading MySQL”
Section 7.11.4.2, “Enabling Large Page Support”
Section 6.3.1, “Establishing a Backup Policy”
Section 18.4.4, “Event Metadata”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 5.3.1, “General Security Guidelines”
Section 7.9.3.1, “How the Query Cache Operates”
Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.5.1, “Installing MySQL from RPM Packages on Linux”
Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
Section 2.7.2, “Installing MySQL on HP-UX using DEPOT”
Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”
Section 2.4, “Installing MySQL on Mac OS X”
Section 2.6.2, “Installing MySQL on OpenSolaris using IPS”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.6.1, “Installing MySQL on Solaris using a Solaris PKG
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 5.5.6.2.2.2, “LDAP Authentication without Proxy Users”
Section 13.3.15, “Limits on InnoDB Tables”
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 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 21.10, “MySQL PHP API”
Section 9.6, “MySQL Server Time Zone Support”
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.10.1.1, “Problems Running mysql_install_db
Section 15.4.4, “Replication FAQ”
Section 15.4.1.10, “Replication and FLUSH
Section 15.4.1.20, “Replication of the mysql System Database”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section E.7, “Restrictions on Character Sets”
Section E.1, “Restrictions on Stored Programs”
Section 8.2, “Schema Object Names”
Section 2.10.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.4.3, “Specifying Account Names”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
Section 2.10.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 12.3.5.3, “Table-Locking Restrictions and Conditions”
Section 5.4, “The MySQL Access Privilege System”
Section 22.2, “The MySQL Plugin API”
Section 2.3.7, “Troubleshooting a MySQL Installation Under Windows”
Section 5.5.6.2.2.3, “Unix Password Authentication with Proxy Users and Group Mapping”
Section 5.5.6.2.2.1, “Unix Password Authentication without Proxy Users”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 2.11.1, “Upgrading MySQL”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
Section 5.5.1, “User Names and Passwords”
Section 13.3.3.1, “Using Raw Devices for the Shared Tablespace”
Section 5.5.8.2, “Using SSL Connections”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 18.2, “Using Stored Routines (Procedures and Functions)”
Section 18.4, “Using the Event Scheduler”
Section 5.5.6.2.2, “Using the PAM Authentication Plugin”
Section 1.4, “What Is New in MySQL 5.5”
Section 2.3.9, “Windows Postinstallation Procedures”

mysql-server

Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”

mysql_plugin

Description

mysqlaccess

Description

mysqladmin

Section 9.1.4, “Connection Character Sets and Collations”
Description

mysqlbinlog

Description

mysqlcheck

Section 9.1.4, “Connection Character Sets and Collations”
Description

mysqld

Section C.5.2.2, “Can't connect to [local] MySQL server
Section 13.11.1, “FEDERATED Storage Engine Overview”
Section 21.9.2, “C API Function Overview”
Description
Description
Section 16.3.4.1, “MySQL Cluster mysqld Option and Variable Reference”
Section 5.1.1, “Server Option and Variable Reference”
Section 15.2.2.2, “Slave Status Logs”
Section 5.2.2, “The Error Log”
Section 22.5.1.3, “Using pdb to create a Windows crashdump”

mysqld_safe

Description
Section 5.2.2, “The Error Log”

mysqldump

Section 6.2, “Database Backup Methods”
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 16.2.3, “Initial Configuration of MySQL Cluster”
Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 16.6.5, “Preparing the MySQL Cluster for Replication”

ndb_autoincrement_prefetch_sz

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_bin

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_log_binlog_index

Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_mgmd

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”

ndb_optimization_delay

Section 12.7.2.4, “OPTIMIZE TABLE Syntax”
Section 16.1.6.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 16.3.4.3, “MySQL Cluster System Variables”

ndbcluster

Section 16.4.1, “MySQL Server Usage for MySQL Cluster”

ndbd

Description

net_retry_count

Section 15.2.1, “Replication Implementation Details”

net_write_timeout

Section 15.2.1, “Replication Implementation Details”

nice

Description

nodes

Section 16.5.9.8, “The ndbinfo nodes Table”

nopager

Section 4.5.1.2, “mysql Commands”

notee

Section 4.5.1.2, “mysql Commands”

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.24, “mysql_stmt_row_seek()

open-files-limit

Section C.5.2.7, “Too many connections

open_files_limit

Description
Section E.10.5, “Windows Platform Limitations”

opt

Section 22.2.4.2.2, “Server Plugin Status and System Variables”

optimize

Section 12.7.2.4, “OPTIMIZE TABLE Syntax”

p

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

pager

Section 4.5.1.2, “mysql Commands”

partition

Chapter 17, Partitioning

password

Description

performance_schema

Section 12.7.5.16, “SHOW ENGINE Syntax”
Description
Section 7.9.3.1, “How the Query Cache Operates”
Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
Section 7.12.4, “Measuring Performance with performance_schema
Chapter 20, MySQL Performance Schema
Section 20.2.1, “Performance Schema Build Configuration”
Section 20.6, “Performance Schema General Table Characteristics”
Section 20.1, “Performance Schema Quick Start”
Section 20.5, “Performance Schema Status Monitoring”
Section 20.7, “Performance Schema Table Descriptions”
Section 20.10, “Performance Schema and Plugins”
Section E.8, “Restrictions on Performance Schema”
Section 12.3.5.3, “Table-Locking Restrictions and Conditions”

pid-file

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

ping

Description
Section 15.4.5, “Troubleshooting Replication”

pipe

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

plugin

Section 21.9.10.2, “mysql_client_register_plugin()
Section 21.9.10.5, “mysql_plugin_options()
Section 22.2.2, “Plugin API Components”
Section 5.4.2, “Privilege System Grant Tables”
Section 22.2, “The MySQL Plugin API”

port

Section 21.9.3.52, “mysql_real_connect()

print

Section 4.5.1.2, “mysql Commands”
Section 11.5.2, “Regular Expressions”

processlist

Description

prompt

Section 4.5.1.2, “mysql Commands”

query

Section 5.7.1.5, “Query Cache Probes”
Section 5.7.1.6, “Query Execution Probes”
Section 5.7.1.4, “Query Parsing Probes”
Section 5.7.1.3, “Query Probes”
Section 5.7.1.12, “Statement Probes”

query_cache_type

Section 5.1.3, “Server System Variables”

quick

Section 4.2.3.3, “Using Option Files”

quit

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

raw

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

read_buffer_size

Section 4.6.3.1, “myisamchk General Options”
Section 7.6.3, “Speed of REPAIR TABLE Statements”

read_only

Section 5.1.3, “Server System Variables”

reconnect

Section C.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.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

record_buffer

Section 1.4, “What Is New in MySQL 5.5”

refresh

Description
Section 5.2, “MySQL Server Logs”
Section 5.4.1, “Privileges Provided by MySQL”

rehash

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section C.5.8, “Known Issues in MySQL”

reload

Description
Section 5.4.1, “Privileges Provided by MySQL”

repair

Section 12.7.2.5, “REPAIR TABLE Syntax”

replication-ignore-table

Section 15.4.1.31, “Replication and Views”

resolve_stack_dump

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

rows

Section 7.8.2, “EXPLAIN Output Format”
Section 17.3.4, “Obtaining Information About Partitions”
Section 5.7.1.5, “Query Cache Probes”
Section 5.7.1.12, “Statement Probes”

s

Section 11.5.2, “Regular Expressions”
Section 9.1.14.1, “Unicode Character Sets”

select_limit

Section 4.5.1.1, “mysql Options”

server-id

Section 15.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 15.1, “Replication Configuration”
Section 15.1.3.2, “Replication Master Options and Variables”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.1.1.8, “Setting Up Replication with Existing Data”
Section 15.1.1.1, “Setting the Replication Master Configuration”
Section 15.1.1.2, “Setting the Replication Slave Configuration”

server_id

Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 16.3.4.3, “MySQL Cluster System Variables”

set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

shutdown

Description

shutdown_timeout

Description

skip-networking

Section 15.4.4, “Replication FAQ”
Section 15.1.1.1, “Setting the Replication Master Configuration”
Section 15.4.5, “Troubleshooting Replication”

skip-slave-start

Section 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
Section 16.6.5, “Preparing the MySQL Cluster for Replication”
Section 16.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

slave

Section 16.5.14, “NDB API Statistics Counters and Variables”
Section 1.2, “Typographical and Syntax Conventions”

slave_type_conversions

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

socket

Section 21.2.6, “Connector/Net Connection String Options Reference”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”

sort

Section 11.16.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”
Section 7.6.3, “Speed of REPAIR TABLE Statements”

sort_key_blocks

Section 4.6.3.1, “myisamchk General Options”

source

Section 4.5.1.5, “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.6, “Server SQL Modes”

sql-mode="modes"

Section 5.1.6, “Server SQL Modes”

sql_big_tables

Section 5.1.3, “Server System Variables”

sql_log_update

Section 1.4, “What Is New in MySQL 5.5”

sql_low_priority_updates

Section 5.1.3, “Server System Variables”

sql_max_join_size

Section 5.1.3, “Server System Variables”

ssl-ca

Section 15.3.7, “Setting Up Replication Using SSL”

ssl-cert

Section 15.3.7, “Setting Up Replication Using SSL”

ssl-key

Section 15.3.7, “Setting Up Replication Using SSL”

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.7.2.1, “ANALYZE TABLE Syntax”
Section 12.7.2.2, “CHECK TABLE Syntax”
Section 12.7.2.4, “OPTIMIZE TABLE Syntax”
Section 12.7.2.5, “REPAIR TABLE Syntax”
Section 5.7.1.2, “Command Probes”
Section 5.7.1.1, “Connection Probes”
Description
Section 5.7.1.11, “Filesort Probes”
Section 5.7.1.9, “Index Probes”
Section 5.7.1.10, “Lock Probes”
Section 16.5.7, “MySQL Cluster Single User Mode”
Section 5.7.1.13, “Network Probes”
Section 5.7.1.6, “Query Execution Probes”
Section 5.7.1.4, “Query Parsing Probes”
Section 5.7.1.3, “Query Probes”
Section 5.7.1.8, “Read Row Probes”
Section 5.7.1.7, “Row-Level Probes”
Section 5.7.1.12, “Statement Probes”
Section 16.5.9.8, “The ndbinfo nodes Table”
Section 16.5.9.10, “The ndbinfo transporters Table”

stop-slave

Description

syslog

Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Description
Section 16.5.5, “Event Reports Generated in MySQL Cluster”
Section 16.5.5.1, “MySQL Cluster Logging Management Commands”
Section 5.2.2, “The Error Log”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

system

Section 4.5.1.2, “mysql Commands”
Chapter 19, INFORMATION_SCHEMA Tables
Section 16.5.6.1, “MySQL Cluster: Messages in the Cluster Log”
Section 2.9.4, “MySQL Source-Configuration Options”

tab

Section 11.5.2, “Regular Expressions”

table

Section 7.8.2, “EXPLAIN Output Format”
Section 21.9.1, “C API Data Structures”
Section 5.7.1.11, “Filesort Probes”
Section 5.7.1.9, “Index Probes”
Section 5.7.1.10, “Lock Probes”
Section 5.7.1.8, “Read Row Probes”
Section 5.7.1.7, “Row-Level Probes”
Section 12.2.10.8, “Subqueries in the FROM Clause”

table_type

Section 1.4, “What Is New in MySQL 5.5”

tee

Section 4.5.1.2, “mysql Commands”

test

Section 13.3.14.2.3, “InnoDB Table Monitor Output”
Section 12.2.7, “LOAD XML Syntax”
Section 12.7.5.19, “SHOW EVENTS Syntax”
Section 9.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 11.4, “Control Flow Functions”
Section 13.3.5, “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.5.14, “NDB API Statistics Counters and Variables”
Section 7.2.4, “Optimizing INFORMATION_SCHEMA Queries”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 2.10.2, “Securing the Initial MySQL Accounts”
Section 18.2.1, “Stored Routine Syntax”
Section 19.13, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 4.2.3.1, “Using Options on the Command Line”
Section 2.3.9, “Windows Postinstallation Procedures”

thread_handling

Section 7.11.6.1, “Thread Pool Components and Installation”

timeout

Section 21.9.3.49, “mysql_options()

tmpdir

Section 2.3, “Installing MySQL on Microsoft Windows”

type

Section 12.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 7.8.2, “EXPLAIN Output Format”
Section 13.3.14.2.3, “InnoDB Table Monitor Output”
Section 21.9.10.1, “mysql_client_find_plugin()
Section 21.9.10.3, “mysql_load_plugin()
Section 21.9.1, “C API Data Structures”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Section 7.2.1.4, “How to Avoid Full Table Scans”
Section 7.13.2, “Index Merge Optimization”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 22.2.4.2.2, “Server Plugin Status and System Variables”
Section 19.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 22.2.4.4, “Writing Full-Text Parser Plugins”

update

Section 7.12.5.3, “Delayed-Insert Thread States”
Description
Section 22.2.4.2.2, “Server Plugin Status and System Variables”

use db_name

Section 4.5.1.2, “mysql Commands”

user

Section 12.7.1.2, “DROP USER Syntax”
Section C.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.5.5, “Assigning Account Passwords”
Section 5.5.10, “Auditing MySQL Account Activity”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 5.7.1.2, “Command Probes”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 5.7.1.1, “Connection Probes”
Section 13.3.5.2, “Converting Tables from Other Storage Engines to InnoDB
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Description
Section 11.13, “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 5.7.1.6, “Query Execution Probes”
Section 5.7.1.3, “Query Probes”
Section E.7, “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.10.1.2, “Starting and Stopping MySQL Automatically”
Section 5.5.6.2.2.3, “Unix Password Authentication with Proxy Users and Group Mapping”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 5.5.1, “User Names and Passwords”
Section 5.5.8.2, “Using SSL Connections”
Section 11.11, “XML Functions”

v

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

variables

Description

version

Section 22.2.4.2.3, “Client Plugin Descriptors”
Description
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”

wait

Section 20.4, “Performance Schema Instrument Naming Conventions”

wait_timeout

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

warning_count

Section 5.1.3, “Server System Variables”

warnings

Section 4.5.1.2, “mysql Commands”

with-unix-socket-path

Section 2.9.4, “MySQL Source-Configuration Options”

write

Description
Section 20.7.3.1, “The events_waits_current Table”

write_buffer_size

Section 4.6.3.1, “myisamchk General Options”
Section 7.6.3, “Speed of REPAIR TABLE Statements”