- 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 DATABASESyntax” - Section 12.4.1.3, “
GRANTSyntax” - 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, “
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: 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: 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 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.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 STATUSSyntax” - 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, “
MyISAMStartup 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
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-options- Section 13.5.1, “
MyISAMStartup 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
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-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 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--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 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.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 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.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 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.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, “
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- 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 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.5, “'
--' 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.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
MyISAMTables for Errors” - Section 6.6.3, “How to Repair
MyISAMTables” - Section 6.6.5, “Setting Up a
MyISAMTable 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
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-y N-–ndb-log-update-as-write=OFF-–ndb-log-updated-onlyAborted_connectsArbitrationArbitrationDelayArbitrationRankArbitrationTimeoutBackupDataBufferSizeBackupDataDirBackupLogBufferSizeBackupMaxWriteSizeBackupMemoryBackupReportFrequencyBackupWriteSizeBatchSizePerLocalScanChecksumCom_dealloc_sqlCom_deleteCom_execute_sqlCom_insertCom_prepare_sqlCom_selectCom_stmt_closeCom_stmt_executeCom_stmt_fetchCom_stmt_prepareCom_stmt_reprepareCom_stmt_resetCom_stmt_send_long_dataCompressedBackupCompressedLCPDataDir- 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”
DiskCheckpointSpeedDiskCheckpointSpeedInRestartDiskIOThreadPoolDiskPageBufferMemoryDiskSyncSizeExecuteOnComputerFileSystemPathFileSystemPathDD- 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”
FragmentLogFileSizeHeartbeatIntervalDbApiHeartbeatIntervalDbDbHeartbeatThreadPriority- 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 COLLATIONSyntax” - Section 12.4.5.31, “
SHOW PROCESSLISTSyntax” - 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 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”
InitFragmentLogFilesInitialLogFileGroupInitialNoOfOpenFilesInitialTablespaceLockExecuteThreadToCPULockMaintThreadsToCPULockPagesInMainMemoryLogDestinationLogLevelCheckpointLogLevelCongestionLogLevelConnectionLogLevelErrorLogLevelNodeRestartLogLevelShutdownLogLevelStartupLogLevelStatisticLongMessageBufferMaxAllocateMaxBufferedEpochsMaxLCPStartDelayMaxNoOfAttributesMaxNoOfConcurrentIndexOperationsMaxNoOfConcurrentOperationsMaxNoOfConcurrentScansMaxNoOfConcurrentSubOperationsMaxNoOfConcurrentTransactionsMaxNoOfExecutionThreadsMaxNoOfFiredTriggersMaxNoOfLocalOperationsMaxNoOfLocalScansMaxNoOfOpenFilesMaxNoOfOrderedIndexesMaxNoOfSavedMessagesMaxNoOfSubscribersMaxNoOfSubscriptionsMaxNoOfTablesMaxNoOfTriggersMaxNoOfUniqueHashIndexesMemReportFrequencyName- 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_idNoOfDiskPagesToDiskAfterRestartACCNoOfDiskPagesToDiskAfterRestartTUPNoOfDiskPagesToDiskDuringRestartACCNoOfDiskPagesToDiskDuringRestartTUPNoOfFragmentLogFilesNoOfReplicasNodeGroupNodeId1NodeId2OverloadLimitPortNumberQuestionsRealtimeSchedulerReceiveBufferMemoryReservedSendBufferMemoryRestartOnErrorInsertSchedulerExecutionTimerSchedulerSpinTimerSendBufferMemorySendLimitSendSignalIdSharedBufferSizeSharedGlobalMemorySlave_runningStartFailureTimeoutStartPartialTimeoutStartPartitionedTimeoutStartupStatusReportFrequencyTcpBind_INADDR_ANYText in this styleTimeBetweenEpochsTimeBetweenEpochsTimeoutTimeBetweenGlobalCheckpointsTimeBetweenInactiveTransactionAbortCheckTimeBetweenLocalCheckpointsTimeBetweenWatchDogCheckTimeBetweenWatchDogCheckInitialTotalSendBufferMemory- 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”
TransactionBufferMemoryTransactionDeadlockDetectionTimeoutTransactionInactiveTimeoutUndoDataBufferUndoIndexBuffer\G\s\tallansiauto_increment_incrementauto_increment_offsetautomatic_sp_privilegesbasedirc- Section 12.1.7, “
ALTER TABLESyntax” - Section 12.1.17, “
CREATE TABLESyntax” - Section 11.12.3, “
GROUP BYandHAVINGwith 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_clientcharacter_set_connectioncollation_connectioncompressconnect_timeoutcountddatadatadir- 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 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 PROCESSLISTTable” - Section 20.14, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 2.13.1, “Unix Post-Installation Procedures”
decode_bitsdefault-storage-enginedefault-table-typedefaults-extra-filedelimiterdescriptioneextended-statusflush-backup-logsflush-hostsflush-logsflush-privilegesflush-statusflush-tablesflush-threadsft_max_word_lenft_min_word_lenft_stopword_filegeneral_loghave_partition_enginehave_profilinghelphost- 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_useibmdb2i_async_enabledibmdb2i_compat_opt_allow_zero_date_valsibmdb2i_compat_opt_blob_colsibmdb2i_compat_opt_time_as_durationibmdb2i_compat_opt_year_as_intibmdb2i_create_index_optionibmdb2i_create_time_columns_as_todibmdb2i_lob_alloc_sizeibmdb2i_map_blob_to_varcharibmdb2i_max_read_buffer_sizeibmdb2i_max_write_buffer_sizeibmdb2i_propagate_default_col_valibmdb2i_propagate_default_col_valsibmdb2i_system_trace_levelibmdb2i_transaction_unsafeignore-builtin-innodbinit-fileinnodbinnodb-safe-binloginnodb-status-file=1innodb_file_per_tableinnodb_support_xainnodb_table_locksinteractive_timeoutkey_buffer_sizeledirlength- 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-updateslog_backup_outputlog_bin_trust_routine_creatorsmax_allowed_packetmax_connectionsmax_user_connectionsmulti_range_countmyisam_block_sizemyisam_max_extra_sort_file_sizemyisam_stats_methodmysql- 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.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
mysqlSystem Database” - Section B.5.4.1.2, “Resetting the Root Password: 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.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-servermysqlaccessmysqlbinlogmysqld- 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 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-binarymysqld_safemysqldumpmysqldumpslowmysqlhotcopymysqlslapndb-connectstringndb_autoincrement_prefetch_szndb_log_binlog_indexndb_optimization_delayndb_table_no_loggingndb_table_temporarynet_retry_countnet_write_timeoutnicenonguardedoffsetold-alter-tableopen-files-limitopen_files_limitppartitionpasswordperformance_schemapid-filepipepluginplugin-loadportprocesslistpurge-backup-logsquery_cache_typeread_buffer_sizereconnectrecord_bufferreplication-ignore-tableresolve_stack_dumprowsselect_limitserver-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-variableset-variable=option=valueshutdownshutdown_timeoutskip-innodbskip-networkingskip-slave-startslave_type_conversionsslow_query_logsocketsort_buffer_sizesort_key_blockssourcesql-mode=""sql-mode="modes"sql_big_tablessql_log_updatesql_low_priority_updatessql_max_join_sizestart-slavestats_methodstatus- 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-slavesyslogtabletable_typetest- 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 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 ROUTINESTable”
updateuser- 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 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”
variableswrite_buffer_size