Option Index

-

Section 12.1.1, “ALTER DATABASE Syntax”
Section 11.18.2, “DECIMAL Data Type Changes”
Section 12.4.1.3, “GRANT Syntax”
Section 11.6.1, “Arithmetic Operators”
Section 11.9.2, “Boolean Full-Text Searches”
Section 10.7, “Choosing the Right Type for a Column”
Section 11.7, “Date and Time Functions”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 8.1.2, “Numbers”
Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”
Section 11.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 4.2.3.1, “Using Options on the Command Line”

-#

Section 21.5.3, “The DBUG Package”

-# [debug_options]

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

-# [debug_options]

Section 5.1.2, “Server Command Options”

-# debug_options

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

-#...

Section 21.5.3, “The DBUG Package”

-#D,20

Section 21.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
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--add-locks

Description

--add-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--addtodest

Description

--all

Section 1.5, “What Is New in MySQL 5.1”

--all-databases

Description
Description
Description
Section 6.4.1, “Dumping Data in SQL Format with mysqldump
Section 8.2.3, “Mapping of Identifiers to File Names”
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.5, “What Is New in MySQL 5.1”

--allow-keywords

Description

--allow-suspicious-udfs

Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 21.3.2.6, “User-Defined Function Security Precautions”

--allowold

Description

--analyze

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

--angel-pid-file

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--angel-pid-file=file_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--ansi

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

--apply-slave-statements

Description

--auto-generate-sql

Description

--auto-generate-sql-add-autoincrement

Description

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

Description

--auto-generate-sql-guid-primary

Description

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

Description

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

Description

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

Description

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

Description

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

Description

--auto-generate-sql-write-number

Description

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

Description

--auto-rehash

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

--auto-repair

Description

--auto-vertical-output

Section 4.5.1.1, “mysql Options”

--autoclose

Description

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

--backup_history_log

Section 5.1.2, “Server Command Options”

--backup_progress_log

Section 5.1.2, “Server Command Options”

--base64-output

Description

--base64-output=ALWAYS

Description

--base64-output=AUTO

Description

--base64-output=DECODE-ROWS

Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 15.1.2.1, “Comparison 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
Section 2.11.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”

--basedir=path

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-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 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server System Variables”

--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”
Section 4.6.10.4, “Instance Manager User and Password Management”

--bind-address=IP

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

--bind-address=ip_address

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

--binlog-checksum={NONE|CRC32}

Section 15.1.3.4, “Binary Log Options and Variables”

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

--binlog-rows-query-log-events

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”

--blob-info

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--block-search=offset

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

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

--brief

Description

--build=x86_64-pc-solaris2.10

Section 2.11, “Installing MySQL from Source”

--burnin

Description

--cflags

Description

--character-set-client-handshake

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

--character-set-filesystem=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server

Section 9.5, “Character Set Configuration”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 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 8.4, “User-Defined Variables”
Section 1.5, “What Is New in MySQL 5.1”

--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.11.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-password-file

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--check-upgrade

Description
Description

--checkpoint

Description

--checkpoint=db_name.tbl_name

Description

--chroot

Description

--chroot=path

Description
Section 5.1.2, “Server Command Options”

--clean-password-file

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

--collation-server

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

--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.11.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.6.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”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

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

--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”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--configinfo

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--configinfo --xml

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--console

Section 13.6.13.3, “InnoDB General Troubleshooting”
Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.6.2.4, “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 5.2.2, “The Error Log”

--copy

Description

--core-file

Section 21.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.5, “What Is New in MySQL 5.1”

--create-schema=value

Description

--create=value

Description

--csv[=file_name]

Description

--daemon

Description

--data-file-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--database

Description

--database=db_name

Section 4.5.1.1, “mysql Options”
Description

--databases

Section 6.4.5.2, “Copy a Database from one Server to Another”
Description
Description
Section 6.4.1, “Dumping Data in SQL Format with mysqldump
Section 6.4.5.1, “Making a Copy of a Database”
Section 6.4.2, “Reloading SQL-Format Backups”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”

--datadir

Description
Description
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”
Section 4.2.3.3, “Using Option Files”

--datadir=path

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 21.5.1.1, “Compiling MySQL for Debugging”
Description
Description
Description
Section 5.1.3, “Server System Variables”
Section 21.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.11.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 21.5.3, “The DBUG Package”

--debug="d,parser_debug"

Section 2.11.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
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--debug[=debug_options]

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

--default-auth

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

--default-auth=plugin

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

--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 1.5, “What Is New in MySQL 5.1”

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

--default-collation=collation_name

Section 5.1.2, “Server Command Options”

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

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-mysqld-path=path

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-storage-engine

Section 13.6.2, “Configuring InnoDB
Section 13.6.3, “InnoDB Startup Options and System Variables”
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.3, “Setting the Storage Engine”
Chapter 13, Storage Engines
Section 1.5, “What Is New in MySQL 5.1”

--default-storage-engine=type

Section 5.1.2, “Server Command Options”

--default-table-type

Chapter 13, Storage Engines
Section 1.5, “What Is New in MySQL 5.1”

--default-table-type=type

Section 5.1.2, “Server Command Options”

--default-time-zone

Section 15.4.1.29, “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.5, “What Is New in MySQL 5.1”

--defaults-extra-file=file_name

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

--defaults-extra-file=path

Description
Section 4.2.3.3, “Using Option Files”

--defaults-file

Section 13.6.2, “Configuring InnoDB
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Section 20.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”

--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 4.6.10.1, “MySQL Instance Manager Command Options”
Section 2.11.4, “MySQL Source-Configuration Options”

--defaults-group-suffix

Section 2.14, “Environment Variables”

--defaults-group-suffix=_other

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

--defaults-group-suffix=str

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

--defaults-group-suffix=suffix

Description

--delay-key-write

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

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

Section 1.5, “What Is New in MySQL 5.1”

--delay-key-write=ALL

Section 13.5.1, “MyISAM Startup Options”
Section 7.7.4, “External Locking”
Section 15.4.4, “Replication FAQ”
Section 1.5, “What Is New in MySQL 5.1”

--delay-key-write=OFF

Section 7.7.4, “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

--delayed-start=N

Description

--delete

Description

--delete-master-logs

Description

--delimiter

Description

--delimiter=str

Section 4.5.1.1, “mysql Options”
Description

--demangle

Section 21.5.1.5, “Using a Stack Trace”

--des-key-file

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

--disable-debug-sync

Section 2.11.4, “MySQL Source-Configuration Options”

--disable-dtrace

Section 2.11.4, “MySQL Source-Configuration Options”

--disable-grant-options

Description
Section 2.11.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.11.4, “MySQL Source-Configuration Options”

--disable-shared

Section 2.11.4, “MySQL Source-Configuration Options”

--disconnect-slave-event-count

Section 15.1.3.3, “Replication Slave Options and Variables”

--drop-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--dryrun

Description

--dump

Description

--dump-date

Description

--dump-slave

Description

--dump-slave[=value]

Description

--edit-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--embedded

Description
Description

--enable-assembler

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

--enable-community-features

Section 2.11.4, “MySQL Source-Configuration Options”

--enable-debug-sync

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

--enable-dtrace

Section 2.11.4, “MySQL Source-Configuration Options”

--enable-local-infile

Section 5.3.5, “Security Issues with LOAD DATA LOCAL

--enable-locking

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

--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 5.1.2, “Server Command Options”

--enable-plugin_name

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--enable-profiling

Section 2.11.4, “MySQL Source-Configuration Options”

--enable-pstack

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

--enable-thread-safe-client

Section 2.11.4, “MySQL Source-Configuration Options”

--engine-condition-pushdown=1

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

--engine=engine_name

Description

--event-scheduler

Section 5.1.2, “Server Command Options”

--event-scheduler=DISABLED

Section 5.1.2, “Server Command Options”

--event-scheduler[=value]

Section 5.1.2, “Server Command Options”

--events

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

--example

Description

--exclude-databases

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--exclude-missing-columns

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--exclude-tables

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--exe-suffix=suffix

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.7.4, “External Locking”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 7.9.1, “System Factors and Startup Parameter Tuning”
Section 1.5, “What Is New in MySQL 5.1”

--extra-file=file_name

Description

--extra-node-info

Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--extra-partition-info

Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--fast

Section 4.6.3.2, “myisamchk Check Options”
Description

--federated

Section 13.11, “The FEDERATED Storage Engine”

--fields-enclosed-by

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

--fields-enclosed-by=...

Description
Description

--fields-enclosed-by=char

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

--fields-escaped-by=...

Description
Description

--fields-escaped-by=char

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

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

Description
Description

--fields-optionally-enclosed-by=char

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

--fields-terminated-by=...

Description
Description

--fields-terminated-by=str

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

--fields-xxx

Description

--first-slave

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

--fix-db-names

Description

--fix-table-names

Description

--flush

Section 5.1.2, “Server Command Options”
Section 5.1.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”

--flush-privileges

Description

--flush_time=val

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

--force-read

Description

--gdb

Section 21.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”
Section 1.5, “What Is New in MySQL 5.1”

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

--header_file=file_name

Description

--help

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.2, “Server Command Options”
Section 7.9.2, “Tuning Server Parameters”
Chapter 3, Tutorial
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.6.3, “InnoDB Startup Options and System Variables”

--ignore-lines=N

Description

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-sql-errors

Description

--ignore-table=db_name.tbl_name

Description

--in_file=file_name

Description

--include

Description

--include-databases

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--include-master-host-port

Description

--include-tables

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--info

Description
Description

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-file

Section 2.11.4, “MySQL Source-Configuration Options”
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.9, “The MEMORY Storage Engine”

--init-file=file_name

Section 5.1.2, “Server Command Options”

--init_connect="SET NAMES 'utf8'"

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

--initial

Section 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.3.2, “MySQL Cluster Configuration Files”
Section 16.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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”
Section 16.2.7.2, “Upgrade and Downgrade Compatibility: MySQL Cluster NDB 6.x”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”

--initial-start

Description

--innodb

Section 13.6.3, “InnoDB Startup Options and System Variables”

--innodb-autoinc-lock-mode

Section 13.6.4.3.2, “Configurable InnoDB Auto-Increment Locking”

--innodb-safe-binlog

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

--innodb-status-file

Section 13.6.3, “InnoDB Startup Options and System Variables”

--innodb-status-file=1

Section 13.6.3, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.2, “Server Command Options”

--innodb=OFF

Section 13.6.2, “Configuring InnoDB
Section 13.6.3, “InnoDB Startup Options and System Variables”

--innodb[=value]

Section 13.6.3, “InnoDB Startup Options and System Variables”

--innodb_checksums

Section 13.6.3, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 5.1.2, “Server Command Options”
Section 13.6.2.2, “Using Per-Table Tablespaces”
Section 7.9.6.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.6.12, “InnoDB Error Handling”
Section 13.6.3, “InnoDB Startup Options and System Variables”

--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 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

--install [service_name]

Section 5.1.2, “Server Command Options”

--install-manual

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

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

--label=str

Description

--language

Section D.1.47, “Changes in MySQL 5.1.21 (16 August 2007)”
Section 5.1.2, “Server Command Options”
Section 9.2, “Setting the Error Message Language”

--language=lang_name, -L lang_name

Section 5.1.2, “Server Command Options”

--large-pages

Section 7.9.7, “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”

--lc-messages-dir

Section 5.1.2, “Server Command Options”
Section 9.2, “Setting the Error Message Language”

--lc-messages-dir=path

Section 5.1.2, “Server Command Options”

--lc-messages=locale_name

Section 5.1.2, “Server Command Options”

--ldata=path

Description

--ledir

Description

--ledir=path

Description

--length

Description

--libmysqld-libs

Description

--libs

Description

--libs_r

Description

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Description

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

Description

--lines-terminated-by=...

Description
Description

--lines-terminated-by=str

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

--list-users

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--local

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

--local-infile

Section 2.11.4, “MySQL Source-Configuration Options”

--local-infile=0

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

--local-infile=1

Section 4.5.1.1, “mysql Options”

--local-infile[=1]

Section 5.3.5, “Security Issues with LOAD DATA LOCAL

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

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

--local-load

Description

--local-load=path

Description

--lock-all-tables

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

--lock-directory

Description

--lock-directory=path

Description

--lock-tables

Description
Description

--log

Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.2.3, “The General Query Log”
Section 1.5, “What Is New in MySQL 5.1”

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

Section 5.1.2, “Server Command Options”

--log-bin

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 6.3.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”
Section 1.5, “What Is New in MySQL 5.1”

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

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

--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=base_name.extension

Section 5.2.4, “The Binary Log”

--log-bin=log_name

Section 6.3.3, “Backup Strategy Summary”

--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.4.6.3, “FLUSH Syntax”
Description
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.2, “Server Command Options”
Section 5.2.6, “Server Log Maintenance”
Section 5.2.2, “The Error Log”

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

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

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

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

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

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

--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
Section 4.6.10.1, “MySQL Instance Manager Command Options”

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

--loose-opt_name

Section 4.2.3.3, “Using Option Files”

--lossy-conversions

Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--low-priority

Description

--low-priority-updates

Section 12.2.5, “INSERT Syntax”
Section 7.7.3, “Concurrent Inserts”
Section 15.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 7.7.2, “Table Locking Issues”

--lower-case-table-names=0

Section 8.2.2, “Identifier Case Sensitivity”

--malloc-lib

Description

--malloc-lib=

Description

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

Description

--malloc-lib=[lib_name]

Description

--malloc-lib=tcmalloc

Description

--master-bind

Section 12.5.2.1, “CHANGE MASTER TO Syntax”

--master-connect-retry

Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
Section 7.10.6, “Replication Slave I/O Thread States”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.4.1.17, “Replication and Master or Slave Shutdowns”
Section 1.5, “What Is New in MySQL 5.1”

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

--master-data[=value]

Description

--master-host

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

--master-host=host_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-info-file

Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.2.2.2, “Slave Status Logs”

--master-info-file=file_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-info-repository

Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.2.2.2, “Slave Status Logs”
Section 1.5, “What Is New in MySQL 5.1”

--master-info-repository=TABLE

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 15.2.2, “Replication Relay and Status Logs”

--master-info-repository={FILE|TABLE}

Section 15.1.3.4, “Binary Log Options and Variables”

--master-password

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

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

--master-port=port_number

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-retry-count

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 12.4.5.36, “SHOW SLAVE STATUS 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.5, “What Is New in MySQL 5.1”

--master-ssl*

Section 5.5.6.3, “SSL Command Options”

--master-ssl-ca

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

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

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

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

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

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

--master-user=user_name

Section 15.1.3.3, “Replication Slave Options and Variables”

--master-verify-checksum={0|1}

Section 15.1.3.4, “Binary Log Options and Variables”

--master-xxx

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

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-binlog-dump-events=N

Section 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.4.2.6, “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.3.1.16, “How to Avoid 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.4.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.6.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.6.2.3, “Using Raw Devices for the Shared Tablespace”

--method=command

Description

--min-examined-row-limit=number

Section 5.1.2, “Server Command Options”

--monitoring-interval=seconds

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--mutex-deadlock-detector

Section 5.1.2, “Server Command Options”

--my-plugin=1

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--my-plugin=ON

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--my_plugin=1

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--my_plugin=ON

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--myisam-block-size

Section 7.6.1.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.3.4, “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 21.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.3.4, “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 21.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”

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

Section 5.1.2, “Server Command Options”

--mysqladmin=prog_name

Description

--mysqld

Description

--mysqld-safe-compatible

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

--mysqld-version

Description

--mysqld-version=debug

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=prog_name

Description
Description

--name_file=file_name

Description

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Description

--ndb-batch-size

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

--ndb-batch-size=#

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-blob-read-batch-bytes

Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

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

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-blob-write-batch-bytes

Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

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

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

--ndb-cluster-connection-pool=#

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=4

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-connectstring

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 16.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”

--ndb-connectstring=connect_string

Section 16.3.4.2, “mysqld Command 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 Configurations for MySQL Cluster NDB 6.2 and Later”

--ndb-index-stat-enable=0

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

--ndb-log-apply-status

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

--ndb-log-empty-epochs

Section 15.1.3.3, “Replication Slave Options and Variables”

--ndb-log-orig

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”

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

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

--ndb-nodeid=#

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-use-exact-count=0

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

--ndb-wait-connected=seconds

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-wait-setup=seconds

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb_optimized_node_selection

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.3.4.3, “MySQL Cluster System Variables”

--ndbcluster

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 12.4.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.4.1, “MySQL Server Usage for MySQL Cluster”
Section 16.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
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

--no-create-info

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

--no-data

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

--no-debug

Description

--no-defaults

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

--no-embedded

Description

--no-log

Description

--no-named-commands

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

--no-pager

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

--no-set-names

Description

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tablespaces

Description

--no-tee

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

--nodaemon

Description

--nodeid

Section 16.3.4.2, “mysqld Command 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
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--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-blob-cols=str

Description

--number-char-cols=N

Description

--number-int-cols=N

Description

--number-of-queries=N

Description

--numeric-dump-file=file_name

Description

--offset=N

Description

--old-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”
Section 1.5, “What Is New in MySQL 5.1”

--only-debug

Description

--only-print

Description

--open-files-limit

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 7.8.2, “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.6.13.1, “InnoDB Performance Tuning Tips”
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”

--passwd

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

--password

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

--password-file

Section 4.6.10.4, “Instance Manager User and Password Management”

--password-file=file_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--password=

Section 4.2.2, “Connecting to the MySQL Server”

--password=pass_val

Section 4.2.3.1, “Using Options on the Command Line”

--password=password

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

--password=your_pass

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

--password[=pass_val]

Section 4.2.2, “Connecting to the MySQL Server”

--password[=password]

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

--pid-file

Description
Section 5.1.3, “Server System Variables”

--pid-file=file_name

Description
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6, “Running Multiple MySQL 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

--plan

Description

--plugin

Section 5.1.2, “Server Command Options”

--plugin-dir=path

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

--plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--plugin-load

Section 12.4.3.3, “INSTALL PLUGIN Syntax”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 21.2.2, “Plugin API Components”
Section 21.2.4.2, “Plugin Data Structures”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 21.2.4.2.1, “Library and Plugin Descriptors”
Section 21.2, “The MySQL Plugin API”

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

--plugin_dir=path

Section 21.2.2, “Plugin API Components”

--plugin_name

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=0

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=1

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=FORCE

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=FORCE_PLUS_PERMANENT

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=OFF

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--plugin_name=ON

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--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.11.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 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 4.6.10.1, “MySQL Instance Manager Command Options”
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.5, “What Is New in MySQL 5.1”

--position=N

Description

--post-query=value

Description

--post-system=str

Description

--pre-query=value

Description

--pre-system=str

Description

--prefix

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.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”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--print-password-line

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

--prompt

Section 4.5.1.2, “mysql Commands”

--prompt=format_str

Section 4.5.1.1, “mysql Options”

--protocol

Section 4.2.2, “Connecting to the MySQL Server”
Description

--protocol=MEMORY

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

--protocol=PIPE

Section 4.2.2, “Connecting to the MySQL Server”
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.7.4, “External Locking”

--query=value

Description

--quick

Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 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”
Description
Section 1.5, “What Is New in MySQL 5.1”

--read-from-remote-server

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

--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.1.3.4, “Binary Log Options and Variables”
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-info-repository

Section 15.1.3.4, “Binary Log Options and Variables”
Section 15.2.2.2, “Slave Status Logs”
Section 1.5, “What Is New in MySQL 5.1”

--relay-log-info-repository=TABLE

Section 15.2.2, “Replication Relay and Status Logs”

--relay-log-info-repository={FILE|TABLE}

Section 15.1.3.4, “Binary Log 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.5.2.1, “CHANGE MASTER TO Syntax”

--relay-log=relay_log_index

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

--relnotes

Description

--reload

Section 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.3.2, “MySQL Cluster Configuration Files”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

--remove

Description
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

--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 Routines, Triggers, and Events”

--replicate-*-do-*

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-ignore-*

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-table

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

--replicate-[do|ignore]-table

Section 13.14, “The BLACKHOLE Storage Engine”

--replicate-do-*

Section 16.6.3, “Known Issues in MySQL Cluster Replication”

--replicate-do-db

Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 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.23, “Replication and Reserved Words”
Section 15.4.1.20, “Replication and Temporary Tables”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
Section 5.2.4, “The Binary Log”

--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.4.5.36, “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.23, “Replication and Reserved Words”
Section 15.4.1.20, “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.4.5.36, “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.23, “Replication and Reserved Words”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
Section 5.2.4, “The Binary Log”

--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.4.5.36, “SHOW SLAVE STATUS Syntax”
Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
Section 15.4.1.23, “Replication and Reserved Words”
Section 15.4.1.20, “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 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
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="db1->db3"

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--replicate-same-server-id

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.1.3, “Replication and Binary Logging Options and Variables”

--replicate-wild-do-table

Section 12.4.5.36, “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.20, “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 Routines, Triggers, and Events”

--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.4.5.36, “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.20, “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.20, “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.4.5.35, “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

Description

--result-file=file_name

Description

--result-file=name

Description

--rewrite-database

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--rhost=host_name

Description

--rollback

Description

--routines

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

--rows=N

Description

--rpm

Description

--run-as-service

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--safe-mode

Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 21.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.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 1.5, “What Is New in MySQL 5.1”

--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-backup-file-priv

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

--secure-backup-file-priv=path

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

--secure-file-priv

Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

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

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”
Description
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.3.4.3, “MySQL Cluster System Variables”

--server-id-bits=#

Section 16.3.4.2, “mysqld Command 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.4.5.35, “SHOW SLAVE HOSTS Syntax”

--service-startup-timeout=file_name

Description

--set-auto-increment[=value]

Section 4.6.3.4, “Other myisamchk Options”

--set-character-set=name

Section 4.6.3.3, “myisamchk Repair Options”

--set-charset

Description

--set-charset=charset_name

Description

--set-collation

Section 4.6.3.3, “myisamchk Repair Options”

--set-collation=name

Section 4.6.3.3, “myisamchk Repair Options”

--set-random-seed=value

Description

--set-variable

Section 4.5.1.1, “mysql Options”
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.5, “What Is New in MySQL 5.1”

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

--shared-memory-base-name

Section 20.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.6.6, “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.6.13.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-broken-objects

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

--skip-character-set-client-handshake

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

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Description

--skip-compact

Description

--skip-concurrent-insert

Section 5.1.2, “Server Command Options”

--skip-disable-keys

Description

--skip-dump-date

Description

--skip-engine_name

Section 12.4.5.17, “SHOW ENGINES Syntax”

--skip-event-scheduler

Section 5.1.2, “Server Command Options”

--skip-events

Section 6.4.5.3, “Dumping Stored Programs”

--skip-extended-insert

Description

--skip-external-locking

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

--skip-grant-tables

Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.4.3.3, “INSTALL PLUGIN Syntax”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Description
Description
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 2.11.4, “MySQL Source-Configuration Options”
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 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.9.8, “How MySQL Uses DNS”
Section 5.1.2, “Server Command Options”

--skip-innodb

Section 13.6.2, “Configuring InnoDB
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 12.4.5.17, “SHOW ENGINES Syntax”
Section 15.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”

--skip-innodb-checksums

Section 13.6.3, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 13.6.3, “InnoDB Startup Options and System Variables”

--skip-innodb_checksums

Section 13.6.3, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 13.6.3, “InnoDB Startup Options and System Variables”

--skip-kill-mysqld

Description

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-lock-tables

Description

--skip-locking

Section 1.5, “What Is New in MySQL 5.1”

--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.8, “The MERGE Storage Engine”

--skip-mutex-deadlock-detector

Section 5.1.2, “Server Command Options”

--skip-name-resolve

Section 5.4.7, “Causes of Access-Denied Errors”
Description
Section 7.9.8, “How MySQL Uses DNS”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-named-commands

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

--skip-ndbcluster

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

--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.9.8, “How MySQL Uses DNS”
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”

--skip-new

Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 21.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.5, “What Is New in MySQL 5.1”

--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 20.9.11, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.6.3, “Disabling mysql Auto-Reconnect”

--skip-routines

Section 6.4.5.3, “Dumping Stored Programs”

--skip-safemalloc

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 5.1.2, “Server Command Options”

--skip-set-charset

Description

--skip-show-database

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

--skip-slave-start

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 12.5.2.7, “START SLAVE Syntax”
Section 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.6.3, “SSL Command Options”

--skip-stack-trace

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

--skip-super-large-pages

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

--skip-symbolic-links

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

--skip-symlink

Section 1.5, “What Is New in MySQL 5.1”

--skip-syslog

Description
Section 5.2.2, “The Error Log”

--skip-tee

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

--skip-thread-priority

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

--skip-triggers

Description
Section 6.4.5.3, “Dumping Stored Programs”

--skip-tz-utc

Description

--skip-use-db

Description

--skip-write-binlog

Description
Description

--skip-xxx

Description

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave

Description

--slave-allow-batching

Section 16.1.4.6, “MySQL Cluster Development in MySQL Cluster NDB 6.1”

--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.25, “Slave Errors During Replication”

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

Section 15.1.3.3, “Replication Slave Options and Variables”

--slave-sql-verify-checksum

Section 15.1.3.4, “Binary Log Options and Variables”
Section 1.5, “What Is New in MySQL 5.1”

--slave-sql-verify-checksum={0|1}

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_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”
Section 1.5, “What Is New in MySQL 5.1”

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

--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.11.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.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 4.6.10.1, “MySQL Instance Manager Command Options”
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.5, “What Is New in MySQL 5.1”

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

Section 10.3.1.1, “TIMESTAMP Properties”

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

Section 5.1.2, “Server Command Options”

--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.6.3, “SSL Command Options”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.5.6.2, “Using SSL Connections”

--ssl*

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

--ssl-ca

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

--ssl-ca=file_name

Section 5.5.6.3, “SSL Command Options”

--ssl-capath

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

--ssl-capath=directory_name

Section 5.5.6.3, “SSL Command Options”

--ssl-cert

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

--ssl-cert=file_name

Section 5.5.6.3, “SSL Command Options”

--ssl-cipher

Section 15.1.3.3, “Replication Slave Options and Variables”

--ssl-cipher=cipher_list

Section 5.5.6.3, “SSL Command Options”

--ssl-key

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

--ssl-key=file_name

Section 5.5.6.3, “SSL Command Options”

--ssl-verify-server-cert

Section 5.5.6.3, “SSL Command Options”

--ssl-xxx

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.3, “Server System Variables”
Section 5.5.6.2, “Using SSL Connections”

--ssl=0

Section 5.5.6.3, “SSL Command Options”

--standalone

Section 21.5.1.2, “Creating Trace Files”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.1.2, “Server Command Options”

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

--start-position=N

Description

--start_row=N

Description

--statefile=file_name

Description

--static

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

--stats

Description

--status

Description

--stop-datetime

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

--stop-datetime=datetime

Description

--stop-never

Description

--stop-never-slave-server-id

Description

--stop-never-slave-server-id=id

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

--superuser=user_name

Description

--symbolic-links

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

--symbols-file=file_name

Description

--sysconfdir

Section 4.2.3.3, “Using Option Files”

--sysdate-is-now

Section 15.1.2.1, “Comparison of Statement-Based and Row-Based Replication”
Section 11.7, “Date and Time Functions”
Section 15.4.1.12, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--syslog

Description
Section 5.2.2, “The Error Log”

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

--table_open_cache

Section 7.8.2, “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 21.5.1.4, “Debugging mysqld under gdb

--thread_handling=no-threads

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

--thread_handling=one-thread-per-connection

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

--thread_handling=pool-of-threads

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

--thread_pool_size=N

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

--thread_stack=N

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

--timer-length=N

Description

--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.29, “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.6.8, “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.5, “What Is New in MySQL 5.1”

--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.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.10, “Installing MySQL on i5/OS”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.2, “Server Command Options”
Section 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”
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--user={user_name|user_id}

Description
Section 5.1.2, “Server Command Options”

--username

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

--username=user_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--var_name=value

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

--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, “Comparison of Statement-Based and Row-Based Replication”
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 15.1.2.2, “Usage of Row-Based Logging and Replication”
Section 5.1.2, “Server Command Options”
Section 7.9.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--version

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

--vertical

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

--wait

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

--wait-timeout=N

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--wait[=count]

Description

--warnings

Section 1.5, “What Is New in MySQL 5.1”

--where='where_condition'

Description

--windows

Description

--with

Section 2.11.4, “MySQL Source-Configuration Options”

--with-archive-storage-engine

Section 13.12, “The ARCHIVE Storage Engine”

--with-big-tables

Section 13.8.2, “MERGE Table Problems”
Section 2.11.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.14, “The BLACKHOLE Storage Engine”

--with-charset

Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.11.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.11.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.13, “The CSV Storage Engine”

--with-debug

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 21.5.2, “Debugging a MySQL Client”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.11.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 21.5.1.1, “Compiling MySQL for Debugging”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 21.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-embedded-privilege-control

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

--with-embedded-server

Section 20.8.1, “Compiling Programs with libmysqld
Section 2.11.4, “MySQL Source-Configuration Options”

--with-example-storage-engine

Section 13.10, “The EXAMPLE Storage Engine”

--with-extra-charsets=LIST

Section 2.11.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-libevent

Section 7.9.3, “How MySQL Uses Threads for Client Connections”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”

--with-low-memory

Section 2.11.5, “Dealing with Problems Compiling MySQL”

--with-max-indexes=N

Section 13.5, “The MyISAM Storage Engine”

--with-mysql-sock[=DIR]

Section 20.10.4, “MySQL Functions (PDO_MYSQL)”

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

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

--with-mysqld-ldflags=-rdynamic

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

--with-named-z-libs=no

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

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

Chapter 17, Partitioning

--with-pdo-mysql[=DIR]

Section 20.10.4, “MySQL Functions (PDO_MYSQL)”

--with-plugin-PLUGIN

Section 2.11.4, “MySQL Source-Configuration Options”

--with-plugins

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 2.11.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.5, “What Is New in MySQL 5.1”

--with-ssl

Section 5.5.6.2, “Using SSL Connections”

--with-tcp-port

Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.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.11.3, “Installing MySQL from a Development Source Tree”

--with-vio

Section 5.5.6.2, “Using SSL Connections”

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

Section 2.11.4, “MySQL Source-Configuration Options”

--with-zlib-dir[=DIR]

Section 20.10.4, “MySQL Functions (PDO_MYSQL)”

--without

Section 2.11.4, “MySQL Source-Configuration Options”

--without-libevent

Section 7.9.3, “How MySQL Uses Threads for Client Connections”
Section 2.11.4, “MySQL Source-Configuration Options”

--without-plugin-PLUGIN

Section 2.11.4, “MySQL Source-Configuration Options”

--without-query-cache

Section 7.6.3, “The MySQL Query Cache”

--without-server

Section 2.11.4, “MySQL Source-Configuration Options”

--write-binlog

Description
Description

--xml

Section 4.5.1.1, “mysql Options”
Description
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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.3, “HASH Partitioning”
Section 20.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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-A

Section 4.5.1.1, “mysql Options”
Description
Description

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

-DBUILD_CONFIG=mysql_release

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

-DCMAKE_BUILD_TYPE=Debug

Section 2.11.4, “MySQL Source-Configuration Options”

-DCMAKE_INSTALL_PREFIX=dir_name

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

-DCPACK_MONOLITHIC_INSTALL=1

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

-DENABLE_DEBUG_SYNC=1

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

-DINSTALL_SQLBENCHDIR=

Section 2.11.4, “MySQL Source-Configuration Options”

-DSAFEMALLOC

Appendix A, Licenses for Third-Party Components

-DUSE_ALARM_THREAD

Section 21.1.1, “MySQL Threads”

-DWITH_ARCHIVE_STORAGE_ENGINE

Section 13.12, “The ARCHIVE Storage Engine”

-DWITH_BLACKHOLE_STORAGE_ENGINE

Section 13.14, “The BLACKHOLE Storage Engine”

-DWITH_DEBUG=1

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 21.5.2, “Debugging a MySQL Client”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.11.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 20.8.1, “Compiling Programs with libmysqld

-DWITH_EXAMPLE_STORAGE_ENGINE

Section 13.10, “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_EXTRA_CHARSETS=complex

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

-DWITH_FEDERATED_STORAGE_ENGINE

Section 13.11, “The FEDERATED Storage Engine”

-DWITH_PARTITION_STORAGE_ENGINE

Chapter 17, Partitioning

-DWITH_SSL=system

Section 5.5.6.2, “Using SSL Connections”

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

-I/usr/local/mysql/include

Section 20.9.16, “Building Client Programs”

-K

Description

-L

Section 4.5.1.1, “mysql Options”
Section 20.9.16, “Building Client Programs”
Description
Section 5.3.5, “Security Issues with LOAD DATA LOCAL
Section 9.2, “Setting the Error Message Language”

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

Section 20.9.16, “Building Client Programs”

-Lpath

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

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

-O file_name

Description

-O0

Section 2.11.5, “Dealing with Problems Compiling MySQL”

-O2

Section 2.11.9, “Notes on Installing MySQL on AIX from Source”

-O3

Section 2.11.9, “Notes on Installing MySQL on AIX from Source”

-P

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

-P port_num

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

-P[password]

Description

-Q

Description

-R

Description
Description

-R N

Section 4.6.3.4, “Other myisamchk Options”

-R index_num

Section 6.6.4, “MyISAM Table Optimization”

-R record_pos_file record_pos

Description

-S

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

-S file_name

Section 4.2.2, “Connecting to the MySQL Server”
Description

-S path

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

-T

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

-T [flags]

Section 5.1.2, “Server Command Options”

-T path

Description
Description

-U

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

-U user_name

Description

-V

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

-W

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

-W [level]

Section 5.1.2, “Server Command Options”

-Wl,r/full/path/to/libmysqlclient.so

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

-X

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

-Y

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

-a

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

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

-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

-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”
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”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

-f N

Description

-felide-constructors

Section 2.11, “Installing MySQL from Source”
Section 2.11.4, “MySQL Source-Configuration Options”

-fno-exceptions

Section 2.11, “Installing MySQL from Source”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 2.11.9, “Notes on Installing MySQL on AIX from Source”

-fno-inline

Section 2.11.5, “Dealing with Problems Compiling MySQL”

-fno-rtti

Section 2.11, “Installing MySQL from Source”
Section 2.11.4, “MySQL Source-Configuration Options”

-fomit-frame-pointer

Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 21.5.1.5, “Using a Stack Trace”

-fomit-frame-pointer -ffixed-ebp

Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”

-g

Section 4.5.1.1, “mysql Options”
Section 21.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 21.5.1.3, “Using pdb to create a Windows crashdump”

-i N

Description

-i delay

Description

-i name

Description

-j N

Description

-j big_tbl_name

Description

-k

Description

-k val

Section 4.6.3.3, “myisamchk Repair Options”

-l

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

-l [file_name]

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

-l path

Description

-lg++

Section 2.11.5, “Dealing with Problems Compiling MySQL”

-lgcc

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

-libmysqlclient

Section 20.9.2, “C API Function Overview”

-libmysqld

Section 20.9.2, “C API Function Overview”

-lm

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

-lmysqlclient

Section 20.9.3.39, “mysql_library_end()
Section 20.9.9, “C API Embedded Server Function Descriptions”

-lmysqlclient -lz

Section 20.9.16, “Building Client Programs”

-lmysqld

Section 20.9.3.39, “mysql_library_end()
Section 20.9.9, “C API Embedded Server Function Descriptions”

-lz

Section 20.8.1, “Compiling Programs with libmysqld
Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

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

-m64

Section 2.11, “Installing MySQL from Source”
Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

-mcpu

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

-mcpu=v8 -Wa,-xarch=v8plusa

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

-mcpu=v8 -Wa,-xarch=v8plusa

Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”

-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 20.8.1, “Compiling Programs with libmysqld
Description

-o async

Section 7.9.5, “Disk Issues”

-o N

Description

-o noatime

Section 7.9.5, “Disk Issues”

-o offset

Description

-p

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 17.2.4, “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
Section 5.3.2.2, “End-User Guidelines for Password Security”
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section C.5.2.5, “Password Fails When Entered Interactively”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”

-p N

Description

-p num

Description

-p password

Section 4.6.10.1, “MySQL Instance Manager Command Options”

-p[pass_val]

Section 4.2.2, “Connecting to the MySQL Server”

-p[password]

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

-ppass_val

Section 4.2.3.1, “Using Options on the Command Line”

-ppassword

Description

-pyour_pass

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

-q

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

-q value

Description

-qstrict

Section 2.11.9, “Notes on Installing MySQL on AIX from Source”

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

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

-static

Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”

-t

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

-t N

Description

-t path

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

-u

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

-u {user_name|user_id}

Section 5.1.2, “Server Command Options”

-u user_name

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

-v

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 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”

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”
Section 16.1.4.6, “MySQL Cluster Development in MySQL Cluster NDB 6.1”

ArbitrationTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
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”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

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 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”

Checksum

Section 12.4.5.38, “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.2, “The INFORMATION_SCHEMA TABLES Table”

Com_dealloc_sql

Section 5.1.5, “Server Status Variables”

Com_delete

Section 5.1.5, “Server Status Variables”

Com_execute_sql

Section 5.1.5, “Server Status Variables”

Com_insert

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

Com_prepare_sql

Section 5.1.5, “Server Status Variables”

Com_select

Section 7.6.3.1, “How the Query Cache Operates”
Section 7.6.3.4, “Query Cache Status and Maintenance”
Section E.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 5.1.5, “Server Status Variables”

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.6.4, “Automatic Prepared Statement Repreparation”
Section 5.1.5, “Server Status Variables”

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.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
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”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

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.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
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.7.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”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

DictTrace

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

DiskCheckpointSpeed

Section 16.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

DiskCheckpointSpeedInRestart

Section 16.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
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.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
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.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
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.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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 20.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.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”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

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”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

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 16.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 12.4.5.5, “SHOW COLLATION Syntax”
Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
Section 20.9.1, “C API Data Structures”
Section 9.4.2, “Choosing a Collation ID”
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.10, “Examining Thread Information”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 19.10, “The INFORMATION_SCHEMA COLLATIONS Table”
Section 19.22, “The INFORMATION_SCHEMA PROCESSLIST Table”

IndexMemory

Section 16.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
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.7.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”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

InitialNoOfOpenFiles

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

InitialTablespace

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

Innodb_buffer_pool_read_ahead_rnd

Section 1.5, “What Is New in MySQL 5.1”

Innodb_buffer_pool_read_ahead_seq

Section 1.5, “What Is New in MySQL 5.1”

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.11.5, “Dealing with Problems Compiling MySQL”

MYSQL_TCP_PORT

Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.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.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.4, “MySQL Source-Configuration Options”

MaxAllocate

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

MaxBufferedEpochs

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

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.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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”

Name

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

Ndb_cluster_node_id

Section 16.3.4.2, “mysqld Command Options for MySQL Cluster”

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”

NoOfDiskPagesToDiskAfterRestartACC

Section 16.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskAfterRestartTUP

Section 16.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
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.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
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.4.2, “mysqld Command Options for MySQL Cluster”
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”

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 4.2.3.2, “Program Option Modifiers”
Section 5.1.3, “Server System Variables”
Section 3.3.4.9, “Using More Than one Table”

OverloadLimit

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

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”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

ReceiveBufferMemory

Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.2.7.1, “Upgrade and downgrade compatibility: MySQL Cluster NDB 7.x”

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”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

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”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

ReservedSendBufferMemory

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

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”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

SchedulerSpinTimer

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”

SendBufferMemory

Section 16.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
Section 16.2.7.1, “Upgrade and downgrade compatibility: MySQL Cluster NDB 7.x”

SendLimit

Section 16.3.2.13, “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”

Slave_running

Section 5.1.5, “Server Status Variables”

Ssl_cipher

Section 15.2.2.2, “Slave Status Logs”

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”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”

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.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”

TimeBetweenEpochsTimeout

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
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”

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.13, “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.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
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.27, “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.27, “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.11.4, “MySQL Source-Configuration Options”

WITH_ZLIB

Section 2.11.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.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
Description
Section 1.7, “How to Report Bugs or Problems”
Section 5.1.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.6.2, “Using SSL Connections”

\t

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

\u db_name

Section 4.5.1.2, “mysql Commands”

\w

Section 4.5.1.2, “mysql Commands”

all

Section 7.2.2, “EXPLAIN Output Format”
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 15.1.3.3, “Replication Slave Options and Variables”

analyze

Section 12.4.2.1, “ANALYZE TABLE Syntax”

ansi

Description

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”

backup

Section 12.4.2.2, “BACKUP TABLE Syntax”

binlog_cache_size

Section 15.1.3.4, “Binary Log Options and Variables”

binlog_checksum

Section 15.1.3.4, “Binary Log Options and Variables”

binlog_row_image

Section 15.1.3.4, “Binary Log Options and Variables”

binlog_rows_query_log_events

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”
Description
Section 8.2.1, “Identifier Qualifiers”
Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section 9.1.13.1, “Unicode Character Sets”
Section 1.5, “What Is New in MySQL 5.1”

character-sets-dir=path

Section 20.9.3.49, “mysql_options()

character_set_client

Section 19.20, “The INFORMATION_SCHEMA EVENTS Table”

character_set_server

Section 11.9.4, “Full-Text Stopwords”

charset

Section 9.1.4, “Connection Character Sets and Collations”

check

Section 12.4.2.3, “CHECK TABLE Syntax”
Section 21.2.4.2.2, “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 20.9.3.49, “mysql_options()
Section 20.9.16.1, “Problems Linking to the MySQL Client Library”

connect

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

connect_timeout

Section 4.5.1.1, “mysql Options”
Description

count

Section 12.4.5.16, “SHOW ENGINE Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 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.11.4, “MySQL Source-Configuration Options”

d

Section 12.1.7.3, “ALTER TABLE Examples”
Section 7.3.1.7, “LEFT JOIN and RIGHT JOIN Optimization”
Section 11.18.5, “Precision Math Examples”
Section 11.5.2, “Regular Expressions”
Section 21.5.3, “The DBUG Package”
Section 9.1.13.1, “Unicode Character Sets”

daemon

Section 16.3.2.5, “Defining a MySQL Cluster Management Server”

data

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

datadir

Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section E.7.5, “Windows Platform Limitations”

date

Section 11.7, “Date and Time Functions”

db

Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
Section 20.9.3.3, “mysql_change_user()
Section 20.9.3.8, “mysql_create_db()
Section 20.9.3.11, “mysql_drop_db()
Section 20.9.3.52, “mysql_real_connect()
Section 20.9.3.60, “mysql_select_db()
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 20.9.1, “C API Data Structures”
Section 5.4.7, “Causes of Access-Denied Errors”
Description
Section 7.10, “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.6, “Restrictions on Character Sets”
Section 19.22, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

debug

Section 20.9.3.49, “mysql_options()
Description

decode_bits

Section 4.6.3.1, “myisamchk General Options”

default-storage-engine

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

default-table-type

Chapter 13, Storage Engines

defaults-extra-file

Section 4.2.3.3, “Using Option Files”

delimiter

Section 4.5.1.2, “mysql Commands”
Section 12.7.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 20.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.4.2, “Controlling Switchable Optimizations”
Section 5.1.3, “Server System Variables”
Section 1.5, “What Is New in MySQL 5.1”

event_scheduler

Section 12.4.5.31, “SHOW PROCESSLIST Syntax”

exit

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

extended-status

Description

fields

Section 13.6.13.2.3, “InnoDB Table Monitor Output”

flush-backup-logs

Description

flush-hosts

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

flush-logs

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

flush-privileges

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

flush-status

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

flush-tables

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

flush-threads

Description
Section 5.4.1, “Privileges Provided by MySQL”

ft_max_word_len

Section 4.6.3.1, “myisamchk General Options”

ft_min_word_len

Section 4.6.3.1, “myisamchk General Options”

ft_stopword_file

Section 4.6.3.1, “myisamchk General Options”

gci

Section 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 20.9.3.7, “mysql_connect()
Section 20.9.3.52, “mysql_real_connect()
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB
Description
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”

ibmdb2i_assume_exclusive_use

Section 13.7.2, “Configuration Options”

ibmdb2i_async_enabled

Section 13.7.2, “Configuration Options”

ibmdb2i_compat_opt_allow_zero_date_vals

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

ibmdb2i_compat_opt_blob_cols

Section 13.7.2, “Configuration Options”

ibmdb2i_compat_opt_time_as_duration

Section 13.7.2, “Configuration Options”

ibmdb2i_compat_opt_year_as_int

Section 13.7.2, “Configuration Options”

ibmdb2i_create_index_option

Section 13.7.2, “Configuration Options”

ibmdb2i_create_time_columns_as_tod

Section 13.7.2, “Configuration Options”

ibmdb2i_lob_alloc_size

Section 13.7.2, “Configuration Options”

ibmdb2i_map_blob_to_varchar

Section 13.7.2, “Configuration Options”

ibmdb2i_max_read_buffer_size

Section 13.7.2, “Configuration Options”

ibmdb2i_max_write_buffer_size

Section 13.7.2, “Configuration Options”

ibmdb2i_propagate_default_col_val

Section 13.7.2, “Configuration Options”

ibmdb2i_propagate_default_col_vals

Section 13.7.2, “Configuration Options”

ibmdb2i_rdb_name

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

ibmdb2i_system_trace_level

Section 13.7.2, “Configuration Options”

ibmdb2i_transaction_unsafe

Section 13.7.2, “Configuration Options”

ignore-builtin-innodb

Section 13.6.2.1, “Using InnoDB Plugin Instead of the Built-In InnoDB

init-file

Section 7.6.1.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 13.6.2.1, “Using InnoDB Plugin Instead of the Built-In InnoDB

innodb-safe-binlog

Section 13.6.3, “InnoDB Startup Options and System Variables”

innodb-status-file=1

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

innodb_buffer_pool_instances

Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 7.6.2, “The InnoDB Buffer Pool”

innodb_buffer_pool_size

Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 7.6.2, “The InnoDB Buffer Pool”

innodb_file_per_table

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

innodb_io_capacity

Section 13.6.3, “InnoDB Startup Options and System Variables”

innodb_support_xa

Section 13.6.3, “InnoDB Startup Options and System Variables”

interactive_timeout

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

language

Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 1.5, “What Is New in MySQL 5.1”

ledir

Description
Description

length

Section 20.9.3.34, “mysql_hex_string()
Section 20.9.3.53, “mysql_real_escape_string()
Section 20.9.3.54, “mysql_real_query()
Section 20.9.7.11, “mysql_stmt_fetch()
Section 20.9.7.20, “mysql_stmt_prepare()
Section 20.9.7.25, “mysql_stmt_send_long_data()
Section 20.9.1, “C API Data Structures”
Section 20.9.5, “C API Prepared Statement Data Structures”
Section 21.2.4.4, “Writing Full-Text Parser Plugins”

license

Section 21.2.4.2.1, “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

log

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

log-slave-updates

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

log_backup_output

Section 5.1.3, “Server System 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 5.1.3, “Server System Variables”
Section 1.5, “What Is New in MySQL 5.1”

lower_case_table_names

Section 5.1.3, “Server System Variables”

master-xxx

Section 15.1.3.3, “Replication Slave Options and Variables”

master_verify_checksum

Section 15.1.3.4, “Binary Log Options and Variables”
Section 1.5, “What Is New in MySQL 5.1”

max_allowed_packet

Section 4.5.1.1, “mysql Options”
Description
Section 15.4.1.18, “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_long_data_size

Section 1.5, “What Is New in MySQL 5.1”

max_user_connections

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

mode

Section 20.9.3.2, “mysql_autocommit()
Section 21.2.4.4, “Writing Full-Text Parser Plugins”

multi_range_count

Section 16.3.4.3, “MySQL Cluster System Variables”
Section 5.1.3, “Server System Variables”

myisam_block_size

Section 4.6.3.1, “myisamchk General Options”

myisam_max_extra_sort_file_size

Section 1.5, “What Is New in MySQL 5.1”

myisam_stats_method

Section 4.6.3.1, “myisamchk General Options”

myisamchk

Description

mysql

Section 4.5.1.1, “mysql Options”
Section 4.5.1.4, “mysql Server-Side Help”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.1.16, “CREATE SERVER Syntax”
Section 12.4.1.1, “CREATE USER Syntax”
Section C.5.2.4, “Client does not support authentication protocol
Section 12.4.3.2, “DROP FUNCTION Syntax”
Section 12.4.1.2, “DROP USER Syntax”
Section 12.4.6.3, “FLUSH Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.8.3, “HELP Syntax”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section C.5.2.9, “MySQL server has gone away
Section 12.4.1.4, “RENAME USER Syntax”
Section 12.4.1.5, “REVOKE Syntax”
Section 12.4.1.6, “SET PASSWORD Syntax”
Section 12.4.5.22, “SHOW GRANTS Syntax”
Section 20.9.3.3, “mysql_change_user()
Section 20.9.3.5, “mysql_close()
Section 20.9.3.14, “mysql_errno()
Section 20.9.3.15, “mysql_error()
Section 20.9.3.33, “mysql_get_ssl_cipher()
Section 20.9.3.36, “mysql_init()
Section 20.9.3.53, “mysql_real_escape_string()
Section 20.9.3.60, “mysql_select_db()
Section 20.9.3.67, “mysql_ssl_set()
Section 20.9.7.10, “mysql_stmt_execute()
Section 20.9.7.11, “mysql_stmt_fetch()
Section 20.9.7.25, “mysql_stmt_send_long_data()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 12.4.1, “Account Management Statements”
Section 5.5.2, “Adding User Accounts”
Section 5.3.2.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 20.9.14, “C API Prepared Statement Handling of Date and Time Values”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 15.1.2.1, “Comparison of Statement-Based and Row-Based Replication”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 9.1.4, “Connection Character Sets and Collations”
Chapter 20, Connectors and APIs
Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB
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
Description
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 7.9.7, “Enabling Large Page Support”
Section 6.3.1, “Establishing a Backup Policy”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 5.3.1, “General Security Guidelines”
Section 7.6.3.1, “How the Query Cache Operates”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.5.1, “Installing MySQL from RPM Packages on Linux”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
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.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 20.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 15.4.4, “Replication FAQ”
Section 15.2.2, “Replication Relay and Status Logs”
Section 15.4.1.11, “Replication and FLUSH
Section 15.4.1.21, “Replication of the mysql System Database”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 13.6.14, “Restrictions on InnoDB Tables”
Section E.6, “Restrictions on Character Sets”
Section E.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 8.2, “Schema Object Names”
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 15.2.2.2, “Slave Status Logs”
Section 5.4.3, “Specifying Account Names”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
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 21.2, “The MySQL Plugin API”
Section 5.5.1, “User Names and Passwords”
Section 13.6.2.3, “Using Raw Devices for the Shared Tablespace”
Section 5.5.6.2, “Using SSL Connections”
Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 18.2, “Using Stored Routines (Procedures and Functions)”
Section 1.5, “What Is New in MySQL 5.1”

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.6.3, “InnoDB Startup Options and System Variables”
Section 20.9.2, “C API Function Overview”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Description
Description
Section 13.11.1, “FEDERATED Storage Engine Overview”
Section 2.10, “Installing MySQL on i5/OS”
Section 16.3.4.1, “MySQL Cluster Server Option and Variable Reference”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 5.1.1, “Server Option and Variable Reference”
Section 15.2.2.2, “Slave Status Logs”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 5.2.2, “The Error Log”
Section 21.5.1.3, “Using pdb to create a Windows crashdump”

mysqld-path

Section 4.6.10.1, “MySQL Instance Manager Command Options”

mysqld-path=path-to-mysqld-binary

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

mysqld_safe

Description
Description
Section 5.2.2, “The Error Log”

mysqldump

Section 13.6.4, “Creating and Using InnoDB Tables”
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.4.2.5, “OPTIMIZE TABLE Syntax”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
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.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.3.4.3, “MySQL Cluster System Variables”

ndb_table_temporary

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

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.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.5.9.8, “The ndbinfo nodes Table”

nonguarded

Description

nopager

Section 4.5.1.2, “mysql Commands”

notee

Section 4.5.1.2, “mysql Commands”

offset

Section 20.9.3.9, “mysql_data_seek()
Section 20.9.3.23, “mysql_field_seek()
Section 20.9.3.58, “mysql_row_seek()
Section 20.9.7.7, “mysql_stmt_data_seek()
Section 20.9.7.12, “mysql_stmt_fetch_column()
Section 20.9.7.23, “mysql_stmt_row_seek()

open-files-limit

Section C.5.2.7, “Too many connections

open_files_limit

Description
Section E.7.5, “Windows Platform Limitations”

opt

Section 21.2.4.2.2, “Plugin Status and System Variables”

optimize

Section 12.4.2.5, “OPTIMIZE TABLE Syntax”

p

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

pager

Section 4.5.1.2, “mysql Commands”

partition

Chapter 17, Partitioning

password

Description

performance_schema

Section 12.4.5.16, “SHOW ENGINE Syntax”
Description
Section 7.6.3.1, “How the Query Cache Operates”
Section 12.3.5.3, “Table-Locking Restrictions and Conditions”
Section 18.3, “Using Triggers”

pid-file

Section 5.2.4, “The Binary Log”

ping

Description
Section 15.4.5, “Troubleshooting Replication”

pipe

Section 20.9.3.49, “mysql_options()
Section 20.2.6, “Connector/NET Connection String Options Reference”

plugin

Section 21.2.2, “Plugin API Components”
Section 5.4.2, “Privilege System Grant Tables”
Section 21.2, “The MySQL Plugin API”

plugin-load

Section 13.6.2.1, “Using InnoDB Plugin Instead of the Built-In InnoDB

port

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

print

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

processlist

Description

prompt

Section 4.5.1.2, “mysql Commands”

purge-backup-logs

Description

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.6.2.3, “Using Raw Devices for the Shared Tablespace”

read_buffer_size

Section 4.6.3.1, “myisamchk General Options”
Section 7.3.2.4, “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 20.9.3.52, “mysql_real_connect()
Section 20.9.2, “C API Function Overview”

record_buffer

Section 1.5, “What Is New in MySQL 5.1”

refresh

Description
Section 5.4.1, “Privileges Provided by MySQL”

rehash

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

reload

Description
Section 5.4.1, “Privileges Provided by MySQL”

repair

Section 12.4.2.6, “REPAIR TABLE Syntax”

replication-ignore-table

Section 15.4.1.32, “Replication and Views”

resolve_stack_dump

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

rows

Section 7.2.2, “EXPLAIN Output Format”
Section 17.3.4, “Obtaining Information About Partitions”

s

Section 11.5.2, “Regular Expressions”
Section 9.1.13.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.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 1.2, “Typographical and Syntax Conventions”

slave_sql_verify_checksum

Section 15.1.3.3, “Replication Slave Options and Variables”

slave_type_conversions

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

socket

Section 20.2.6, “Connector/NET Connection String Options Reference”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”

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

sort_key_blocks

Section 4.6.3.1, “myisamchk General Options”

source

Appendix C, Errors, Error Codes, and Common Problems
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”
Section 1.5, “What Is New in MySQL 5.1”

sql_log_update

Section 1.5, “What Is New in MySQL 5.1”

sql_low_priority_updates

Section 5.1.3, “Server System Variables”
Section 1.5, “What Is New in MySQL 5.1”

sql_max_join_size

Section 5.1.3, “Server System Variables”
Section 1.5, “What Is New in MySQL 5.1”

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.4.2.1, “ANALYZE TABLE Syntax”
Section 12.4.2.2, “BACKUP TABLE Syntax”
Section 12.4.2.3, “CHECK TABLE Syntax”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 12.4.2.6, “REPAIR TABLE Syntax”
Section 12.4.2.7, “RESTORE TABLE Syntax”
Description
Section 16.5.7, “MySQL Cluster Single User Mode”
Section 4.6.10.5, “MySQL Server Instance Status Monitoring”
Section 16.5.9.8, “The ndbinfo nodes Table”
Section 16.5.9.11, “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”

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

tab

Section 11.5.2, “Regular Expressions”

table

Section 7.2.2, “EXPLAIN Output Format”
Section 20.9.1, “C API Data Structures”
Section 12.2.9.8, “Subqueries in the FROM Clause”

table_type

Section 1.5, “What Is New in MySQL 5.1”

tee

Section 4.5.1.2, “mysql Commands”

test

Section 13.6.13.2.3, “InnoDB Table Monitor Output”
Section 12.4.5.19, “SHOW EVENTS Syntax”
Section 9.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 11.4, “Control Flow Functions”
Section 13.6.4, “Creating and Using InnoDB Tables”
Section 3.3, “Creating and Using a Database”
Description
Description
Section 6.4.5.4, “Dumping Table Definitions and Content Separately”
Section 3.6, “Examples of Common Queries”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 4.2.1, “Invoking MySQL Programs”
Section 7.3.3, “INFORMATION_SCHEMA Optimization”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 18.2.1, “Stored Routine Syntax”
Section 19.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 4.2.3.1, “Using Options on the Command Line”

timeout

Section 20.9.3.49, “mysql_options()

type

Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 7.2.2, “EXPLAIN Output Format”
Section 13.6.13.2.3, “InnoDB Table Monitor Output”
Section 20.9.1, “C API Data Structures”
Section 7.3.1.16, “How to Avoid Table Scans”
Section 7.3.1.4, “Index Merge Optimization”
Section 21.2.4.2.1, “Library and Plugin Descriptors”
Section 21.2.4.2.2, “Plugin Status and System Variables”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 21.2.4.4, “Writing Full-Text Parser Plugins”

update

Section 7.10.3, “Delayed-Insert Thread States”
Description
Section 21.2.4.2.2, “Plugin Status and System Variables”

use db_name

Section 4.5.1.2, “mysql Commands”

use-manager

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

user

Section 12.4.1.2, “DROP USER Syntax”
Section C.5.2.15, “Ignoring user
Section 20.9.3.49, “mysql_options()
Section 20.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.8, “Auditing MySQL Account Activity”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 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 E.6, “Restrictions on Character Sets”
Section 5.1.2, “Server Command Options”
Section 5.5.4, “Setting Account Resource Limits”
Section 5.4.3, “Specifying Account Names”
Section 5.5.1, “User Names and Passwords”
Section 5.5.6.2, “Using SSL Connections”
Section 11.11, “XML Functions”

v

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

variables

Description

version

Description
Section 9.4.4.2, “LDML Syntax Supported in MySQL”
Section 21.2.4.2.1, “Library and Plugin Descriptors”

wait_timeout

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

warnings

Section 4.5.1.2, “mysql Commands”

with-unix-socket-path

Section 2.11.4, “MySQL Source-Configuration Options”

write

Description

write_buffer_size

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