Option Index
Prev Next

Option Index

-

Section 12.1.1, “ALTER DATABASE Syntax”
Section 11.17.2, “DECIMAL Data Type Changes”
Section 12.4.1.3, “GRANT Syntax”
Section 11.6.1, “Arithmetic Operators”
Section 11.9.2, “Boolean Full-Text Searches”
Section 10.7, “Choosing the Right Type for a Column”
Section 11.7, “Date and Time Functions”
Section 4.2.1, “Invoking MySQL Programs”
Section 8.1.2, “Numbers”
Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”
Section 11.5.2, “Regular Expressions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 5.4.3, “Specifying Account Names”
Section 4.2.3.1, “Using Options on the Command Line”

-#

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

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

-#...

Section 21.4.3, “The DBUG Package”

-#D,20

Section 21.4.3, “The DBUG Package”

-#debug_options

Description

--

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

--HELP

Section 4.6.3.1, “myisamchk General Options”

--Information

Description

--abort-slave-event-count

Section 16.1.2.3, “Replication Slave Options and Variables”

--add-drop-database

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

--add-drop-table

Description

--add-drop-trigger

Description

--add-locks

Description

--add-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--addtodest

Description

--all

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

--all-databases

Description
Description
Description
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
Section 6.4.2, “Reloading SQL-Format Backups”

--all-in-1

Description

--all-tablespaces

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

--allow-keywords

Description

--allow-suspicious-udfs

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

--allowold

Description

--analyze

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

--angel-pid-file

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--angel-pid-file=file_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--ansi

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

--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.15, “Installing MySQL on NetWare”

--back_log=50

Section 2.13, “Installing MySQL on Solaris”
Section 2.20.3, “Solaris Notes”

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Description

--backup_history_log

Section 5.1.2, “Server Command Options”

--backup_progress_log

Section 5.1.2, “Server Command Options”

--base64-output

Description

--base64-output=ALWAYS

Description

--base64-output=AUTO

Description

--base64-output[=value]

Description

--basedir

Description
Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 17.1.5.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.18.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.17.2, “Typical configure Options”
Section 2.18.1, “Unix Post-Installation Procedures”

--basedir=path

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

--batch

Section 4.5.1.3, “mysql History File”
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.18.1.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.5.2.12, “The table is full”
Section 7.9.5, “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.5.2.2, “Can't connect to [local] MySQL server”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.6.10.4, “Instance Manager User and Password Management”

--bind-address=IP

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

--binlog-do-db

Section 16.1.2.4, “Binary Log Options and Variables”
Description
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.4.1.10, “Replication and LOAD Operations”
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.2.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 17.1.5.6, “Unsupported or Missing Features in MySQL Cluster”

--binlog-format=ROW

Section 17.1.5.6, “Unsupported or Missing Features in MySQL Cluster”

--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.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.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”
Description

--block-search=offset

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Description
Section 5.1.2, “Server Command Options”
Section 2.17.2, “Typical configure Options”

--brief

Description

--build=x86_64-pc-solaris2.10

Section 2.17, “MySQL Installation from a Source Distribution”

--cflags

Description

--character-set-client-handshake

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

--character-set-filesystem=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server

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

--character-set-server=charset_name

Section 5.1.2, “Server Command Options”

--character-set-server=latin1

Section 9.1.3.1, “Server Character Set and Collation”

--character-sets-dir

Section B.5.2.17, “Can't initialize character set”
Section 9.5, “Character Set Configuration”
Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”

--character-sets-dir=path

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

--charset=path

Description

--check

Section 4.6.3.2, “myisamchk Check Options”
Description

--check-only-changed

Section 4.6.3.2, “myisamchk Check Options”
Description

--check-password-file

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--check-upgrade

Description
Description

--checkpoint

Description

--checkpoint=db_name.tbl_name

Description

--chroot

Description

--chroot=path

Description
Section 5.1.2, “Server Command Options”

--clean-password-file

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

--clear

Description

--clear-only

Description

--col

Description

--collation-server

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

--collation-server=collation_name

Section 5.1.2, “Server Command Options”

--collation-server=latin1_swedish_ci

Section 9.1.3.1, “Server Character Set and Collation”

--column-names

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

--column-type-info

Section 4.5.1.1, “mysql Options”

--columns=column_list

Description

--comments

Section 4.5.1.1, “mysql Options”
Description

--commit

Description

--comp

Section 4.2.3, “Specifying Program Options”

--compact

Description

--compatible

Description

--compatible=name

Description

--compatible=oracle

Description

--complete-insert

Description

--compr

Section 4.2.3, “Specifying Program Options”

--compress

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

--config-cache

Section 17.3.2, “MySQL Cluster Configuration Files”

--config-file

Description
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 1.5, “What Is New in MySQL 5.0”

--config-file=file_name

Description
Description

--config-file=path_name

Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”

--configdir

Section 17.3.2, “MySQL Cluster Configuration Files”

--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.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.2, “Server Command Options”
Section 5.2.1, “The Error Log”

--copy

Description

--core-file

Section 21.4.1.4, “Debugging mysqld under gdb”
Section 2.20.1.4, “Linux Post-Installation Notes”
Section 5.1.2, “Server Command Options”

--core-file-size

Section 5.1.2, “Server Command Options”

--core-file-size=1000000

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

--daemon

Description

--data-file-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--database

Description

--database=db_name

Section 4.5.1.1, “mysql Options”
Description

--databases

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

--datadir

Section 13.5.3, “BDB Startup Options”
Description
Description
Section 5.1.3, “Server System Variables”
Section 2.18.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.17.2, “Typical configure Options”
Section 2.18.1, “Unix Post-Installation Procedures”
Section 4.2.3.3, “Using Option Files”

--datadir=path

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

--date=YYMMDD

Description

--db=db_name

Description

--debug

Section 21.4.1.1, “Compiling MySQL for Debugging”
Description
Description
Description
Description
Section 5.1.3, “Server System Variables”
Section 2.18.1.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
Description

--debug-info

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

--debug-sync-timeout=N

Section 5.1.3, “Server System Variables”
Section 2.17.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.17.2, “Typical configure Options”

--debug=+P

Section 5.1.2, “Server Command Options”

--debug=N

Description

--debug=T

Section 5.1.2, “Server Command Options”

--debug=d,general,query

Section 5.4.7, “Causes of Access-Denied Errors”

--debug=debug_options

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

--debug[=debug_options]

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

--default-character-set

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

--default-character-set=charset_name

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

--default-character-set=system_character_set

Section 9.5, “Character Set Configuration”

--default-character-set=utf8

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

--default-collation

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

--default-collation=collation_name

Section 5.1.2, “Server Command Options”

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

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-mysqld-path=path

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--default-storage-engine

Section 13.2.2, “InnoDB Configuration”
Section 13.2.3, “InnoDB Startup Options and System Variables”
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.4.5.13, “SHOW ENGINES Syntax”

--default-table-type=type

Section 5.1.2, “Server Command Options”

--default-time-zone

Section 16.4.1.23, “Replication and Time Zones”
Section 5.1.3, “Server System Variables”

--default-time-zone=timezone

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

--default.key_buffer_size=256K

Section 5.1.4.1, “Structured System Variables”

--defaults-extra-file

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

--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.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”

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

--defaults-group-suffix

Section 2.21, “Environment Variables”

--defaults-group-suffix=_other

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

--defaults-group-suffix=str

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

--defaults-group-suffix=suffix

Description

--delay-key-write

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

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

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

--delay-key-write=ALL

Section 13.1.1, “MyISAM Startup Options”
Section 7.7.4, “External Locking”
Section 16.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 1.5, “What Is New in MySQL 5.0”

--delay-key-write=OFF

Section 7.7.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.4, “Using System Variables”

--delay_key_write=ON

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

--delayed-insert

Description

--delete

Description

--delete-master-logs

Description

--delimiter=str

Section 4.5.1.1, “mysql Options”

--demangle

Section 21.4.1.5, “Using a Stack Trace”

--des-key-file

Section 12.4.6.2, “FLUSH Syntax”
Section 11.12, “Encryption and Compression Functions”

--des-key-file=file_name

Section 5.1.2, “Server Command Options”

--description

Section 4.6.3.4, “Other myisamchk Options”

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

--disable-debug-sync

Section 2.17.2, “Typical configure Options”

--disable-dtrace

Section 2.17.2, “Typical configure Options”

--disable-grant-options

Description
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.17.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.17.2, “Typical configure Options”

--disable-shared

Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section 2.17.2, “Typical configure Options”

--disconnect-slave-event-count

Section 16.1.2.3, “Replication Slave Options and Variables”

--drop-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--dryrun

Description

--dump

Description

--dump-date

Description

--dump-slave

Description

--dump-slave[=value]

Description

--edit-user

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--embedded

Description
Description

--enable-assembler

Section 2.20.3, “Solaris Notes”

--enable-community-features

Section 2.17.2, “Typical configure Options”

--enable-debug-sync

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

--enable-dtrace

Section 2.17.2, “Typical configure Options”

--enable-local-infile

Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

--enable-locking

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

--enable-named-pipe

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

--enable-profiling

Section 2.17.2, “Typical configure Options”

--enable-pstack

Section 5.1.2, “Server Command Options”

--enable-thread-safe-client

Section 2.17.2, “Typical configure Options”

--engine-condition-pushdown

Section 17.1.4.1, “MySQL Cluster Developement in MySQL 5.0”

--err-log=file_name

Description
Section 5.2.1, “The Error Log”

--event-scheduler

Section 5.1.2, “Server Command Options”

--event-scheduler=DISABLED

Section 5.1.2, “Server Command Options”

--event-scheduler[=value]

Section 5.1.2, “Server Command Options”

--events

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

--example

Description

--exe-suffix=suffix

Description

--execute

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

--execute=statement

Section 4.5.1.1, “mysql Options”

--exit-info[=flags]

Section 5.1.2, “Server Command Options”

--extend-check

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

--extended

Description

--extended-insert

Description

--external-locking

Section 13.1.1, “MyISAM Startup Options”
Section 7.7.4, “External Locking”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 7.9.2, “System Factors and Startup Parameter Tuning”
Section 1.5, “What Is New in MySQL 5.0”

--extra-file=file_name

Description

--fast

Section 4.6.3.2, “myisamchk Check Options”
Description

--federated

Section 13.7, “The FEDERATED Storage Engine”

--fields-enclosed-by

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

--fields-enclosed-by=...

Description
Description

--fields-enclosed-by=char

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

--fields-escaped-by=...

Description
Description

--fields-escaped-by=char

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

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

Description
Description

--fields-optionally-enclosed-by=char

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

--fields-terminated-by=...

Description
Description

--fields-terminated-by=str

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

--fields-xxx

Description

--first-slave

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

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

--flush-logs

Description
Section 6.3.1, “Establishing a Backup Policy”

--flush-privileges

Description

--flush_time=val

Section 21.1.1, “MySQL Threads”

--flushlog

Description

--force

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Description
Description
Description
Description
Description
Description
Description
Description
Section 2.20.1.2, “Linux Binary Distribution Notes”
Section 21.1.2, “MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

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[={0|1}]

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_file=file_name

Description

--help

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

--hex-blob

Description

--hexdump

Description

--host

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

--host=--user

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

--host=127.0.0.1

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

--host=host_name

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

--host=localhost

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

--howto

Description

--html

Section 4.5.1.1, “mysql Options”

--i-am-a-dummy

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

--idx

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

Description

--include

Description

--include-master-host-port

Description

--info

Description
Description

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-file

Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.3, “Server System Variables”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 2.17.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.2.5, “Defining MySQL Cluster Data Nodes”
Description
Section 17.2.6.2, “MySQL Cluster 5.0 Upgrade and Downgrade Compatibility”
Section 17.3.2, “MySQL Cluster Configuration Files”
Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
Section 17.3.3.2, “MySQL Cluster Management Node Configuration Parameters”
Section 17.3.3.3, “MySQL Cluster SQL Node and API Node Configuration Parameters”
Section 17.3.3.4, “Other MySQL Cluster Configuration Parameters”
Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.5.1, “Summary of MySQL Cluster Start Phases”

--initial-start

Description

--innodb

Section 13.2.3, “InnoDB Startup Options and System Variables”

--innodb-safe-binlog

Section 16.4.1.13, “Replication and Master or Slave Shutdowns”
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-xxx

Section 5.1.2, “Server Command Options”

--innodb=OFF

Section 13.2.2, “InnoDB Configuration”
Section 13.2.3, “InnoDB Startup Options and System Variables”

--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 5.1.2, “Server Command Options”
Section 13.2.2.1, “Using Per-Table Tablespaces”
Section 7.9.7.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”

--innodb_support_xa

Section 5.2.3, “The Binary Log”

--insert-ignore

Description

--install

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 5.6.1.2, “Starting Multiple Windows Servers as Services”

--install-manual

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

--install[=name]

Description

--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 5.1.2, “Server Command Options”
Section 9.2, “Setting the Error Message Language”

--language=lang_name, -L lang_name

Section 5.1.2, “Server Command Options”

--large-pages

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

--lc-messages

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

--lc-messages-dir

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

--lc-messages-dir=path

Section 5.1.2, “Server Command Options”

--lc-messages=locale_name

Section 5.1.2, “Server Command Options”

--ldata=path

Description

--ledir

Description

--ledir=path

Description

--length

Description

--libmysqld-libs

Description

--libs

Description

--libs_r

Description

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Description

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

Description

--lines-terminated-by=...

Description
Description

--lines-terminated-by=str

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

--list-users

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--local

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

--local-infile=0

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

--local-infile=1

Section 4.5.1.1, “mysql Options”

--local-infile[=1]

Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

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

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

--local-load

Description

--local-load=path

Description

--lock-all-tables

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

--lock-tables

Description
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.5.2.1, “CHANGE MASTER TO Syntax”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 6.3.3, “Backup Strategy Summary”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.6, “Binary Logging of Stored Programs”
Section C.1, “Changes in Release 5.0.x (Production)”
Section 6.2, “Database Backup Methods”
Section 6.3.1, “Establishing a Backup Policy”
Section 16.4.6, “How to Report Replication Bugs or Problems”
Section 21.4.1.7, “Making a Test Case If You Experience Table Corruption”
Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 16.4.4, “Replication FAQ”
Section 16.1.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 16.3.6, “Switching Masters During Failover”
Section 5.2.3, “The Binary Log”
Section 5.2.2, “The General Query Log”
Section 16.4.5, “Troubleshooting Replication”
Section 16.4.3, “Upgrading a Replication Setup”
Section 6.3.2, “Using Backups for Recovery”

--log-bin-index

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

--log-bin-index[=file_name]

Section 16.1.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.6, “Binary Logging of Stored Programs”
Section 1.5, “What Is New in MySQL 5.0”

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

Section 16.1.2.4, “Binary Log Options and Variables”
Section 18.6, “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.6, “Binary Logging of Stored Programs”
Section 1.5, “What Is New in MySQL 5.0”

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

Section 18.6, “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.3.3, “Backup Strategy Summary”

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

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

--log-output

Section 5.1.2, “Server Command Options”
Section 5.2.2, “The General Query Log”
Section 5.2.4, “The Slow Query Log”
Section 1.5, “What Is New in MySQL 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.4.6, “How to Report Replication Bugs or Problems”
Section 16.3.5, “Improving Replication Performance”
Section 16.4.4, “Replication FAQ”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.3.6, “Switching Masters During Failover”
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”
Section 5.2.4, “The Slow Query Log”

--log-tc-size

Section 5.1.5, “Server Status Variables”

--log-tc-size=size

Section 5.1.2, “Server Command Options”

--log-tc=file_name

Section 5.1.2, “Server Command Options”

--log-update

Section C.1, “Changes in Release 5.0.x (Production)”
Section 5.2.5, “Server Log Maintenance”
Section 1.5, “What Is New in MySQL 5.0”

--log-update[=file_name]

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

--log-warnings

Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 16.1.1, “How to Set Up Replication”
Section 5.1.2, “Server Command Options”
Section 5.2.1, “The Error Log”
Section 1.5, “What Is New in MySQL 5.0”

--log-warnings=0

Section 5.1.2, “Server Command Options”

--log-warnings=2

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

--log-warnings[=level]

Section 16.1.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”

--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.7.3, “Concurrent Inserts”
Section 16.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 7.7.2, “Table Locking Issues”

--lower-case-table-names=0

Section 8.2.2, “Identifier Case Sensitivity”

--malloc-lib

Description

--malloc-lib=

Description

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

Description

--malloc-lib=[lib_name]

Description

--malloc-lib=tcmalloc

Description

--master-bind

Section 12.5.2.1, “CHANGE MASTER TO Syntax”

--master-connect-retry

Section 12.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.2, “Replication Implementation”
Section 7.10.6, “Replication Slave I/O Thread States”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.4.1.13, “Replication and Master or Slave Shutdowns”
Section 1.5, “What Is New in MySQL 5.0”

--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
Section 6.3.1, “Establishing a Backup Policy”

--master-data[=value]

Description

--master-host

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

--master-host=host_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-info-file

Section 16.2.2.2, “The Slave Status Files”

--master-info-file=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-password

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

--master-password=password

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-port

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

--master-port=port_number

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-retry-count

Section 12.5.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 16.1.2.3, “Replication Slave Options and Variables”
Section 1.5, “What Is New in MySQL 5.0”

--master-ssl*

Section 5.5.6.3, “SSL Command Options”

--master-ssl-ca

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

--master-ssl-ca=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-capath

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

--master-ssl-capath=directory_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-cert

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

--master-ssl-cert=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-cipher

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

--master-ssl-cipher=cipher_list

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-ssl-key

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

--master-ssl-key=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-user

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

--master-user=user_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--master-xxx

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

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-binlog-dump-events=N

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.4.2.6, “REPAIR TABLE Syntax”

--max-record-length=len

Section 4.6.3.3, “myisamchk Repair Options”

--max-relay-log-size

Section 16.1.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.3.1.16, “How to Avoid Table Scans”
Section B.5.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.4, “Using Options to Set Program Variables”

--max_connect_errors=999999999

Section 12.4.6.2, “FLUSH Syntax”

--max_join_size

Section 4.5.1.6.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.6.3.3, “Query Cache Configuration”
Section 5.1.4, “Using System Variables”

--maximum-query_cache_size=4M

Section 4.2.3.2, “Program Option Modifiers”

--maximum-var_name=value

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

--medium-check

Section 4.6.3.2, “myisamchk Check Options”
Description

--memlock

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

--mutex-deadlock-detector

Section 5.1.2, “Server Command Options”

--myisam-block-size

Section 7.6.1.5, “Key Cache Block Size”

--myisam-block-size=N

Section 5.1.2, “Server Command Options”

--myisam-recover

Section 13.1.1, “MyISAM Startup Options”
Section 7.3.3, “Other Optimization Tips”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.5.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-options

Section 13.1.1, “MyISAM Startup Options”
Section 7.3.3, “Other Optimization Tips”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.5.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-options=BACKUP,FORCE

Section 5.1.3, “Server System Variables”

--myisam-recover-options=mode

Section 13.1.1, “MyISAM Startup Options”

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

Section 5.1.2, “Server Command Options”

--myisam-recover=BACKUP,FORCE

Section 5.1.3, “Server System Variables”

--myisam-recover=mode

Section 13.1.1, “MyISAM Startup Options”

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

Section 5.1.2, “Server Command Options”

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

Section 5.1.2, “Server Command Options”

--mysqladmin=prog_name

Description

--mysqld

Description

--mysqld-safe-compatible

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

--mysqld-version

Description

--mysqld-version=debug

Description

--mysqld-version=max

Description

--mysqld-version=suffix

Description

--mysqld=mysqld_safe

Description

--mysqld=prog_name

Description
Description

--name_file=file_name

Description

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Description

--ndb-batch-size=#

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=#

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-cluster-connection-pool=4

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-connectstring

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

--ndb-connectstring=connect_string

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb-log-empty-epochs

Section 16.1.2.3, “Replication Slave Options and Variables”

--ndb-nodeid

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

--ndb-nodeid=#

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--ndb_optimized_node_selection

Section 17.3.4.3, “MySQL Cluster System Variables”

--ndbcluster

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 12.4.5.13, “SHOW ENGINES Syntax”
Section 17.3, “MySQL Cluster Configuration”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

--ndbcluster --ndb-connectstring=management_host

Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”

--ndbinfo-database=name

Section 17.3.4.3, “MySQL Cluster System Variables”

--ndbinfo-table-prefix

Section 17.3.4.3, “MySQL Cluster System Variables”

--new

Section 8.1.4, “Hexadecimal Values”
Section 10.1.2, “Overview of Date and Time Types”
Section 5.1.2, “Server Command Options”
Section 4.2.3.3, “Using Option Files”

--nice=priority

Description

--no-auto-rehash

Section 4.5.1.1, “mysql Options”

--no-autocommit

Description

--no-beep

Section 4.5.1.1, “mysql Options”
Description

--no-create-db

Description

--no-create-info

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

--no-data

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

--no-debug

Description

--no-defaults

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

--no-embedded

Description

--no-log

Description

--no-named-commands

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

--no-pager

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

--no-set-names

Description

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tablespaces

Description

--no-tee

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

--nodaemon

Description

--nodeid

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--noindices

Description

--nostart

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

Section 5.1.2, “Server Command Options”

--old-passwords

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

--old-protocol

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

--old-style-user-limits

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

--old_server

Description
Description

--one-database

Section 4.5.1.1, “mysql Options”

--one-thread

Section 5.1.2, “Server Command Options”

--only-debug

Description

--open-files-limit

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 13.2.3, “InnoDB Startup Options and System Variables”
Section 2.20.4.1, “FreeBSD Notes”
Section 7.8.2, “How MySQL Opens and Closes Tables”
Section 5.1.3, “Server System Variables”

--open-files-limit=count

Description
Section 5.1.2, “Server Command Options”

--opt

Section 13.2.13.1, “InnoDB Performance Tuning Tips”
Description

--opt_name

Section 4.2.3.3, “Using Option Files”

--opt_name=value

Section 4.2.3.3, “Using Option Files”

--optimize

Description

--order-by-primary

Description

--out_dir=path

Description

--out_file=file_name

Description

--packlength=len

Description

--pager

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

--pager[=command]

Section 4.5.1.1, “mysql Options”

--parallel-recover

Section 4.6.3.3, “myisamchk Repair Options”

--partition[=value]

Section 5.1.2, “Server Command Options”

--passwd

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

--password

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

--password-file

Section 4.6.10.4, “Instance Manager User and Password Management”

--password-file=file_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--password=

Section 4.2.2, “Connecting to the MySQL Server”

--password=pass_val

Section 4.2.3.1, “Using Options on the Command Line”

--password=password

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

--password=your_pass

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

--password[=pass_val]

Section 4.2.2, “Connecting to the MySQL Server”

--password[=password]

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

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

--plan

Description

--plugin

Section 5.1.2, “Server Command Options”

--plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--plugin-load

Section 5.1.2, “Server Command Options”

--plugin-load=plugin_list

Section 5.1.2, “Server Command Options”

--plugin-sql-mode

Section 5.1.2, “Server Command Options”

--plugin-xxx

Section 5.1.2, “Server Command Options”

--plugindir

Description

--plugins=max

Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

--plugins=max-no-innodb

Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

--plugins=ndbcluster

Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

--port

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

--port-open-timeout=num

Section 5.1.2, “Server Command Options”

--port=port_num

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

--port=port_number

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

--position

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

--position=N

Description

--prefix

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

--prefix=prefix_str

Description

--preview

Description

--print-defaults

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

--print-password-line

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

--printerror=1

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 5.6.3, “Using Client Programs in a Multiple-Server Environment”

--protocol=PIPE

Section 4.2.2, “Connecting to the MySQL Server”
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-cache-size=0

Section 7.7.4, “External Locking”

--quick

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

--quiet

Description
Description

--quote-names

Description

--raw

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

--read-from-remote-server

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

--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.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--regexp=expr

Description

--regexp=pattern

Description

--relative

Description

--relay-log

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

--relay-log-index

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

--relay-log-index=file_name

Section 16.1.2.3, “Replication Slave Options and Variables”

--relay-log-info-file

Section 16.2.2.2, “The Slave Status Files”

--relay-log-info-file=file_name

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

--relay-log=relay_log_index

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

--relnotes

Description

--reload

Section 17.3.2, “MySQL Cluster Configuration Files”

--remove

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

--remove[=name]

Description

--repair

Description

--replace

Description
Description

--replicate-*

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

--replicate-*-db

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

--replicate-*-do-*

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-ignore-*

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-table

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

--replicate-[do|ignore]-table

Section 13.10, “The BLACKHOLE Storage Engine”

--replicate-do-db

Section 12.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.4.1.19, “Replication and Reserved Words”
Section 16.4.1.15, “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.3, “Replication Slave Options and Variables”

--replicate-do-table

Section 12.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.2.3.3, “Replication Rule Application”
Section 16.4.1.19, “Replication and Reserved Words”
Section 16.4.1.15, “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.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.2.3.3, “Replication Rule Application”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.4.1.19, “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.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.4.1.19, “Replication and Reserved Words”
Section 16.4.1.15, “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.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”

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

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

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

Section 16.1.2.3, “Replication Slave Options and Variables”

--replicate-same-server-id

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

--replicate-wild-do-table

Section 12.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.4.1.15, “Replication and Temporary Tables”

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

Section 16.3.4, “Replicating Different Databases to Different Slaves”

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

Section 16.3.4, “Replicating Different Databases to Different Slaves”

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

Section 16.3.4, “Replicating Different Databases to Different Slaves”

--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”
Section D.1, “Restrictions on Stored Routines and Triggers”

--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.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 16.4.1.15, “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.4.4, “Replication FAQ”
Section 16.4.1.17, “Replication and User Privileges”

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

Section 16.4.1.15, “Replication and Temporary Tables”

--report-host

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

--report-host=host_name

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

--result-file

Description

--result-file=file_name

Description

--result-file=name

Description

--rhost=host_name

Description

--rollback

Description

--routines

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

--rows=N

Description

--rpm

Description

--run-as-service

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--safe-mode

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

--safe-recover

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

--safe-show-database

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

--safe-updates

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

--safe-user-create

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

--secure-auth

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

--secure-backup-file-priv

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

--secure-backup-file-priv=path

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

--secure-file-priv

Section 2.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.17.1, “Source Installation Overview”

--secure-file-priv=path

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

--select_limit

Section 4.5.1.6.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.4.5, “Troubleshooting Replication”

--server-id-bits

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

--server-id-bits=#

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

--server-id-bits=N

Description

--server-id=id

Description

--server-id=value

Section 12.4.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=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.9.3, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”
Section 1.5, “What Is New in MySQL 5.0”

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

--shared-memory-base-name

Section 20.8.3.49, “mysql_options()”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
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.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--single-transaction

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

--skip

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

--skip-add-drop-table

Description

--skip-add-locks

Description

--skip-auto-rehash

Section 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.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-character-set-client-handshake

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

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Description

--skip-compact

Description

--skip-concurrent-insert

Section 5.1.2, “Server Command Options”

--skip-delay-key-write

Section 5.1.2, “Server Command Options”

--skip-disable-keys

Description

--skip-dump-date

Description

--skip-engine_name

Section 12.4.5.13, “SHOW ENGINES Syntax”

--skip-event-scheduler

Section 5.1.2, “Server Command Options”

--skip-events

Section 6.4.5.3, “Dumping Stored Programs”

--skip-extended-insert

Description

--skip-external-locking

Section 7.7.4, “External Locking”
Section 7.10.2, “General Thread States”
Section 2.15, “Installing MySQL on NetWare”
Section 5.1.2, “Server Command Options”
Section 7.9.2, “System Factors and Startup Parameter Tuning”
Section 1.5, “What Is New in MySQL 5.0”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--skip-grant-tables

Section 12.4.3.1, “CREATE FUNCTION Syntax”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Description
Description
Section 2.18.1.1, “Problems Running mysql_install_db”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.17.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.9.9, “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.4.5.13, “SHOW ENGINES Syntax”
Section 16.4.4, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

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

Description

--skip-locking

Section 7.7.4, “External Locking”
Section 1.5, “What Is New in MySQL 5.0”

--skip-log-warnings

Section 16.1.2.3, “Replication Slave Options and Variables”

--skip-merge

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

--skip-mutex-deadlock-detector

Section 5.1.2, “Server Command Options”

--skip-name-resolve

Section 5.4.7, “Causes of Access-Denied Errors”
Description
Section 2.20.4.1, “FreeBSD Notes”
Section 7.9.9, “How MySQL Uses DNS”
Section 2.18.2, “Securing the Initial MySQL Accounts”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-named-commands

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

--skip-ndbcluster

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

--skip-networking

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

--skip-new

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

--skip-pager

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

--skip-partition

Section 5.1.2, “Server Command Options”

--skip-plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--skip-quick

Description

--skip-quote-names

Description

--skip-reconnect

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

--skip-routines

Section 6.4.5.3, “Dumping Stored Programs”

--skip-safemalloc

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

--skip-set-charset

Description

--skip-show-database

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

--skip-slave-start

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

--skip-ssl

Section 5.5.6.3, “SSL Command Options”

--skip-stack-trace

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

--skip-super-large-pages

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

--skip-symbolic-links

Section 12.1.10, “CREATE TABLE Syntax”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 5.1.2, “Server Command Options”
Section 7.9.7.3, “Using Symbolic Links for Databases on Windows”
Section 7.9.7.2, “Using Symbolic Links for Tables on Unix”
Section 1.5, “What Is New in MySQL 5.0”

--skip-symlink

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

--skip-sync-bdb-logs

Section 13.5.3, “BDB Startup Options”

--skip-syslog

Description
Section 5.2.1, “The Error Log”

--skip-tee

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

--skip-thread-priority

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

--skip-triggers

Description
Section 6.4.5.3, “Dumping Stored Programs”

--skip-tz-utc

Description

--skip-use-db

Description

--skip-write-binlog

Description
Description

--skip-xxx

Description

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave-load-tmpdir

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

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

--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[={0|1}]

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

--socket=/path/to/socket

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

--socket=file_name

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

--socket=path

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

--sort-index

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

--sort-records=N

Section 4.6.3.4, “Other myisamchk Options”

--sort-records=index_num

Section 6.6.4, “MyISAM Table Optimization”

--sort-recover

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

--sort_buffer_size=16M

Section 4.6.3.6, “myisamchk Memory Usage”

--spassword

Description

--spassword[=password]

Description

--sporadic-binlog-dump-fail

Section 16.1.2.4, “Binary Log Options and Variables”

--sql-bin-update-same

Section 1.5, “What Is New in MySQL 5.0”

--sql-mode

Section 5.1.2, “Server Command Options”

--sql-mode=""

Section 5.1.6, “Server SQL Modes”

--sql-mode="mode_value"

Section 1.8.2, “Selecting SQL Modes”

--sql-mode="modes"

Section 5.1.6, “Server SQL Modes”

--sql-mode=IGNORE_SPACE

Chapter 11, Functions and Operators

--sql-mode=MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”

--sql-mode=NO_UNSIGNED_SUBTRACTION

Section 11.10, “Cast Functions and Operators”

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

Section 5.1.2, “Server Command Options”

--srcdir=path

Description

--ssl

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

--ssl*

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

--ssl-ca

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

--ssl-ca=file_name

Section 5.5.6.3, “SSL Command Options”

--ssl-capath

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

--ssl-capath=directory_name

Section 5.5.6.3, “SSL Command Options”

--ssl-cert

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

--ssl-cert=file_name

Section 5.5.6.3, “SSL Command Options”

--ssl-cipher

Section 16.1.2.3, “Replication Slave Options and Variables”

--ssl-cipher=cipher_list

Section 5.5.6.3, “SSL Command Options”

--ssl-key

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

--ssl-key=file_name

Section 5.5.6.3, “SSL Command Options”

--ssl-verify-server-cert

Section 5.5.6.3, “SSL Command Options”

--ssl-xxx

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

--ssl=0

Section 5.5.6.3, “SSL Command Options”

--standalone

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

--start-datetime

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

--start-datetime=datetime

Description

--start-position

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

--start-position=N

Description

--start_row=N

Description

--statefile=file_name

Description

--static

Section 2.20.3, “Solaris Notes”

--stats

Description

--status

Description

--stop-datetime

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

--stop-datetime=datetime

Description

--stop-never

Description

--stop-never-slave-server-id

Description

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

Description

--stop-position

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

--stop-position=N

Description

--suffix

Description

--suffix=str

Description

--super-large-pages

Section 7.9.8, “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.9.7.3, “Using Symbolic Links for Databases on Windows”
Section 1.5, “What Is New in MySQL 5.0”

--symbols-file=file_name

Description

--sync-bdb-logs

Section 13.5.3, “BDB Startup Options”

--sysdate-is-now

Section 11.7, “Date and Time Functions”
Section 16.4.1.8, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--syslog

Description
Section 5.2.1, “The Error Log”

--syslog-tag=tag

Description
Section 5.2.1, “The Error Log”

--tab

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

--tab=dir_name

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

--tab=path

Description

--table

Section 4.5.1.1, “mysql Options”
Description

--table_cache

Section 7.8.2, “How MySQL Opens and Closes Tables”

--table_open_cache

Section 7.8.2, “How MySQL Opens and Closes Tables”

--tables

Description
Description

--tar

Description

--tbl-status

Description

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

Section 5.1.2, “Server Command Options”

--tcp-ip

Description

--tee

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

--tee=file_name

Section 4.5.1.1, “mysql Options”

--temp-pool

Section 5.1.2, “Server Command Options”

--test

Description

--thread-stack=192K

Section 2.20.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.9.4, “How MySQL Uses Threads for Client Connections”

--thread_handling=pool-of-threads

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

--thread_pool_size=N

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

--thread_stack=N

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

--timezone

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

--timezone=timezone

Description

--timezone=timezone_name

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

--tmp

Description

--tmp_table_size=val

Section B.5.2.12, “The table is full”

--tmpdir

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

--tmpdir=path

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

--to-last-log

Description

--transaction-isolation

Section 13.2.8, “The InnoDB Transaction Model and Locking”

--transaction-isolation=level

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

--triggers

Description
Section 6.4.5.3, “Dumping Stored Programs”

--type=engine_name

Description

--tz-utc

Description

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

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

--update-state

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

--upgrade-system-tables

Description

--use-frm

Description

--use-manager

Description

--use-mysqld_safe

Description

--use-symbolic-links

Section 1.5, “What Is New in MySQL 5.0”

--use-threads=N

Description

--user

Section B.5.2.18, “'File' Not Found and Similar Errors”
Description
Description
Description
Section 6.3, “Example Backup and Recovery Strategy”
Section 2.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.14, “Installing MySQL on i5/OS”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.20.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.20.3, “Solaris Notes”
Section 2.17.1, “Source Installation Overview”
Section 2.18.1, “Unix Post-Installation Procedures”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.3, “Using Option Files”

--user=mysql

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

--user=root

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

--user=user_name

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

--user={user_name|user_id}

Description
Section 5.1.2, “Server Command Options”

--username

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

--username=user_name

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--var_name=value

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

--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
Description
Description
Description
Description
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.18.1.3, “Starting and Troubleshooting the MySQL Server”
Section 7.9.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 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--vertical

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

--wait

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

--wait-timeout=N

Section 4.6.10.1, “MySQL Instance Manager Command Options”

--wait[=count]

Description

--warnings

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

--where='where_condition'

Description

--windows

Description

--with

Section 2.17.2, “Typical configure Options”

--with-archive-storage-engine

Section 13.8, “The ARCHIVE Storage Engine”

--with-berkeley-db

Section 13.5.2, “Installing BDB”

--with-big-tables

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

--with-blackhole-storage-engine

Section 13.10, “The BLACKHOLE Storage Engine”

--with-charset

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

--with-charset=MYSET

Section 9.3, “Adding a New Character Set”

--with-charset=charset_name

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

--with-collation

Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 9.1.3.1, “Server Character Set and Collation”
Section 2.17.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.17.4, “Dealing with Problems Compiling MySQL”
Section 21.4.2, “Debugging a MySQL Client”
Section 7.9.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 5.1.2, “Server Command Options”
Section 2.17.2, “Typical configure Options”
Section B.5.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.9.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 5.1.2, “Server Command Options”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--with-embedded-privilege-control

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

--with-embedded-server

Section 2.17.2, “Typical configure Options”

--with-example-storage-engine

Section 13.6, “The EXAMPLE Storage Engine”

--with-extra-charsets=LIST

Section 2.17.2, “Typical configure Options”

--with-extra-charsets=charset_name

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

--with-extra-charsets=complex

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

--with-federated-storage-engine

Section 13.7, “The FEDERATED Storage Engine”

--with-innodb

Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

--with-libevent

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

--with-low-memory

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

--with-max-indexes=N

Section 13.1, “The MyISAM Storage Engine”

--with-mit-threads

Section 2.20.4.1, “FreeBSD Notes”

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

Section 21.2.2, “Adding a New User-Defined Function”
Section 2.20.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.20.5.6, “Alpha-DEC-OSF/1 Notes”

--with-named-z-libs=no

Section 2.20.3.1, “Solaris 2.7/2.8 Notes”
Section 2.20.3, “Solaris Notes”

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

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

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

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

--with-ndb-shm

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

--with-ndbcluster

Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

--with-openssl

Section 5.5.6.2, “Using SSL Connections”

--with-plugin-PLUGIN

Section 2.17.2, “Typical configure Options”

--with-plugins

Section 2.17.2, “Typical configure Options”

--with-plugins=max

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

--with-plugins=max-no-innodb

Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

--with-plugins=ndbcluster

Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

--with-pstack

Section 5.1.2, “Server Command Options”

--with-raid

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

--with-ssl

Section 5.5.6.2, “Using SSL Connections”

--with-tcp-port

Section 2.17.3, “Installing from the Development Source Tree”

--with-unix-socket-path

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

--with-vio

Section 5.5.6.2, “Using SSL Connections”

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

Section 2.17.2, “Typical configure Options”

--without

Section 2.17.2, “Typical configure Options”

--without-libevent

Section 7.9.4, “How MySQL Uses Threads for Client Connections”
Section 2.17.2, “Typical configure Options”

--without-plugin-PLUGIN

Section 2.17.2, “Typical configure Options”

--without-query-cache

Section 7.6.3, “The MySQL Query Cache”

--without-server

Section 2.17.2, “Typical configure Options”

--write-binlog

Description
Description

--xml

Section 4.5.1.1, “mysql Options”
Description

-0

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

-1

Section 1.8.5.5, “'--' as the Start of a Comment”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 20.8.3.1, “mysql_affected_rows()”
Section 11.3.2, “Comparison Functions and Operators”
Description
Section 11.6.2, “Mathematical Functions”
Section 11.14, “Miscellaneous Functions”
Section 11.5.1, “String Comparison Functions”

-?

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

-A

Section 4.5.1.1, “mysql Options”
Description
Description

-A[value]

Section 4.6.3.4, “Other myisamchk Options”

-B

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

-C

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

-C charset_name

Section 5.1.2, “Server Command Options”

-C path

Description

-D

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

-D db_name

Section 4.5.1.1, “mysql Options”

-D len

Section 4.6.3.3, “myisamchk Repair Options”

-D path

Description

-DBIG_TABLES

Section 2.17.2, “Typical configure Options”

-DUSE_ALARM_THREAD

Section 21.1.1, “MySQL Threads”

-DUSE_SYMDIR

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

-E

Section 4.5.1.1, “mysql Options”
Description
Description

-F

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

-F file_name

Description

-G

Section 4.5.1.1, “mysql Options”

-H

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

-H file_name

Description

-H host_name

Description

-I

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

-I/usr/local/mysql/include

Section 20.8.16, “Building Client Programs”

-K

Description

-L

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

-L/lib

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

-L/usr/lib

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

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

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

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

Section 20.8.16, “Building Client Programs”

-Lpath

Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.3, “Solaris Notes”

-N

Section 4.5.1.1, “mysql Options”
Description

-N file_name

Description

-O

Section 2.20.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.9.3, “Tuning Server Parameters”
Section 1.5, “What Is New in MySQL 5.0”

-O back_log=50

Section 2.20.3, “Solaris Notes”

-O file_name

Description

-O0

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

-O2

Section 2.20.5.3, “IBM-AIX notes”

-O3

Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 7.9.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.20.5.3, “IBM-AIX notes”

-O6

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

-P

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

-P port_num

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

-P[password]

Description

-Q

Description

-R

Description
Description

-R N

Section 4.6.3.4, “Other myisamchk Options”

-R index_num

Section 6.6.4, “MyISAM Table Optimization”

-R record_pos_file record_pos

Description

-RELEASE

Section 2.20.4.1, “FreeBSD Notes”

-S

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

-S file_name

Section 4.2.2, “Connecting to the MySQL Server”
Description

-S path

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

-T

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
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
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-W

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

-W [level]

Section 5.1.2, “Server Command Options”

-Wa,-many

Section 2.20.5.3, “IBM-AIX notes”

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

Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.3, “Solaris Notes”

-X

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

-Xc

Section 2.20.3, “Solaris Notes”

-Y

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

-a

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

-arch generic

Section 2.20.1.7, “Linux Alpha Notes”

-arch generic

Section 2.20.1.7, “Linux Alpha Notes”

-b

Section 4.5.1.1, “mysql Options”
Description
Description
Description

-b path

Section 5.1.2, “Server Command Options”

-b offset

Section 4.6.3.4, “Other myisamchk Options”

-c

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Description
Description
Description
Description

-c N

Description
Description

-c column_list

Description

-c file_name

Description

-d

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

-d YYMMDD

Description

-d db_name

Description
Description

-e

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

-e 1

Description

-e file_name

Description

-e num

Description

-e statement

Section 4.5.1.1, “mysql Options”

-eis

Section 4.6.3.5, “Obtaining Table Information with myisamchk”

-f

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Description
Description
Description
Section 17.2.3, “Initial Startup of MySQL Cluster”

-f N

Description

-fast

Section 2.20.1.7, “Linux Alpha Notes”

-felide-constructors

Section 2.17, “MySQL Installation from a Source Distribution”
Section 2.17.2, “Typical configure Options”

-fno-exceptions

Section 2.20.5.3, “IBM-AIX notes”
Section 2.17, “MySQL Installation from a Source Distribution”
Section 2.17.2, “Typical configure Options”

-fno-inline

Section 2.17.4, “Dealing with Problems Compiling MySQL”

-fno-rtti

Section 2.17, “MySQL Installation from a Source Distribution”
Section 2.17.2, “Typical configure Options”

-fomit-frame-pointer

Section 7.9.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 21.4.1.5, “Using a Stack Trace”

-fomit-frame-pointer -ffixed-ebp

Section 7.9.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.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section 4.2.1, “Invoking MySQL Programs”
Section 1.2, “Typographical and Syntax Conventions”

-h host_name

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

-h localhost

Section 4.2.3.1, “Using Options on the Command Line”

-h path

Section 5.1.2, “Server Command Options”

-hlocalhost

Section 4.2.3.1, “Using Options on the Command Line”

-i

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Description
Description
Description
Section 6.6.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
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 path

Description

-lg++

Section 2.17.4, “Dealing with Problems Compiling MySQL”

-lgcc

Section 2.20.3, “Solaris Notes”

-lgthreads -lsocket -lgthreads

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

-libmysqlclient

Section 20.8.2, “C API Function Overview”

-libmysqld

Section 20.8.2, “C API Function Overview”

-lm

Section 20.8.16.1, “Problems Linking with the C API”

-lmach -lexc

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

-lmysqlclient

Section 20.8.3.39, “mysql_library_end()”
Section 20.8.9, “C API Embedded Server Function Descriptions”

-lmysqlclient -lz

Section 20.8.16, “Building Client Programs”

-lmysqld

Section 20.8.3.39, “mysql_library_end()”
Section 20.8.9, “C API Embedded Server Function Descriptions”

-lpthread

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

-lz

Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.20.3.1, “Solaris 2.7/2.8 Notes”
Section 2.20.3, “Solaris Notes”

-m

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

-m64

Section 2.17, “MySQL Installation from a Source Distribution”
Section 2.20.3, “Solaris Notes”

-mcpu

Section 2.20.3, “Solaris Notes”

-mcpu=v8 -Wa,-xarch=v8plusa

Section 2.20.3, “Solaris Notes”

-mcpu=v8 -Wa,-xarch=v8plusa

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

-mcpu=xxx

Section 2.20.5.3, “IBM-AIX notes”

-mt

Section 2.20.3, “Solaris Notes”

-n

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

-n N

Description

-n file_name

Description

-o

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

-o async

Section 7.9.6, “Disk Issues”

-o N

Description

-o noatime

Section 7.9.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
Section 5.3.2.2, “End-User Guidelines for Password Security”
Section 2.15, “Installing MySQL on NetWare”
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.2.1, “Invoking MySQL Programs”
Section B.5.2.5, “Password Fails When Entered Interactively”
Section 2.18.2, “Securing the Initial MySQL Accounts”
Section 5.5.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”

-p N

Description

-p len

Description

-p num

Description

-p password

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

-pthread

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

-pyour_pass

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

-q

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

-qstrict

Section 2.20.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
Section 6.6.3, “How to Repair MyISAM Tables”
Section 2.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”

-r -q

Section 6.6.3, “How to Repair MyISAM Tables”

-r file_name

Description

-r name

Description

-r path

Section 5.1.2, “Server Command Options”

-rdynamic

Section 21.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.6.2, “How to Check MyISAM Tables for Errors”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

-s at

Description

-s file_name

Description

-s num

Description

-s sort_type

Description

-server

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

-signal

Description

-skip-auto-rehash

Section 4.5.1.1, “mysql Options”

-slow_query_log_file

Section 5.1.2, “Server Command Options”

-ss

Section 4.6.3.1, “myisamchk General Options”

-static

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

-t

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

-t N

Description

-t path

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

-u

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

-u {user_name|user_id}

Section 5.1.2, “Server Command Options”

-u user_name

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
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
Description
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-v -v -v

Section 4.5.1.1, “mysql Options”

-vv

Section 4.6.3.1, “myisamchk General Options”

-vvv

Section 4.6.3.1, “myisamchk General Options”

-w

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

-w 'where_condition'

Description

-w write_file

Description

-w[count]

Description

-x

Description

-y

Description

/3GB

Section D.7.3, “Windows Platform Limitations”

Arbitration

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

ArbitrationDelay

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

ArbitrationRank

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

ArbitrationTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

AutoReconnect

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

BackupDataBufferSize

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

BackupDataDir

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

BackupLogBufferSize

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

BackupMaxWriteSize

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

BackupMemory

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

BackupReportFrequency

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.1.4, “MySQL Cluster Development History”

BackupWriteSize

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

BatchByteSize

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

BatchSize

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

BatchSizePerLocalScan

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

BuildIndexThreads

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

CFLAGS

Section 2.20.3, “Solaris Notes”

Checksum

Section 12.4.5.33, “SHOW TABLE STATUS Syntax”
Section 17.3.2.9, “MySQL Cluster Shared-Memory Connections”
Section 17.3.2.7, “MySQL Cluster TCP/IP Connections”
Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”
Section 19.2, “The INFORMATION_SCHEMA TABLES Table”

Com_dealloc_sql

Section 5.1.5, “Server Status Variables”

Com_delete

Section 5.1.5, “Server Status Variables”

Com_execute_sql

Section 5.1.5, “Server Status Variables”

Com_insert

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

Com_prepare_sql

Section 5.1.5, “Server Status Variables”

Com_select

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

Com_stmt_close

Section 5.1.5, “Server Status Variables”

Com_stmt_execute

Section 5.1.5, “Server Status Variables”

Com_stmt_fetch

Section 5.1.5, “Server Status Variables”

Com_stmt_prepare

Section 5.1.5, “Server Status Variables”

Com_stmt_reprepare

Section 5.1.5, “Server Status Variables”

Com_stmt_reset

Section 5.1.5, “Server Status Variables”

Com_stmt_send_long_data

Section 5.1.5, “Server Status Variables”

CompressedBackup

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

CompressedLCP

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

DataDir

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
Description
Section 17.5.4, “Event Reports Generated in MySQL Cluster”
Section 17.5, “Management of MySQL Cluster”
Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

DataMemory

Section B.5.2.12, “The table is full”
Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”

DictTrace

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

DiskCheckpointSpeed

Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

DiskCheckpointSpeedInRestart

Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

DiskIOThreadPool

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

DiskPageBufferMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

DiskSyncSize

Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

Diskless

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

ExecuteOnComputer

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

FileSystemPath

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

FileSystemPathDD

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

FileSystemPathDataFiles

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

FileSystemPathUndoFiles

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

FragmentLogFileSize

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

HELP

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

HeartbeatIntervalDbApi

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

HeartbeatIntervalDbDb

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

HeartbeatOrder

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

HeartbeatThreadPriority

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

Host1SciId0

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

Host1SciId1

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

Host2SciId0

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

Host2SciId1

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

HostName

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

Id

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 12.4.5.4, “SHOW COLLATION Syntax”
Section 12.4.5.27, “SHOW PROCESSLIST Syntax”
Section 20.8.1, “C API Data Structures”
Section 9.4.2, “Choosing a Collation ID”
Section 17.3.2.3, “Defining Computers in a MySQL Cluster”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
Section 7.10, “Examining Thread Information”
Section 17.3.2.7, “MySQL Cluster TCP/IP Connections”
Section 19.10, “The INFORMATION_SCHEMA COLLATIONS Table”

IndexMemory

Section B.5.2.12, “The table is full”
Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 17.1.4.1, “MySQL Cluster Developement in MySQL 5.0”

InitFragmentLogFiles

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

InitialLogFileGroup

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

InitialNoOfOpenFiles

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

InitialTablespace

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LockExecuteThreadToCPU

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LockMaintThreadsToCPU

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LockPagesInMainMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogDestination

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

LogLevelCheckpoint

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelCongestion

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelConnection

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelError

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelInfo

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelNodeRestart

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelShutdown

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelStartup

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LogLevelStatistic

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

LongMessageBuffer

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxAllocate

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxBufferedEpochs

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxLCPStartDelay

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfAttributes

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentIndexOperations

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentOperations

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

MaxNoOfConcurrentScans

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentSubOperations

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfConcurrentTransactions

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfExecutionThreads

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”

MaxNoOfFiredTriggers

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfLocalOperations

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

MaxNoOfLocalScans

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfOpenFiles

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfOrderedIndexes

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

MaxNoOfSavedMessages

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfSubscribers

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfSubscriptions

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfTables

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

MaxNoOfTriggers

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MaxNoOfUniqueHashIndexes

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

MaxScanBatchSize

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

MaxStartFailRetries

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

MemReportFrequency

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

Name

Section 12.4.5.12, “SHOW ENGINE Syntax”
Section 12.4.5.33, “SHOW TABLE STATUS Syntax”

Ndb_cluster_node_id

Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

NoOfDiskPagesToDiskAfterRestartACC

Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskAfterRestartTUP

Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskDuringRestartACC

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

NoOfDiskPagesToDiskDuringRestartTUP

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

NoOfFragmentLogFiles

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

NoOfReplicas

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”

NodeGroup

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

NodeId1

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

NodeId2

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

ODirect

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

ON

Section 3.3.4.9, “Using More Than one Table”

OverloadLimit

Section 17.3.2.7, “MySQL Cluster TCP/IP Connections”

PortNumber

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

Queries

Section 5.1.5, “Server Status Variables”

Questions

Section 5.1.5, “Server Status Variables”

RealtimeScheduler

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

ReceiveBufferMemory

Section 17.3.2.7, “MySQL Cluster TCP/IP Connections”

RedoBuffer

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

ReservedSendBufferMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

RestartOnErrorInsert

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

SchedulerExecutionTimer

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

SchedulerSpinTimer

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

SendBufferMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.3.2.7, “MySQL Cluster TCP/IP Connections”

SendLimit

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

SendSignalId

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

ServerPort

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

SharedBufferSize

Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”

SharedGlobalMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

ShmKey

Section 17.3.2.9, “MySQL Cluster Shared-Memory Connections”

ShmSize

Section 17.3.2.9, “MySQL Cluster Shared-Memory Connections”

Slave_running

Section 5.1.5, “Server Status Variables”

StartFailRetryDelay

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

StartFailureTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

StartPartialTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Description

StartPartitionedTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Description

StartupStatusReportFrequency

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

StopOnError

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

StringMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TcpBind_INADDR_ANY

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

TimeBetweenEpochs

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TimeBetweenEpochsTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TimeBetweenGlobalCheckpoints

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TimeBetweenInactiveTransactionAbortCheck

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TimeBetweenLocalCheckpoints

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TimeBetweenWatchDogCheck

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TimeBetweenWatchDogCheckInitial

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TotalSendBufferMemory

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

TransactionBufferMemory

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

TransactionDeadlockDetectionTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 16.4.1.22, “Replication Retries and Timeouts”
Section 16.1.2.3, “Replication Slave Options and Variables”

TransactionInactiveTimeout

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 16.4.1.22, “Replication Retries and Timeouts”
Section 16.1.2.3, “Replication Slave Options and Variables”

UndoDataBuffer

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

UndoIndexBuffer

Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”

\G

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

\P

Section 4.5.1.2, “mysql Commands”

\c

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

\q

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

\s

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

\t

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

\w

Section 4.5.1.2, “mysql Commands”

all

Section 7.2.2, “EXPLAIN Output Format”
Section 13.2.3, “InnoDB Startup Options and System Variables”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 2.17.2, “Typical configure Options”

analyze

Section 12.4.2.1, “ANALYZE TABLE Syntax”

ansi

Description

auto_increment_increment

Section 16.1.2.2, “Replication Master Options and Variables”

auto_increment_offset

Section 16.1.2.2, “Replication Master Options and Variables”

automatic_sp_privileges

Section 12.1.16, “DROP PROCEDURE and DROP FUNCTION Syntax”

backup

Section 12.4.2.2, “BACKUP TABLE Syntax”

basedir

Section 2.18.1.2, “Starting and Stopping MySQL Automatically”

c

Section 12.1.4, “ALTER TABLE Syntax”
Section 12.1.10.1, “CREATE TABLE ... SELECT Syntax”
Section 12.1.10, “CREATE TABLE Syntax”
Section 11.15.3, “GROUP BY and HAVING with Hidden Columns”
Description
Section 8.2.1, “Identifier Qualifiers”
Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section 9.1.13.1, “Unicode Character Sets”

character-sets-dir=path

Section 20.8.3.49, “mysql_options()”

character_set_server

Section 11.9.4, “Full-Text Stopwords”

charset

Section 9.1.4, “Connection Character Sets and Collations”

check

Section 12.4.2.3, “CHECK TABLE Syntax”

col

Description
Section 16.1.2.2, “Replication Master Options and Variables”

collation_server

Section 11.9.4, “Full-Text Stopwords”

compress

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

connect

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

connect_timeout

Section 4.5.1.1, “mysql Options”
Description

count

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

csv

Section 2.17.2, “Typical configure Options”

d

Section 12.1.4, “ALTER TABLE Syntax”
Section 7.3.1.7, “LEFT JOIN and RIGHT JOIN Optimization”
Section 11.17.5, “Precision Math Examples”
Section 11.5.2, “Regular Expressions”
Section 21.4.3, “The DBUG Package”
Section 9.1.13.1, “Unicode Character Sets”

daemon

Section 17.3.2.4, “Defining a MySQL Cluster Management Server”

data

Section 20.8.7.25, “mysql_stmt_send_long_data()”
Section 7.9.7.2, “Using Symbolic Links for Tables on Unix”
Section 12.3.7.1, “XA Transaction SQL Syntax”

datadir

Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section D.7.3, “Windows Platform Limitations”

date

Section 11.7, “Date and Time Functions”

db

Section 12.4.1.3, “GRANT Syntax”
Section 12.4.5.27, “SHOW PROCESSLIST Syntax”
Section 20.8.3.3, “mysql_change_user()”
Section 20.8.3.8, “mysql_create_db()”
Section 20.8.3.11, “mysql_drop_db()”
Section 20.8.3.52, “mysql_real_connect()”
Section 20.8.3.60, “mysql_select_db()”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 20.8.1, “C API Data Structures”
Section 5.4.7, “Causes of Access-Denied Errors”
Description
Description
Section 7.10, “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.18.1, “Unix Post-Installation Procedures”

debug

Section 20.8.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.7.1, “BEGIN ... END Compound Statement Syntax”
Section 12.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 18.1, “Defining Stored Programs”

description

Section 12.8.3, “HELP Syntax”

e

Section 20.2.4.8, “Tutorial: Using MySqlScript”

engine_condition_pushdown

Section 5.1.3, “Server System Variables”

event_scheduler

Section 12.4.5.27, “SHOW PROCESSLIST Syntax”

exit

Section 21.4.3, “The DBUG Package”

extended-status

Description

federated

Section 13.7.2, “How to Use FEDERATED Tables”

fields

Section 13.2.13.2.3, “InnoDB Table Monitor Output”

flush-backup-logs

Description

flush-hosts

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

flush-logs

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

flush-privileges

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

flush-status

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

flush-tables

Section 12.4.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.20.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.4, “mysql Server-Side Help”
Section 1.5, “What Is New in MySQL 5.0”

host

Section 12.4.1.3, “GRANT Syntax”
Section 20.8.3.7, “mysql_connect()”
Section 20.8.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”
Description
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.18.1, “Unix Post-Installation Procedures”

idx

Description

init-file

Section 7.6.1.2, “Multiple Key Caches”

initial

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

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_buffer_pool_size

Section 7.6.2, “The InnoDB Buffer Pool”

innodb_file_per_table

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

innodb_support_xa

Section 13.2.3, “InnoDB Startup Options and System Variables”

interactive_timeout

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

key_buffer_size

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”

language

Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

ledir

Description
Description

length

Section 20.8.3.34, “mysql_hex_string()”
Section 20.8.3.53, “mysql_real_escape_string()”
Section 20.8.3.54, “mysql_real_query()”
Section 20.8.7.11, “mysql_stmt_fetch()”
Section 20.8.7.20, “mysql_stmt_prepare()”
Section 20.8.7.25, “mysql_stmt_send_long_data()”
Section 20.8.1, “C API Data Structures”
Section 20.8.5, “C API Prepared Statement Data Structures”

local

Section 5.1.4.1, “Structured System Variables”

local-infile

Section 5.3.5, “Security Issues with LOAD DATA LOCAL”

log

Section 2.17.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.6, “Binary Logging of Stored Programs”
Section 5.1.3, “Server System Variables”
Section 1.5, “What Is New in MySQL 5.0”

master-xxx

Section 16.1.2.3, “Replication Slave Options and Variables”

master_uuid

Section 16.1.2, “Replication and Binary Logging Options and Variables”

max_allowed_packet

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

max_connections

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

max_user_connections

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

multi_range_count

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

myisam_block_size

Section 4.6.3.1, “myisamchk General Options”

myisam_max_extra_sort_file_size

Section 1.5, “What Is New in MySQL 5.0”

myisam_stats_method

Section 4.6.3.1, “myisamchk General Options”

myisamchk

Description

mysql

Section 4.5.1.1, “mysql Options”
Section 4.5.1.4, “mysql Server-Side Help”
Section 12.4.3.1, “CREATE FUNCTION Syntax”
Section 12.4.1.1, “CREATE USER Syntax”
Section B.5.2.4, “Client does not support authentication protocol”
Section 12.4.3.2, “DROP FUNCTION Syntax”
Section 12.4.1.2, “DROP USER Syntax”
Section 12.4.6.2, “FLUSH Syntax”
Section 12.4.1.3, “GRANT Syntax”
Section 12.8.3, “HELP Syntax”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section B.5.2.9, “MySQL server has gone away”
Section 12.4.1.4, “RENAME USER Syntax”
Section 12.4.1.5, “REVOKE Syntax”
Section 12.4.1.6, “SET PASSWORD Syntax”
Section 12.4.5.17, “SHOW GRANTS Syntax”
Section 20.8.3.3, “mysql_change_user()”
Section 20.8.3.5, “mysql_close()”
Section 20.8.3.14, “mysql_errno()”
Section 20.8.3.15, “mysql_error()”
Section 20.8.3.33, “mysql_get_ssl_cipher()”
Section 20.8.3.36, “mysql_init()”
Section 20.8.3.53, “mysql_real_escape_string()”
Section 20.8.3.60, “mysql_select_db()”
Section 20.8.3.67, “mysql_ssl_set()”
Section 20.8.7.10, “mysql_stmt_execute()”
Section 20.8.7.11, “mysql_stmt_fetch()”
Section 20.8.7.25, “mysql_stmt_send_long_data()”
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 12.4.1, “Account Management Statements”
Section 5.5.2, “Adding User Accounts”
Section 5.3.2.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 20.8.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”
Section 9.1.4, “Connection Character Sets and Collations”
Chapter 20, Connectors and APIs
Section 13.2.4.2, “Converting Tables from Other Storage Engines to InnoDB”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Description
Description
Description
Description
Section 7.9.8, “Enabling Large Page Support”
Section 6.3.1, “Establishing a Backup Policy”
Section 5.3.1, “General Security Guidelines”
Section 7.6.3.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.16, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.12, “Installing MySQL from RPM Packages on Linux”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.13, “Installing MySQL on Solaris”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”
Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 20.9, “MySQL PHP API”
Section 9.6, “MySQL Server Time Zone Support”
Section 12.3.5.3, “Other Table-Locking Notes”
Section 4.1, “Overview of MySQL Programs”
Section 5.3.2.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section 16.4.4, “Replication FAQ”
Section 16.4.1.7, “Replication and FLUSH”
Section 16.4.1.17, “Replication and User Privileges”
Section 16.4.1.16, “Replication of the mysql System Database”
Section B.5.4.1.2, “Resetting the Root Password: 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.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 8.2, “Schema Object Names”
Section 2.18.2, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.1.7, “Server-Side Help”
Section 5.5.4, “Setting Account Resource Limits”
Section 2.17.1, “Source Installation Overview”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 2.18.1.3, “Starting and Troubleshooting the MySQL Server”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 9.6.1, “Staying Current with Time Zone Changes”
Section 5.4, “The MySQL Access Privilege System”
Section 2.18.1, “Unix Post-Installation Procedures”
Section 5.5.1, “User Names and Passwords”
Section 13.2.2.2, “Using Raw Devices for the Shared Tablespace”
Section 5.5.6.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 1.5, “What Is New in MySQL 5.0”

mysql-server

Chapter 17, MySQL Cluster

mysql_tableinfo

Description

mysqlaccess

Description

mysqladmin

Section 9.1.4, “Connection Character Sets and Collations”
Description

mysqlbinlog

Description
Section 5.2.3, “The Binary Log”

mysqlcheck

Section 9.1.4, “Connection Character Sets and Collations”
Description

mysqld

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 20.8.2, “C API Function Overview”
Description
Description
Section 13.7.1, “Description of the FEDERATED Storage Engine”
Section 7.9.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.14, “Installing MySQL on i5/OS”
Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
Section 4.6.10.7, “MySQL Instance Manager Commands”
Section 5.1.1, “Server Option and Variable Reference”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 5.2.1, “The Error Log”
Section 16.2.2.2, “The Slave Status Files”
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”

mysqldump

Description

mysqldumpslow

Description

mysqlhotcopy

Description

mysqlimport

Section 9.1.4, “Connection Character Sets and Collations”
Description

mysqlshow

Section 9.1.4, “Connection Character Sets and Collations”
Description

ndb-connectstring

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

ndb_autoincrement_prefetch_sz

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_log_bin

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_log_binlog_index

Section 17.3.4.3, “MySQL Cluster System Variables”

ndb_optimization_delay

Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”

ndb_table_no_logging

Section 17.3.4.3, “MySQL Cluster System Variables”

ndbcluster

Section 17.4.1, “MySQL Server Usage for MySQL Cluster”

ndbd

Description

net_retry_count

Section 16.2.1, “Replication Implementation Details”

net_write_timeout

Section 16.2.1, “Replication Implementation Details”

nice

Description

nonguarded

Description

offset

Section 20.8.3.9, “mysql_data_seek()”
Section 20.8.3.23, “mysql_field_seek()”
Section 20.8.3.58, “mysql_row_seek()”
Section 20.8.7.7, “mysql_stmt_data_seek()”
Section 20.8.7.12, “mysql_stmt_fetch_column()”
Section 20.8.7.23, “mysql_stmt_row_seek()”

old-alter-table

Section 12.1.4, “ALTER TABLE Syntax”

open-files-limit

Section B.5.2.7, “Too many connections”

open_files_limit

Description
Section D.7.3, “Windows Platform Limitations”

optimize

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

performance_schema

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

pid-file

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

ping

Description
Section 16.4.5, “Troubleshooting Replication”

pipe

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

plugin

Section 5.4.2, “Privilege System Grant Tables”

port

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

print

Section 11.5.2, “Regular Expressions”

processlist

Description

prompt

Section 4.5.1.2, “mysql Commands”

purge-backup-logs

Description

query_cache_type

Section 5.1.3, “Server System Variables”

quick

Section 4.2.3.3, “Using Option Files”

quit

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

reconnect

Section B.5.2.9, “MySQL server has gone away”
Section 20.8.3.52, “mysql_real_connect()”
Section 20.8.2, “C API Function Overview”

record_buffer

Section 7.9.5, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 7.9.3, “Tuning Server Parameters”
Section 1.5, “What Is New in MySQL 5.0”

refresh

Description
Section 5.4.1, “Privileges Provided by MySQL”

rehash

Section 4.5.1.1, “mysql Options”

reload

Description
Section 5.4.1, “Privileges Provided by MySQL”

repair

Section 12.4.2.6, “REPAIR TABLE Syntax”

replication-ignore-table

Section 16.4.1.26, “Replication and Views”

resolve_stack_dump

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

resolveip

Section 2.20.1.2, “Linux Binary Distribution Notes”

rows

Section 7.2.2, “EXPLAIN Output Format”

s

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

select_limit

Section 4.5.1.1, “mysql Options”

server-id

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

server-id=3

Section 16.1.2.3, “Replication Slave Options and Variables”

server_id

Section 17.3.4.3, “MySQL Cluster System Variables”

server_uuid

Section 12.4.5.31, “SHOW SLAVE STATUS Syntax”
Section 16.1.2, “Replication and Binary Logging 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.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

shutdown_timeout

Description

skip-networking

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

slave

Section 1.2, “Typographical and Syntax Conventions”

slave_uuid

Section 16.1.2, “Replication and Binary Logging Options and Variables”

slow_query_log

Section 5.1.3, “Server System Variables”

socket

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

sort

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

sort_buffer_size

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

sort_key_blocks

Section 4.6.3.1, “myisamchk General Options”

source

Appendix B, Errors, Error Codes, and Common Problems
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 6.4.2, “Reloading SQL-Format Backups”
Section 3.5, “Using mysql in Batch Mode”

sql-mode=""

Section 5.1.6, “Server SQL Modes”

sql-mode="modes"

Section 5.1.6, “Server SQL Modes”

sql_big_tables

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

sql_log_update

Section 1.5, “What Is New in MySQL 5.0”

sql_low_priority_updates

Section 5.1.3, “Server System Variables”

sql_max_join_size

Section 5.1.3, “Server System Variables”

ssl-ca

Section 16.3.7, “Setting Up Replication Using SSL”

ssl-cert

Section 16.3.7, “Setting Up Replication Using SSL”

ssl-key

Section 16.3.7, “Setting Up Replication Using SSL”

ssl_cipher

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

start-slave

Description

stats_method

Section 4.6.3.1, “myisamchk General Options”

status

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

stop-slave

Description

syslog

Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
Description
Section 17.5.4, “Event Reports Generated in MySQL Cluster”
Section 17.5.4.1, “MySQL Cluster Logging Management Commands”
Section 5.2.1, “The Error Log”

system

Chapter 19, INFORMATION_SCHEMA Tables

tab

Section 11.5.2, “Regular Expressions”

table

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

table_type

Section 1.5, “What Is New in MySQL 5.0”

test

Section 12.2.2, “DELETE Syntax”
Section 13.2.13.2.3, “InnoDB Table Monitor Output”
Section 11.4, “Control Flow Functions”
Section 13.2.4, “Creating and Using InnoDB Tables”
Section 3.3, “Creating and Using a Database”
Description
Description
Section 6.4.5.4, “Dumping Table Definitions and Content Separately”
Section 3.6, “Examples of Common Queries”
Section 8.2.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.18.2, “Securing the Initial MySQL Accounts”
Section 18.2.1, “Stored Routine Syntax”
Section 2.18.1, “Unix Post-Installation Procedures”
Section 4.2.3.1, “Using Options on the Command Line”

timeout

Section 20.8.3.49, “mysql_options()”

type

Section 12.4.3.1, “CREATE FUNCTION Syntax”
Section 7.2.2, “EXPLAIN Output Format”
Section 13.2.13.2.3, “InnoDB Table Monitor Output”
Section 20.8.1, “C API Data Structures”
Section 7.3.1.16, “How to Avoid Table Scans”
Section 7.3.1.4, “Index Merge Optimization”
Section 19.14, “The INFORMATION_SCHEMA ROUTINES Table”

update

Section 7.10.3, “Delayed-Insert Thread States”

use-manager

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

user

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

v

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

variables

Description

version

Section 9.4.4, “Adding a UCA Collation to a Unicode Character Set”
Description

wait_timeout

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

write_buffer_size

Section 4.6.3.1, “myisamchk General Options”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”
Copyright © 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Prev Next
Operator Index Home Privileges Index