-
- Section 12.1.1, “
ALTER DATABASEСинтаксис” - Section 11.18.2, “
DECIMALData Type Changes” - Section 12.7.1.3, “
GRANTСинтаксис” - Section 11.6.1, “Arithmetic Operators”
- Section 11.9.2, “Boolean Full-Text Searches”
- Section 10.6, “Choosing the Right Type for a Column”
- Section 11.7, “Date and Time Functions”
- Section 10.2.2, “Fixed-Point Types (Exact Value)”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 8.1.2, “Number Literals”
- Section 10.1.1, “Numeric Type Overview”
- Section 11.5.2, “Regular Expressions”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 5.4.3, “Specifying Account Names”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- 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-drop-trigger
--add-locks
--addtodest
--all-databases
- Описание
- Описание
- Описание
- Section 2.11.2.1, “Downgrading to MySQL 5.1”
- Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
- Section 8.2.3, “Mapping of Identifiers to File Names”
- Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
- Section 6.4.2, “Reloading SQL-Format Backups”
- Section 16.5.9, “The
ndbinfoMySQL Cluster Information Database”
--all-in-1
--all-tablespaces
--allow-keywords
--allow-suspicious-udfs
--allowold
--analyze
--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-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
--autocommit=0
--base64-output
--base64-output=ALWAYS
--base64-output=AUTO
--base64-output=DECODE-ROWS
--base64-output=NEVER
--base64-output[=value]
--basedir
- Описание
- Описание
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 16.1.6.1, “Noncompliance with SQL Синтаксис in MySQL Cluster”
- Section 16.1.6.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 Instances on One Machine”
- Section 5.1.3, “Server System Variables”
- Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.10.1, “Unix Postinstallation Procedures”
--basedir=path
--bdb-logdir
--bdb-logdir=file_name
--bdb-shared-data
--bdb-tmpdir=path
--big-tables
--bind-address
--bind-address=127.0.0.1
--bind-address=IP
--bind-address=ip_address
--binlog-checksum={NONE|CRC32}
--binlog-do-db
- Section 15.1.3.4, “Binary Log Options and Variables”
- Описание
- Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.6.3, “Known Issues in MySQL Cluster Replication”
- Section 15.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 15.1.3.4, “Binary Log Options and Variables”
- Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 16.6.3, “Known Issues in MySQL Cluster Replication”
- Section 15.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
--binlog-rows-query-log-events
--binlog_format=STATEMENT
--block-search=offset
--bootstrap
--brief
--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 15.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 1.4, “What Is New in MySQL 5.5”
--character-set-server=charset_name
--character-set-server=latin1
--character-sets-dir
--character-sets-dir=path
--character_set_server
--charset=path
--check-only-changed
--checkpoint
--checkpoint=db_name.tbl_name
--chroot
--chroot=path
--collation-server
- Section 9.5, “Character Set Configuration”
- Section 9.1.5, “Configuring the Character Set and Collation for Applications”
- Section 15.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 1.4, “What Is New in MySQL 5.5”
--collation-server=collation_name
--collation-server=latin1_swedish_ci
--collation_server
--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=path_name
--console
- Section 13.3.14.3, “
InnoDBGeneral Troubleshooting” - Section 13.3.14.2, “
SHOW ENGINE INNODB STATUSand theInnoDBMonitors” - Section 13.3.3.2, “Creating the
InnoDBTablespace” - Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
- Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
- Section 5.1.2, “Server Command Options”
- Section 2.3.6.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=N
--create
--create-and-drop-schema
--create-and-drop-schema=value
--create-options
--create-schema=value
--create=value
--csv[=file_name]
--daemon
--data-file-length=len
--database
--database=db_name
--databases
- Section 6.4.5.2, “Copy a Database from one Server to Another”
- Описание
- Описание
- Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
- Section 6.4.5.1, “Making a Copy of a Database”
- Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
- Section 6.4.2, “Reloading SQL-Format Backups”
- Section 16.5.9, “The
ndbinfoMySQL Cluster Information Database”
--datadir
- Section 2.3.6.2, “Creating an Option File”
- Описание
- Описание
- Описание
- Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.1.3, “Server System Variables”
- Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 2.10.1, “Unix Postinstallation 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=d,general,query
--debug=debug_options
--debug[=debug_options]
--default-auth
--default-auth=plugin
--default-auth=plugin_name
--default-character-set
- Section 12.2.6, “
LOAD DATA INFILEСинтаксис” - Section 9.1.4, “Connection Character Sets and Collations”
- Описание
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 5.5.1, “User Names and Passwords”
- Section 1.4, “What Is New in MySQL 5.5”
--default-character-set=charset_name
--default-character-set=latin1
--default-character-set=system_character_set
--default-character-set=utf8
--default-collation=collation_name
--default-storage-engine
- Section 13.3.4, “
InnoDBStartup Options and System Variables” - Section 13.3.2, “Configuring
InnoDB” - Section 5.1.7.1, “Installing and Uninstalling Plugins”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 13.1, “Setting the Storage Engine”
- Глава 13, Storage Engines
- Section 1.4, “What Is New in MySQL 5.5”
--default-storage-engine=type
--default-table-type
--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 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
- Section 13.3.2, “Configuring
InnoDB” - Описание
- Section 21.8.3, “Options with the Embedded Server”
- Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
- Section 5.6, “Running Multiple MySQL Instances on One Machine”
- Section 5.6.3, “Running Multiple MySQL Instances on Unix”
- Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
- Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
- Section 2.3.6.7, “Starting MySQL as a Windows Service”
- Section 2.3.5.1, “Starting the MySQL Server Instance Configuration Wizard”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
--defaults-file=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=ON
--delayed-insert
--delete
--delete-master-logs
--delimiter
--delimiter=str
--demangle
--des-key-file
--des-key-file=file_name
--description
--detach=N
--disable-auto-rehash
--disable-community-features
--disable-debug-sync
--disable-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-local-infile
--enable-named-pipe
--enable-plugin_name
--enable-profiling
--enable-thread-safe-client
--engine-condition-pushdown=1
--engine=engine_name
--event-scheduler
--event-scheduler=DISABLED
--event-scheduler[=value]
--events
--example
--execute
--execute=statement
--exit-info[=flags]
--extend-check
--extended
--extended-insert
--external-locking
--extra-file=file_name
--fields-enclosed-by
--fields-enclosed-by=char
--fields-escaped-by=char
--fields-optionally-enclosed-by=char
--fields-terminated-by=str
--fields-xxx
--first-slave
--fix-db-names
--fix-table-names
--flush
--flush-privileges
--flush_time=val
--flushlog
--force
--force-read
--foreground
--general-log
--general-log[={0|1}]
--general_log
--general_log[={0|1}]
--general_log_file=file_name
--header_file=file_name
--help
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
- Section 4.1, “Overview of MySQL Programs”
- Section 5.1.2, “Server Command Options”
- Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.11.2, “Tuning Server Parameters”
- Глава 3, Tutorial
- Section 2.10.1, “Unix Postinstallation 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 Ошибки”
- Section 4.2.2, “Connecting to the MySQL Server”
- Описание
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 1.2, “Typographical and Синтаксис Conventions”
- Section 5.6.4, “Using Client Programs in a Multiple-Server Environment”
--host=127.0.0.1
--host=host_name
--host=localhost
--howto
--ignore
--ignore-builtin-innodb
--ignore-db-dir
--ignore-db-dir=
--ignore-db-dir=dir_name
--ignore-db-dir=lost+found
--ignore-lines=N
--ignore-spaces
--ignore-table=db_name.tbl_name
--in_file=file_name
--include
--include-master-host-port
--information
--init-file
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 20.2.3, “Performance Schema Runtime Configuration”
- Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
- Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
- Section 5.1.3, “Server System Variables”
- Section 13.6, “The
MEMORYStorage Engine”
--init-file=file_name
--init-rpl-role
--init_connect="SET NAMES 'utf8'"
--initial
- Section 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
- Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Пример”
- Section 16.5.2, “Commands in the MySQL Cluster Management Client”
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Описание
- Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
- Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
- Section 16.6.3, “Known Issues in MySQL Cluster Replication”
- Section 16.1.6.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
- Section 16.3.2, “MySQL Cluster Configuration Files”
- Section 16.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
- Section 16.5.11.3, “MySQL Cluster Disk Data Storage Requirements”
- Section 16.3.3.2, “MySQL Cluster Management Node Configuration Parameters”
- Section 16.3.3.3, “MySQL Cluster SQL Node and API Node Configuration Parameters”
- Section 16.3.3.4, “Other MySQL Cluster Configuration Parameters”
- Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”
- Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
- Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
- Section 16.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=OFF
--innodb[=value]
--innodb_checksums
--innodb_file_per_table
--innodb_locks_unsafe_for_binlog
--innodb_rollback_on_timeout
--innodb_support_xa
--insert-ignore
--install
--install [service_name]
--install-manual
--install-manual [service_name]
--install[=name]
--iterations=N
--join=big_tbl_name
--keep_files_on_create
--keepold
--key_buffer_size=32M
--keys
--keys-used=val
--language
--language=lang_name, -L lang_name
--large-pages
--lc-messages
--lc-messages-dir
--lc-messages-dir=path
--lc-messages=locale_name
--ldata=path
--ledir
--ledir=path
--length
--libmysqld-libs
--libs
--libs_r
--line-numbers
--lines-terminated-by
--lines-terminated-by="\r\n"
--lines-terminated-by=str
--local
--local-infile
--local-infile=0
--local-infile=1
--local-infile=OFF
--local-infile[=1]
--local-infile[={0|1}]
--local-load
--local-load=path
--local-service
--lock-all-tables
--lock-directory
--lock-directory=path
--log
--log-bin
- Section 12.4.2.1, “
CHANGE MASTER TOСинтаксис” - Section 12.4.1.1, “
PURGE BINARY LOGSСинтаксис” - Section 6.3.3, “Backup Strategy Summary”
- Section 15.1.3.4, “Binary Log Options and Variables”
- Section 18.7, “Binary Logging of Stored Programs”
- Section 6.2, “Database Backup Methods”
- Section 6.3.1, “Establishing a Backup Policy”
- Section 15.4.5, “How to Report Replication Bugs or Problems”
- Section 16.1.6.1, “Noncompliance with SQL Синтаксис in MySQL Cluster”
- Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 5.2.6, “Server Log Maintenance”
- Section 5.1.3, “Server System Variables”
- Section 15.3.6, “Switching Masters During Failover”
- Section 5.2.4, “The Binary Log”
- Section 15.4.4, “Troubleshooting Replication”
- Section 15.4.3, “Upgrading a Replication Setup”
- Section 6.3.2, “Using Backups for Recovery”
- Section 1.4, “What Is New in MySQL 5.5”
--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-use-v1-events
--log-bin-use-v1-row-events
--log-bin-use-v1-row-events[={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-output
--log-output=TABLE
--log-output=TABLE,FILE
--log-output[=value,...]
--log-queries-not-using-indexes
--log-raw
--log-short-format
--log-slave-updates
- Section 15.4.5, “How to Report Replication Bugs or Problems”
- Section 15.3.5, “Improving Replication Performance”
- Section 16.6.3, “Known Issues in MySQL Cluster Replication”
- Section 16.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”
- Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.3.6, “Switching Masters During Failover”
- Section 5.2.4, “The Binary Log”
--log-slow-admin-statements
--log-slow-queries
--log-slow-queries[=file_name]
--log-slow-slave-statements
--log-tc-size
--log-tc-size=size
--log-tc=file_name
--log-update
--log-warnings
--log-warnings=0
--log-warnings=2
--log-warnings[=level]
--log=file_name
--log[=file_name]
--loose
--loose-opt_name
--loose-skip-innodb
--low-priority
--low-priority-updates
--lower-case-table-names=0
--malloc-lib
--malloc-lib=
--malloc-lib=/path/to/some/library
--malloc-lib=[lib_name]
--malloc-lib=tcmalloc
--master-connect-retry
--master-connect-retry=seconds
--master-data
--master-data=2
--master-data[=value]
--master-host
--master-host=host_name
--master-info-file
--master-info-file=file_name
--master-info-repository
--master-info-repository=TABLE
--master-info-repository={FILE|TABLE}
--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-verify-checksum={0|1}
--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
--maximum-query_cache_size=32M
--maximum-query_cache_size=4M
--maximum-var_name=value
--medium-check
--memlock
--method=command
--min-examined-row-limit=number
--my-plugin=ON
--my-print-defaults=path
--my_plugin=ON
--myisam-block-size
--myisam-block-size=N
--myisam-recover
- Section 13.5.1, “
MyISAMStartup Options” - Section 7.2.5, “Other Optimization Tips”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 6.6.5, “Setting Up a
MyISAMTable Maintenance Schedule” - Section C.5.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAMStorage Engine” - Section 22.5.1.6, “Using Server Logs to Find Causes of Ошибки in mysqld”
--myisam-recover-options
- Section 13.5.1, “
MyISAMStartup Options” - Section 7.6.1, “Optimizing
MyISAMQueries” - Section 7.2.5, “Other Optimization Tips”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 6.6.5, “Setting Up a
MyISAMTable Maintenance Schedule” - Section C.5.2.19, “Table-Corruption Issues”
- Section 13.5, “The
MyISAMStorage Engine” - Section 22.5.1.6, “Using Server Logs to Find Causes of Ошибки 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]...]]
--mysqladmin=prog_name
--mysqld-version
--mysqld-version=debug
--mysqld-version=suffix
--mysqld=mysqld_safe
--mysqld=path
--name_file=file_name
--named-commands
--ndb
--ndb-batch-size=#
--ndb-blob-read-batch-bytes=bytes
--ndb-blob-write-batch-bytes=bytes
--ndb-cluster-connection-pool
--ndb-cluster-connection-pool=#
--ndb-cluster-connection-pool=4
--ndb-connectstring
- Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.1.1, “MySQL Cluster Core Concepts”
- Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
- Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
- Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”
--ndb-connectstring=connect_string
--ndb-connectstring=management_host
--ndb-deferred-constraints=[TRUE|FALSE]
--ndb-distribution=[KEYHASH|LINHASH]
--ndb-force-send=1
--ndb-index-stat-enable=0
--ndb-log-apply-status
--ndb-log-empty-epochs
--ndb-log-empty-epochs=0
--ndb-log-empty-epochs=1
--ndb-log-empty-epochs=[0|1]
--ndb-log-transaction-id
--ndb-log-update-as-write
--ndb-log-update-as-write=0
--ndb-log-update-as-write=OFF
--ndb-log-updated-only
--ndb-use-exact-count=0
--ndb-wait-connected=seconds
--ndb-wait-setup=seconds
--ndb_optimization_delay=milliseconds
--ndb_optimized_node_selection
--ndbcluster
- Section 12.7.5.17, “
SHOW ENGINESСинтаксис” - Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.3, “MySQL Cluster Configuration”
- Section 16.1.1, “MySQL Cluster Core Concepts”
- Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
- Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
- Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
- Section 16.3.2.2, “Recommended Starting Configuration for MySQL Cluster”
- Section 16.5.9, “The
ndbinfoMySQL Cluster Information Database”
--ndbcluster --ndb-connectstring=management_host
--ndbinfo-database=name
--ndbinfo-table-prefix
--nice=priority
--no-auto-rehash
--no-autocommit
--no-defaults
--no-log
--no-named-commands
--no-set-names
--no-symlinks
--no-tablespaces
--nodaemon
--noindices
--nowait-nodes
--nowait-nodes=3
--nowait-nodes=3,5
--nowait-nodes=node_id_1[, node_id_2[, ...]]
--number-char-cols=N
--number-int-cols=N
--number-of-queries=N
--numeric-dump-file=file_name
--offset=N
--old-alter-table
--old-passwords
--old-style-user-limits
--one-database
--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
--pager[=command]
--parallel-recover
--partition[=value]
--password
- Section 4.5.1.1, “mysql Options”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 4.2.2, “Connecting to the MySQL Server”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 5.3.2.2, “End-User Guidelines for Password Security”
- Section 6.3, “Пример Backup and Recovery Strategy”
- Section 4.2.1, “Invoking MySQL Programs”
- Section C.5.2.5, “Password Fails When Entered Interactively”
- Section 5.5.6, “Pluggable Authentication”
- Section 5.5.6.6, “The Test Authentication Plugin”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.1, “Using Options on the Command Line”
--password=pass_val
--password=your_pass
--password[=pass_val]
--password[=password]
--performance_schema_consumer_consumer_name=value
--performance_schema_instrument
--performance_schema_instrument=instrument_name=value
--performance_schema_max_mutex_classes=200
--performance_schema_max_mutex_classes=N
--performance_schema_max_mutex_instances=N
--pid-file=file_name
--pid-file=path
--pipe
--plan
--plugin-dir
--plugin-dir=dir_name
--plugin-dir=path
--plugin-dir=path_name
--plugin-ini=file_name
--plugin-innodb_file_per_table
--plugin-load
- Section 12.7.3.3, “
INSTALL PLUGINСинтаксис” - Описание
- Section 5.1.7.1, “Installing and Uninstalling Plugins”
- Section 5.5.6.2.1, “Installing the PAM Authentication Plugin”
- Section 5.5.6.3.1, “Installing the Windows Authentication Plugin”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.5.6, “Pluggable Authentication”
- Section 22.2.2, “Plugin API Components”
- Section 22.2.4.2, “Plugin Data Structures”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
- Section 22.2, “The MySQL Plugin API”
- Section 7.11.6.1, “Thread Pool Components and Installation”
- Section 22.2.4.9.3, “Using the Authentication Plugins”
--plugin-load-add
--plugin-load-add=plugin_list
--plugin-load=auth_simple.so
--plugin-load=plugin_list
--plugin-sql-mode
--plugin-xxx
--plugin_dir=path
--plugin_name=0
--plugin_name=1
--plugin_name=FORCE
--plugin_name=FORCE_PLUS_PERMANENT
--plugin_name=OFF
--plugin_name=ON
--plugin_name[=ON]
--plugindir
--port
- Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 4.2.2, “Connecting to the MySQL Server”
- Описание
- Описание
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.6, “Running Multiple MySQL Instances on One Machine”
- Section 5.6.3, “Running Multiple MySQL Instances on Unix”
- Section 5.1.3, “Server System Variables”
- Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 5.6.4, “Using Client Programs in a Multiple-Server Environment”
--port-open-timeout=num
--port=port_num
--port=port_number
--position=N
--post-query=value
--post-system=str
--pre-query=value
--pre-system=str
--prefix
--preserve-schema
--preview
--print-defaults
--prompt=format_str
--protocol=MEMORY
--protocol=PIPE
--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
- Section 15.3.5, “Improving Replication Performance”
- Section 15.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.2.2.1, “The Slave Relay Log”
--relay-log-index
--relay-log-index=file_name
--relay-log-info-file
--relay-log-info-file=file_name
--relay-log-info-repository
--relay-log-info-repository=TABLE
--relay-log-info-repository={FILE|TABLE}
--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
- Section 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
- Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Пример”
- Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
- Section 16.1.6.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
- Section 16.3.2, “MySQL Cluster Configuration Files”
- Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
--remove
--remove [service_name]
--remove[=name]
--repair
--replicate-*
--replicate-*-db
--replicate-*-table
--replicate-[do|ignore]-table
--replicate-do-*
--replicate-do-db
- Section 12.7.5.35, “
SHOW SLAVE STATUSСинтаксис” - Section 12.3.1, “
START TRANSACTION,COMMIT, andROLLBACKСинтаксис” - Section 15.1.3.4, “Binary Log Options and Variables”
- Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 15.3.4, “Replicating Different Databases to Different Slaves”
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.4.1.22, “Replication and Reserved Words”
- Section 15.4.1.19, “Replication and Temporary Tables”
- Section 5.2.4, “The Binary Log”
- Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
--replicate-do-db=db1
--replicate-do-db=db_name
--replicate-do-db=dbx
--replicate-do-db=mysql
--replicate-do-db=sales
--replicate-do-table
- Section 12.7.5.35, “
SHOW SLAVE STATUSСинтаксис” - Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
- Section 15.2.3.3, “Replication Rule Application”
- Section 15.4.1.22, “Replication and Reserved Words”
- Section 15.4.1.19, “Replication and Temporary Tables”
- Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
--replicate-do-table=db_name.tbl_name
--replicate-do-table=mysql.ndb_apply_status
--replicate-ignore-*
--replicate-ignore-db
- Section 12.7.5.35, “
SHOW SLAVE STATUSСинтаксис” - Section 12.3.1, “
START TRANSACTION,COMMIT, andROLLBACKСинтаксис” - Section 15.1.3.4, “Binary Log Options and Variables”
- Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 15.2.3.3, “Replication Rule Application”
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.4.1.22, “Replication and Reserved Words”
- Section 5.2.4, “The Binary Log”
- Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
--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=from_name->to_name
--replicate-same-server-id
--replicate-wild-do-table
- Section 12.7.5.35, “
SHOW SLAVE STATUSСинтаксис” - Section 15.2.3.2, “Evaluation of Table-Level Replication Options”
- Section 15.2.3, “How Servers Evaluate Replication Filtering Rules”
- Section 15.3.4, “Replicating Different Databases to Different Slaves”
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.4.1.19, “Replication and Temporary Tables”
--replicate-wild-do-table=databaseA.%
--replicate-wild-do-table=databaseB.%
--replicate-wild-do-table=databaseC.%
--replicate-wild-do-table=db%.t1
--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=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
--result-file=file_name
--result-file=name
--rhost=host_name
--rollback
--routines
--rows=N
--rpl-recovery-rank
--rpm
--safe-mode
--safe-recover
--safe-show-database
--safe-updates
--safe-user-create
--secure-auth
--secure-file-priv
--secure-file-priv=path
--select_limit
--server-id
--server-id-bits
--server-id-bits=#
--server-id-bits=N
--server-id=value
--service-startup-timeout=file_name
--set-auto-increment[=value]
--set-character-set=name
--set-charset
--set-charset=charset_name
--set-collation
--set-collation=name
--set-variable
--set-variable=option=value
--set-variable=var_name=value
--shared-memory
--shared-memory-base-name
--shared-memory-base-name=name
--short-form
--show-slave-auth-info
--show-table-type
--show-warnings
--sigint-ignore
--silent
--single-transaction
--skip-add-drop-table
--skip-add-locks
--skip-auto-rehash
--skip-base64-output
--skip-character-set-client-handshake
--skip-column-names
--skip-comments
--skip-compact
--skip-concurrent-insert
--skip-disable-keys
--skip-dump-date
--skip-engine_name
--skip-event-scheduler
--skip-extended-insert
--skip-external-locking
--skip-grant-tables
- Section 12.7.3.1, “
CREATE FUNCTIONСинтаксис for User-Defined Functions” - Section 12.7.3.3, “
INSTALL PLUGINСинтаксис” - Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
- Описание
- Описание
- Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
- Section 2.11.2.1, “Downgrading to MySQL 5.1”
- Section 18.4.2, “Event Scheduler Configuration”
- Section 5.1.7.1, “Installing and Uninstalling Plugins”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.5.6, “Pluggable Authentication”
- Section 2.10.1.1, “Problems Running mysql_install_db”
- Section C.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.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
- 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.3.4, “
InnoDBStartup Options and System Variables” - Section 12.7.5.17, “
SHOW ENGINESСинтаксис” - Section 13.3.2, “Configuring
InnoDB” - Section 5.1.7.1, “Installing and Uninstalling Plugins”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”
--skip-innodb-checksums
--skip-innodb_adaptive_hash_index
--skip-innodb_checksums
--skip-innodb_doublewrite
--skip-kill-mysqld
--skip-line-numbers
--skip-lock-tables
--skip-locking
--skip-log-warnings
--skip-merge
--skip-name-resolve
- Section 5.4.7, “Causes of Access-Denied Ошибки”
- Описание
- Section 7.11.5.2, “How MySQL Uses DNS”
- Section 2.10.2, “Securing the Initial MySQL Accounts”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 2.3.6.8, “Testing The MySQL Installation”
--skip-named-commands
--skip-ndbcluster
--skip-networking
- Section C.5.2.2, “
Can't connect to [local] MySQL server” - Section C.5.2.9, “
MySQL server has gone away” - Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 7.11.5.2, “How MySQL Uses DNS”
- Section 5.5.6, “Pluggable Authentication”
- Section C.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 5.1.3, “Server System Variables”
- Section 15.4.3, “Upgrading a Replication Setup”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
--skip-new
--skip-opt
--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.4.2.1, “
CHANGE MASTER TOСинтаксис” - Section 12.4.2.5, “
START SLAVEСинтаксис” - Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.3.7, “Setting Up Replication Using SSL”
- Section 15.1.1.8, “Setting Up Replication with Existing Data”
- Section 15.4.4, “Troubleshooting Replication”
- Section 15.4.3, “Upgrading a Replication Setup”
--skip-ssl
--skip-stack-trace
--skip-super-large-pages
--skip-symbolic-links
- Section 12.1.17, “
CREATE TABLEСинтаксис” - Section 5.3.3, “Making MySQL Secure Against Attackers”
- Section 5.1.2, “Server Command Options”
- Section 7.11.3.1.3, “Using Symbolic Links for Databases on Windows”
- Section 7.11.3.1.2, “Using Symbolic Links for Tables on Unix”
- Section 1.4, “What Is New in MySQL 5.5”
--skip-symlink
--skip-syslog
--skip-thread-priority
--skip-triggers
--skip-tz-utc
--skip-use-db
--skip-xxx
--skip_grant_tables
--slave
--slave-load-tmpdir
--slave-load-tmpdir=file_name
--slave-net-timeout
--slave-net-timeout=seconds
--slave-parallel-workers
--slave-skip-errors
--slave-skip-errors=[err_code1,err_code2,...|all]
--slave-sql-verify-checksum
--slave-sql-verify-checksum={0|1}
--slave_compressed_protocol={0|1}
--sleep
--sleep=delay
--slow-query-log
--slow-query-log[={0|1}]
--slow-start-timeout=timeout
--slow_query_log
--slow_query_log[={0|1}]
--slow_query_log_file
--slow_query_log_file=file_name
--socket
- Section C.5.2.2, “
Can't connect to [local] MySQL server” - Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 4.2.2, “Connecting to the MySQL Server”
- Описание
- Описание
- Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.6, “Running Multiple MySQL Instances on One Machine”
- Section 5.6.3, “Running Multiple MySQL Instances on Unix”
- Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
- Section 2.3.6.8, “Testing The MySQL Installation”
- Section 5.6.4, “Using Client Programs in a Multiple-Server Environment”
--socket=/path/to/socket
--socket=file_name
--socket=path
--sort-records=N
--sort-records=index_num
--sort-recover
--sort_buffer_size=16M
--spassword
--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=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”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 5.5.8.3, “SSL Command Options”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.5.8.2, “Using SSL Connections”
--ssl*
--ssl-ca
--ssl-ca=file_name
--ssl-capath
--ssl-capath=dir_name
--ssl-capath=directory_name
--ssl-cert
--ssl-cert=file_name
--ssl-cipher=cipher_list
--ssl-crl=file_name
--ssl-crlpath
--ssl-crlpath=dir_name
--ssl-key
--ssl-key=file_name
--ssl-verify-server-cert
--ssl-xxx
--standalone
--start-datetime=datetime
--start-position
--start-position=N
--start_row=N
--statefile=file_name
--stats
--status
--stop-datetime=datetime
--stop-never
--stop-never-slave-server-id
--stop-never-slave-server-id=id
--stop-position=N
--suffix=str
--super-large-pages
--superuser=user_name
--symbols-file=file_name
--sysconfdir
--sysdate-is-now
- Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 11.7, “Date and Time Functions”
- Section 15.4.1.11, “Replication and System Functions”
- Section 5.1.2, “Server Command Options”
- Section 5.1.3, “Server System Variables”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
--syslog-tag=tag
--tab
--tab=path
--table_cache
--table_open_cache
--tc-heuristic-recover={COMMIT|ROLLBACK}
--tcp-ip
--tee=file_name
--temp-pool
--test
--thread_cache_size=5'
--thread_handling=no-threads
--timezone
--timezone=timezone
--timezone=timezone_name
--tmpdir
--tmpdir=path
--to-last-log
--transaction-isolation
--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 C.5.2.18, “'
File' Not Found and Similar Ошибки” - Описание
- Описание
- Описание
- Section 6.3, “Пример Backup and Recovery Strategy”
- Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
- Section 4.2.1, “Invoking MySQL Programs”
- Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the
=Sign” - Section 5.5.6, “Pluggable Authentication”
- Section 5.1.2, “Server Command Options”
- Section 5.5.6.5, “The Socket Peer-Credential Authentication Plugin”
- Section 5.5.6.6, “The Test Authentication Plugin”
- Section 2.10.1, “Unix Postinstallation Procedures”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 5.5.1, “User Names and Passwords”
- Section 4.2.3.3, “Using Option Files”
--user=mysql
--user=root
--user=user_name
--user={user_name|user_id}
--var_name=value
--verbose
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 4.5.1.5, “Executing SQL Statements from a Text File”
- Section 4.6.3.4, “Other myisamchk Options”
- Section 5.1.2, “Server Command Options”
- Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
- Section 7.11.2, “Tuning Server Parameters”
- Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
- 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”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
--wait[=count]
--warnings
--where='where_condition'
--windows
--with-archive-storage-engine
--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 22.5.2, “Debugging a MySQL Client”
- Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.1.2, “Server Command Options”
- Section C.5.4.2, “What to Do If MySQL Keeps Crashing”
--with-debug=full
--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-libwrap
--with-low-memory
--with-max-indexes=N
--with-mysql-sock[=DIR]
--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-ndbcluster
--with-openssl
--with-partition
--with-pdo-mysql[=DIR]
--with-plugin-PLUGIN
--with-plugins
--with-plugins=max
--with-plugins=max-no-innodb
--with-plugins=ndbcluster
--with-ssl
--with-ssl=path
--with-tcp-port
--with-unix-socket-path
--with-vio
--with-zlib-dir=no|bundled|DIR
--with-zlib-dir[=DIR]
--without-plugin-PLUGIN
--without-query-cache
--without-server
--xml
-1
- Section 1.8.5.5, “'
--' as the Start of a Comment” - Section 17.2.4, “
HASHPartitioning” - Section 21.9.3.1, “
mysql_affected_rows()” - Section 11.3.2, “Comparison Functions and Operators”
- Описание
- Section 11.6.2, “Mathematical Functions”
- Section 11.15, “Miscellaneous Functions”
- Section 11.5.1, “String Comparison Functions”
-?
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-C
-C charset_name
-C path
-D db_name
-D path
-DBUILD_CONFIG=mysql_release
-DCMAKE_BUILD_TYPE=Debug
-DCMAKE_INSTALL_PREFIX=dir_name
-DCPACK_MONOLITHIC_INSTALL=1
-DDEFAULT_CHARSET=MYSET
-DDEFAULT_CHARSET=charset_name
-DENABLED_LOCAL_INFILE=1
-DENABLE_DEBUG_SYNC=0
-DENABLE_DEBUG_SYNC=1
-DENABLE_DTRACE=0
-DENABLE_DTRACE=1
-DINSTALL_SQLBENCHDIR=
-DMEMCACHED_HOME=path
-DSAFEMALLOC
-DUSE_ALARM_THREAD
-DWITHOUT_PERFSCHEMA_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE
-DWITH_BLACKHOLE_STORAGE_ENGINE
-DWITH_BUNDLED_LIBEVENT=OFF
-DWITH_BUNDLED_MEMCACHED=OFF
-DWITH_DEBUG=1
- Section 2.1.2.2, “Choosing a Distribution Format”
- Section 22.5.1.1, “Compiling MySQL for Debugging”
- Section 22.5.2, “Debugging a MySQL Client”
- Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
- Section 2.9.4, “MySQL Source-Configuration Options”
- Section 5.1.2, “Server Command Options”
- Section C.5.4.2, “What to Do If MySQL Keeps Crashing”
-DWITH_EMBEDDED_SERVER=1
-DWITH_EXAMPLE_STORAGE_ENGINE
-DWITH_EXTRA_CHARSETS=all
-DWITH_EXTRA_CHARSETS=charset_name
-DWITH_EXTRA_CHARSETS=complex
-DWITH_FEDERATED_STORAGE_ENGINE
-DWITH_LIBWRAP=1
-DWITH_PARTITION_STORAGE_ENGINE
-DWITH_SSL=system
-DWITH_ZLIB={system|bundled}
-F file_name
-F str
-H file_name
-H host_name
-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 port_num
-P[password]
-Q
-R index_num
-R record_pos_file record_pos
-S
-S path
-T
-T [flags]
-U user_name
-V
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 5.1.2, “Server Command Options”
- Section 4.2.3.1, “Using Options on the Command Line”
-W
-W [level]
-a
-b path
-c
-c column_list
-c file_name
-d
-d path
-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”
- Section 12.2.7, “
LOAD XMLСинтаксис” - Описание
- Описание
- Section 6.6.2, “How to Check
MyISAMTables for Ошибки” - Section 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
- Section 16.5.15.4, “NDB Engine Configuration”
- Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 16.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
-e "configuration_string"
-e reconf=false
-e engine_name
-e file_name
-e num
-e statement
-f
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Section 16.5.2, “Commands in the MySQL Cluster Management Client”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 16.2.4, “Initial Startup of MySQL Cluster”
- Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
-f N
-felide-constructors
-fno-exceptions
-fno-rtti
-fomit-frame-pointer
-g pattern
-g suffix
-h
-h host_name
-i
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.5.1.1, “mysql Options”
- Section 16.5.2, “Commands in the MySQL Cluster Management Client”
- Описание
- Описание
- Описание
- Описание
- Section 6.6.2, “How to Check
MyISAMTables for Ошибки” - Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
- Section 22.5.1.3, “Using
pdbto create a Windows crashdump”
-i N
-i delay
-i file_name
-i name
-j N
-j big_tbl_name
-k
-l
-l path
-libmysqlclient
-lmysqlclient
-lmysqlclient -lz
-lmysqld
-lz
-m
-n
-n N
-n file_name
-o
-o N
-o noatime
-o offset
-p
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Section 17.2.5, “
KEYPartitioning” - Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Пример”
- Section 5.5.2, “Adding User Accounts”
- Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 4.2.2, “Connecting to the MySQL Server”
- Section 3.3.1, “Creating and Selecting a Database”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 5.3.2.2, “End-User Guidelines for Password Security”
- Section 4.2.1, “Invoking MySQL Programs”
- Section C.5.2.5, “Password Fails When Entered Interactively”
- Section 2.10.2, “Securing the Initial MySQL Accounts”
- Section 2.3.6.7, “Starting MySQL as a Windows Service”
- Section 2.3.6.5, “Starting MySQL from the Windows Command Line”
- Section 2.3.6.8, “Testing The MySQL Installation”
- Section 2.3.8, “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.3.9, “Windows Postinstallation Procedures”
-p N
-p num
-p path
-p[pass_val]
-p[password]
-ppassword
-q
-q value
-r
- Section 4.6.3.2, “myisamchk Check Options”
- Section 4.6.3.3, “myisamchk Repair Options”
- Section 4.5.1.1, “mysql Options”
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 6.6.3, “How to Repair
MyISAMTables” - Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
-r file_name
-r name
-s
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 6.6.2, “How to Check
MyISAMTables for Ошибки” - Section 6.6.3, “How to Repair
MyISAMTables” - Section 2.3.5.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
- 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 number_of_worker_threads
-t N
-u
-u {user_name|user_id}
-u user_name
-v
- Section 4.6.3.1, “myisamchk General Options”
- Section 4.5.1.1, “mysql Options”
- Section 4.6.7.2, “mysqlbinlog Row Event Display”
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Описание
- Section 6.6.2, “How to Check
MyISAMTables for Ошибки” - Section 4.6.3.5, “Obtaining Table Information with myisamchk”
- 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
/uninstall
Arbitration
ArbitrationDelay
ArbitrationRank
ArbitrationTimeout
BackupDataBufferSize
BackupDataDir
BackupLogBufferSize
BackupMaxWriteSize
BackupMemory
BackupReportFrequency
BackupWriteSize
BatchSize
BatchSizePerLocalScan
BuildIndexThreads
CMAKE_INSTALL_PREFIX
Checksum
Com_alter_event
Com_create_event
Com_dealloc_sql
Com_delete
Com_execute_sql
Com_prepare_sql
Com_select
Com_show_create_event
Com_show_events
Com_stmt_close
Com_stmt_execute
Com_stmt_fetch
Com_stmt_prepare
Com_stmt_reprepare
Com_stmt_reset
Com_stmt_send_long_data
CompressedBackup
ConnectCheckIntervalDelay
CrashOnCorruptedTuple
DEFAULT_CHARSET
DEFAULT_COLLATION
DISABLE_GRANT_OPTIONS
DataDir
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
- Описание
- Section 16.5.5, “Event Reports Generated in MySQL Cluster”
- Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.5, “Management of MySQL Cluster”
- Section 16.5.11.1, “MySQL Cluster Disk Data Objects”
- Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
- Section 16.3.1, “Quick Test Setup of MySQL Cluster”
- Section 16.5.11.2, “Using Symbolic Links with Disk Data Objects”
- Section 16.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
DataMemory
- Section C.5.2.12, “
The table is full” - Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
- Section E.10.3, “Limits on Table Size”
- Section 16.5, “Management of MySQL Cluster”
- Section 16.3.2.1, “MySQL Cluster Configuration: Basic Пример”
- Section 16.5.11.3, “MySQL Cluster Disk Data Storage Requirements”
- Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
- Section 17.1, “Overview of Partitioning in MySQL”
- Section 16.5.9.7, “The
ndbinfo memoryusageTable”
DefaultOperationRedoProblemAction
DiskCheckpointSpeed
DiskCheckpointSpeedInRestart
DiskIOThreadPool
DiskPageBufferMemory
ExecuteOnComputer
ExtraSendBufferMemory
FileSystemPath
FileSystemPathDD
FileSystemPathDataFiles
FileSystemPathUndoFiles
FragmentLogFileSize
HAVE_EMBEDDED_PRIVILEGE_CONTROL
HeartbeatIntervalDbApi
HeartbeatIntervalDbDb
HeartbeatOrder
HeartbeatThreadPriority
HostName
- Section 16.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.2, “MySQL Cluster Installation”
- Section 16.5.10.1, “MySQL Cluster Security and Networking Issues”
- Section 16.3.1, “Quick Test Setup of MySQL Cluster”
HostName1
Id
- Section 12.7.5.5, “
SHOW COLLATIONСинтаксис” - Section 12.7.5.30, “
SHOW PROCESSLISTСинтаксис” - Section 21.9.1, “C API Data Structures”
- Section 9.4.2, “Choosing a Collation ID”
- Section 5.7.1.1, “Connection Probes”
- Section 16.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 7.12.5, “Examining Thread Information”
- Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
- Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
- Section 5.7.1.6, “Query Execution Probes”
- Section 5.7.1.3, “Query Probes”
- Section 19.2, “The
INFORMATION_SCHEMA COLLATIONSTable” - Section 19.15, “The
INFORMATION_SCHEMA PROCESSLISTTable”
IndexMemory
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.1.6.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
- Section E.10.3, “Limits on Table Size”
- Section 16.5.9.7, “The
ndbinfo memoryusageTable”
InitFragmentLogFiles
InitialLogFileGroup
InitialNoOfOpenFiles
InitialTablespace
Innodb_buffer_pool_read_ahead_rnd
Innodb_buffer_pool_read_ahead_seq
LockExecuteThreadToCPU
LockMaintThreadsToCPU
LockPagesInMainMemory
LogDestination
LogLevelCheckpoint
LogLevelCongestion
LogLevelConnection
LogLevelNodeRestart
LogLevelShutdown
LogLevelStartup
LogLevelStatistic
LongMessageBuffer
MYSQL_MAINTAINER_MODE
MYSQL_TCP_PORT
MYSQL_UNIX_ADDR
MaxBufferedEpochs
MaxDMLOperationsPerTransaction
MaxLCPStartDelay
MaxNoOfAttributes
MaxNoOfConcurrentIndexOperations
MaxNoOfConcurrentOperations
MaxNoOfConcurrentScans
MaxNoOfConcurrentSubOperations
MaxNoOfConcurrentTransactions
MaxNoOfExecutionThreads
MaxNoOfFiredTriggers
MaxNoOfLocalOperations
MaxNoOfLocalScans
MaxNoOfOpenFiles
MaxNoOfOrderedIndexes
MaxNoOfSavedMessages
MaxNoOfSubscribers
MaxNoOfSubscriptions
MaxNoOfTables
MaxNoOfTriggers
MaxNoOfUniqueHashIndexes
MaxParallelScansPerFragment
MaxStartFailRetries
MemReportFrequency
Name
- Section 12.7.5.1, “
SHOW AUTHORSСинтаксис” - Section 12.7.5.7, “
SHOW CONTRIBUTORSСинтаксис” - Section 12.7.5.16, “
SHOW ENGINEСинтаксис” - Section 12.7.5.19, “
SHOW EVENTSСинтаксис” - Section 12.7.5.26, “
SHOW PLUGINSСинтаксис” - Section 12.7.5.37, “
SHOW TABLE STATUSСинтаксис” - Section 19.7, “The
INFORMATION_SCHEMA EVENTSTable” - Section 19.14, “The
INFORMATION_SCHEMA PLUGINSTable” - Section 16.5.9, “The
ndbinfoMySQL Cluster Information Database”
Ndb_cluster_node_id
Ndb_conflict_fn_epoch
Ndb_conflict_fn_epoch_trans
Ndb_conflict_fn_max
Ndb_conflict_fn_old
Ndb_conflict_trans_conflict_commit_count
Ndb_conflict_trans_detect_iter_count
Ndb_conflict_trans_reject_count
Ndb_conflict_trans_row_conflict_count
Ndb_conflict_trans_row_reject_count
NoOfDiskPagesToDiskAfterRestartACC
NoOfDiskPagesToDiskAfterRestartTUP
NoOfDiskPagesToDiskDuringRestartACC
NoOfDiskPagesToDiskDuringRestartTUP
NoOfFragmentLogFiles
NoOfReplicas
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
- Section 16.3.2.1, “MySQL Cluster Configuration: Basic Пример”
- Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
- Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
NodeId
- Section 16.3.2.4, “Defining Computers in a MySQL Cluster”
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
- Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
NodeId1
NodeId2
OverloadLimit
Performance_schema_accounts_lost
Performance_schema_hosts_lost
Performance_schema_locker_lost
Performance_schema_users_lost
PortNumber
RealtimeScheduler
ReceiveBufferMemory
RedoOverCommitCounter
RedoOverCommitLimit
ReservedSendBufferMemory
RestartOnErrorInsert
Rpl_status
SYSCONFDIR
SchedulerExecutionTimer
SchedulerSpinTimer
SendBufferMemory
SendLimit
SendSignalId
ServerPort
SharedBufferSize
SharedGlobalMemory
Ssl_cipher
StartFailRetryDelay
StartFailureTimeout
StartNoNodeGroupTimeout
StartPartialTimeout
StartPartitionedTimeout
StartupStatusReportFrequency
TcpBind_INADDR_ANY
Text in this style
TimeBetweenEpochs
TimeBetweenEpochsTimeout
TimeBetweenGlobalCheckpoints
TimeBetweenInactiveTransactionAbortCheck
TimeBetweenLocalCheckpoints
TimeBetweenWatchDogCheck
TimeBetweenWatchDogCheckInitial
TotalSendBufferMemory
- Section 16.3.2.12, “Configuring MySQL Cluster Send Buffer Parameters”
- Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
- Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
- Section 16.3.2.8, “MySQL Cluster TCP/IP Connections”
TransactionBufferMemory
TransactionDeadlockDetectionTimeout
TransactionInactiveTimeout
UndoDataBuffer
UndoIndexBuffer
WITH_BUNDLED_MEMCACHED
WITH_COMMENT
WITH_NDBCLUSTER_STORAGE_ENGINE
WITH_PERFSCHEMA_STORAGE_ENGINE
\G
\q
\s
\t
\u db_name
all
ansi
auto_increment_increment
auto_increment_offset
automatic_sp_privileges
basedir
binlog_cache_size
binlog_checksum
binlog_row_image
binlog_rows_query_log_events
c
- Section 12.1.7.3, “
ALTER TABLEExamples” - Section 12.1.17.1, “
CREATE TABLE ... SELECTСинтаксис” - Section 11.16.3, “
GROUP BYandHAVINGwith Hidden Columns” - Section 17.2.3.1, “
RANGE COLUMNSpartitioning” - Описание
- Section 8.2.1, “Identifier Qualifiers”
- Section 16.5.15.4, “NDB Engine Configuration”
- Section 3.3.4.7, “Pattern Matching”
- Section 11.5.2, “Regular Expressions”
- Section 9.1.14.1, “Unicode Character Sets”
- Section 1.4, “What Is New in MySQL 5.5”
character-sets-dir=path
character_set_client
character_set_server
charset
check
collation_server
compress
connect_timeout
connectstring=connect_string
count
csv
d
database
datadir
db
- Section 12.7.5.30, “
SHOW PROCESSLISTСинтаксис” - 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 Ошибки”
- Описание
- Section 7.12.5, “Examining Thread Information”
- Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section E.7, “Restrictions on Character Sets”
- Section 19.12, “The
INFORMATION_SCHEMA PARAMETERSTable” - Section 19.15, “The
INFORMATION_SCHEMA PROCESSLISTTable” - Section 19.18, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 2.10.1, “Unix Postinstallation Procedures”
debug={true|false}
decode_bits
default-storage-engine
default-table-type
defaults-extra-file
delimiter
description
e
engine_condition_pushdown
event-scheduler=DISABLED
event_scheduler
extended-status
external_user
flush-logs
flush-privileges
flush-status
flush-tables
foreign_key_checks
ft_max_word_len
ft_min_word_len
ft_stopword_file
have_innodb
have_ndbcluster
have_partition_engine
have_partitioning
have_profiling
host
- 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 Ошибки”
- Section 5.7.1.2, “Command Probes”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 5.7.1.1, “Connection Probes”
- Section 13.3.5.2, “Converting Tables from Other Storage Engines to
InnoDB” - Описание
- Section 5.4.2, “Privilege System Grant Tables”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 5.7.1.6, “Query Execution Probes”
- Section 5.7.1.3, “Query Probes”
- Section 2.10.1, “Unix Postinstallation Procedures”
ignore_builtin_innodb
innodb
innodb-safe-binlog
innodb-status-file=1
innodb_adaptive_flushing
innodb_adaptive_hash_index
innodb_adaptive_max_sleep_delay
innodb_additional_mem_pool_size
innodb_analyze_is_persistent
innodb_autoextend_increment
innodb_autoinc_lock_mode
innodb_buffer_pool_awe_mem_mb
innodb_buffer_pool_dump_at_shutdown
innodb_buffer_pool_dump_now
innodb_buffer_pool_filename
innodb_buffer_pool_instances
innodb_buffer_pool_load_abort
innodb_buffer_pool_load_at_startup
innodb_buffer_pool_load_now
innodb_buffer_pool_size
innodb_change_buffer_max_size
innodb_change_buffering
innodb_checksum_algorithm
innodb_checksums
innodb_commit_concurrency
innodb_concurrency_tickets
innodb_data_file_path
innodb_data_home_dir
innodb_doublewrite
innodb_fast_shutdown
innodb_file_format
innodb_file_format_check
innodb_file_format_max
innodb_file_io_threads
innodb_file_per_table
- Section 13.3.4, “
InnoDBStartup Options and System Variables” - Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
- Section 13.3.12.2, “File Space Management”
- Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
- Section 5.1.2, “Server Command Options”
- Section 13.3.3, “Using Per-Table Tablespaces”
innodb_flush_log_at_trx_commit
innodb_flush_method
innodb_flush_neighbors
innodb_force_recovery
innodb_io_capacity
innodb_large_prefix
innodb_lock_wait_timeout
innodb_locks_unsafe_for_binlog
innodb_log_arch_dir
innodb_log_archive
innodb_log_buffer_size
innodb_log_file_size
innodb_log_files_in_group
innodb_log_group_home_dir
innodb_lru_scan_depth
innodb_max_dirty_pages_pct
innodb_max_purge_lag
innodb_mirrored_log_groups
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_old_blocks_pct
innodb_old_blocks_time
innodb_open_files
innodb_optimize_fulltext_only
innodb_page_size
innodb_print_all_deadlocks
innodb_purge_batch_size
innodb_purge_threads
innodb_random_read_ahead
innodb_read_ahead_threshold
innodb_read_io_threads
innodb_replication_delay
innodb_rollback_on_timeout
innodb_rollback_segments
innodb_sort_buffer_size
innodb_spin_wait_delay
innodb_stats_method
innodb_stats_on_metadata
innodb_stats_persistent_sample_pages
innodb_stats_sample_pages
innodb_stats_transient_sample_pages
innodb_strict_mode
innodb_support_xa
innodb_sync_array_size
innodb_sync_spin_loops
innodb_table_locks
innodb_thread_concurrency
innodb_thread_sleep_delay
innodb_undo_directory
innodb_undo_logs
innodb_undo_tablespaces
innodb_use_legacy_cardinality_algorithm
innodb_use_native_aio
innodb_use_sys_malloc
innodb_write_io_threads
interactive_timeout
key_buffer_size
language
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.21, “
mysql_stmt_prepare()” - Section 21.9.7.26, “
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.4, “Writing Full-Text Parser Plugins”
license
log
log-slave-updates
log_bin_trust_routine_creators
log_slow_queries
lower_case_table_names
master_verify_checksum
max_allowed_packet
max_binlog_cache_size
max_binlog_stmt_cache_size
max_connections
max_long_data_size
max_user_connections
multi_range_count
myisam_block_size
myisam_max_extra_sort_file_size
myisam_stats_method
myisamchk
mysql
- Section 4.5.1.1, “mysql Options”
- Section 4.5.1.4, “mysql Server-Side Help”
- Section 12.7.3.1, “
CREATE FUNCTIONСинтаксис for User-Defined Functions” - Section 12.1.16, “
CREATE SERVERСинтаксис” - Section 12.7.1.1, “
CREATE USERСинтаксис” - Section C.5.2.4, “
Client does not support authentication protocol” - Section 12.7.3.2, “
DROP FUNCTIONСинтаксис” - Section 12.7.1.2, “
DROP USERСинтаксис” - Section 12.7.6.3, “
FLUSHСинтаксис” - Section 12.7.1.3, “
GRANTСинтаксис” - Section 12.8.3, “
HELPСинтаксис” - Section C.5.2.9, “
MySQL server has gone away” - Section 12.7.1.4, “
RENAME USERСинтаксис” - Section 12.7.1.5, “
REVOKEСинтаксис” - Section 12.7.1.6, “
SET PASSWORDСинтаксис” - Section 12.7.5.22, “
SHOW GRANTSСинтаксис” - Section 21.9.3.3, “
mysql_change_user()” - Section 21.9.10.1, “
mysql_client_find_plugin()” - Section 21.9.10.2, “
mysql_client_register_plugin()” - 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.10.3, “
mysql_load_plugin()” - 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.26, “
mysql_stmt_send_long_data()” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 12.7.1, “Account Management Statements”
- Section 5.5.2, “Adding User Accounts”
- Section 5.3.2.1, “Administrator Guidelines for Password Security”
- Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 5.5.5, “Assigning Account Passwords”
- Section 15.1.3.4, “Binary Log Options and Variables”
- Section 21.9.15, “C API Prepared Statement Handling of Date and Time Values”
- Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
- Section 9.1.4, “Connection Character Sets and Collations”
- Глава 21, Connectors and APIs
- Section 13.3.5.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 2.11.5, “Copying MySQL Databases to Another Machine”
- Section 13.11.2.1, “Creating a
FEDERATEDTable UsingCONNECTION” - Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
- Section 3.3, “Creating and Using a Database”
- Section 16.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
- Описание
- Описание
- Описание
- Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
- Section 2.11.2, “Downgrading MySQL”
- Section 7.11.4.2, “Enabling Large Page Support”
- Section 6.3.1, “Establishing a Backup Policy”
- Section 18.4.4, “Event Metadata”
- Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
- Section 5.3.1, “General Security Guidelines”
- Section 7.9.3.1, “How the Query Cache Operates”
- Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
- Section 16.2.1.2, “Installing MySQL Cluster from RPM”
- Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
- Section 2.5.1, “Installing MySQL from RPM Packages on Linux”
- Section 2.9.2, “Installing MySQL from a Standard Source Distribution”
- Section 2.7.2, “Installing MySQL on HP-UX using DEPOT”
- Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”
- Section 2.4, “Installing MySQL on Mac OS X”
- Section 2.6.2, “Installing MySQL on OpenSolaris using IPS”
- Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
- Section 2.6.1, “Installing MySQL on Solaris using a Solaris
PKG” - Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
- Section 16.6.3, “Known Issues in MySQL Cluster Replication”
- Section 5.5.6.2.2.2, “LDAP Authentication without Proxy Users”
- Section 13.3.15, “Limits on
InnoDBTables” - 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 16.6.11, “MySQL Cluster Replication Conflict Resolution”
- Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
- Section 16.3.4.3, “MySQL Cluster System Variables”
- Section 16.5.10.2, “MySQL Cluster and MySQL Privileges”
- Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
- Section 21.10, “MySQL PHP API”
- Section 9.6, “MySQL Server Time Zone Support”
- 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.10.1.1, “Problems Running mysql_install_db”
- Section 15.2.2, “Replication Relay and Status Logs”
- Section 15.4.1.10, “Replication and
FLUSH” - Section 15.4.1.20, “Replication of the
mysqlSystem Database” - Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
- Section E.7, “Restrictions on Character Sets”
- Section E.1, “Restrictions on Stored Programs”
- Section 8.2, “Schema Object Names”
- Section 2.10.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 15.2.2.2, “Slave Status Logs”
- Section 5.4.3, “Specifying Account Names”
- Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
- Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
- Section 2.10.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 12.3.5.3, “Table-Locking Restrictions and Conditions”
- Section 5.4, “The MySQL Access Privilege System”
- Section 22.2, “The MySQL Plugin API”
- Section 2.3.7, “Troubleshooting a MySQL Installation Under Windows”
- Section 5.5.6.2.2.3, “Unix Password Authentication with Proxy Users and Group Mapping”
- Section 5.5.6.2.2.1, “Unix Password Authentication without Proxy Users”
- Section 2.10.1, “Unix Postinstallation Procedures”
- Section 2.11.1, “Upgrading MySQL”
- Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
- Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
- Section 5.5.1, “User Names and Passwords”
- Section 13.3.3.1, “Using Raw Devices for the Shared Tablespace”
- Section 5.5.8.2, “Using SSL Connections”
- Section 22.5.1.6, “Using Server Logs to Find Causes of Ошибки in mysqld”
- Section 18.2, “Using Stored Routines (Procedures and Functions)”
- Section 18.4, “Using the Event Scheduler”
- Section 5.5.6.2.2, “Using the PAM Authentication Plugin”
- Section 1.4, “What Is New in MySQL 5.5”
- Section 2.3.9, “Windows Postinstallation Procedures”
mysql_plugin
mysqlaccess
mysqlbinlog
mysqld
- Section C.5.2.2, “
Can't connect to [local] MySQL server” - Section 13.11.1, “
FEDERATEDStorage Engine Overview” - Section 13.3.4, “
InnoDBStartup Options and System Variables” - Section 21.9.2, “C API Function Overview”
- Описание
- Описание
- Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
- Section 16.3.4.1, “MySQL Cluster mysqld Option and Variable Reference”
- Section 5.1.1, “Server Option and Variable Reference”
- Section 15.2.2.2, “Slave Status Logs”
- Section 5.2.2, “The Error Log”
- Section 22.5.1.3, “Using
pdbto create a Windows crashdump”
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlslap
ndb-connectstring
ndb_autoincrement_prefetch_sz
ndb_log_binlog_index
ndb_optimization_delay
ndb_table_no_logging
ndbd
net_buffer_length
net_retry_count
net_write_timeout
nice
offset
open-files-limit
open_files_limit
p
partition
password
performance_schema
- Section 12.7.5.16, “
SHOW ENGINEСинтаксис” - Описание
- Section 7.9.3.1, “How the Query Cache Operates”
- Section 13.3.1, “InnoDB as the Default MySQL Storage Engine”
- Section 7.12.4, “Measuring Performance with
performance_schema” - Глава 20, MySQL Performance Schema
- Section 20.2.1, “Performance Schema Build Configuration”
- Section 20.6, “Performance Schema General Table Characteristics”
- Section 20.1, “Performance Schema Quick Start”
- Section 20.5, “Performance Schema Status Monitoring”
- Section 20.7, “Performance Schema Table Описаниеs”
- Section 20.10, “Performance Schema and Plugins”
- Section E.8, “Restrictions on Performance Schema”
- Section 12.3.5.3, “Table-Locking Restrictions and Conditions”
- Section 18.3, “Using Triggers”
pid-file
pipe
plugin
processlist
query
query_cache_type
read_buffer_size
reconf={true|false}
reconnect
record_buffer
rehash
replication-ignore-table
resolve_stack_dump
role=role_name
rows
rpl_recovery_rank
s
select_limit
server-id
- Section 15.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
- Section 15.1, “Replication Configuration”
- Section 15.1.3.2, “Replication Master Options and Variables”
- Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 15.1.1.8, “Setting Up Replication with Existing Data”
- Section 15.1.1.1, “Setting the Replication Master Configuration”
- Section 15.1.1.2, “Setting the Replication Slave Configuration”
server_id
set-variable=option=value
shutdown
shutdown_timeout
skip-networking
skip-slave-start
slave
slave_sql_verify_checksum
slave_type_conversions
socket
sort_buffer_size
sort_key_blocks
source
sql-mode=""
sql-mode="modes"
sql_log_update
sql_low_priority_updates
start-slave
stats_method
status
- Section 4.5.1.2, “mysql Commands”
- Section 12.7.2.1, “
ANALYZE TABLEСинтаксис” - Section 12.7.2.2, “
CHECK TABLEСинтаксис” - Section 12.7.2.4, “
OPTIMIZE TABLEСинтаксис” - Section 12.7.2.5, “
REPAIR TABLEСинтаксис” - Section 5.7.1.2, “Command Probes”
- Section 5.7.1.1, “Connection Probes”
- Описание
- Section 5.7.1.11, “Filesort Probes”
- Section 5.7.1.9, “Index Probes”
- Section 5.7.1.10, “Lock Probes”
- Section 16.5.7, “MySQL Cluster Single User Mode”
- Section 5.7.1.13, “Network Probes”
- Section 5.7.1.6, “Query Execution Probes”
- Section 5.7.1.4, “Query Parsing Probes”
- Section 5.7.1.3, “Query Probes”
- Section 5.7.1.8, “Read Row Probes”
- Section 5.7.1.7, “Row-Level Probes”
- Section 5.7.1.12, “Statement Probes”
- Section 16.5.9.8, “The
ndbinfo nodesTable” - Section 16.5.9.10, “The
ndbinfo transportersTable”
stop-slave
syslog
system
table
table_type
test
- Section 13.3.14.2.3, “
InnoDBTable Monitor Output” - Section 12.2.7, “
LOAD XMLСинтаксис” - Section 12.7.5.19, “
SHOW EVENTSСинтаксис” - Section 9.1.7.9, “Collation and
INFORMATION_SCHEMASearches” - Section 11.4, “Control Flow Functions”
- Section 13.3.5, “Creating and Using
InnoDBTables” - Section 3.3, “Creating and Using a Database”
- Описание
- Описание
- 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.5.14, “NDB API Statistics Counters and Variables”
- Section 7.2.4, “Optimizing
INFORMATION_SCHEMAQueries” - Section 15.1.3.3, “Replication Slave Options and Variables”
- Section 2.10.2, “Securing the Initial MySQL Accounts”
- Section 18.2.1, “Stored Routine Синтаксис”
- Section 19.13, “The
INFORMATION_SCHEMA PARTITIONSTable” - Section 2.10.1, “Unix Postinstallation Procedures”
- Section 4.2.3.1, “Using Options on the Command Line”
- Section 2.3.9, “Windows Postinstallation Procedures”
thread_handling
tmpdir
type
- Section 12.7.3.1, “
CREATE FUNCTIONСинтаксис for User-Defined Functions” - Section 7.8.2, “
EXPLAINOutput Format” - Section 13.3.14.2.3, “
InnoDBTable Monitor Output” - Section 21.9.10.1, “
mysql_client_find_plugin()” - Section 21.9.10.3, “
mysql_load_plugin()” - Section 21.9.1, “C API Data Structures”
- Section 22.2.4.2.3, “Client Plugin Descriptors”
- Section 7.2.1.4, “How to Avoid Full Table Scans”
- Section 7.13.2, “Index Merge Optimization”
- Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
- Section 22.2.4.2.2, “Server Plugin Status and System Variables”
- Section 19.18, “The
INFORMATION_SCHEMA ROUTINESTable” - Section 22.2.4.4, “Writing Full-Text Parser Plugins”
update
use db_name
user
- Section 12.7.1.2, “
DROP USERСинтаксис” - Section C.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.5.5, “Assigning Account Passwords”
- Section 5.5.10, “Auditing MySQL Account Activity”
- Section 5.4.7, “Causes of Access-Denied Ошибки”
- Section 5.7.1.2, “Command Probes”
- Section 3.1, “Connecting to and Disconnecting from the Server”
- Section 5.7.1.1, “Connection Probes”
- Section 13.3.5.2, “Converting Tables from Other Storage Engines to
InnoDB” - Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
- Описание
- Section 11.13, “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 5.7.1.6, “Query Execution Probes”
- Section 5.7.1.3, “Query Probes”
- Section E.7, “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.10.1.2, “Starting and Stopping MySQL Automatically”
- Section 5.5.6.2.2.3, “Unix Password Authentication with Proxy Users and Group Mapping”
- Section 2.10.1, “Unix Postinstallation Procedures”
- Section 5.5.1, “User Names and Passwords”
- Section 5.5.8.2, “Using SSL Connections”
- Section 11.11, “XML Functions”