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

#mysql50 identifier prefix, Schema Object Names, Mapping of Identifiers to File 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

--basedir

removed features, Features Removed in MySQL 5.7

--bootstrap

deprecated features, Features Deprecated in MySQL 5.7

--comments

deprecated features, Features Deprecated in MySQL 5.7

--datadir

removed features, Features Removed in MySQL 5.7

--des-key-file

deprecated features, Features Deprecated in MySQL 5.7

--fix-db-names

deprecated features, Features Deprecated in MySQL 5.7

--fix-table-names

deprecated features, Features Deprecated in MySQL 5.7

--ignore-db-dir

deprecated features, Features Deprecated in MySQL 5.7

--log-warnings

deprecated features, Features Deprecated in MySQL 5.7

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

--secure-auth

removed features, Features Removed in MySQL 5.7

--skip-comments

deprecated features, Features Deprecated in MySQL 5.7

--skip-innodb

deprecated features, Features Deprecated in MySQL 5.7

--skip-secure-auth

removed features, Features Removed in MySQL 5.7

--ssl

deprecated features, Features Deprecated in MySQL 5.7

--ssl-verify-server-cert

deprecated features, Features Deprecated in MySQL 5.7

--temp-pool

deprecated features, Features Deprecated in MySQL 5.7

--tmpdir

removed features, Features Removed in MySQL 5.7

->, 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

.frm file, Files Created by CREATE TABLE

.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

.mysql_secret file, Installing MySQL on Linux Using RPM Packages from Oracle, mysql_install_db — Initialize MySQL Data Directory

.pid (process ID) file, Setting Up a MyISAM Table Maintenance Schedule

/ (division), Arithmetic Operators

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

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

\N as NULL

deprecated features, Features Deprecated in MySQL 5.7

\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

_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

abort-slave-event-count option

mysqld, Startup Options for Replicas

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

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

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
Locked_connects status variable, Server Status Variables

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
deleting, Dropping Accounts
reserved, Reserved Accounts

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

ACOS(), Mathematical Functions

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

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
functions, Adding Functions to MySQL
native functions, Adding a Native Function
new account privileges, Adding Accounts, Assigning Privileges, and Dropping Accounts
new user privileges, Adding Accounts, Assigning Privileges, and Dropping Accounts
user-defined functions, Adding a User-Defined Function

addition (+), Arithmetic Operators

ADDTIME(), Date and Time Functions

admin-auth-plugin option

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

admin-host option

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

admin-require-ssl option

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

admin-user option

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

administration

server, mysqladmin — A MySQL Server Administration Program

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

administrative programs, Overview of MySQL Programs

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
in GROUP BY clauses, MySQL Handling of GROUP BY
names, Schema Object Names
on expressions, SELECT Statement

ALL, Subqueries with ALL

SELECT modifier, SELECT Statement

ALL join type

optimizer, EXPLAIN Join Types

ALL privilege, Privilege Descriptions

ALL PRIVILEGES privilege, Privilege Descriptions

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

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

ALLOW_INVALID_DATES SQL mode, Full List of SQL Modes

ALTER COLUMN, ALTER TABLE Statement

ALTER DATABASE, ALTER DATABASE Statement

deprecated features, Features Deprecated in MySQL 5.7

ALTER EVENT, ALTER EVENT Statement

and replication, Replication of Invoked Features

ALTER FUNCTION, ALTER FUNCTION Statement

ALTER IGNORE TABLE

removed features, Features Removed in MySQL 5.7

ALTER INSTANCE, ALTER INSTANCE Statement

ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Statement

(see also NDB Cluster Disk Data)

ALTER privilege, Privilege Descriptions

ALTER PROCEDURE, ALTER PROCEDURE Statement

ALTER ROUTINE privilege, Privilege Descriptions

ALTER SCHEMA, ALTER DATABASE Statement

ALTER SERVER, ALTER SERVER Statement

ALTER TABLE, ALTER TABLE Statement, Problems with ALTER TABLE

and replication applier metadata repositories, Relay Log and Replication Applier Metadata Repositories
monitoring, Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
ROW_FORMAT, Defining the Row Format of a Table

ALTER TABLE partition validation

new features, Features Added in MySQL 5.7

ALTER TABLESPACE

NDB Cluster Disk Data, ALTER TABLESPACE Statement

ALTER USER statement, Assigning Account Passwords, ALTER USER Statement

ALTER VIEW, ALTER VIEW Statement

altering

database, ALTER DATABASE Statement
schema, ALTER DATABASE Statement

altering table

thread state, General Thread States

altering user accounts, ALTER USER Statement

ANALYSE()

PROCEDURE, Using PROCEDURE ANALYSE

analyze option

myisamchk, Other myisamchk Options
mysqlcheck, mysqlcheck — A Table Maintenance Program

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

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

Antelope, MySQL Glossary

Antelope file format, InnoDB File-Format Management, InnoDB Startup Options and System Variables

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 Glossary

apply, MySQL Glossary

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

Area(), Polygon and MultiPolygon Property Functions

argument processing, UDF Argument Processing

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

AsBinary(), Geometry Format Conversion Functions

ASCII(), String Functions and Operators

ASIN(), Mathematical Functions

assignment operator

:=, Assignment Operators
=, Assignment Operators

assignment operators, Assignment Operators

AsText(), Geometry Format Conversion Functions

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 Glossary

asynchronous replication (see NDB Cluster replication)

ATAN(), Mathematical Functions

ATAN2(), Mathematical Functions

atomic, MySQL Glossary

atomic DDL, MySQL Glossary

atomic instruction, MySQL Glossary

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

audit log encryption UDFs

audit_log_encryption_password_get(), Encrypting Audit Log Files, Audit Log Functions
audit_log_encryption_password_set(), Encrypting Audit Log Files, Audit Log Functions

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_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 reading UDFs

audit_log_read(), Reading Audit Log Files, Audit Log Functions
audit_log_read_bookmark(), Reading Audit Log Files, Audit Log Functions

audit plugins, Audit Plugins

audit-log option

mysqld, Audit Log Options and Variables

audit_log plugin, MySQL Enterprise Audit

and Group Replication, Audit Log Restrictions, Group Replication Limitations
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 encryption UDF, Encrypting Audit Log Files, Audit Log Functions

audit_log_encryption_password_set() audit log encryption UDF, Encrypting Audit Log Files, 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, Reading Audit Log Files, 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 reading UDF, Reading Audit Log Files, Audit Log Functions

audit_log_read_bookmark() audit log reading UDF, Reading Audit Log Files, Audit Log Functions

audit_log_read_buffer_size system variable, Reading Audit Log Files, 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
mysql_old_password, Old Native Pluggable Authentication
sha256_password, SHA-256 Pluggable Authentication
test_plugin_server, Test Pluggable Authentication

authentication plugins, Authentication Plugins

AUTHENTICATION_LDAP_CLIENT_LOG environment variable, Environment Variables, 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, Environment Variables, PAM 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 — A Load Emulation Client

auto-generate-sql-add-autoincrement option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-execute-number option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-guid-primary option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-load-type option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-secondary-indexes option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-unique-query-number option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-unique-write-number option

mysqlslap, mysqlslap — A Load Emulation Client

auto-generate-sql-write-number option

mysqlslap, mysqlslap — A Load Emulation Client

auto-inc lock, InnoDB Locking

auto-inc option

ndb_desc, ndb_desc — Describe NDB Tables

auto-increment, AUTO_INCREMENT Handling in InnoDB, InnoDB AUTO_INCREMENT Lock Modes, InnoDB AUTO_INCREMENT Counter Initialization, Notes, MySQL Glossary

auto-increment locking, MySQL Glossary

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 Statement

autocommit, MySQL Glossary

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 Type Attributes

and NULL values, Problems with NULL Values
and replication, Replication and AUTO_INCREMENT

auto_increment_increment system variable, System Variables Used on Replication Source Servers

auto_increment_offset system variable, System Variables Used on Replication Source Servers

availability, MySQL Glossary

AVG(), Aggregate Function Descriptions

AVG(DISTINCT), Aggregate Function Descriptions

avoid_temporal_upgrade system variable, Server System Variables

B

[ index top]

B-tree, MySQL Glossary

B-tree indexes, Comparison of B-Tree and Hash Indexes, The Physical Structure of an InnoDB Index

background threads, Configuring InnoDB I/O Capacity

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 Glossary

backup, MySQL Glossary

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

backup-path option

ndb_restore, ndb_restore — Restore an NDB Cluster Backup

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

back_log system variable, Server System Variables

Barracuda, MySQL Glossary

Barracuda file format, Creating Compressed Tables, InnoDB File-Format Management, InnoDB Startup Options and System Variables

base column, MySQL Glossary

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_install_db, mysql_install_db — Initialize MySQL Data Directory
mysql_plugin, mysql_plugin — Configure MySQL Server Plugins

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 Statements, BEGIN ... END Compound Statement

labels, Statement Labels
XA transactions, XA Transaction SQL Statements

BENCHMARK(), Information Functions

benchmarks, Using Your Own Benchmarks

beta, MySQL Glossary

BETWEEN ... AND, Comparison Functions and Operators

bidirectional replication

in NDB Cluster, NDB Cluster Replication: Bidrectional and Circular Replication, NDB Cluster Replication Conflict Resolution

big5, MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

BIGINT data type, Numeric Data Type Syntax

big_tables system variable, Server System Variables

BIN(), String Functions and Operators

BINARY, Cast Functions and Operators

binary collation, The binary Collation Compared to _bin Collations

BINARY data type, String Data Type Syntax, The BINARY and VARBINARY Types

binary distributions

installing, Installing MySQL on Unix/Linux Using Generic Binaries

binary log, The Binary Log, MySQL Glossary

event groups, Skipping Transactions With SET GLOBAL sql_slave_skip_counter

binary logging

and NDB Cluster, Issues Exclusive to NDB Cluster

binary-as-hex option

mysql, mysql Client Options

binary-configure.sh

removed features, Features Removed in MySQL 5.7

binary-mode option

mysql, mysql Client Options

bind-address option

mysql, mysql Client Options
mysqladmin, mysqladmin — A MySQL Server Administration Program
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
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 Glossary

Binlog Dump

thread command, Thread Command Values

BINLOG statement, BINLOG Statement

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-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_cache_disk_use status variable, Server Status Variables

binlog_cache_size system variable, System Variables Used with Binary Logging

Binlog_cache_use status variable, Server Status Variables

binlog_checksum system variable, System Variables Used with Binary Logging

binlog_direct_non_transactional_updates system variable, System Variables Used with Binary Logging

binlog_error_action system variable, 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, Global Transaction ID System Variables

binlog_index table (OBSOLETE) (see NDB Cluster replication)

binlog_max_flush_queue_time

deprecated features, Features Deprecated in MySQL 5.7

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_rows_query_log_events system variable, System Variables Used with Binary Logging

binlog_row_image system variable, System Variables Used with Binary Logging

Binlog_stmt_cache_disk_use status variable, Server Status Variables

binlog_stmt_cache_size system variable, System Variables Used with Binary Logging

Binlog_stmt_cache_use status variable, Server Status Variables

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

BIT data type, Numeric Data Type Syntax

bit functions, Bit Functions and Operators

example, Calculating Visits Per Day

bit operators, Bit Functions and Operators

bit-value literal introducer, Bit-Value Literals

bit-value literals, Bit-Value Literals

BIT_AND(), Aggregate Function Descriptions

BIT_COUNT, Calculating Visits Per Day

BIT_COUNT(), Bit Functions and Operators

BIT_LENGTH(), String Functions and Operators

BIT_OR, Calculating Visits Per Day

BIT_OR(), Aggregate Function Descriptions

BIT_XOR(), Aggregate 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 Glossary

BLOB columns

default values, The BLOB and TEXT Types
indexing, Index Prefixes, CREATE TABLE Statement
inserting binary data, String Literals
size, String Type Storage Requirements

BLOB data type, String Data Type Syntax, 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 Semijoins

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 Data Type Syntax

BOOLEAN data type, Numeric Data Type Syntax

boolean literals, Boolean Literals

boolean options, Program Option Modifiers

Boolean search, Boolean Full-Text Searches

bootstrap option

mysqld, Server Command Options

bottleneck, MySQL Glossary

bounce, MySQL Glossary

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 Glossary

buffer, MySQL Glossary

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 Buffer Pool Flushing, Saving and Restoring the Buffer Pool State, MySQL Glossary

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 Glossary

buffer sizes, InnoDB Buffer Pool Optimization, Configuring InnoDB Buffer Pool Size

client, Connectors and APIs

Buffer(), Spatial Operator Functions

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

builddir option

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

BuildIndexThreads, Defining NDB Cluster Data Nodes

building

client programs, Building C API Client Programs

BUILD_CONFIG option

CMake, General Options

built-in, MySQL Glossary

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, MyISAM Startup Options

business rules, MySQL Glossary

Bytes_received status variable, Server Status Variables

Bytes_sent status variable, Server Status Variables

C

[ index top]

C API, Connectors and APIs

data structures, C API Data Structures
data types, MySQL C API
example programs, Example C API Client Programs
FAQ, MySQL 5.7 FAQ: C API, libmysql
functions, C API Function Overview
linking problems, Troubleshooting Problems Linking to the MySQL Client Library

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 Glossary

CACHE INDEX

and partitioning, Restrictions and Limitations on Partitioning

CACHE INDEX statement, CACHE INDEX Statement

caches

clearing, FLUSH Statement

cache_policies table, InnoDB memcached Plugin Configuration Tables

caching_sha2_password authentication plugin, Caching SHA-2 Pluggable Authentication

calculating

aggregate value for a set of rows, Aggregate Function Descriptions
cardinality, SHOW INDEX Statement
dates, Date Calculations

calendar, What Calendar Is Used By MySQL?

CALL, CALL Statement

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

cardinality,

首页

MySql

General Index

Symbols

A

B

C