Appendix C Indexes

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

Appendix C Indexes

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 Functions and Operators

&& (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

--password option, End-User Guidelines for Password Security

->, Functions That Search JSON Values

->>, Functions That Search JSON Values

-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

ndb\_mgmd, [ndb\_mgmd — The NDB Cluster Management Server Daemon](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/mysql-cluster-programs-ndb-mgmd.html)

-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

ndbmtd, [ndbd — The NDB Cluster Data Node Daemon](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/mysql-cluster-programs-ndbd.html)

-p option, End-User Guidelines for Password Security

-P option : ndb_mgmd, ndb_mgmd — The NDB Cluster Management Server Daemon

-v option : ndb_mgmd, ndb_mgmd — The NDB Cluster Management Server Daemon

.ibd file, Files Created by CREATE TABLE

.my.cnf option file, Using Option Files, Option File Processing Order, Connecting to the MySQL Server Using Command Options, Using Client Programs in a Multiple-Server Environment, End-User Guidelines for Password Security, Troubleshooting Problems Connecting to MySQL

.MYD file, Files Created by CREATE TABLE

.MYI file, Files Created by CREATE TABLE

.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 Statement

/ (division), Arithmetic Operators

/etc/passwd, Making MySQL Secure Against Attackers, SELECT ... INTO Statement

1FA (see multifactor authentication)

2FA (see multifactor authentication)

3306 port, Feature Options, Server Command Options

33060 port, Feature Options

3FA (see multifactor authentication)

:= (assignment operator), Assignment Operators

:= (assignment), User-Defined Variables

< (less than), Comparison Functions and Operators

<< (left shift), Calculating Visits Per Day, Bit Functions and Operators

<= (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 Functions and Operators

[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

[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 Functions and Operators

_ (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 Statement

`, Schema Object Names

| (bitwise OR), Bit Functions and Operators

|| (logical OR), Logical Operators

~ (invert bits), Bit Functions and Operators

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](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/mysql-cluster-programs-ndb-move-data.html)

aborted clients, Communication Errors and Aborted Connections

aborted connection, Communication Errors and Aborted Connections

Aborted_clients status variable, Server Status Variables

Aborted_connects status variable, Server Status Variables

ABS(), Mathematical Functions

abstract-numbers option : mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files

access control, Access Control and Account Management, Access Control, Stage 1: Connection Verification

access denied errors, Access denied

access privileges, Access Control and Account Management

account : default, Securing the Initial MySQL Account

root, [Securing the Initial MySQL Account](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/default-privileges.html)

account attributes : ALTER USER, ALTER USER Comment and Attribute Options

CREATE USER statement, [CREATE USER Comment and Attribute Options](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/create-user.html#create-user-comments-attributes)

account categories, Account Categories

account comments : ALTER USER, ALTER USER Comment and Attribute Options

CREATE USER statement, [CREATE USER Comment and Attribute Options](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/create-user.html#create-user-comments-attributes)

account locking, The user and db Grant Tables, Account Locking : ALTER USER, ALTER USER Account-Locking Options

CREATE USER statement, [CREATE USER Account-Locking Options](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/create-user.html#create-user-account-locking)

Locked\_connects status variable, [Server Status Variables](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/server-status-variables.html)

account management, Access Control and Account Management

account names, Specifying Account Names

accounts : adding privileges, Adding Accounts, Assigning Privileges, and Dropping Accounts

creating, [Adding Accounts, Assigning Privileges, and Dropping Accounts](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/creating-accounts.html)

deleting, [Dropping Accounts](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/creating-accounts.html#dropping-accounts)

reserved, [Reserved Accounts](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/reserved-accounts.html)

accounts table : performance_schema, The accounts Table

account_locked column : user table, The user and db Grant Tables

ACID, Introduction to InnoDB, InnoDB and the ACID Model, MySQL Glossary

ACLs, Access Control and Account Management

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 Glossary

adaptive hash index, Adaptive Hash Index, MySQL Glossary

add-drop-database option : mysqldump, mysqldump — A Database Backup Program

add-drop-table option : mysqldump, mysqldump — A Database Backup Program

add-drop-trigger option : mysqldump, mysqldump — A Database Backup Program

add-locks option : mysqldump, mysqldump — A Database Backup Program

add-missing option : ndb_blob_tool, ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables

ADDDATE(), Date and Time Functions

adding : character sets, Adding a Character Set

new account privileges, [Adding Accounts, Assigning Privileges, and Dropping Accounts](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/creating-accounts.html)

new user privileges, [Adding Accounts, Assigning Privileges, and Dropping Accounts](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/creating-accounts.html)

addition (+), Arithmetic Operators

ADDTIME(), Date and Time Functions

ADD_GDB_INDEX option : CMake, Feature Options

ADMINISTRABLE_ROLE_AUTHORIZATIONS : INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS Table

administration : server, mysqladmin — A MySQL Server Administration Program

administration of NDB Cluster, ndb_mgm — The NDB Cluster Management Client

administrative connection interface, Connection Interfaces, Administrative Connection Management

administrative programs, Overview of MySQL Programs

admin_address system variable, Server System Variables

admin_port system variable, Server System Variables

admin_ssl_ca system variable, Server System Variables

admin_ssl_capath system variable, Server System Variables

admin_ssl_cert system variable, Server System Variables

admin_ssl_cipher system variable, Server System Variables

admin_ssl_crl system variable, Server System Variables

admin_ssl_crlpath system variable, Server System Variables

admin_ssl_key system variable, Server System Variables

admin_tls_ciphersuites system variable, Server System Variables

admin_tls_version system variable, Server System Variables

ADO.NET, MySQL Glossary

AES_DECRYPT(), Encryption and Compression Functions

AES_ENCRYPT(), Encryption and Compression Functions

After create : thread state, General Thread States

age : calculating, Date Calculations

aggregate functions, Aggregate Function Descriptions

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 Glossary

alias names : case sensitivity, Identifier Case Sensitivity

aliases : for expressions, MySQL Handling of GROUP BY

for tables, [SELECT Statement](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/select.html)

in GROUP BY clauses, [MySQL Handling of GROUP BY](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/group-by-handling.html)

names, [Schema Object Names](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/identifiers.html)

on expressions, [SELECT Statement](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/select.html)

ALL, Subqueries with ALL : SELECT modifier, SELECT Statement

ALL join type : optimizer, EXPLAIN Join Types

ALL privilege, Static Privilege Descriptions

ALL PRIVILEGES privilege, Static Privilege Descriptions

all-databases option : mysqlcheck, mysqlcheck — A Table Maintenance Program

mysqldump, [mysqldump — A Database Backup Program](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/mysqldump.html)

all-in-1 option : mysqlcheck, mysqlcheck — A Table Maintenance Program

all-tablespaces option : mysqldump, mysqldump — A Database Backup Program

Alliance Key Manager : keyring_okv keyring plugin, Configuring keyring_okv for Townsend Alliance Key Manager

allow-keywords option : mysqldump, mysqldump — A Database Backup Program

allow-mismatches option : innochecksum, innochecksum — Offline InnoDB File Checksum Utility

allow-pk-changes option : ndb_restore, ndb_restore — Restore an NDB Cluster Backup

allow-suspicious-udfs option : mysqld, Server Command Options

AllowSpinOverhead, Defining NDB Cluster Data Nodes

AllowUnresolvedHostNames, NDB Cluster TCP/IP Connections

ALLOW_INVALID_DATES SQL mode, Full List of SQL Modes

ALLOW_NONEXISTENT_DEFINER privilege, Dynamic Privilege Descriptions : orphan stored objects, Orphan Stored Objects

ALTER COLUMN, ALTER TABLE Statement

ALTER DATABASE, ALTER DATABASE Statement

ALTER EVENT, ALTER EVENT Statement : and replication, Replication of Invoked Features

ALTER FUNCTION, ALTER FUNCTION Statement

ALTER INSTANCE, ALTER INSTANCE Statement

ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Statement : (see also NDB Cluster Disk Data)

ALTER privilege, Static Privilege Descriptions

ALTER PROCEDURE, ALTER PROCEDURE Statement

ALTER RESOURCE GROUP statement, ALTER RESOURCE GROUP Statement

ALTER ROUTINE privilege, Static Privilege Descriptions

ALTER SCHEMA, ALTER DATABASE Statement

ALTER SERVER, ALTER SERVER Statement

ALTER TABLE, ALTER TABLE Statement, Problems with ALTER TABLE : and replication metadata repositories, Relay Log and Replication Metadata Repositories

monitoring, [Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/monitor-alter-table-performance-schema.html)

ROW\_FORMAT, [Defining the Row Format of a Table](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/innodb-row-format.html#innodb-row-format-defining)

ALTER TABLESPACE : general tablespace, ALTER TABLESPACE Statement

NDB Cluster Disk Data, [ALTER TABLESPACE Statement](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/alter-tablespace.html)

undo tablespace, [ALTER TABLESPACE Statement](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/alter-tablespace.html)

ALTER USER statement, Assigning Account Passwords, ALTER USER Statement

ALTER VIEW, ALTER VIEW Statement

altering : database, ALTER DATABASE Statement

schema, [ALTER DATABASE Statement](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/alter-database.html)

altering table : thread state, General Thread States

altering user accounts, ALTER USER Statement

MySQL Enterprise Backup, MySQL Glossary

analyze option : myisamchk, Other myisamchk Options

mysqlcheck, [mysqlcheck — A Table Maintenance Program](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/mysqlcheck.html)

ANALYZE TABLE : and partitioning, Maintenance of Partitions

ANALYZE TABLE statement, ANALYZE TABLE Statement

Analyzing : thread state, General Thread States

AND : bitwise, Bit Functions and Operators

logical, [Logical Operators](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/logical-operators.html)

anonymous user, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification

ANSI, MySQL Glossary

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

antijoins, Optimizing IN and EXISTS Subquery Predicates with Semijoin and Antijoin Transformations

ANY, Subqueries with ANY, IN, or SOME

ANY_VALUE(), Miscellaneous Functions

Apache, Using MySQL with Apache

API, MySQL Glossary

API node (NDB Cluster) : defined, NDB Cluster Core Concepts

API nodes (see SQL nodes)

ApiFailureHandlingTimeout, Defining NDB Cluster Data Nodes

APIs, Connectors and APIs : Perl, MySQL Perl API

append option : ndb_restore, ndb_restore — Restore an NDB Cluster Backup

APPLICABLE_ROLES : INFORMATION_SCHEMA table, The INFORMATION_SCHEMA APPLICABLE_ROLES Table

application error handling, Handle MySQL Error Messages Properly

application programming interface (API), MySQL Glossary

APPLICATION_PASSWORD_ADMIN privilege, Dynamic Privilege Descriptions

apply, MySQL Glossary

apply-replica-statements option : mysqldump, mysqldump — A Database Backup Program

apply-slave-statements option : mysqldump, mysqldump — A Database Backup Program

apply_status table (OBSOLETE), ndb_apply_status Table : (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

arithmetic expressions, Arithmetic Operators

arithmetic functions, Bit Functions and Operators

arithmetic operators, Bit Functions and Operators

.ARM file, MySQL Glossary

array : JSON, Creating JSON Values

.ARZ file, MySQL Glossary

AS, SELECT Statement, JOIN Clause, MySQL Glossary

ASCII(), String Functions and Operators

ASIN(), Mathematical Functions

ASP.net, MySQL Glossary

assembly, MySQL Glossary

assigning roles, SET ROLE Statement

assignment operator : :=, Assignment Operators

=, [Assignment Operators](https://docs.oracle.com/cd/E17952_01/mysql-8.4-en/assignment-operators.html)

assignment operators, Assignment Operators

asymmetric_decrypt(), MySQL Enterprise Encryption Component Function Descriptions

asymmetric_encrypt(), MySQL Enterprise Encryption Component Function Descriptions

asymmetric_sign(), MySQL Enterprise Encryption Component Function Descriptions

asymmetric_verify(), MySQL Enterprise Encryption Component Function Descriptions

asynchronous I/O, Using Asynchronous I/O on Linux, MySQL Glossary

asynchronous replication (see NDB Cluster replication)

asynchronous_connection_failover_add_managed() function, Asynchronous Replication Channel Failover Functions

asynchronous_connection_failover_add_source() function, Asynchronous Replication Channel Failover Functions

asynchronous_connection_failover_delete_managed() function, Asynchronous Replication Channel Failover Functions

asynchronous_connection_failover_delete_source() function, Asynchronous Replication Channel Failover Functions

asynchronous_connection_failover_reset() function, Asynchronous Replication Channel Failover Functions

ATAN(), [Mathem

（本文超出站点单文档体积上限，已截断）