MySQL 5.1 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 NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 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.4.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 5.2.4.3, “Mixed Binary Logging Format”
- 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-databases
--all-in-1
--all-tablespaces
--allow-keywords
--allow-suspicious-udfs
--allowold
--analyze
--angel-pid-file
--angel-pid-file=file_name
--ansi
--apply-slave-statements
--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-select-columns=str
--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
--auto-vertical-output
--autoclose
--backup_history_log
--backup_progress_log
--base64-output
--base64-output=DECODE-ROWS
--base64-output=NEVER
--base64-output[=value]
--basedir
- Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
- Description
- Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
- Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.1.4, “Server System Variables”
- Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.3.2, “Typical configure Options”
- Section 2.13.1, “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
--bind-address=127.0.0.1
--bind-address=IP
--binlog-direct-non-transactional-updates
--binlog-direct-non-transactional-updates[={0|1}]
--binlog-do-db
- Section 16.1.3.4, “Binary Log Options and Variables”
- Description
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 17.6.3, “Known Issues in MySQL Cluster Replication”
- Section 16.4.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=mysql
--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
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 17.6.3, “Known Issues in MySQL Cluster Replication”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.2.4, “The Binary Log”
--binlog-ignore-db=db_name
--binlog-ignore-db=mysql
--binlog-ignore-db=sales
--binlog-row-event-max-size
--binlog-row-event-max-size=N
--blob-info
--block-search=offset
--bootstrap
--brief
--build=x86_64-pc-solaris2.10
--burnin
--cflags
--character-set-client-handshake
--character-set-filesystem=charset_name
--character-set-server
- Section 9.5, “Character Set Configuration”
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 1.5, “What Is New in MySQL 5.1”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.4.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
- Section 8.4, “User-Defined Variables”
--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
--collation-server
- Section 9.5, “Character Set Configuration”
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 1.5, “What Is New in MySQL 5.1”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.4.1.2, “Replication and Character Sets”
- Section 9.1.3.1, “Server Character Set and Collation”
- Section 5.1.2, “Server Command Options”
--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
--config-file=path_name
--configdir
--configinfo
--configinfo --xml
--connect-string
--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.5.4.1.1, “Resetting the Root Password on Windows Systems”
- Section 5.1.2, “Server Command Options”
- Section 2.5.5.4, “Starting the Server for the First Time”
- Section 5.2.2, “The Error Log”
--copy
--core-file-size
--core-file-size=size
--correct-checksum
--count
--count=N
--create
--create-options
--create-schema=value
--create=value
--csv[=file_name]
--daemon
--data-file-length=len
--database
--database=db_name
--databases
--datadir
- Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 2.5.5.2, “Creating an Option File”
- Description
- Description
- Section 5.1.4, “Server System Variables”
- Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.3.2, “Typical configure Options”
- Section 2.13.1, “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 1.5, “What Is New in MySQL 5.1”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- Section 8.4, “User-Defined Variables”
--default-character-set=charset_name
--default-character-set=system_character_set
--default-character-set=utf8
--default-collation
--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.6.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 21.8.3, “Options with the Embedded Server”
- Section B.5.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.5.5.6, “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
--delayed-start=N
--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
--dump-slave
--dump-slave[=value]
--embedded
--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-condition-pushdown=1
--engine=engine_name
--err-log=file_name
--event-scheduler
--event-scheduler=DISABLED
--event-scheduler[=value]
--events
--example
--exclude-databases
--exclude-missing-columns
--exclude-tables
--exe-suffix=suffix
--execute
--execute=statement
--exit-info[=flags]
--extend-check
--extended
--extended-insert
--external-locking
--extra-file=file_name
--extra-node-info
--extra-partition-info
--federated
--fields-enclosed-by
--fields-enclosed-by=...
--fields-enclosed-by=char
--fields-escaped-by=...
--fields-escaped-by=char
--fields-optionally-enclosed-by=...
--fields-optionally-enclosed-by=char
--fields-terminated-by=...
--fields-terminated-by=str
--fields-xxx
--first-slave
--fix-db-names
--fix-table-names
--flush
--flush-logs
--flush-privileges
--flush_time=val
--flushlog
--force
--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
- 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.13.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.5.3, “Tuning Server Parameters”
- Chapter 3, Tutorial
- Section 2.13.1, “Unix Post-Installation Procedures”
- Section 4.2.3.3, “Using Option Files”
- Section 4.2.3.1, “Using Options on the Command Line”
--hex-blob
--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.3.5, “MIT-pthreads Notes”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 1.2, “Typographical and Syntax Conventions”
- Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
--host=127.0.0.1
--host=host_name
--host=localhost
--howto
--i-am-a-dummy
--ignore
--ignore-builtin-innodb
--ignore-lines=N
--ignore-spaces
--ignore-sql-errors
--ignore-table=db_name.tbl_name
--in_file=file_name
--include
--include-databases
--include-master-host-port
--include-tables
--info
--information
--init-file
- Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
- Section B.5.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.3.2, “Typical configure Options”
--init-file=file_name
--init_connect="SET NAMES 'utf8'"
--initial
- Section 17.5.11.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
- Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Description
- Section 17.6.3, “Known Issues in MySQL Cluster Replication”
- MySQL 4.1 FAQ — MySQL Cluster
- Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x 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.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.5.10.3, “MySQL Cluster Disk Data Storage Requirements”
- 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.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
- Section 17.5.1, “Summary of MySQL Cluster Start Phases”
--initial-start
--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
--label=str
--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=...
--lines-terminated-by=str
--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 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- 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 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--log-backup-output[=value,...]
--log-bin
- Section 12.5.2.1, “
CHANGE MASTER TOSyntax” - Section 12.5.1.1, “
PURGE BINARY LOGSSyntax” - Section 6.3.1, “Backup Policy”
- Section 6.3.3, “Backup Strategy Summary”
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 19.6, “Binary Logging of Stored Programs”
- Section 6.2, “Database Backup Methods”
- Section 16.4.6, “How to Report Replication Bugs or Problems”
- Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
- Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
- Section 16.4.4, “Replication FAQ”
- Section 16.1.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.4.5, “Troubleshooting Replication”
- Section 16.4.3, “Upgrading a Replication Setup”
- Section 6.3.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 22.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[=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.4.5.36, “
SHOW SLAVE STATUSSyntax” - Section 1.5, “What Is New in MySQL 5.1”
- Section 16.4.1.16, “Replication During a Master Shutdown”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.2, “Replication Implementation”
- Section 7.5.6.6, “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=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=N
--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.5.1, “
MyISAMStartup Options” - Section 7.2.24, “Other Optimization Tips”
- Section 5.1.4, “Server System Variables”
- Section 6.6.5, “Setting Up a
MyISAMTable Maintenance Schedule” - Section B.5.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAMStorage Engine” - Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--myisam-recover=BACKUP,FORCE
--myisam-recover=mode
--myisam-recover[=option[,option]...]]
--mysql-backup[={0|1}]
--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-force-send=1
--ndb-index-stat-enable=0
--ndb-log-empty-epochs
--ndb-log-orig
--ndb-log-update-as-write
--ndb-log-update-as-write=0
--ndb-log-update-as-write=OFF
--ndb-log-updated-only
--ndb-nodeid=#
--ndb-use-exact-count=0
--ndb_optimized_node_selection
--ndbcluster
- Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
- Section 12.4.5.17, “
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”
- Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
- The mysqld-max Extended MySQL Server
- Section 17.5.8, “The
ndbinfoMySQL Cluster Information Database”
--ndbcluster --ndb-connectstring=management_host
--new
--nice=priority
--no-auto-rehash
--no-autocommit
--no-beep
--no-create-db
--no-debug
--no-defaults
--no-embedded
--no-log
--no-named-commands
--no-set-names
--no-symlinks
--nodaemon
--noindices
--nostart
--nowait-nodes
--nowait-nodes=3
--nowait-nodes=3,5
--nowait-nodes=node_id_1[, node_id_2[, ...]]
--number-blob-cols=str
--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.5.2.4, “
Client does not support authentication protocol” - Section 5.3.2.3, “Password Hashing in MySQL”
- Section 16.4.1, “Replication Features and Issues”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
--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]
--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
- Description
- Section 5.3.2.2, “End-User Guidelines for Password Security”
- Section 6.3, “Example Backup and Recovery Strategy”
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
- Section B.5.2.5, “Password Fails When Entered Interactively”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
--password-file=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_dir=path
--plugin_name
--plugin_name=0
--plugin_name=1
--plugin_name=FORCE
--plugin_name=OFF
--plugin_name=ON
--plugin_name[=ON]
--plugindir
--plugins=max-no-innodb
--plugins=ndbcluster
--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.13.1.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=N
--post-query=value
--post-system=str
--pre-query=value
--pre-system=str
--prefix
--preserve-schema
--preview
--print-defaults
--print-password-line
--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
--relay-log=relay_log_index
--relnotes
--reload
--remove
--repair
--replace
--replicate-*
--replicate-*-db
--replicate-*-do-*
--replicate-*-ignore-*
--replicate-*-table
--replicate-[do|ignore]-table
--replicate-do-*
--replicate-do-db
- Section 12.4.5.36, “
SHOW SLAVE STATUSSyntax” - Section 12.3.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.4.1.21, “Replication and Reserved Words”
- Section 16.4.1.25, “Replication and Temporary Tables”
- Section 5.2.4, “The Binary Log”
--replicate-do-db=db1
--replicate-do-db=db_name
--replicate-do-db=mysql
--replicate-do-db=sales
--replicate-do-table
- Section 12.4.5.36, “
SHOW SLAVE STATUSSyntax” - Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.2.3.3, “Replication Rule Application”
- Section 16.4.1.21, “Replication and Reserved Words”
- Section 16.4.1.25, “Replication and Temporary Tables”
--replicate-do-table=db_name.tbl_name
--replicate-do-table=mysql.ndb_apply_status
--replicate-ignore-*
--replicate-ignore-db
- Section 12.4.5.36, “
SHOW SLAVE STATUSSyntax” - Section 12.3.1, “
START TRANSACTION,COMMIT, andROLLBACKSyntax” - Section 16.1.3.4, “Binary Log Options and Variables”
- Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.2.3.3, “Replication Rule Application”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.4.1.21, “Replication and Reserved Words”
- Section 5.2.4, “The Binary Log”
--replicate-ignore-db=db_name
--replicate-ignore-db=mysql
--replicate-ignore-db=sales
--replicate-ignore-table
--replicate-ignore-table=db_name.tbl_name
--replicate-ignore-table=mysql.ndb_apply_status
--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-backup-file-priv
--secure-backup-file-priv=path
--secure-file-priv
--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-random-seed=value
--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.4.3.2, “
CREATE FUNCTIONSyntax” - Section 12.4.3.4, “
INSTALL PLUGINSyntax” - Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
- Description
- Description
- Section 2.4.2.1, “Downgrading to MySQL 5.0”
- Section 12.4.3.1, “Installing and Uninstalling Plugins”
- Section 2.13.1.1, “Problems Running mysql_install_db”
- Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 2.3.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.4.5.17, “
SHOW ENGINESSyntax” - Section 16.4.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.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
--skip-innodb-checksums
--skip-innodb_adaptive_hash_index
--skip-innodb_checksums
--skip-innodb_doublewrite
--skip-kill-mysqld
--skip-line-numbers
--skip-lock-tables
--skip-log-warnings
--skip-merge
--skip-mutex-deadlock-detector
--skip-name-resolve
--skip-named-commands
--skip-ndbcluster
--skip-networking
- Section B.5.2.2, “
Can't connect to [local] MySQL server” - Section B.5.2.9, “
MySQL server has gone away” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 7.5.11, “How MySQL Uses DNS”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 16.4.3, “Upgrading a Replication Setup”
--skip-new
--skip-partition
--skip-plugin-innodb_file_per_table
--skip-plugin_name
--skip-quick
--skip-quote-names
--skip-reconnect
--skip-routines
--skip-safemalloc
--skip-set-charset
--skip-show-database
--skip-slave-start
- Section 12.5.2.1, “
CHANGE MASTER TOSyntax” - Section 12.5.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.4.5, “Troubleshooting Replication”
- Section 16.4.3, “Upgrading a Replication Setup”
--skip-ssl
--skip-stack-trace
--skip-super-large-pages
--skip-symbolic-links
--skip-syslog
--skip-thread-priority
--skip-triggers
--skip-tz-utc
--skip-use-db
--skip-write-binlog
--skip-xxx
--skip_grant_tables
--slave
--slave-allow-batching
--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.5.2.2, “
Can't connect to [local] MySQL server” - Section 5.4.7, “Causes of Access-Denied Errors”
- Section 4.2.2, “Connecting to the MySQL Server”
- Description
- Description
- Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
- Section 5.6.2, “Running Multiple Servers on Unix”
- Section 2.5.5.7, “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
- 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
--spassword[=password]
--sporadic-binlog-dump-fail
--sql-bin-update-same
--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 16.1.3.3, “Replication Slave Options and Variables”
- Section 5.5.6.3, “SSL Command Options”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.5.6.2, “Using SSL Connections”
--ssl*
--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
--standalone
--start-datetime
--start-datetime=datetime
--start-position
--start-position=N
--start_row=N
--statefile=file_name
--stats
--status
--stop-datetime
--stop-datetime=datetime
--stop-position
--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
--tab=path
--table_cache
--table_open_cache
--tables
--tc-heuristic-recover={COMMIT|ROLLBACK}
--tcp-ip
--tee=file_name
--temp-pool
--test
--thread_cache_size=5'
--thread_handling=no-threads
--thread_handling=one-thread-per-connection
--thread_handling=pool-of-threads
--thread_pool_size=N
--thread_stack=N
--timer-length=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
--type=engine_name
--tz-utc
--unbuffered
--unpack
--update-state
--upgrade-system-tables
--use-frm
--use-manager
--use-mysqld_safe
--use-symbolic-links
--use-threads
--use-threads=N
--user
- Section B.5.2.18, “'
File' Not Found and Similar Errors” - Description
- Description
- Description
- Section 6.3, “Example Backup and Recovery Strategy”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 2.9, “Installing MySQL on i5/OS”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.1.2, “Server Command Options”
- Section 2.3.1, “Source Installation Overview”
- Section 2.13.1, “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
- Section 5.3.6, “How to Run MySQL as a Normal User”
- Section 4.6.10.1, “MySQL Instance Manager Command Options”
--user={user_name|user_id}
--username
--username=user_name
--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.5.5.5, “Starting MySQL from the Windows Command Line”
- Section 2.13.1.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 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 22.5.1.1, “Compiling MySQL for Debugging”
- Section 2.3.4, “Dealing with Problems Compiling MySQL”
- Section 22.5.2, “Debugging a MySQL Client”
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 5.1.2, “Server Command Options”
- Section 2.3.2, “Typical configure Options”
- Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug=full
- Section 22.5.1.1, “Compiling MySQL for Debugging”
- Section 22.5.2, “Debugging a MySQL Client”
- Description
- Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 5.1.2, “Server Command Options”
- Section B.5.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-federated-storage-engine
--with-innodb
--with-libevent
--with-libwrap
--with-low-memory
--with-max-indexes=N
--with-mit-threads
--with-mysqld-ldflags=-all-static
--with-mysqld-ldflags=-rdynamic
--with-named-z-libs
--with-ndb-sci=/opt/DIS
--with-ndb-sci=/your/path/to/SCI
--with-ndb-shm
--with-ndbcluster
--with-openssl
--with-partition
--with-plugin-PLUGIN
--with-plugins
--with-plugins=max
--with-plugins=max-no-innodb
--with-plugins=ndbcluster
--with-pstack
--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-libevent
--without-plugin-PLUGIN
--without-query-cache
--write-binlog
--xml
-1
- Section 1.8.5.6, “'
--' as the Start of a Comment” - Section 11.12.1, “
GROUP BY(Aggregate) Functions” - Section 18.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.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
-?
- 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
-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 file_name
-P
-P port_num
-P[password]
-Q
-R index_num
-R record_pos_file record_pos
-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 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]
-a
-c
-c column_list
-c file_name
-d
-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.6.2, “How to Check
MyISAMTables for Errors” - MySQL 4.1 FAQ — MySQL Cluster
- Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
- 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 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
- 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”
- Section 2.5.4.13, “Creating an Instance from the Command Line”
- Description
- Description
- Description
- Description
- Description
- Section 6.6.2, “How to Check
MyISAMTables for Errors” - Section 22.5.1.3, “Using
pdbto create a Windows crashdump”
-i N
-i delay
-i name
-j N
-j big_tbl_name
-k
-l
-l path
-libmysqlclient
-libmysqld
-lmysqlclient
-lmysqlclient -lz
-lmysqld
-lz
-m
-mcpu=v8 -Wa,-xarch=v8plusa
-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 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
- 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.3.2.2, “End-User Guidelines for Password Security”
- Section 4.6.10.4, “Instance Manager User and Password Management”
- Section 4.2.1, “Invoking MySQL Programs”
- Section B.5.2.5, “Password Fails When Entered Interactively”
- Section 2.5.5.6, “Starting MySQL as a Windows Service”
- Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
- Section 2.5.5.7, “Testing The MySQL Installation”
- Section 2.5.7, “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.5.8, “Windows Post-Installation Procedures”
-p N
-p len
-p num
-p[pass_val]
-p[password]
-ppassword
-q
-q value
-r
-r file_name
-r name
-s
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Section 2.5.4.13, “Creating an Instance from the Command Line”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 6.6.2, “How to Check
MyISAMTables for Errors” - Section 6.6.3, “How to Repair
MyISAMTables” - Section 6.6.5, “Setting Up a
MyISAMTable Maintenance Schedule”
-s file_name
-s num
-s sort_type
-signal
-skip-auto-rehash
-slow_query_log_file
-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.5.5.7, “Testing The MySQL Installation”
- Section 5.5.1, “User Names and Passwords”
- Section 2.5.8, “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”
- 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.6.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
-ândb-log-update-as-write=OFF
-ândb-log-updated-only
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.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.5, “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.10.1, “MySQL Cluster Disk Data Objects”
- Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
- Section 17.3.1, “Quick Test Setup of MySQL Cluster”
- Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”
- Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
DataMemory
- Section B.5.2.12, “
The table is full” - Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
- Section 17.3.2.6, “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”
- Section 17.5.10.3, “MySQL Cluster Disk Data Storage Requirements”
- Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
- Section 17.5.8.6, “The
ndbinfo memoryusageTable”
DiskCheckpointSpeed
DiskCheckpointSpeedInRestart
DiskIOThreadPool
DiskPageBufferMemory
DiskSyncSize
ExecuteOnComputer
FileSystemPath
FileSystemPathDD
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.1.4.3, “MySQL CLuster Development in MySQL Cluster NDB 6.2”
- Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”
FileSystemPathDataFiles
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.1.4.3, “MySQL CLuster Development in MySQL Cluster NDB 6.2”
- Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”
FileSystemPathUndoFiles
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.1.4.3, “MySQL CLuster Development in MySQL Cluster NDB 6.2”
- Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”
FragmentLogFileSize
HeartbeatIntervalDbApi
HeartbeatIntervalDbDb
HeartbeatThreadPriority
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.1.4.6, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
HostName
- Section 17.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 17.2, “MySQL Cluster Multi-Computer How-To”
- Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”
- Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Id
- Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
- Section 12.4.5.5, “
SHOW COLLATIONSyntax” - Section 12.4.5.31, “
SHOW PROCESSLISTSyntax” - Section 21.9.1, “C API Data Types”
- Section 9.4.2, “Choosing a Collation ID”
- Section 17.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 7.5.6, “Examining Thread Information”
- Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
- Section 20.10, “The
INFORMATION_SCHEMA COLLATIONSTable” - Section 20.22, “The
INFORMATION_SCHEMA PROCESSLISTTable”
IndexMemory
- Section B.5.2.12, “
The table is full” - Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
- Section 17.3.2.6, “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.5.8.6, “The
ndbinfo memoryusageTable”
InitFragmentLogFiles
InitialLogFileGroup
InitialNoOfOpenFiles
InitialTablespace
LockExecuteThreadToCPU
LockMaintThreadsToCPU
LockPagesInMainMemory
LogDestination
LogLevelCheckpoint
LogLevelCongestion
LogLevelConnection
LogLevelError
LogLevelNodeRestart
LogLevelShutdown
LogLevelStartup
LogLevelStatistic
LongMessageBuffer
MaxAllocate
MaxBufferedEpochs
MaxLCPStartDelay
MaxNoOfAttributes
MaxNoOfConcurrentIndexOperations
MaxNoOfConcurrentOperations
MaxNoOfConcurrentScans
MaxNoOfConcurrentSubOperations
MaxNoOfConcurrentTransactions
MaxNoOfExecutionThreads
MaxNoOfFiredTriggers
MaxNoOfLocalOperations
MaxNoOfLocalScans
MaxNoOfOpenFiles
MaxNoOfOrderedIndexes
MaxNoOfSavedMessages
MaxNoOfSubscribers
MaxNoOfSubscriptions
MaxNoOfTables
MaxNoOfTriggers
MaxNoOfUniqueHashIndexes
MemReportFrequency
Name
- Section 12.4.5.1, “
SHOW AUTHORSSyntax” - Section 12.4.5.7, “
SHOW CONTRIBUTORSSyntax” - Section 12.4.5.16, “
SHOW ENGINESyntax” - Section 12.4.5.19, “
SHOW EVENTSSyntax” - Section 12.4.5.27, “
SHOW PLUGINSSyntax” - Section 12.4.5.38, “
SHOW TABLE STATUSSyntax” - Section 20.20, “The
INFORMATION_SCHEMA EVENTSTable” - Section 20.17, “The
INFORMATION_SCHEMA PLUGINSTable” - Section 17.5.8, “The
ndbinfoMySQL Cluster Information Database”
Ndb_cluster_node_id
NoOfDiskPagesToDiskAfterRestartACC
NoOfDiskPagesToDiskAfterRestartTUP
NoOfDiskPagesToDiskDuringRestartACC
NoOfDiskPagesToDiskDuringRestartTUP
NoOfFragmentLogFiles
NoOfReplicas
NodeGroup
NodeId1
NodeId2
OverloadLimit
PortNumber
Questions
RealtimeScheduler
ReceiveBufferMemory
ReservedSendBufferMemory
RestartOnErrorInsert
SchedulerExecutionTimer
SchedulerSpinTimer
SendBufferMemory
SendLimit
SendSignalId
SharedBufferSize
SharedGlobalMemory
Slave_running
StartFailureTimeout
StartPartialTimeout
StartPartitionedTimeout
StartupStatusReportFrequency
TcpBind_INADDR_ANY
Text in this style
TimeBetweenEpochs
TimeBetweenEpochsTimeout
TimeBetweenGlobalCheckpoints
TimeBetweenInactiveTransactionAbortCheck
TimeBetweenLocalCheckpoints
TimeBetweenWatchDogCheck
TimeBetweenWatchDogCheckInitial
TotalSendBufferMemory
- Section 17.3.2.13, “Configuring MySQL Cluster Send Buffer Parameters”
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
TransactionBufferMemory
TransactionDeadlockDetectionTimeout
TransactionInactiveTimeout
UndoDataBuffer
UndoIndexBuffer
\G
\s
\t
all
ansi
automatic_sp_privileges
basedir
c
character_set_client
collation_connection
compress
connect_timeout
count
d
data
datadir
- Section 2.5.5.2, “Creating an Option File”
- Section 2.7.5, “MySQL Installation on Mac OS X Notes”
- Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
- Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
- Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
- Section D.7.3, “Windows Platform Limitations”
db
- Section 12.4.1.3, “
GRANTSyntax” - Section 12.4.5.31, “
SHOW PROCESSLISTSyntax” - Section 21.9.3.3, “
mysql_change_user()” - Section 21.9.3.8, “
mysql_create_db()” - Section 21.9.3.11, “
mysql_drop_db()” - Section 21.9.3.52, “
mysql_real_connect()” - Section 21.9.3.60, “
mysql_select_db()” - Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 21.9.1, “C API Data Types”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 2.4.5, “Copying MySQL Databases to Another Machine”
- Description
- Section 7.5.6, “Examining Thread Information”
- Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 20.22, “The
INFORMATION_SCHEMA PROCESSLISTTable” - Section 20.14, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 2.13.1, “Unix Post-Installation Procedures”
decode_bits
default-storage-engine
default-table-type
defaults-extra-file
delimiter
description
e
extended-status
flush-backup-logs
flush-hosts
flush-logs
flush-privileges
flush-status
flush-tables
flush-threads
ft_max_word_len
ft_min_word_len
ft_stopword_file
general_log
have_partition_engine
have_profiling
help
host
- Section 12.4.1.3, “
GRANTSyntax” - Section 21.9.3.7, “
mysql_connect()” - Section 21.9.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.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.4.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.13.1, “Unix Post-Installation Procedures”
ibmdb2i_assume_exclusive_use
ibmdb2i_async_enabled
ibmdb2i_compat_opt_allow_zero_date_vals
ibmdb2i_compat_opt_blob_cols
ibmdb2i_compat_opt_time_as_duration
ibmdb2i_compat_opt_year_as_int
ibmdb2i_create_index_option
ibmdb2i_create_time_columns_as_tod
ibmdb2i_lob_alloc_size
ibmdb2i_map_blob_to_varchar
ibmdb2i_max_read_buffer_size
ibmdb2i_max_write_buffer_size
ibmdb2i_propagate_default_col_val
ibmdb2i_propagate_default_col_vals
ibmdb2i_system_trace_level
ibmdb2i_transaction_unsafe
ignore-builtin-innodb
init-file
innodb
innodb_file_per_table
innodb_safe_binlog
innodb_status_file=1
innodb_support_xa
innodb_table_locks
interactive_timeout
key_buffer_size
ledir
length
- Section 21.9.3.34, “
mysql_hex_string()” - Section 21.9.3.53, “
mysql_real_escape_string()” - Section 21.9.3.54, “
mysql_real_query()” - Section 21.9.7.11, “
mysql_stmt_fetch()” - Section 21.9.7.20, “
mysql_stmt_prepare()” - Section 21.9.7.25, “
mysql_stmt_send_long_data()” - Section 21.9.1, “C API Data Types”
- Section 21.9.5, “C API Prepared Statement Data types”
- Section 22.2.4.2.1, “Full-Text Parser Plugin Data Structures and Functions”
- Section 22.2.5, “Writing Plugins”
log-slave-updates
log_backup_output
log_bin_trust_routine_creators
max_allowed_packet
max_connections
max_user_connections
multi_range_count
myisam_block_size
myisam_max_extra_sort_file_size
myisam_stats_method
mysql
- Section 4.5.1.1, “mysql Options”
- Section 4.5.1.3, “mysql Server-Side Help”
- Section 12.4.3.2, “
CREATE FUNCTIONSyntax” - Section 12.1.16, “
CREATE SERVERSyntax” - Section 12.4.1.1, “
CREATE USERSyntax” - Section B.5.2.4, “
Client does not support authentication protocol” - Section 12.4.3.3, “
DROP FUNCTIONSyntax” - Section 12.4.1.2, “
DROP USERSyntax” - Section 12.4.6.3, “
FLUSHSyntax” - Section 12.4.1.3, “
GRANTSyntax” - Section 12.8.3, “
HELPSyntax” - Section 12.5.2.2, “
LOAD DATA FROM MASTERSyntax” - Section B.5.2.9, “
MySQL server has gone away” - Section 12.4.1.4, “
RENAME USERSyntax” - Section 12.4.1.5, “
REVOKESyntax” - Section 12.4.1.6, “
SET PASSWORDSyntax” - Section 12.4.5.22, “
SHOW GRANTSSyntax” - Section 21.9.3.3, “
mysql_change_user()” - Section 21.9.3.5, “
mysql_close()” - Section 21.9.3.14, “
mysql_errno()” - Section 21.9.3.15, “
mysql_error()” - Section 21.9.3.33, “
mysql_get_ssl_cipher()” - Section 21.9.3.36, “
mysql_init()” - Section 21.9.3.53, “
mysql_real_escape_string()” - Section 21.9.3.60, “
mysql_select_db()” - Section 21.9.3.67, “
mysql_ssl_set()” - Section 21.9.7.10, “
mysql_stmt_execute()” - Section 21.9.7.11, “
mysql_stmt_fetch()” - Section 21.9.7.25, “
mysql_stmt_send_long_data()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 12.4.1, “Account Management Statements”
- Section 5.5.2, “Adding User Accounts”
- Section 5.3.2.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 6.3.1, “Backup Policy”
- Section 21.9.14, “C API Prepared Statement Handling of Date and Time Values”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
- Section 9.1.4, “Connection Character Sets and Collations”
- Chapter 21, Connectors and APIs
- Section 13.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.4.5, “Copying MySQL Databases to Another Machine”
- Section 13.11.2.1, “Creating a
FEDERATEDTable UsingCONNECTION” - 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.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Description
- Description
- Description
- Description
- Section 2.4.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 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
- Section 2.7, “Installing MySQL on Mac OS X”
- Section 2.8, “Installing MySQL on Solaris”
- Section 17.6.3, “Known Issues in MySQL Cluster Replication”
- Section 5.2.4.4, “Logging Format for Changes to
mysqlDatabase Tables” - Section 5.3.3, “Making MySQL Secure Against Attackers”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 1.5, “What Is New in MySQL 5.1”
- Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
- Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
- Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
- Section 17.5.9.2, “MySQL Cluster and MySQL Privileges”
- Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
- Section 2.7.5, “MySQL Installation on Mac OS X Notes”
- Section 21.10, “MySQL PHP API”
- Section 9.6, “MySQL Server Time Zone Support”
- Section 12.3.5.3, “Other Table-Locking Notes”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.3.2.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 2.13.1.1, “Problems Running mysql_install_db”
- Section 16.4.4, “Replication FAQ”
- Section 16.4.1, “Replication Features and Issues”
- Section 16.4.1.10, “Replication and
FLUSH” - Section 16.4.1.19, “Replication of the System
mysqlDatabase” - Section B.5.4.1.2, “Resetting the Root Password on Unix Systems”
- Section 13.6.14, “Restrictions on
InnoDBTables” - Section D.6, “Restrictions on Character Sets”
- Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
- Section 2.13.2, “Securing the Initial MySQL Accounts”
- Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
- Section 5.1.2, “Server Command Options”
- Section 5.1.9, “Server-Side Help”
- Section 5.5.4, “Setting Account Resource Limits”
- Section 2.3.1, “Source Installation Overview”
- Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
- Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
- Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 12.3.3, “Statements That Cause an Implicit Commit”
- Section 9.6.1, “Staying Current with Time Zone Changes”
- Section 5.4, “The MySQL Access Privilege System”
- Section 22.2, “The MySQL Plugin API”
- Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
- Section 2.13.1, “Unix Post-Installation Procedures”
- Section 2.4.1, “Upgrading MySQL”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”
- Section 5.5.6.2, “Using SSL Connections”
- Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 19.2, “Using Stored Routines (Procedures and Functions)”
- Section 2.5.8, “Windows Post-Installation Procedures”
mysql-server
mysqlaccess
mysqlbinlog
mysqld
- Section B.5.2.2, “
Can't connect to [local] MySQL server” - Section 21.9.2, “C API Function Overview”
- Description
- Description
- Section 13.11.1, “
FEDERATEDStorage Engine Overview” - Section 2.9, “Installing MySQL on i5/OS”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
- Section 4.6.10.7, “MySQL Instance Manager Commands”
- Section 5.1.1, “Server Option and Variable Reference”
- Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
- Section 5.2.2, “The Error Log”
- Section 16.2.2.2, “The Slave Status Files”
- Section 22.5.1.3, “Using
pdbto create a Windows crashdump”
mysqld-path=path-to-mysqld-binary
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlslap
ndb-connectstring
ndb_autoincrement_prefetch_sz
ndb_optimization_delay
ndb_table_no_logging
ndb_table_temporary
net_retry_count
net_write_timeout
nice
nonguarded
offset
old-alter-table
open-files-limit
open_files_limit
p
partition
password
performance_schema
pid-file
pipe
plugin
plugin-load
port
processlist
purge-backup-logs
query_cache_type
read_buffer_size
reconnect
record_buffer
replication-ignore-table
resolve_stack_dump
rows
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.3.2, “Replication Master Options and Variables”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.1.1.8, “Setting Up Replication with Existing Data”
- Section 16.1.1.1, “Setting the Replication Master Configuration”
- Section 16.1.1.2, “Setting the Replication Slave Configuration”
set-variable
set-variable=option=value
shutdown
shutdown_timeout
skip-innodb
skip-networking
skip-slave-start
slave_type_conversions
slow_query_log
socket
sort_buffer_size
sort_key_blocks
source
sql-mode=""
sql-mode="modes"
sql_big_tables
sql_log_update
sql_low_priority_updates
sql_max_join_size
start-slave
stats_method
status
- Section 4.5.1.2, “mysql Commands”
- Section 12.4.2.1, “
ANALYZE TABLESyntax” - Section 12.4.2.2, “
BACKUP TABLESyntax” - Section 12.4.2.3, “
CHECK TABLESyntax” - Section 12.4.2.5, “
OPTIMIZE TABLESyntax” - Section 12.4.2.6, “
REPAIR TABLESyntax” - Section 12.4.2.7, “
RESTORE TABLESyntax” - Description
- Section 17.5.6, “MySQL Cluster Single User Mode”
- Section 4.6.10.5, “MySQL Server Instance Status Monitoring”
- Section 17.5.8.7, “The
ndbinfo nodesTable” - Section 17.5.8.10, “The
ndbinfo transportersTable”
stop-slave
syslog
table
table_type
test
- Section 12.2.2, “
DELETESyntax” - Section 7.2.20, “
INFORMATION_SCHEMAOptimization” - Section 13.6.13.2.3, “
InnoDBTable Monitor Output” - Section 12.4.5.19, “
SHOW EVENTSSyntax” - Section 9.1.7.8, “Collation and
INFORMATION_SCHEMASearches” - Section 11.3, “Control Flow Functions”
- Section 13.6.4, “Creating and Using
InnoDBTables” - Section 3.3, “Creating and Using a Database”
- Description
- Description
- Section 6.4.5.4, “Dumping Table Definitions and Content Separately”
- Section 3.6, “Examples of Common Queries”
- Section 8.2.4, “Function Name Parsing and Resolution”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 2.13.2, “Securing the Initial MySQL Accounts”
- Section 19.2.1, “Stored Routine Syntax”
- Section 20.19, “The
INFORMATION_SCHEMA PARTITIONSTable” - Section 2.13.1, “Unix Post-Installation Procedures”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 2.5.8, “Windows Post-Installation Procedures”
type
- Section 12.4.3.2, “
CREATE FUNCTIONSyntax” - Section 13.6.13.2.3, “
InnoDBTable Monitor Output” - Section 21.9.1, “C API Data Types”
- Section 22.2.4.2.1, “Full-Text Parser Plugin Data Structures and Functions”
- Section 22.2.4.1, “General Plugin Data Structures and Functions”
- Section 7.2.19, “How to Avoid Table Scans”
- Section 7.2.6, “Index Merge Optimization”
- Section 7.2.1, “Optimizing Queries with
EXPLAIN” - Section 22.2.4.3, “Plugin Status and System Variables”
- Section 20.14, “The
INFORMATION_SCHEMA ROUTINESTable”
update
user
- Section 12.4.1.2, “
DROP USERSyntax” - Section B.5.2.15, “
Ignoring user” - Section 21.9.3.49, “
mysql_options()” - Section 21.9.3.52, “
mysql_real_connect()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 5.4.5, “Access Control, Stage 2: Request Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 5.3.2.1, “Administrator Guidelines for Password Security”
- Section 5.5.5, “Assigning Account Passwords”
- Section 5.5.8, “Auditing MySQL Account Activity”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 13.6.4.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.4.5, “Copying MySQL Databases to Another Machine”
- Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
- Description
- Section 11.11.2, “Encryption and Compression Functions”
- Section 5.3.1, “General Security Guidelines”
- Section 5.3.6, “How to Run MySQL as a Normal User”
- Section 5.3.3, “Making MySQL Secure Against Attackers”
- Section 5.3.2.3, “Password Hashing in MySQL”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section D.6, “Restrictions on Character Sets”
- Section 2.13.2, “Securing the Initial MySQL Accounts”
- Section 5.1.2, “Server Command Options”
- Section 5.5.4, “Setting Account Resource Limits”
- Section 5.4.3, “Specifying Account Names”
- Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
- Section 2.13.1, “Unix Post-Installation Procedures”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- Section 5.5.1, “User Names and Passwords”
- Section 5.5.6.2, “Using SSL Connections”
- Section 11.10, “XML Functions”
User Comments
Add your own comment.