General Index


Symbols  |  A  |  B  |  C  |  D  |  E  |  F  |  G  |  H  |  I  |  J  |  K  |  L  |  M  |  N  |  O  |  P  |  Q  |  R  |  S  |  T  |  U  |  V  |  W  |  X  |  Y  |  Z

Symbols

[ index top ]
! (logical NOT), Logical Operators
!= (not equal), Comparison Functions and Operators
", Schema Object Names
%, Arithmetic Operators
% (modulo), Mathematical Functions
% (wildcard character), String Literals
& (bitwise AND), Bit-Operation Incompatibilities with MySQL 5.7
&& (logical AND), Logical Operators
() (parentheses), Operator Precedence
(Control+Z) \Z, String Literals , Field and Line Handling
* (multiplication), Arithmetic Operators
+ (addition), Arithmetic Operators
- (subtraction), Arithmetic Operators
- (unary minus), Arithmetic Operators
--master-info-repository option, Replication Relay and Status Logs
--password option, End-User Guidelines for Password Security
--relay-log-info-repository option, Replication Relay and Status Logs
->, Functions That Search JSON Values
->>, Functions That Search JSON Values
-? option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
-c option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
-c option (ndb_mgmd) (OBSOLETE), ndb_mgmd — The NDB Cluster Management Server Daemon
-d option (ndb_index_stat), ndb_index_stat — NDB Index Statistics Utility
-d option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
-e option (ndb_mgm), ndb_mgm — The NDB Cluster Management Client
-f option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
-l option (ndbinfo_select_all), ndbinfo_select_all — Select From ndbinfo Tables
-n option (ndbd), ndbd — The NDB Cluster Data Node Daemon
-n option (ndbmtd), ndbd — The NDB Cluster Data Node Daemon
-p option, End-User Guidelines for Password Security
-P option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
-V option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
-v option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
.my.cnf option file, Connecting to the MySQL Server , Using Option Files , Using Client Programs in a Multiple-Server Environment , End-User Guidelines for Password Security , Troubleshooting Problems Connecting to MySQL
.mylogin.cnf option file, Using Option Files , mysql_config_editor — MySQL Configuration Utility
.mysql_history file, mysql Client Logging , End-User Guidelines for Password Security
.pid (process ID) file, Setting Up a MyISAM Table Maintenance Schedule
.sdi file, IMPORT TABLE Syntax
/ (division), Arithmetic Operators
/etc/passwd, Making MySQL Secure Against Attackers , SELECT ... INTO Syntax
3306 port, Feature Options , Server Command Options
33060 port, Feature Options
:= (assignment operator), Assignment Operators
:= (assignment), User-Defined Variables
< (less than), Comparison Functions and Operators
<< (left shift), Calculating Visits Per Day , Bit-Operation Incompatibilities with MySQL 5.7
<= (less than or equal), Comparison Functions and Operators
<=> (equal to), Comparison Functions and Operators
<> (not equal), Comparison Functions and Operators
= (assignment operator), Assignment Operators
= (assignment), User-Defined Variables
= (equal), Comparison Functions and Operators
> (greater than), Comparison Functions and Operators
>= (greater than or equal), Comparison Functions and Operators
>> (right shift), Bit-Operation Incompatibilities with MySQL 5.7
@master_binlog_checksum user-defined variable, C API Binary Log Function Descriptions
[api] (NDB Cluster), NDB Cluster SQL Node and API Node Configuration Parameters
[computer] (NDB Cluster), Other NDB Cluster Configuration Parameters
[mgm] (NDB Cluster), NDB Cluster Management Node Configuration Parameters
[mysqld] (NDB Cluster), NDB Cluster SQL Node and API Node Configuration Parameters
[ndbd default] (NDB Cluster), NDB Cluster Data Node Configuration Parameters
[ndbd] (NDB Cluster), NDB Cluster Data Node Configuration Parameters
[ndb_mgmd] (NDB Cluster), NDB Cluster Management Node Configuration Parameters
[sci] (NDB Cluster), Other NDB Cluster Configuration Parameters
[shm] (NDB Cluster), Other NDB Cluster Configuration Parameters
[tcp] (NDB Cluster), Other NDB Cluster Configuration Parameters
\" (double quote), String Literals , Functions That Modify JSON Values
\' (single quote), String Literals
\. (mysql client command), Using mysql in Batch Mode , Executing SQL Statements from a Text File
\0 (ASCII NUL), String Literals , Field and Line Handling
\b (backspace), String Literals , Functions That Modify JSON Values , Field and Line Handling
\f (formfeed), Functions That Modify JSON Values
\n (linefeed), String Literals , Functions That Modify JSON Values , Field and Line Handling
\n (newline), String Literals , Functions That Modify JSON Values , Field and Line Handling
\N (NULL), Field and Line Handling
\r (carriage return), String Literals , Functions That Modify JSON Values , Field and Line Handling
\t (tab), String Literals , Functions That Modify JSON Values , Field and Line Handling
\u (Unicode character), Functions That Modify JSON Values
\Z (Control+Z) ASCII 26, String Literals , Field and Line Handling
\\ (escape), String Literals , Functions That Modify JSON Values
^ (bitwise XOR), Bit-Operation Incompatibilities with MySQL 5.7
_ (wildcard character), String Literals
_ai collation sufffix, Collation Naming Conventions
_as collation sufffix, Collation Naming Conventions
_bin collation sufffix, Collation Naming Conventions , The binary Collation Compared to _bin Collations
_ci collation sufffix, Collation Naming Conventions
_cs collation sufffix, Collation Naming Conventions
_ks collation sufffix, Collation Naming Conventions
_rowid
SELECT statements, Unique Indexes , CREATE TABLE Syntax
`, Schema Object Names
| (bitwise OR), Bit-Operation Incompatibilities with MySQL 5.7
|| (logical OR), Logical Operators
~ (invert bits), Bit-Operation Incompatibilities with MySQL 5.7

A

[ index top ]
abort-on-error option
ndb_import, ndb_import — Import CSV Data Into NDB
ndb_move_data, ndb_move_data — NDB Data Copy Utility
abort-slave-event-count option
mysqld, Startup Options for Replication Slaves
aborted clients, Communication Errors and Aborted Connections
aborted connection, Communication Errors and Aborted Connections
ABS(), Mathematical Functions
access control, Access Control, Stage 1: Connection Verification
access denied errors, Access denied
access privileges, The MySQL Access Privilege System
account
default, Securing the Initial MySQL Account
root, Securing the Initial MySQL Account
account locking, Grant Tables , User Account Locking
ALTER USER, ALTER USER Account-Locking Options
CREATE USER statement, CREATE USER Account-Locking Options
Locked_connects status variable, Server Status Variables
account names, Specifying Account Names
accounts
adding privileges, Adding User Accounts
accounts table
performance_schema, The accounts Table
account_locked column
user table, Grant Tables
ACID, Introduction to InnoDB , InnoDB and the ACID Model , MySQL 词汇表
ACLs, The MySQL Access Privilege System
Acl_cache_items_count status variable, Server Status Variables
ACOS(), Mathematical Functions
activate_all_roles_on_login system variable, Server System Variables
activating plugins, Installing and Uninstalling Plugins
ActiveState Perl, Installing ActiveState Perl on Windows
adaptive flushing, MySQL 词汇表
adaptive hash index, Adaptive Hash Index , MySQL 词汇表
add-drop-database option
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
add-drop-table option
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
add-drop-trigger option
mysqldump, mysqldump — A Database Backup Program
add-drop-user option
mysqlpump, mysqlpump — A Database Backup Program
add-locks option
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
ADDDATE(), Date and Time Functions
adding
character sets, Adding a Character Set
native functions, Adding a New Native Function
new account privileges, Adding User Accounts
new functions, Adding New Functions to MySQL
new user privileges, Adding User Accounts
user-defined functions, Adding a New User-Defined Function
addition (+), Arithmetic Operators
ADDTIME(), Date and Time Functions
administration
server, mysqladmin — Client for Administering a MySQL Server
administration of NDB Cluster, ndb_mgm — The NDB Cluster Management Client
administrative programs, Overview of MySQL Programs
admin_address system variable, Server System Variables
admin_port system variable, Server System Variables
AES_DECRYPT(), Encryption and Compression Functions
AES_ENCRYPT(), Encryption and Compression Functions
After create
thread state, General Thread States
age
calculating, Date Calculations
ai-increment option
ndb_import, ndb_import — Import CSV Data Into NDB
ai-offset option
ndb_import, ndb_import — Import CSV Data Into NDB
ai-prefetch-sz option
ndb_import, ndb_import — Import CSV Data Into NDB
AIO, MySQL 词汇表
alias names
case sensitivity, Identifier Case Sensitivity
aliases
for expressions, MySQL Handling of GROUP BY
for tables, SELECT Syntax
in GROUP BY clauses, MySQL Handling of GROUP BY
names, Schema Object Names
on expressions, SELECT Syntax
ALL, Subqueries with ALL
SELECT modifier, SELECT Syntax
ALL join type
optimizer, EXPLAIN Join Types
all-databases option
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
all-in-1 option
mysqlcheck, mysqlcheck — A Table Maintenance Program
all-tablespaces option
mysqldump, mysqldump — A Database Backup Program
allow-keywords option
mysqldump, mysqldump — A Database Backup Program
allow-mismatches option
innochecksum, innochecksum — Offline InnoDB File Checksum Utility
allow-suspicious-udfs option
mysqld, Server Command Options
ALLOW_INVALID_DATES SQL mode, Full List of SQL Modes
ALTER COLUMN, ALTER TABLE Syntax
ALTER DATABASE, ALTER DATABASE Syntax
ALTER EVENT, ALTER EVENT Syntax
and replication, Replication of Invoked Features
ALTER FUNCTION, ALTER FUNCTION Syntax
ALTER INSTANCE, ALTER INSTANCE Syntax
ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Syntax
(see also NDB Cluster Disk Data )
ALTER PROCEDURE, ALTER PROCEDURE Syntax
ALTER RESOURCE GROUP statement, ALTER RESOURCE GROUP Syntax
ALTER SCHEMA, ALTER DATABASE Syntax
ALTER SERVER, ALTER SERVER Syntax
ALTER TABLE, ALTER TABLE Syntax , Problems with ALTER TABLE
and replication log tables, Replication Relay and Status Logs
monitoring, Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
ROW_FORMAT, Defining the Row Format of a Table
ALTER TABLESPACE
general tablespace, ALTER TABLESPACE Syntax
NDB Cluster Disk Data, ALTER TABLESPACE Syntax
undo tablespace, ALTER TABLESPACE Syntax
ALTER USER statement, Assigning Account Passwords , ALTER USER Syntax
ALTER VIEW, ALTER VIEW Syntax
altering
database, ALTER DATABASE Syntax
schema, ALTER DATABASE Syntax
altering table
thread state, General Thread States
altering user accounts, ALTER USER Syntax
analyze option
myisamchk, Other myisamchk Options
mysqlcheck, mysqlcheck — A Table Maintenance Program
ANALYZE TABLE
and partitioning, Maintenance of Partitions
ANALYZE TABLE statement, ANALYZE TABLE Syntax
Analyzing
thread state, General Thread States
AND
bitwise, Bit-Operation Incompatibilities with MySQL 5.7
logical, Logical Operators
anonymous user, Access Control, Stage 1: Connection Verification , Access Control, Stage 2: Request Verification
ANSI mode
running, MySQL Standards Compliance
ansi option
mysqld, Server Command Options
ANSI SQL mode, The Most Important SQL Modes , Combination SQL Modes
ANSI_QUOTES SQL mode, Full List of SQL Modes
answering questions
etiquette, Guidelines for Using the Mailing Lists
ANY, Subqueries with ANY, IN, or SOME
ANY_VALUE(), Miscellaneous Functions
Apache, Using MySQL with Apache
API node (NDB Cluster)
defined, NDB Cluster Core Concepts
API nodes (see SQL nodes)
APIs, Connectors and APIs
list of, Packages that support MySQL
Perl, MySQL Perl API
append option
ndb_restore, ndb_restore — Restore an NDB Cluster Backup
application programming interface (API), MySQL 词汇表
apply, MySQL 词汇表
apply-slave-statements option
mysqldump, mysqldump — A Database Backup Program
apply_status table (OBSOLETE), NDB Cluster Replication Schema and Tables
(see also NDB Cluster replication )
approximate-value literals, Precision Math
approximate-value numeric literals, Numeric Literals , Types of Numeric Values
Arbitration, Defining NDB Cluster Data Nodes
ArbitrationDelay, Defining an NDB Cluster Management Server , Defining SQL and Other API Nodes in an NDB Cluster
ArbitrationRank, Defining an NDB Cluster Management Server , Defining SQL and Other API Nodes in an NDB Cluster
ArbitrationTimeout, Defining NDB Cluster Data Nodes
arbitrator_validity_detail
ndbinfo table, The ndbinfo arbitrator_validity_detail Table
arbitrator_validity_summary
ndbinfo table, The ndbinfo arbitrator_validity_summary Table
ARCHIVE storage engine, Alternative Storage Engines , The ARCHIVE Storage Engine
argument processing, UDF Argument Processing
arithmetic expressions, Arithmetic Operators
arithmetic functions, Bit Functions and Operators
arithmetic operators, Bit Functions and Operators
.ARM file, MySQL 词汇表
array
JSON, Creating JSON Values
.ARZ file, MySQL 词汇表
AS, SELECT Syntax , JOIN Syntax
ASCII(), String Functions
ASIN(), Mathematical Functions
assigning roles, SET ROLE Syntax
assignment operator
:=, Assignment Operators
=, Assignment Operators
assignment operators, Assignment Operators
ASYMMETRIC_DECRYPT(), MySQL Enterprise Encryption Function Descriptions
ASYMMETRIC_DERIVE(), MySQL Enterprise Encryption Function Descriptions
ASYMMETRIC_ENCRYPT(), MySQL Enterprise Encryption Function Descriptions
ASYMMETRIC_SIGN(), MySQL Enterprise Encryption Function Descriptions
ASYMMETRIC_VERIFY(), MySQL Enterprise Encryption Function Descriptions
asynchronous I/O, Using Asynchronous I/O on Linux , MySQL 词汇表
asynchronous replication (see NDB Cluster replication )
ATAN(), Mathematical Functions
ATAN2(), Mathematical Functions
atomic, MySQL 词汇表
atomic DDL, Atomic Data Definition Statement Support , MySQL 词汇表
atomic instruction, MySQL 词汇表
attackers
security against, Making MySQL Secure Against Attackers
attribute demotion
replication, Replication of Columns Having Different Data Types
attribute promotion
replication, Replication of Columns Having Different Data Types
attributes
resource groups, Resource Group Attributes
audit API UDFs
audit_api_message_emit_udf(), Audit Message Function
audit log filtering
legacy mode, Audit Log Filtering , Referencing Predefined Variables , Legacy Mode Audit Log Filtering
rule based, Audit Log Filtering
audit log filtering UDFs
audit_log_encryption_password_get(), Audit Log Functions
audit_log_encryption_password_set(), Audit Log Functions
audit_log_filter_flush(), Audit Log Functions
audit_log_filter_remove_filter(), Audit Log Functions
audit_log_filter_remove_user(), Audit Log Functions
audit_log_filter_set_filter(), Audit Log Functions
audit_log_filter_set_user(), Audit Log Functions
audit_log_read(), Audit Log Functions
audit_log_read_bookmark(), Audit Log Functions
audit plugin
sha2_cache_cleaner, Cache Operation for SHA-2 Pluggable Authentication
audit plugins, Audit Plugins
audit-log option
mysqld, Audit Log Options and Variables
audit_api_message_emit_udf() audit API UDF, Audit Message Function
audit_log plugin, MySQL Enterprise Audit
installing, Installing or Uninstalling MySQL Enterprise Audit
audit_log_buffer_size system variable, Audit Log Options and Variables
audit_log_compression system variable, Audit Log Options and Variables
audit_log_connection_policy system variable, Audit Log Options and Variables
audit_log_current_session system variable, Audit Log Options and Variables
Audit_log_current_size status variable, Audit Log Status Variables
audit_log_encryption system variable, Audit Log Options and Variables
audit_log_encryption_password_get() audit log filtering UDF, Audit Log Functions
audit_log_encryption_password_set() audit log filtering UDF, Audit Log Functions
Audit_log_events status variable, Audit Log Status Variables
Audit_log_events_filtered status variable, Audit Log Status Variables
Audit_log_events_lost status variable, Audit Log Status Variables
Audit_log_events_written status variable, Audit Log Status Variables
Audit_log_event_max_drop_size status variable, Audit Log Status Variables
audit_log_exclude_accounts system variable, Audit Log Options and Variables
audit_log_file system variable, Audit Log Options and Variables
audit_log_filter table
system table, Miscellaneous System Tables
audit_log_filter_flush() audit log filtering UDF, Audit Log Functions
audit_log_filter_id system variable, Audit Log Options and Variables
audit_log_filter_remove_filter() audit log filtering UDF, Audit Log Functions
audit_log_filter_remove_user() audit log filtering UDF, Audit Log Functions
audit_log_filter_set_filter() audit log filtering UDF, Audit Log Functions
audit_log_filter_set_user() audit log filtering UDF, Audit Log Functions
audit_log_flush system variable, Audit Log Options and Variables
audit_log_format system variable, Audit Log Options and Variables
audit_log_include_accounts system variable, Audit Log Options and Variables
audit_log_policy system variable, Audit Log Options and Variables
audit_log_read() audit log filtering UDF, Audit Log Functions
audit_log_read_bookmark() audit log filtering UDF, Audit Log Functions
audit_log_read_buffer_size system variable, Audit Log Options and Variables
audit_log_rotate_on_size system variable, Audit Log Options and Variables
audit_log_statement_policy system variable, Audit Log Options and Variables
audit_log_strategy system variable, Audit Log Options and Variables
Audit_log_total_size status variable, Audit Log Status Variables
audit_log_user table
system table, Miscellaneous System Tables
Audit_log_write_waits status variable, Audit Log Status Variables
authentication
for the InnoDB memcached interface, Password-Protecting memcached Using SASL
LDAP, LDAP Pluggable Authentication
SASL, LDAP Pluggable Authentication
authentication plugin
authentication_ldap_sasl, LDAP Pluggable Authentication
authentication_ldap_sasl_client, LDAP Pluggable Authentication
authentication_ldap_simple, LDAP Pluggable Authentication
authentication_pam, PAM Pluggable Authentication
authentication_windows, Windows Pluggable Authentication
authentication_windows_client, Windows Pluggable Authentication
auth_socket, Socket Peer-Credential Pluggable Authentication
auth_test_plugin, Test Pluggable Authentication
caching_sha2_password, Caching SHA-2 Pluggable Authentication
mysql_clear_password, Client-Side Cleartext Pluggable Authentication
mysql_clear_plugin, LDAP Pluggable Authentication
mysql_native_password, Native Pluggable Authentication
mysql_no_login, No-Login Pluggable Authentication
sha256_password, SHA-256 Pluggable Authentication
test_plugin_server, Test Pluggable Authentication
authentication plugins, Authentication Plugins
client/server compatibility, Authentication Plugin Client/Server Compatibility
client/server protocol, Authentication Plugin Connector-Writing Considerations
AUTHENTICATION_LDAP_CLIENT_LOG environment variable, Pluggable Authentication System Variables
authentication_ldap_sasl_auth_method_name system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_bind_base_dn system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_bind_root_dn system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_bind_root_pwd system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_ca_path system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_group_search_attr system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_group_search_filter system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_init_pool_size system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_log_status system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_max_pool_size system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_server_host system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_server_port system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_tls system variable, Pluggable Authentication System Variables
authentication_ldap_sasl_user_search_attr system variable, Pluggable Authentication System Variables
authentication_ldap_simple_auth_method_name system variable, Pluggable Authentication System Variables
authentication_ldap_simple_bind_base_dn system variable, Pluggable Authentication System Variables
authentication_ldap_simple_bind_root_dn system variable, Pluggable Authentication System Variables
authentication_ldap_simple_bind_root_pwd system variable, Pluggable Authentication System Variables
authentication_ldap_simple_ca_path system variable, Pluggable Authentication System Variables
authentication_ldap_simple_group_search_attr system variable, Pluggable Authentication System Variables
authentication_ldap_simple_group_search_filter system variable, Pluggable Authentication System Variables
authentication_ldap_simple_init_pool_size system variable, Pluggable Authentication System Variables
authentication_ldap_simple_log_status system variable, Pluggable Authentication System Variables
authentication_ldap_simple_max_pool_size system variable, Pluggable Authentication System Variables
authentication_ldap_simple_server_host system variable, Pluggable Authentication System Variables
authentication_ldap_simple_server_port system variable, Pluggable Authentication System Variables
authentication_ldap_simple_tls system variable, Pluggable Authentication System Variables
authentication_ldap_simple_user_search_attr system variable, Pluggable Authentication System Variables
authentication_pam authentication plugin, PAM Pluggable Authentication
AUTHENTICATION_PAM_LOG environment variable, MySQL Program Environment Variables , PAM Pluggable Authentication Debugging
authentication_windows authentication plugin, Windows Pluggable Authentication
authentication_windows_client authentication plugin, Windows Pluggable Authentication
authentication_windows_log_level system variable, Server System Variables
authentication_windows_use_principal_name system variable, Server System Variables
auth_socket authentication plugin, Socket Peer-Credential Pluggable Authentication
auth_test_plugin authentication plugin, Test Pluggable Authentication
auto-generate-sql option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-add-autoincrement option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-execute-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-guid-primary option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-load-type option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-secondary-indexes option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-unique-query-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-unique-write-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-write-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-inc lock, InnoDB Locking
auto-increment, AUTO_INCREMENT Handling in InnoDB , InnoDB AUTO_INCREMENT Lock Modes , InnoDB AUTO_INCREMENT Counter Initialization , MySQL 词汇表
auto-increment locking, MySQL 词汇表
auto-rehash option
mysql, mysql Client Options
auto-repair option
mysqlcheck, mysqlcheck — A Table Maintenance Program
auto-vertical-output option
mysql, mysql Client Options
auto.cnf file, Replication and Binary Logging Options and Variables
and SHOW SLAVE HOSTS statement, SHOW SLAVE HOSTS Syntax
autocommit, MySQL 词汇表
autocommit mode, autocommit, Commit, and Rollback
autocommit system variable, Server System Variables
automatic_sp_privileges system variable, Server System Variables
AutoReconnect
API and SQL nodes, Defining SQL and Other API Nodes in an NDB Cluster
autowrapped JSON values, Normalization, Merging, and Autowrapping of JSON Values
auto_generate_certs system variable, Server System Variables
AUTO_INCREMENT, Using AUTO_INCREMENT , Numeric Types
and NULL values, Problems with NULL Values
and replication, Replication and AUTO_INCREMENT
auto_increment_increment system variable, System Variables Used on Replication Masters
auto_increment_offset system variable, System Variables Used on Replication Masters
availability, MySQL 词汇表
AVG(), Aggregate (GROUP BY) Function Descriptions
AVG(DISTINCT), Aggregate (GROUP BY) Function Descriptions
avoid_temporal_upgrade system variable, Server System Variables

B

[ index top ]
B-tree, MySQL 词汇表
B-tree indexes, Comparison of B-Tree and Hash Indexes , The Physical Structure of an InnoDB Index
background threads
master, Configuring InnoDB Buffer Pool Flushing , Configuring the InnoDB Master Thread I/O Rate
read, Configuring the Number of Background InnoDB I/O Threads
write, Configuring the Number of Background InnoDB I/O Threads
backslash
escape character, String Literals
backspace (\b), String Literals , Functions That Modify JSON Values , Field and Line Handling
backticks, MySQL 词汇表
backup, MySQL 词汇表
BACKUP Events (NDB Cluster), NDB Cluster Log Events
backup identifiers
native backup and restore, Using The NDB Cluster Management Client to Create a Backup
backup option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
BackupDataBufferSize, Defining NDB Cluster Data Nodes , Configuration for NDB Cluster Backups
BackupDataDir, Defining NDB Cluster Data Nodes
BackupDiskWriteSpeedPct, Defining NDB Cluster Data Nodes
backupid option
ndb_restore, ndb_restore — Restore an NDB Cluster Backup
BackupLogBufferSize, Defining NDB Cluster Data Nodes , Configuration for NDB Cluster Backups
BackupMaxWriteSize, Defining NDB Cluster Data Nodes , Configuration for NDB Cluster Backups
BackupMemory, Defining NDB Cluster Data Nodes , Configuration for NDB Cluster Backups
BackupReportFrequency, Defining NDB Cluster Data Nodes
backups, Backup and Recovery , MySQL Enterprise Backup Overview
databases and tables, mysqldump — A Database Backup Program , mysqlpump — A Database Backup Program
in NDB Cluster, ndb_restore — Restore an NDB Cluster Backup , Online Backup of NDB Cluster , NDB Cluster Backup Concepts , Using The NDB Cluster Management Client to Create a Backup , Configuration for NDB Cluster Backups
in NDB Cluster replication, NDB Cluster Backups With NDB Cluster Replication
InnoDB, InnoDB Backup
with mysqldump, Using mysqldump for Backups
backups, troubleshooting
in NDB Cluster, NDB Cluster Backup Troubleshooting
BackupWriteSize, Defining NDB Cluster Data Nodes , Configuration for NDB Cluster Backups
backup_metadata_57 directory, In-Place Upgrade
backup_path option
ndb_restore, ndb_restore — Restore an NDB Cluster Backup
back_log system variable, Server System Variables
base column, MySQL 词汇表
base64-output option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
basedir option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
basedir system variable, Server System Variables
batch mode, Using mysql in Batch Mode
batch option
mysql, mysql Client Options
batch SQL files, mysql — The MySQL Command-Line Client
BatchByteSize, Defining SQL and Other API Nodes in an NDB Cluster
Batched Key Access
optimization, Block Nested-Loop and Batched Key Access Joins , Batched Key Access Joins
batched updates (NDB Cluster Replication), Starting NDB Cluster Replication (Single Replication Channel)
BatchSize, Defining SQL and Other API Nodes in an NDB Cluster
BatchSizePerLocalScan, Defining NDB Cluster Data Nodes
BEGIN, START TRANSACTION, COMMIT, and ROLLBACK Syntax , BEGIN ... END Compound-Statement Syntax
labels, Statement Label Syntax
XA transactions, XA Transaction SQL Syntax
BENCHMARK(), Information Functions
benchmarks, Using Your Own Benchmarks
beta, MySQL 词汇表
BETWEEN ... AND, Comparison Functions and Operators
big-tables option
mysqld, Server Command Options
big5, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
BIGINT data type, Numeric Type Overview
big_tables system variable, Server System Variables
BIN(), String Functions
BINARY, Cast Functions and Operators
binary collation, The binary Collation Compared to _bin Collations
BINARY data type, String Type Overview , The BINARY and VARBINARY Types
binary distributions
installing, Installing MySQL on Unix/Linux Using Generic Binaries
binary log, The Binary Log , MySQL 词汇表
C API, C API Binary Log Interface
event groups, SET GLOBAL sql_slave_skip_counter Syntax
binary log encryption, Encrypting Binary Log Files and Relay Log Files
binary logging
ALTER USER, ALTER USER Binary Logging
and NDB Cluster, Issues Exclusive to NDB Cluster
CREATE USER, CREATE USER Binary Logging
binary-as-hex option
mysql, mysql Client Options
binary-mode option
mysql, mysql Client Options
bind-address option
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
bind-address option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
bind_address system variable, Server System Variables
binlog, MySQL 词汇表
Binlog Dump
thread command, Thread Command Values
BINLOG statement, BINLOG Syntax
mysqlbinlog output, mysqlbinlog Row Event Display
binlog-checksum option
mysqld, Startup Options Used with Binary Logging
binlog-do-db option
mysqld, Startup Options Used with Binary Logging
binlog-format option
mysqld, Server Command Options
binlog-ignore-db option
mysqld, Startup Options Used with Binary Logging
binlog-row-event-max-size option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqld, Startup Options Used with Binary Logging
binlog-rows-query-log-events option
mysqld, Startup Options Used with Binary Logging
binlog_cache_size system variable, System Variables Used with Binary Logging
binlog_checksum system variable, System Variables Used with Binary Logging
binlog_direct_non_transactional_updates system variable, System Variables Used with Binary Logging
binlog_encryption system variable, System Variables Used with Binary Logging
binlog_error_action system variable, System Variables Used with Binary Logging
binlog_expire_logs_seconds, System Variables Used with Binary Logging
binlog_format
BLACKHOLE, Replication and BLACKHOLE Tables
binlog_format system variable, System Variables Used with Binary Logging
binlog_group_commit_sync_delay, System Variables Used with Binary Logging
binlog_group_commit_sync_no_delay_count, System Variables Used with Binary Logging
binlog_gtid_simple_recovery, System Variables Used with GTID Replication
binlog_index table (OBSOLETE) (see NDB Cluster replication )
binlog_max_flush_queue_time system variable, System Variables Used with Binary Logging
binlog_order_commits system variable, System Variables Used with Binary Logging
binlog_rotate_encryption_master_key_at_startup system variable, System Variables Used with Binary Logging
binlog_rows_query_log_events system variable, System Variables Used with Binary Logging
binlog_row_event_max_size system variable, System Variables Used with Binary Logging
binlog_row_image system variable, System Variables Used with Binary Logging
binlog_row_metadata system variable, System Variables Used with Binary Logging
binlog_row_value_options system variable, System Variables Used with Binary Logging
binlog_stmt_cache_size system variable, System Variables Used with Binary Logging
binlog_transaction_dependency_history_size system variable, System Variables Used with Binary Logging
binlog_transaction_dependency_tracking system variable, System Variables Used with Binary Logging
BIN_TO_UUID(), Miscellaneous Functions
BIT data type, Numeric Type Overview
bit functions, Bit Functions and Operators
example, Calculating Visits Per Day
bit operations
bit-value literals, Bit-Value Literals
hexadecimal literals, Hexadecimal Literals
bit operators, Bit Functions and Operators
bit-value literal introducer, Bit-Value Literals
bit-value literals, Bit-Value Literals
bit operations, Bit-Value Literals
BIT_AND(), Aggregate (GROUP BY) Function Descriptions
BIT_COUNT, Calculating Visits Per Day
BIT_COUNT(), Bit-Operation Incompatibilities with MySQL 5.7
BIT_LENGTH(), String Functions
BIT_OR, Calculating Visits Per Day
BIT_OR(), Aggregate (GROUP BY) Function Descriptions
BIT_XOR(), Aggregate (GROUP BY) Function Descriptions
BLACKHOLE
binlog_format, Replication and BLACKHOLE Tables
replication, Replication and BLACKHOLE Tables
BLACKHOLE storage engine, Alternative Storage Engines , The BLACKHOLE Storage Engine
blind query expansion, Full-Text Searches with Query Expansion , MySQL 词汇表
BLOB columns
default values, The BLOB and TEXT Types
indexing, Index Prefixes , CREATE TABLE Syntax
inserting binary data, String Literals
size, String Type Storage Requirements
BLOB data type, String Type Overview , The BLOB and TEXT Types
blob-info option
ndb_desc, ndb_desc — Describe NDB Tables
Block Nested-Loop
optimization, Block Nested-Loop and Batched Key Access Joins , Block Nested-Loop Algorithm for Outer Joins and Semi-Joins
Block Nested-Loop join algorithm, Nested-Loop Join Algorithms
block-search option
myisamchk, Other myisamchk Options
blocks
ndbinfo table, The ndbinfo blocks Table
block_encryption_mode system variable, Server System Variables
BOOL data type, Numeric Type Overview
BOOLEAN data type, Numeric Type Overview
boolean literals, Boolean Literals
boolean options, Program Option Modifiers
Boolean search, Boolean Full-Text Searches
bottleneck, MySQL 词汇表
bounce, MySQL 词汇表
brackets
square, Data Types
browser-start-page option
ndb_setup.py, ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster
buddy allocator, INNODB_CMPMEM and INNODB_CMPMEM_RESET , MySQL 词汇表
buffer, MySQL 词汇表
buffer pool, InnoDB Buffer Pool Optimization , Configuring InnoDB Buffer Pool Size , Configuring Multiple Buffer Pool Instances , Making the Buffer Pool Scan Resistant , Configuring InnoDB Buffer Pool Prefetching (Read-Ahead) , Configuring InnoDB Buffer Pool Flushing , Fine-tuning InnoDB Buffer Pool Flushing , Saving and Restoring the Buffer Pool State , MySQL 词汇表
and compressed tables, How Compression Works for InnoDB Tables
monitoring, Monitoring the Buffer Pool Using the InnoDB Standard Monitor , Monitoring Online Buffer Pool Resizing Progress , Monitoring Buffer Pool Load Progress Using Performance Schema
buffer pool instance, MySQL 词汇表
buffer sizes, InnoDB Buffer Pool Optimization , Configuring InnoDB Buffer Pool Size
client, Connectors and APIs
bugs
known, Known Issues in MySQL
NDB Cluster
reporting, ndb_error_reporter — NDB Error-Reporting Utility
reporting, General Information , How to Report Bugs or Problems
bugs database, How to Report Bugs or Problems
bugs.mysql.com, How to Report Bugs or Problems
BuildIndexThreads, Defining NDB Cluster Data Nodes
building
client programs, Building C API Client Programs
BUILD_CONFIG option
CMake, General Options
built-in, MySQL 词汇表
bulk loading
for InnoDB tables, Bulk Data Loading for InnoDB Tables
for MyISAM tables, Bulk Data Loading for MyISAM Tables
bulk_insert_buffer_size system variable, Server System Variables
BUNDLE_RUNTIME_LIBRARIES option
CMake, General Options
business rules, MySQL 词汇表

C

[ index top ]
C API, Connectors and APIs
binary log, C API Binary Log Interface
data structures, C API Data Structures
data types, MySQL C API
example programs, Example C API Client Programs
functions, C API Function Overview
linking problems, Troubleshooting Problems Linking to the MySQL Client Library
C binary log API
data structures, C API Binary Log Data Structures
functions, C API Binary Log Function Overview
C prepared statement API
data structures, C API Prepared Statement Data Structures
functions, C API Prepared Statement Type Conversions , C API Prepared Statement Function Overview
type codes, C API Prepared Statement Type Codes
C++, MySQL Connector/C++
C:\my.cnf option file, Using Client Programs in a Multiple-Server Environment
ca-certs-file option
ndb_setup.py, ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster
cache, MySQL 词汇表
CACHE INDEX statement, CACHE INDEX Syntax
caches
clearing, FLUSH Syntax
cache_policies table, InnoDB memcached Plugin Configuration Tables
caching_sha2_password
authentication method unknown to the client error, caching_sha2_password as the Preferred Authentication Plugin
cannot be loaded error, caching_sha2_password as the Preferred Authentication Plugin
is not supported error, caching_sha2_password as the Preferred Authentication Plugin
caching_sha2_password authentication plugin, Caching SHA-2 Pluggable Authentication
compatibility, caching_sha2_password as the Preferred Authentication Plugin
caching_sha2_password_auto_generate_rsa_keys system variable, Server System Variables
caching_sha2_password_private_key_path system variable, Server System Variables
caching_sha2_password_public_key_path system variable, Server System Variables
Caching_sha2_password_rsa_public_key status variable, Server Status Variables
calculating
aggregate value for a set of rows, Aggregate (GROUP BY) Function Descriptions
cardinality, SHOW INDEX Syntax
dates, Date Calculations
calendar, What Calendar Is Used By MySQL?
CALL, CALL Syntax
calling sequences for aggregate functions
UDF, UDF Calling Sequences for Aggregate Functions
calling sequences for simple functions
UDF, UDF Calling Sequences for Simple Functions
can't create/write to file, Can't create/write to file
Can't reopen table
error message, TEMPORARY Table Problems
CAN_ACCESS_COLUMN(), Internal Functions
CAN_ACCESS_DATABASE(), Internal Functions
CAN_ACCESS_TABLE(), Internal Functions
CAN_ACCESS_VIEW(), Internal Functions
cardinality, Avoiding Full Table Scans , MySQL 词汇表
carriage return (\r), String Literals , Functions That Modify JSON Values , Field and Line Handling
CASE, Control Flow Functions , CASE Syntax
case sensitivity
access checking, Grant Tables
account names, Specifying Account Names
in identifiers, Identifier Case Sensitivity
in names, Identifier Case Sensitivity
in searches, Case Sensitivity in String Searches
in string comparisons, String Comparison Functions
of database names, MySQL Extensions to Standard SQL
of replication filtering options, How Servers Evaluate Replication Filtering Rules
of table names, MySQL Extensions to Standard SQL
CAST, Cast Functions and Operators
cast functions, Cast Functions and Operators
cast operators, Cast Functions and Operators
casts, Type Conversion in Expression Evaluation , Comparison Functions and Operators , Cast Functions and Operators
catalogs table
data dictionary table, Data Dictionary Tables
CC environment variable, Dealing with Problems Compiling MySQL , MySQL Program Environment Variables
CEIL(), Mathematical Functions
CEILING(), Mathematical Functions
cert-file option
ndb_setup.py, ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster
.cfg file, MySQL 词汇表
cflags option
mysql_config, mysql_config — Display Options for Compiling Clients
change buffer, Change Buffer , MySQL 词汇表
monitoring, Monitoring the Change Buffer
change buffering, MySQL 词汇表
disabling, Configuring Change Buffering
CHANGE MASTER TO, CHANGE MASTER TO Syntax
in NDB Cluster, Preparing the NDB Cluster for Replication
CHANGE REPLICATION FILTER, CHANGE REPLICATION FILTER Syntax
Change user
thread command, Thread Command Values
changes to privileges, When Privilege Changes Take Effect
changing
column, ALTER TABLE Syntax
field, ALTER TABLE Syntax
socket location, mysql.server — MySQL Server Startup Script , How to Protect or Change the MySQL Unix Socket File
table, ALTER TABLE Syntax , Problems with ALTER TABLE
Changing master
thread state, Replication Slave Connection Thread States
channel, Replication Channels
commands, Commands for Operations on a Single Channel
CHAR data type, String Type Overview , String Types
CHAR VARYING data type, String Type Overview
CHAR(), String Functions
CHARACTER data type, String Type Overview
character set introducer, Character Set Introducers
character set repertoire, The utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)
character sets, Character Sets, Collations, Unicode
adding, Adding a Character Set
and replication, Replication and Character Sets
Asian, Asian Character Sets
Baltic, Baltic Character Sets
binary, The Binary Character Set
Central European, Central European Character Sets
Cyrillic, Cyrillic Character Sets
Middle East, South European and Middle East Character Sets
repertoire, Character Set Repertoire
restrictions, Restrictions on Character Sets
South European, South European and Middle East Character Sets
Unicode, Unicode Character Sets
West European, West European Character Sets
CHARACTER VARYING data type, String Type Overview
character-set-client-handshake option
mysqld, Server Command Options
character-set-filesystem option
mysqld, Server Command Options
character-set-server option
mysqld, Server Command Options
character-sets-dir option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
ndb_move_data, ndb_move_data — NDB Data Copy Utility
character-sets-dir option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
characters
multibyte, Multi-Byte Character Support for Complex Character Sets
CHARACTER_LENGTH(), String Functions
CHARACTER_SETS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table
character_sets table
data dictionary table, Data Dictionary Tables
character_sets_dir system variable, Server System Variables
character_set_client system variable, Server System Variables
character_set_connection system variable, Server System Variables
character_set_database system variable, Server System Variables
character_set_filesystem system variable, Server System Variables
character_set_results system variable, Server System Variables
character_set_server system variable, Server System Variables
character_set_system system variable, Server System Variables
charset command
mysql, mysql Client Commands
charset option
comp_err, comp_err — Compile MySQL Error Message File
CHARSET(), Information Functions
CHAR_LENGTH(), String Functions
CHECK constraints
ALTER TABLE, ALTER TABLE Syntax
CREATE TABLE, CHECK Constraints
RENAME TABLE, RENAME TABLE Syntax
SHOW CREATE TABLE, SHOW CREATE TABLE Syntax
check option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance Program
check options
myisamchk, myisamchk Check Options
CHECK TABLE
and partitioning, Maintenance of Partitions
CHECK TABLE statement, CHECK TABLE Syntax
check-only-changed option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance Program
check-orphans option
ndb_blob_tool, ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
check-upgrade option
mysqlcheck, mysqlcheck — A Table Maintenance Program
checking
tables for errors, How to Check MyISAM Tables for Errors
Checking master version
thread state, Replication Slave I/O Thread States
checking permissions
thread state, General Thread States
Checking table
thread state, General Thread States
checkpoint, MySQL 词汇表
CHECKPOINT Events (NDB Cluster), NDB Cluster Log Events
Checksum, NDB Cluster TCP/IP Connections , SCI Transport Connections in NDB Cluster
checksum, MySQL 词汇表
Checksum (NDB Cluster), NDB Cluster Shared-Memory Connections
checksum errors, Installing MySQL on Solaris
CHECKSUM TABLE
and replication, Replication and CHECKSUM TABLE
CHECKSUM TABLE statement, CHECKSUM TABLE Syntax
CHECK_CONSTRAINTS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
check_constraints table
data dictionary table, Data Dictionary Tables
check_proxy_users system variable, Server System Variables , Server Support for Proxy User Mapping
child table, MySQL 词汇表
Chinese, Japanese, Korean character sets
frequently asked questions, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
choosing
a MySQL version, Which MySQL Version and Distribution to Install
data types, Choosing the Right Type for a Column
chroot option
mysqld, Server Command Options
circular replication
in NDB Cluster, Known Issues in NDB Cluster Replication , NDB Cluster Replication: Multi-Master and Circular Replication , NDB Cluster Replication Conflict Resolution
CJK (Chinese, Japanese, Korean)
Access, PHP, etc., MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
availability of specific characters, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
big5, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
character sets available, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
characters displayed as question marks, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
CJKV, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
collations, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
conversion problems with Japanese character sets, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
data truncation, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Database and table names, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
documentation in Chinese, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
documentation in Japanese, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
documentation in Korean, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
FAQ, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
gb2312, gbk, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Japanese character sets, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Korean character set, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
LIKE and FULLTEXT, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
MySQL 4.0 behavior, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
ORDER BY treatment, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with Access, PHP, etc., MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with Big5 character sets (Chinese), MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with data truncation, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with euckr character set (Korean), MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with GB character sets (Chinese), MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with LIKE and FULLTEXT, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
problems with Yen sign (Japanese), MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
rejected characters, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
sort order problems, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
sorting problems, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
testing availability of characters, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Unicode collations, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Vietnamese, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Yen sign, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
clean page, MySQL 词汇表
clean shutdown, The Server Shutdown Process , Setting Up Multiple Data Directories , Replication and Master or Slave Shutdowns , MySQL 词汇表
cleaning up
thread state, General Thread States
clear command
mysql, mysql Client Commands
Clearing
thread state, Event Scheduler Thread States
clearing
caches, FLUSH Syntax
client, MySQL 词汇表
client connections, How MySQL Handles Client Connections
client programs, Overview of MySQL Programs
building, Building C API Client Programs
client tools, Connectors and APIs
clients
debugging, Debugging a MySQL Client
threaded, Writing C API Threaded Client Programs
cloning tables, CREATE TABLE ... LIKE Syntax
CLOSE, Cursor CLOSE Syntax
Close stmt
thread command, Thread Command Values
closing
tables, How MySQL Opens and Closes Tables
closing tables
thread state, General Thread States
cluster database (OBSOLETE) (see NDB Cluster replication )
cluster logs, Event Reports Generated in NDB Cluster , NDB Cluster Logging Management Commands
cluster.binlog_index table (OBSOLETE) (see NDB Cluster replication )
clustered index, MySQL 词汇表
InnoDB, Clustered and Secondary Indexes
Clustering (see NDB Cluster )
CLUSTERLOG commands (NDB Cluster), NDB Cluster Logging Management Commands
CLUSTERLOG STATISTICS command (NDB Cluster), Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client
cluster_locks
ndbinfo table, The ndbinfo cluster_locks Table
cluster_operations
ndbinfo table, The ndbinfo cluster_operations Table
cluster_replication database (OBSOLETE) (see NDB Cluster replication )
cluster_transactions
ndbinfo table, The ndbinfo cluster_transactions Table
CMake
BUILD_CONFIG option, General Options
BUNDLE_RUNTIME_LIBRARIES option, General Options
CMAKE_BUILD_TYPE option, General Options
CMAKE_CXX_FLAGS option, Compiler Flags
CMAKE_C_FLAGS option, Compiler Flags
CMAKE_INSTALL_PREFIX option, Installation Layout Options
COMPILATION_COMMENT option, Feature Options
COMPILATION_COMMENT_SERVER option, Feature Options
CPACK_MONOLITHIC_INSTALL option, General Options
DEFAULT_CHARSET option, Feature Options
DEFAULT_COLLATION option, Feature Options
DISABLE_PSI_COND option, Feature Options
DISABLE_PSI_DATA_LOCK option, Feature Options
DISABLE_PSI_ERROR option, Feature Options
DISABLE_PSI_FILE option, Feature Options
DISABLE_PSI_IDLE option, Feature Options
DISABLE_PSI_MEMORY option, Feature Options
DISABLE_PSI_METADATA option, Feature Options
DISABLE_PSI_MUTEX option, Feature Options
DISABLE_PSI_PS option, Feature Options
DISABLE_PSI_RWLOCK option, Feature Options
DISABLE_PSI_SOCKET option, Feature Options
DISABLE_PSI_SP option, Feature Options
DISABLE_PSI_STAGE option, Feature Options
DISABLE_PSI_STATEMENT option, Feature Options
DISABLE_PSI_STATEMENT_DIGEST option, Feature Options
DISABLE_PSI_TABLE option, Feature Options
DISABLE_PSI_THREAD option, Feature Options
DISABLE_PSI_TRANSACTION option, Feature Options
DISABLE_SHARED option, Feature Options
DOWNLOAD_BOOST option, Feature Options
DOWNLOAD_BOOST_TIMEOUT option, Feature Options
ENABLED_LOCAL_INFILE option, Feature Options
ENABLED_PROFILING option, Feature Options
ENABLE_DEBUG_SYNC option, Feature Options
ENABLE_DOWNLOADS option, Feature Options
ENABLE_DTRACE option, Feature Options
ENABLE_EXPERIMENTAL_SYSVARS option, Feature Options
ENABLE_GCOV option, Feature Options
ENABLE_GPROF option, Feature Options
FORCE_INSOURCE_BUILD option, General Options
FORCE_UNSUPPORTED_COMPILER option, Feature Options
IGNORE_AIO_CHECK option, Feature Options
INSTALL_BINDIR option, Installation Layout Options
INSTALL_DOCDIR option, Installation Layout Options
INSTALL_DOCREADMEDIR option, Installation Layout Options
INSTALL_INCLUDEDIR option, Installation Layout Options
INSTALL_INFODIR option, Installation Layout Options
INSTALL_LAYOUT option, Installation Layout Options
INSTALL_LIBDIR option, Installation Layout Options
INSTALL_MANDIR option, Installation Layout Options
INSTALL_MYSQLKEYRINGDIR option, Installation Layout Options
INSTALL_MYSQLSHAREDIR option, Installation Layout Options
INSTALL_MYSQLTESTDIR option, Installation Layout Options
INSTALL_PKGCONFIGDIR option, Installation Layout Options
INSTALL_PLUGINDIR option, Installation Layout Options
INSTALL_SBINDIR option, Installation Layout Options
INSTALL_SECURE_FILE_PRIVDIR option, Installation Layout Options
INSTALL_SHAREDIR option, Installation Layout Options
INSTALL_STATIC_LIBRARIES option, Installation Layout Options
INSTALL_SUPPORTFILESDIR option, Installation Layout Options
LINK_RANDOMIZE option, Installation Layout Options
LINK_RANDOMIZE_SEED option, Installation Layout Options
MAX_INDEXES option, Feature Options
MEMCACHED_HOME option, CMake Options for Compiling NDB Cluster
MUTEX_TYPE option, Feature Options
MYSQLX_TCP_PORT option, Feature Options
MYSQLX_UNIX_ADDR option, Feature Options
MYSQL_DATADIR option, Installation Layout Options
MYSQL_MAINTAINER_MODE option, Feature Options
MYSQL_PROJECT_NAME option, Feature Options
MYSQL_TCP_PORT option, Feature Options
MYSQL_UNIX_ADDR option, Feature Options
ODBC_INCLUDES option, Installation Layout Options
ODBC_LIB_DIR option, Installation Layout Options
OPTIMIZER_TRACE option, Feature Options
options, MySQL Source-Configuration Options
REPRODUCIBLE_BUILD option, Feature Options
running after prior invocation, Configure the Distribution , Dealing with Problems Compiling MySQL
SYSCONFDIR option, Installation Layout Options
SYSTEMD_PID_DIR option, Installation Layout Options
SYSTEMD_SERVICE_NAME option, Installation Layout Options
TMPDIR option, Installation Layout Options
USE_LD_GOLD option, Feature Options
VERSION file, MySQL Configuration and Third-Party Tools
WIN_DEBUG_NO_INLINE option, Feature Options
WITH_ANT option, Feature Options
WITH_ASAN option, Feature Options
WITH_ASAN_SCOPE option, Feature Options
WITH_AUTHENTICATION_LDAP option, Feature Options
WITH_AUTHENTICATION_PAM option, Feature Options
WITH_AWS_SDK option, Feature Options
WITH_BOOST option, Feature Options
WITH_BUNDLED_LIBEVENT option, CMake Options for Compiling NDB Cluster
WITH_BUNDLED_MEMCACHED option, CMake Options for Compiling NDB Cluster
WITH_CLASSPATH option, CMake Options for Compiling NDB Cluster
WITH_CLIENT_PROTOCOL_TRACING option, Feature Options
WITH_CURL option, Feature Options
WITH_DEBUG option, Feature Options
WITH_DEFAULT_COMPILER_OPTIONS option, Compiler Flags
WITH_DEFAULT_FEATURE_SET option, Feature Options
WITH_EDITLINE option, Feature Options
WITH_ERROR_INSERT option, CMake Options for Compiling NDB Cluster
WITH_GMOCK option, Feature Options
WITH_ICU option, Feature Options
WITH_INNODB_EXTRA_DEBUG option, Feature Options
WITH_INNODB_MEMCACHED option, Feature Options
WITH_JEMALLOC option, Feature Options
WITH_KEYRING_TEST option, Feature Options
WITH_LIBEVENT option, Feature Options
WITH_LIBWRAP option, Feature Options
WITH_LSAN option, Feature Options
WITH_LTO option, Feature Options
WITH_LZ4 option, Feature Options
WITH_LZMA option, Feature Options
WITH_MECAB option, Feature Options
WITH_MSAN option, Feature Options
WITH_MSCRT_DEBUG option, Feature Options
WITH_MYSQLX option, Feature Options
WITH_NDBCLUSTER option, CMake Options for Compiling NDB Cluster
WITH_NDBCLUSTER_STORAGE_ENGINE option, CMake Options for Compiling NDB Cluster
WITH_NDBMTD option, CMake Options for Compiling NDB Cluster
WITH_NDB_BINLOG option, CMake Options for Compiling NDB Cluster
WITH_NDB_DEBUG option, CMake Options for Compiling NDB Cluster
WITH_NDB_JAVA option, CMake Options for Compiling NDB Cluster
WITH_NDB_PORT option, CMake Options for Compiling NDB Cluster
WITH_NDB_TEST option, CMake Options for Compiling NDB Cluster
WITH_NUMA option, Feature Options
WITH_PLUGIN_NDBCLUSTER option, CMake Options for Compiling NDB Cluster
WITH_PROTOBUF option, Feature Options
WITH_RAPID option, Feature Options
WITH_RAPIDJSON option, Feature Options
WITH_RE2 option, Feature Options
WITH_ROUTER option, Feature Options
WITH_SSL option, Feature Options
WITH_SYSTEMD option, Feature Options
WITH_SYSTEM_LIBS option, Feature Options
WITH_TEST_TRACE_PLUGIN option, Feature Options
WITH_TSAN option, Feature Options
WITH_UBSAN option, Feature Options
WITH_UNIT_TESTS option, Feature Options
WITH_UNIXODBC option, Feature Options
WITH_VALGRIND option, Feature Options
WITH_ZLIB option, Feature Options
CMakeCache.txt file, Dealing with Problems Compiling MySQL
CMAKE_BUILD_TYPE option
CMake, General Options
CMAKE_CXX_FLAGS option
CMake, Compiler Flags
CMAKE_C_FLAGS option
CMake, Compiler Flags
CMAKE_INSTALL_PREFIX option
CMake, Installation Layout Options
COALESCE(), Comparison Functions and Operators
coercibility
collation, Collation Coercibility in Expressions
COERCIBILITY(), Information Functions
cold backup, MySQL 词汇表
collating
strings, String Collating Support for Complex Character Sets
collation
adding, Adding a Collation to a Character Set
coercibility, Collation Coercibility in Expressions
INFORMATION_SCHEMA, Using Collation in INFORMATION_SCHEMA Searches
modifying, Adding a Collation to a Character Set
COLLATION(), Information Functions
collation-server option
mysqld, Server Command Options
collations, Character Sets, Collations, Unicode
Asian, Asian Character Sets
Baltic, Baltic Character Sets
binary, The binary Collation Compared to _bin Collations , The Binary Character Set
Central European, Central European Character Sets
Cyrillic, Cyrillic Character Sets
Middle East, South European and Middle East Character Sets
naming conventions, Collation Naming Conventions
NO PAD, The binary Collation Compared to _bin Collations , Unicode Character Sets , The CHAR and VARCHAR Types
PAD SPACE, The binary Collation Compared to _bin Collations , Unicode Character Sets , The CHAR and VARCHAR Types
South European, South European and Middle East Character Sets
Unicode, Unicode Character Sets
West European, West European Character Sets
_ai suffix, Collation Naming Conventions
_as suffix, Collation Naming Conventions
_bin suffix, Collation Naming Conventions , The binary Collation Compared to _bin Collations
_ci suffix, Collation Naming Conventions
_ks suffix, Collation Naming Conventions
_ss suffix, Collation Naming Conventions
COLLATIONS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table
collations table
data dictionary table, Data Dictionary Tables
COLLATION_CHARACTER_SET_APPLICABILITY
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
collation_connection system variable, Server System Variables
collation_database system variable, Server System Variables
collation_server system variable, Server System Variables
color option
ndb_top, ndb_top — View CPU usage information for NDB threads
column, MySQL 词汇表
changing, ALTER TABLE Syntax
types, Data Types
column alias
problems, Problems with Column Aliases
quoting, Schema Object Names , Problems with Column Aliases
column comments, CREATE TABLE Syntax
column format, CREATE TABLE Syntax
column index, MySQL 词汇表
column names
case sensitivity, Identifier Case Sensitivity
column prefix, MySQL 词汇表
column storage, CREATE TABLE Syntax
column-names option
mysql, mysql Client Options
column-statistics option
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
column-type-info option
mysql, mysql Client Options
columns
displaying, mysqlshow — Display Database, Table, and Column Information
indexes, Column Indexes
names, Schema Object Names
other types, Using Data Types from Other Database Engines
selecting, Selecting Particular Columns
storage requirements, Data Type Storage Requirements
COLUMNS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table
columns option
mysqlimport, mysqlimport — A Data Import Program
columns partitioning, COLUMNS Partitioning
columns per table
maximum, Limits on Table Column Count and Row Size
columns table
data dictionary table, Data Dictionary Tables
columns_priv table
system table, Grant System Tables , Grant Tables
COLUMN_PRIVILEGES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
COLUMN_STATISTICS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_STATISTICS Table
column_statistics table
system table, Data Dictionary Tables , Optimizer Statistics
column_type_elements table
data dictionary table, Data Dictionary Tables
comma-separated values data, reading, Field and Line Handling , SELECT ... INTO Syntax
command option precedence, Specifying Program Options
command options
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqld, Server Command Options
command options (NDB Cluster)
mysqld, MySQL Server Options for NDB Cluster
ndbd, ndbd — The NDB Cluster Data Node Daemon
ndbinfo_select_all, ndbinfo_select_all — Select From ndbinfo Tables
ndb_mgm, ndb_mgm — The NDB Cluster Management Client
ndb_mgmd, ndb_mgmd — The NDB Cluster Management Server Daemon
command syntax, Typographical and Syntax Conventions
command-line history
mysql, mysql Client Logging
command-line options (NDB Cluster), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
command-line tool, MySQLInstallerConsole Reference , mysql — The MySQL Command-Line Client
commands
for binary distribution, Installing MySQL on Unix/Linux Using Generic Binaries
commands out of sync, Commands out of sync
comment syntax, Comment Syntax
comments
adding, Comment Syntax
starting, '--' as the Start of a Comment
comments option
mysql, mysql Client Options
mysqldump, mysqldump — A Database Backup Program
COMMIT, START TRANSACTION, COMMIT, and ROLLBACK Syntax
XA transactions, XA Transaction SQL Syntax
commit, MySQL 词汇表
commit option
mysqlslap, mysqlslap — Load Emulation Client
committing alter table to storage engine
thread state, General Thread States
Committing events to binlog
thread state, NDB Cluster Thread States
common table expressions, The Rows Holding the Group-wise Maximum of a Certain Column , WITH Syntax (Common Table Expressions)
optimization, Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions , Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization
compact option
mysqldump, mysqldump — A Database Backup Program
compact row format, COMPACT Row Format , MySQL 词汇表
comparison operators, Comparison Functions and Operators
comparisons
access checking, Grant Tables
account names, Specifying Account Names
compatibility
with ODBC, Server System Variables , Numeric Type Overview , Type Conversion in Expression Evaluation , Comparison Functions and Operators , CREATE TABLE Syntax , JOIN Syntax
with Oracle, MySQL Extensions to Standard SQL , Aggregate (GROUP BY) Function Descriptions , ALTER TABLE Syntax , Obtaining Table Structure Information
with PostgreSQL, MySQL Extensions to Standard SQL
with standard SQL, MySQL Standards Compliance
compatible option
mysqldump, mysqldump — A Database Backup Program
COMPILATION_COMMENT option
CMake, Feature Options
COMPILATION_COMMENT_SERVER option
CMake, Feature Options
compiling
user-defined functions, UDF Compiling and Installing
compiling clients
on Unix, Compiling MySQL Clients on Unix
on Windows, Compiling MySQL Clients on Microsoft Windows
compiling MySQL server
problems, Dealing with Problems Compiling MySQL
complete-insert option
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
completion_type system variable, Server System Variables
component installing
validate_password, Password Validation Component Installation and Uninstallation
component service
status_variable_registration, MySQL Services for Plugins
component table
system table, Object Information System Tables
component uninstalling
validate_password, Password Validation Component Installation and Uninstallation
components
installing, INSTALL COMPONENT Syntax
security, Security Components and Plugins
server, MySQL Server Components
uninstalling, UNINSTALL COMPONENT Syntax
composite index, MySQL 词汇表
composite partitioning, Subpartitioning
compound statements, Compound-Statement Syntax
compress option
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
COMPRESS(), Encryption and Compression Functions
compress-output option
mysqlpump, mysqlpump — A Database Backup Program
compressed backup, MySQL 词汇表
compressed row format, COMPRESSED Row Format , MySQL 词汇表
compressed table, MySQL 词汇表
compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables , Compressed Table Characteristics
CompressedBackup, Defining NDB Cluster Data Nodes
CompressedLCP, Defining NDB Cluster Data Nodes
compression, InnoDB Table and Page Compression , InnoDB Page Compression , MySQL 词汇表
algorithms, How Compression Works for InnoDB Tables
application and schema design, Tuning Compression for InnoDB Tables
BLOBs, VARCHAR and TEXT, How Compression Works for InnoDB Tables
buffer pool considerations, How Compression Works for InnoDB Tables
compressed page size, Tuning Compression for InnoDB Tables
configuration characteristics, Tuning Compression for InnoDB Tables
data and indexes, How Compression Works for InnoDB Tables
data characteristics, Tuning Compression for InnoDB Tables
enabling for a table, Creating Compressed Tables
implementation, How Compression Works for InnoDB Tables
information schema, InnoDB INFORMATION_SCHEMA Tables about Compression
KEY_BLOCK_SIZE, Tuning Compression for InnoDB Tables
log file format, How Compression Works for InnoDB Tables
modification log, How Compression Works for InnoDB Tables
monitoring, Monitoring InnoDB Table Compression at Runtime
overflow pages, How Compression Works for InnoDB Tables
overview, Overview of Table Compression
tuning, Tuning Compression for InnoDB Tables
workload characteristics, Tuning Compression for InnoDB Tables
compression failure, MySQL 词汇表
comp_err, Overview of MySQL Programs , comp_err — Compile MySQL Error Message File
charset option, comp_err — Compile MySQL Error Message File
debug option, comp_err — Compile MySQL Error Message File
debug-info option, comp_err — Compile MySQL Error Message File
header_file option, comp_err — Compile MySQL Error Message File
help option, comp_err — Compile MySQL Error Message File
in_file option, comp_err — Compile MySQL Error Message File
name_file option, comp_err — Compile MySQL Error Message File
out_dir option, comp_err — Compile MySQL Error Message File
out_file option, comp_err — Compile MySQL Error Message File
statefile option, comp_err — Compile MySQL Error Message File
version option, comp_err — Compile MySQL Error Message File
CONCAT(), String Functions
concatenation
string, String Literals , String Functions
CONCAT_WS(), String Functions
concurrency, Introduction to InnoDB , MySQL 词汇表
of commits, InnoDB Startup Options and System Variables
of threads, InnoDB Startup Options and System Variables
tickets, InnoDB Startup Options and System Variables
concurrency option
mysqlslap, mysqlslap — Load Emulation Client
concurrent inserts, Table-Level Locking , Concurrent Inserts
concurrent_insert system variable, Server System Variables
condition handling
INOUT parameters, Condition Handling and OUT or INOUT Parameters
OUT parameters, Condition Handling and OUT or INOUT Parameters
Conditions, DECLARE ... CONDITION Syntax
conditions, SHOW ERRORS Syntax , SHOW WARNINGS Syntax
cond_instances table
performance_schema, The cond_instances Table
config-cache option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
config-file option
my_print_defaults, my_print_defaults — Display Options from Option Files
ndb_config, ndb_config — Extract NDB Cluster Configuration Information
config-file option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
config.ini (NDB Cluster), Initial Configuration of NDB Cluster , NDB Cluster Configuration Files , NDB Cluster Configuration: Basic Example , ndb_mgmd — The NDB Cluster Management Server Daemon
configdir option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
ConfigGenerationNumber, Defining the System
configinfo option
ndb_config, ndb_config — Extract NDB Cluster Configuration Information
configuration
NDB Cluster, Overview of NDB Cluster Configuration Parameters, Options, and Variables
server, Configuring the Server
configuration file, MySQL 词汇表
configuration files, Troubleshooting Problems Connecting to MySQL
configure option
MySQLInstallerConsole, MySQLInstallerConsole Reference
configuring backups
in NDB Cluster, Configuration for NDB Cluster Backups
configuring NDB Cluster, NDB Cluster Installation , Configuration of NDB Cluster , ndb_mgmd — The NDB Cluster Management Server Daemon , MySQL Server Usage for NDB Cluster
Configuring NDB Cluster (concepts), NDB Cluster Core Concepts
config_from_node option
ndb_config, ndb_config — Extract NDB Cluster Configuration Information
config_nodes
ndbinfo table, The ndbinfo config_nodes Table
config_options table, InnoDB memcached Plugin Configuration Tables
config_params
ndbinfo table, The ndbinfo config_params Table
config_values
ndbinfo table, The ndbinfo config_values Table
conflict detection status variables
NDB Cluster Replication, NDB Cluster Replication Conflict Resolution
conflict resolution
and ndb_replication system table, NDB Cluster Replication Conflict Resolution
enabling, NDB Cluster Replication Conflict Resolution
in NDB Cluster Replication, NDB Cluster Replication Conflict Resolution
mysqld startup options, NDB Cluster Replication Conflict Resolution
Connect
thread command, Thread Command Values
connect command
mysql, mysql Client Commands
CONNECT command (NDB Cluster), Commands in the NDB Cluster Management Client
connect option
ndb_restore, ndb_restore — Restore an NDB Cluster Backup
Connect Out
thread command, Thread Command Values
connect-delay option (ndbd), ndbd — The NDB Cluster Data Node Daemon
connect-delay option (ndbmtd), ndbd — The NDB Cluster Data Node Daemon
connect-expired-password option
mysql, mysql Client Options
connect-retries option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
connect-retries option (ndbd), ndbd — The NDB Cluster Data Node Daemon
connect-retries option (ndbmtd), ndbd — The NDB Cluster Data Node Daemon
connect-retries option (ndb_mgm), ndb_mgm — The NDB Cluster Management Client
connect-retry-delay option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
connect-retry-delay option (ndbd), ndbd — The NDB Cluster Data Node Daemon
connect-retry-delay option (ndbmtd), ndbd — The NDB Cluster Data Node Daemon
connect-string option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
ConnectBackoffMaxTime, Defining SQL and Other API Nodes in an NDB Cluster
ConnectCheckIntervalDelay, Defining NDB Cluster Data Nodes
connecting
key-value pairs, Connecting using Key-value Pairs
parameters, Base Connection Parameters
remotely with SSH, Connecting to MySQL Remotely from Windows with SSH
to the server, Connecting to and Disconnecting from the Server , Connecting to the MySQL Server
uri type string, Connecting using a URI String
using a URI, Connecting Using a URI or Key-Value Pairs
using key-value pairs, Connecting Using a URI or Key-Value Pairs
verification, Access Control, Stage 1: Connection Verification
Connecting to master
thread state, Replication Slave I/O Thread States
connection
aborted, Communication Errors and Aborted Connections
CONNECTION Events (NDB Cluster), NDB Cluster Log Events
connection string (see NDB Cluster )
connection-server-id option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
connection-timeout option (ndb_error_reporter), ndb_error_reporter — NDB Error-Reporting Utility
ConnectionMap, Defining SQL and Other API Nodes in an NDB Cluster
connections option
ndb_config, ndb_config — Extract NDB Cluster Configuration Information
ndb_import, ndb_import — Import CSV Data Into NDB
CONNECTION_CONTROL plugin
installing, Connection-Control Plugin Installation
status variables, Connection-Control Status Variables
system variables, Connection-Control System Variables
Connection_control_delay_generated status variable, Connection-Control Status Variables
connection_control_failed_connections_threshold system variable, Connection-Control System Variables
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table
CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin
installing, Connection-Control Plugin Installation
connection_control_max_connection_delay system variable, Connection-Control System Variables
connection_control_min_connection_delay system variable, Connection-Control System Variables
CONNECTION_ID(), Information Functions
Connector/C, Connectors and APIs , MySQL Connector/C
Connector/C++, Connectors and APIs , MySQL Connector/C++
Connector/J, Connectors and APIs , MySQL Connector/J
Connector/NET, Connectors and APIs , MySQL Connector/NET
Connector/ODBC, Connectors and APIs , MySQL Connector/ODBC
Connector/Python, Connectors and APIs , MySQL Connector/Python
Connectors, Connectors and APIs
connect_timeout system variable, Server System Variables
connect_timeout variable, mysql Client Options , mysqladmin — Client for Administering a MySQL Server
consistent read, MySQL 词汇表
consistent reads, Consistent Nonlocking Reads
console option
mysqld, Server Command Options
const table
optimizer, EXPLAIN Join Types , SELECT Syntax
constant table, WHERE Clause Optimization
constraint, MySQL 词汇表
constraints, How MySQL Deals with Constraints
foreign keys, Using FOREIGN KEY Constraints
containers table, InnoDB memcached Plugin Configuration Tables
continue option
ndb_import, ndb_import — Import CSV Data Into NDB
contributing companies
list of, Supporters of MySQL
contributors
list of, Contributors to MySQL
control flow functions, Control Flow Functions
Control+C
statement termination, mysql — The MySQL Command-Line Client , mysql Client Options , Limiting Common Table Expression Recursion
CONV(), Mathematical Functions
conventions
syntax, Typographical and Syntax Conventions
typographical, Typographical and Syntax Conventions
CONVERT, Cast Functions and Operators
CONVERT TO, ALTER TABLE Syntax
converting HEAP to ondisk
thread state, General Thread States
CONVERT_TZ(), Date and Time Functions
copy to tmp table
thread state, General Thread States
copying databases, Copying MySQL Databases to Another Machine
copying tables, CREATE TABLE ... SELECT Syntax
Copying to group table
thread state, General Thread States
Copying to tmp table
thread state, General Thread States
Copying to tmp table on disk
thread state, General Thread States
core-file option
mysqld, Server Command Options
core-file option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
core-file-size option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
core_file system variable, Server System Variables
correct-checksum option
myisamchk, myisamchk Repair Options
correlated subqueries, Correlated Subqueries
corruption, Forcing InnoDB Recovery
InnoDB, Recovery from Data Corruption or Disk Failure
COS(), Mathematical Functions
cost model
optimizer, The Optimizer Cost Model
COT(), Mathematical Functions
count option
innochecksum, innochecksum — Offline InnoDB File Checksum Utility
myisam_ftdump, myisam_ftdump — Display Full-Text Index information
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlshow, mysqlshow — Display Database, Table, and Column Information
COUNT(), Aggregate (GROUP BY) Function Descriptions
COUNT(DISTINCT), Aggregate (GROUP BY) Function Descriptions
counter, MySQL 词汇表
counters
ndbinfo table, The ndbinfo counters Table
counting
table rows, Counting Rows
covering index, MySQL 词汇表
CPACK_MONOLITHIC_INSTALL option
CMake, General Options
CPU-bound, MySQL 词汇表
cpustat
ndbinfo table, The ndbinfo cpustat Table
cpustat_1sec
ndbinfo table, The ndbinfo cpustat_1sec Table
cpustat_20sec
ndbinfo table, The ndbinfo cpustat_20sec Table
cpustat_50ms
ndbinfo table, The ndbinfo cpustat_50ms Table
crash, Debugging a MySQL Server , MySQL 词汇表
recovery, Using myisamchk for Crash Recovery
repeated, What to Do If MySQL Keeps Crashing
replication, Replication and Master or Slave Shutdowns
crash recovery, MySQL 词汇表
InnoDB, InnoDB Crash Recovery , Tablespace Discovery During Crash Recovery
crash-safe replication, Startup Options for Replication Slaves , Options for Logging Slave Status to Tables , Handling an Unexpected Halt of a Replication Slave
CrashOnCorruptedTuple, Defining NDB Cluster Data Nodes
CRC32(), Mathematical Functions
CREATE ... IF NOT EXISTS
and replication, Replication of CREATE ... IF NOT EXISTS Statements
CREATE DATABASE, CREATE DATABASE Syntax
Create DB
thread command, Thread Command Values
CREATE EVENT, CREATE EVENT Syntax
and replication, Replication of Invoked Features
CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax
CREATE FUNCTION statement, CREATE FUNCTION Syntax for User-Defined Functions
CREATE INDEX, CREATE INDEX Syntax
CREATE LOGFILE GROUP, CREATE LOGFILE GROUP Syntax
(see also NDB Cluster Disk Data )
CREATE NODEGROUP command (NDB Cluster), Commands in the NDB Cluster Management Client
create option
mysqlslap, mysqlslap — Load Emulation Client
CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION Syntax
CREATE RESOURCE GROUP statement, CREATE RESOURCE GROUP Syntax
CREATE ROLE statement, CREATE ROLE Syntax
CREATE SCHEMA, CREATE DATABASE Syntax
CREATE SERVER, CREATE SERVER Syntax
CREATE SPATIAL REFERENCE SYSTEM, CREATE SPATIAL REFERENCE SYSTEM Syntax
CREATE TABLE, CREATE TABLE Syntax
DIRECTORY options
and replication, Replication and DIRECTORY Table Options
KEY_BLOCK_SIZE, Tuning Compression for InnoDB Tables
NDB_TABLE options, Setting NDB_TABLE Options
options for table compression, Creating Compressed Tables
ROW_FORMAT, Defining the Row Format of a Table
statement retention, CREATE TABLE Statement Retention
table definition, CREATE TABLE Statement Retention
CREATE TABLE ... SELECT
and replication, Replication of CREATE TABLE ... SELECT Statements
CREATE TABLESPACE, CREATE TABLESPACE Syntax
general tablespace, CREATE TABLESPACE Syntax
undo tablespace, CREATE TABLESPACE Syntax
CREATE TRIGGER, CREATE TRIGGER Syntax
CREATE USER statement, Assigning Account Passwords , CREATE USER Syntax
CREATE VIEW, CREATE VIEW Syntax
create-options option
mysqldump, mysqldump — A Database Backup Program
create-schema option
mysqlslap, mysqlslap — Load Emulation Client
create_admin_listener_thread system variable, Server System Variables
CREATE_ASYMMETRIC_PRIV_KEY(), MySQL Enterprise Encryption Function Descriptions
CREATE_ASYMMETRIC_PUB_KEY(), MySQL Enterprise Encryption Function Descriptions
CREATE_DH_PARAMETERS(), MySQL Enterprise Encryption Function Descriptions
CREATE_DIGEST(), MySQL Enterprise Encryption Function Descriptions
create_synonym_db() procedure
sys schema, The create_synonym_db() Procedure
creating
bug reports, How to Report Bugs or Problems
database, CREATE DATABASE Syntax
databases, Creating and Using a Database
default startup options, Using Option Files
function, CREATE FUNCTION Syntax for User-Defined Functions
schema, CREATE DATABASE Syntax
tables, Creating a Table
Creating index
thread state, General Thread States
creating roles, CREATE ROLE Syntax
Creating sort index
thread state, General Thread States
creating table
thread state, General Thread States
Creating tmp table
thread state, General Thread States
creating user accounts, CREATE USER Syntax
CROSS JOIN, JOIN Syntax
CRUD, MySQL 词汇表
CR_ALREADY_CONNECTED error code, Client Error Message Reference
CR_AUTH_PLUGIN_CANNOT_LOAD error code, Client Error Message Reference
CR_AUTH_PLUGIN_ERR error code, Client Error Message Reference
CR_CANT_READ_CHARSET error code, Client Error Message Reference
CR_COMMANDS_OUT_OF_SYNC error code, Client Error Message Reference
CR_COMPRESSION_NOT_SUPPORTED error code, Client Error Message Reference
CR_CONNECTION_ERROR error code, Client Error Message Reference
CR_CONN_HOST_ERROR error code, Client Error Message Reference
CR_CONN_UNKNOW_PROTOCOL error code, Client Error Message Reference
CR_DATA_TRUNCATED error code, Client Error Message Reference
CR_DUPLICATE_CONNECTION_ATTR error code, Client Error Message Reference
CR_EMBEDDED_CONNECTION error code, Client Error Message Reference
CR_FETCH_CANCELED error code, Client Error Message Reference
CR_FILE_NAME_TOO_LONG error code, Client Error Message Reference
CR_INSECURE_API_ERR error code, Client Error Message Reference
CR_INVALID_BUFFER_USE error code, Client Error Message Reference
CR_INVALID_CONN_HANDLE error code, Client Error Message Reference
CR_INVALID_PARAMETER_NO error code, Client Error Message Reference
CR_IPSOCK_ERROR error code, Client Error Message Reference
CR_LOCALHOST_CONNECTION error code, Client Error Message Reference
CR_MALFORMED_PACKET error code, Client Error Message Reference
CR_NAMEDPIPEOPEN_ERROR error code, Client Error Message Reference
CR_NAMEDPIPESETSTATE_ERROR error code, Client Error Message Reference
CR_NAMEDPIPEWAIT_ERROR error code, Client Error Message Reference
CR_NAMEDPIPE_CONNECTION error code, Client Error Message Reference
CR_NET_PACKET_TOO_LARGE error code, Client Error Message Reference
CR_NEW_STMT_METADATA error code, Client Error Message Reference
CR_NOT_IMPLEMENTED error code, Client Error Message Reference
CR_NO_DATA error code, Client Error Message Reference
CR_NO_PARAMETERS_EXISTS error code, Client Error Message Reference
CR_NO_PREPARE_STMT error code, Client Error Message Reference
CR_NO_RESULT_SET error code, Client Error Message Reference
CR_NO_STMT_METADATA error code, Client Error Message Reference
CR_NULL_POINTER error code, Client Error Message Reference
CR_OUT_OF_MEMORY error code, Client Error Message Reference
CR_PARAMS_NOT_BOUND error code, Client Error Message Reference
CR_PROBE_MASTER_CONNECT error code, Client Error Message Reference
CR_PROBE_SLAVE_CONNECT error code, Client Error Message Reference
CR_PROBE_SLAVE_HOSTS error code, Client Error Message Reference
CR_PROBE_SLAVE_STATUS error code, Client Error Message Reference
CR_SERVER_GONE_ERROR, MySQL server has gone away
CR_SERVER_GONE_ERROR error code, Client Error Message Reference
CR_SERVER_HANDSHAKE_ERR error code, Client Error Message Reference
CR_SERVER_LOST error code, Client Error Message Reference
CR_SERVER_LOST_ERROR, MySQL server has gone away
CR_SERVER_LOST_EXTENDED error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECTION error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECT_MAP_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_CONNECT_SET_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_EVENT_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_FILE_MAP_ERROR error code, Client Error Message Reference
CR_SHARED_MEMORY_MAP_ERROR error code, Client Error Message Reference
CR_SOCKET_CREATE_ERROR error code, Client Error Message Reference
CR_SSL_CONNECTION_ERROR error code, Client Error Message Reference
CR_SSL_FIPS_MODE_ERR error code, Client Error Message Reference
CR_STMT_CLOSED error code, Client Error Message Reference
CR_TCP_CONNECTION error code, Client Error Message Reference
CR_UNKNOWN_ERROR error code, Client Error Message Reference
CR_UNKNOWN_HOST error code, Client Error Message Reference
CR_UNSUPPORTED_PARAM_TYPE error code, Client Error Message Reference
CR_UNUSED_1 error code, Client Error Message Reference
CR_VERSION_ERROR error code, Client Error Message Reference
CR_WRONG_HOST_INFO error code, Client Error Message Reference
CR_WRONG_LICENSE error code, Client Error Message Reference
CSV data, reading, Field and Line Handling , SELECT ... INTO Syntax
csv option
mysqlslap, mysqlslap — Load Emulation Client
CSV storage engine, Alternative Storage Engines , The CSV Storage Engine
cte_max_recursion_depth system variable, Server System Variables
CUME_DIST(), Window Function Descriptions
CURDATE(), Date and Time Functions
current row
window functions, Window Function Concepts and Syntax
CURRENT_DATE, Date and Time Functions
CURRENT_ROLE(), Information Functions
CURRENT_TIME, Date and Time Functions
CURRENT_TIMESTAMP, Date and Time Functions
CURRENT_USER(), Information Functions
cursor, MySQL 词汇表
Cursors, Cursors
CURTIME(), Date and Time Functions
CXX environment variable, Dealing with Problems Compiling MySQL , MySQL Program Environment Variables
cxxflags option
mysql_config, mysql_config — Display Options for Compiling Clients

D

[ index top ]
Daemon
thread command, Thread Command Values
daemon option (ndb_mgmd), ndb_mgmd — The NDB Cluster Management Server Daemon
daemon plugins, Daemon Plugins
daemonize option
mysqld, Server Command Options
daemon_memcached_enable_binlog system variable, InnoDB Startup Options and System Variables
daemon_memcached_engine_lib_name system variable, InnoDB Startup Options and System Variables
daemon_memcached_engine_lib_path system variable, InnoDB Startup Options and System Variables
daemon_memcached_option system variable, InnoDB Startup Options and System Variables
daemon_memcached_r_batch_size system variable, InnoDB Startup Options and System Variables
daemon_memcached_w_batch_size system variable, InnoDB Startup Options and System Variables
data
importing, Executing SQL Statements from a Text File , mysqlimport — A Data Import Program
loading into tables, Loading Data into a Table
retrieving, Retrieving Information from a Table
size, Optimizing Data Size
data dictionary, MySQL Data Dictionary , File-Per-Table Tablespaces , MySQL 词汇表
benefits, MySQL Data Dictionary
dictionary object cache, Dictionary Object Cache
INFORMATION_SCHEMA integration, INFORMATION_SCHEMA and Data Dictionary Integration
limitations, Data Dictionary Limitations
metadata file removal, Removal of File-based Metadata Storage
operational implications, Data Dictionary Usage Differences
schema, Data Dictionary Schema
transactional storage, Transactional Storage of Dictionary Data
data dictionary tables
catalogs table, Data Dictionary Tables
character_sets table, Data Dictionary Tables
check_constraints table, Data Dictionary Tables
collations table, Data Dictionary Tables
columns table, Data Dictionary Tables
column_type_elements table, Data Dictionary Tables
dd_properties table, Data Dictionary Tables
events table, Data Dictionary Tables
foreign_keys table, Data Dictionary Tables
foreign_key_column_usage table, Data Dictionary Tables
indexes table, Data Dictionary Tables
index_column_usage table, Data Dictionary Tables
index_partitions table, Data Dictionary Tables
index_stats table, Data Dictionary Tables
innodb_ddl_log table, Data Dictionary Tables
parameters table, Data Dictionary Tables
parameter_type_elements table, Data Dictionary Tables
resource_groups table, Data Dictionary Tables
routines table, Data Dictionary Tables
schemata table, Data Dictionary Tables
st_spatial_reference_systems table, Data Dictionary Tables
tables table, Data Dictionary Tables
tablespaces table, Data Dictionary Tables
tablespace_files table, Data Dictionary Tables
table_partitions table, Data Dictionary Tables
table_partition_values table, Data Dictionary Tables
table_stats table, Data Dictionary Tables
triggers table, Data Dictionary Tables
view_routine_usage table, Data Dictionary Tables
view_table_usage table, Data Dictionary Tables
data directory, MySQL 词汇表
mysql_upgrade_info file, mysql_upgrade — Check and Upgrade MySQL Tables
DATA DIRECTORY
and replication, Replication and DIRECTORY Table Options
data encryption, Tablespace Encryption
data files, MySQL 词汇表
Data Masking plugin
installing, Installing or Uninstalling MySQL Enterprise Data Masking and De-Identification
uninstalling, Installing or Uninstalling MySQL Enterprise Data Masking and De-Identification
data node (NDB Cluster)
defined, NDB Cluster Core Concepts
data nodes
memory allocation, Defining NDB Cluster Data Nodes
data nodes (NDB Cluster), ndbd — The NDB Cluster Data Node Daemon , ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)
Data on disk (NDB Cluster)
and INFORMATION_SCHEMA.FILES table, The INFORMATION_SCHEMA FILES Table
data structures
C API, C API Data Structures
C binary log API, C API Binary Log Data Structures
C prepared statement API, C API Prepared Statement Data Structures
Data truncation with CJK characters, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
data type
BIGINT, Numeric Type Overview
BINARY, String Type Overview , The BINARY and VARBINARY Types
BIT, Numeric Type Overview
BLOB, String Type Overview , The BLOB and TEXT Types
BOOL, Numeric Type Overview , Using Data Types from Other Database Engines
BOOLEAN, Numeric Type Overview , Using Data Types from Other Database Engines
CHAR, String Type Overview , String Types
CHAR VARYING, String Type Overview
CHARACTER, String Type Overview
CHARACTER VARYING, String Type Overview
DATE, Date and Time Type Overview , The DATE, DATETIME, and TIMESTAMP Types
DATETIME, Date and Time Type Overview , The DATE, DATETIME, and TIMESTAMP Types
DEC, Numeric Type Overview
DECIMAL, Numeric Type Overview , Precision Math
DOUBLE, Numeric Type Overview
DOUBLE PRECISION, Numeric Type Overview
ENUM, String Type Overview , The ENUM Type
FIXED, Numeric Type Overview
FLOAT, Numeric Type Overview
GEOMETRY, Spatial Data Types
GEOMETRYCOLLECTION, Spatial Data Types
INT, Numeric Type Overview
INTEGER, Numeric Type Overview
LINESTRING, Spatial Data Types
LONG, The BLOB and TEXT Types
LONGBLOB, String Type Overview
LONGTEXT, String Type Overview
MEDIUMBLOB, String Type Overview
MEDIUMINT, Numeric Type Overview
MEDIUMTEXT, String Type Overview
MULTILINESTRING, Spatial Data Types
MULTIPOINT, Spatial Data Types
MULTIPOLYGON, Spatial Data Types
NATIONAL CHAR, String Type Overview
NATIONAL VARCHAR, String Type Overview
NCHAR, String Type Overview
NUMERIC, Numeric Type Overview
NVARCHAR, String Type Overview
POINT, Spatial Data Types
POLYGON, Spatial Data Types
REAL, Numeric Type Overview
SET, String Type Overview , The SET Type
SMALLINT, Numeric Type Overview
TEXT, String Type Overview , The BLOB and TEXT Types
TIME, Date and Time Type Overview , The TIME Type
TIMESTAMP, Date and Time Type Overview , The DATE, DATETIME, and TIMESTAMP Types
TINYBLOB, String Type Overview
TINYINT, Numeric Type Overview
TINYTEXT, String Type Overview
VARBINARY, String Type Overview , The BINARY and VARBINARY Types
VARCHAR, String Type Overview , String Types
VARCHARACTER, String Type Overview
YEAR, Date and Time Type Overview , The YEAR Type
data types, Data Types
C API, MySQL C API
overview, Data Type Overview
data warehouse, MySQL 词汇表
data-file-length option
myisamchk, myisamchk Repair Options
database, MySQL 词汇表
altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax
renaming, RENAME TABLE Syntax
Database information
obtaining, SHOW Syntax
database metadata, INFORMATION_SCHEMA Tables
database names
case sensitivity, MySQL Extensions to Standard SQL , Identifier Case Sensitivity
database objects
metadata, UTF-8 for Metadata
database option
mysql, mysql Client Options
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
ndb_blob_tool, ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
ndb_desc, ndb_desc — Describe NDB Tables
ndb_move_data, ndb_move_data — NDB Data Copy Utility
ndb_show_tables, ndb_show_tables — Display List of NDB Tables
database option (ndb_index_stat), ndb_index_stat — NDB Index Statistics Utility
DATABASE(), Information Functions
databases
backups, Backup and Recovery
copying, Copying MySQL Databases to Another Machine
creating, Creating and Using a Database , CREATE DATABASE Syntax
defined, What is MySQL?
displaying, mysqlshow — Display Database, Table, and Column Information
dumping, mysqldump — A Database Backup Program , mysqlpump — A Database Backup Program
information about, Getting Information About Databases and Tables
names, Schema Object Names
replicating, Replication
selecting, Creating and Selecting a Database , USE Syntax
symbolic links, Using Symbolic Links for Databases on Unix
using, Creating and Using a Database
databases option
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlpump, mysqlpump — A Database Backup Program
DataDir, Defining an NDB Cluster Management Server , Defining NDB Cluster Data Nodes
datadir option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysql_ssl_rsa_setup, mysql_ssl_rsa_setup — Create SSL/RSA Files
datadir system variable, Server System Variables
DataMemory, Defining NDB Cluster Data Nodes
data_locks table
performance_schema, The data_locks Table , Obtaining Parent Event Information
data_lock_waits table
performance_schema, The data_lock_waits Table
DATE, Problems Using DATE Columns
date and time functions, Date and Time Functions
Date and Time types, Date and Time Types
date calculations, Date Calculations
DATE columns
problems, Problems Using DATE Columns
DATE data type, Date and Time Type Overview , The DATE, DATETIME, and TIMESTAMP Types
date data types
storage requirements, Date and Time Type Storage Requirements
date literals, Date and Time Literals
date values
problems, The DATE, DATETIME, and TIMESTAMP Types
DATE(), Date and Time Functions
DATEDIFF(), Date and Time Functions
dates
used with partitioning, Partitioning Types
used with partitioning (examples), RANGE Partitioning , HASH Partitioning , Subpartitioning , Partition Pruning
DATETIME data type, Date and Time Type Overview , The DATE, DATETIME, and TIMESTAMP Types
datetime_format system variable, Server System Variables
DATE_ADD(), Date and Time Functions
date_format system variable, Server System Variables
DATE_FORMAT(), Date and Time Functions
DATE_SUB(), Date and Time Functions
DAY(), Date and Time Functions , Encryption and Compression Functions
DAYNAME(), Date and Time Functions
DAYOFMONTH(), Date and Time Functions
DAYOFWEEK(), Date and Time Functions
DAYOFYEAR(), Date and Time Functions
db table
sorting, Access Control, Stage 2: Request Verification
system table, Securing the Initial MySQL Account , Grant System Tables , Grant Tables
db-workers option
ndb_import, ndb_import — Import CSV Data Into NDB
DBI interface, MySQL Perl API
DBI->quote, String Literals
DBI->trace, Debugging mysqld under gdb
DBI/DBD interface, MySQL Perl API
DBI_TRACE environment variable, MySQL Program Environment Variables , Debugging mysqld under gdb
DBI_USER environment variable, MySQL Program Environment Variables
DBUG package, The DBUG Package
DCL, GRANT Syntax , REVOKE Syntax , MySQL 词汇表
DDL, Data Definition Statements , Atomic Data Definition Statement Support , MySQL 词汇表
DDL log, The DDL Log
dd_properties table
data dictionary table, Data Dictionary Tables
deadlock, Internal Locking Methods , Interaction of Table Locking and Transactions , Locks Set by Different SQL Statements in InnoDB , Deadlocks in InnoDB , An InnoDB Deadlock Example , Deadlock Detection and Rollback , InnoDB Startup Options and System Variables , Using the Performance Schema to Diagnose Problems , MySQL 词汇表
deadlock detection, MySQL 词汇表
DEALLOCATE PREPARE, Prepared SQL Statement Syntax , DEALLOCATE PREPARE Syntax
deb file
MySQL APT Repository, Installing MySQL on Linux Using the MySQL APT Repository
MySQL SLES Repository, Installing MySQL on Linux Using the MySQL SLES Repository
Debug
thread command, Thread Command Values
debug option
comp_err, comp_err — Compile MySQL Error Message File
ibd2sdi, ibd2sdi — InnoDB Tablespace SDI Extraction Utility
myisamchk, myisamchk General Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_config_editor, mysql_config_editor — MySQL Configuration Utility
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
my_print_defaults, my_print_defaults — Display Options from Option Files
debug option (NDB Cluster programs), Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
debug system variable, Server System Variables
debug-check option
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
debug-info option
comp_err, comp_err — Compile MySQL Error Message File
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
debug-level option
ndb_setup.py, ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster
debug-sync-timeout option
mysqld, Server Command Options
调试
client, Debugging a MySQL Client
server, Debugging a MySQL Server
debugging support, MySQL Source-Configuration Options
debug_sync system variable, Server System Variables
DEC data type, Numeric Type Overview
decimal arithmetic, Precision Math
DECIMAL data type, Numeric Type Overview , Precision Math
decimal point, Data Types
DECLARE, DECLARE Syntax
DECODE(), Encryption and Compression Functions
decode_bits myisamchk variable, myisamchk General Options
DEFAULT
constraint, Constraints on Invalid Data
default
privileges, Securing the Initial MySQL Account
default account, Securing the Initial MySQL Account
default host name, Connecting to the MySQL Server
default installation location, Installation Layouts
default options, Using Option Files
default proxy user, Default Proxy Users
default role
ALTER USER, ALTER USER Role Options
CREATE USER statement, CREATE USER Role Options
default roles, SET DEFAULT ROLE Syntax
DEFAULT value clause, Data Type Default Values , CREATE TABLE Syntax
default values, Data Type Default Values , CREATE TABLE Syntax , INSERT Syntax
BLOB and TEXT columns, The BLOB and TEXT Types
explicit, Data Type Default Values
implicit, Data Type Default Values
suppression, Constraints on Invalid Data
DEFAULT(), Miscellaneous Functions
default-auth option, Connecting to the MySQL Server
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
default-character-set option
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
default-parallelism option
mysqlpump, mysqlpump — A Database Backup Program
default-storage-engine option
mysqld, Server Command Options
default-time-zone option
mysqld, Server Command Options
DefaultHashMapSize, Defining NDB Cluster Data Nodes , Defining SQL and Other API Nodes in an NDB Cluster
DefaultOperationRedoProblemAction
API and SQL nodes, Defining SQL and Other API Nodes in an NDB Cluster
defaults-extra-file option, Command-Line Options that Affect Option-File Handling
myisamchk, myisamchk General Options
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_secure_installation, mysql_secure_installation — Improve MySQL Installation Security
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
my_print_defaults, my_print_defaults — Display Options from Option Files
NDB client programs, Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
defaults-file option, Command-Line Options that Affect Option-File Handling
myisamchk, myisamchk General Options
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_secure_installation, mysql_secure_installation — Improve MySQL Installation Security
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
my_print_defaults, my_print_defaults — Display Options from Option Files
NDB client programs, Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
defaults-group-suffix option, Command-Line Options that Affect Option-File Handling
myisamchk, myisamchk General Options
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlpump, mysqlpump — A Database Backup Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_secure_installation, mysql_secure_installation — Improve MySQL Installation Security
mysql_upgrade, mysql_upgrade — Check and Upgrade MySQL Tables
my_print_defaults, my_print_defaults — Display Options from Option Files
NDB client programs, Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs
default_authentication_plugin system variable, Server System Variables
DEFAULT_CHARSET option
CMake, Feature Options
DEFAULT_COLLATION option
CMake, Feature Options
default_collation_for_utf8mb4 system variable, Server System Variables
default_password_lifetime system variable, Server System Variables
default_roles table
system table, Grant System Tables , Grant Tables
default_storage_engine system variable, Server System Variables
default_tmp_storage_engine system variable, Server System Variables
default_week_format system variable, Server System Variables
defer-table-indexes option
mysqlpump, mysqlpump — A Database Backup Program
DEFINER privileges, SHOW GRANTS Syntax , Access Control for Stored Programs and Views
DEGREES(), Mathematical Functions
delay option (ndbinfo_select_all), ndbinfo_select_all — Select From ndbinfo Tables
delay-key-write option
mysqld, Server Command Options , MyISAM Startup Options
DELAYED, INSERT DELAYED Syntax
INSERT modifier, INSERT Syntax
Delayed insert
thread command, Thread Command Values
delayed replication, Delayed Replication
delayed_insert_limit system variable, Server System Variables
delayed_insert_timeout system variable, Server System Variables
delayed_queue_size system variable, Server System Variables
delay_key_write system variable, Server System Variables
DELETE, DELETE Syntax
and NDB Cluster, Limits and Differences of NDB Cluster from Standard MySQL Limits
delete, MySQL 词汇表
delete buffering, MySQL 词汇表
delete option
mysqlimport, mysqlimport — A Data Import Program
delete option (ndb_index_stat), ndb_index_stat — NDB Index Statistics Utility
delete-master-logs option
mysqldump, mysqldump — A Database Backup Program
delete-orphans option
ndb_blob_tool, ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
deleting
database, DROP DATABASE Syntax
foreign key, ALTER TABLE Syntax , Dropping Foreign Keys
function, DROP FUNCTION Syntax
index, ALTER TABLE Syntax , DROP INDEX Syntax
primary key, ALTER TABLE Syntax
rows, Deleting Rows from Related Tables
schema, DROP DATABASE Syntax
table, DROP TABLE Syntax
user, Removing User Accounts , DROP USER Syntax
users, Removing User Accounts , DROP USER Syntax
deleting from main table
thread state, General Thread States
deleting from reference tables
thread state, General Thread States
deletion
mysql.sock, How to Protect or Change the MySQL Unix Socket File
delimiter command
mysql, mysql Client Commands
delimiter option
mysql, mysql Client Options
mysqlslap, mysqlslap — Load Emulation Client
ndb_select_all, ndb_select_all — Print Rows from an NDB Table
demo_test table, Installing and Configuring the InnoDB memcached Plugin
denormalized, MySQL 词汇表
DENSE_RANK(), Window Function Descriptions
deprecated features in MySQL 8.0, What Is New in MySQL 8.0
derived tables, Derived Tables
lateral, EXPLAIN Extra Information , Lateral Derived Tables
materialization prevention, Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization
optimization, Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions , Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization
updatable views, Updatable and Insertable Views
des-key-file option
mysqld, Server Command Options
DESC, DESCRIBE Syntax
descending index, MySQL 词汇表
descending indexes, Descending Indexes
descending option
ndb_select_all, ndb_select_all — Print Rows from an NDB Table
DESCRIBE, Getting Information About Databases and Tables , DESCRIBE Syntax
description option
myisamchk, Other myisamchk Options
design
issues, Known Issues in MySQL
DES_DECRYPT(), Encryption and Compression Functions
DES_ENCRYPT(), Encryption and Compression Functions
detach option
mysqlslap, mysqlslap — Load Emulation Client
development of NDB Cluster, What is New in NDB Cluster
development source tree, Installing MySQL Using a Development Source Tree
diagnostics() procedure
sys schema, The diagnostics() Procedure
dictionary collation, German, West European Character Sets
dictionary object cache, Dictionary Object Cache , MySQL 词汇表
DictTrace, Defining NDB Cluster Data Nodes
dict_obj_info
ndbinfo table, The ndbinfo dict_obj_info Table
dict_obj_types
ndbinfo table, The ndbinfo dict_obj_types Table
diff-default option
ndb_config, ndb_config — Extract NDB Cluster Configuration Information
digits, Data Types
directory structure
default, Installation Layouts
dirty page, Configuring InnoDB Buffer Pool Flushing , InnoDB Startup Options and System Variables , MySQL 词汇表
dirty read, MySQL 词汇表
disable named command
mysql, mysql Client Options
--disable option prefix, Program Option Modifiers
disable-indexes option
ndb_restore, ndb_restore — Restore an NDB Cluster Backup
disable-keys option
mysqldump, mysqldump — A Database Backup Program
disable-log-bin option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
disabled_storage_engines system variable, Server System Variables
DISABLE_PSI_COND option
CMake, Feature Options
DISABLE_PSI_DATA_LOCK option
CMake, Feature Options
DISABLE_PSI_ERROR option
CMake, Feature Options
DISABLE_PSI_FILE option
CMake, Feature Options
DISABLE_PSI_IDLE option
CMake, Feature Options
DISABLE_PSI_MEMORY option
CMake, Feature Options
DISABLE_PSI_METADATA option
CMake, Feature Options
DISABLE_PSI_MUTEX option
CMake, Feature Options
DISABLE_PSI_PS option
CMake, Feature Options
DISABLE_PSI_RWLOCK option
CMake, Feature Options
DISABLE_PSI_SOCKET option
CMake, Feature Options
DISABLE_PSI_SP option
CMake, Feature Options
DISABLE_PSI_STAGE option
CMake, Feature Options
DISABLE_PSI_STATEMENT option
CMake, Feature Options
DISABLE_PSI_STATEMENT_DIGEST option
CMake, Feature Options
DISABLE_PSI_TABLE option
CMake, Feature Options
DISABLE_PSI_THREAD option
CMake, Feature Options
DISABLE_PSI_TRANSACTION option
CMake, Feature Options
DISABLE_SHARED option
CMake, Feature Options
DISCARD TABLESPACE, ALTER TABLE Syntax , Moving or Copying InnoDB Tables
discard_or_import_tablespace
thread state, General Thread States
disconnect-slave-event-count option
mysqld, Startup Options for Replication Slaves
disconnecting
from the server, Connecting to and Disconnecting from the Server
disconnect_on_expired_password system variable, Server System Variables
Disk Data tables (NDB Cluster) (see NDB Cluster Disk Data )
disk failure
InnoDB, Recovery from Data Corruption or Disk Failure
disk full, How MySQL Handles a Full Disk
disk I/O, Optimizing InnoDB Disk I/O
disk option
ndb_select_all, ndb_select_all — Print Rows from an NDB Table
disk performance, Optimizing Disk I/O
disk-based, MySQL 词汇表
disk-bound, MySQL 词汇表
DiskIOThreadPool, Defining NDB Cluster Data Nodes
Diskless, Defining NDB Cluster Data Nodes
diskpagebuffer
ndbinfo table, The ndbinfo diskpagebuffer Table
DiskPageBufferEntries, Defining NDB Cluster Data Nodes
DiskPageBufferMemory, Defining NDB Cluster Data Nodes
disks
splitting data across, Using Symbolic Links for Databases on Windows
DiskSyncSize, Defining NDB Cluster Data Nodes
disk_write_speed_aggregate
ndbinfo table, The ndbinfo disk_write_speed_aggregate Table
disk_write_speed_aggregate_node
ndbinfo table, The ndbinfo disk_write_speed_aggregate_node Table
disk_write_speed_base
ndbinfo table, The ndbinfo disk_write_speed_base Table
display size, Data Types
display triggers, SHOW TRIGGERS Syntax
display width, Data Types
displaying
database information, mysqlshow — Display Database, Table, and Column Information
information
Cardinality, SHOW INDEX Syntax
Collation, SHOW INDEX Syntax
SHOW, SHOW Syntax , SHOW COLUMNS Syntax , SHOW TABLES Syntax
SHOW statement, SHOW INDEX Syntax , SHOW OPEN TABLES Syntax
table status, SHOW TABLE STATUS Syntax
DISTINCT, Selecting Particular Columns , DISTINCT Optimization
AVG(), Aggregate (GROUP BY) Function Descriptions
COUNT(), Aggregate (GROUP BY) Function Descriptions
MAX(), Aggregate (GROUP BY) Function Descriptions
MIN(), Aggregate (GROUP BY) Function Descriptions
SELECT modifier, SELECT Syntax
SUM(), Aggregate (GROUP BY) Function Descriptions
DISTINCTROW
SELECT modifier, SELECT Syntax
distinguished name
LDAP authentication, How LDAP Authentication of MySQL Users Works
distributed privileges (NDB Cluster), Distributed MySQL Privileges for NDB Cluster
and NDB API applications, Distributed MySQL Privileges for NDB Cluster
DIV, Arithmetic Operators
division (/), Arithmetic Operators
div_precision_increment system variable, Server System Variables
DML, Data Manipulation Statements , MySQL 词汇表
DELETE statement, DELETE Syntax
INSERT statement, INSERT Syntax
UPDATE statement, UPDATE Syntax
DMR
MySQL releases, Which MySQL Version and Distribution to Install
DN (see distinguished name )
DNS, DNS Lookup Optimization and the Host Cache
DO, DO Syntax
DocBook XML
documentation source format, About This Manual
Docker, Upgrading a Docker Installation of MySQL
Docker images
on Windows, Deploying MySQL on Windows and Other Non-Linux Platforms with Docker
document id, MySQL 词汇表
document store, Using MySQL as a Document Store
MySQL as a, Using MySQL as a Document Store
文档编制
in Chinese, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
in Japanese, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
in Korean, MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
Documenters
list of, Documenters and translators
dont_ignore_systab_0 option
ndb_restore, ndb_restore — Restore an NDB Cluster Backup
DOUBLE data type, Numeric Type Overview
DOUBLE PRECISION data type, Numeric Type Overview
double quote (\"), String Literals , Functions That Modify JSON Values
doublewrite buffer, Server Status Variables , Doublewrite Buffer , InnoDB Startup Options and System Variables , MySQL 词汇表
downgrades
NDB Cluster, Upgrading and Downgrading NDB Cluster , Performing a Rolling Restart of an NDB Cluster
downgrading, Upgrading or Downgrading MySQL , Downgrading MySQL
downloading, How to Get MySQL
DOWNLOAD_BOOST option
CMake, Feature Options
DOWNLOAD_BOOST_TIMEOUT option
CMake, Feature Options
dragnet.log_error_filter_rules system variable, Server System Variables
dragnet.Status status variable, Server Status Variables
drop, MySQL 词汇表
DROP ... IF EXISTS
and replication, Replication of DROP ... IF EXISTS Statements
DROP DATABASE, DROP DATABASE Syntax
Drop DB
thread command, Thread Command Values
DROP EVENT, DROP EVENT Syntax
DROP FOREIGN KEY, ALTER TABLE Syntax , Dropping Foreign Keys
DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION Syntax
DROP FUNCTION statement, DROP FUNCTION Syntax
DROP INDEX, ALTER TABLE Syntax , DROP INDEX Syntax
DROP LOGFILE GROUP, DROP LOGFILE GROUP Syntax
(see also NDB Cluster Disk Data )
DROP NODEGROUP command (NDB Cluster), Commands in the NDB Cluster Management Client
DROP PREPARE, DEALLOCATE PREPARE Syntax
DROP PRIMARY KEY, ALTER TABLE Syntax
DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax
DROP RESOURCE GROUP statement, DROP RESOURCE GROUP Syntax
DROP ROLE statement, DROP ROLE Syntax
DROP SCHEMA, DROP DATABASE Syntax
DROP SERVER, DROP SERVER Syntax
DROP SPATIAL REFERENCE SYSTEM, DROP SPATIAL REFERENCE SYSTEM Syntax
DROP TABLE, DROP TABLE Syntax
and NDB Cluster, Limits and Differences of NDB Cluster from Standard MySQL Limits
DROP TABLESPACE
general tablespace, DROP TABLESPACE Syntax
NDB Cluster Disk Data, DROP TABLESPACE Syntax
undo tablespace, DROP TABLESPACE Syntax
DROP TRIGGER, DROP TRIGGER Syntax
DROP USER statement, DROP USER Syntax
DROP VIEW, DROP VIEW Syntax
drop-source option
ndb_move_data, ndb_move_data — NDB Data Copy Utility
dropping
user, Removing User Accounts , DROP USER Syntax
dropping roles, DROP ROLE Syntax
dry-scp option (ndb_error_reporter), ndb_error_reporter — NDB Error-Reporting Utility
DUAL, SELECT Syntax
dual passwords, Dual Password Support
dump option
myisam_ftdump, myisam_ftdump — Display Full-Text Index information
ndb_redo_log_reader, ndb_redo_log_reader — Check and Print Content of Cluster Redo Log
dump option (ndb_index_stat), ndb_index_stat — NDB Index Statistics Utility
dump-date option
mysqldump, mysqldump — A Database Backup Program
dump-file option
ibd2sdi, ibd2sdi — InnoDB Tablespace SDI Extraction Utility
ndb_blob_tool, ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables
dump-slave option
mysqldump, mysqldump — A Database Backup Program
DUMPFILE, SELECT ... INTO Syntax
dumping
databases and tables, mysqldump — A Database Backup Program , mysqlpump — A Database Backup Program
Duplicate Weedout
semi-join strategy, Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions with Semi-Join Transformations
DYLD_LIBRARY_PATH environment variable, Running C API Client Programs
dynamic privileges, Static Versus Dynamic Privileges
dynamic row format, DYNAMIC Row Format , MySQL 词汇表
dynamic table characteristics, Dynamic Table Characteristics

E

[ index top ]
early adopter, MySQL 词汇表
early-plugin-load option
mysqld, Server Command Options
edit command
mysql, mysql Client Commands
EE_ADJUSTED_DOUBLE_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_ADJUSTED_SIGNED_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_ADJUSTED_ULONGLONG_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_ADJUSTED_UNSIGNED_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_BADCLOSE error code, Global Error Message Reference
EE_CANTCREATEFILE error code, Global Error Message Reference
EE_CANTLOCK error code, Global Error Message Reference
EE_CANTUNLOCK error code, Global Error Message Reference
EE_CANT_CHSIZE error code, Global Error Message Reference
EE_CANT_MKDIR error code, Global Error Message Reference
EE_CANT_OPEN_STREAM error code, Global Error Message Reference
EE_CANT_READLINK error code, Global Error Message Reference
EE_CANT_SEEK error code, Global Error Message Reference
EE_CANT_SYMLINK error code, Global Error Message Reference
EE_CAPACITY_EXCEEDED error code, Global Error Message Reference
EE_CHANGE_OWNERSHIP error code, Global Error Message Reference
EE_CHANGE_PERMISSIONS error code, Global Error Message Reference
EE_COLLATION_PARSER_ERROR error code, Global Error Message Reference
EE_CONFIG_FILE_PERMISSION_ERROR error code, Global Error Message Reference
EE_DEBUG_INFO error code, Global Error Message Reference
EE_DELETE error code, Global Error Message Reference
EE_DIR error code, Global Error Message Reference
EE_DISK_FULL error code, Global Error Message Reference
EE_DISK_FULL_WITH_RETRY_MSG error code, Global Error Message Reference
EE_EOFERR error code, Global Error Message Reference
EE_EXITING_TIMER_NOTIFY_THREAD error code, Global Error Message Reference
EE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION error code, Global Error Message Reference
EE_FAILED_TO_CREATE_IO_COMPLETION_PORT error code, Global Error Message Reference
EE_FAILED_TO_CREATE_TIMER error code, Global Error Message Reference
EE_FAILED_TO_CREATE_TIMER_NOTIFY_THREAD_INTERRUPT_EVENT error code, Global Error Message Reference
EE_FAILED_TO_CREATE_TIMER_QUEUE error code, Global Error Message Reference
EE_FAILED_TO_DELETE_TIMER error code, Global Error Message Reference
EE_FAILED_TO_DETERMINE_LARGE_PAGE_SIZE error code, Global Error Message Reference
EE_FAILED_TO_HANDLE_DEFAULTS_FILE error code, Global Error Message Reference
EE_FAILED_TO_KILL_ALL_THREADS error code, Global Error Message Reference
EE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY error code, Global Error Message Reference
EE_FAILED_TO_OPEN_DEFAULTS_FILE error code, Global Error Message Reference
EE_FAILED_TO_RESET_BEFORE_PRIMARY_IGNORABLE_CHAR error code, Global Error Message Reference
EE_FAILED_TO_RESET_BEFORE_SECONDARY_IGNORABLE_CHAR error code, Global Error Message Reference
EE_FAILED_TO_RESET_BEFORE_TERTIARY_IGNORABLE_CHAR error code, Global Error Message Reference
EE_FAILED_TO_SET_OPTION_VALUE error code, Global Error Message Reference
EE_FAILED_TO_START_TIMER_NOTIFY_THREAD error code, Global Error Message Reference
EE_FILENOTFOUND error code, Global Error Message Reference
EE_FILE_NOT_CLOSED error code, Global Error Message Reference
EE_GETWD error code, Global Error Message Reference
EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE error code, Global Error Message Reference
EE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE error code, Global Error Message Reference
EE_INCORRECT_INT_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_INCORRECT_UINT_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_INVALID_DECIMAL_VALUE_FOR_OPTION error code, Global Error Message Reference
EE_LINK error code, Global Error Message Reference
EE_LINK_WARNING error code, Global Error Message Reference
EE_NET_SEND_ERROR_IN_BOOTSTRAP error code, Global Error Message Reference
EE_OPEN_WARNING error code, Global Error Message Reference
EE_OPTION_IGNORED_DUE_TO_INVALID_VALUE error code, Global Error Message Reference
EE_OPTION_REQUIRES_ARGUMENT error code, Global Error Message Reference
EE_OPTION_WITHOUT_ARGUMENT error code, Global Error Message Reference
EE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE error code, Global Error Message Reference
EE_OPTION_WITH_EMPTY_VALUE error code, Global Error Message Reference
EE_OUTOFMEMORY error code, Global Error Message Reference
EE_OUT_OF_FILERESOURCES error code, Global Error Message Reference
EE_PACKETS_OUT_OF_ORDER error code, Global Error Message Reference
EE_PUBLIC_KEY_NOT_IN_PEM_FORMAT error code, Global Error Message Reference
EE_READ error code, Global Error Message Reference
EE_REALPATH error code, Global Error Message Reference
EE_RESET_CHAR_OUT_OF_RANGE error code, Global Error Message Reference
EE_SETWD error code, Global Error Message Reference
EE_SHIFT_CHAR_OUT_OF_RANGE error code, Global Error Message Reference
EE_SHORT_OPTION_REQUIRES_ARGUMENT error code, Global Error Message Reference
EE_SKIPPING_DIRECTIVE_DUE_TO_MAX_INCLUDE_RECURSION error code, Global Error Message Reference
EE_SSL_ERROR error code, Global Error Message Reference
EE_SSL_ERROR_FROM_FILE error code, Global Error Message Reference
EE_STAT error code, Global Error Message Reference
EE_SYNC error code, Global Error Message Reference
EE_UNKNOWN_CHARSET error code, Global Error Message Reference
EE_UNKNOWN_COLLATION error code, Global Error Message Reference
EE_UNKNOWN_LDML_TAG error code, Global Error Message Reference
EE_UNKNOWN_OPTION error code, Global Error Message Reference
EE_UNKNOWN_PROTOCOL_OPTION error code, Global Error Message Reference
EE_UNKNOWN_SHORT_OPTION error code, Global Error Message Reference
EE_UNKNOWN_SUFFIX_FOR_VARIABLE error code, Global Error Message Reference
EE_UNKNOWN_VARIABLE error code, Global Error Message Reference
EE_USING_DISABLED_OPTION error code, Global Error Message Reference
EE_USING_DISABLED_SHORT_OPTION error code, Global Error Message Reference
EE_USING_PASSWORD_ON_CLI_IS_INSECURE error code, Global Error Message Reference
EE_WIN_LIBRARY_LOAD_FAILED error code, Global Error Message Reference
EE_WIN_RUN_TIME_ERROR_CHECK error code, Global Error Message Reference
EE_WRITE error code, Global Error Message Reference
EE_WRONG_DIRECTIVE_IN_CONFIG_FILE error code, Global Error Message Reference
ego command
mysql, mysql Client Commands
Eiffel Wrapper, MySQL Eiffel Wrapper
ELT(), String Functions
email lists, MySQL 邮件列表
--enable option prefix, Program Option Modifiers
enable-cleartext-plugin option
mysql, mysql Client Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
enable-named-pipe option
mysqld, Server Command Options
ENABLED_LOCAL_INFILE option
CMake, Feature Options
ENABLED_PROFILING option
CMake, Feature Options
EnablePartialLcp, Defining NDB Cluster Data Nodes
EnableRedoControl, Defining NDB Cluster Data Nodes
ENABLE_DEBUG_SYNC option
CMake, Feature Options
ENABLE_DOWNLOADS option
CMake, Feature Options
ENABLE_DTRACE option
CMake, Feature Options
ENABLE_EXPERIMENTAL_SYSVARS option
CMake, Feature Options
ENABLE_GCOV option
CMake, Feature Options
ENABLE_GPROF option
CMake, Feature Options
ENCODE(), Encryption and Compression Functions
ENCRYPT(), Encryption and Compression Functions
encrypted connections, Using Encrypted Connections
command options, Command Options for Encrypted Connections
configuring, Building MySQL with Support for Encrypted Connections
encryption, Making MySQL Secure Against Attackers , Using Encrypted Connections , Tablespace Encryption
binary log files, Encrypting Binary Log Files and Relay Log Files
encryption functions, Encryption and Compression Functions
end
thread state, General Thread States
END, BEGIN ... END Compound-Statement Syntax
end-page option
innochecksum, innochecksum — Offline InnoDB File Checksum Utility
end_markers_in_json system variable, Server System Variables
enforce-gtid-consistency option, Startup Options Used with GTID Replication
enforce_gtid_consistency system variable, System Variables Used with GTID Replication
engine option
mysqlslap, mysqlslap — Load Emulation Client
ENGINES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ENGINES Table
engine_cost
system table, The Cost Model Database
engine_cost table
system table, Optimizer System Tables
ENTER SINGLE USER MODE command (NDB Cluster), Commands in the NDB Cluster Management Client
entering
queries, Entering Queries
enterprise components
MySQL Enterprise Audit, MySQL Enterprise Audit , MySQL Enterprise Audit Overview
MySQL Enterprise Backup, MySQL Enterprise Backup Overview
MySQL Enterprise Data Masking and De-Identification, MySQL Enterprise Data Masking and De-Identification Overview
MySQL Enterprise Encryption, MySQL Enterprise Encryption Overview
MySQL Enterprise Firewall, MySQL Enterprise Firewall , MySQL Enterprise Firewall Overview
MySQL Enterprise Monitor, MySQL Enterprise Monitor Overview
MySQL Enterprise Security, PAM Pluggable Authentication , Windows Pluggable Authentication , LDAP Pluggable Authentication , MySQL Enterprise Security Overview
MySQL Enterprise Thread Pool, MySQL Enterprise Thread Pool , MySQL Enterprise Thread Pool Overview
ENUM
size, String Type Storage Requirements
ENUM data type, String Type Overview , The ENUM Type
environment variable
AUTHENTICATION_LDAP_CLIENT_LOG, Pluggable Authentication System Variables
AUTHENTICATION_PAM_LOG, MySQL Program Environment Variables , PAM Pluggable Authentication Debugging
CC, Dealing with Problems Compiling MySQL , MySQL Program Environment Variables
CXX, Dealing with Problems Compiling MySQL , MySQL Program Environment Variables
DBI_TRACE, MySQL Program Environment Variables , Debugging mysqld under gdb
DBI_USER, MySQL Program Environment Variables
DYLD_LIBRARY_PATH, Running C API Client Programs
HOME, mysql Client Logging , MySQL Program Environment Variables
LD)_PRELOAD, Configuring systemd for MySQL
LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface , Running C API Client Programs
LD_RUN_PATH, Problems Using the Perl DBI/DBD Interface , MySQL Program Environment Variables
LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN, MySQL Program Environment Variables
LIBMYSQL_PLUGINS, MySQL Program Environment Variables , 描述
LIBMYSQL_PLUGIN_DIR, MySQL Program Environment Variables , 描述
MYSQLD_OPTS, Configuring systemd for MySQL
MYSQLX_TCP_PORT, MySQL Program Environment Variables
MYSQLX_UNIX_PORT, MySQL Program Environment Variables
MYSQL_DEBUG, Overview of MySQL Programs , MySQL Program Environment Variables , Debugging a MySQL Client
MYSQL_GROUP_SUFFIX, MySQL Program Environment Variables
MYSQL_HISTFILE, mysql Client Logging , MySQL Program Environment Variables
MYSQL_HISTIGNORE, mysql Client Logging , MySQL Program Environment Variables
MYSQL_HOME, MySQL Program Environment Variables
MYSQL_HOST, Connecting to the MySQL Server , MySQL Program Environment Variables
MYSQL_OPENSSL_UDF_DH_BITS_THRESHOLD, MySQL Program Environment Variables , Limit CPU usage by key-generation operations
MYSQL_OPENSSL_UDF_DSA_BITS_THRESHOLD, MySQL Program Environment Variables , Limit CPU usage by key-generation operations
MYSQL_OPENSSL_UDF_RSA_BITS_THRESHOLD, MySQL Program Environment Variables , Limit CPU usage by key-generation operations
MYSQL_PS1, MySQL Program Environment Variables
MYSQL_PWD, Overview of MySQL Programs , Connecting to the MySQL Server , MySQL Program Environment Variables
MYSQL_TCP_PORT, Overview of MySQL Programs , MySQL Program Environment Variables , Running Multiple MySQL Instances on Unix , Using Client Programs in a Multiple-Server Environment
MYSQL_TEST_LOGIN_FILE, Command-Line Options that Affect Option-File Handling , mysql_config_editor — MySQL Configuration Utility , MySQL Program Environment Variables
MYSQL_TEST_TRACE_CRASH, MySQL Program Environment Variables , Using the Test Protocol Trace Plugin
MYSQL_TEST_TRACE_DEBUG, MySQL Program Environment Variables , Using the Test Protocol Trace Plugin
MYSQL_UNIX_PORT, Overview of MySQL Programs , MySQL Program Environment Variables , Running Multiple MySQL Instances on Unix , Using Client Programs in a Multiple-Server Environment
NOTIFY_SOCKET, Configuring systemd for MySQL , MySQL Program Environment Variables
PATH, Customizing the PATH for MySQL Tools , Windows Postinstallation Procedures , Testing the Server , Invoking MySQL Programs , MySQL Program Environment Variables
PKG_CONFIG_PATH, MySQL Program Environment Variables , Building C API Client Programs Using pkg-config