Related Documentation Download this Manual
PDF (US Ltr) - 37.2Mb
PDF (A4) - 37.2Mb
PDF (RPM) - 36.9Mb
EPUB - 10.5Mb
HTML Download (TGZ) - 10.3Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Eclipse Doc Plugin (TGZ) - 11.1Mb
Eclipse Doc Plugin (Zip) - 13.3Mb
Man Pages (TGZ) - 203.8Kb
Man Pages (Zip) - 309.1Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  Indexes  /  Option Index

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

Symbols

[index top]

-?

Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 20.4.16, “ndb_print_file — Print NDB Disk Data File Contents”
Section 20.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 5.8.2, “perror — Explain Error Codes”
Section 5.8.3, “replace — A String-Replacement Utility”
Section 5.8.4, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.1.4, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”
Section 5.2.4, “Using Options on the Command Line”

A

[index top]

--auto-generate-sql-add-autoincrement

Section 5.5.9, “mysqlslap — Load Emulation Client”

--auto-generate-sql-secondary-indexes

Section 5.5.9, “mysqlslap — Load Emulation Client”

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

Section 5.5.9, “mysqlslap — Load Emulation Client”

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

Section 5.5.9, “mysqlslap — Load Emulation Client”

--auto-vertical-output

Section 5.5.1.1, “mysql Options”

B

[index top]

C

[index top]

--connection-control-failed-login-attempts

Section 7.5.2.1, “Connection-Control Plugin Installation”

D

[index top]

-D

Section 11.3, “Adding a Character Set”
Section 7.4.2, “Building MySQL with Support for Secure Connections”
Section 20.2.2.4, “Building NDB Cluster from Source on Linux”
Section B.5.2.17, “Can't initialize character set”
Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 20.2.3.2, “Compiling and Installing NDB Cluster from Source on Windows”
Section 27.5.1.1, “Compiling MySQL for Debugging”
Section 26.7.1, “Compiling Programs with libmysqld”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 27.5.2, “Debugging a MySQL Client”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.9.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.5.10, “Managing MySQL Server with systemd”
Section 17.2.2.1, “memcached Command-Line Options”
Section 5.6.3.3, “myisamchk Repair Options”
Section 5.5.1.1, “mysql Options”
Section 20.5.4, “MySQL Server Usage for NDB Cluster”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 20.4.21, “ndb_select_all — Print Rows from an NDB Table”
Chapter 21, Partitioning
Section 24.2.1, “Performance Schema Build Configuration”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 7.1.6, “Security Issues with LOAD DATA LOCAL”
Section 6.1.4, “Server Command Options”
Section 6.1.5, “Server System Variables”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 16.5, “The ARCHIVE Storage Engine”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 16.9, “The EXAMPLE Storage Engine”
Section 16.8, “The FEDERATED Storage Engine”
Section 6.7, “Tracing mysqld Using DTrace”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”
Section 2.1.1, “Which MySQL Version and Distribution to Install”

--debug

Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 27.5.1.1, “Compiling MySQL for Debugging”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 6.1.4, “Server Command Options”
Section 6.1.5, “Server System Variables”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 27.5.3, “The DBUG Package”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”

--defaults-file

Section 5.2.7, “Command-Line Options that Affect Option-File Handling”
Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 15.6.1, “InnoDB Startup Configuration”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.3.1, “myisamchk General Options”
Section 5.5.1.1, “mysql Options”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 26.7.3, “Options with the Embedded Server”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 6.6, “Running Multiple MySQL Instances on One Machine”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.4, “Server Command Options”
Section 6.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 6.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

--disable-named-commands

Section 5.5.1.1, “mysql Options”

E

[index top]

F

[index top]

G

[index top]

H

[index top]

-h

Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 5.2.1, “Invoking MySQL Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.16, “ndb_print_file — Print NDB Disk Data File Contents”
Section 20.4.23, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster ”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 6.1.4, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.2.4, “Using Options on the Command Line”

--help

Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 20.2.3.4, “Installing NDB Cluster Processes as Windows Services”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
Section 20.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 20.4.16, “ndb_print_file — Print NDB Disk Data File Contents”
Section 20.4.23, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster ”
Section 20.4.19, “ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 20.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 5.1, “Overview of MySQL Programs”
Section 5.8.2, “perror — Explain Error Codes”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.8.4, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.1.4, “Server Command Options”
Section 2.10.3, “Testing the Server”
Section 1.3.2, “The Main Features of MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Chapter 4, Tutorial
Section 5.2.6, “Using Option Files”
Section 5.2.4, “Using Options on the Command Line”

--host

Section 6.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 5.2.1, “Invoking MySQL Programs”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 5.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 6.1.4, “Server Command Options”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 1.2, “Typographical and Syntax Conventions”
Section 6.6.4, “Using Client Programs in a Multiple-Server Environment”
Section 5.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 5.2.6, “Using Option Files”
Section 5.2.4, “Using Options on the Command Line”

I

[index top]

--initial

Section 20.5.14.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 20.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 20.5.2, “Commands in the NDB Cluster Management Client”
Section 20.3.3.6, “Defining NDB Cluster Data Nodes”
Section 20.5.15, “Distributed MySQL Privileges for NDB Cluster”
Section 20.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 20.6.3, “Known Issues in NDB Cluster Replication”
Section 20.1.6.10, “Limitations Relating to Multiple NDB Cluster Nodes”
Section 20.3.3, “NDB Cluster Configuration Files”
Section 20.3.2.1, “NDB Cluster Data Node Configuration Parameters”
Section 20.5.13.3, “NDB Cluster Disk Data Storage Requirements”
Section 20.3.2.2, “NDB Cluster Management Node Configuration Parameters”
Section 20.3.2.3, “NDB Cluster SQL Node and API Node Configuration Parameters”
Section 20.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 20.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 20.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 20.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 20.4.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
Section 20.3.2.4, “Other NDB Cluster Configuration Parameters”
Section 20.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
Section 20.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 20.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 20.5.1, “Summary of NDB Cluster Start Phases”

INNODB_PAGE_ATOMIC_REF_COUNT

Section 1.4, “What Is New in MySQL 5.7”

INSTALL_SECURE_FILE_PRIVDIR

Section 6.1.5, “Server System Variables”

J

[index top]

K

[index top]

L

[index top]

--log-queries-not-using-indexes

Section 6.1.4, “Server Command Options”

--log-slow-admin-statements

Section 6.1.4, “Server Command Options”

M

[index top]

--maximum-max_heap_table_size

Section 5.2.5, “Program Option Modifiers”

N

[index top]

O

[index top]

P

[index top]

-p

Section 20.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 7.3.2, “Adding User Accounts”
Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 2.11.2, “Downgrading MySQL”
Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 5.2.1, “Invoking MySQL Programs”
Section 21.2.5, “KEY Partitioning”
Section 17.2.2.1, “memcached Command-Line Options”
Section 5.6.3.3, “myisamchk Repair Options”
Section 5.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.10, “ndb_desc — Describe NDB Tables”
Section 20.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 20.4.21, “ndb_select_all — Print Rows from an NDB Table”
Section 20.4.23, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster ”
Section 20.4.24, “ndb_show_tables — Display List of NDB Tables”
Section B.5.2.5, “Password Fails When Entered Interactively”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 20.5.10.5, “The ndbinfo cluster_operations Table”
Section 20.5.10.31, “The ndbinfo server_operations Table”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 2.11.1, “Upgrading MySQL”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 7.3.1, “User Names and Passwords”
Section 5.2.4, “Using Options on the Command Line”
Section 2.3.7, “Windows Postinstallation Procedures”

--password

Section 7.3.2, “Adding User Accounts”
Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 8.3, “Example Backup and Recovery Strategy”
Section 5.2.1, “Invoking MySQL Programs”
Section 5.5.1.1, “mysql Options”
Section 3.8.2.2, “MySQL Shell Connections”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section B.5.2.5, “Password Fails When Entered Interactively”
Section 7.3.8, “Pluggable Authentication”
Section 7.5.1.10, “The Test Authentication Plugin”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 7.3.1, “User Names and Passwords”
Section 5.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 5.2.4, “Using Options on the Command Line”

--performance-schema-consumer-consumer_name

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

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

Section 24.12, “Performance Schema Command Options”

--performance-schema-consumer-global-instrumentation

Section 24.12, “Performance Schema Command Options”

--performance-schema-consumer-statements-digest

Section 24.12, “Performance Schema Command Options”

--performance-schema-consumer-thread-instrumentation

Section 24.12, “Performance Schema Command Options”

--performance_schema_max_mutex_classes

Section 24.6, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances

Section 24.6, “Performance Schema Status Monitoring”

--plugin-innodb_file_per_table

Section 6.1.4, “Server Command Options”

--port

Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 5.2.1, “Invoking MySQL Programs”
Section 5.5.1.1, “mysql Options”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.7.1, “mysql_config — Display Options for Compiling Clients”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.23, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster ”
Section 6.6, “Running Multiple MySQL Instances on One Machine”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.4, “Server Command Options”
Section 6.1.5, “Server System Variables”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 6.6.4, “Using Client Programs in a Multiple-Server Environment”

Q

[index top]

R

[index top]

S

[index top]

-s

Section 8.6.2, “How to Check MyISAM Tables for Errors”
Section 8.6.3, “How to Repair MyISAM Tables”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 17.2.2.1, “memcached Command-Line Options”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 20.4.23, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster ”
Section 5.8.2, “perror — Explain Error Codes”
Section 5.8.3, “replace — A String-Replacement Utility”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.8.4, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.1.4, “Server Command Options”
Section 8.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--skip-plugin-innodb_file_per_table

Section 6.1.4, “Server Command Options”

--socket

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 5.2.2, “Connecting to the MySQL Server”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 5.2.1, “Invoking MySQL Programs”
Section 5.5.1.1, “mysql Options”
Section 3.8.2.2, “MySQL Shell Connections”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.7.1, “mysql_config — Display Options for Compiling Clients”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 6.6, “Running Multiple MySQL Instances on One Machine”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.4, “Server Command Options”
Section 27.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 6.6.4, “Using Client Programs in a Multiple-Server Environment”

T

[index top]

U

[index top]

-u

Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 2.11.2, “Downgrading MySQL”
Section 5.2.1, “Invoking MySQL Programs”
Section 17.2.2.1, “memcached Command-Line Options”
Section 5.6.3.3, “myisamchk Repair Options”
Section 5.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.10, “ndb_desc — Describe NDB Tables”
Section 20.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 20.4.24, “ndb_show_tables — Display List of NDB Tables”
Section 6.1.4, “Server Command Options”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 2.11.1, “Upgrading MySQL”
Section 7.3.1, “User Names and Passwords”
Section 2.3.7, “Windows Postinstallation Procedures”

--user

Section 5.2.2, “Connecting to the MySQL Server”
Section 3.8.2.2.4, “Connecting using both URI and Individual Parameters”
Section 3.8.2.2.2, “Connecting using Individual Parameters”
Section 8.3, “Example Backup and Recovery Strategy”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 7.1.5, “How to Run MySQL as a Normal User”
Section 2.10.1.2, “Initializing the Data Directory Manually Using mysql_install_db”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 5.2.1, “Invoking MySQL Programs”
Section 7.1.3, “Making MySQL Secure Against Attackers”
Section 5.5.1.3, “mysql Logging”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 5.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 7.3.8, “Pluggable Authentication”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section 6.1.4, “Server Command Options”
Section 2.10.2, “Starting the Server”
Section 7.5.1.9, “The Socket Peer-Credential Authentication Plugin”
Section 7.5.1.10, “The Test Authentication Plugin”
Section 7.3.1, “User Names and Passwords”
Section 5.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 5.2.6, “Using Option Files”

V

[index top]

-V

Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 20.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 5.8.2, “perror — Explain Error Codes”
Section 5.8.3, “replace — A String-Replacement Utility”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.8.4, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.1.4, “Server Command Options”
Section 5.2.4, “Using Options on the Command Line”

-v

Section 7.5.4.3, “Configuring the keyring_okv Oracle Key Vault Plugin”
Section 8.6.2, “How to Check MyISAM Tables for Errors”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 17.2.2.1, “memcached Command-Line Options”
Section 17.2.2.9, “memcached Logs”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7.2, “mysqlbinlog Row Event Display”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.16, “ndb_print_file — Print NDB Disk Data File Contents”
Section 5.6.3.5, “Obtaining Table Information with myisamchk”
Section 5.8.2, “perror — Explain Error Codes”
Section 5.8.3, “replace — A String-Replacement Utility”
Section 6.1.4, “Server Command Options”
Section 5.2.4, “Using Options on the Command Line”

--verbose

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.1.6.4, “Binary Logging Options and Variables”
Section 5.5.1.5, “Executing SQL Statements from a Text File”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7.2, “mysqlbinlog Row Event Display”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
Section 20.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 20.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 5.6.3.4, “Other myisamchk Options”
Section 5.8.2, “perror — Explain Error Codes”
Section 6.1.4, “Server Command Options”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”
Section 5.2.6, “Using Option Files”
Section 5.2.4, “Using Options on the Command Line”

--version

Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.1.1, “mysql Options”
Section 5.7.1, “mysql_config — Display Options for Compiling Clients”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 20.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 20.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 5.8.2, “perror — Explain Error Codes”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 5.8.4, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.1.4, “Server Command Options”
Section 5.2.4, “Using Options on the Command Line”

W

[index top]

WITH_EMBEDDED_SHARED_LIBRARY

Section 1.4, “What Is New in MySQL 5.7”

X

[index top]

Y

[index top]

Z

[index top]


User Comments
Sign Up Login You must be logged in to post a comment.