Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 5.4 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 5.4 Reference Manual :: Option Index
Section Navigation [Toggle]
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 Partitioning
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 Extending MySQL
- A MySQL 5.4 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
-
- Section 12.1.1, “
ALTER DATABASESyntax” - Section 12.5.1.3, “
GRANTSyntax” - Section 11.8.2, “Boolean Full-Text Searches”
- Section 10.6, “Choosing the Right Type for a Column”
- Section 11.6, “Date and Time Functions”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 8.1.2, “Numbers”
- Section 10.2, “Numeric Types”
- Section 10.1.1, “Overview of Numeric Types”
- Section 11.4.2, “Regular Expressions”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 5.4.3, “Specifying Account Names”
- Section 4.2.3.1, “Using Options on the Command Line”
-# [debug_options]
-# [debug_options]
-# debug_options
-#debug_options
--
--Information
--abort-slave-event-count
--add-drop-database
--add-drop-table
--add-locks
--addtodest
--all
--all-databases
--all-in-1
--all-tablespaces
--allow-keywords
--allow-suspicious-udfs
--allowold
--analyze
--ansi
--auto-generate-sql
--auto-generate-sql-add-autoincrement
--auto-generate-sql-execute-number=N
--auto-generate-sql-guid-primary
--auto-generate-sql-load-type=type
--auto-generate-sql-secondary-indexes=N
--auto-generate-sql-unique-query-number=N
--auto-generate-sql-unique-write-number=N
--auto-generate-sql-write-number
--auto-generate-sql-write-number=N
--auto-repair
--back_log=50
--base64-output
--base64-output=DECODE-ROWS
--base64-output=NEVER
--base64-output[=value]
--basedir
- Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Description
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.4, “Server System Variables”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.10.2, “Typical configure Options”
- Section 2.11.2, “Unix Post-Installation Procedures”
--basedir=path
--batch
--bdb-logdir
--bdb-logdir=file_name
--bdb-no-recover
--bdb-shared-data
--bdb-tmpdir=path
--big-tables
--bind-address=127.0.0.1
--bind-address=IP
--binlog-do-db
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.2.4, “The Binary Log”
--binlog-do-db=db1
--binlog-do-db=db_name
--binlog-do-db=sales
--binlog-format
--binlog-format=MIXED
--binlog-format=ROW
--binlog-format=STATEMENT
--binlog-format=type
--binlog-format={ROW|STATEMENT|MIXED}
--binlog-ignore-db
--binlog-ignore-db=db_name
--binlog-ignore-db=sales
--binlog-row-event-max-size
--binlog-row-event-max-size=N
--block-search=offset
--bootstrap
--brief
--cflags
--character-set-client-handshake
--character-set-filesystem=charset_name
--character-set-server
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.3.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
- Section 9.2, “The Character Set Used for Data and Sorting”
- Section 8.4, “User-Defined Variables”
--character-set-server=charset_name
--character-set-server=latin1
--character-sets-dir
--character-sets-dir=path
--charset=path
--check-only-changed
--check-upgrade
--checkpoint
--checkpoint=db_name.tbl_name
--chroot
--chroot=path
--collation-server
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.3.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
- Section 9.2, “The Character Set Used for Data and Sorting”
--collation-server=collation_name
--collation-server=latin1_swedish_ci
--column-type-info
--columns=column_list
--comments
--commit
--commit=N
--compact
--compatible
--compatible=name
--compatible=oracle
--complete-insert
--compress
--concurrency=N
--config-file
--config-file=file_name
--console
- Section 13.6.13.3, “
InnoDBGeneral Troubleshooting” - Section 13.6.13.2, “
SHOW ENGINE INNODB STATUSand theInnoDBMonitors” - Section 13.6.2.3, “Creating the
InnoDBTablespace” - Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.2, “Server Command Options”
- Section 2.3.9, “Starting the Server for the First Time”
- Section 5.2.2, “The Error Log”
--copy
--core-file
--core-file-size
--core-file-size=1000000
--core-file-size=size
--correct-checksum
--count
--count=N
--create
--create-options
--create-schema=value
--create=value
--csv[=file_name]
--data-file-length=len
--database
--database=db_name
--databases
--datadir
- Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 2.3.7, “Creating an Option File”
- Description
- Description
- Section 5.1.4, “Server System Variables”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.10.2, “Typical configure Options”
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
--datadir=path
--db=db_name
--debug
--debug-check
--debug-info
--debug-sync-timeout=N
--debug-sync-timeout[=N]
--debug="..."
--debug="d,parser_debug"
--debug=+P
--debug=N
--debug=T
--debug=d,general,query
--debug=debug_options
--debug[=debug_options]
--default-character-set
- Section 12.2.6, “
LOAD DATA INFILESyntax” - Section 9.1.4, “Connection Character Sets and Collations”
- Description
- Section 5.1.4, “Server System Variables”
- Section 9.2, “The Character Set Used for Data and Sorting”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
- Section 8.4, “User-Defined Variables”
--default-character-set=charset_name
--default-character-set=utf8
--default-collation=collation_name
--default-storage-engine
--default-storage-engine=type
--default-table-type
--default-table-type=InnoDB
--default-table-type=type
--default-time-zone
--default-time-zone=timezone
--default.key_buffer_size=256K
--defaults-extra-file
--defaults-extra-file=file_name
--defaults-extra-file=path
--defaults-file
- Section 13.6.2, “
InnoDBConfiguration” - Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
- Description
- Section 20.8.3, “Options with the Embedded Server”
- Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.3.11, “Starting MySQL as a Windows Service”
--defaults-file=file_name
--defaults-file=option_file_name
--defaults-group-suffix
--defaults-group-suffix=_other
--defaults-group-suffix=str
--defaults-group-suffix=suffix
--delay-key-write
--delay-key-write-for-all-tables
--delay-key-write=ALL
--delay-key-write=OFF
--delay-key-write[={OFF|ON|ALL}]
--delay_key_write=1
--delay_key_write=ON
--delayed-insert
--delete
--delete-master-logs
--delimiter
--delimiter=str
--demangle
--des-key-file
--des-key-file=file_name
--description
--detach=N
--disable-auto-rehash
--disable-community-features
--disable-debug-sync
--disable-dtrace
--disable-grant-options
--disable-keys
--disable-log-bin
--disable-named-commands
--disable-plugin_name
--disable-profiling
--disable-shared
--disconnect-slave-event-count
--dryrun
--dump
--dump-date
--embedded
--enable-assembler
--enable-community-features
--enable-debug-sync
--enable-dtrace
--enable-local-infile
--enable-locking
--enable-named-pipe
--enable-plugin_name
--enable-profiling
--enable-pstack
--enable-thread-safe-client
--engine-condition-pushdown
--engine=engine_name
--err-log=file_name
--event-scheduler
--event-scheduler=DISABLED
--event-scheduler[=value]
--events
--example
--exe-suffix=suffix
--execute=statement
--exit-info[=flags]
--extend-check
--extended
--extended-insert
--external-locking
--extra-file=file_name
--federated
--fields-enclosed-by=...
--fields-escaped-by=...
--fields-optionally-enclosed-by=...
--fields-terminated-by=...
--fields-xxx
--first-slave
--fix-db-names
--fix-table-names
--flush
--flush-logs
--flush-logs
--flush-privileges
--flush_time=val
--flushlog
--force
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 2.13.1.2, “Linux Binary Distribution Notes”
- Section 21.1.2, “MySQL Test Suite”
- Section 3.5, “Using mysql in Batch Mode”
--force-read
--general-log
--general-log[={0|1}]
--general_log
--general_log[={0|1}]
--general_log_file
--general_log_file=file_name
--header_file=file_name
--help
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Section C.1.5, “Changes in MySQL 5.4.0 (05 April 2009 Beta)”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.1, “Overview of MySQL Programs”
- Section 5.1.2, “Server Command Options”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Chapter 3, Tutorial
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--hex-blob
--host
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.10.5, “MIT-pthreads Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--host=127.0.0.1
--host=host_name
--host=localhost
--howto
--i-am-a-dummy
--ignore
--ignore-builtin-innodb
--ignore-lines=N
--ignore-spaces
--ignore-table=db_name.tbl_name
--in_file=file_name
--include
--info
--information
--init-file
- Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.4, “Server System Variables”
- Section 13.9, “The
MEMORY(HEAP) Storage Engine” - Section 2.10.2, “Typical configure Options”
--init-file=file_name
--init_connect="SET NAMES 'utf8'"
--innodb-autoinc-lock-mode
--innodb-xxx
--innodb[=value]
--innodb_checksums
--innodb_file_per_table
--innodb_locks_unsafe_for_binlog
--innodb_rollback_on_timeout
--innodb_safe_binlog
--innodb_status_file
--innodb_status_file=1
--innodb_support_xa
--insert-ignore
--install
--install-manual
--iterations=N
--join=big_tbl_name
--keep_files_on_create
--keepold
--key_buffer_size=32M
--keys
--keys-used=val
--language
--language=lang_name, -L lang_name
--large-pages
--lc-messages
--lc-messages-dir
--lc-messages-dir=path
--lc-messages=locale_name
--ldata=path
--ledir
--ledir=path
--length
--libmysqld-libs
--libs
--libs_r
--line-numbers
--lines-terminated-by
--lines-terminated-by="\r\n"
--lines-terminated-by=...
--local
--local-infile
--local-infile=0
--local-infile=1
--local-infile[=1]
--local-infile[={0|1}]
--local-load
--local-load=path
--local-service
--lock-all-tables
--lock-directory
--lock-directory=path
--lock-tables
--log
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
- Section 5.1.2, “Server Command Options”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.4, “Server System Variables”
- Section 5.2.3, “The General Query Log”
- Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-bin
- Section 12.6.2.1, “
CHANGE MASTER TOSyntax” - Section 12.6.1.1, “
PURGE BINARY LOGSSyntax” - Section 6.2.1, “Backup Policy”
- Section 6.2.3, “Backup Strategy Summary”
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 18.6, “Binary Logging of Stored Programs”
- Section 6.1, “Database Backup Methods”
- Section 16.3.6, “How to Report Replication Bugs or Problems”
- Section 21.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 6.3, “Point-in-Time Recovery”
- Section 16.3.4, “Replication FAQ”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.1.2, “Server Command Options”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.4, “Server System Variables”
- Section 5.2.4, “The Binary Log”
- Section 5.2.3, “The General Query Log”
- Section 16.3.5, “Troubleshooting Replication”
- Section 16.3.3, “Upgrading a Replication Setup”
- Section 6.2.2, “Using Backups for Recovery”
--log-bin-index[=file_name]
--log-bin-trust-function-creators
--log-bin-trust-function-creators=1
--log-bin-trust-function-creators[={0|1}]
--log-bin-trust-routine-creators
--log-bin-trust-routine-creators=1
--log-bin-trust-routine-creators[={0|1}]
--log-bin=base_name.extension
--log-bin=log_name
--log-bin=old_host_name-bin
--log-bin[=base_name]
--log-bin[=file_name]
--log-error
--log-error my-errors
--log-error=file_name
--log-error[=file_name]
--log-isam=file_name
--log-isam[=file_name]
--log-long-format
--log-output
--log-output=TABLE
--log-output=TABLE,FILE
--log-output[=value,...]
--log-queries-not-using-indexes
--log-short-format
--log-slave-updates
--log-slow-admin-statements
--log-slow-queries
- Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
- Section 5.1.2, “Server Command Options”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.4, “Server System Variables”
- Section 5.2.5, “The Slow Query Log”
- Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-slow-queries[=file_name]
--log-slow-slave-statements
--log-tc-size
--log-tc-size=size
--log-tc=file_name
--log-update
--log-update[=file_name]
--log-warnings
--log-warnings=0
--log-warnings=2
--log-warnings[=level]
--log=file_name
--log[=file_name]
--loose
--loose-opt_name
--loose-skip-innodb
--low-priority
--low-priority-updates
--lower-case-table-names=0
--malloc-lib
--malloc-lib=
--malloc-lib=/path/to/some/library
--malloc-lib=[lib_name]
--malloc-lib=tcmalloc
--master-bind
--master-connect-retry
- Section 12.5.5.35, “
SHOW SLAVE STATUSSyntax” - Section 1.4.1, “What Is New in MySQL 5.4”
- Section 16.3.1.16, “Replication During a Master Shutdown”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4, “Replication Implementation”
- Section 7.5.6.5, “Replication Slave I/O Thread States”
- Section 16.1.3.3, “Replication Slave Options and Variables”
--master-connect-retry=seconds
--master-data
--master-data[=value]
--master-host
--master-host=host_name
--master-info-file
--master-info-file=file_name
--master-password
--master-password
--master-password=password
--master-port
--master-port=port_number
--master-retry-count
--master-retry-count=count
--master-ssl
--master-ssl*
--master-ssl-ca
--master-ssl-ca=file_name
--master-ssl-capath
--master-ssl-capath=directory_name
--master-ssl-cert
--master-ssl-cert=file_name
--master-ssl-cipher
--master-ssl-cipher=cipher_list
--master-ssl-key
--master-ssl-key=file_name
--master-user
--master-user=user_name
--master-xxx
--max-binlog-dump-events
--max-binlog-size
--max-record-length
--max-record-length=len
--max-relay-log-size
--max-relay-log-size=size
--max-seeks-for-key=1000
--max_connect_errors=999999999
--max_join_size
--max_sort_length=N
--maximum-query_cache_size=32M
--maximum-query_cache_size=4M
--maximum-var_name=value
--medium-check
--memlock
--method=command
--min-examined-row-limit=number
--mutex-deadlock-detector
--myisam-block-size
--myisam-block-size=N
--myisam-recover
- Section 13.5.1, “
MyISAMStartup Options” - Section 7.2.25, “Other Optimization Tips”
- Section 5.1.4, “Server System Variables”
- Section 6.4.5, “Setting Up a Table Maintenance Schedule”
- Section B.1.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAMStorage Engine” - Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--myisam-recover=BACKUP,FORCE
--myisam-recover=mode
--myisam-recover[=option[,option]...]]
--mysqladmin=prog_name
--mysqld-version
--mysqld-version=debug
--mysqld-version=max
--mysqld-version=suffix
--mysqld=mysqld_safe
--mysqld=prog_name
--name_file=file_name
--named-commands
--ndb
--ndb-cluster
--ndb-log-empty-epochs
--new
--nice=priority
--no-auto-rehash
--no-autocommit
--no-beep
--no-create-db
--no-create-info
--no-data
--no-debug
--no-defaults
--no-embedded
--no-log
--no-named-commands
--no-pager
--no-set-names
--no-symlinks
--no-tee
--noindices
--number-char-cols=N
--number-int-cols=N
--number-of-queries=N
--numeric-dump-file=file_name
--offset=N
--old-alter-table
--old-passwords
- Section B.1.2.4, “
Client does not support authentication protocol” - Section 5.5.6.3, “Password Hashing in MySQL”
- Section 16.3.1, “Replication Features and Issues”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
--old-protocol
--old-style-user-limits
--old_server
--one-database
--one-thread
--only-debug
--only-print
--open-files-limit
--open-files-limit=count
--opt
--opt_name
--opt_name=value
--optimize
--order-by-primary
--out_dir=path
--out_file=file_name
--packlength=len
--pager[=command]
--parallel-recover
--partition[=value]
--password
- Section 4.5.1.1, “mysql Options”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.5.6.2, “End-User Guidelines for Password Security”
- Section 6.2, “Example Backup and Recovery Strategy”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.1.2.5, “Password Fails When Entered Interactively”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
--password=
--password=pass_val
--password=password
--password=your_pass
--password[=pass_val]
--password[=password]
--pid-file=file_name
--pid-file=path
--pipe
--plan
--plugin-innodb_file_per_table
--plugin-load=plugin_list
--plugin-sql-mode
--plugin-xxx
--plugin_dir=path
--plugin_name
--plugin_name=0
--plugin_name=1
--plugin_name=FORCE
--plugin_name=OFF
--plugin_name=ON
--plugin_name[=ON]
--plugindir
--port
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.2, “Running Multiple Servers on Unix”
- Section 5.1.4, “Server System Variables”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--port-open-timeout=num
--port=port_num
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.2, “Server Command Options”
--port=port_number
--position
--position=N
--post-query=value
--post-system=str
--pre-query=value
--pre-system=str
--prefix
--preserve-schema
--preview
--print-defaults
--prompt
--prompt=format_str
--protocol=MEMORY
--protocol=PIPE
--protocol=SOCKET
--protocol=TCP
--protocol={TCP|SOCKET|PIPE|MEMORY}
--query
--query-cache-size=0
--query=value
--quick
--quiet
--quote-names
--read-from-remote-server
--read-only
--reconnect
--record_log_pos
--record_log_pos=db_name.tbl_name
--recover
--regexp=expr
--regexp=pattern
--relative
--relay-log
--relay-log-index
--relay-log-index=file_name
--relay-log-info-file
--relay-log-info-file=file_name
--relay-log-purge={0|1}
--relay-log-recovery
--relay-log-recovery={0|1}
--relay-log-space-limit
--relay-log-space-limit=size
--relay-log=file_name
--relay-log=myhost-bin
--relnotes
--remove
--repair
--replace
--replicate-*
--replicate-*-db
--replicate-*-do-*
--replicate-*-ignore-*
--replicate-*-table
--replicate-do-db
- Section 12.5.5.35, “
SHOW SLAVE STATUSSyntax” - Section 12.4.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.3.1.21, “Replication and Reserved Words”
- Section 16.3.1.24, “Replication and Temporary Tables”
- Section 5.2.4, “The Binary Log”
--replicate-do-db=db1
--replicate-do-db=db_name
--replicate-do-db=sales
--replicate-do-table
- Section 12.5.5.35, “
SHOW SLAVE STATUSSyntax” - Section 16.4.3.2, “Evaluation of Table-Level Replication Options”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4.3.3, “Replication Rule Application”
- Section 16.3.1.21, “Replication and Reserved Words”
- Section 16.3.1.24, “Replication and Temporary Tables”
--replicate-do-table=db_name.tbl_name
--replicate-ignore-db
- Section 12.5.5.35, “
SHOW SLAVE STATUSSyntax” - Section 12.4.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4.3.3, “Replication Rule Application”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.3.1.21, “Replication and Reserved Words”
- Section 5.2.4, “The Binary Log”
--replicate-ignore-db=db_name
--replicate-ignore-db=sales
--replicate-ignore-table
--replicate-ignore-table=db_name.tbl_name
--replicate-rewrite-db
--replicate-rewrite-db="db1->db3"
--replicate-rewrite-db="db2->db3"
--replicate-rewrite-db=from_name->to_name
--replicate-same-server-id
--replicate-wild-do-table
--replicate-wild-do-table=db_name.%
--replicate-wild-do-table=db_name.tbl_name
--replicate-wild-do-table=foo%.%
--replicate-wild-do-table=foo%.bar%
--replicate-wild-do-table=my\\_own\\%db
--replicate-wild-do-table=my\_own\%db
--replicate-wild-ignore-table
--replicate-wild-ignore-table=db_name.%
--replicate-wild-ignore-table=db_name.tbl_name
--replicate-wild-ignore-table=foo%.bar%
--replicate-wild-ignore-table=mysql.%
--replicate-wild-ignore-table=norep_
--report-host
--report-host=host_name
--report-password
--report-password=password
--report-port
--report-port=slave_port_num
--report-user
--report-user=user_name
--resetmaster
--resetslave
--result-file=file_name
--result-file=name
--rhost=host_name
--rollback
--rows=N
--rpm
--safe-mode
--safe-recover
--safe-show-database
--safe-updates
--safe-user-create
--secure-auth
--secure-file-priv=path
--select_limit
--server-id
--server-id=id
--server-id=value
--service-startup-timeout=file_name
--set-auto-increment[=value]
--set-character-set=name
--set-charset
--set-charset=charset_name
--set-collation
--set-collation=name
--set-variable
--set-variable=option=value
--set-variable=var_name=value
--shared-memory
--shared-memory-base-name
--shared-memory-base-name=name
--short-form
--show-slave-auth-info
--show-table-type
--show-warnings
--sigint-ignore
--silent
--single-transaction
--skip
--skip-add-drop-table
--skip-add-locks
--skip-auto-rehash
--skip-base64-output
--skip-bdb
--skip-character-set-client-handshake
--skip-column-names
--skip-comments
--skip-compact
--skip-concurrent-insert
--skip-delay-key-write
--skip-disable-keys
--skip-dump-date
--skip-engine_name
--skip-event-scheduler
--skip-events
--skip-extended-insert
--skip-external-locking
--skip-grant-tables
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 12.5.3.3, “
INSTALL PLUGINSyntax” - Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
- Description
- Description
- Section 2.11.2.1, “Problems Running mysql_install_db”
- Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.10.2, “Typical configure Options”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 5.4.6, “When Privilege Changes Take Effect”
--skip-host-cache
--skip-innodb
- Section 13.6.2, “
InnoDBConfiguration” - Section 13.6.3, “
InnoDBStartup Options and System Variables” - Section 12.5.5.17, “
SHOW ENGINESSyntax” - Section 16.3.4, “Replication FAQ”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- The mysqld-max Extended MySQL Server
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
--skip-innodb-checksums
--skip-innodb_adaptive_hash_index
--skip-innodb_checksums
--skip-innodb_doublewrite
--skip-kill-mysqld
--skip-line-numbers
--skip-locking
--skip-log-warnings
--skip-merge
--skip-mutex-deadlock-detector
--skip-name-resolve
--skip-named-commands
--skip-networking
- Section B.1.2.2, “
Can't connect to [local] MySQL server” - Section B.1.2.9, “
MySQL server has gone away” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 7.5.11, “How MySQL Uses DNS”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 16.3.3, “Upgrading a Replication Setup”
--skip-new
--skip-pager
--skip-partition
--skip-plugin-innodb_file_per_table
--skip-plugin_name
--skip-quick
--skip-quote-names
--skip-reconnect
--skip-safemalloc
--skip-set-charset
--skip-show-database
--skip-slave-start
- Section 12.6.2.1, “
CHANGE MASTER TOSyntax” - Section 12.6.2.7, “
START SLAVESyntax” - Section 16.1.1, “How to Set Up Replication”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.1.1.8, “Setting Up Replication with Existing Data”
- Section 16.3.5, “Troubleshooting Replication”
- Section 16.3.3, “Upgrading a Replication Setup”
--skip-ssl
--skip-stack-trace
--skip-super-large-pages
--skip-symbolic-links
--skip-symlink
--skip-syslog
--skip-thread-priority
--skip-triggers
--skip-tz-utc
--skip-use-db
--skip-write-binlog
--skip-xxx
--skip_grant_tables
--slave
--slave-load-tmpdir
--slave-load-tmpdir=file_name
--slave-net-timeout
--slave-net-timeout=seconds
--slave-skip-errors
--slave-skip-errors=[err_code1,err_code2,...|all]
--slave_compressed_protocol={0|1}
--sleep
--sleep=delay
--slow-query-log
--slow-query-log[={0|1}]
--slow_query_log
--slow_query_log[={0|1}]
--slow_query_log_file
--slow_query_log_file=file_name
--socket
- Section B.1.2.2, “
Can't connect to [local] MySQL server” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Section B.1.4.5, “How to Protect or Change the MySQL Unix Socket File”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.2, “Running Multiple Servers on Unix”
- Section 2.3.12, “Testing The MySQL Installation”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--socket=/path/to/socket
--socket=file_name
--socket=path
--sort-records=N
--sort-records=index_num
--sort-recover
--sort_buffer_size=16M
--spassword[=password]
--sporadic-binlog-dump-fail
--sql-mode
--sql-mode=""
--sql-mode="mode_value"
--sql-mode="modes"
--sql-mode=IGNORE_SPACE
--sql-mode=MAXDB
--sql-mode=NO_UNSIGNED_SUBTRACTION
--sql-mode=value[,value[,value...]]
--sql_mode="TRADITIONAL,ALLOW_INVALID_DATES"
--srcdir=path
--ssl
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.3.2, “Making MySQL Secure Against Attackers”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.5.7.3, “SSL Command Options”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.5.7.2, “Using SSL Connections”
--ssl*
--ssl-ca
--ssl-ca=file_name
--ssl-capath
--ssl-capath=directory_name
--ssl-cert
--ssl-cert=file_name
--ssl-cipher=cipher_list
--ssl-key
--ssl-key=file_name
--ssl-verify-server-cert
--ssl-xxx
--standalone
--start-datetime
--start-datetime=datetime
--start-position=N
--start_row=N
--statefile=file_name
--static
--stats
--status
--stop-datetime=datetime
--stop-position=N
--suffix=str
--super-large-pages
--superuser=user_name
--symbolic-links
--symbols-file=file_name
--sysdate-is-now
--syslog
--syslog-tag=tag
--tab=path
--table_cache
--table_open_cache
--tables
--tc-heuristic-recover={COMMIT|ROLLBACK}
--tcp-ip
--tee=file_name
--temp-pool
--test
--thread-stack=192K
--thread_cache_size=5'
--thread_handling=no-threads
--thread_stack=N
--timezone
--timezone=timezone
--timezone=timezone_name
--tmp_table_size=val
--tmpdir
--tmpdir=path
--to-last-log
--transaction-isolation
--transaction-isolation=SERIALIZABLE
--transaction-isolation=level
--triggers
--type=engine_name
--tz-utc
--unbuffered
--unpack
--update-state
--upgrade-system-tables
--use-frm
--use-manager
--use-mysqld_safe
--use-threads
--use-threads=N
--user
- Section B.1.2.18, “'
File' Not Found and Similar Errors” - Description
- Description
- Description
- Section 6.2, “Example Backup and Recovery Strategy”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.7, “Installing MySQL on i5/OS”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.13.1.2, “Linux Binary Distribution Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.1.2, “Server Command Options”
- Section 2.13.3, “Solaris Notes”
- Section 2.10.1, “Source Installation Overview”
- Section 2.11.2, “Unix Post-Installation Procedures”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.3, “Using Option Files”
--user=root
--user=user_name
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.3.5, “How to Run MySQL as a Normal User”
--user={user_name|user_id}
--var_name=value
--verbose
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.5.1.4, “Executing SQL Statements from a Text File”
- Section 4.6.3.4, “Other
myisamchkOptions” - Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 2.3.10, “Starting MySQL from the Windows Command Line”
- Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--version
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
--vertical
--wait[=count]
--warnings
--where='where_condition'
--windows
--with-archive-storage-engine
--with-bdb
--with-berkeley-db
--with-big-tables
--with-blackhole-storage-engine
--with-charset
--with-charset=MYSET
--with-charset=charset_name
--with-collation
--with-comment
--with-csv-storage-engine
--with-debug
- Section 21.5.1.1, “Compiling MySQL for Debugging”
- Section 2.10.4, “Dealing with Problems Compiling MySQL”
- Section 21.5.2, “Debugging a MySQL Client”
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
- Section 5.1.2, “Server Command Options”
- Section 2.10.2, “Typical configure Options”
- Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug=full
- Section 21.5.1.1, “Compiling MySQL for Debugging”
- Section 21.5.2, “Debugging a MySQL Client”
- Description
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.9, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
- Section 5.1.2, “Server Command Options”
- Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug[=full]
--with-embedded-privilege-control
--with-embedded-server
--with-example-storage-engine
--with-extra-charsets=LIST
--with-extra-charsets=charset_name
--with-extra-charsets=complex
--with-extra-charsets=list-of-charsets | complex | all | none
--with-federated-storage-engine
--with-innodb
--with-libwrap
--with-low-memory
--with-max-indexes=N
--with-mit-threads
--with-mysqld-ldflags=-all-static
--with-mysqld-ldflags=-rdynamic
--with-named-thread-libs="-lpthread -lmach -lexc -lc"
--with-named-z-libs
--with-named-z-libs=no
--with-ndbcluster
--with-openssl
--with-partition
--with-plugin-PLUGIN
--with-plugins
--with-raid
--with-server-suffix=-max
--with-ssl
--with-ssl=path
--with-tcp-port
--with-unix-socket-path
--with-vio
--with-yassl
--with-zlib-dir=no|bundled|DIR
--without-plugin-PLUGIN
--without-query-cache
--write-binlog
-1
- Section 1.7.5.6, “'
--' as the Start of a Comment” - Section 11.12.1, “
GROUP BY(Aggregate) Functions” - Section 17.2.3, “
HASHPartitioning” - Section 11.2.3, “Comparison Functions and Operators”
- Description
- Section 11.5.2, “Mathematical Functions”
- Section 11.11.4, “Miscellaneous Functions”
- Section 11.4.1, “String Comparison Functions”
- Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”
-?
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-B
-C
-C charset_name
-C path
-D db_name
-D path
-DBIG_TABLES
-DHAVE_rts_threads
-DUSE_ALARM_THREAD
-F
-F file_name
-F str
-H file_name
-H host_name
-I
-I/usr/local/mysql/include
-K
-L
-L/usr/lib/gcc-lib/... -lgcc
-L/usr/local/mysql/lib -lmysqlclient -lz
-N file_name
-O var_name=value
-O back_log=50
-O file_name
-O thread_stack=192K
-O0
-O3
-O6
-P port_num
-P[password]
-Q
-R index_num
-R record_pos_file record_pos
-RELEASE
-S
-S path
-T
-T [flags]
-T path
-U user_name
-V
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-W
-W [level]
-Wa,-many
-Wl,r/full/path/to/libmysqlclient.so
-a
-arch generic
-arch generic
-c
-c column_list
-c file_name
-d
-d db_name
-e
-e engine_name
-e file_name
-e num
-e statement
-f
-f N
-felide-constructors
-fno-exceptions
-fomit-frame-pointer
-fomit-frame-pointer -ffixed-ebp
-g pattern
-g suffix
-h
-h host_name
-h localhost
-i
-i N
-i delay
-i name
-j N
-j big_tbl_name
-k
-l
-l path
-lgthreads -lsocket -lgthreads
-libmysqlclient
-libmysqld
-lmach -lexc
-lmysqlclient
-lmysqlclient -lz
-lmysqld
-lz
-mcpu=v8 -Wa,-xarch=v8plusa
-mcpu=v8 -Wa,-xarch=v8plusa
-mcpu=xxx
-n
-n N
-n file_name
-o
-o async
-o N
-o noatime
-o offset
-o udf_example.so
-p
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Section 3.3.1, “Creating and Selecting a Database”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.5.6.2, “End-User Guidelines for Password Security”
- Section 2.8, “Installing MySQL on NetWare”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.1.2.5, “Password Fails When Entered Interactively”
- Section 2.3.11, “Starting MySQL as a Windows Service”
- Section 2.3.10, “Starting MySQL from the Windows Command Line”
- Section 2.3.12, “Testing The MySQL Installation”
- Section 2.3.14, “Upgrading MySQL on Windows”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 2.11.1, “Windows Post-Installation Procedures”
-p N
-p len
-p num
-p[pass_val]
-p[password]
-ppassword
-q
-q value
-qstrict
-r
-r file_name
-r name
-s
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 6.4.2, “How to Check
MyISAMTables for Errors” - Section 6.4.3, “How to Repair Tables”
- Section 6.4.5, “Setting Up a Table Maintenance Schedule”
-s file_name
-s num
-s sort_type
-signal
-skip-auto-rehash
-slow_query_log_file
-static
-t
-t N
-t path
-u
-u {user_name|user_id}
-u user_name
-v
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.6.3.5, “myisamchk Table Information”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 6.4.2, “How to Check
MyISAMTables for Errors” - Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-v -v -v
-w 'where_condition'
-w write_file
-w[count]
-x
-x N
-y N
Aborted_connects
Checksum
Com_dealloc_sql
Com_delete
Com_execute_sql
Com_insert
Com_prepare_sql
Com_select
Com_stmt_close
Com_stmt_execute
Com_stmt_fetch
Com_stmt_prepare
Com_stmt_reprepare
Com_stmt_reset
Com_stmt_send_long_data
DataMemory
Id
- Section 12.5.5.5, “
SHOW COLLATIONSyntax” - Section 12.5.5.30, “
SHOW PROCESSLISTSyntax” - Section 20.9.1, “C API Data Types”
- Section 9.5.2, “Choosing a Collation ID”
- Section 7.5.6, “Examining Thread Information”
- Section 19.10, “The
INFORMATION_SCHEMA COLLATIONSTable” - Section 19.22, “The
INFORMATION_SCHEMA PROCESSLISTTable”
IndexMemory
Name
- Section 12.5.5.1, “
SHOW AUTHORSSyntax” - Section 12.5.5.7, “
SHOW CONTRIBUTORSSyntax” - Section 12.5.5.16, “
SHOW ENGINESyntax” - Section 12.5.5.19, “
SHOW EVENTSSyntax” - Section 12.5.5.37, “
SHOW TABLE STATUSSyntax” - Section 19.20, “The
INFORMATION_SCHEMA EVENTSTable” - Section 19.17, “The
INFORMATION_SCHEMA PLUGINSTable”
Questions
TransactionDeadlockDetectionTimeout
TransactionInactiveTimeout
\G
\s
\t
all
ansi
basedir
c
compress
connect_timeout
count
d
data
datadir
db
- Section 12.5.1.3, “
GRANTSyntax” - Section 12.5.5.30, “
SHOW PROCESSLISTSyntax” - Section 20.9.3.3, “
mysql_change_user()” - Section 20.9.3.8, “
mysql_create_db()” - Section 20.9.3.11, “
mysql_drop_db()” - Section 20.9.3.52, “
mysql_real_connect()” - Section 20.9.3.60, “
mysql_select_db()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User