Option Index

role="configure"--with-extra-charsets=charset_name

Section B.1.2.17, “Can't initialize character set

-

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

-#

Description
Section 21.4.3, “The DBUG Package”

-# [debug_options]

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

-# [debug_options]

Section 5.1.2, “Server Command Options”

-# debug_options

Description

-#...

Section 21.4.3, “The DBUG Package”

-#D,20

Section 21.4.3, “The DBUG Package”

-#debug_options

Description

--

Section 1.7.5.6, “'--' as the Start of a Comment”
Section 8.5, “Comment Syntax”
Description
Section 4.2.1, “Invoking MySQL Programs”

--HELP

Section 4.6.3.1, “myisamchk General Options”

--abort-slave-event-count

Section 16.1.2.3, “Replication Slave Options and Variables”

--add-drop-database

Description

--add-drop-table

Description

--add-locks

Description

--add-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--addtodest

Description

--all

Description

--all-databases

Description
Description
Section 2.18.4, “Rebuilding or Repairing Tables or Indexes”

--all-in-1

Description

--all-tablespaces

Description
Section 1.4.1, “What Is New in MySQL 5.0”

--allow-keywords

Description

--allow-suspicious-udfs

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 21.2.2.6, “User-Defined Function Security Precautions”

--allowold

Description

--analyze

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

--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.7.3, “Running MySQL in ANSI Mode”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--append

Description

--apply-slave-statements

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
Section 2.14, “Installing MySQL on NetWare”

--back_log=50

Section 2.19.3, “Solaris Notes”

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Description

--backup-id

Description

--backup_history_log

Section 5.1.2, “Server Command Options”

--backup_id

Description

--backup_path

Description

--backup_path=/path/to/backup/files

Description

--backup_progress_log

Section 5.1.2, “Server Command Options”

--base64-output

Description

--base64-output[=value]

Description

--basedir

Section 2.16.6.2, “Building MySQL from a Windows Source Distribution”
Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
Section 17.10.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.3, “Server System Variables”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.16.6.4, “Testing a Windows Source Build”
Section 2.16.2, “Typical configure Options”
Section 2.17.2, “Unix Post-Installation Procedures”

--basedir=path

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

--batch

Section 4.5.1.1, “mysql Options”

--bdb-home=path

Section 13.5.3, “BDB Startup Options”

--bdb-lock-detect=method

Section 13.5.3, “BDB Startup Options”

--bdb-logdir

Section 13.5.4, “Characteristics of BDB Tables”
Section 5.1.3, “Server System Variables”

--bdb-logdir=file_name

Section 13.5.3, “BDB Startup Options”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--bdb-no-recover

Section 13.5.3, “BDB Startup Options”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”

--bdb-no-sync

Section 13.5.3, “BDB Startup Options”

--bdb-shared-data

Section 13.5.3, “BDB Startup Options”
Section 5.1.3, “Server System Variables”

--bdb-tmpdir=path

Section 13.5.3, “BDB Startup Options”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

--big-tables

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

--bind-address

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

--bind-address=127.0.0.1

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

--bind-address=IP

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

--binlog-do-db

Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1, “Replication Features and Issues”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.2.3, “The Binary Log”

--binlog-do-db=db1

Section 16.1.2.4, “Binary Log Options and Variables”

--binlog-do-db=db_name

Section 16.1.2.4, “Binary Log Options and Variables”

--binlog-do-db=sales

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

--binlog-format

Section 16.1.2.4, “Binary Log Options and Variables”

--binlog-format=mixed

Section A.4, “MySQL 5.0 FAQ — Stored Procedures and Functions”

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

Section 5.1.2, “Server Command Options”

--binlog-ignore-db

Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.2.3, “The Binary Log”

--binlog-ignore-db=db_name

Section 16.1.2.4, “Binary Log Options and Variables”

--binlog-ignore-db=sales

Section 16.1.2.4, “Binary Log Options and Variables”

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

Section 16.1.2.4, “Binary Log Options and Variables”

--block-search=offset

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
Section 5.1.2, “Server Command Options”
Section 2.16.2, “Typical configure Options”

--brief

Description

--build=x86_64-pc-solaris2.10

Section 2.16, “MySQL Installation Using a Source Distribution”

--cflags

Description

--character-set-client-handshake

Section A.11, “MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.2, “Server Command Options”
Section 9.1.12.7.1, “The cp932 Character Set”

--character-set-filesystem=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.2, “Server Command Options”
Section 9.2, “The Character Set Used for Data and Sorting”
Section 8.4, “User-Defined Variables”

--character-set-server=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server=latin1

Section 9.1.3.1, “Server Character Set and Collation”
Section 9.2.1, “Using the German Character Set”

--character-set-server=utf8

Section A.11, “MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

--character-sets-dir

Section B.1.2.17, “Can't initialize character set
Description
Section 17.10.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
Section 9.6, “Problems With Character Sets”
Section 9.2, “The Character Set Used for Data and Sorting”

--character-sets-dir=name

Section 17.6.21, “Options Common to MySQL Cluster Programs”

--character-sets-dir=path

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

--charset=path, -C 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

--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.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.2, “Server Command Options”
Section 9.2, “The Character Set Used for Data and Sorting”

--collation-server=collation_name

Section 5.1.2, “Server Command Options”

--collation-server=latin1_german1_ci

Section 9.2.1, “Using the German Character Set”

--collation-server=latin1_swedish_ci

Section 9.1.3.1, “Server Character Set and Collation”

--column-names

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

--column-type-info

Section 4.5.1.1, “mysql Options”

--columns=column_list

Description

--comments

Section 4.5.1.1, “mysql Options”
Description

--commit

Description

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

--config-file

Description
Description
Description
Section 17.2.4, “Initial Startup of MySQL Cluster”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”

--config-file=file_name

Description
Description

--config-file=filename

Description

--config-file=path-to-file

Description

--config-file=path_name

Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”

--configdir

Section 17.3.4, “MySQL Cluster Configuration Files”

--configdir=directory

Description

--configinfo

Description

--connect

Description

--connect-string

MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”

--connect-string=connect_string

Section 17.6.21, “Options Common to MySQL Cluster Programs”

--connectstring

Description

--console

Section 13.2.13.3, “InnoDB General Troubleshooting”
Section 13.2.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.2.2.3, “Creating the InnoDB Tablespace”
Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
Section 5.1.2, “Server Command Options”
Section 2.9.9, “Starting the Server for the First Time”
Section 5.2.1, “The Error Log”

--copy

Description

--core-file

Section 21.4.1.4, “Debugging mysqld under gdb
Description
Section 2.19.1.4, “Linux Post-Installation Notes”
Section 17.6.21, “Options Common to MySQL Cluster Programs”
Section 5.1.2, “Server Command Options”

--core-file-size

Section 5.1.2, “Server Command Options”

--core-file-size=1000000

Section 2.19.1.4, “Linux Post-Installation Notes”

--core-file-size=size

Description

--correct-checksum

Section 4.6.3.3, “myisamchk Repair Options”

--count

Description
Description
Description

--count=N

Description

--create-options

Description

--daemon

Description
Description

--data-file-length=len, -D len

Section 4.6.3.3, “myisamchk Repair Options”

--database

Description
Description

--database=db_name

Section 4.5.1.1, “mysql Options”
Description

--databases

Description
Description

--datadir

Section 13.5.3, “BDB Startup Options”
Section 2.16.6.2, “Building MySQL from a Windows Source Distribution”
Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
Section 2.9.7, “Creating an Option File”
Description
Section 5.1.3, “Server System Variables”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.16.6.4, “Testing a Windows Source Build”
Section 2.16.2, “Typical configure Options”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 4.2.3.3, “Using Option Files”

--datadir=path

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

--db=db_name

Description

--debug

Section 21.4.1.1, “Compiling MySQL for Debugging”
Description
Description
Description
Description
Description
Section 17.6.21, “Options Common to MySQL Cluster Programs”
Section 5.1.3, “Server System Variables”
Section 2.9.10, “Starting MySQL from the Windows Command Line”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
Section 21.4.3, “The DBUG Package”

--debug-check

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

--debug-info

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

--debug-sync-timeout=N

Section 5.1.3, “Server System Variables”
Section 2.16.2, “Typical configure Options”

--debug-sync-timeout[=N]

Section 5.1.2, “Server Command Options”

--debug="..."

Section 21.4.3, “The DBUG Package”

--debug="d,parser_debug"

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

--debug=+P

Section 5.1.2, “Server Command Options”

--debug=N

Description

--debug=T

Section 5.1.2, “Server Command Options”

--debug=d,general,query

Section 5.4.7, “Causes of Access-Denied Errors”

--debug=debug_options, -# 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
Section 5.1.2, “Server Command Options”

--debug[=options]

Section 17.6.21, “Options Common to MySQL Cluster Programs”

--default-character-set

Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 9.1.4, “Connection Character Sets and Collations”
Description
Section 5.1.3, “Server System Variables”
Section 9.2, “The Character Set Used for Data and Sorting”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 8.4, “User-Defined Variables”

--default-character-set=charset_name

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

--default-character-set=latin1_de

Section 9.2.1, “Using the German Character Set”

--default-character-set=utf8

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

--default-collation=collation_name

Section 5.1.2, “Server Command Options”

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

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-mysqld-path=path

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-storage-engine

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

--default-storage-engine=type

Section 5.1.2, “Server Command Options”

--default-table-type

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

--default-table-type=InnoDB

Section 12.5.5.13, “SHOW ENGINES Syntax”

--default-table-type=type

Section 5.1.2, “Server Command Options”

--default-time-zone

Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.22, “Replication and Time Zones”
Section 5.1.3, “Server System Variables”

--default-time-zone=timezone

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

--default.key_buffer_size=256K

Section 5.1.5.1, “Structured System Variables”

--defaults-extra-file

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

--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.2.2, “InnoDB Configuration”
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.9.11, “Starting MySQL as a Windows Service”
Section 2.9.4.1, “Starting the MySQL Server Instance Configuration Wizard”
The Location of the my.ini File

--defaults-file=file_name

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

--defaults-file=option_file_name

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--defaults-group-suffix

Section 2.20, “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 5.1.2, “Server Command Options”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

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

Section 5.1.2, “Server Command Options”

--delay-key-write=ALL

Section 13.1.1, “MyISAM Startup Options”
Section 7.3.4, “External Locking”
Section 16.3.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”

--delay-key-write=OFF

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

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

Section 5.1.2, “Server Command Options”

--delay_key_write=1

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

--delay_key_write=ON

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

--delayed-insert

Description

--delete

Description

--delete-master-logs

Description

--delimiter=character

Description

--delimiter=str

Section 4.5.1.1, “mysql Options”

--demangle

Section 21.4.1.5, “Using a Stack Trace”

--des-key-file

Section 12.5.6.2, “FLUSH Syntax”
Section 11.10.2, “Encryption and Compression Functions”

--des-key-file=file_name

Section 5.1.2, “Server Command Options”

--descending

Description

--description

Section 4.6.3.4, “Other myisamchk Options”

--dirname

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.16.2, “Typical configure Options”

--disable-debug-sync

Section 2.16.2, “Typical configure Options”

--disable-dtrace

Section 2.16.2, “Typical configure Options”

--disable-grant-options

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.16.2, “Typical configure Options”

--disable-keys

Description

--disable-log-bin

Description

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-profiling

Section 2.16.2, “Typical configure Options”

--disable-shared

Section 2.19.4.6, “BSD/OS Version 4.x Notes”
Section 2.16.2, “Typical configure Options”

--disconnect-slave-event-count

Section 16.1.2.3, “Replication Slave Options and Variables”

--disk

Description

--dont_ignore_systab_0

Description

--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.19.3, “Solaris Notes”

--enable-community-features

Section 2.16.2, “Typical configure Options”

--enable-debug-sync

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.16.2, “Typical configure Options”

--enable-dtrace

Section 2.16.2, “Typical configure Options”

--enable-local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--enable-locking

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

--enable-named-pipe

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

--enable-profiling

Section 2.16.2, “Typical configure Options”

--enable-pstack

Section 5.1.2, “Server Command Options”

--enable-thread-safe-client

Section 2.16.2, “Typical configure Options”

--engine-condition-pushdown

Section 7.2.7, “Condition Pushdown Optimization”

--err-log=file_name

Description
Section 5.2.1, “The Error Log”

--event-scheduler[=value]

Section 5.1.2, “Server Command Options”

--events

Description

--example

Description

--exclude-databases

Description

--exclude-databases=db_list

Description

--exclude-tables

Description

--exclude-tables=tbl_list

Description

--excludedbs

Description

--excludetables

Description

--exe-suffix=suffix

Description

--execute

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

--execute=command

Section 17.6.21, “Options Common to MySQL Cluster Programs”

--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.1.1, “MyISAM Startup Options”
Section 7.3.4, “External Locking”
Section 2.16.5, “MIT-pthreads Notes”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 7.5.2, “System Factors and Startup Parameter Tuning”

--extra-file=file_name

Description

--extra-partition-info

Description

--fast

Section 4.6.3.2, “myisamchk Check Options”
Description

--federated

Section 13.7, “The FEDERATED Storage Engine”

--fields

Description

--fields-enclosed-by

Description

--fields-enclosed-by=...

Description
Description

--fields-escaped-by=...

Description
Description

--fields-optionally-enclosed-by

Description

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

Description
Description

--fields-terminated-by

Description

--fields-terminated-by=...

Description
Description

--fields-xxx

Description

--fields=delimiter

Description

--first-slave

Description

--fix-db-names

Description

--fix-table-names

Description

--flush

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

--flush-logs

Description

--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
Section 2.19.1.2, “Linux Binary Distribution Notes”
Section 21.1.2, “MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

Description

--format

Description

--fs

Description

--gci

Description

--gdb

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

--general-log

Section 5.1.2, “Server Command Options”

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

Section 5.1.2, “Server Command Options”

--general_log

Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 5.2.2, “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.1.2, “Server Command Options”
Section 5.2.2, “The General Query Log”

--header=FALSE

Description

--header_file=file_name, -H 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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 17.6.21, “Options Common to MySQL Cluster Programs”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.2, “Server Command Options”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
Section 7.5.3, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 2.17.2, “Unix Post-Installation Procedures”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--hex

Description

--hex-blob

Description

--hexdump

Description

--host

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.16.5, “MIT-pthreads Notes”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--host=--user

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

--host=127.0.0.1

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

--host=host_name

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

--host=hostname

Description

--host=localhost

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

--hostname

Description

--howto

Description

--html

Section 4.5.1.1, “mysql Options”

--i-am-a-dummy

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

--id

Description

--id=node_id

Description

--ignore

Description

--ignore-builtin-innodb

Section 13.2.3, “InnoDB Startup Options and System Variables”

--ignore-lines=N

Description

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table=db_name.tbl_name

Description

--in_file=file_name, -F file_name

Description

--include

Description

--include-databases

Description

--include-databases=db_list

Description

--include-master-host-port

Description

--include-tables

Description

--include-tables=tbl_list

Description

--info

Description
Description

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-file

Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
Section 5.1.3, “Server System Variables”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 2.16.2, “Typical configure Options”

--init-file=file_name

Section 5.1.2, “Server Command Options”

--init_connect="SET NAMES 'utf8'"

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

--initial

Section 17.3.4.5, “Defining MySQL Cluster Data Nodes”
Description
Description
Description
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”
Section 17.5.2, “MySQL Cluster 5.0 Upgrade and Downgrade Compatibility”
Section 17.3.4, “MySQL Cluster Configuration Files”
Section 17.3.5.1, “MySQL Cluster Data Node Configuration Parameters”
Section 17.3.5, “Overview of MySQL Cluster Configuration Parameters”
Section 17.7.1, “Summary of MySQL Cluster Start Phases”

--initial-start

Description

--innodb

Section 13.2.3, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.2, “Server Command Options”

--innodb[=value]

Section 13.2.3, “InnoDB Startup Options and System Variables”

--innodb_checksums

Section 13.2.3, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 13.2.2.1, “Using Per-Table Tablespaces”
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

--innodb_locks_unsafe_for_binlog

Section 16.1.2.4, “Binary Log Options and Variables”

--innodb_rollback_on_timeout

Section 13.2.12, “InnoDB Error Handling”
Section 13.2.3, “InnoDB Startup Options and System Variables”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--innodb_safe_binlog

Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.19, “Replication during a Slave Shutdown”
Section 5.1.2, “Server Command Options”
Section 5.2.3, “The Binary Log”

--innodb_status_file

Section 13.2.3, “InnoDB Startup Options and System Variables”

--innodb_status_file=1

Section 13.2.3, “InnoDB Startup Options and System Variables”

--innodb_support_xa

Section 5.2.3, “The Binary Log”

--insert-ignore

Description

--install

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

--install-manual

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

--join=big_tbl_name

Description

--keep_files_on_create

Section 12.1.10, “CREATE TABLE Syntax”

--keepold

Description

--key_buffer_size=32M

Section 5.1.2, “Server Command Options”

--keys

Description

--keys-used=val

Section 4.6.3.3, “myisamchk Repair Options”

--language

Section 9.3, “Setting the Error Message Language”

--language=lang_name, -L lang_name

Section 5.1.2, “Server Command Options”

--large-pages

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

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

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

Description

--lines-terminated-by=...

Description
Description

--list-users

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--loadqueries

Description

--local

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

--local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

--local-infile=0

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

--local-infile=1

Section 4.5.1.1, “mysql Options”

--local-infile[=1]

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

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

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

--local-load

Description

--local-load=path

Description

--local-service

Section 2.9.11, “Starting MySQL as a Windows Service”

--lock-all-tables

Description

--lock-tables

Description
Description

--lock=lock_type

Description

--log

Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.4.1.7, “Making a Test Case If You Experience Table Corruption”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.1.2, “Server Command Options”
Section 5.2.5, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.2.2, “The General Query Log”
Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld

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

Section 5.1.2, “Server Command Options”

--log-bin

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
Section 6.2.1, “Backup Policy”
Section 6.2.3, “Backup Strategy Summary”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.5, “Binary Logging of Stored Programs”
Section 6.1, “Database Backups”
Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 21.4.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.3, “Point-in-Time Recovery”
Section 16.3.4, “Replication FAQ”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.2, “Server Command Options”
Section 5.2.5, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.2.3, “The Binary Log”
Section 5.2.2, “The General Query Log”
Section 16.3.5, “Troubleshooting Replication”
Section 6.2.2, “Using Backups for Recovery”

--log-bin-index[=file_name]

Section 16.1.2.4, “Binary Log Options and Variables”
Section 5.2.3, “The Binary Log”

--log-bin-trust-function-creators

Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.5, “Binary Logging of Stored Programs”

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

Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.5, “Binary Logging of Stored Programs”

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

Section 16.1.2.4, “Binary Log Options and Variables”

--log-bin-trust-routine-creators

Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.5, “Binary Logging of Stored Programs”

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

Section 18.5, “Binary Logging of Stored Programs”

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

Section 16.1.2.4, “Binary Log Options and Variables”

--log-bin=base_name.extension

Section 5.2.3, “The Binary Log”

--log-bin=log_name

Section 6.2.3, “Backup Strategy Summary”

--log-bin=old_host_name-bin

Section B.1.8.1, “Open Issues in MySQL”

--log-bin[=base_name]

Section 16.1.2.4, “Binary Log Options and Variables”
Section 5.2.3, “The Binary Log”

--log-bin[=file_name]

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

--log-error

Section 12.5.6.2, “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.5, “Server Log Maintenance”
Section 5.2.1, “The Error Log”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--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.1, “The Error Log”

--log-error[=file_name]

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

--log-isam=file_name

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

--log-isam[=file_name]

Section 5.1.2, “Server Command Options”

--log-long-format

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

--log-output

Section 1.4.1, “What Is New in MySQL 5.0”
Section 5.1.2, “Server Command Options”
Section 5.2.2, “The General Query Log”
Section 5.2.4, “The Slow Query Log”

--log-output=TABLE

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

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

Section 5.1.2, “Server Command Options”

--log-queries-not-using-indexes

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

--log-short-format

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

--log-slave-updates

Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 16.3.4, “Replication FAQ”
Section 16.3.1, “Replication Features and Issues”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.2.3, “The Binary Log”

--log-slow-admin-statements

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

--log-slow-queries

Section 5.1.2, “Server Command Options”
Section 5.2.5, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Slow Query Log”
Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld

--log-slow-queries[=file_name]

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

--log-slow-slave-statements

Section 16.1.2.3, “Replication Slave Options and Variables”

--log-tc-size

Section 5.1.6, “Server Status Variables”

--log-tc-size=size

Section 5.1.2, “Server Command Options”

--log-tc=file_name

Section 5.1.2, “Server Command Options”

--log-update

Section 5.2.5, “Server Log Maintenance”

--log-update[=file_name]

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

--log-warnings

Section B.1.2.11, “Communication Errors and Aborted Connections”
Section 16.1.1, “How to Set Up Replication”
Section 5.1.2, “Server Command Options”
Section 5.2.1, “The Error Log”

--log-warnings=0

Section 5.1.2, “Server Command Options”

--log-warnings=2

Section B.1.2.9, “MySQL server has gone away

--log-warnings[=level]

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

--log=file_name

Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--log[=file_name]

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

--loops

Description

--loose

Section 4.2.3.2, “Program Option Modifiers”

--loose-opt_name

Section 4.2.3.3, “Using Option Files”

--low-priority

Description

--low-priority-updates

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

--lower-case-table-names=0

Section 8.2.2, “Identifier Case Sensitivity”

--master-bind

Section 12.6.2.1, “CHANGE MASTER TO Syntax”

--master-connect-retry

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.3.1.13, “Replication During a Master Shutdown”
Section 16.3.1, “Replication Features and Issues”
Section 16.4, “Replication Implementation Overview”
Section 7.5.6.5, “Replication Slave I/O Thread States”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-connect-retry=seconds

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-data

Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump
Description

--master-data[=value]

Description

--master-host

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-host=host_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-info-file

Section 16.4.2, “Replication Relay and Status Files”

--master-info-file=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-password

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-password

Section 1.4.1, “What Is New in MySQL 5.0”

--master-password=password

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-port

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-port=port_number

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-retry-count

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-retry-count=count

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl*

Section 5.5.7.3, “SSL Command Options”

--master-ssl-ca

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-ca=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-capath=directory_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-cert=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-cipher=cipher_list

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-key=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-user

Section 1.4.1, “What Is New in MySQL 5.0”
Section 16.1.2.3, “Replication Slave Options and Variables”

--master-user=user_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-xxx

Section 1.4.1, “What Is New in MySQL 5.0”

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-binlog-dump-events

Section 16.1.2.4, “Binary Log Options and Variables”

--max-binlog-size

Section 16.1.2.3, “Replication Slave Options and Variables”

--max-record-length

Section 12.5.2.6, “REPAIR TABLE Syntax”

--max-record-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--max-relay-log-size

Section 16.1.2.3, “Replication Slave Options and Variables”

--max-relay-log-size=size

Section 16.1.2.3, “Replication Slave Options and Variables”

--max-seeks-for-key=1000

Section 7.2.18, “How to Avoid Table Scans”
Section B.1.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.4, “Using Options to Set Program Variables”

--max_connect_errors=999999999

Section 12.5.6.2, “FLUSH Syntax”

--max_join_size

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

--max_sort_length=N

Section 10.4.3, “The BLOB and TEXT Types”

--maximum

Section 4.2.3.2, “Program Option Modifiers”

--maximum-query_cache_size=32M

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

--maximum-query_cache_size=4M

Section 4.2.3.2, “Program Option Modifiers”

--maximum-var_name=value

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

--medium-check

Section 4.6.3.2, “myisamchk Check Options”
Description

--memlock

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

--method=command

Description

--min-examined-row-limit=number

Section 5.1.2, “Server Command Options”

--monitoring-interval=seconds

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--myisam-block-size

Section 7.4.5.5, “Key Cache Block Size”

--myisam-block-size=N

Section 5.1.2, “Server Command Options”

--myisam-recover

Section 13.1.1, “MyISAM Startup Options”
Section 7.2.22, “Other Optimization Tips”
Section 5.1.3, “Server System Variables”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section B.1.2.19, “Table-Corruption Issues”
Section 13.1, “The MyISAM Storage Engine”
Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld

--myisam-recover=BACKUP,FORCE

Section 5.1.3, “Server System Variables”

--myisam-recover=mode

Section 13.1.1, “MyISAM Startup Options”

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

Section 5.1.2, “Server Command Options”

--mysqladmin=prog_name

Description

--mysqld

Description
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--mysqld-safe-compatible

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

--mysqld-version

Description
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--mysqld-version=debug

Description

--mysqld-version=max

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=prog_name

Description
Description

--name_file=file_name, -N file_name

Description

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Description

--ndb-batch-size=#

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster

The mysqld-max Extended MySQL Server

--ndb-cluster-connection-pool

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=#

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=4

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-connectstring

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Description
Description
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”

--ndb-connectstring=connect_string

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

--ndb-log-empty-epochs

Section 16.1.2.3, “Replication Slave Options and Variables”

--ndb-mgmd-host

Description

--ndb-nodegroup-map

Description

--ndb-nodeid

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

--ndb-nodeid=#

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.21, “Options Common to MySQL Cluster Programs”

--ndb-optimized-node-selection

Description
Section 17.6.21, “Options Common to MySQL Cluster Programs”

--ndb-shm

Description

--ndb_optimized_node_selection

Section 17.4.3, “MySQL Cluster System Variables”

--ndbcluster

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 12.5.5.13, “SHOW ENGINES Syntax”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”
Section 17.3, “MySQL Cluster Configuration”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
The mysqld-max Extended MySQL Server

--ndbcluster --ndb-connectstring=management_host

Section 17.8.2, “MySQL Cluster and MySQL Privileges”

--new

Section 8.1.3, “Hexadecimal Values”
Section 10.1.2, “Overview of Date and Time Types”
Section 5.1.2, “Server Command Options”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
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-binlog

Description

--no-contact

Description

--no-create-db

Description

--no-create-info

Description

--no-data

Description

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

--no-pager

Section 4.5.1.1, “mysql Options”

--no-restore-disk-objects

Description

--no-set-names

Description

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tee

Section 4.5.1.1, “mysql Options”

--no-upgrade

Description

--nodaemon

Description
Description

--nodata

Description

--nodeid

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

--nodeid=node_id

Description

--nodes

Description

--noindices

Description

--nostart

Description

--not-started

Description

--nowait-nodes

Description

--nowait-nodes=3

Description

--nowait-nodes=3,5

Description

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

Description

--numeric-dump-file=file_name

Description

--offset=N

Description

--old

Section 12.5.2.4, “CHECKSUM TABLE Syntax”

--old-alter-table

Section 5.1.2, “Server Command Options”

--old-passwords

Section B.1.2.4, “Client does not support authentication protocol
Section 5.5.6.3, “Password Hashing in MySQL”
Section 16.3.1, “Replication Features and Issues”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--old-protocol

Section B.1.2.15, “Ignoring user
Section 20.9.3.52, “mysql_real_connect()
Section 5.1.2, “Server Command Options”

--old-style-user-limits

Section 5.5.4, “Limiting Account Resources”
Section 5.1.2, “Server Command Options”

--old_server

Description

--one-database

Section 4.5.1.1, “mysql Options”

--one-thread

Section 5.1.2, “Server Command Options”

--only-debug

Description

--open-files-limit

Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 13.2.3, “InnoDB Startup Options and System Variables”
Section 2.19.4.1, “FreeBSD Notes”
Section 7.4.7, “How MySQL Opens and Closes Tables”
Section 2.9.15, “MySQL on Windows Compared to MySQL on Unix”
Section 5.1.3, “Server System Variables”

--open-files-limit=count

Description
Section 5.1.2, “Server Command Options”

--opt

Section 13.2.13.1, “InnoDB Performance Tuning Tips”
Section 2.18.5, “Copying MySQL Databases to Another Machine”
Description
Section 2.18.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--opt_name

Section 4.2.3.3, “Using Option Files”

--opt_name=value

Section 4.2.3.3, “Using Option Files”

--optimize

Description

--order

Description

--order-by-primary

Description

--order=index_name

Description

--out_dir=path, -D path

Description

--out_file=file_name, -O file_name

Description

--packlength=len

Description

--pager

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

--pager[=command]

Section 4.5.1.1, “mysql Options”

--parallel-recover

Section 4.6.3.3, “myisamchk Repair Options”

--parallelism

Description

--parsable

Description

--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
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 6.2, “Example Backup and Recovery Strategy”
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section B.1.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
Section 4.6.10.1, “MySQL Instance Manager Command Options”

--password=your_pass

Section 5.4.7, “Causes of Access-Denied Errors”
Section 5.5.6.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

--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 Servers on the Same Machine”

--pid-file=path

Section 5.1.2, “Server Command Options”

--pipe

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

--plan

Description

--plugin-load

Section 5.1.2, “Server Command Options”

--plugin-load=plugin_list

Section 5.1.2, “Server Command Options”

--plugin_name=0

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--plugin_name=1

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--plugin_name=OFF

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--plugin_name=ON

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--plugindir

Description

--plugins=max

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

--plugins=max-no-innodb

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

--port

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

--port-open-timeout=num

Section 5.1.2, “Server Command Options”

--port=port_num

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

--port=port_number

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

--position

Description

--position=N

Description

--prefix

Section 2.16.3, “Installing from the Development Source Tree”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 5.6.2, “Running Multiple Servers on Unix”

--preserve-trailing-spaces

Description

--preview

Description

--print

Description

--print-defaults

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

--print-full-config

Description

--print-password-line

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

--print_data

Description

--print_log

Description

--print_meta

Description

--promote-attributes

Description

--prompt

Section 4.5.1.2, “mysql Commands”

--prompt=format_str

Section 4.5.1.1, “mysql Options”

--protocol

Section 4.2.2, “Connecting to the MySQL Server”
Description

--protocol=MEMORY

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

--protocol=PIPE

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

--protocol=SOCKET

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

--protocol=TCP

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

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

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

--query

Description

--query-cache-size=0

Section 7.3.4, “External Locking”

--query=id,type,indexmemory,datamemory

Description

--query=query-options

Description

--quick

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

--quiet

Description

--quote-names

Description
Section 2.18.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--raw

Section 4.5.1.1, “mysql Options”

--read-from-remote-server

Description

--read-only

Section 4.6.3.2, “myisamchk Check Options”
Section 16.1.2.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.5, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--regexp=expr

Description

--relative

Description

--relay-log

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 16.4.2, “Replication Relay and Status Files”
Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-index

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 16.4.2, “Replication Relay and Status Files”
Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-index=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-info-file

Section 16.4.2, “Replication Relay and Status Files”

--relay-log-info-file=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-space-limit

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-space-limit=size

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log=myhost-bin

Section 12.6.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

Description
Section 17.3.4, “MySQL Cluster Configuration Files”

--remove

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

--repair

Description

--replace

Description
Description

--replicate-*

Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.4.3.3, “Replication Rule Application”
Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-*-db

Section 16.4.3.3, “Replication Rule Application”
Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-*-do-*

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-ignore-*

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-table

Section 18.5, “Binary Logging of Stored Programs”
Section 16.4.3.3, “Replication Rule Application”

--replicate-do-db

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 12.4.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1, “Replication Features and Issues”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.3.1.17, “Replication and Reserved Words”
Section 16.3.1.20, “Replication and Temporary Tables”
Section 5.2.3, “The Binary Log”

--replicate-do-db=db1

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-do-db=db_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-do-db=sales

Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-do-table

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.4.3.2, “Evaluation of Table-Level Replication Options”
Section 16.3.1, “Replication Features and Issues”
Section 16.4.3.3, “Replication Rule Application”
Section 16.3.1.17, “Replication and Reserved Words”
Section 16.3.1.20, “Replication and Temporary Tables”

--replicate-do-table=db_name.tbl_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-ignore-db

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 12.4.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.1, “Replication Features and Issues”
Section 16.4.3.3, “Replication Rule Application”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.3.1.17, “Replication and Reserved Words”
Section 5.2.3, “The Binary Log”

--replicate-ignore-db=db_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-ignore-db=sales

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-ignore-table

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.4.3.2, “Evaluation of Table-Level Replication Options”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.17, “Replication and Reserved Words”
Section 16.3.1.20, “Replication and Temporary Tables”

--replicate-ignore-table=db_name.tbl_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-rewrite-db

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-same-server-id

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 16.3.1, “Replication Features and Issues”
Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-wild-do-table

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.4.3.2, “Evaluation of Table-Level Replication Options”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.3.1.20, “Replication and Temporary Tables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-wild-ignore-table

Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.4.3.2, “Evaluation of Table-Level Replication Options”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.3.1.20, “Replication and Temporary Tables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

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

Section 16.3.4, “Replication FAQ”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.25, “Replication and User Privileges”

--replicate-wild-ignore-table=norep_

Section 16.3.1.20, “Replication and Temporary Tables”

--report-host

Section 5.1.3, “Server System Variables”

--report-host=host_name

Section 12.5.5.30, “SHOW SLAVE HOSTS Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”

--report-password

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

--report-password=password

Section 16.1.2.3, “Replication Slave Options and Variables”

--report-port

Section 5.1.3, “Server System Variables”

--report-port=slave_port_num

Section 16.1.2.3, “Replication Slave Options and Variables”

--report-user

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

--report-user=user_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--resetmaster

Description

--resetslave

Description

--restore_data

Description

--restore_epoch

Description

--restore_meta

Description

--result-file=file_name

Description

--result-file=name

Description

--rhost=host_name

Description

--rollback

Description

--routines

Description

--rowid

Description

--rows

Description

--rows=separator

Description

--run-as-service

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--safe-mode

Section 12.5.2.5, “OPTIMIZE TABLE Syntax”
Section 21.4.1, “Debugging a MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--safe-recover

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

--safe-show-database

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

--safe-updates

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

--safe-user-create

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

--savequeries

Description

--secure-auth

Section 4.5.1.1, “mysql Options”
Section 5.3.3, “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.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--secure-backup-file-priv=path

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

--secure-file-priv

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

--secure-file-priv=path

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

--select_limit

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

--server-id

Section 16.1.2, “Replication and Binary Logging Options and Variables”
Section 5.1.3, “Server System Variables”
Section 16.3.5, “Troubleshooting Replication”

--server-id=id

Description

--server-id=value

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

Section 9.2, “The Character Set Used for Data and Sorting”
Section 2.16.2, “Typical configure Options”

--set-character-set=name

Section 4.6.3.3, “myisamchk Repair Options”

--set-charset

Description

--set-charset=charset_name

Description

--set-collation

Section 4.6.3.3, “myisamchk Repair Options”

--set-collation=name

Section 4.6.3.3, “myisamchk Repair Options”

--set-variable

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

--set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

--set-variable=var_name=value

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 7.5.3, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”

--shared-memory

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

--shared-memory-base-name

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

--shared-memory-base-name=name

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

--short-form

Description

--show-slave-auth-info

Section 16.1.2.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.4.6, “Setting Up a Table Maintenance Schedule”

--single-transaction

Section 13.2.6, “Backing Up and Recovering an InnoDB Database”
Section 6.2.1, “Backup Policy”
Description

--skip

Description
Section 4.2.3.2, “Program Option Modifiers”

--skip-add-drop-table

Description

--skip-add-locks

Description

--skip-auto-rehash

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

--skip-base64-output

Description

--skip-bdb

Section 13.5.3, “BDB Startup Options”
Section 13.5.1, “Operating Systems Supported by BDB
Section 16.3.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-character-set-client-handshake

Section A.11, “MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 9.1.12.7.1, “The cp932 Character Set”

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Description

--skip-compact

Description

--skip-concurrent-insert

Section 5.1.2, “Server Command Options”

--skip-delay-key-write

Section 5.1.2, “Server Command Options”

--skip-disable-keys

Description

--skip-dump-date

Description

--skip-engine_name

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

--skip-extended-insert

Description

--skip-external-locking

Section 7.3.4, “External Locking”
Section 7.5.6.2, “General Thread States”
Section 2.14, “Installing MySQL on NetWare”
Section 5.1.2, “Server Command Options”
Section 7.5.2, “System Factors and Startup Parameter Tuning”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--skip-grant-tables

Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Description
Section 2.18.2.1, “Downgrading to MySQL 4.1”
Section 2.17.2.1, “Problems Running mysql_install_db
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.16.2, “Typical configure Options”
Section 4.2.3.1, “Using Options on the Command Line”
Section 5.4.6, “When Privilege Changes Take Effect”

--skip-host-cache

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

--skip-innodb

Section 13.2.2, “InnoDB Configuration”
Section 13.2.3, “InnoDB Startup Options and System Variables”
Section 12.5.5.13, “SHOW ENGINES Syntax”
Section 16.3.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
The mysqld-max Extended MySQL Server

--skip-innodb-checksums

Section 13.2.3, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 13.2.3, “InnoDB Startup Options and System Variables”

--skip-innodb_checksums

Section 13.2.3, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 13.2.3, “InnoDB Startup Options and System Variables”

--skip-isam

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

--skip-kill-mysqld

Description

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-locking

Section 7.3.4, “External Locking”

--skip-log-warnings

Section 16.1.2.3, “Replication Slave Options and Variables”

--skip-merge

Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 13.3, “The MERGE Storage Engine”

--skip-name-resolve

Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.19.4.1, “FreeBSD Notes”
Section 7.5.11, “How MySQL Uses DNS”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.9.12, “Testing The MySQL Installation”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-ndbcluster

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.4.3, “MySQL Cluster System Variables”

--skip-networking

Section B.1.2.2, “Can't connect to [local] MySQL server
Section B.1.2.9, “MySQL server has gone away
Section 5.4.7, “Causes of Access-Denied Errors”
Section 7.5.11, “How MySQL Uses DNS”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-new

Section 12.5.2.5, “OPTIMIZE TABLE Syntax”
Section 21.4.1, “Debugging a MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-opt

Description
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-quick

Description

--skip-quote-names

Description
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--skip-reconnect

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

--skip-routines

Section 2.18.2.1, “Downgrading to MySQL 4.1”

--skip-safemalloc

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

--skip-set-charset

Description

--skip-show-database

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

--skip-slave-start

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.2.7, “START SLAVE Syntax”
Section 16.1.1, “How to Set Up Replication”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.3.5, “Troubleshooting Replication”

--skip-ssl

Section 5.5.7.3, “SSL Command Options”

--skip-stack-trace

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

--skip-super-large-pages

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

--skip-symbolic-links

Section 12.1.10, “CREATE TABLE Syntax”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.1.2, “Server Command Options”
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”

--skip-symlink

Section 5.1.2, “Server Command Options”

--skip-sync-bdb-logs

Section 13.5.3, “BDB Startup Options”

--skip-syslog

Description
Section 5.2.1, “The Error Log”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--skip-table-check

Description

--skip-thread-priority

Section 2.19.4.5, “BSD/OS Version 3.x Notes”
Section 2.19.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.2, “Server Command Options”

--skip-triggers

Description
Section 2.18.2.1, “Downgrading to MySQL 4.1”

--skip-tz-utc

Description

--skip-write-binlog

Description

--skip-xxx

Description

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave-load-tmpdir

Section 6.1, “Database Backups”
Section 16.4.2, “Replication Relay and Status Files”

--slave-load-tmpdir=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section 16.1.2.3, “Replication Slave Options and Variables”

--slave-net-timeout=seconds

Section 16.1.2.3, “Replication Slave Options and Variables”

--slave-skip-errors

Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.23, “Replication and Transactions”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

--slave_compressed_protocol={0|1}

Section 16.1.2.3, “Replication Slave Options and Variables”

--sleep

Description

--sleep=delay

Description

--slow-query-log

Section 5.1.2, “Server Command Options”

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

Section 5.1.2, “Server Command Options”

--slow_query_log

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

--slow_query_log_file

Section 5.1.3, “Server System Variables”

--slow_query_log_file=file_name

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

--socket

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

--socket=/path/to/socket

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

--socket=file_name

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

--socket=path

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

--sort-index

Section 4.6.3.4, “Other myisamchk Options”
Section 6.4.4, “Table Optimization”

--sort-records=N

Section 4.6.3.4, “Other myisamchk Options”

--sort-records=index_num

Section 6.4.4, “Table Optimization”

--sort-recover

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

--sort_buffer_size=16M

Section 4.6.3.5, “myisamchk Memory Usage”

--spassword[=password]

Description

--sporadic-binlog-dump-fail

Section 16.1.2.4, “Binary Log Options and Variables”

--sql-mode

Section A.3, “MySQL 5.0 FAQ — Server SQL Mode”
Section 5.1.2, “Server Command Options”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--sql-mode=""

Section 5.1.7, “Server SQL Modes”

--sql-mode="mode_value"

Section 1.7.2, “Selecting SQL Modes”

--sql-mode="modes"

Section 5.1.7, “Server SQL Modes”

--sql-mode=IGNORE_SPACE

Chapter 11, Functions and Operators

--sql-mode=MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”

--sql-mode=NO_UNSIGNED_SUBTRACTION

Section 11.9, “Cast Functions and Operators”

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

Section 5.1.2, “Server Command Options”

--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--ssl

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.5.7.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
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--ssl-ca

Section 12.5.1.3, “GRANT Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl-ca=file_name

Section 5.5.7.3, “SSL Command Options”

--ssl-capath

Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”

--ssl-capath=directory_name

Section 5.5.7.3, “SSL Command Options”

--ssl-cert

Section 12.5.1.3, “GRANT Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl-cert=file_name

Section 5.5.7.3, “SSL Command Options”

--ssl-cipher

Section 16.1.2.3, “Replication Slave Options and Variables”

--ssl-cipher=cipher_list

Section 5.5.7.3, “SSL Command Options”

--ssl-key

Section 12.5.1.3, “GRANT Syntax”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.5.7.3, “SSL Command Options”
Section 5.5.7.2, “Using SSL Connections”

--ssl-key=file_name

Section 5.5.7.3, “SSL Command Options”

--ssl-verify-server-cert

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 5.5.7.3, “SSL Command Options”

--ssl-xxx

Section 5.5.7.2, “Using SSL Connections”

--ssl=0

Section 5.5.7.3, “SSL Command Options”

--standalone

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

--start-datetime

Description
Section 6.3.1, “Specifying Times for Recovery”

--start-datetime=datetime

Description

--start-position

Description
Section 6.3.2, “Specifying Positions for Recovery”

--start-position=N

Description

--statefile=file_name, -S file_name

Description

--static

Section 2.19.3, “Solaris Notes”

--stats

Description

--status

Description

--stop-datetime

Description
Section 6.3.1, “Specifying Times for Recovery”

--stop-datetime=datetime

Description

--stop-position

Section 6.3.2, “Specifying Positions for Recovery”

--stop-position=N

Description

--suffix

Description

--suffix=str

Description

--super-large-pages

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

--superuser=user_name

Description

--symbolic-links

Section 5.1.2, “Server Command Options”
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

--symbols-file=file_name

Description

--sync-bdb-logs

Section 13.5.3, “BDB Startup Options”

--sysdate-is-now

Section 11.6, “Date and Time Functions”
Section 16.3.1.8, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Session System Variables”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--syslog

Description
Section 5.2.1, “The Error Log”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--syslog-tag=tag

Description
Section 5.2.1, “The Error Log”

--tab

Chapter 6, Backup and Recovery
Description
Description

--tab=path

Description

--table

Section 4.5.1.1, “mysql Options”
Description

--table_cache

Section 7.4.7, “How MySQL Opens and Closes Tables”

--table_open_cache

Section 7.4.7, “How MySQL Opens and Closes Tables”

--tables

Description
Description

--tar

Description

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

Section 5.1.2, “Server Command Options”

--tcp-ip

Description

--tee

Section 4.5.1.2, “mysql Commands”

--tee=file_name

Section 4.5.1.1, “mysql Options”

--temp-pool

Section 5.1.2, “Server Command Options”

--test

Description

--thread-stack=192K

Section 2.19.1.5, “Linux x86 Notes”

--thread_cache_size=5'

Section 21.4.1.4, “Debugging mysqld under gdb

--thread_handling=no-threads

Section 5.1.2, “Server Command Options”

--thread_handling=one-thread-per-connection

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

--thread_handling=pool-of-threads

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

--thread_pool_size=N

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

--thread_stack=N

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

--timeout

Description

--timeout=seconds

Description

--timezone

Section 9.7, “MySQL Server Time Zone Support”
Section 5.1.3, “Server System Variables”
Section B.1.4.6, “Time Zone Problems”

--timezone=timezone

Description

--timezone=timezone_name

Section 9.7, “MySQL Server Time Zone Support”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.22, “Replication and Time Zones”
Section B.1.4.6, “Time Zone Problems”

--tmp

Description

--tmp_table_size=val

Section B.1.2.12, “The table is full

--tmpdir

Section B.1.2.13, “Can't create/write to file
Section 5.1.2, “Server Command Options”
Section B.1.4.4, “Where MySQL Stores Temporary Files”

--tmpdir=path

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

--to-last-log

Description

--transaction-isolation

Section 13.2.8, “The InnoDB Transaction Model and Locking”

--transaction-isolation=SERIALIZABLE

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--transaction-isolation=level

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

--transactional

Description

--triggers

Description

--try-reconnect=number

Description

--tupscan

Description

--type

Description
Description

--type=node_type

Description

--tz-utc

Description

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

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

--unqualified

Description

--update-state

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

--usage

Description
Description
Section 17.6.21, “Options Common to MySQL Cluster Programs”

--use-frm

Description

--use-manager

Description

--use-mysqld_safe

Description

--use-threads=N

Description

--useHexFormat

Description

--user

Section B.1.2.18, “'File' Not Found and Similar Errors”
Description
Description
Section 6.2, “Example Backup and Recovery Strategy”
Section 2.15, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.13, “Installing MySQL on i5/OS”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.19.1.2, “Linux Binary Distribution Notes”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.2, “Server Command Options”
Section 2.19.3, “Solaris Notes”
Section 2.16.1, “Source Installation Overview”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.3, “Using Option Files”

--user=mysql

Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”

--user=root

Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.3.2, “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
Section 5.3.5, “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.2.3, “InnoDB Startup Options and System Variables”
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 7.5.3, “Tuning Server Parameters”

--verbose

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.9.10, “Starting MySQL from the Windows Command Line”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
Section 7.5.3, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--version

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 17.6.21, “Options Common to MySQL Cluster Programs”
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.6, “How to Report Bugs or Problems”

--wait

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

--wait-timeout=N

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--wait[=count]

Description

--warnings

Section B.1.2.11, “Communication Errors and Aborted Connections”
Section 5.1.2, “Server Command Options”

--where='where_condition'

Description

--with

Section 2.16.2, “Typical configure Options”

--with-archive-storage-engine

Section 13.8, “The ARCHIVE Storage Engine”

--with-bdb

The mysqld-max Extended MySQL Server

--with-berkeley-db

Section 13.5.2, “Installing BDB

--with-big-tables

Section 13.3.1, “MERGE Table Problems”
Section 5.1.3, “Server System Variables”
Section 13.1, “The MyISAM Storage Engine”
Section 2.16.2, “Typical configure Options”

--with-blackhole-storage-engine

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

--with-charset

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

--with-charset=MYSET

Section 9.4, “Adding a New Character Set”

--with-charset=charset_name

Section B.1.2.17, “Can't initialize character set
Section 9.2, “The Character Set Used for Data and Sorting”

--with-collation

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

--with-comment

Section 5.1.3, “Server System Variables”

--with-csv-storage-engine

Section 13.9, “The CSV Storage Engine”

--with-debug

Section 21.4.1.1, “Compiling MySQL for Debugging”
Section 2.16.4, “Dealing with Problems Compiling MySQL”
Section 21.4.2, “Debugging a MySQL Client”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 5.1.2, “Server Command Options”
Section 2.16.2, “Typical configure Options”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

--with-debug=full

Section 21.4.1.1, “Compiling MySQL for Debugging”
Section 21.4.2, “Debugging a MySQL Client”
Description
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 5.1.2, “Server Command Options”
Section B.1.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 2.16.2, “Typical configure Options”

--with-example-storage-engine

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

--with-extra-charsets=LIST

Section 2.16.2, “Typical configure Options”

--with-extra-charsets=charset_name

Section B.1.2.17, “Can't initialize character set

--with-extra-charsets=complex

Section B.1.2.17, “Can't initialize character set
Section 9.2, “The Character Set Used for Data and Sorting”

--with-extra-charsets=list-of-charsets | complex | all | none

Section 9.2, “The Character Set Used for Data and Sorting”

--with-federated-storage-engine

Section 13.7, “The FEDERATED Storage Engine”

--with-innodb

The mysqld-max Extended MySQL Server

--with-libevent

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

--with-low-memory

Section 2.19.4.4, “BSD/OS Version 2.x Notes”
Section 2.16.4, “Dealing with Problems Compiling MySQL”

--with-max-indexes=N

Section 13.1, “The MyISAM Storage Engine”

--with-mit-threads

Section 2.19.4.1, “FreeBSD Notes”
Section 2.16.5, “MIT-pthreads Notes”

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

Section 21.2.2, “Adding a New User-Defined Function”
Section 2.19.1.7, “Linux Alpha Notes”

--with-mysqld-ldflags=-rdynamic

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

--with-named-thread-libs="-lpthread -lmach -lexc -lc"

Section 2.19.5.6, “Alpha-DEC-OSF/1 Notes”

--with-named-z-libs=no

Section 2.19.3.1, “Solaris 2.7/2.8 Notes”
Section 2.19.3, “Solaris Notes”

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

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

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

Section 17.3.4.10, “SCI Transport Connections in MySQL Cluster”

--with-ndb-shm

Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”
Section 17.3.4.9, “MySQL Cluster Shared-Memory Connections”

--with-ndbcluster

Section 17.3.1, “Building MySQL Cluster from Source Code”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
The mysqld-max Extended MySQL Server

--with-openssl

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 5.5.7.2, “Using SSL Connections”

--with-plugin-PLUGIN

Section 2.16.2, “Typical configure Options”

--with-plugins

Section 2.16.2, “Typical configure Options”

--with-raid

Section 12.1.10, “CREATE TABLE Syntax”
Section 2.16.4, “Dealing with Problems Compiling MySQL”

--with-server-suffix=-max

The mysqld-max Extended MySQL Server

--with-ssl

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 5.5.7.2, “Using SSL Connections”

--with-ssl=path

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

--with-tcp-port

Section 2.16.3, “Installing from the Development Source Tree”

--with-unix-socket-path

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

--with-vio

Section 5.5.7.2, “Using SSL Connections”

--with-yassl

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

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

Section 2.16.2, “Typical configure Options”

--without

Section 2.16.2, “Typical configure Options”

--without-libevent

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

--without-plugin-PLUGIN

Section 2.16.2, “Typical configure Options”

--without-query-cache

Section 7.5.5, “The MySQL Query Cache”

--without-server

Section 2.16.5, “MIT-pthreads Notes”
Section 2.16.2, “Typical configure Options”

--write-binlog

Description

--xml

Section 4.5.1.1, “mysql Options”
Description
Description

-1

Section 1.7.5.6, “'--' as the Start of a Comment”
Section 11.11.1, “GROUP BY (Aggregate) Functions”
Section 11.2.3, “Comparison Functions and Operators”
Description
Section 11.5.2, “Mathematical Functions”
Section 11.10.4, “Miscellaneous Functions”
Section 11.4.1, “String Comparison Functions”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

-?

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 17.6.21, “Options Common to MySQL Cluster Programs”
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
Description
Section B.1.8.1, “Open Issues in MySQL”

-A[value]

Section 4.6.3.4, “Other myisamchk Options”

-B

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

-C

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

-C charset_name

Section 5.1.2, “Server Command Options”

-D

Description
Description

-D character

Description

-D db_name

Section 4.5.1.1, “mysql Options”

-DBIG_TABLES

Section 2.16.2, “Typical configure Options”

-DHAVE_rts_threads

Section 21.4.4, “Comments about RTS Threads”

-DUSE_ALARM_THREAD

Section 21.1.1, “MySQL Threads”

-DUSE_SYMDIR

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

-E

Section 4.5.1.1, “mysql Options”
Description
Description

-F

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

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

Description

-I

Section 20.9.16, “Building Client Programs”
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 2.21.3, “Problems Using the Perl DBI/DBD Interface”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 9.3, “Setting the Error Message Language”

-L/lib

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

-L/usr/lib

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

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

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

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

Section 20.9.16, “Building Client Programs”

-Lpath

Section 2.19.1.3, “Linux Source Distribution Notes”
Section 2.19.3, “Solaris Notes”

-N

Section 4.5.1.1, “mysql Options”

-O

Section 2.19.5.6, “Alpha-DEC-OSF/1 Notes”

-O var_name=value

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Section 5.1.2, “Server Command Options”
Section 7.5.3, “Tuning Server Parameters”

-O back_log=50

Section 2.19.3, “Solaris Notes”

-O thread_stack=192K

Section 2.19.1.5, “Linux x86 Notes”

-O0

Section 2.19.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.16.4, “Dealing with Problems Compiling MySQL”

-O2

Section 2.19.5.3, “IBM-AIX notes”

-O3

Section 2.19.5.6, “Alpha-DEC-OSF/1 Notes”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.19.5.3, “IBM-AIX notes”

-O6

Section 2.19.5.1, “HP-UX Version 10.20 Notes”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

-P

Section 4.2.2, “Connecting to the MySQL Server”
Description
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
Section 5.1.2, “Server Command Options”

-P[password]

Description

-Q

Description

-R

Description
Description
Description

-R N

Section 4.6.3.4, “Other myisamchk Options”

-R index_num

Section 6.4.4, “Table Optimization”

-R record_pos_file record_pos

Description

-RELEASE

Section 2.19.4.1, “FreeBSD Notes”

-S

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

-S file_name

Section 4.2.2, “Connecting to the MySQL Server”

-S path

Section 4.5.1.1, “mysql Options”
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 17.6.21, “Options Common to MySQL Cluster Programs”
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

-W [level]

Section 5.1.2, “Server Command Options”

-Wa,-many

Section 2.19.5.3, “IBM-AIX notes”

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

Section 2.19.1.3, “Linux Source Distribution Notes”
Section 2.19.3, “Solaris Notes”

-X

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

-Xc

Section 2.19.3, “Solaris Notes”

-Y

Description
Section 1.4.1, “What Is New in MySQL 5.0”

-a

Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Section 4.6.3.4, “Other myisamchk Options”
Section 6.4.4, “Table Optimization”

-arch generic

Section 2.19.1.7, “Linux Alpha Notes”

-arch generic

Section 2.19.1.7, “Linux Alpha Notes”

-b

Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description

-b path

Section 5.1.2, “Server Command Options”

-b offset

Section 4.6.3.4, “Other myisamchk Options”

-c

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Description
Description
Description
Description
Description
Description
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”

-c file_name

Description

-c N

Description
Description

-c column_list

Description

-c connect_string

Section 17.6.21, “Options Common to MySQL Cluster Programs”

-c file_name

Description
Description

-c filename

Description

-d

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

-d db_name

Description
Description

-e

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”
Description
Description
Description
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 17.6.21, “Options Common to MySQL Cluster Programs”
Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 4.2.3.1, “Using Options on the Command Line”
Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

-e command

Section 17.6.21, “Options Common to MySQL Cluster Programs”

-e file_name

Description

-e num

Description

-e statement

Section 4.5.1.1, “mysql Options”

-eis

Section 6.4.5, “Getting Information About a Table”

-f

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 17.2.4, “Initial Startup of MySQL Cluster”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.0 FAQ — MySQL Cluster”

-f N

Description

-f filename

Description

-fast

Section 2.19.1.7, “Linux Alpha Notes”

-felide-constructors

Section 2.16, “MySQL Installation Using a Source Distribution”

-fno-exceptions

Section 2.19.5.3, “IBM-AIX notes”
Section 2.16, “MySQL Installation Using a Source Distribution”

-fno-inline

Section 2.16.4, “Dealing with Problems Compiling MySQL”

-fno-rtti

Section 2.16, “MySQL Installation Using a Source Distribution”

-fomit-frame-pointer

Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 21.4.1.5, “Using a Stack Trace”

-fomit-frame-pointer -ffixed-ebp

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

-g

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

-g pattern

Description

-g suffix

Description

-h

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 2.16.5, “MIT-pthreads Notes”

-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

-h localhost

Section 4.2.3.1, “Using Options on the Command Line”

-h path

Section 5.1.2, “Server Command Options”

-hlocalhost

Section 4.2.3.1, “Using Options on the Command Line”

-i

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Description
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 21.4.1.3, “Using pdb to create a Windows crashdump”

-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
Description
Section 5.2.2, “The General Query Log”

-l [file_name]

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

-l lock_type

Description

-l path

Description

-ldbug

Section 20.9.17, “How to Make a Threaded Client”

-lg++

Section 2.16.4, “Dealing with Problems Compiling MySQL”

-lgcc

Section 2.19.3, “Solaris Notes”

-lgthreads -lsocket -lgthreads

Section 2.19.5.8, “SCO UNIX and OpenServer 5.0.x Notes”

-libmysqlclient

Section 20.9.2, “C API Function Overview”

-libmysqld

Section 20.9.2, “C API Function Overview”

-lm

Section 20.9.10.4, “Problems Linking with the C API”

-lmach -lexc

Section 2.19.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

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

-lmystrings

Section 20.9.17, “How to Make a Threaded Client”

-lmysys

Section 20.9.17, “How to Make a Threaded Client”

-lpthread

Section 2.19.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

-lz

Section 2.21.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.19.3.1, “Solaris 2.7/2.8 Notes”
Section 2.19.3, “Solaris Notes”

-m

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

-m64

Section 2.16, “MySQL Installation Using a Source Distribution”
Section 2.19.3, “Solaris Notes”

-max

Section 2.9.8, “Selecting a MySQL Server Type”

-mcpu

Section 2.19.3, “Solaris Notes”

-mcpu=v8 -Wa,-xarch=v8plusa

Section 2.19.3, “Solaris Notes”

-mcpu=v8 -Wa,-xarch=v8plusa

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

-mcpu=xxx

Section 2.19.5.3, “IBM-AIX notes”

-mt

Section 2.19.3, “Solaris Notes”

-n

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

-n N

Description

-n file_name

Description

-nt

Section 2.9.8, “Selecting a MySQL Server Type”

-o

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

-o async

Section 7.6, “Disk Issues”

-o N

Description

-o index_name

Description

-o noatime

Section 7.6, “Disk Issues”

-o offset

Description

-o udf_example.so

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

-p

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 5.5.2, “Adding User Accounts”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 3.3.1, “Creating and Selecting a Database”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 2.14, “Installing MySQL on NetWare”
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section B.1.2.5, “Password Fails When Entered Interactively”
Section 2.9.11, “Starting MySQL as a Windows Service”
Section 2.9.10, “Starting MySQL from the Windows Command Line”
Section 2.9.12, “Testing The MySQL Installation”
Section 2.9.14, “Upgrading MySQL on Windows”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 2.17.1, “Windows Post-Installation Procedures”

-p N

Description

-p len

Description

-p num

Description

-p password

Section 4.6.10.1, “MySQL Instance Manager Command Options”

-p[pass_val]

Section 4.2.2, “Connecting to the MySQL Server”

-p[password]

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

-ppass_val

Section 4.2.3.1, “Using Options on the Command Line”

-ppassword

Description

-pthread

Section 2.19.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

-pyour_pass

Section 5.5.6.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
Description

-qstrict

Section 2.19.5.3, “IBM-AIX notes”

-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
Description
Description
Section 6.4.3, “How to Repair Tables”

-r -q

Section 6.4.3, “How to Repair Tables”

-r file_name

Description

-r name

Description

-r path

Section 5.1.2, “Server Command Options”

-rdynamic

Section 21.2.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
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 6.4.3, “How to Repair Tables”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”

-s file_name

Description

-s num

Description

-s sort_type

Description

-server

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

-skip-auto-rehash

Section 4.5.1.1, “mysql Options”

-slow_query_log_file

Section 5.1.2, “Server Command Options”

-ss

Section 4.6.3.1, “myisamchk General Options”

-static

Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.19.1.2, “Linux Binary Distribution Notes”

-t

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

-t N

Description

-t path

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

-t seconds

Description

-u

Section 4.6.3.3, “myisamchk Repair Options”
Description
Description
Description
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.12, “Testing The MySQL Installation”
Section 5.5.1, “User Names and Passwords”
Section 2.17.1, “Windows Post-Installation Procedures”

-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
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”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 6.4.5, “Getting Information About a Table”
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-v -v -v

Section 4.5.1.1, “mysql Options”

-vv

Section 4.6.3.1, “myisamchk General Options”

-vvv

Section 4.6.3.1, “myisamchk General Options”

-w

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

-w 'where_condition'

Description

-w write_file

Description

-w[count]

Description

-x

Description
Description

-z

Description
Description

/3GB

Section D.7.3, “Windows Platform Limitations”

Aborted_connects

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

CFLAGS

Section 2.19.3, “Solaris Notes”

Com_dealloc_sql

Section 5.1.6, “Server Status Variables”

Com_delete

Section 5.1.6, “Server Status Variables”

Com_execute_sql

Section 5.1.6, “Server Status Variables”

Com_insert

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

Com_prepare_sql

Section 5.1.6, “Server Status Variables”

Com_select

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

Com_stmt_close

Section 5.1.6, “Server Status Variables”

Com_stmt_execute

Section 5.1.6, “Server Status Variables”

Com_stmt_fetch

Section 5.1.6, “Server Status Variables”

Com_stmt_prepare

Section 5.1.6, “Server Status Variables”

Com_stmt_reprepare

Section 5.1.6, “Server Status Variables”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

Com_stmt_reset

Section 5.1.6, “Server Status Variables”

Com_stmt_send_long_data

Section 5.1.6, “Server Status Variables”

ENGINE=NDB

Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”

ENGINE=NDBCLUSTER

Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”

HELP

Section 17.7.2, “Commands in the MySQL Cluster Management Client”

Ndb_cluster_node_id

Section 17.4.2, “mysqld Command Options for MySQL Cluster”

ON

Section 3.3.4.9, “Using More Than one Table”

Queries

Section 5.1.6, “Server Status Variables”

Questions

Section 5.1.6, “Server Status Variables”

Slave_running

Section 5.1.6, “Server Status Variables”

\G

Section 4.5.1.1, “mysql Options”
Section 13.2.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.5.5.31, “SHOW SLAVE STATUS Syntax”
Description
Section 1.6, “How to Report Bugs or Problems”

\P

Section 4.5.1.2, “mysql Commands”

\c

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

\q

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

\s

Section 4.5.1.2, “mysql Commands”
Section 4.2.3.3, “Using Option Files”
Section 5.5.7.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”
Description
Section 8.1.1, “Strings”
Section 4.2.3.3, “Using Option Files”

\w

Section 4.5.1.2, “mysql Commands”

all

Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 2.16.2, “Typical configure Options”

analyze

Section 12.5.2.1, “ANALYZE TABLE Syntax”

ansi

Description

backup

Section 12.5.2.2, “BACKUP TABLE Syntax”

backup_path

Description

backup_path=

Description

basedir

Section 2.9.7, “Creating an Option File”
Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 2.9.13, “Troubleshooting a MySQL Installation Under Windows”

binlog_format

Section 12.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.2, “Server Command Options”

c

Section 12.1.4, “ALTER TABLE Syntax”
Section 12.1.10, “CREATE TABLE Syntax”
Description
Section 8.2.1, “Identifier Qualifiers”
Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section 9.1.12.1, “Unicode Character Sets”

charset

Section 9.1.4, “Connection Character Sets and Collations”

check

Section 12.5.2.3, “CHECK TABLE Syntax”

col

Section 16.1.2.2, “Replication Master Options and Variables”

compress

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

connect

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

connect_timeout

Section 4.5.1.1, “mysql Options”
Description

count

Section 12.5.5.12, “SHOW ENGINE Syntax”
Section 8.2.3, “Function Name Parsing and Resolution”
Section 5.1.7, “Server SQL Modes”

csv

Section 2.16.2, “Typical configure Options”

d

Section 12.1.4, “ALTER TABLE Syntax”
Section 7.2.9, “LEFT JOIN and RIGHT JOIN Optimization”
Section 11.4.2, “Regular Expressions”
Section 21.4.3, “The DBUG Package”
Section 9.1.12.1, “Unicode Character Sets”

daemon

Section 17.3.4.4, “Defining a MySQL Cluster Management Server”

data

Section 20.9.7.25, “mysql_stmt_send_long_data()
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
Section 12.4.7.1, “XA Transaction SQL Syntax”

datadir

Section 2.9.7, “Creating an Option File”
Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 2.9.13, “Troubleshooting a MySQL Installation Under Windows”
Section D.7.3, “Windows Platform Limitations”

date

Section 11.6, “Date and Time Functions”

db

Section 12.5.1.3, “GRANT Syntax”
Section 12.5.5.27, “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 Types”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.18.5, “Copying MySQL Databases to Another Machine”
Description
Section 7.5.6, “Examining Thread Information”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.6, “Restrictions on Character Sets”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”
Section 2.17.2, “Unix Post-Installation Procedures”

dbname

Section A.5, “MySQL 5.0 FAQ — Triggers”

debug

Section 20.9.3.49, “mysql_options()
Description

decode_bits

Section 4.6.3.1, “myisamchk General Options”

default-storage-engine

Chapter 13, Storage Engines

default-table-type

Chapter 13, Storage Engines

defaults-extra-file

Section 4.2.3.3, “Using Option Files”

delimiter

Section 12.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 18.1, “Defining Stored Programs”

description

Section 12.3.3, “HELP Syntax”

e

Section B.1.5.1, “Case Sensitivity in String Searches”

event-scheduler

Section 5.1.2, “Server Command Options”

exit

Section 21.4.3, “The DBUG Package”

extended-status

Description

fields

Section 13.2.13.2.3, “InnoDB Table Monitor Output”

flush-hosts

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

flush-logs

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

flush-privileges

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

flush-status

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

flush-tables

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

flush-threads

Description
Section 5.4.1, “Privileges Provided by MySQL”

forcedirectio

Section 2.19.3, “Solaris Notes”

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”

general_log

Section 5.1.3, “Server System Variables”

have_partition_engine

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.3, “mysql Server-Side Help”
Section 1.4.1, “What Is New in MySQL 5.0”

host

Section 12.5.1.3, “GRANT Syntax”
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.2.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.18.5, “Copying MySQL Databases to Another Machine”
Description
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.17.2, “Unix Post-Installation Procedures”

html

Description

init-file

Section 7.4.5.2, “Multiple Key Caches”

initial

Section 17.7.5.1, “MySQL Cluster — Messages in the Cluster Log”

innodb_file_per_table

Section 13.2.13.2.2, “InnoDB Tablespace Monitor Output”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 13.2.13.4, “Troubleshooting InnoDB Data Dictionary Operations”

innodb_safe_binlog

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

innodb_status_file=1

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

innodb_support_xa

Section 13.2.3, “InnoDB Startup Options and System Variables”

innodb_table_locks

Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

innodb_thread_concurrency

Section 13.2.3, “InnoDB Startup Options and System Variables”

key_buffer_size

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

language

Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

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.5, “C API Prepared Statement Data types”

local

Section 5.1.5.1, “Structured System Variables”

local-infile

Section 5.3.4, “Security Issues with LOAD DATA LOCAL

log

Section 2.16.3, “Installing from the Development Source Tree”

log-bin

Section 16.1.1, “How to Set Up Replication”

log_backup_output

Section 5.1.3, “Server System Variables”

log_bin_trust_routine_creators

Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.5, “Binary Logging of Stored Programs”
Section 1.4.1, “What Is New in MySQL 5.0”
Section 5.1.3, “Server System Variables”

max_allowed_packet

Section 4.5.1.1, “mysql Options”
Description
Section 4.2.3.4, “Using Options to Set Program Variables”

multi_range_count

Section 17.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_stats_method

Section 4.6.3.1, “myisamchk General Options”

myisamchk

Section 4.6.3.4, “Other myisamchk Options”

mysql

Section 4.5.1.3, “mysql Server-Side Help”
Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 12.5.1.1, “CREATE USER Syntax”
Section B.1.2.4, “Client does not support authentication protocol
Section 12.5.3.2, “DROP FUNCTION Syntax”
Section 12.5.1.2, “DROP USER Syntax”
Section 12.5.6.2, “FLUSH Syntax”
Section 12.5.1.3, “GRANT Syntax”
Section 12.3.3, “HELP Syntax”
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section B.1.2.9, “MySQL server has gone away
Section 12.5.1.4, “RENAME USER Syntax”
Section 12.5.1.5, “REVOKE Syntax”
Section 12.5.1.6, “SET PASSWORD Syntax”
Section 12.5.5.17, “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.5.1, “Account Management Statements”
Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 6.2.1, “Backup Policy”
Section 20.9.14, “C API Prepared Statement Handling of Date and Time Values”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Chapter 20, Connectors and APIs
Section 13.2.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.18.5, “Copying MySQL Databases to Another Machine”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 8.2, “Schema Object Names”
Section 17.3.4.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Description
Section 2.18.2, “Downgrading MySQL”
Section 7.5.9, “Enabling Large Page Support”
Section 5.3.1, “General Security Guidelines”
Section 7.5.5.1, “How the Query Cache Operates”
Section 16.1.1, “How to Set Up Replication”
Section 13.7.2, “How to Use FEDERATED Tables”
Section 2.15, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.10, “Installing MySQL from RPM Packages on Linux”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.12, “Installing MySQL on Solaris”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 1.4.1, “What Is New in MySQL 5.0”
Section A.11, “MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section A.4, “MySQL 5.0 FAQ — Stored Procedures and Functions”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 20.10, “MySQL PHP API”
Section 9.7, “MySQL Server Time Zone Support”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 4.1, “Overview of MySQL Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.17.2.1, “Problems Running mysql_install_db
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.7, “Replication and FLUSH
Section 16.3.1.25, “Replication and User Privileges”
Section 16.3.1.15, “Replication of the System mysql Database”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section 13.2.14, “Restrictions on InnoDB Tables”
Section D.6, “Restrictions on Character Sets”
Section D.1, “Restrictions on Stored Routines and Triggers”
Section 2.19.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.17.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.1.8, “Server-Side Help”
Section 2.16.1, “Source Installation Overview”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
Section 12.4.3, “Statements That Cause an Implicit Commit”
Section 9.7.1, “Staying Current with Time Zone Changes”
Section 5.4, “The MySQL Access Privilege System”
Section 2.9.13, “Troubleshooting a MySQL Installation Under Windows”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 2.18.1, “Upgrading MySQL”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 13.2.2.2, “Using Raw Devices for the Shared Tablespace”
Section 5.5.7.2, “Using SSL Connections”
Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 18.2, “Using Stored Routines (Procedures and Functions)”
Section 2.17.1, “Windows Post-Installation Procedures”

mysqlbinlog

Section 12.5.5.2, “SHOW BINLOG EVENTS Syntax”
Section 6.3, “Point-in-Time Recovery”
Section 5.2.3, “The Binary Log”

mysqld

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 20.9.2, “C API Function Overview”
Description
Description
Description
Section 13.7.1, “Description of the FEDERATED Storage Engine”
Section 2.13, “Installing MySQL on i5/OS”
Section 17.4.1, “MySQL Cluster Server Option and Variable Reference”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 16.4.2, “Replication Relay and Status Files”
Section 5.1.1, “Server Option and Variable Reference”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 5.2.1, “The Error Log”
Section 21.4.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.1, “The Error Log”

ndb-connectstring

Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”
Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”

ndb_mgmd

Description

ndb_optimization_delay

Section 12.5.2.5, “OPTIMIZE TABLE Syntax”
Section 17.10.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”

ndb_restore

Description

ndbd

Description

net_retry_count

Section 16.4.1, “Replication Implementation Details”

net_write_timeout

Section 16.4.1, “Replication Implementation Details”

nice

Description

nodeid

Description

nonguarded

Description

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

old-alter-table

Section 12.1.4, “ALTER TABLE Syntax”

open_files_limit

Description
Section D.7.3, “Windows Platform Limitations”

optimize

Section 12.5.2.5, “OPTIMIZE TABLE Syntax”

p

Section 12.2.1, “CALL Syntax”
Section 18.2.1, “Stored Routine Syntax”
Section 21.4.3, “The DBUG Package”

password

Description

pid-file

Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 5.2.3, “The Binary Log”

ping

Description
Section 16.3.5, “Troubleshooting Replication”

pipe

Section 20.9.3.49, “mysql_options()

port

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

print

Section 11.4.2, “Regular Expressions”

processlist

Description

prompt

Section 4.5.1.2, “mysql Commands”

quick

Section 4.2.3.3, “Using Option Files”

quit

Section 4.5.1.1, “mysql Options”

raw

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

read_buffer_size

Section 4.6.3.1, “myisamchk General Options”

reconnect

Section B.1.2.9, “MySQL server has gone away
Section 20.9.3.52, “mysql_real_connect()
Section 20.9.2, “C API Function Overview”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

record_buffer

Section 7.5.8, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 7.5.3, “Tuning Server Parameters”

refresh

Description
Section 5.4.1, “Privileges Provided by MySQL”

rehash

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

reload

Description
Section 5.4.1, “Privileges Provided by MySQL”

repair

Section 12.5.2.6, “REPAIR TABLE Syntax”

replication-ignore-table

Section 16.3.1.27, “Replication and Views”

resolve_stack_dump

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

resolveip

Section 2.19.1.2, “Linux Binary Distribution Notes”

rows

Section 7.2.1, “Optimizing Queries with EXPLAIN

s

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

select_limit

Section 4.5.1.1, “mysql Options”

server-id

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

server-id=3

Section 16.1.2.3, “Replication Slave Options and Variables”

set-variable

Section 4.2.3.3, “Using Option Files”

set-variable=option=value

Section 4.2.3.4, “Using Options to Set Program Variables”

shutdown

Description
Section 2.19.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

shutdown_timeout

Description

skip-innodb

Section 13.2.2, “InnoDB Configuration”

skip-networking

Section 16.3.4, “Replication FAQ”
Section 16.1.1.2, “Setting the Replication Master Configuration”
Section 16.3.5, “Troubleshooting Replication”

slave

Section 1.2, “Typographical and Syntax Conventions”

slow_query_log

Section 5.1.3, “Server System Variables”

sort

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

sort_buffer_size

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

sort_key_blocks

Section 4.6.3.1, “myisamchk General Options”

source

Appendix B, Errors, Error Codes, and Common Problems
Section 4.5.1.4, “Executing SQL Statements from a Text File”
Section 3.5, “Using mysql in Batch Mode”

sql-mode=""

Section 5.1.7, “Server SQL Modes”

sql-mode="modes"

Section 5.1.7, “Server SQL Modes”

sql_big_tables

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

sql_low_priority_updates

Section 5.1.3, “Server System Variables”

sql_max_join_size

Section 5.1.3, “Server System Variables”

start-slave

Description

stats_method

Section 4.6.3.1, “myisamchk General Options”

status

Section 4.5.1.2, “mysql Commands”
Section 12.5.2.1, “ANALYZE TABLE Syntax”
Section 12.5.2.2, “BACKUP TABLE Syntax”
Section 12.5.2.3, “CHECK TABLE Syntax”
Section 12.5.2.5, “OPTIMIZE TABLE Syntax”
Section 12.5.2.6, “REPAIR TABLE Syntax”
Section 12.5.2.7, “RESTORE TABLE Syntax”
Description
Section 4.6.10.5, “MySQL Server Instance Status Monitoring”

stop-slave

Description

syslog

Section 17.3.4.4, “Defining a MySQL Cluster Management Server”
Description
Section 17.7.4, “Event Reports Generated in MySQL Cluster”
Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
Section 5.2.1, “The Error Log”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”

system

Chapter 19, INFORMATION_SCHEMA Tables

tab

Section 11.4.2, “Regular Expressions”

table

Section 20.9.1, “C API Data Types”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 12.2.9.8, “Subqueries in the FROM clause”

test

Section 12.2.2, “DELETE Syntax”
Section 13.2.13.2.3, “InnoDB Table Monitor Output”
Section 11.3, “Control Flow Functions”
Section 13.2.4, “Creating and Using InnoDB Tables”
Section 3.3, “Creating and Using a Database”
Description
Section 3.6, “Examples of Common Queries”
Section 8.2.3, “Function Name Parsing and Resolution”
Section 4.2.1, “Invoking MySQL Programs”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 2.17.3, “Securing the Initial MySQL Accounts”
Section 18.2.1, “Stored Routine Syntax”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 4.2.3.1, “Using Options on the Command Line”

timeout

Section 20.9.3.49, “mysql_options()

tmpdir

Section 4.6.3.3, “myisamchk Repair Options”
Section B.1.2.13, “Can't create/write to file
Section 7.2.13, “ORDER BY Optimization”
Section 6.1, “Database Backups”
Section 2.9, “Installing MySQL on Windows”
Section 16.4.2, “Replication Relay and Status Files”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

type

Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 13.2.13.2.3, “InnoDB Table Monitor Output”
Section 20.9.1, “C API Data Types”
Section 7.2.18, “How to Avoid Table Scans”
Section 7.2.6, “Index Merge Optimization”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

update

Section 7.5.6.3, “Delayed-Insert Thread States”

use-manager

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

user

Section 12.5.1.2, “DROP USER Syntax”
Section B.1.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.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.9, “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.2.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.18.5, “Copying MySQL Databases to Another Machine”
Section 17.3.4.4, “Defining a MySQL Cluster Management Server”
Description
Section 11.10.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.6, “Restrictions on Character Sets”
Section 2.17.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.4.3, “Specifying Account Names”
Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
Section 2.17.2, “Unix Post-Installation Procedures”
Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”

v

Section 12.1.12, “CREATE VIEW Syntax”
Section 16.3.1.8, “Replication and System Functions”

variables

Description

version

Description
Section 5.1.3, “Server System Variables”

write

Section 21.4.4, “Comments about RTS Threads”

write_buffer_size

Section 4.6.3.1, “myisamchk General Options”