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.0 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 MySQL Cluster
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 Extending MySQL
- A MySQL 5.0 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.3, “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
--angel-pid-file
--angel-pid-file=file_name
--ansi
--auto-repair
--back_log=50
--base64-output
--base64-output[=value]
--basedir
- Section 2.16.6.2, “Building MySQL from a Windows Source Distribution”
- Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
- Description
- Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.3, “Server System Variables”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.16.6.4, “Testing a Windows Source Build”
- Section 2.16.2, “Typical configure Options”
- Section 2.17.2, “Unix Post-Installation Procedures”
--basedir=path
--batch
--bdb-home=path
--bdb-lock-detect=method
--bdb-logdir
--bdb-logdir=file_name
--bdb-no-recover
--bdb-no-sync
--bdb-tmpdir=path
--big-tables
--bind-address
--bind-address=127.0.0.1
--bind-address=IP
--binlog-do-db
- Section 16.1.2.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 5.2.3, “The Binary Log”
--binlog-do-db=db1
--binlog-do-db=db_name
--binlog-do-db=sales
--binlog-format
--binlog-format={ROW|STATEMENT|MIXED}
--binlog-ignore-db
--binlog-ignore-db=db_name
--binlog-ignore-db=sales
--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-password-file
--check-upgrade
--checkpoint
--checkpoint=db_name.tbl_name
--chroot
--chroot=path
--clean-password-file
--clear
--clear-only
--col
--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
--compact
--compatible
--compatible=name
--compatible=oracle
--complete-insert
--compress
--config-file
--config-file=file_name
--config-file=path_name
--connect-string
--console
- Section 13.2.13.3, “
InnoDBGeneral Troubleshooting” - Section 13.2.13.2, “
SHOW ENGINE INNODB STATUSand theInnoDBMonitors” - Section 13.2.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.9.9, “Starting the Server for the First Time”
- Section 5.2.1, “The Error Log”
--copy
--core-file
--core-file-size
--core-file-size=1000000
--core-file-size=size
--correct-checksum
--count
--count=N
--create-options
--daemon
--data-file-length=len
--database
--database=db_name
--databases
--datadir
- Section 13.5.3, “
BDBStartup Options” - Section 2.16.6.2, “Building MySQL from a Windows Source Distribution”
- Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
- Section 2.9.7, “Creating an Option File”
- Description
- Description
- Section 5.1.3, “Server System Variables”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.16.6.4, “Testing a Windows Source Build”
- Section 2.16.2, “Typical configure Options”
- Section 2.17.2, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
--datadir=path
--date=YYMMDD
--db=db_name
--debug
- Section 21.4.1.1, “Compiling MySQL for Debugging”
- Description
- Description
- Description
- Description
- Section 5.1.3, “Server System Variables”
- Section 2.9.10, “Starting MySQL from the Windows Command Line”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 21.4.3, “The DBUG Package”
--debug-check
--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.3, “Server System Variables”
- Section 9.2, “The Character Set Used for Data and Sorting”
- Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
- Section 8.4, “User-Defined Variables”
--default-character-set=charset_name
--default-character-set=utf8
--default-collation=collation_name
--default-mysqld-path=/usr/sbin/mysqld
--default-mysqld-path=path
--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.2.2, “
InnoDBConfiguration” - Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 4.6.10.7, “MySQL Instance Manager Commands”
- Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
- Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.9.11, “Starting MySQL as a Windows Service”
- Section 2.9.4.1, “Starting the MySQL Server Instance Configuration Wizard”
- The Location of the my.ini File
--defaults-file=file_name
--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=str
--demangle
--des-key-file
--des-key-file=file_name
--description
--dirname
--disable-auto-rehash
--disable-community-features
--disable-debug-sync
--disable-dtrace
--disable-grant-options
--disable-keys
--disable-log-bin
--disable-named-commands
--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-profiling
--enable-pstack
--enable-thread-safe-client
--engine-condition-pushdown
--err-log=file_name
--event-scheduler
--event-scheduler=DISABLED
--event-scheduler[=value]
--events
--example
--exe-suffix=suffix
--execute
--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.19.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”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.1.2, “Server Command Options”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Chapter 3, Tutorial
- Section 2.17.2, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--hex-blob
--hexdump
--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.16.5, “MIT-pthreads Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--host=127.0.0.1
--host=host_name
--host=localhost
--howto
--i-am-a-dummy
--idx
--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.16.6.1, “Building MySQL from the Standard Source Distribution”
- Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section B.1.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.3, “Server System Variables”
- Section 13.4, “The
MEMORY(HEAP) Storage Engine” - Section 2.16.2, “Typical configure Options”
--init-file=file_name
--init_connect="SET NAMES 'utf8'"
--initial
- Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
- Description
- MySQL 4.1 FAQ — MySQL Cluster
- Section 17.2.6.2, “MySQL Cluster 5.0 Upgrade and Downgrade Compatibility”
- Section 17.3.2, “MySQL Cluster Configuration Files”
- Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
- Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
- Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
- Section 17.5.1, “Summary of MySQL Cluster Start Phases”
--initial-start
--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
--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-tables
--log
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.4.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.1.2, “Server Command Options”
- Section 5.2.5, “Server Log Maintenance”
- Section 5.1.3, “Server System Variables”
- Section 5.2.2, “The General Query Log”
- Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-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.2.4, “Binary Log Options and Variables”
- Section 18.5, “Binary Logging of Stored Programs”
- Section C.1, “Changes in Release 5.0.x (Production)”
- Section 6.1, “Database Backup Methods”
- Section 16.3.6, “How to Report Replication Bugs or Problems”
- Section 21.4.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 6.3, “Point-in-Time Recovery”
- Section 16.3.4, “Replication FAQ”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 5.1.2, “Server Command Options”
- Section 5.2.5, “Server Log Maintenance”
- Section 5.1.3, “Server System Variables”
- Section 5.2.3, “The Binary Log”
- Section 5.2.2, “The General Query Log”
- Section 16.3.5, “Troubleshooting Replication”
- Section 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[=value,...]
--log-queries-not-using-indexes
--log-short-format
--log-slave-updates
--log-slow-admin-statements
--log-slow-queries
--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]
--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.31, “
SHOW SLAVE STATUSSyntax” - Section 1.4.1, “What Is New in MySQL 5.0”
- Section 16.3.1.13, “Replication During a Master Shutdown”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4, “Replication Implementation Overview”
- Section 7.5.6.5, “Replication Slave I/O Thread States”
- Section 16.1.2.3, “Replication Slave Options and Variables”
--master-connect-retry=seconds
--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
--monitoring-interval=seconds
--mutex-deadlock-detector
--myisam-block-size
--myisam-block-size=N
--myisam-recover
- Section 13.1.1, “
MyISAMStartup Options” - Section 7.2.22, “Other Optimization Tips”
- Section 5.1.3, “Server System Variables”
- Section 6.4.5, “Setting Up a Table Maintenance Schedule”
- Section B.1.2.19, “Table-Corruption Issues”
- Section 13.1, “The
MyISAMStorage Engine” - Section 21.4.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-safe-compatible
--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-batch-size=#
--ndb-cluster
--ndb-cluster-connection-pool
--ndb-cluster-connection-pool=#
--ndb-cluster-connection-pool=4
--ndb-connectstring
--ndb-connectstring=connect_string
--ndb-log-empty-epochs
--ndb-nodeid=#
--ndb_optimized_node_selection
--ndbcluster
- Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
- Section 12.5.5.13, “
SHOW ENGINESSyntax” - MySQL 4.1 FAQ — MySQL Cluster
- Section 17.3, “MySQL Cluster Configuration”
- Section 17.1.1, “MySQL Cluster Core Concepts”
- Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
- The mysqld-max Extended MySQL Server
--ndbcluster --ndb-connectstring=management_host
--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
--nodaemon
--noindices
--nostart
--nowait-nodes
--nowait-nodes=3
--nowait-nodes=3,5
--nowait-nodes=node_id_1[, node_id_2[, ...]]
--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.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
--old-protocol
--old-style-user-limits
--old_server
--one-database
--one-thread
--only-debug
--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]
--passwd
--password
- Section 4.5.1.1, “mysql Options”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 5.5.6.2, “End-User Guidelines for Password Security”
- Section 6.2, “Example Backup and Recovery Strategy”
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section B.1.2.5, “Password Fails When Entered Interactively”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
--password-file=file_name
--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-load=plugin_list
--plugin-sql-mode
--plugin-xxx
--plugin_name=0
--plugin_name=1
--plugin_name=OFF
--plugin_name=ON
--plugindir
--plugins=max-no-innodb
--port
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.2, “Running Multiple Servers on Unix”
- Section 5.1.3, “Server System Variables”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--port-open-timeout=num
--port=port_num
- Section 4.5.1.1, “mysql Options”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.2, “Server Command Options”
--port=port_number
--position
--position=N
--prefix
--prefix=prefix_str
--preview
--print-defaults
--print-password-line
--printerror=1
--prompt
--prompt=format_str
--protocol=MEMORY
--protocol=PIPE
--protocol=SOCKET
--protocol=TCP
--protocol={TCP|SOCKET|PIPE|MEMORY}
--query-cache-size=0
--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.31, “
SHOW SLAVE STATUSSyntax” - Section 12.4.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.2.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 16.3.1.17, “Replication and Reserved Words”
- Section 16.3.1.20, “Replication and Temporary Tables”
- Section 5.2.3, “The Binary Log”
--replicate-do-db=db1
--replicate-do-db=db_name
--replicate-do-db=sales
--replicate-do-table
- Section 12.5.5.31, “
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.17, “Replication and Reserved Words”
- Section 16.3.1.20, “Replication and Temporary Tables”
--replicate-do-table=db_name.tbl_name
--replicate-ignore-db
- Section 12.5.5.31, “
SHOW SLAVE STATUSSyntax” - Section 12.4.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.2.4, “Binary Log Options and Variables”
- Section 16.4.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.4.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.4.3.3, “Replication Rule Application”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 16.3.1.17, “Replication and Reserved Words”
- Section 5.2.3, “The Binary Log”
--replicate-ignore-db=db_name
--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
--routines
--rows=N
--rpm
--run-as-service
--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-extended-insert
--skip-external-locking
--skip-grant-tables
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 2.16.6.1, “Building MySQL from the Standard Source Distribution”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
- Description
- Description
- Section 2.18.2.1, “Downgrading to MySQL 4.1”
- Section 2.17.2.1, “Problems Running mysql_install_db”
- Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.16.2, “Typical configure Options”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 5.4.6, “When Privilege Changes Take Effect”
--skip-host-cache
--skip-innodb
- Section 13.2.2, “
InnoDBConfiguration” - Section 13.2.3, “
InnoDBStartup Options and System Variables” - Section 12.5.5.13, “
SHOW ENGINESSyntax” - Section 16.3.4, “Replication FAQ”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- The mysqld-max Extended MySQL Server
- Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
--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-ndbcluster
--skip-networking
- Section B.1.2.2, “
Can't connect to [local] MySQL server” - Section B.1.2.9, “
MySQL server has gone away” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 7.5.11, “How MySQL Uses DNS”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 16.3.3, “Upgrading a Replication Setup”
--skip-new
--skip-pager
--skip-partition
--skip-plugin-innodb_file_per_table
--skip-quick
--skip-quote-names
--skip-reconnect
--skip-routines
--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.2.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-sync-bdb-logs
--skip-syslog
--skip-thread-priority
--skip-triggers
--skip-tz-utc
--skip-use-db
--skip-write-binlog
--skip-xxx
--skip_grant_tables
--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.9.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
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.2, “Server Command Options”
--sort-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
- Section 5.3.2, “Making MySQL Secure Against Attackers”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 5.5.7.3, “SSL Command Options”
- Section 5.3.3, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.5.7.2, “Using SSL Connections”
--ssl*
--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
--suffix=str
--super-large-pages
--superuser=user_name
--symbolic-links
--symbols-file=file_name
--sync-bdb-logs
--sysdate-is-now
--syslog
--syslog-tag=tag
--tab=path
--table_cache
--table_open_cache
--tables
--tar
--tbl-status
--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
--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=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.15, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.13, “Installing MySQL on i5/OS”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.19.1.2, “Linux Binary Distribution Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.1.2, “Server Command Options”
- Section 2.19.3, “Solaris Notes”
- Section 2.16.1, “Source Installation Overview”
- Section 2.17.2, “Unix Post-Installation Procedures”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.3, “Using Option Files”
--user=mysql
--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
- Description
- Section 5.3.5, “How to Run MySQL as a Normal User”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
--user={user_name|user_id}
--username
--username=user_name
--var_name=value
--verbose
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.5.1.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.3, “Server System Variables”
- Section 2.9.10, “Starting MySQL from the Windows Command Line”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--version
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
--vertical
--wait-timeout=N
--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.4.1.1, “Compiling MySQL for Debugging”
- Section 2.16.4, “Dealing with Problems Compiling MySQL”
- Section 21.4.2, “Debugging a MySQL Client”
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.15, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 5.1.2, “Server Command Options”
- Section 2.16.2, “Typical configure Options”
- Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug=full
- Section 21.4.1.1, “Compiling MySQL for Debugging”
- Section 21.4.2, “Debugging a MySQL Client”
- Description
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.15, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 5.1.2, “Server Command Options”
- Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
--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-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=no
--with-ndb-sci=/opt/DIS
--with-ndb-sci=/your/path/to/SCI
--with-ndb-shm
--with-ndbcluster
--with-openssl
--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.11.1, “
GROUP BY(Aggregate) Functions” - Section 11.2.3, “Comparison Functions and Operators”
- Description
- Section 11.5.2, “Mathematical Functions”
- Section 11.10.4, “Miscellaneous Functions”
- Section 11.4.1, “String Comparison Functions”
- Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
-?
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-B
-C
-C charset_name
-C path
-D db_name
-D path
-DBIG_TABLES
-DHAVE_rts_threads
-DUSE_ALARM_THREAD
-F
-F file_name
-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
-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
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-W
-W [level]
-Wa,-many
-Wl,r/full/path/to/libmysqlclient.so
-a
-arch generic
-arch generic
-c
-c N
-c column_list
-c file_name
-d
-d YYMMDD
-d db_name
-e
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.6.3.3, “myisamchk Repair Options”
- Description
- Description
- Section 6.4.2, “How to Check
MyISAMTables for Errors” - MySQL 4.1 FAQ — MySQL Cluster
- Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
-e 1
-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
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.5.1.1, “mysql Options”
- Section 17.5.2, “Commands in the MySQL Cluster Management Client”
- Description
- Description
- Description
- Description
- Description
- Section 6.4.2, “How to Check
MyISAMTables for Errors” - Section 21.4.1.3, “Using
pdbto create a Windows crashdump”
-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
- Section 5.5.6.2, “End-User Guidelines for Password Security”
- Section 2.14, “Installing MySQL on NetWare”
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.1.2.5, “Password Fails When Entered Interactively”
- Section 2.9.11, “Starting MySQL as a Windows Service”
- Section 2.9.10, “Starting MySQL from the Windows Command Line”
- Section 2.9.12, “Testing The MySQL Installation”
- Section 2.9.14, “Upgrading MySQL on Windows”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 2.17.1, “Windows Post-Installation Procedures”
-p N
-p len
-p num
-p[pass_val]
-p[password]
-ppassword
-q
-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
- 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
- Section 4.6.3.3, “myisamchk Repair Options”
- Description
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.9.12, “Testing The MySQL Installation”
- Section 5.5.1, “User Names and Passwords”
- Section 2.17.1, “Windows Post-Installation Procedures”
-u {user_name|user_id}
-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”
- 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
Aborted_connects
Arbitration
ArbitrationDelay
ArbitrationRank
ArbitrationTimeout
BackupDataBufferSize
BackupDataDir
BackupLogBufferSize
BackupMaxWriteSize
BackupMemory
BackupReportFrequency
BackupWriteSize
BatchSizePerLocalScan
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
CompressedBackup
CompressedLCP
DataDir
- Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
- Description
- Section 17.5.4, “Event Reports Generated in MySQL Cluster”
- Section 17.5, “Management of MySQL Cluster”
- Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
- Section 17.3.1, “Quick Test Setup of MySQL Cluster”
- Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
DataMemory
- Section B.1.2.12, “
The table is full” - Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
- Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
- Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
- MySQL 4.1 FAQ — MySQL Cluster
- Section 17.3.2.1, “MySQL Cluster Configuration — Basic Example”
DiskCheckpointSpeed
DiskCheckpointSpeedInRestart
DiskIOThreadPool
DiskPageBufferMemory
DiskSyncSize
ExecuteOnComputer
FileSystemPath
FileSystemPathDD
FileSystemPathDataFiles
FileSystemPathUndoFiles
FragmentLogFileSize
HeartbeatIntervalDbApi
HeartbeatIntervalDbDb
HostName
- Section 17.3.2.3, “Defining Computers in a MySQL Cluster”
- Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
- Section 17.2, “MySQL Cluster Multi-Computer How-To”
- Section 17.5.8.1, “MySQL Cluster Security and Networking Issues”
- Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Id
- Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
- Section 12.5.5.4, “
SHOW COLLATIONSyntax” - Section 12.5.5.27, “
SHOW PROCESSLISTSyntax” - Section 20.8.1, “C API Data Types”
- Section 9.5.2, “Choosing a Collation ID”
- Section 17.3.2.3, “Defining Computers in a MySQL Cluster”
- Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
- Section 7.5.6, “Examining Thread Information”
- Section 17.3.2.7, “MySQL Cluster TCP/IP Connections”
- Section 19.10, “The
INFORMATION_SCHEMA COLLATIONSTable”
IndexMemory
- Section B.1.2.12, “
The table is full” - Section 17.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
- Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
- Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
- MySQL 4.1 FAQ — MySQL Cluster
- Section 17.1.4.1, “MySQL Cluster Changes in MySQL 5.0”
InitFragmentLogFiles
InitialLogFileGroup
InitialNoOfOpenFiles
InitialTablespace
LockExecuteThreadToCPU
LockMaintThreadsToCPU
LockPagesInMainMemory
LogDestination
LogLevelCheckpoint
LogLevelCongestion
LogLevelConnection
LogLevelError
LogLevelNodeRestart
LogLevelShutdown
LogLevelStartup
LogLevelStatistic
LongMessageBuffer
MaxBufferedEpochs
MaxLCPStartDelay
MaxNoOfAttributes
MaxNoOfConcurrentIndexOperations
MaxNoOfConcurrentOperations
MaxNoOfConcurrentScans
MaxNoOfConcurrentSubOperations
MaxNoOfConcurrentTransactions
MaxNoOfExecutionThreads
MaxNoOfFiredTriggers
MaxNoOfLocalOperations
MaxNoOfLocalScans
MaxNoOfOpenFiles
MaxNoOfOrderedIndexes
MaxNoOfSavedMessages
MaxNoOfSubscribers
MaxNoOfSubscriptions
MaxNoOfTables
MaxNoOfTriggers
MaxNoOfUniqueHashIndexes
MemReportFrequency
Ndb_cluster_node_id
NoOfDiskPagesToDiskAfterRestartACC
NoOfDiskPagesToDiskAfterRestartTUP
NoOfDiskPagesToDiskDuringRestartACC
NoOfDiskPagesToDiskDuringRestartTUP
NoOfFragmentLogFiles
NoOfReplicas
NodeId1
NodeId2
OverloadLimit
PortNumber
Questions
RealtimeScheduler
ReceiveBufferMemory
ReservedSendBufferMemory
RestartOnErrorInsert
SchedulerExecutionTimer
SchedulerSpinTimer
SendBufferMemory
SendSignalId
SharedBufferSize
SharedGlobalMemory
StartFailureTimeout
StartPartialTimeout
StartPartitionedTimeout
StartupStatusReportFrequency
TcpBind_INADDR_ANY
TimeBetweenEpochs
TimeBetweenEpochsTimeout
TimeBetweenGlobalCheckpoints
TimeBetweenInactiveTransactionAbortCheck
TimeBetweenLocalCheckpoints
TimeBetweenWatchDogCheck
TimeBetweenWatchDogCheckInitial
TotalSendBufferMemory
TransactionBufferMemory
TransactionDeadlockDetectionTimeout
TransactionInactiveTimeout
UndoDataBuffer
UndoIndexBuffer
\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.27, “
SHOW PROCESSLISTSyntax” - Section 20.8.3.3, “
mysql_change_user()” - Section 20.8.3.8, “
mysql_create_db()” - Section 20.8.3.11, “
mysql_drop_db()” - Section 20.8.3.52, “
mysql_real_connect()” - Section 20.8.3.60, “
mysql_select_db()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 20.8.1, “C API Data Types”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 2.18.5, “Copying MySQL Databases to Another Machine”
- Description
- Description
- Section 7.5.6, “Examining Thread Information”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 19.14, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 2.17.2, “Unix Post-Installation Procedures”
decode_bits
default-storage-engine
default-table-type
defaults-extra-file
delimiter
description
extended-status
flush-hosts
flush-logs
flush-privileges
flush-status
flush-tables
flush-threads
forcedirectio
ft_max_word_len
ft_min_word_len
ft_stopword_file
general_log
have_partition_engine
have_profiling
help
host
- Section 12.5.1.3, “
GRANTSyntax” - Section 20.8.3.7, “
mysql_connect()” - Section 20.8.3.52, “
mysql_real_connect()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 13.2.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.18.5, “Copying MySQL Databases to Another Machine”
- Description
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 2.17.2, “Unix Post-Installation Procedures”
idx
init-file
innodb_file_per_table
innodb_safe_binlog
innodb_status_file=1
innodb_support_xa
innodb_table_locks
key_buffer_size
ledir
length
- Section 20.8.3.34, “
mysql_hex_string()” - Section 20.8.3.53, “
mysql_real_escape_string()” - Section 20.8.3.54, “
mysql_real_query()” - Section 20.8.7.11, “
mysql_stmt_fetch()” - Section 20.8.7.20, “
mysql_stmt_prepare()” - Section 20.8.7.25, “
mysql_stmt_send_long_data()” - Section 20.8.1, “C API Data Types”
- Section 20.8.5, “C API Prepared Statement Data types”
log_bin_trust_routine_creators
max_allowed_packet
multi_range_count
myisam_block_size
myisam_stats_method
mysql
- Section 4.5.1.1, “mysql Options”
- Section 4.5.1.3, “mysql Server-Side Help”
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 12.5.1.1, “
CREATE USERSyntax” - Section B.1.2.4, “
Client does not support authentication protocol” - Section 12.5.3.2, “
DROP FUNCTIONSyntax” - Section 12.5.1.2, “
DROP USERSyntax” - Section 12.5.6.2, “
FLUSHSyntax” - Section 12.5.1.3, “
GRANTSyntax” - Section 12.3.3, “
HELPSyntax” - Section 12.6.2.2, “
LOAD DATA FROM MASTERSyntax” - Section B.1.2.9, “
MySQL server has gone away” - Section 12.5.1.4, “
RENAME USERSyntax” - Section 12.5.1.5, “
REVOKESyntax” - Section 12.5.1.6, “
SET PASSWORDSyntax” - Section 12.5.5.17, “
SHOW GRANTSSyntax” - Section 20.8.3.3, “
mysql_change_user()” - Section 20.8.3.5, “
mysql_close()” - Section 20.8.3.14, “
mysql_errno()” - Section 20.8.3.15, “
mysql_error()” - Section 20.8.3.33, “
mysql_get_ssl_cipher()” - Section 20.8.3.36, “
mysql_init()” - Section 20.8.3.53, “
mysql_real_escape_string()” - Section 20.8.3.60, “
mysql_select_db()” - Section 20.8.3.67, “
mysql_ssl_set()” - Section 20.8.7.10, “
mysql_stmt_execute()” - Section 20.8.7.11, “
mysql_stmt_fetch()” - Section 20.8.7.25, “
mysql_stmt_send_long_data()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 12.5.1, “Account Management Statements”
- Section 5.5.2, “Adding User Accounts”
- Section 5.5.6.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 6.2.1, “Backup Policy”
- Section 20.8.14, “C API Prepared Statement Handling of Date and Time Values”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
- Section 9.1.4, “Connection Character Sets and Collations”
- Chapter 20, Connectors and APIs
- Section 13.2.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.18.5, “Copying MySQL Databases to Another Machine”
- Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
- Section 3.3, “Creating and Using a Database”
- Section 8.2, “Schema Object Names”
- Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Description
- Description
- Description
- Description
- Section 2.18.2, “Downgrading MySQL”
- Section 7.5.9, “Enabling Large Page Support”
- Section 5.3.1, “General Security Guidelines”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 16.1.1, “How to Set Up Replication”
- Section 13.7.2, “How to Use
FEDERATEDTables” - Section 2.15, “Installing MySQL from
tar.gzPackages on Other Unix-Like Systems” - Section 2.10, “Installing MySQL from RPM Packages on Linux”
- Section 2.11, “Installing MySQL on Mac OS X”
- Section 2.12, “Installing MySQL on Solaris”
- Section 5.5.4, “Limiting Account Resources”
- Section 5.3.2, “Making MySQL Secure Against Attackers”
- Section 1.4.1, “What Is New in MySQL 5.0”
- Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
- Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”
- Section 17.5.8.3, “MySQL Cluster and MySQL Security Procedures”
- Section 20.9, “MySQL PHP API”
- Section 9.7, “MySQL Server Time Zone Support”
- Section 12.4.5.3, “Other Table-Locking Notes”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.5.6.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 2.17.2.1, “Problems Running mysql_install_db”
- Section 16.3.1, “Replication Features and Issues”
- Section 16.3.1.7, “Replication and
FLUSH” - Section 16.3.1.25, “Replication and User Privileges”
- Section 16.3.1.15, “Replication of the System
mysqlDatabase” - Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 13.2.14, “Restrictions on
InnoDBTables” - Section D.6, “Restrictions on Character Sets”
- Section D.1, “Restrictions on Stored Routines and Triggers”
- Section 2.19.5.9, “SCO OpenServer 6.0.x Notes”
- Section 2.17.3, “Securing the Initial MySQL Accounts”
- Section 5.1.2, “Server Command Options”
- Section 5.1.8, “Server-Side Help”
- Section 2.16.1, “Source Installation Overview”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
- Section 2.17.2.3, “Starting and Troubleshooting the MySQL Server”
- Section 12.4.3, “Statements That Cause an Implicit Commit”
- Section 9.7.1, “Staying Current with Time Zone Changes”
- Section 5.4, “The MySQL Access Privilege System”
- Section 2.9.13, “Troubleshooting a MySQL Installation Under Windows”
- Section 2.17.2, “Unix Post-Installation Procedures”
- Section 2.18.1, “Upgrading MySQL”
- Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 13.2.2.2, “Using Raw Devices for the Shared Tablespace”
- Section 5.5.7.2, “Using SSL Connections”
- Section 21.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 18.2, “Using Stored Routines (Procedures and Functions)”
- Section 2.17.1, “Windows Post-Installation Procedures”
mysql_tableinfo
mysqlaccess
mysqlbinlog
mysqld
- Section B.1.2.2, “
Can't connect to [local] MySQL server” - Section 20.8.2, “C API Function Overview”
- Description
- Description
- Section 13.7.1, “Description of the
FEDERATEDStorage Engine” - Section 2.13, “Installing MySQL on i5/OS”
- Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
- Section 4.6.10.7, “MySQL Instance Manager Commands”
- Section 16.4.2, “Replication Relay and Status Files”
- Section 5.1.1, “Server Option and Variable Reference”
- Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
- Section 5.2.1, “The Error Log”
- Section 21.4.1.3, “Using
pdbto create a Windows crashdump”
mysqld-path=path-to-mysqld-binary
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
ndb-connectstring
ndb_optimization_delay
net_retry_count
net_write_timeout
nice
nonguarded
offset
old-alter-table
open-files-limit
open_files_limit
p
password
pid-file
pipe
plugin-load
port
processlist
read_buffer_size
reconnect
record_buffer
replication-ignore-table
resolve_stack_dump
select_limit
server-id
- Section 16.1.1, “How to Set Up Replication”
- Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
- Section 16.1.2.2, “Replication Master Options and Variables”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 16.1.1.8, “Setting Up Replication with Existing Data”
- Section 16.1.1.2, “Setting the Replication Master Configuration”
- Section 16.1.1.3, “Setting the Replication Slave Configuration”
set-variable
set-variable=option=value
shutdown_timeout
skip-innodb
skip-networking
slow_query_log
sort_buffer_size
sort_key_blocks
source
sql-mode=""
sql-mode="modes"
sql_big_tables
sql_low_priority_updates
sql_max_join_size
start-slave
stats_method
status
- Section 4.5.1.2, “mysql Commands”
- Section 12.5.2.1, “
ANALYZE TABLESyntax” - Section 12.5.2.2, “
BACKUP TABLESyntax” - Section 12.5.2.3, “
CHECK TABLESyntax” - Section 12.5.2.5, “
OPTIMIZE TABLESyntax” - Section 12.5.2.6, “
REPAIR TABLESyntax” - Section 12.5.2.7, “
RESTORE TABLESyntax” - Description
- Section 4.6.10.5, “MySQL Server Instance Status Monitoring”
stop-slave
syslog
table
test
- Section 12.2.2, “
DELETESyntax” - Section 13.2.13.2.3, “
InnoDBTable Monitor Output” - Section 11.3, “Control Flow Functions”
- Section 13.2.4, “Creating and Using
InnoDBTables” - Section 3.3, “Creating and Using a Database”
- Description
- Description
- Section 3.6, “Examples of Common Queries”
- Section 8.2.3, “Function Name Parsing and Resolution”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 2.17.3, “Securing the Initial MySQL Accounts”
- Section 18.2.1, “Stored Routine Syntax”
- Section 2.17.2, “Unix Post-Installation Procedures”
- Section 4.2.3.1, “Using Options on the Command Line”
tmpdir
- Section 4.6.3.3, “myisamchk Repair Options”
- Section B.1.2.13, “
Can't create/write to file” - Section 7.2.13, “
ORDER BYOptimization” - Section 6.1, “Database Backup Methods”
- Section 2.9, “Installing MySQL on Windows”
- Section 16.4.2, “Replication Relay and Status Files”
- Section 16.1.2.3, “Replication Slave Options and Variables”
- Section 5.1.3, “Server System Variables”
type
- Section 12.5.3.1, “
CREATE FUNCTIONSyntax” - Section 13.2.13.2.3, “
InnoDBTable Monitor Output” - Section 20.8.1, “C API Data Types”
- Section 7.2.18, “How to Avoid Table Scans”
- Section 7.2.6, “Index Merge Optimization”
- Section 7.2.1, “Optimizing Queries with
EXPLAIN” - Section 19.14, “The
INFORMATION_SCHEMA ROUTINESTable”
user
- Section 12.5.1.2, “
DROP USERSyntax” - Section B.1.2.15, “
Ignoring user” - Section 20.8.3.49, “
mysql_options()” - Section 20.8.3.52, “
mysql_real_connect()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 5.5.6.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 5.5.9, “Auditing MySQL Account Activity”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 13.2.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.18.5, “Copying MySQL Databases to Another Machine”
- Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
- Description
- Section 11.10.2, “Encryption and Compression Functions”
- Section 5.3.1, “General Security Guidelines”
- Section 5.3.5, “How to Run MySQL as a Normal User”
- Section 5.5.4, “Limiting Account Resources”
- Section 5.3.2, “Making MySQL Secure Against Attackers”
- Section 5.5.6.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 2.17.3, “Securing the Initial MySQL Accounts”
- Section 5.1.2, “Server Command Options”
- Section 5.4.3, “Specifying Account Names”
- Section 2.17.2.2, “Starting and Stopping MySQL Automatically”
- Section 2.17.2, “Unix Post-Installation Procedures”
- Section 2.18.1.2, “Upgrading from MySQL 4.1 to 5.0”
- Section 5.5.1, “User Names and Passwords”
- Section 5.5.7.2, “Using SSL Connections”
variables
write_buffer_size
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
User Comments
Add your own comment.