- MySQL 5.1 Reference Manual :: Option Index
-
- MySQL 5.1 Reference Manual
- 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 DATABASE
Syntax” - Section 12.4.1.3, “
GRANT
Syntax” - Section 11.5.1, “Arithmetic Operators”
- 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-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.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.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.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-cache
--config-file
--config-file=file_name
--config-file=path_name
--configdir
--configinfo
--configinfo --xml
--connect-string
--console
- Section 13.6.13.3, “
InnoDB
General Troubleshooting” - Section 13.6.13.2, “
SHOW ENGINE INNODB STATUS
and theInnoDB
Monitors” - Section 13.6.2.3, “Creating the
InnoDB
Tablespace” - Section B.5.4.1.1, “Resetting the Root Password: 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 INFILE
Syntax” - 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, “
InnoDB
Configuration” - 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: 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: Unix Systems”
- Section B.5.4.1.1, “Resetting the Root Password: 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.2, “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-safe-binlog
--innodb-status-file
--innodb-status-file=1
--innodb-xxx
--innodb[=value]
--innodb_checksums
--innodb_file_per_table
--innodb_locks_unsafe_for_binlog
--innodb_rollback_on_timeout
--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 TO
Syntax” - Section 12.5.1.1, “
PURGE BINARY LOGS
Syntax” - 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.7, “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 STATUS
Syntax” - Section 1.5, “What Is New in MySQL 5.1”
- 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”
- Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
--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, “
MyISAM
Startup Options” - Section 7.2.24, “Other Optimization Tips”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 6.6.5, “Setting Up a
MyISAM
Table Maintenance Schedule” - Section B.5.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAM
Storage Engine” - Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--myisam-recover-options
- Section 13.5.1, “
MyISAM
Startup Options” - Section 7.2.24, “Other Optimization Tips”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 6.6.5, “Setting Up a
MyISAM
Table Maintenance Schedule” - Section B.5.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAM
Storage Engine” - Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
--myisam-recover-options=BACKUP,FORCE
--myisam-recover-options=mode
--myisam-recover-options[=option[,option]...]]
--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 ENGINES
Syntax” - 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
ndbinfo
MySQL Cluster Information Database”
--ndbcluster --ndb-connectstring=management_host
--ndbinfo-database=name
--ndbinfo-table-prefix
--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
--no-tablespaces
--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.11, “Replication and System Functions”
- Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
- 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 STATUS
Syntax” - Section 12.3.1, “
START TRANSACTION
,COMMIT
, andROLLBACK
Syntax” - 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.1.3.3, “Replication Slave Options and Variables”
- Section 16.4.1.22, “Replication and Reserved Words”
- Section 16.4.1.19, “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
--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 STATUS
Syntax” - Section 12.3.1, “
START TRANSACTION
,COMMIT
, andROLLBACK
Syntax” - 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.2.3.3, “Replication Rule Application”
- Section 16.1.3.3, “Replication Slave Options and Variables”
- Section 16.4.1.22, “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 FUNCTION
Syntax” - Section 12.4.3.4, “
INSTALL PLUGIN
Syntax” - 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.3, “Resetting the Root Password: Generic Instructions”
- 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, “
InnoDB
Configuration” - Section 13.6.3, “
InnoDB
Startup Options and System Variables” - Section 12.4.5.17, “
SHOW ENGINES
Syntax” - 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
- Section 5.4.7, “Causes of Access-Denied Errors”
- Description
- Section 7.5.11, “How MySQL Uses DNS”
- Section 2.13.2, “Securing the Initial MySQL Accounts”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 2.5.5.7, “Testing The MySQL Installation”
--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 TO
Syntax” - Section 12.5.2.7, “
START SLAVE
Syntax” - 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
myisamchk
Options” - 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.5, “'
--
' as the Start of a Comment” - Section 11.12.1, “
GROUP BY
(Aggregate) Functions” - Section 18.2.3, “
HASH
Partitioning” - 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
MyISAM
Tables 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
MyISAM
Tables for Errors” - Section 22.5.1.3, “Using
pdb
to 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.13.2, “Securing the Initial MySQL Accounts”
- 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
MyISAM
Tables for Errors” - Section 6.6.3, “How to Repair
MyISAM
Tables” - Section 6.6.5, “Setting Up a
MyISAM
Table Maintenance Schedule”
-s at
-s file_name
-s num
-s sort_type
-signal
-skip-auto-rehash
-slow_query_log_file
-t
-t N
-t path
-u
-u {user_name|user_id}
-u user_name
-v
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.6.3.5, “myisamchk Table Information”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Description
- Section 6.6.2, “How to Check
MyISAM
Tables 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
-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 memoryusage
Table”
DiskCheckpointSpeed
DiskCheckpointSpeedInRestart
DiskIOThreadPool
DiskPageBufferMemory
DiskSyncSize
ExecuteOnComputer
FileSystemPath
FileSystemPathDD
- Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
- Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.2, “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.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
- Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.2, “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.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
- Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.2, “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.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
- Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
- Section 17.1.4.1, “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 COLLATION
Syntax” - Section 12.4.5.31, “
SHOW PROCESSLIST
Syntax” - Section 21.9.1, “C API Data Structures”
- 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 COLLATIONS
Table” - Section 20.22, “The
INFORMATION_SCHEMA PROCESSLIST
Table”
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 memoryusage
Table”
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 AUTHORS
Syntax” - Section 12.4.5.7, “
SHOW CONTRIBUTORS
Syntax” - Section 12.4.5.16, “
SHOW ENGINE
Syntax” - Section 12.4.5.19, “
SHOW EVENTS
Syntax” - Section 12.4.5.27, “
SHOW PLUGINS
Syntax” - Section 12.4.5.38, “
SHOW TABLE STATUS
Syntax” - Section 20.20, “The
INFORMATION_SCHEMA EVENTS
Table” - Section 20.17, “The
INFORMATION_SCHEMA PLUGINS
Table” - Section 17.5.8, “The
ndbinfo
MySQL 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.2, “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
auto_increment_increment
auto_increment_offset
automatic_sp_privileges
basedir
c
- Section 12.1.7, “
ALTER TABLE
Syntax” - Section 12.1.17, “
CREATE TABLE
Syntax” - Section 11.12.3, “
GROUP BY
andHAVING
with Hidden Columns” - Description
- Section 8.2.1, “Identifier Qualifiers”
- Section 3.3.4.7, “Pattern Matching”
- Section 11.4.2, “Regular Expressions”
- Section 9.1.13.1, “Unicode Character Sets”
character_set_client
character_set_connection
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, “
GRANT
Syntax” - Section 12.4.5.31, “
SHOW PROCESSLIST
Syntax” - 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 Structures”
- 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 PROCESSLIST
Table” - Section 20.14, “The
INFORMATION_SCHEMA ROUTINES
Table” - 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, “
GRANT
Syntax” - 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-safe-binlog
innodb-status-file=1
innodb_file_per_table
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 Structures”
- Section 21.9.5, “C API Prepared Statement Data Structures”
- 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 FUNCTION
Syntax” - Section 12.1.16, “
CREATE SERVER
Syntax” - Section 12.4.1.1, “
CREATE USER
Syntax” - Section B.5.2.4, “
Client does not support authentication protocol
” - Section 12.4.3.3, “
DROP FUNCTION
Syntax” - Section 12.4.1.2, “
DROP USER
Syntax” - Section 12.4.6.3, “
FLUSH
Syntax” - Section 12.4.1.3, “
GRANT
Syntax” - Section 12.8.3, “
HELP
Syntax” - Section 12.5.2.2, “
LOAD DATA FROM MASTER
Syntax” - Section B.5.2.9, “
MySQL server has gone away
” - Section 12.4.1.4, “
RENAME USER
Syntax” - Section 12.4.1.5, “
REVOKE
Syntax” - Section 12.4.1.6, “
SET PASSWORD
Syntax” - Section 12.4.5.22, “
SHOW GRANTS
Syntax” - 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
FEDERATED
Table 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
mysql
Database 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.3.4.3, “MySQL Cluster System Variables”
- 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.10, “Replication and
FLUSH
” - Section 16.4.1.20, “Replication of the
mysql
System Database” - Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
- Section 13.6.14, “Restrictions on
InnoDB
Tables” - 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.8, “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, “
FEDERATED
Storage Engine Overview” - Section 2.9, “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 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
pdb
to create a Windows crashdump”
mysqld-path=path-to-mysqld-binary
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlslap
ndb-connectstring
ndb_autoincrement_prefetch_sz
ndb_log_binlog_index
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 TABLE
Syntax” - Section 12.4.2.2, “
BACKUP TABLE
Syntax” - Section 12.4.2.3, “
CHECK TABLE
Syntax” - Section 12.4.2.5, “
OPTIMIZE TABLE
Syntax” - Section 12.4.2.6, “
REPAIR TABLE
Syntax” - Section 12.4.2.7, “
RESTORE TABLE
Syntax” - 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 nodes
Table” - Section 17.5.8.10, “The
ndbinfo transporters
Table”
stop-slave
syslog
table
table_type
test
- Section 12.2.2, “
DELETE
Syntax” - Section 7.2.20, “
INFORMATION_SCHEMA
Optimization” - Section 13.6.13.2.3, “
InnoDB
Table Monitor Output” - Section 12.4.5.19, “
SHOW EVENTS
Syntax” - Section 9.1.7.8, “Collation and
INFORMATION_SCHEMA
Searches” - Section 11.3, “Control Flow Functions”
- Section 13.6.4, “Creating and Using
InnoDB
Tables” - 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 PARTITIONS
Table” - 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 FUNCTION
Syntax” - Section 13.6.13.2.3, “
InnoDB
Table Monitor Output” - Section 21.9.1, “C API Data Structures”
- 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 ROUTINES
Table”
update
user
- Section 12.4.1.2, “
DROP USER
Syntax” - 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 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”
variables
write_buffer_size