Option Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

Symbols

[index top]

--

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 4.8.2, “replace — A String-Replacement Utility”

-#

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 5.1.3, “Server Command Options”
Section 23.4.3, “The DBUG Package”

/opt/mysql/server-5.7

Section 2.5.6, “Installing MySQL on Linux Using Debian Packages from Oracle”

-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

-?

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”
Section 4.2.4, “Using Options on the Command Line”

A

[index top]

-A

Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.3.4, “Other myisamchk Options”

-a

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.4, “Other myisamchk Options”
Section 16.6.2, “Using memcached

--abort-slave-event-count

Section 17.1.4.3, “Replication Slave Options and Variables”

--add-drop-database

Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-trigger

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--admin-auth-plugin

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--admin-host

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--admin-require-ssl

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--admin-user

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--admin-xxx

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--all

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

--all-databases

Section 17.1.1.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 9.2.3, “Mapping of Identifiers to File Names”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--all-in-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--all-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-keywords

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-mismatches

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--allow-suspicious-udfs

Section 5.1.3, “Server Command Options”
Section 23.3.2.6, “User-Defined Function Security Precautions”

--analyze

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.3.4, “Other myisamchk Options”

--ansi

Section 1.8, “MySQL Standards Compliance”
Section 5.1.3, “Server Command Options”

--apply-slave-statements

Section 4.5.4, “mysqldump — A Database Backup Program”

--auto-generate-sql

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-add-autoincrement

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-execute-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-guid-primary

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-load-type

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-secondary-indexes

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-unique-query-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-unique-write-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-write-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-rehash

Section 14.13.16.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--auto-repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--auto-vertical-output

Section 4.5.1.1, “mysql Options”

--autocommit

Section 5.1.4, “Server System Variables”

B

[index top]

-B

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 16.6.2, “Using memcached

-b

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached

--back_log

Section 2.6, “Installing MySQL on Solaris and OpenSolaris”

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--base64-output

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.1.3.1, “GTID Concepts”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--basedir

Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 1.4, “What Is New in MySQL 5.7”

basedir

Section 2.3.5.2, “Creating an Option File”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”

--batch

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”

--big-tables

Section 5.1.3, “Server Command Options”

--binary-mode

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--bind-address

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.1.9.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.9.3, “Connecting Using the IPv6 Local Host Address”
Section 5.1.9, “IPv6 Support”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.9.5, “Obtaining an IPv6 Address from a Broker”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--binlog-checksum

Section 17.1.4.4, “Binary Logging Options and Variables”

--binlog-do-db

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-format

Section 5.2.4.1, “Binary Logging Formats”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section A.4, “MySQL 5.7 FAQ: Stored Procedures and Functions”
Section 5.1.3, “Server Command Options”
Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-ignore-db

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-row-event-max-size

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-rows-query-log-events

Section 17.1.4.4, “Binary Logging Options and Variables”

--block-search

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Section 5.1.3, “Server Command Options”

--builddir

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

C

[index top]

-C

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached

-c

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 16.6.2, “Using memcached

--cflags

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--character-set-client-handshake

Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.3, “Server Command Options”
Section 10.1.14.7.1, “The cp932 Character Set”

--character-set-filesystem

Section 5.1.3, “Server Command Options”

--character-set-server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 17.4.1.3, “Replication and Character Sets”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”

--character-sets-dir

Section B.5.2.17, “Can't initialize character set”
Section 10.5, “Character Set Configuration”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.3, “Server Command Options”

--character_set_server

Section 2.8.4, “MySQL Source-Configuration Options”

--charset

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--check

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--check-only-changed

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--check-upgrade

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--chroot

Section 5.1.3, “Server Command Options”

CMAKE_BUILD_TYPE

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS

Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS_build_type

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS_RELWITHDEBINFO

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS

Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS_build_type

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS_RELWITHDEBINFO

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_INSTALL_PREFIX

Section 23.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”

CMAKE_PREFIX_PATH

Section 2.8.4, “MySQL Source-Configuration Options”

--collation-server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 17.4.1.3, “Replication and Character Sets”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”

--collation_server

Section 2.8.4, “MySQL Source-Configuration Options”

--column-names

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

--column-type-info

Section 4.5.1.1, “mysql Options”

--columns

Section 4.5.5, “mysqlimport — A Data Import Program”

--comments

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

--commit

Section 4.5.7, “mysqlslap — Load Emulation Client”

--comp

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--compact

Section 4.5.4, “mysqldump — A Database Backup Program”

--compatible

Section 4.5.4, “mysqldump — A Database Backup Program”

COMPILATION_COMMENT

Section 5.1.4, “Server System Variables”

--complete-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--compr

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--compress

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--concurrency

Section 4.5.7, “mysqlslap — Load Emulation Client”

--config-file

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--connect-expired-password

Section 4.5.1.1, “mysql Options”

--connection-server-id

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--console

Section 14.5.1, “Creating the InnoDB Tablespace”
Section 14.15.2, “Enabling InnoDB Monitors”
Section 14.19, “InnoDB Troubleshooting”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.3, “Server Command Options”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--core-file

Section 23.4.1.4, “Debugging mysqld under gdb”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--core-file-size

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.3, “Server Command Options”

--correct-checksum

Section 4.6.3.3, “myisamchk Repair Options”

--count

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--create

Section 4.5.7, “mysqlslap — Load Emulation Client”

--create-options

Section 4.5.4, “mysqldump — A Database Backup Program”

--create-schema

Section 4.5.7, “mysqlslap — Load Emulation Client”

--cross-bootstrap

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--csv

Section 4.5.7, “mysqlslap — Load Emulation Client”

--cxxflags

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

D

[index top]

-D

Section 10.3, “Adding a Character Set”
Section B.5.2.17, “Can't initialize character set”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 22.7.1, “Compiling Programs with libmysqld”
Section 23.4.2, “Debugging a MySQL Client”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Chapter 18, Partitioning
Section 21.2.1, “Performance Schema Build Configuration”
Section 14.18.3.1, “Prerequisites for the InnoDB memcached Plugin”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 15.5, “The ARCHIVE Storage Engine”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 15.9, “The EXAMPLE Storage Engine”
Section 15.8, “The FEDERATED Storage Engine”
Section 5.4, “Tracing mysqld Using DTrace”
Section 16.6.2, “Using memcached
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
Section 2.1.2, “Which MySQL Version and Distribution to Install”

-d

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.1, “myisamchk General Options”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.4, “Server System Variables”
Section 16.6.2, “Using memcached

--data-file-length

Section 4.6.3.3, “myisamchk Repair Options”

--database

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--databases

Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 17.1.1.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 7.4.5.1, “Making a Copy of a Database”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”

--datadir

Section 2.3.5.2, “Creating an Option File”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.3.1, “Setting Up Multiple Data Directories”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 4.2.6, “Using Option Files”
Section 1.4, “What Is New in MySQL 5.7”

datadir

Section 2.3.5.2, “Creating an Option File”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section 16.4.1, “Setting Up MySQL on an EC2 AMI”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section D.10.6, “Windows Platform Limitations”

--debug

Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 23.4.3, “The DBUG Package”

--debug-check

Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--debug-info

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--debug-sync-timeout

Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--default-auth

Section 22.8.14, “C API Client Plugin Functions”
Section 23.2.4.2.3, “Client Plugin Descriptors”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 6.3.8, “Pluggable Authentication”
Section 6.3.9.1, “The Native Authentication Plugin”
Section 6.3.9.2, “The Old Native Authentication Plugin”
Section 23.2.4.9.3, “Using the Authentication Plugins”

--default-authentication-plugin

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

--default-character-set

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 10.1.4, “Connection Character Sets and Collations”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.4, “Server System Variables”
Section 4.5.1.6.2, “Unicode Support on Windows”
Section 6.3.1, “User Names and Passwords”

--default-storage-engine

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.3, “Server Command Options”
Section 15.1, “Setting the Storage Engine”
Section 14.1.3, “Turning Off InnoDB”

default-storage-engine

Section 15.1, “Setting the Storage Engine”

--default-time-zone

Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.30, “Replication and Time Zones”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--default-tmp-storage-engine

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.3, “Server Command Options”
Section 14.1.3, “Turning Off InnoDB”

--default.key_buffer_size

Section 5.1.5.1, “Structured System Variables”

DEFAULT_CHARSET

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 10.1.3.1, “Server Character Set and Collation”

DEFAULT_COLLATION

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 10.1.3.1, “Server Character Set and Collation”

--defaults

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--defaults-extra-file

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 4.2.6, “Using Option Files”

--defaults-file

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 14.3, “InnoDB Configuration”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 22.7.3, “Options with the Embedded Server”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--defaults-group-suffix

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 2.11, “Environment Variables”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

--delay-key-write

Section 8.10.5, “External Locking”
Section 15.2.1, “MyISAM Startup Options”
Section A.13, “MySQL 5.7 FAQ: Replication”
Section 5.1.3, “Server Command Options”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--delay_key_write

Section 5.1.5, “Using System Variables”

--delete

Section 4.5.5, “mysqlimport — A Data Import Program”

--delete-master-logs

Section 4.5.4, “mysqldump — A Database Backup Program”

--delimiter

Section 4.5.1.1, “mysql Options”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--demangle

Section 23.4.1.5, “Using a Stack Trace”

--des-key-file

Section 12.13, “Encryption and Compression Functions”
Section 13.7.6.3, “FLUSH Syntax”
Section 5.1.3, “Server Command Options”

--description

Section 4.6.3.4, “Other myisamchk Options”

--detach

Section 4.5.7, “mysqlslap — Load Emulation Client”

--disable

Section 4.2.5, “Program Option Modifiers”

--disable-auto-rehash

Section 14.13.16.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 4.5.1.1, “mysql Options”

--disable-innodb

Section 14.1.3, “Turning Off InnoDB”
Section 1.4, “What Is New in MySQL 5.7”

--disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--disable-log-bin

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--disable-ssl

Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--disconnect-slave-event-count

Section 17.1.4.3, “Replication Slave Options and Variables”

--dump

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

--dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--dump-slave

Section 4.5.4, “mysqldump — A Database Backup Program”

E

[index top]

-E

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”

-e

Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 13.2.7, “LOAD XML Syntax”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
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 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 4.2.4, “Using Options on the Command Line”

--embedded

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--enable-64bit

Section 16.6.1, “Installing memcached

--enable-cleartext-plugin

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 6.3.9.6, “The Cleartext Client-Side Authentication Plugin”

--enable-dtrace

Section 16.6.1, “Installing memcached
Section 16.6.2.5, “Using memcached and DTrace”

--enable-memcache

Section 16.6.3.6, “Using MySQL and memcached with PHP”

--enable-named-pipe

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 5.1.3, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”

--enable-plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--enable-threads

Section 16.6.1, “Installing memcached

enabled

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

--end-page

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--enforce-gtid-consistency

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”

--engine

Section 4.5.7, “mysqlslap — Load Emulation Client”

event-scheduler

Section 19.4.2, “Event Scheduler Configuration”

--event-scheduler

Section 19.4.2, “Event Scheduler Configuration”
Section 5.1.3, “Server Command Options”

--events

Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--example

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--exclude-gtids

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--execute

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.2.4, “Using Options on the Command Line”

--executed-gtids-compression-period

Section 17.1.4.5, “Global Transaction ID Options and Variables”

--exit-info

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

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--external-locking

Section 8.10.5, “External Locking”
Section 15.2.1, “MyISAM Startup Options”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 8.11.1, “System Factors and Startup Parameter Tuning”

--extra-file

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--extra-sql-file

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

F

[index top]

-F

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.2, “mysql Commands”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”

-f

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 23.4.1.5, “Using a Stack Trace”
Section 16.6.2, “Using memcached

--fast

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--federated

Section 15.8, “The FEDERATED Storage Engine”

--fields-enclosed-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-escaped-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-optionally-enclosed-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-terminated-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--fields-xxx

Section 4.5.4, “mysqldump — A Database Backup Program”

--fix-db-names

Section 9.2.3, “Mapping of Identifiers to File Names”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 1.4, “What Is New in MySQL 5.7”

--fix-table-names

Section 9.2.3, “Mapping of Identifiers to File Names”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 1.4, “What Is New in MySQL 5.7”

--flush

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

--flush-logs

Section 7.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”
Section 4.5.4, “mysqldump — A Database Backup Program”

--flush-privileges

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”

--flush_time

Section 23.1.1, “MySQL Threads”

--force

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 23.1.2, “The MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-if-open

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--force-read

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

G

[index top]

-G

Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

-g

Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”

--gdb

Section 23.4.1.4, “Debugging mysqld under gdb”
Section 5.1.3, “Server Command Options”

--general-log

Section 5.1.3, “Server Command Options”

--general_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

--general_log_file

Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

--gtid-executed-compression-period

Section 17.1.4.5, “Global Transaction ID Options and Variables”

--gtid-mode

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 2.10.1, “Upgrading MySQL”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

H

[index top]

-H

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

-h

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.1.3, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 16.6.2, “Using memcached
Section 4.2.4, “Using Options on the Command Line”

--header_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--HELP

Section 4.6.3.1, “myisamchk General Options”

--help

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.1, “perror — Explain Error Codes”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 1.3.2, “The Main Features of MySQL”
Section 8.11.2, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”

--hex-blob

Section 4.5.4, “mysqldump — A Database Backup Program”

--hexdump

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--histignore

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.7”

--host

Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.3, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”

host

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.6, “Using Option Files”

--html

Section 4.5.1.1, “mysql Options”

I

[index top]

-I

Section 22.8.4.1, “Building C API Client Programs”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 16.6.5, “memcached FAQ”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 16.6.2, “Using memcached

-i

Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 16.6.2, “Using memcached
Section 23.4.1.3, “Using pdb to create a Windows crashdump”

--i-am-a-dummy

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

--idempotent

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.4.3, “Replication Slave Options and Variables”

--ignore

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-builtin-innodb

Section 14.12, “InnoDB Startup Options and System Variables”

--ignore-db-dir

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

--ignore-error

Section 4.5.4, “mysqldump — A Database Backup Program”

--ignore-lines

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table

Section 17.1.1.5.1, “Creating a Data Snapshot Using mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”

--in_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--include

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--include-gtids

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--include-master-host-port

Section 4.5.4, “mysqldump — A Database Backup Program”

--info

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-command

Section 4.5.1.1, “mysql Options”
Section 17.4.1.27, “Replication of Server-Side Help Tables”

--init-file

Section 21.2.3, “Performance Schema Runtime Configuration”
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 Command Options”
Section 5.1.4, “Server System Variables”
Section 15.3, “The MEMORY Storage Engine”

--init_connect

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

--innodb

Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.1.3, “Turning Off InnoDB”
Section 1.4, “What Is New in MySQL 5.7”

innodb-status-file

Section 14.15.2, “Enabling InnoDB Monitors”

--innodb-status-file

Section 14.12, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.3, “Server Command Options”

--innodb_adaptive_hash_index

Section 14.12, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 14.5.3, “Enabling and Disabling File-Per-Table Mode”
Section 5.1.3, “Server Command Options”

innodb_file_per_table

Section 17.1.1.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 5.1.3, “Server Command Options”

INNODB_PAGE_ATOMIC_REF_COUNT

Section 1.4, “What Is New in MySQL 5.7”

--innodb_rollback_on_timeout

Section 14.19.4, “InnoDB Error Handling”
Section 14.12, “InnoDB Startup Options and System Variables”

--innodb_support_xa

Section 5.2.4, “The Binary Log”

--insecure

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--insert-ignore

Section 4.5.4, “mysqldump — A Database Backup Program”

--install

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--install-manual

Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--iterations

Section 4.5.7, “mysqlslap — Load Emulation Client”

J

[index top]

-j

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--join

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

K

[index top]

-K

Section 4.5.4, “mysqldump — A Database Backup Program”

-k

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 16.6.2, “Using memcached

--keep-my-cnf

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--keep_files_on_create

Section 13.1.14, “CREATE TABLE Syntax”

--key-buffer

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--key-buffer-size

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--key_buffer_size

Section 5.1.3, “Server Command Options”

--keys

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--keys-used

Section 4.6.3.3, “myisamchk Repair Options”

L

[index top]

-L

Section 22.8.4.1, “Building C API Client Programs”
Section 4.5.1.1, “mysql Options”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 2.12.3, “Problems Using the Perl DBI/DBD Interface”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 16.6.2, “Using memcached

-l

Section 22.8.4.1, “Building C API Client Programs”
Section 22.8.13, “C API Embedded Server Function Descriptions”
Section 22.8.6, “C API Function Overview”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.3, “myisamchk Repair Options”
Section 22.8.7.40, “mysql_library_end()”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 16.6.2, “Using memcached

--language

Section 5.1.3, “Server Command Options”

--large-pages

Section 8.11.4.2, “Enabling Large Page Support”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--lc-messages

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.1.3, “Server Command Options”

--lc-messages-dir

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.1.3, “Server Command Options”

--ldata

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--ledir

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--length

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

--libmysqld-libs

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--libs

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--libs_r

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--local

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

--local-infile

Section 13.2.7, “LOAD XML Syntax”
Section 4.5.1.1, “mysql Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

--local-load

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--local-service

Section 5.1.3, “Server Command Options”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--lock-all-tables

Section 4.5.4, “mysqldump — A Database Backup Program”

--lock-tables

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--log

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--log-bin

Section 7.3.3, “Backup Strategy Summary”
Section 19.7, “Binary Logging of Stored Programs”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 7.2, “Database Backup Methods”
Section 7.3.1, “Establishing a Backup Policy”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.4.5, “How to Report Replication Bugs or Problems”
Section B.5.8, “Known Issues in MySQL”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 13.4.1.1, “PURGE BINARY LOGS Syntax”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 17.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”
Section 17.4.4, “Troubleshooting Replication”
Section 17.4.3, “Upgrading a Replication Setup”
Section 7.3.2, “Using Backups for Recovery”

--log-bin-index

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.2.4, “The Binary Log”

--log-bin-trust-function-creators

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

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

Section 17.1.4.4, “Binary Logging Options and Variables”

--log-error

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.2.7, “Server Log Maintenance”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--log-isam

Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.1.3, “Server Command Options”

--log-output

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.2.3, “The General Query Log”
Section 5.2.5, “The Slow Query Log”

--log-queries-not-using-indexes

Section 5.1.3, “Server Command Options”

--log-raw

Section 6.1.2.3, “Passwords and Logging”
Section 5.1.3, “Server Command Options”
Section 5.2.3, “The General Query Log”

--log-short-format

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slave-updates

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.4.5, “How to Report Replication Bugs or Problems”
Section 17.3.5, “Improving Replication Performance”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”

--log-slow-admin-statements

Section 5.1.3, “Server Command Options”

--log-slow-slave-statements

Section 17.1.4.3, “Replication Slave Options and Variables”

--log-tc

Section 5.1.3, “Server Command Options”

--log-tc-size

Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”

--log-warnings

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

--login-file

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--login-path

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.6, “Using Option Files”

--loose

Section 4.2.5, “Program Option Modifiers”

--loose-opt_name

Section 4.2.6, “Using Option Files”

--low-priority

Section 4.5.5, “mysqlimport — A Data Import Program”

--low-priority-updates

Section 8.10.3, “Concurrent Inserts”
Section 13.2.5, “INSERT Syntax”
Section A.13, “MySQL 5.7 FAQ: Replication”
Section 5.1.3, “Server Command Options”
Section 8.10.2, “Table Locking Issues”

--lower-case-table-names

Section 9.2.2, “Identifier Case Sensitivity”

M

[index top]

-M

Section 16.6.2, “Using memcached

-m

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 16.6.2, “Using memcached

--malloc-lib

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--master-connect-retry

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-data

Section 17.1.1.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--master-host

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-info-file

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

--master-info-repository

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.1.6.2, “Setting Up Replication with Existing Data”
Section 17.2.2.2, “Slave Status Logs”

--master-password

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-port

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-retry-count

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”

--master-ssl

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-ca

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-user

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-verify-checksum

Section 17.1.4.4, “Binary Logging Options and Variables”

--max

Section 4.2.8, “Using Options to Set Program Variables”

--max-allowed-packet

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--max-binlog-dump-events

Section 17.1.4.4, “Binary Logging Options and Variables”

--max-binlog-size

Section 17.1.4.3, “Replication Slave Options and Variables”

--max-record-length

Section 4.6.3.3, “myisamchk Repair Options”
Section 13.7.2.5, “REPAIR TABLE Syntax”

--max-relay-log-size

Section 17.1.4.3, “Replication Slave Options and Variables”

--max-seeks-for-key

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

--max_a

Section 4.2.8, “Using Options to Set Program Variables”

--max_join_size

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

--maximum

Section 4.2.5, “Program Option Modifiers”

--maximum-query_cache_size

Section 4.2.5, “Program Option Modifiers”
Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.5, “Using System Variables”

--maximum-var_name

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

--medium-check

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--memlock

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.5.9, “Using Raw Disk Partitions for the Shared Tablespace”

--min-examined-row-limit

Section 5.1.3, “Server Command Options”

--my-plugin

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--my-print-defaults

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”

--my_plugin

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--myisam-block-size

Section 8.9.2.5, “Key Cache Block Size”
Section 5.1.3, “Server Command Options”

--myisam-recover

Section 5.1.3, “Server Command Options”

--myisam-recover-options

Section 15.2.1, “MyISAM Startup Options”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 8.2.5, “Other Optimization Tips”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.5.2.19, “Table-Corruption Issues”
Section 15.2, “The MyISAM Storage Engine”
Section 23.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

--myisam_sort_buffer_size

Section 4.6.3.6, “myisamchk Memory Usage”

MYSQL_MAINTAINER_MODE

Section 2.8.5, “Dealing with Problems Compiling MySQL”

MYSQL_TCP_PORT

Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”

MYSQL_UNIX_ADDR

Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”

--mysqladmin

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--mysqld

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--mysqld-file

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--mysqld-version

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

N

[index top]

-N

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

-n

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 16.6.2, “Using memcached

--name_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Section 4.8.1, “perror — Explain Error Codes”

--net-buffer-length

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

net_retry_count

Section 17.2.1, “Replication Implementation Details”

net_write_timeout

Section 17.2.1, “Replication Implementation Details”

--new

Section 4.2.6, “Using Option Files”

--nice

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--no-auto-rehash

Section 4.5.1.1, “mysql Options”

--no-autocommit

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-beep

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--no-check

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--no-create-db

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-create-info

Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”

--no-data

Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”

--no-defaults

Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

--no-drop

Section 4.5.7, “mysqlslap — Load Emulation Client”

--no-log

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--no-set-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--number-char-cols

Section 4.5.7, “mysqlslap — Load Emulation Client”

--number-int-cols

Section 4.5.7, “mysqlslap — Load Emulation Client”

--number-of-queries

Section 4.5.7, “mysqlslap — Load Emulation Client”

--numeric-dump-file

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

O

[index top]

-O

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.8.4, “MySQL Source-Configuration Options”

-o

Section 22.7.1, “Compiling Programs with libmysqld”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 8.11.3, “Optimizing Disk I/O”

--offset

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--old-alter-table

Section 5.1.3, “Server Command Options”

--old-style-user-limits

Section 5.1.3, “Server Command Options”
Section 6.3.4, “Setting Account Resource Limits”

ON

Section 3.3.4.9, “Using More Than one Table”

--one-database

Section 4.5.1.1, “mysql Options”

--only-print

Section 4.5.7, “mysqlslap — Load Emulation Client”

open-files-limit

Section B.5.2.7, “Too many connections”

--open-files-limit

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.3, “Server Command Options”

--opt

Section 8.5.4, “Bulk Data Loading for InnoDB Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”

--opt_name

Section 4.2.6, “Using Option Files”

--optimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--order-by-primary

Section 4.5.4, “mysqldump — A Database Backup Program”

--out_dir

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--out_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

P

[index top]

-P

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached

-p

Section 6.3.2, “Adding User Accounts”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section B.5.2.5, “Password Fails When Entered Interactively”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 2.3.7, “Upgrading MySQL on Windows”
Section 6.3.1, “User Names and Passwords”
Section 16.6.2, “Using memcached
Section 4.2.4, “Using Options on the Command Line”
Section 2.3.8, “Windows Postinstallation Procedures”

--page

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--page-type-dump

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--page-type-summary

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--pager

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

--parallel-recover

Section 4.6.3.3, “myisamchk Repair Options”

--partition

Section 5.1.3, “Server Command Options”

password

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.6, “Using Option Files”

--password

Section 6.3.2, “Adding User Accounts”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 7.3, “Example Backup and Recovery Strategy”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section B.5.2.5, “Password Fails When Entered Interactively”
Section 6.3.8, “Pluggable Authentication”
Section 6.3.9.8, “The Test Authentication Plugin”
Section 6.3.1, “User Names and Passwords”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.4, “Using Options on the Command Line”

--performance-schema-consumer-consumer_name

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-global-instrumentation

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-statements-digest

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-thread-instrumentation

Section 21.11, “Performance Schema Command Options”

--performance-schema-instrument

Section 21.11, “Performance Schema Command Options”
Section 21.2.2, “Performance Schema Startup Configuration”

--performance-schema-xxx

Section 5.1.3, “Server Command Options”

--performance_schema_max_mutex_classes

Section 21.5, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances

Section 21.5, “Performance Schema Status Monitoring”

pid-file

Section 2.9.1.2, “Starting and Stopping MySQL Automatically”

--pid-file

Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--pipe

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 2.3.5.8, “Testing The MySQL Installation”

--plugin

Section 5.1.3, “Server Command Options”

--plugin-dir

Section 22.8.14, “C API Client Plugin Functions”
Section 23.2.4.2.3, “Client Plugin Descriptors”
Section 4.5.1.1, “mysql Options”
Section 22.8.14.3, “mysql_load_plugin()”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 6.3.8, “Pluggable Authentication”
Section D.9, “Restrictions on Pluggable Authentication”
Section 23.2.4.9.3, “Using the Authentication Plugins”
Section 23.2.4.11.2, “Using Your Own Protocol Trace Plugins”

--plugin-ini

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”

--plugin-innodb_file_per_table

Section 5.1.3, “Server Command Options”

--plugin-load

Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”
Section 6.3.8, “Pluggable Authentication”
Section 23.2.2, “Plugin API Components”
Section 23.2.4.2, “Plugin Data Structures”
Section 5.1.3, “Server Command Options”
Section 23.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 23.2, “The MySQL Plugin API”
Section 23.2.4.9.3, “Using the Authentication Plugins”

--plugin-load-add

Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 5.1.3, “Server Command Options”

--plugin-sql-mode

Section 5.1.3, “Server Command Options”

--plugin-xxx

Section 5.1.3, “Server Command Options”

--plugin_dir

Section 2.8.4, “MySQL Source-Configuration Options”
Section 23.2.2, “Plugin API Components”

--plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”

--plugindir

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--port

Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

--port-open-timeout

Section 5.1.3, “Server Command Options”

--post-query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--post-system

Section 4.5.7, “mysqlslap — Load Emulation Client”

--pre-query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--pre-system

Section 4.5.7, “mysqlslap — Load Emulation Client”

--prefix

Section 16.6.1, “Installing memcached

--print-defaults

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 2.10.1, “Upgrading MySQL”

--prompt

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

--protocol

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 1.3.2, “The Main Features of MySQL”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

Q

[index top]

-Q

Section 4.5.4, “mysqldump — A Database Backup Program”

-q

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--query-cache-size

Section 8.10.5, “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 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section B.5.2.8, “Out of memory”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.6, “Using Option Files”

--quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

R

[index top]

-R

Section 16.6.4.1, “memcached General Statistics”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.3.4, “Other myisamchk Options”
Section 16.6.2, “Using memcached
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

-r

Section 23.3.2, “Adding a New User-Defined Function”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached

--random-password-file

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--random-passwords

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”

--raw

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--read-from-remote-master

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--read-from-remote-server

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--read-only

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

--reconnect

Section 4.5.1.1, “mysql Options”

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

--relative

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--relay-log

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.3.5, “Improving Replication Performance”
Section 17.1.1.7, “Introducing Additional Slaves to an Existing Replication Environment”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

--relay-log-index

Section 17.1.1.7, “Introducing Additional Slaves to an Existing Replication Environment”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

--relay-log-info-file

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

--relay-log-info-repository

Section 14.12, “InnoDB Startup Options and System Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

relay-log-purge

Section 17.1.4.3, “Replication Slave Options and Variables”

--relay-log-purge

Section 17.1.4.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 5.1.12, “The Shutdown Process”

--relay-log-space-limit

Section 17.1.4.3, “Replication Slave Options and Variables”

--remove

Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--replace

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--replicate-*

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”

--replicate-*-db

Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section D.1, “Restrictions on Stored Programs”

--replicate-*-table

Section 17.2.3.3, “Replication Rule Application”

--replicate-do-db

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.3.4, “Replicating Different Databases to Different Slaves”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.2.4, “The Binary Log”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-do-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.15, “Replication and System Functions”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-db

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.15, “Replication and System Functions”
Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.2.4, “The Binary Log”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-rewrite-db

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-same-server-id

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”

--replicate-wild-do-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.3.4, “Replicating Different Databases to Different Slaves”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section D.1, “Restrictions on Stored Programs”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”

--replicate-wild-ignore-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section A.13, “MySQL 5.7 FAQ: Replication”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”

replication-ignore-table

Section 17.4.1.35, “Replication and Views”

--replication-rewrite-db

Section 17.1.4.3, “Replication Slave Options and Variables”

--report-host

Section 17.1.5.1, “Checking Replication Status”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 13.7.5.32, “SHOW SLAVE HOSTS Syntax”

--report-password

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

--report-port

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 13.7.5.32, “SHOW SLAVE HOSTS Syntax”

--report-user

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

--result-file

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--rewrite-db

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 1.4, “What Is New in MySQL 5.7”

--routines

Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--rpm

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

S

[index top]

-S

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.2.1, “Invoking MySQL Programs”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.4, “Other myisamchk Options”

-s

Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 16.6.2, “Using memcached

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

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

--safe-user-create

Section 5.1.3, “Server Command Options”

--secure-auth

Section 6.3.9.3, “Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.3, “Server Command Options”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 1.4, “What Is New in MySQL 5.7”

--secure-file-priv

Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--select_limit

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

server-id

Section 17.1.1.7, “Introducing Additional Slaves to an Existing Replication Environment”
Section 17.1, “Replication Configuration”
Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.1.1, “Setting the Replication Master Configuration”
Section 17.1.1.2, “Setting the Replication Slave Configuration”
Section 17.1.1.6.2, “Setting Up Replication with Existing Data”

--server-id

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 5.1.4, “Server System Variables”
Section 13.7.5.32, “SHOW SLAVE HOSTS Syntax”
Section 17.4.4, “Troubleshooting Replication”

--server-public-key-path

Section 4.5.1.1, “mysql Options”
Section 6.3.9.4, “The SHA-256 Authentication Plugin”

--service-startup-timeout

Section 4.3.3, “mysql.server — MySQL Server Startup Script”

--set-auto-increment

Section 4.6.3.4, “Other myisamchk Options”

--set-character-set

Section 4.6.3.3, “myisamchk Repair Options”

--set-charset

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”

--set-collation

Section 4.6.3.3, “myisamchk Repair Options”

--set-gtid-purged

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--shared-memory

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.3, “Server Command Options”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 1.3.2, “The Main Features of MySQL”

--shared-memory-base-name

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 22.8.7.50, “mysql_options()”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

--short-form

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--show-slave-auth-info

Section 17.1.4.3, “Replication Slave Options and Variables”

--show-table-type

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--show-warnings

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--sigint-ignore

Section 4.5.1.1, “mysql Options”

--silent

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--single-transaction

Section 7.2, “Database Backup Methods”
Section 7.3.1, “Establishing a Backup Policy”
Section 14.16, “InnoDB Backup and Recovery”
Section 4.5.4, “mysqldump — A Database Backup Program”

--skip

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.2.5, “Program Option Modifiers”
Section 5.1.3, “Server Command Options”

--skip-add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-auto-rehash

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

--skip-character-set-client-handshake

Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 10.1.14.7.1, “The cp932 Character Set”

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-concurrent-insert

Section 5.1.3, “Server Command Options”

--skip-database

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--skip-disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-engine_name

Section 13.7.5.15, “SHOW ENGINES Syntax”

--skip-event-scheduler

Section 5.1.3, “Server Command Options”

--skip-events

Section 7.4.5.3, “Dumping Stored Programs”

--skip-extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-external-locking

Section 8.10.5, “External Locking”
Section 8.12.5.2, “General Thread States”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 8.11.1, “System Factors and Startup Parameter Tuning”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--skip-federated

Section 17.3.2, “Using Replication with Different Master and Slave Storage Engines”

--skip-grant

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--skip-grant-tables

Section 6.2.7, “Causes of Access-Denied Errors”
Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 19.4.2, “Event Scheduler Configuration”
Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.3.8, “Pluggable Authentication”
Section 2.9.1.1, “Problems Running mysql_install_db”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.3, “Server Command Options”
Section 4.2.3, “Specifying Program Options”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 4.2.4, “Using Options on the Command Line”
Section 1.4, “What Is New in MySQL 5.7”
Section 6.2.6, “When Privilege Changes Take Effect”

--skip-gtids

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”

--skip-host-cache

Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--skip-innodb

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section A.13, “MySQL 5.7 FAQ: Replication”
Section 5.1.3, “Server Command Options”
Section 14.1.3, “Turning Off InnoDB”
Section 1.4, “What Is New in MySQL 5.7”

--skip-innodb-checksums

Section 14.12, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 14.12, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 14.12, “InnoDB Startup Options and System Variables”

--skip-kill-mysqld

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-lock-tables

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-name-resolve

Section 6.2.7, “Causes of Access-Denied Errors”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.3.5.8, “Testing The MySQL Installation”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-networking

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section B.5.2.9, “MySQL server has gone away”
Section 6.3.8, “Pluggable Authentication”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 17.4.3, “Upgrading a Replication Setup”

skip-networking

Section A.13, “MySQL 5.7 FAQ: Replication”
Section 17.1.1.1, “Setting the Replication Master Configuration”
Section 17.4.4, “Troubleshooting Replication”

--skip-new

Section 23.4.1, “Debugging a MySQL Server”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 5.1.4, “Server System Variables”

--skip-opt

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-partition

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

--skip-plugin-innodb_file_per_table

Section 5.1.3, “Server Command Options”

--skip-plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--skip-quick

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-random-passwords

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--skip-reconnect

Section 22.8.16, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.6.5, “Disabling mysql Auto-Reconnect”
Section 4.5.1.1, “mysql Options”

--skip-routines

Section 7.4.5.3, “Dumping Stored Programs”

--skip-secure-auth

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 1.4, “What Is New in MySQL 5.7”

--skip-set-charset

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-show-database

Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server Command Options”
Section 13.7.5.13, “SHOW DATABASES Syntax”
Section 1.9.5, “Supporters of MySQL”

--skip-slave-start

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 17.3.7, “Setting Up Replication Using SSL”
Section 17.1.1.6.2, “Setting Up Replication with Existing Data”
Section 13.4.2.6, “START SLAVE Syntax”
Section 17.4.4, “Troubleshooting Replication”
Section 17.4.3, “Upgrading a Replication Setup”

--skip-ssl

Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--skip-stack-trace

Section 23.4.1.4, “Debugging mysqld under gdb”
Section 5.1.3, “Server Command Options”

--skip-super-large-pages

Section 8.11.4.2, “Enabling Large Page Support”
Section 5.1.3, “Server Command Options”

--skip-symbolic-links

Section 13.1.14, “CREATE TABLE Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 8.11.3.1.2, “Using Symbolic Links for MyISAM Tables on Unix”

--skip-syslog

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.2.2, “The Error Log”

--skip-triggers

Section 7.4.5.3, “Dumping Stored Programs”
Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-version-check

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--skip-warn

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

--skip-write-binlog

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 11.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

--skip_grant_tables

Section 4.2.4, “Using Options on the Command Line”

--slave-checkpoint-group

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-checkpoint-period

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-load-tmpdir

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section B.5.4.4, “Where MySQL Stores Temporary Files”

slave-max-allowed-packet

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-max-allowed-packet

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-parallel-type

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-parallel-workers

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-pending-jobs-size-max

Section 17.1.4.3, “Replication Slave Options and Variables”

slave-rows-search-algorithms

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-skip-errors

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.4.1.26, “Slave Errors During Replication”

--slave-sql-verify-checksum

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”

--slave_compressed_protocol

Section 17.1.4.3, “Replication Slave Options and Variables”

--sleep

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--slow-query-log

Section 5.1.3, “Server Command Options”

--slow-start-timeout

Section 5.1.3, “Server Command Options”

--slow_query_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

--slow_query_log_file

Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.2.5, “The Slow Query Log”

--socket

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 23.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

--sort-index

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

--sort-records

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

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

--sporadic-binlog-dump-fail

Section 17.1.4.4, “Binary Logging Options and Variables”

--sql-mode

Chapter 12, Functions and Operators
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 5.1.7, “Server SQL Modes”

sql-mode

Section 5.1.7, “Server SQL Modes”

--srcdir

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--ssl

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl*

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

--ssl-ca

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl-capath

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.4, “SSL Command Options”

--ssl-cert

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl-cipher

Section 6.3.11.4, “SSL Command Options”

--ssl-crl

Section 6.3.11.4, “SSL Command Options”

--ssl-crlpath

Section 6.3.11.4, “SSL Command Options”

--ssl-key

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl-verify-server-cert

Section 6.3.11.4, “SSL Command Options”

--ssl-xxx

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 6.3.11.2, “Configuring MySQL for SSL”
Section 5.1.4, “Server System Variables”
Section 6.3.11.4, “SSL Command Options”

--standalone

Section 23.4.1.2, “Creating Trace Files”
Section 5.1.3, “Server Command Options”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”

--start-datetime

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--start-page

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--start-position

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”

--statefile

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--stats

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

--status

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--stop-datetime

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--stop-never

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-never-slave-server-id

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-position

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”

--strict-check

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--super-large-pages

Section 8.11.4.2, “Enabling Large Page Support”
Section 5.1.3, “Server Command Options”

--symbolic-links

Section 5.1.3, “Server Command Options”

--symbols-file

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

SYSCONFDIR

Section 4.2.6, “Using Option Files”

--sysdate-is-now

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 12.7, “Date and Time Functions”
Section 17.4.1.15, “Replication and System Functions”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--syslog

Section 2.11, “Environment Variables”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.2.2, “The Error Log”
Section 1.4, “What Is New in MySQL 5.7”

--syslog-tag

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.2.2, “The Error Log”

T

[index top]

-T

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

-t

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached

--tab

Section 7.1, “Backup and Recovery Types”
Section 7.2, “Database Backup Methods”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4, “Using mysqldump for Backups”

--table

Section 4.5.1.1, “mysql Options”

--tables

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”

--tc-heuristic-recover

Section 5.1.3, “Server Command Options”

--tcp-ip

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--tee

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

--temp-pool

Section 5.1.3, “Server Command Options”

--test

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

Text

Section 1.2, “Typographical and Syntax Conventions”

--thread_cache_size

Section 23.4.1.4, “Debugging mysqld under gdb”

--thread_stack

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

--timezone

Section 10.6, “MySQL Server Time Zone Support”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 17.4.1.30, “Replication and Time Zones”
Section 5.1.4, “Server System Variables”
Section B.5.4.6, “Time Zone Problems”

tmpdir

Section 2.3, “Installing MySQL on Microsoft Windows”

--tmpdir

Section B.5.2.13, “Can't create/write to file”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.7”
Section B.5.4.4, “Where MySQL Stores Temporary Files”

--to-last-log

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--transaction-isolation

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 14.2.2, “The InnoDB Transaction Model and Locking”

--transaction-read-only

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”

--triggers

Section 7.4.5.3, “Dumping Stored Programs”
Section 4.5.4, “mysqldump — A Database Backup Program”

--tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”

U

[index top]

-U

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 16.6.2, “Using memcached

-u

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 6.3.1, “User Names and Passwords”
Section 16.6.2, “Using memcached
Section 2.3.8, “Windows Postinstallation Procedures”

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

Section 15.2.3, “MyISAM Table Storage Formats”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--update-state

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

--upgrade-system-tables

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--use-default

Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”

--use-frm

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--use-mysqld_safe

Section 4.3.3, “mysql.server — MySQL Server Startup Script”

--use-threads

Section 4.5.5, “mysqlimport — A Data Import Program”

--user

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 7.3, “Example Backup and Recovery Strategy”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 4.2.1, “Invoking MySQL Programs”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 6.3.8, “Pluggable Authentication”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 5.1.3, “Server Command Options”
Section 6.3.9.7, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.9.8, “The Test Authentication Plugin”
Section 6.3.1, “User Names and Passwords”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.6, “Using Option Files”

user

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.6, “Using Option Files”

V

[index top]

-V

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 4.2.4, “Using Options on the Command Line”

-v

Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 16.6.2.8, “memcached Logs”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached
Section 4.2.4, “Using Options on the Command Line”

--validate-password

Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

--var_name

Section 14.12, “InnoDB Startup Options and System Variables”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.3, “Server Command Options”

--verbose

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.4, “Other myisamchk Options”
Section 4.8.1, “perror — Explain Error Codes”
Section 5.1.3, “Server Command Options”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 8.11.2, “Tuning Server Parameters”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”

--verify-binlog-checksum

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--version

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 4.2.4, “Using Options on the Command Line”

--version-check

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--vertical

Section 1.7, “How to Report Bugs or Problems”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

W

[index top]

-W

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

-w

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”

--wait

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--warn

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

--where

Section 4.5.4, “mysqldump — A Database Backup Program”

--windows

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--with-libevent

Section 16.6.1, “Installing memcached

WITH_BOOST

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_CLIENT_PROTOCOL_TRACING

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_DEBUG

Section 2.8.4, “MySQL Source-Configuration Options”
Section 13.7.5.14, “SHOW ENGINE Syntax”

WITH_EDITLINE

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_LIBEDIT

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_PERFSCHEMA_STORAGE_ENGINE

Section 21.2.1, “Performance Schema Build Configuration”

WITH_TEST_TRACE_PLUGIN

Section 2.8.4, “MySQL Source-Configuration Options”
Section 23.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 23.2.4.11.2, “Using Your Own Protocol Trace Plugins”

WITH_ZLIB

Section 2.8.4, “MySQL Source-Configuration Options”

--write

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--write-binlog

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

X

[index top]

-X

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

-x

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--xml

Section 13.2.7, “LOAD XML Syntax”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 12.11, “XML Functions”

Y

[index top]

-Y

Section 4.5.4, “mysqldump — A Database Backup Program”

-y

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”