MySQL 5.1 英文手册 :: Index

MySQL 实验室因为专注，所以专业。

MySQL 5.1 Reference Manual :: Index
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), Strings

& (bitwise AND), Bit Functions

&& (logical AND), Logical Operators

() (parentheses), Operator Precedence

(Control-Z) \Z, Strings, LOAD DATA INFILE Syntax

* (multiplication), Arithmetic Operators

+ (addition), Arithmetic Operators

- (subtraction), Arithmetic Operators

- (unary minus), Arithmetic Operators

--append option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--bind-address option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--character-sets-dir option

MySQL Cluster programs, Options Common to MySQL Cluster Programs

--config-cache option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--config-file option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--configdir option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--connect-string option (MySQL Cluster), Options Common to MySQL Cluster Programs

--core-file option (MySQL Cluster), Options Common to MySQL Cluster Programs

--daemon option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--debug option (MySQL Cluster), Options Common to MySQL Cluster Programs

--disable option prefix, Program Option Modifiers

--disable-indexes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--enable option prefix, Program Option Modifiers

--exclude-databases option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--exclude-missing-columns option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--exclude-tables option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--execute option (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client

--fields-enclosed-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--fields-optionally-enclosed-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--fields-terminated-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--help option

MySQL Cluster programs, Options Common to MySQL Cluster Programs

--hex option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--include-databases option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--include-tables option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--initial option (ndbd), ndbd — The MySQL Cluster Data Node Daemon

--initial option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon

--initial option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--initial-start option (ndbd), ndbd — The MySQL Cluster Data Node Daemon

--initial-start option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon

--log-name option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--loose option prefix, Program Option Modifiers

--maximum option prefix, Program Option Modifiers

--ndb-log-update-as-write (mysqld option), MySQL Cluster Replication Conflict Resolution

--ndb-mgmd-host option (MySQL Cluster), Options Common to MySQL Cluster Programs

--ndb-nodeid option (MySQL Cluster), Options Common to MySQL Cluster Programs

--ndb-optimized-node-selection option (MySQL Cluster), Options Common to MySQL Cluster Programs

--nodaemon option (ndbd), ndbd — The MySQL Cluster Data Node Daemon

--nodaemon option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon

--nodaemon option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--nostart option (ndbd), ndbd — The MySQL Cluster Data Node Daemon

--nostart option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon

--nowait-nodes option (ndbd), ndbd — The MySQL Cluster Data Node Daemon

--nowait-nodes option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon

--nowait-nodes option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

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

--print-full-config option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--rebuild-indexes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--reload option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

--restore_backupid option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_backup_path option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_connect option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_epoch option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_nodeid option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_preserve-trailing-spaces option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_print_data option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_promote-attributes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--restore_skip-table-check option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--skip option prefix, Program Option Modifiers

--skip-unknown-objects option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--tab option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup

--usage option

MySQL Cluster programs, Options Common to MySQL Cluster Programs

--version option (MySQL Cluster), Options Common to MySQL Cluster Programs

-? option

MySQL Cluster programs, Options Common to MySQL Cluster Programs

-c option (MySQL Cluster), Options Common to MySQL Cluster Programs

-c option (ndb_mgmd) (OBSOLETE), ndb_mgmd — The MySQL Cluster Management Server Daemon

-d option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

-e option (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client

-f option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

-n option (ndbd), ndbd — The MySQL Cluster Data Node Daemon

-n option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon

-p option, End-User Guidelines for Password Security

-P option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon

-V option (MySQL Cluster), Options Common to MySQL Cluster Programs

.my.cnf file, Connecting to the MySQL Server, Using Option Files, End-User Guidelines for Password Security, Causes of Access-Denied Errors, Using Client Programs in a Multiple-Server Environment

.mysql_history file, mysql Options, End-User Guidelines for Password Security

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

/ (division), Arithmetic Operators

/etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax

:= (assignment), User-Defined Variables

< (less than), Comparison Functions and Operators

<<, Calculating Visits Per Day

<< (left shift), Bit Functions

<= (less than or equal), Comparison Functions and Operators

<=> (equal to), Comparison Functions and Operators

<> (not equal), Comparison Functions and 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

[api] (MySQL Cluster), MySQL Cluster SQL Node and API Node Configuration Parameters

[computer] (MySQL Cluster), Other MySQL Cluster Configuration Parameters

[mgm] (MySQL Cluster), MySQL Cluster Management Node Configuration Parameters

[ndbd default] (MySQL Cluster), MySQL Cluster Data Node Configuration Parameters

[ndbd] (MySQL Cluster), MySQL Cluster Data Node Configuration Parameters

[ndb_mgmd] (MySQL Cluster), MySQL Cluster Management Node Configuration Parameters

[sci] (MySQL Cluster), Other MySQL Cluster Configuration Parameters

[shm] (MySQL Cluster), Other MySQL Cluster Configuration Parameters

[SQL] (MySQL Cluster), MySQL Cluster SQL Node and API Node Configuration Parameters

[tcp] (MySQL Cluster), Other MySQL Cluster Configuration Parameters

\" (double quote), Strings

\' (single quote), Strings

\. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File

\0 (ASCII NUL), Strings, LOAD DATA INFILE Syntax

\b (backspace), Strings, LOAD DATA INFILE Syntax

\n (linefeed), Strings, LOAD DATA INFILE Syntax

\n (newline), Strings, LOAD DATA INFILE Syntax

\N (NULL), LOAD DATA INFILE Syntax

\r (carriage return), Strings, LOAD DATA INFILE Syntax

\t (tab), Strings, LOAD DATA INFILE Syntax

\Z (Control-Z) ASCII 26, Strings, LOAD DATA INFILE Syntax

\\ (escape), Strings

^ (bitwise XOR), Bit Functions

_ (wildcard character), Strings

_rowid, CREATE TABLE Syntax

`, Schema Object Names

| (bitwise OR), Bit Functions

|| (logical OR), Logical Operators

~, Bit Functions

A
[index top]

abort-slave-event-count option

mysqld, Replication Slave Options and Variables

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 names, Specifying Account Names

account privileges

adding, Adding User Accounts

accounts

anonymous user, Securing the Initial MySQL Accounts

root, Securing the Initial MySQL Accounts

ACID, Transactions and Atomic Operations, The InnoDB Storage Engine

ACLs, The MySQL Access Privilege System

ACOS(), Mathematical Functions

Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP)

ActiveState Perl, Installing ActiveState Perl on Windows

add-drop-database option

mysqldump, mysqldump — A Database Backup Program

add-drop-table option

mysqldump, mysqldump — A Database Backup Program

add-locks option

mysqldump, mysqldump — A Database Backup Program

add-user option

mysqlmanager, MySQL Instance Manager Command Options

ADDDATE(), Date and Time Functions

adding

character sets, Adding a New 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

new users, Installing MySQL from Generic Binaries on Unix/Linux, Source Installation Overview

procedures, Adding New Procedures to MySQL

user-defined functions, Adding a New User-Defined Function

addition (+), Arithmetic Operators

ADDTIME(), Date and Time Functions

addtodest option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

administration

server, mysqladmin — Client for Administering a MySQL Server

administration of MySQL Cluster, ndb_mgm — The MySQL 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

alias names

case sensitivity, Identifier Case Sensitivity

aliases

for expressions, GROUP BY and HAVING with Hidden Columns

for tables, SELECT Syntax

in GROUP BY clauses, GROUP BY and HAVING with Hidden Columns

names, Schema Object Names

on expressions, SELECT Syntax

ALL, SELECT Syntax, Subqueries with ALL

ALL join type

optimizer, Optimizing Queries with EXPLAIN

all-databases option

mysqlcheck, mysqlcheck — A Table Maintenance Program

mysqldump, mysqldump — A Database Backup Program

all-in-1 option

mysqlcheck, mysqlcheck — A Table Maintenance Program

all-tablespaces option

mysqldump, mysqldump — A Database Backup Program

allocating local table

thread state, Delayed-Insert Thread States

allow-keywords option

mysqldump, mysqldump — A Database Backup Program

allow-suspicious-udfs option

mysqld, Server Command Options, Security-Related mysqld Options

allowold option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

ALLOW_INVALID_DATES SQL mode, Server SQL Modes

ALTER COLUMN, ALTER TABLE Syntax

ALTER DATABASE, ALTER DATABASE Syntax

ALTER EVENT, ALTER EVENT Syntax

ALTER FUNCTION, ALTER FUNCTION Syntax

ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Syntax

(see also MySQL Cluster Disk Data)

ALTER PROCEDURE, ALTER PROCEDURE Syntax

ALTER SCHEMA, ALTER DATABASE Syntax

ALTER SERVER, ALTER SERVER Syntax

ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE

ALTER TABLESPACE, ALTER TABLESPACE Syntax

(see also MySQL Cluster Disk Data)

ALTER VIEW, ALTER VIEW Syntax

altering

database, ALTER DATABASE Syntax

schema, ALTER DATABASE Syntax

analyze option

myisamchk, Other myisamchk Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

ANALYZE TABLE, ANALYZE TABLE Syntax

and partitioning, Maintenance of Partitions

Analyzing

thread state, General Thread States

AND

bitwise, Bit Functions

logical, Logical Operators

angel-pid-file option

mysqlmanager, MySQL Instance Manager Command Options

anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification

ANSI mode

running, Running MySQL in ANSI Mode

ansi option

mysqld, Server Command Options

ANSI SQL mode, Server SQL Modes

ANSI_QUOTES SQL mode, Server SQL Modes

answering questions

etiquette, Guidelines for Using the Mailing Lists

ANY, Subqueries with ANY, IN, or SOME

Apache, Using MySQL with Apache

API node (MySQL Cluster)

defined, MySQL Cluster Core Concepts

API nodes (see SQL nodes)

API's

list of, Packages that support MySQL

APIs, Connectors and APIs

Perl, MySQL Perl API

apply_status table (OBSOLETE), MySQL Cluster Replication Schema and Tables

(see also MySQL Cluster replication)

approximate-value literals, Precision Math

Arbitration, Defining MySQL Cluster Data Nodes

ArbitrationDelay, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster

ArbitrationRank, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster

ArbitrationTimeout (DEPRECATED), Defining MySQL Cluster Data Nodes

arbitrator, MySQL 5.1 FAQ: MySQL Cluster

ARCHIVE storage engine, Storage Engines, The ARCHIVE Storage Engine

Area(), Polygon Functions, MultiPolygon Functions

argument processing, UDF Argument Processing

arithmetic expressions, Arithmetic Operators

arithmetic functions, Bit Functions

AS, SELECT Syntax, JOIN Syntax

AS/400, Installing MySQL on i5/OS

AsBinary(), Geometry Format Conversion Functions

ASCII(), String Functions

ASIN(), Mathematical Functions

AsText(), Geometry Format Conversion Functions

asynchronous replication (see MySQL Cluster replication)

ATAN(), Mathematical Functions

ATAN2(), Mathematical Functions

attackers

security against, Making MySQL Secure Against Attackers

attribute demotion

replication, Replication of Columns Having Different Data Types

attribute promotion

ndb_restore, ndb_restore — Restore a MySQL Cluster Backup

replication, Replication of Columns Having Different Data Types

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

ODBC, Obtaining Auto-Increment Values

auto-rehash option

mysql, mysql Options

auto-repair option

mysqlcheck, mysqlcheck — A Table Maintenance Program

autoclose option

mysqld_safe, mysqld_safe — MySQL Server Startup Script

autocommit session variable, Server System Variables

automatic_sp_privileges system variable, Server System Variables

AutoReconnect

API and SQL nodes, Defining SQL and Other API Nodes in a MySQL Cluster

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, Replication Master Options and Variables

auto_increment_offset system variable, Replication Master Options and Variables

AVG(), GROUP BY (Aggregate) Functions

AVG(DISTINCT), GROUP BY (Aggregate) Functions

B
[index top]

backslash

escape character, Strings

backspace (\b), Strings, LOAD DATA INFILE Syntax

backup identifiers

native backup and restore, Using The MySQL Cluster Management Client to Create a Backup

backup option

myisamchk, myisamchk Repair Options

myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables

BACKUP TABLE, BACKUP TABLE Syntax

BackupDataBufferSize, Configuration for MySQL Cluster Backups

BackupDataBufferSize (MySQL Cluster configuration parameter), Defining MySQL Cluster Data Nodes

BackupDataDir, Defining MySQL Cluster Data Nodes

BackupLogBufferSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups

BackupMaxWriteSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups

BackupMemory, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups

BackupReportFrequency, Defining MySQL Cluster Data Nodes

backups, Backup and Recovery

database, BACKUP TABLE Syntax

databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program

in MySQL Cluster, ndb_restore — Restore a MySQL Cluster Backup, Online Backup of MySQL Cluster, MySQL Cluster Backup Concepts, Using The MySQL Cluster Management Client to Create a Backup, Configuration for MySQL Cluster Backups

in MySQL Cluster replication, MySQL Cluster Backups With MySQL Cluster Replication

InnoDB, Backing Up and Recovering an InnoDB Database

with mysqldump, Using mysqldump for Backups

backups, troubleshooting

in MySQL Cluster, MySQL Cluster Backup Troubleshooting

BackupWriteSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups

back_log system variable, Server System Variables

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_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

basedir system variable, Server System Variables

batch mode, Using mysql in Batch Mode

batch option

mysql, mysql Options

batch SQL files, mysql — The MySQL Command-Line Tool

BatchByteSize, Defining SQL and Other API Nodes in a MySQL Cluster

batched updates (MySQL Cluster Replication), Starting MySQL Cluster Replication (Single Replication Channel)

BatchSize, Defining SQL and Other API Nodes in a MySQL Cluster

BatchSizePerLocalScan, Defining MySQL Cluster Data Nodes

Bazaar tree, Installing from the Development Source Tree

BdMPolyFromText(), Creating Geometry Values Using WKT Functions

BdMPolyFromWKB(), Creating Geometry Values Using WKB Functions

BdPolyFromText(), Creating Geometry Values Using WKT Functions

BdPolyFromWKB(), Creating Geometry Values Using WKB Functions

BEGIN, START TRANSACTION, COMMIT, and ROLLBACK Syntax, BEGIN ... END Compound Statement Syntax

XA transactions, XA Transaction SQL Syntax

benchmark suite, The MySQL Benchmark Suite

BENCHMARK(), Information Functions

benchmarks, Using Your Own Benchmarks

BETWEEN ... AND, Comparison Functions and Operators

big-tables option

mysqld, Server Command Options

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

BIGINT data type, Overview of Numeric Types

big_tables session variable, Server System Variables

BIN(), String Functions

BINARY, Cast Functions and Operators

BINARY data type, Overview of String Types, The BINARY and VARBINARY Types

binary distributions

installing, Installing MySQL from Generic Binaries on Unix/Linux

binary log, The Binary Log

event groups, SET GLOBAL sql_slave_skip_counter Syntax

binary logging

and MySQL Cluster, Issues Exclusive to MySQL Cluster

bind-address option

mysqld, Server Command Options

mysqlmanager, MySQL Instance Manager Command Options

BINLOG, BINLOG Syntax

Binlog Dump

thread command, Thread Command Values

BINLOG statement

mysqlbinlog output, mysqlbinlog Row Event Display

binlog-do-db option

mysqld, Binary Log Options and Variables

binlog-format option

mysqld, Server Command Options

binlog-ignore-db option

mysqld, Binary Log Options and Variables

binlog-row-event-max-size option

mysqld, Binary Log Options and Variables

binlog_cache_size system variable, Binary Log Options and Variables

binlog_direct_non_transactional_updates system variable, Binary Log Options and Variables

binlog_format system variable, Binary Log Options and Variables

binlog_index table (OBSOLETE) (see MySQL Cluster replication)

BIT data type, Overview of Numeric Types

BitKeeper tree, Installing from the Development Source Tree

BIT_AND(), GROUP BY (Aggregate) Functions

BIT_COUNT, Calculating Visits Per Day

BIT_COUNT(), Bit Functions

bit_functions

example, Calculating Visits Per Day

BIT_LENGTH(), String Functions

BIT_OR, Calculating Visits Per Day

BIT_OR(), GROUP BY (Aggregate) Functions

BIT_XOR(), GROUP BY (Aggregate) Functions

BLACKHOLE storage engine, Storage Engines, The BLACKHOLE Storage Engine

BLOB

inserting binary data, Strings

size, Data Type Storage Requirements

BLOB columns

default values, The BLOB and TEXT Types

indexing, Column Indexes, CREATE TABLE Syntax

BLOB data type, Overview of String Types, The BLOB and TEXT Types

blob-info option

ndb_desc, ndb_desc — Describe NDB Tables

Block Nested-Loop join algorithm, Nested-Loop Join Algorithms

block-search option

myisamchk, Other myisamchk Options

blocks

ndbinfo table, The ndbinfo blocks Table

BOOL data type, Overview of Numeric Types

BOOLEAN data type, Overview of Numeric Types

boolean options, Program Option Modifiers

bootstrap option

mysqld, Server Command Options

Borland Builder 4, Using Connector/ODBC with Borland Builder 4

Boundary(), General Geometry Functions

brackets

square, Data Types

brief option

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

Buffer pool

InnoDB, The InnoDB Buffer Pool

buffer sizes

client, Connectors and APIs

mysqld server, Tuning Server Parameters

Buffer(), Spatial Operators

bug reports

criteria for, How to Report Bugs or Problems

bugs

known, Known Issues in MySQL

MySQL Cluster

reporting, ndb_error_reporter — NDB Error-Reporting Utility

reporting, How to Report Bugs or Problems

bugs database, How to Report Bugs or Problems

bugs.mysql.com, How to Report Bugs or Problems

building

client programs, Building Client Programs

bulk_insert_buffer_size system variable, Server System Variables

C
[index top]

C API

data types, MySQL C API

functions, C API Function Overview

linking problems, Problems Linking with the C API

C prepared statement API

functions, C API Prepared Statement Type Conversions, C API Prepared Statement Function Overview

type codes, C API Prepared Statement Type Codes

C++ APIs, MySQL C++ API

C++ Builder, Using Connector/ODBC with C++ Builder

C++ compiler

gcc, Typical configure Options

C++ compiler cannot create executables, Dealing with Problems Compiling MySQL

C:\my.cnf file, Using Client Programs in a Multiple-Server Environment

CACHE INDEX, CACHE INDEX Syntax

and partitioning, Restrictions and Limitations on Partitioning

caches

clearing, FLUSH Syntax

calculating

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

carriage return (\r), Strings, LOAD DATA INFILE Syntax

CASE, Control Flow Functions, CASE Statement

case sensitivity

in access checking, Privilege System Grant Tables

in identifiers, Identifier Case Sensitivity

in names, Identifier Case Sensitivity

in searches, Case Sensitivity in String Searches

in string comparisons, String Comparison Functions

case-sensitivity

of database names, MySQL Extensions to Standard SQL

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

CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

cc1plus problems, Dealing with Problems Compiling MySQL

CEIL(), Mathematical Functions

CEILING(), Mathematical Functions

Centroid(), MultiPolygon Functions

CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

cflags option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

CHANGE MASTER TO, CHANGE MASTER TO Syntax

in MySQL Cluster, Preparing the MySQL Cluster for Replication

Change user

thread command, Thread Command Values

ChangeLog, MySQL Change History

changes

log, MySQL Change History

MySQL 5.1, Changes in Release 5.1.x (Production)

MySQL Cluster, Changes in MySQL Cluster NDB 6.X and 7.X, Release Series Changelogs: MySQL Cluster NDB 6.X and 7.X

changes to privileges, When Privilege Changes Take Effect

changing

column, ALTER TABLE Syntax

field, ALTER TABLE Syntax

table, ALTER TABLE Syntax, Problems with ALTER TABLE

Changing master

thread state, Replication Slave Connection Thread States

changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Unix Socket File

CHAR data type, Overview of String Types, String Types

CHAR VARYING data type, Overview of String Types

CHAR(), String Functions

CHARACTER data type, Overview of String Types

character set repertoire, String Repertoire

character sets, Typical configure Options

adding, Adding a New Character Set

and MySQL Cluster (replication), Known Issues in MySQL Cluster Replication

and replication, Replication and Character Sets

Character sets, Character Set Support

CHARACTER VARYING data type, Overview of String Types

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

mysqlshow, mysqlshow — Display Database, Table, and Column Information

characters

multi-byte, Multi-Byte Character Support

CHARACTER_LENGTH(), String Functions

CHARACTER_SETS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table

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 Commands

charset option

comp_err, comp_err — Compile MySQL Error Message File

CHARSET(), Information Functions

CHAR_LENGTH(), String Functions

check option

myisamchk, myisamchk Check Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

check options

myisamchk, myisamchk Check Options

CHECK TABLE, CHECK TABLE Syntax

and partitioning, Maintenance of Partitions

check-only-changed option

myisamchk, myisamchk Check Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

check-password-file option

mysqlmanager, MySQL Instance Manager Command Options

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 privileges on cached query

thread state, Query Cache Thread States

checking query cache for query

thread state, Query Cache Thread States

Checking table

thread state, General Thread States

CHECKPOINT Events (MySQL Cluster), MySQL Cluster Log Events

checkpoint option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

Checksum, MySQL Cluster TCP/IP Connections

Checksum (MySQL Cluster), MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster

checksum errors, Installing MySQL on Solaris

CHECKSUM TABLE, CHECKSUM TABLE Syntax

Chinese, Japanese, Korean character sets

frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

choosing

a MySQL version, Choosing Which MySQL Distribution to Install

choosing types, Choosing the Right Type for a Column

chroot option

mysqld, Server Command Options

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

circular replication

in MySQL Cluster, Known Issues in MySQL Cluster Replication, MySQL Cluster Replication: Multi-Master and Circular Replication, MySQL Cluster Replication Conflict Resolution

CJK

FAQ, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

CJK (Chinese, Japanese, Korean)

Access, PHP, etc., MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

availability of specific characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

available character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

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

character sets available, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

characters displayed as question marks, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

CJKV, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

collations, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

conversion problems with Japanese character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

data truncation, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Database and table names, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

documentation in Chinese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

documentation in Japanese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

documentation in Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

gb2312, gbk, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Japanese character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Korean character set, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

LIKE and FULLTEXT, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

MySQL 4.0 behavior, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

ORDER BY treatment, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with Access, PHP, etc., MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with Big5 character sets (Chinese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with data truncation, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with euckr character set (Korean), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with GB character sets (Chinese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with LIKE and FULLTEXT, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

problems with Yen sign (Japanese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

rejected characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

sort order problems, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

sorting problems, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

testing availability of characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Unicode collations, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Vietnamese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Yen sign, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

clean-password-file option

mysqlmanager, MySQL Instance Manager Command Options

cleaning up

thread state, General Thread States

clear command

mysql, mysql Commands

Clearing

thread state, Event Scheduler Thread States

clearing

caches, FLUSH Syntax

client connection threads, How MySQL Uses Threads for Client Connections

client programs, Overview of MySQL Programs

building, Building Client Programs

client tools, Connectors and APIs

clients

debugging, Debugging a MySQL Client

threaded, How to Make a Threaded Client

CLOSE, Cursor CLOSE Statement

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 MySQL Cluster replication)

cluster logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands

cluster.binlog_index table (OBSOLETE) (see MySQL Cluster replication)

clustered index

InnoDB, Clustered and Secondary Indexes

Clustering (see MySQL Cluster)

CLUSTERLOG commands (MySQL Cluster), MySQL Cluster Logging Management Commands

CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

cluster_replication database (OBSOLETE) (see MySQL Cluster replication)

CMake, Building MySQL from Source Using CMake and Visual Studio

COALESCE(), Comparison Functions and Operators

COERCIBILITY(), Information Functions

ColdFusion, Using Connector/ODBC with ColdFusion

collating

strings, String Collating Support

collation

adding, How to Add a New Collation to a Character Set

INFORMATION_SCHEMA, Collation and INFORMATION_SCHEMA Searches

COLLATION(), Information Functions

collation-server option

mysqld, Server Command Options

COLLATIONS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table

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

column

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 names

case sensitivity, Identifier Case Sensitivity

column storage, CREATE TABLE Syntax

column-names option

mysql, mysql Options

column-type-info option

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

COLUMN_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

comma-separated values data, reading, LOAD DATA INFILE Syntax, SELECT Syntax

command options

mysql, mysql Options

mysqladmin, mysqladmin — Client for Administering a MySQL Server

mysqld, Server Command Options

command options (MySQL Cluster)

mysqld, mysqld Command Options for MySQL Cluster

ndbd, ndbd — The MySQL Cluster Data Node Daemon

ndb_mgm, ndb_mgm — The MySQL Cluster Management Client

ndb_mgmd, ndb_mgmd — The MySQL Cluster Management Server Daemon

command syntax, Typographical and Syntax Conventions, Conventions Used in This Document

command-line history

mysql, mysql Options

command-line options (MySQL Cluster), Options Common to MySQL Cluster Programs

command-line tool, mysql — The MySQL Command-Line Tool

commands

for binary distribution, Installing MySQL from Generic Binaries on Unix/Linux

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 Options

mysqldump, mysqldump — A Database Backup Program

COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax

XA transactions, XA Transaction SQL Syntax

commit option

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

mysqlslap, mysqlslap — Load Emulation Client

Committing events to binlog

thread state, MySQL Cluster Thread States

compact option

mysqldump, mysqldump — A Database Backup Program

comparison operators, Comparison Functions and Operators

compatibility

between MySQL versions, Upgrading from MySQL 5.0 to 5.1

with mSQL, Regular Expressions

with ODBC, Server System Variables, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax

with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax

with PostgreSQL, MySQL Extensions to Standard SQL

with standard SQL, MySQL Standards Compliance

with Sybase, USE Syntax

compatible option

mysqldump, mysqldump — A Database Backup Program

compiler

C++ gcc, Typical configure Options

compiling

on Windows, Compiling MySQL Clients on Windows

optimizing, System Factors and Startup Parameter Tuning

problems, Dealing with Problems Compiling MySQL

speed, How Compiling and Linking Affects the Speed of MySQL

statically, Typical configure Options

user-defined functions, Compiling and Installing User-Defined Functions

complete-insert option

mysqldump, mysqldump — A Database Backup Program

completion_type system variable, Server System Variables

compliance

Y2K, Year 2000 Issues and Date Types

composite partitioning, Subpartitioning

compound statements, MySQL Compound-Statement Syntax

compress option

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

COMPRESS(), Encryption and Compression Functions

compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics

CompressedBackup, Defining MySQL Cluster Data Nodes

CompressedLCP, Defining MySQL Cluster Data Nodes

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, Strings, String Functions

CONCAT_WS(), String Functions

concurrency option

mysqlslap, mysqlslap — Load Emulation Client

concurrent inserts, Internal Locking Methods, Concurrent Inserts

concurrent_insert system variable, Server System Variables

Conditions, DECLARE for Conditions

config-file option

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

my_print_defaults, my_print_defaults — Display Options from Option Files

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

config.cache, Dealing with Problems Compiling MySQL

config.cache file, Dealing with Problems Compiling MySQL

config.ini (MySQL Cluster), MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files, MySQL Cluster Configuration: Basic Example, ndb_mgmd — The MySQL Cluster Management Server Daemon

configinfo option

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

configuration

MySQL Cluster, Overview of MySQL Cluster Configuration Parameters

configuration files, Causes of Access-Denied Errors

configuration options, Typical configure Options

configure

disable-grant-options option, Typical configure Options

enable-community-features option, Typical configure Options

enable-debug-sync option, Typical configure Options

enable-profiling option, Typical configure Options

enable-thread-safe-client option, Typical configure Options

localstatedir option, Typical configure Options

prefix option, Typical configure Options

running after prior invocation, Dealing with Problems Compiling MySQL

with-big-tables option, Typical configure Options

with-charset option, Typical configure Options

with-client-ldflags option, Typical configure Options

with-collation option, Typical configure Options

with-debug option, Typical configure Options

with-embedded-server option, Typical configure Options

with-extra-charsets option, Typical configure Options

with-tcp-port option, Typical configure Options

with-unix-socket-path option, Typical configure Options

with-zlib-dir option, Typical configure Options

without-server option, Typical configure Options

configure option

--with-low-memory, Dealing with Problems Compiling MySQL

configure script, Typical configure Options

configuring backups

in MySQL Cluster, Configuration for MySQL Cluster Backups

configuring MySQL Cluster, MySQL Cluster Multi-Computer How-To, MySQL Cluster Configuration, MySQL Server Usage for MySQL Cluster, ndb_mgmd — The MySQL Cluster Management Server Daemon

Configuring MySQL Cluster (concepts), MySQL Cluster Core Concepts

config_params

ndbinfo table, The ndbinfo config_params Table

conflict resolution

and ndb_replication system table, MySQL Cluster Replication Conflict Resolution

enabling, MySQL Cluster Replication Conflict Resolution

in MySQL Cluster Replication, MySQL Cluster Replication Conflict Resolution

mysqld startup options, MySQL Cluster Replication Conflict Resolution

Connect

thread command, Thread Command Values

connect command

mysql, mysql Commands

Connect Out

thread command, Thread Command Values

connecting

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

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 (MySQL Cluster), MySQL Cluster Log Events

CONNECTION_ID(), Information Functions

Connector/C, Connectors and APIs

Connector/C++, Connectors and APIs

Connector/JDBC, Connectors and APIs

Connector/MXJ, Connectors and APIs

Connector/NET, Connectors and APIs, MySQL Connector/NET

reporting problems, Connector/NET Support

Connector/ODBC, Connectors and APIs, MySQL Connector/ODBC

Borland, Using Connector/ODBC with Borland Applications

Borland Database Engine, Using Connector/ODBC with Borland Applications

reporting problems, Connector/ODBC Support

Connector/OpenOffice.org, Connectors and APIs

Connectors

MySQL, Connectors and APIs

connectstring (see MySQL Cluster)

connect_timeout system variable, Server System Variables

connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server

console option

mysqld, Server Command Options

const table

optimizer, Optimizing Queries with EXPLAIN, SELECT Syntax

constant table, WHERE Clause Optimization

constraints, How MySQL Deals with Constraints

CONSTRAINTS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

Contains(), Functions That Test Spatial Relationships Between Geometries

contributing companies

list of, Supporters of MySQL

contributors

list of, Contributors to MySQL

control flow functions, Control Flow Functions

CONV(), Mathematical Functions

conventions

syntax, Typographical and Syntax Conventions

typographical, Typographical and Syntax Conventions, Conventions Used in This Document

CONVERT, Cast Functions and Operators

CONVERT TO, ALTER TABLE Syntax

converting HEAP to MyISAM

thread state, General Thread States

CONVERT_TZ(), Date and Time Functions

ConvexHull(), Spatial Operators

copy option

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

copy to tmp table

thread state, General Thread States

copying databases, Copying MySQL Databases to Another Machine

copying tables, CREATE TABLE 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-size option

mysqld_safe, mysqld_safe — MySQL Server Startup Script

correct-checksum option

myisamchk, myisamchk Repair Options

correlated subqueries, Correlated Subqueries

COS(), Mathematical Functions

COT(), Mathematical Functions

count option

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(), GROUP BY (Aggregate) Functions

COUNT(DISTINCT), GROUP BY (Aggregate) Functions

counters

ndbinfo table, The ndbinfo counters Table

counting

table rows, Counting Rows

crash, Debugging a MySQL Server

recovery, Using myisamchk for Crash Recovery

repeated, What to Do If MySQL Keeps Crashing

replication, Replication and Master or Slave Shutdowns

crash-me, The MySQL Benchmark Suite

crash-me program, Designing Applications for Portability, The MySQL Benchmark Suite

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

CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax, CREATE FUNCTION Syntax

CREATE INDEX, CREATE INDEX Syntax

CREATE LOGFILE GROUP, CREATE LOGFILE GROUP Syntax

(see also MySQL Cluster Disk Data)

CREATE NODEGROUP command (MySQL Cluster), Commands in the MySQL Cluster Management Client

create option

mysqlslap, mysqlslap — Load Emulation Client

CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION Syntax

CREATE SCHEMA, CREATE DATABASE Syntax

CREATE SERVER, CREATE SERVER Syntax

CREATE TABLE, CREATE TABLE Syntax

DIRECTORY options

and replication, Replication and DIRECTORY Table Options

CREATE TABLE ... SELECT

and replication, Replication of CREATE TABLE ... SELECT Statements

CREATE TABLESPACE, CREATE TABLESPACE Syntax

(see also MySQL Cluster Disk Data)

CREATE TRIGGER, CREATE TRIGGER Syntax

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

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

schema, CREATE DATABASE Syntax

tables, Creating a Table

Creating delayed handler

thread state, Delayed-Insert Thread States

Creating index

thread state, General Thread States

Creating sort index

thread state, General Thread States

creating table

thread state, General Thread States

Creating table from master dump

thread state, Replication Slave Connection Thread States

Creating tmp table

thread state, General Thread States

creating user accounts, CREATE USER Syntax

CROSS JOIN, JOIN Syntax

Crosses(), Functions That Test Spatial Relationships Between Geometries

CR_SERVER_GONE_ERROR, MySQL server has gone away

CR_SERVER_LOST_ERROR, MySQL server has gone away

CSV data, reading, LOAD DATA INFILE Syntax, SELECT Syntax

csv option

mysqlslap, mysqlslap — Load Emulation Client

CSV storage engine, Storage Engines, The CSV Storage Engine

CURDATE(), Date and Time Functions

CURRENT_DATE, Date and Time Functions

CURRENT_TIME, Date and Time Functions

CURRENT_TIMESTAMP, Date and Time Functions

CURRENT_USER(), Information Functions

Cursors, Cursors

CURTIME(), Date and Time Functions

CXX environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

CXXFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

D
[index top]

Daemon

thread command, Thread Command Values

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, Make Your Data as Small as Possible

DATA DIRECTORY

and replication, Replication and DIRECTORY Table Options

data node (MySQL Cluster)

defined, MySQL Cluster Core Concepts

data nodes (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

Data truncation with CJK characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

data type

BIGINT, Overview of Numeric Types

BINARY, Overview of String Types, The BINARY and VARBINARY Types

BIT, Overview of Numeric Types

BLOB, Overview of String Types, The BLOB and TEXT Types

BOOL, Overview of Numeric Types, Using Data Types from Other Database Engines

BOOLEAN, Overview of Numeric Types, Using Data Types from Other Database Engines

CHAR, Overview of String Types, String Types

CHAR VARYING, Overview of String Types

CHARACTER, Overview of String Types

CHARACTER VARYING, Overview of String Types

DATE, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

DATETIME, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

DEC, Overview of Numeric Types

DECIMAL, Overview of Numeric Types, Precision Math

DOUBLE, Overview of Numeric Types

DOUBLE PRECISION, Overview of Numeric Types

ENUM, Overview of String Types, The ENUM Type

FIXED, Overview of Numeric Types

FLOAT, Overview of Numeric Types

GEOMETRY, MySQL Spatial Data Types

GEOMETRYCOLLECTION, MySQL Spatial Data Types

INT, Overview of Numeric Types

INTEGER, Overview of Numeric Types

LINESTRING, MySQL Spatial Data Types

LONG, The BLOB and TEXT Types

LONGBLOB, Overview of String Types

LONGTEXT, Overview of String Types

MEDIUMBLOB, Overview of String Types

MEDIUMINT, Overview of Numeric Types

MEDIUMTEXT, Overview of String Types

MULTILINESTRING, MySQL Spatial Data Types

MULTIPOINT, MySQL Spatial Data Types

MULTIPOLYGON, MySQL Spatial Data Types

NATIONAL CHAR, Overview of String Types

NATIONAL VARCHAR, Overview of String Types

NCHAR, Overview of String Types

NUMERIC, Overview of Numeric Types

NVARCHAR, Overview of String Types

POINT, MySQL Spatial Data Types

POLYGON, MySQL Spatial Data Types

REAL, Overview of Numeric Types

SET, Overview of String Types, The SET Type

SMALLINT, Overview of Numeric Types

TEXT, Overview of String Types, The BLOB and TEXT Types

TIME, Overview of Date and Time Types, The TIME Type

TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

TINYBLOB, Overview of String Types

TINYINT, Overview of Numeric Types

TINYTEXT, Overview of String Types

VARBINARY, Overview of String Types, The BINARY and VARBINARY Types

VARCHAR, Overview of String Types, String Types

VARCHARACTER, Overview of String Types

YEAR, Overview of Date and Time Types, The YEAR Type

data types, Data Types

C API, MySQL C API

overview, Data Type Overview

data-file-length option

myisamchk, myisamchk Repair Options

database

altering, ALTER DATABASE Syntax

creating, CREATE DATABASE Syntax

deleting, DROP DATABASE Syntax

Database information

obtaining, SHOW Syntax

database metadata, INFORMATION_SCHEMA Tables

database names

case sensitivity, Identifier Case Sensitivity

case-sensitivity, MySQL Extensions to Standard SQL

database option

mysql, mysql Options

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

ndb_show_tables, ndb_show_tables — Display List of NDB Tables

DATABASE(), Information Functions

databases

backups, Backup and Recovery

copying, Copying MySQL Databases to Another Machine

creating, Creating and Using a Database

defined, What is MySQL?

displaying, mysqlshow — Display Database, Table, and Column Information

dumping, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program

information about, Getting Information About Databases and Tables

names, Schema Object Names

replicating, Replication

selecting, Creating and Selecting a Database

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

DataDir, Defining a MySQL Cluster Management Server, Defining MySQL 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_install_db, mysql_install_db — Initialize MySQL Data Directory

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

datadir system variable, Server System Variables

DataJunction, Using Connector/ODBC with Pervasive Software DataJunction

DataMemory, Defining MySQL Cluster Data Nodes, Configuring MySQL Cluster Parameters for Local Checkpoints

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, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

date functions

Y2K compliance, Year 2000 Issues and Date Types

date types, Data Type Storage Requirements

Y2K issues, Year 2000 Issues and Date Types

date values, Date and Time Values

problems, The DATETIME, DATE, and TIMESTAMP Types

DATE(), Date and Time Functions

DATEDIFF(), Date and Time Functions

dates

used with partitioning, Partition Types

used with partitioning (examples), RANGE Partitioning, HASH Partitioning, Subpartitioning, Partition Pruning

DATETIME data type, Overview of Date and Time Types, The DATETIME, DATE, 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

DAYNAME(), Date and Time Functions

DAYOFMONTH(), Date and Time Functions

DAYOFWEEK(), Date and Time Functions

DAYOFYEAR(), Date and Time Functions

db option

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

db table

sorting, Access Control, Stage 2: Request Verification

DB2 SQL mode, Server SQL Modes

DBI interface, MySQL Perl API

DBI->quote, Strings

DBI->trace, Debugging mysqld under gdb

DBI/DBD interface, MySQL Perl API

DBI_TRACE environment variable, Environment Variables, Debugging mysqld under gdb

DBI_USER environment variable, Environment Variables

DBUG package, The DBUG Package

DEALLOCATE PREPARE, SQL Syntax for Prepared Statements, DEALLOCATE PREPARE Syntax

Debug

thread command, Thread Command Values

debug option

comp_err, comp_err — Compile MySQL Error Message File

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

myisamchk, myisamchk General Options

myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables

mysql, mysql Options

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

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

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

mysqlmanager, MySQL Instance Manager Command Options

mysqlshow, mysqlshow — Display Database, Table, and Column Information

mysqlslap, mysqlslap — Load Emulation Client

my_print_defaults, my_print_defaults — Display Options from Option Files

debug system variable, Server System Variables

debug-check option

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

mysqlshow, mysqlshow — Display Database, Table, and Column Information

mysqlslap, mysqlslap — Load Emulation Client

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

debug-info option

comp_err, comp_err — Compile MySQL Error Message File

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

mysqlshow, mysqlshow — Display Database, Table, and Column Information

mysqlslap, mysqlslap — Load Emulation Client

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

debug-sync-timeout option

mysqld, Server Command Options

debugging

client, Debugging a MySQL Client

server, Debugging a MySQL Server

debugging support, Typical configure Options

debug_sync system variable, Server System Variables

DEC data type, Overview of Numeric Types

decimal arithmetic, Precision Math

DECIMAL data type, Overview of Numeric Types, 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 Accounts

default host name, Connecting to the MySQL Server

default installation location, Installation Layouts

default options, Using Option Files

DEFAULT value clause, Data Type Default Values, CREATE TABLE Syntax

default values, MySQL Design Limitations and Tradeoffs, 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-character-set option

mysql, mysql Options

mysqladmin, mysqladmin — Client for Administering a MySQL Server

mysqlcheck, mysqlcheck — A Table Maintenance Program

mysqld, Server Command Options

mysqldump, mysqldump — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

mysqlshow, mysqlshow — Display Database, Table, and Column Information

default-collation option

mysqld, Server Command Options

default-mysqld-path option

mysqlmanager, MySQL Instance Manager Command Options

default-storage-engine option

mysqld, Server Command Options

default-table-type option

mysqld, Server Command Options

default-time-zone option

mysqld, Server Command Options

defaults

embedded, Options with the Embedded Server

defaults-extra-file option, Command-Line Options that Affect Option-File Handling

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

mysqld_safe, mysqld_safe — MySQL Server Startup Script

my_print_defaults, my_print_defaults — Display Options from Option Files

defaults-file option, Command-Line Options that Affect Option-File Handling

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

mysqld_safe, mysqld_safe — MySQL Server Startup Script

mysqlmanager, MySQL Instance Manager Command Options

my_print_defaults, my_print_defaults — Display Options from Option Files

defaults-group-suffix option, Command-Line Options that Affect Option-File Handling

my_print_defaults, my_print_defaults — Display Options from Option Files

default_week_format system variable, Server System Variables

DEGREES(), Mathematical Functions

delay-key-write option

mysqld, Server Command Options, MyISAM Startup Options

DELAYED, INSERT DELAYED Syntax

when ignored, INSERT Syntax

Delayed insert

thread command, Thread Command Values

delayed inserts

thread states, Delayed-Insert Thread States

delayed-insert option

mysqldump, mysqldump — A Database Backup Program

delayed_insert_limit, INSERT DELAYED Syntax

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 MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits

delete option

mysqlimport, mysqlimport — A Data Import Program

delete-master-logs option

mysqldump, mysqldump — A Database Backup Program

deleting

database, DROP DATABASE Syntax

foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints

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 Commands

delimiter option

mysql, mysql Options

mysqlslap, mysqlslap — Load Emulation Client

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

Delphi, Using Connector/ODBC with Delphi

derived tables, Subqueries in the FROM Clause

des-key-file option

mysqld, Server Command Options

DESC, DESCRIBE Syntax

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

limitations, MySQL Design Limitations and Tradeoffs

DES_DECRYPT(), Encryption and Compression Functions

DES_ENCRYPT(), Encryption and Compression Functions

detach option

mysqlslap, mysqlslap — Load Emulation Client

development of MySQL Cluster, MySQL Cluster Development History

development source tree, Installing from the Development Source Tree

Difference(), Spatial Operators

digits, Data Types

Dimension(), General Geometry Functions

directory structure

default, Installation Layouts

disable named command

mysql, mysql Options

disable-grant-options option

configure, Typical configure Options

disable-keys option

mysqldump, mysqldump — A Database Backup Program

disable-log-bin option

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

DISCARD TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces

discard_or_import_tablespace

thread state, General Thread States

disconnect-slave-event-count option

mysqld, Replication Slave Options and Variables

disconnecting

from the server, Connecting to and Disconnecting from the Server

Disjoint(), Functions That Test Spatial Relationships Between Geometries

Disk Data tables (MySQL Cluster) (see MySQL Cluster Disk Data)

disk full, How MySQL Handles a Full Disk

disk issues, Disk Issues

disk option

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

DiskCheckpointSpeed, Defining MySQL Cluster Data Nodes

DiskCheckpointSpeedInRestart, Defining MySQL Cluster Data Nodes

DiskIOThreadPool, Defining MySQL Cluster Data Nodes

Diskless, Defining MySQL Cluster Data Nodes

DiskPageBufferMemory, Defining MySQL Cluster Data Nodes

disks

splitting data across, Using Symbolic Links for Databases on Windows

DiskSyncSize, Defining MySQL Cluster Data Nodes

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 INDEX Syntax, SHOW OPEN TABLES Syntax, SHOW TABLES Syntax

table status, SHOW TABLE STATUS Syntax

Distance(), Functions That Test Spatial Relationships Between Geometries

DISTINCT, Selecting Particular Columns, DISTINCT Optimization, SELECT Syntax

AVG(), GROUP BY (Aggregate) Functions

COUNT(), GROUP BY (Aggregate) Functions

MAX(), GROUP BY (Aggregate) Functions

MIN(), GROUP BY (Aggregate) Functions

SUM(), GROUP BY (Aggregate) Functions

DISTINCTROW, SELECT Syntax

DIV, Arithmetic Operators

division (/), Arithmetic Operators

div_precision_increment system variable, Server System Variables

DNS, How MySQL Uses DNS

DO, DO Syntax

DocBook XML

documentation source format, About This Manual

Documentation

in Chinese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

in Japanese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

in Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Documenters

list of, Documenters and translators

DOUBLE data type, Overview of Numeric Types

DOUBLE PRECISION data type, Overview of Numeric Types

double quote (\"), Strings

downgrades

MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of a MySQL Cluster, MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility

downgrading, Upgrading or Downgrading MySQL, Downgrading MySQL

downloading, How to Get MySQL

drbd

FAQ, MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat, Distributed Replicated Block Device (DRBD)

DRBD license, Distributed Replicated Block Device (DRBD)

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, FOREIGN KEY Constraints

DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION Syntax, DROP FUNCTION Syntax

DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax

DROP LOGFILE GROUP, DROP LOGFILE GROUP Syntax

(see also MySQL Cluster Disk Data)

DROP NODEGROUP command (MySQL Cluster), Commands in the MySQL Cluster Management Client

DROP PREPARE, DEALLOCATE PREPARE Syntax

DROP PRIMARY KEY, ALTER TABLE Syntax

DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax

DROP SCHEMA, DROP DATABASE Syntax

DROP SERVER, DROP SERVER Syntax

DROP TABLE, DROP TABLE Syntax

and MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits

DROP TABLESPACE, DROP TABLESPACE Syntax

(see also MySQL Cluster Disk Data)

DROP TRIGGER, DROP TRIGGER Syntax

DROP USER, DROP USER Syntax

DROP VIEW, DROP VIEW Syntax

drop-user option

mysqlmanager, MySQL Instance Manager Command Options

dropping

user, Removing User Accounts, DROP USER Syntax

dryrun option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

DUAL, SELECT Syntax

dump option

myisam_ftdump, myisam_ftdump — Display Full-Text Index information

dump-date option

mysqldump, mysqldump — A Database Backup Program

DUMPFILE, SELECT Syntax

dumping

databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program

dynamic table characteristics, Dynamic Table Characteristics

E
[index top]

edit command

mysql, mysql Commands

edit-user option

mysqlmanager, MySQL Instance Manager Command Options

ego command

mysql, mysql Commands

Eiffel Wrapper, MySQL Eiffel Wrapper

ELT(), String Functions

email lists, MySQL Mailing Lists

embedded MySQL server library, libmysqld, the Embedded MySQL Server Library

embedded option

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

mysql_config, mysql_config — Get Compile Options for Compiling Clients

enable-community-features option

configure, Typical configure Options

enable-debug-sync option

configure, Typical configure Options

enable-named-pipe option

mysqld, Server Command Options

enable-profiling option

configure, Typical configure Options

enable-pstack option

mysqld, Server Command Options

enable-thread-safe-client option

configure, Typical configure Options

ENCODE(), Encryption and Compression Functions

ENCRYPT(), Encryption and Compression Functions

encryption, Basic SSL Concepts

encryption functions, Encryption and Compression Functions

end

thread state, General Thread States

END, BEGIN ... END Compound Statement Syntax

EndPoint(), LineString Functions

engine option

mysqlslap, mysqlslap — Load Emulation Client

ENGINES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ENGINES Table

engine_condition_pushdown system variable, Server System Variables

ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client

entering

queries, Entering Queries

ENUM

size, Data Type Storage Requirements

ENUM data type, Overview of String Types, The ENUM Type

Envelope(), General Geometry Functions

environment variable

CC, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

CXX, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

DBI_TRACE, Environment Variables, Debugging mysqld under gdb

DBI_USER, Environment Variables

HOME, Environment Variables, mysql Options

LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface

LD_RUN_PATH, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface

MYSQL_DEBUG, Environment Variables, Overview of MySQL Programs, Debugging a MySQL Client

MYSQL_GROUP_SUFFIX, Environment Variables

MYSQL_HISTFILE, Environment Variables, mysql Options

MYSQL_HOME, Environment Variables

MYSQL_HOST, Environment Variables, Connecting to the MySQL Server

MYSQL_PS1, Environment Variables

MYSQL_PWD, Environment Variables, Overview of MySQL Programs, Connecting to the MySQL Server

MYSQL_TCP_PORT, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment

MYSQL_UNIX_PORT, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment

PATH, Installing MySQL from Generic Binaries on Unix/Linux, Environment Variables, Invoking MySQL Programs

TMPDIR, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Where MySQL Stores Temporary Files

TZ, Environment Variables, Time Zone Problems

UMASK, Environment Variables, Problems with File Permissions

UMASK_DIR, Environment Variables, Problems with File Permissions

USER, Environment Variables, Connecting to the MySQL Server

environment variables, Overview of MySQL Programs, Setting Environment Variables, Causes of Access-Denied Errors

CXX, Dealing with Problems Compiling MySQL

list of, Environment Variables

equal (=), Comparison Functions and Operators

Equals(), Functions That Test Spatial Relationships Between Geometries

eq_ref join type

optimizer, Optimizing Queries with EXPLAIN

Errcode, perror — Explain Error Codes

errno, perror — Explain Error Codes

Error

thread command, Thread Command Values

ERROR Events (MySQL Cluster), MySQL Cluster Log Events

error logs (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon

error messages

can't find file, Problems with File Permissions

displaying, perror — Explain Error Codes

languages, Setting the Error Message Language

errors

access denied, Access denied

and replication, Slave Errors During Replication

checking tables for, How to Check MyISAM Tables for Errors

common, Problems and Common Errors

directory checksum, Installing MySQL on Solaris

handling for UDFs, UDF Return Values and Error Handling

in subqueries, Subquery Errors

known, Known Issues in MySQL

linking, Problems Linking to the MySQL Client Library

list of, Common Errors When Using MySQL Programs

lost connection, Lost connection to MySQL server

reporting, General Information, How to Report Bugs or Problems

sources of information, Sources of Error Information

error_count session variable, Server System Variables

ERROR_FOR_DIVISION_BY_ZERO SQL mode, Server SQL Modes

escape (\\), Strings

escape sequences

option files, Using Option Files

strings, Strings

estimating

query performance, Estimating Query Performance

event

restrictions, Restrictions on Stored Routines, Triggers, and Events

event groups, SET GLOBAL sql_slave_skip_counter Syntax

event log format (MySQL Cluster), MySQL Cluster Log Events

event logs (MySQL Cluster), Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands

event scheduler, Stored Programs and Views

thread states, Event Scheduler Thread States

Event Scheduler, Using the Event Scheduler

altering events, ALTER EVENT Syntax

and MySQL privileges, The Event Scheduler and MySQL Privileges

and mysqladmin debug, Event Scheduler Status

and replication, Replication of Invoked Features

and SHOW PROCESSLIST, Event Scheduler Configuration

concepts, Event Scheduler Overview

creating events, CREATE EVENT Syntax

dropping events, DROP EVENT Syntax

enabling and disabling, Event Scheduler Configuration

event metadata, Event Metadata

obtaining status information, SHOW SCHEDULER STATUS Syntax, Event Scheduler Status

SQL statements, Event Syntax

starting and stopping, Event Scheduler Configuration

time representation, Event Metadata

event severity levels (MySQL Cluster), MySQL Cluster Logging Management Commands

event types (MySQL Cluster), Event Reports Generated in MySQL Cluster, MySQL Cluster Log Events

event-scheduler option

mysqld, Server Command Options

events, Stored Programs and Views, Using the Event Scheduler

altering, ALTER EVENT Syntax

creating, CREATE EVENT Syntax

dropping, DROP EVENT Syntax

metadata, Event Metadata

status variables, The Event Scheduler and MySQL Privileges

EVENTS

INFORMATION_SCHEMA table, The Event Scheduler and MySQL Privileges, The INFORMATION_SCHEMA EVENTS Table

events option

mysqldump, mysqldump — A Database Backup Program

event_scheduler system variable, Server System Variables

exact-value literals, Precision Math

example option

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

EXAMPLE storage engine, Storage Engines, The EXAMPLE Storage Engine

examples

compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables

myisamchk output, myisamchk Table Information

queries, Examples of Common Queries

exe-suffix option

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

Execute

thread command, Thread Command Values

EXECUTE, SQL Syntax for Prepared Statements, EXECUTE Syntax

execute option

mysql, mysql Options

ExecuteOnComputer, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster

executing

thread state, General Thread States

executing SQL statements from text files, Using mysql in Batch Mode, Executing SQL Statements from a Text File

Execution of init_command

thread state, General Thread States

execution threads (MySQL Cluster), ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

EXISTS

with subqueries, Subqueries with EXISTS or NOT EXISTS

exit command

mysql, mysql Commands

EXIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client

EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client

exit-info option

mysqld, Server Command Options

EXP(), Mathematical Functions

expire_logs_days system variable, Server System Variables

EXPLAIN, Optimizing Queries with EXPLAIN, EXPLAIN Syntax

EXPLAIN PARTITIONS, Obtaining Information About Partitions

EXPLAIN used with partitioned tables, Obtaining Information About Partitions

explicit default values, Data Type Default Values

EXPORT_SET(), String Functions

expression aliases, GROUP BY and HAVING with Hidden Columns, SELECT Syntax

expressions

extended, Pattern Matching

extend-check option

myisamchk, myisamchk Check Options, myisamchk Repair Options

extended option

mysqlcheck, mysqlcheck — A Table Maintenance Program

extended-insert option

mysqldump, mysqldump — A Database Backup Program

extensions

to standard SQL, MySQL Standards Compliance

ExteriorRing(), Polygon Functions

external locking, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States

external-locking option

mysqld, Server Command Options

extra-file option

my_print_defaults, my_print_defaults — Display Options from Option Files

extra-node-info option

ndb_desc, ndb_desc — Describe NDB Tables

extra-partition-info option

ndb_desc, ndb_desc — Describe NDB Tables

EXTRACT(), Date and Time Functions

extracting

dates, Date Calculations

ExtractValue(), XML Functions

F
[index top]

failover

in MySQL Cluster replication, Implementing Failover with MySQL Cluster Replication

Java clients, MySQL Cluster Core Concepts

FALSE, Numbers, Boolean Values

testing for, Comparison Functions and Operators

fast option

myisamchk, myisamchk Check Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

fatal signal 11, Dealing with Problems Compiling MySQL

features of MySQL, The Main Features of MySQL

FEDERATED storage engine, Storage Engines, The FEDERATED Storage Engine

Fetch

thread command, Thread Command Values

FETCH, Cursor FETCH Statement

field

changing, ALTER TABLE Syntax

Field List

thread command, Thread Command Values

FIELD(), String Functions

fields option

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

fields-enclosed-by option

mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

fields-escaped-by option

mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

fields-optionally-enclosed-by option

mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

fields-terminated-by option

mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

FILE, String Functions

files

binary log, The Binary Log

config.cache, Dealing with Problems Compiling MySQL

error messages, Setting the Error Message Language

general query log, The General Query Log

log, Typical configure Options, Server Log Maintenance

my.cnf, Replication Features and Issues

not found message, Problems with File Permissions

permissions, Problems with File Permissions

repairing, myisamchk Repair Options

script, Using mysql in Batch Mode

size limits, The table is full

slow query log, The Slow Query Log

text, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program

tmp, Problems Running mysql_install_db

FILES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA FILES Table

(see also MySQL Cluster Disk Data)

filesort optimization, ORDER BY Optimization

FileSystemPath, Defining MySQL Cluster Data Nodes

FileSystemPathDataFiles, Defining MySQL Cluster Data Nodes

FileSystemPathDD, Defining MySQL Cluster Data Nodes

FileSystemPathUndoFiles, Defining MySQL Cluster Data Nodes

FIND_IN_SET(), String Functions

Finished reading one binlog; switching to next binlog

thread state, Replication Master Thread States

firewalls (software)

and MySQL Cluster, MySQL Cluster Security and Networking Issues

first-slave option

mysqldump, mysqldump — A Database Backup Program

fix-db-names option

mysqlcheck, mysqlcheck — A Table Maintenance Program

fix-table-names option

mysqlcheck, mysqlcheck — A Table Maintenance Program

FIXED data type, Overview of Numeric Types

fixed-point arithmetic, Precision Math

FLOAT data type, Overview of Numeric Types

floating-point number, Overview of Numeric Types

floating-point values

and replication, Replication and Floating-Point Values

floats, Numbers

FLOOR(), Mathematical Functions

FLUSH, FLUSH Syntax

and replication, Replication and FLUSH

flush option

mysqld, Server Command Options

flush system variable, Server System Variables

flush tables, mysqladmin — Client for Administering a MySQL Server

flush-logs option

mysqldump, mysqldump — A Database Backup Program

flush-privileges option

mysqldump, mysqldump — A Database Backup Program

Flushing tables

thread state, General Thread States

flushlog option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

flush_time system variable, Server System Variables

FOR UPDATE, SELECT Syntax

FORCE INDEX, Index Hint Syntax, Optimizer-Related Issues

FORCE KEY, Index Hint Syntax

force option

myisamchk, myisamchk Check Options, myisamchk Repair Options

myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables

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

mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

force-read option

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

foreign key

constraint, PRIMARY KEY and UNIQUE Index Constraints

deleting, ALTER TABLE Syntax, FOREIGN KEY Constraints

foreign keys, Foreign Keys, Using Foreign Keys, ALTER TABLE Syntax

foreign_key_checks session variable, Server System Variables

FORMAT(), String Functions

Forums, MySQL Community Support at the MySQL Forums

FOUND_ROWS(), Information Functions

FragmentLogFileSize, Defining MySQL Cluster Data Nodes

FreeBSD troubleshooting, Dealing with Problems Compiling MySQL

freeing items

thread state, General Thread States

frequently-asked questions about DRBD, MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat, Distributed Replicated Block Device (DRBD)

frequently-asked questions about MySQL Cluster, MySQL 5.1 FAQ: MySQL Cluster

FROM, SELECT Syntax

FROM_DAYS(), Date and Time Functions

FROM_UNIXTIME(), Date and Time Functions

ft_boolean_syntax system variable, Server System Variables

ft_max_word_len myisamchk variable, myisamchk General Options

ft_max_word_len system variable, Server System Variables

ft_min_word_len myisamchk variable, myisamchk General Options

ft_min_word_len system variable, Server System Variables

ft_query_expansion_limit system variable, Server System Variables

ft_stopword_file myisamchk variable, myisamchk General Options

ft_stopword_file system variable, Server System Variables

full disk, How MySQL Handles a Full Disk

full-text search, Full-Text Search Functions

FULLTEXT, Full-Text Search Functions

fulltext

stopword list, Fine-Tuning MySQL Full-Text Search

FULLTEXT initialization

thread state, General Thread States

fulltext join type

optimizer, Optimizing Queries with EXPLAIN

function

creating, CREATE FUNCTION Syntax

deleting, DROP FUNCTION Syntax

function names

parsing, Function Name Parsing and Resolution

resolving ambiguity, Function Name Parsing and Resolution

functions, Functions and Operators

and replication, Replication and System Functions

arithmetic, Bit Functions

bit, Bit Functions

C API, C API Function Overview

C prepared statement API, C API Prepared Statement Type Conversions, C API Prepared Statement Function Overview

cast, Cast Functions and Operators

control flow, Control Flow Functions

date and time, Date and Time Functions

encryption, Encryption and Compression Functions

GROUP BY, GROUP BY (Aggregate) Functions

grouping, Operator Precedence

information, Information Functions

mathematical, Mathematical Functions

miscellaneous, Miscellaneous Functions

native

adding, Adding a New Native Function

new, Adding New Functions to MySQL

stored, Using Stored Routines (Procedures and Functions)

string, String Functions

string comparison, String Comparison Functions

user-defined, Adding New Functions to MySQL

adding, Adding a New User-Defined Function

Functions

user-defined, CREATE FUNCTION Syntax, DROP FUNCTION Syntax

functions for SELECT and WHERE clauses, Functions and Operators

G
[index top]

gap event, Known Issues in MySQL Cluster Replication

gap lock

InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking

gb2312, gbk, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

gcc, Typical configure Options

gci option

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

GCP Stop errors (MySQL Cluster), Defining MySQL Cluster Data Nodes

gdb

using, Debugging mysqld under gdb

gdb option

mysqld, Server Command Options

general information, General Information

General Public License, What is MySQL?

general query log, The General Query Log

general-log option

mysqld, Server Command Options

general_log system variable, Server System Variables

general_log_file system variable, Server System Variables

geographic feature, Introduction to MySQL Spatial Support

GeomCollFromText(), Creating Geometry Values Using WKT Functions

GeomCollFromWKB(), Creating Geometry Values Using WKB Functions

geometry, Introduction to MySQL Spatial Support

GEOMETRY data type, MySQL Spatial Data Types

GEOMETRYCOLLECTION data type, MySQL Spatial Data Types

GeometryCollection(), Creating Geometry Values Using MySQL-Specific Functions

GeometryCollectionFromText(), Creating Geometry Values Using WKT Functions

GeometryCollectionFromWKB(), Creating Geometry Values Using WKB Functions

GeometryFromText(), Creating Geometry Values Using WKT Functions

GeometryFromWKB(), Creating Geometry Values Using WKB Functions

GeometryN(), GeometryCollection Functions

GeometryType(), General Geometry Functions

GeomFromText(), Creating Geometry Values Using WKT Functions, Geometry Format Conversion Functions

GeomFromWKB(), Creating Geometry Values Using WKB Functions, Geometry Format Conversion Functions

geospatial feature, Introduction to MySQL Spatial Support

getting MySQL, How to Get MySQL

GET_FORMAT(), Date and Time Functions

GET_LOCK(), Miscellaneous Functions

GIS, Spatial Extensions, Introduction to MySQL Spatial Support

GLength(), LineString Functions, MultiLineString Functions

global privileges, GRANT Syntax, REVOKE Syntax

GLOBAL_STATUS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables

GLOBAL_VARIABLES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables

go command

mysql, mysql Commands

goals of MySQL, What is MySQL?

got handler lock

thread state, Delayed-Insert Thread States

got old table

thread state, Delayed-Insert Thread States

GRANT, GRANT Syntax

GRANT statement, Adding User Accounts

grant tables

re-creating, Problems Running mysql_install_db

sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification

structure, Privilege System Grant Tables

upgrading, mysql_fix_privilege_tables — Upgrade MySQL System Tables

granting

privileges, GRANT Syntax

GRANTS, SHOW GRANTS Syntax

greater than (>), Comparison Functions and Operators

greater than or equal (>=), Comparison Functions and Operators

greatest timestamp wins (conflict resolution), MySQL Cluster Replication Conflict Resolution

greatest timestamp, delete wins (conflict resolution), MySQL Cluster Replication Conflict Resolution

GREATEST(), Comparison Functions and Operators

GROUP BY, GROUP BY Optimization

aliases in, GROUP BY and HAVING with Hidden Columns

extensions to standard SQL, GROUP BY and HAVING with Hidden Columns, SELECT Syntax

GROUP BY functions, GROUP BY (Aggregate) Functions

grouping

expressions, Operator Precedence

GROUP_CONCAT(), GROUP BY (Aggregate) Functions

group_concat_max_len system variable, Server System Variables

H
[index top]

HANDLER, HANDLER Syntax

Handlers, DECLARE for Handlers

handling

errors, UDF Return Values and Error Handling

Has read all relay log; waiting for the slave I/O thread to update it

thread state, Replication Slave SQL Thread States

Has sent all binlog to slave; waiting for binlog to be updated

thread state, Replication Master Thread States

hash partitioning, HASH Partitioning

hash partitions

managing, Management of HASH and KEY Partitions

splitting and merging, Management of HASH and KEY Partitions

have_archive system variable, Server System Variables

have_blackhole_engine system variable, Server System Variables

have_community_features system variable, Server System Variables

have_compress system variable, Server System Variables

have_crypt system variable, Server System Variables

have_csv system variable, Server System Variables

have_dynamic_loading system variable, Server System Variables

have_example_engine system variable, Server System Variables

have_federated_engine system variable, Server System Variables

have_geometry system variable, Server System Variables

have_innodb system variable, Server System Variables

have_isam system variable, Server System Variables

have_merge_engine system variable, Server System Variables

have_openssl system variable, Server System Variables

have_partitioning system variable, Server System Variables

have_query_cache system variable, Server System Variables

have_raid system variable, Server System Variables

have_row_based_replication system variable, Server System Variables

have_rtree_keys system variable, Server System Variables

have_ssl system variable, Server System Variables

have_symlink system variable, Server System Variables

HAVING, SELECT Syntax

header option

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

header_file option

comp_err, comp_err — Compile MySQL Error Message File

HEAP storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine

HeartbeatIntervalDbApi, Defining MySQL Cluster Data Nodes

HeartbeatIntervalDbDb, Defining MySQL Cluster Data Nodes

HeartbeatThreadPriority, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster

help command

mysql, mysql Commands

HELP command (MySQL Cluster), Commands in the MySQL Cluster Management Client

help option

comp_err, comp_err — Compile MySQL Error Message File

myisamchk, myisamchk General Options

myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables

myisam_ftdump, myisam_ftdump — Display Full-Text Index information

mysql, mysql Options

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

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

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

mysqld_safe, mysqld_safe — MySQL Server Startup Script

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

mysqlmanager, MySQL Instance Manager Command Options

mysqlshow, mysqlshow — Display Database, Table, and Column Information

mysqlslap, mysqlslap — Load Emulation Client

mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine

mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files

mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination

my_print_defaults, my_print_defaults — Display Options from Option Files

perror, perror — Explain Error Codes

resolveip, resolveip — Resolve Host name to IP Address or Vice Versa

resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols

HELP option

myisamchk, myisamchk General Options

HELP statement, HELP Syntax

HEX(), String Functions, Mathematical Functions

hex-blob option

mysqldump, mysqldump — A Database Backup Program

hexadecimal values, Hexadecimal Values

hexdump option

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

HIGH_NOT_PRECEDENCE SQL mode, Server SQL Modes

HIGH_PRIORITY, SELECT Syntax

hints, MySQL Extensions to Standard SQL

index, SELECT Syntax, Index Hint Syntax

history of MySQL, History of MySQL

HOME environment variable, Environment Variables, mysql Options

host name

default, Connecting to the MySQL Server

host name caching, How MySQL Uses DNS

host name resolution, How MySQL Uses DNS

host option, Connecting to the MySQL Server

mysql, mysql Options

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

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

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

mysqlshow, mysqlshow — Display Database, Table, and Column Information

mysqlslap, mysqlslap — Load Emulation Client

mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine

mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

host table, Access Control, Stage 2: Request Verification

sorting, Access Control, Stage 2: Request Verification

Host*SciId* parameters, SCI Transport Connections in MySQL Cluster

host.frm

problems finding, Unix Post-Installation Procedures

HostName, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster

HostName (MySQL Cluster), MySQL Cluster Security and Networking Issues

hostname system variable, Server System Variables

HOUR(), Date and Time Functions

howto option

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

html option

mysql, mysql Options

I
[index top]

i-am-a-dummy option

mysql, mysql Options

i5/OS, Installing MySQL on i5/OS

IBM i5/OS, Installing MySQL on i5/OS

IBMDB2I storage engine, Storage Engines

icc

and MySQL Cluster support>, Debugging and Porting MySQL

MySQL builds, Compiler-Specific Build Characteristics

Id, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster

ID

unique, How to Get the Unique ID for the Last Inserted Row

id option

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

identifiers, Schema Object Names

case sensitivity, Identifier Case Sensitivity

quoting, Schema Object Names

identity session variable, Server System Variables

IF, IF Statement

IF(), Control Flow Functions

IFNULL(), Control Flow Functions

IGNORE

with partitioned tables, INSERT Syntax

IGNORE INDEX, Index Hint Syntax

IGNORE KEY, Index Hint Syntax

ignore option

mysqlimport, mysqlimport — A Data Import Program

ignore-builtin-innodb option

mysqld, InnoDB Startup Options and System Variables

ignore-lines option

mysqlimport, mysqlimport — A Data Import Program

ignore-spaces option

mysql, mysql Options

ignore-table option

mysqldump, mysqldump — A Database Backup Program

IGNORE_SPACE SQL mode, Server SQL Modes

implicit default values, Data Type Default Values

IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces

importing

data, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program

IN, Comparison Functions and Operators, Subqueries with ANY, IN, or SOME

include option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

increasing

performance, Replication FAQ

increasing with replication

speed, Replication

incremental recovery, Point-in-Time (Incremental) Recovery Using the Binary Log

using MySQL Cluster replication, Point-In-Time Recovery Using MySQL Cluster Replication

index

deleting, ALTER TABLE Syntax, DROP INDEX Syntax

rebuilding, Rebuilding or Repairing Tables or Indexes

INDEX DIRECTORY

and replication, Replication and DIRECTORY Table Options

index hints, SELECT Syntax, Index Hint Syntax

index join type

optimizer, Optimizing Queries with EXPLAIN

index-record lock

InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking

indexes, CREATE INDEX Syntax

and BLOB columns, Column Indexes, CREATE TABLE Syntax

and IS NULL, How MySQL Uses Indexes

and LIKE, How MySQL Uses Indexes

and NULL values, CREATE TABLE Syntax

and TEXT columns, Column Indexes, CREATE TABLE Syntax

assigning to key cache, CACHE INDEX Syntax

block size, Server System Variables

columns, Column Indexes

leftmost prefix of, How MySQL Uses Indexes

multi-column, Multiple-Column Indexes

multiple-part, CREATE INDEX Syntax

names, Schema Object Names

use of, How MySQL Uses Indexes

IndexMemory, Defining MySQL Cluster Data Nodes, Configuring MySQL Cluster Parameters for Local Checkpoints

index_merge join type

optimizer, Optimizing Queries with EXPLAIN

index_subquery join type

optimizer, Optimizing Queries with EXPLAIN

INET_ATON(), Miscellaneous Functions

INET_NTOA(), Miscellaneous Functions

INFO Events (MySQL Cluster), MySQL Cluster Log Events

information functions, Information Functions

information option

myisamchk, myisamchk Check Options

INFORMATION_SCHEMA, INFORMATION_SCHEMA Tables

and security issues, MySQL Cluster and MySQL Privileges

collation and searching, Collation and INFORMATION_SCHEMA Searches

INFORMATION_SCHEMA.ENGINES table

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

INFORMATION_SCHEMA.GLOBAL_STATUS table

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

INFORMATION_SCHEMA.GLOBAL_VARIABLES table

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

init

thread state, General Thread States

Init DB

thread command, Thread Command Values

init-file option

mysqld, Server Command Options

InitFragmentLogFiles, Defining MySQL Cluster Data Nodes

Initialized

thread state, Event Scheduler Thread States

InitialLogFileGroup, Defining MySQL Cluster Data Nodes

InitialNoOfOpenFiles, Defining MySQL Cluster Data Nodes

InitialTablespace, Defining MySQL Cluster Data Nodes

init_connect system variable, Server System Variables

init_file system variable, Server System Variables

init_slave system variable, Replication Slave Options and Variables

INNER JOIN, JOIN Syntax

innochecksum, Overview of MySQL Programs, innochecksum — Offline InnoDB File Checksum Utility

InnoDB, The InnoDB Storage Engine

backups, Backing Up and Recovering an InnoDB Database

clustered index, Clustered and Secondary Indexes

gap lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking

index-record lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking

Monitors, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations

next-key lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking

NFS, InnoDB Configuration, Restrictions on InnoDB Tables

page size, Physical Structure of an Index, Restrictions on InnoDB Tables

record-level locks, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking

secondary index, Clustered and Secondary Indexes

semi-consistent read, InnoDB Startup Options and System Variables

Solaris 10 x86_64 issues, Installing MySQL on Solaris

transaction isolation levels, The InnoDB Transaction Model and Locking

InnoDB buffer pool, The InnoDB Buffer Pool

innodb option

mysqld, InnoDB Startup Options and System Variables

InnoDB storage engine, Storage Engines, The InnoDB Storage Engine

InnoDB tables, Transactions and Atomic Operations

innodb-status-file option

mysqld, InnoDB Startup Options and System Variables

INSERT, Speed of INSERT Statements, INSERT Syntax

insert

thread state, Delayed-Insert Thread States

INSERT ... SELECT, INSERT ... SELECT Syntax

INSERT DELAYED, INSERT DELAYED Syntax

INSERT statement

grant privileges, Adding User Accounts

INSERT(), String Functions

insert-ignore option

mysqldump, mysqldump — A Database Backup Program

insertable views

insertable, Updatable and Insertable Views

inserting

speed of, Speed of INSERT Statements

inserts

concurrent, Internal Locking Methods, Concurrent Inserts

insert_id session variable, Server System Variables

install option

mysqlmanager, MySQL Instance Manager Command Options

INSTALL PLUGIN, INSTALL PLUGIN Syntax

installation layouts, Installation Layouts

installation overview, MySQL Installation Using a Source Distribution

installing

binary distribution, Installing MySQL from Generic Binaries on Unix/Linux

Linux RPM packages, Installing MySQL from RPM Packages on Linux

Mac OS X PKG packages, Installing MySQL on Mac OS X

overview, Installing and Upgrading MySQL

Perl, Perl Installation Notes

Perl on Windows, Installing ActiveState Perl on Windows

Solaris PKG packages, Installing MySQL on Solaris

source distribution, MySQL Installation Using a Source Distribution

user-defined functions, Compiling and Installing User-Defined Functions

installing MySQL Cluster, MySQL Cluster Multi-Computer How-To, MySQL Cluster Multi-Computer Installation

installing plugins, Installing and Uninstalling Plugins, INSTALL PLUGIN Syntax

INSTR(), String Functions

INT data type, Overview of Numeric Types

integer arithmetic, Precision Math

INTEGER data type, Overview of Numeric Types

integers, Numbers

interactive_timeout system variable, Server System Variables

InteriorRingN(), Polygon Functions

internal compiler errors, Dealing with Problems Compiling MySQL

internal locking, Internal Locking Methods

internals, MySQL Internals

internationalization, Internationalization and Localization

Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC)

Intersection(), Spatial Operators

Intersects(), Functions That Test Spatial Relationships Between Geometries

INTERVAL(), Comparison Functions and Operators

introducer

string literal, Strings, Character String Literal Character Set and Collation

invalid data

constraint, Constraints on Invalid Data

invalidating query cache entries

thread state, Query Cache Thread States

in_file option

comp_err, comp_err — Compile MySQL Error Message File

IRC, MySQL Community Support on Internet Relay Chat (IRC)

IS boolean_value, Comparison Functions and Operators

IS NOT boolean_value, Comparison Functions and Operators

IS NOT NULL, Comparison Functions and Operators

IS NULL, IS NULL Optimization, Comparison Functions and Operators

and indexes, How MySQL Uses Indexes

isamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents

IsClosed(), MultiLineString Functions

IsEmpty(), General Geometry Functions

ISNULL(), Comparison Functions and Operators

ISOLATION LEVEL, SET TRANSACTION Syntax

IsRing(), LineString Functions

IsSimple(), General Geometry Functions

IS_FREE_LOCK(), Miscellaneous Functions

IS_USED_LOCK(), Miscellaneous Functions

ITERATE, ITERATE Statement

iterations option

mysqlslap, mysqlslap — Load Emulation Client

J
[index top]

Japanese character sets

conversion, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Japanese, Korean, Chinese character sets

frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

jdbc:mysql:loadbalance://, MySQL Cluster Core Concepts

join

nested-loop algorithm, Nested Join Optimization

JOIN, JOIN Syntax

join algorithm

Block Nested-Loop, Nested-Loop Join Algorithms

Nested-Loop, Nested-Loop Join Algorithms

join option

myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables

join type

ALL, Optimizing Queries with EXPLAIN

const, Optimizing Queries with EXPLAIN

eq_ref, Optimizing Queries with EXPLAIN

fulltext, Optimizing Queries with EXPLAIN

index, Optimizing Queries with EXPLAIN

index_merge, Optimizing Queries with EXPLAIN

index_subquery, Optimizing Queries with EXPLAIN

range, Optimizing Queries with EXPLAIN

ref, Optimizing Queries with EXPLAIN

ref_or_null, Optimizing Queries with EXPLAIN

system, Optimizing Queries with EXPLAIN

unique_subquery, Optimizing Queries with EXPLAIN

join_buffer_size system variable, Server System Variables

K
[index top]

keepold option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

keep_files_on_create system variable, Server System Variables

Key cache

MyISAM, The MyISAM Key Cache

key cache

assigning indexes to, CACHE INDEX Syntax

key partitioning, KEY Partitioning

key partitions

managing, Management of HASH and KEY Partitions

splitting and merging, Management of HASH and KEY Partitions

key space

MyISAM, Space Needed for Keys

keys, Column Indexes

foreign, Foreign Keys, Using Foreign Keys

multi-column, Multiple-Column Indexes

searching on two, Searching on Two Keys

keys option

mysqlshow, mysqlshow — Display Database, Table, and Column Information

keys-used option

myisamchk, myisamchk Repair Options

keywords, Reserved Words

key_buffer_size myisamchk variable, myisamchk General Options

key_buffer_size system variable, Server System Variables

key_cache_age_threshold system variable, Server System Variables

key_cache_block_size system variable, Server System Variables

key_cache_division_limit system variable, Server System Variables

KEY_COLUMN_USAGE

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table

Kill

thread command, Thread Command Values

KILL, KILL Syntax

Killed

thread state, General Thread States

Killing slave

thread state, Replication Slave Connection Thread States

known errors, Known Issues in MySQL

Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Korean, Chinese, Japanese character sets

frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

L
[index top]

language option

mysqld, Server Command Options

language support

error messages, Setting the Error Message Language

language system variable, Server System Variables

large page support, Enabling Large Page Support

large-pages option

mysqld, Server Command Options

large_files_support system variable, Server System Variables

large_pages system variable, Server System Variables

large_page_size system variable, Server System Variables

last row

unique ID, How to Get the Unique ID for the Last Inserted Row

LAST_DAY(), Date and Time Functions

last_insert_id session variable, Server System Variables

LAST_INSERT_ID(), Transactions and Atomic Operations, INSERT Syntax

and replication, Replication and AUTO_INCREMENT

LAST_INSERT_ID() and stored routines, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

LAST_INSERT_ID() and triggers, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

LAST_INSERT_ID([<replaceable>expr</replaceable>]), Information Functions

layout of installation, Installation Layouts

LCASE(), String Functions

lc_time_names system variable, Server System Variables

ldata option

mysql_install_db, mysql_install_db — Initialize MySQL Data Directory

LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD Interface

LD_RUN_PATH environment variable, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface

LEAST(), Comparison Functions and Operators

LEAVE, LEAVE Statement

ledir option

mysqld_safe, mysqld_safe — MySQL Server Startup Script

LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization, JOIN Syntax

LEFT OUTER JOIN, JOIN Syntax

LEFT(), String Functions

leftmost prefix of indexes, How MySQL Uses Indexes

legal names, Schema Object Names

length option

myisam_ftdump, myisam_ftdump — Display Full-Text Index information

LENGTH(), String Functions

less than (<), Comparison Functions and Operators

less than or equal (<=), Comparison Functions and Operators

libmysqld, libmysqld, the Embedded MySQL Server Library

options, Options with the Embedded Server

libmysqld-libs option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

library

mysqlclient, Connectors and APIs

mysqld, Connectors and APIs

libs option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

libs_r option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

license system variable, Server System Variables

LIKE, String Comparison Functions

and indexes, How MySQL Uses Indexes

and wildcards, How MySQL Uses Indexes

LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax

and replication, Replication and LIMIT

limitations

design, MySQL Design Limitations and Tradeoffs

MySQL Limitations, Limits in MySQL

replication, Replication Features and Issues

limitations of MySQL Cluster, Known Limitations of MySQL Cluster

limits

file-size, The table is full

MySQL Limits, limits in MySQL, Limits in MySQL

line-numbers option

mysql, mysql Options

linear hash partitioning, LINEAR HASH Partitioning

linear key partitioning, KEY Partitioning

linefeed (\n), Strings, LOAD DATA INFILE Syntax

LineFromText(), Creating Geometry Values Using WKT Functions

LineFromWKB(), Creating Geometry Values Using WKB Functions

lines-terminated-by option

mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

LINESTRING data type, MySQL Spatial Data Types

LineString(), Creating Geometry Values Using MySQL-Specific Functions

LineStringFromText(), Creating Geometry Values Using WKT Functions

LineStringFromWKB(), Creating Geometry Values Using WKB Functions

linking, Building Client Programs

errors, Problems Linking to the MySQL Client Library

problems, Problems Linking with the C API

speed, How Compiling and Linking Affects the Speed of MySQL

links

symbolic, Using Symbolic Links

list partitioning, LIST Partitioning

list partitions

adding and dropping, Management of RANGE and LIST Partitions

managing, Management of RANGE and LIST Partitions

list-users option

mysqlmanager, MySQL Instance Manager Command Options

literals, Literal Values

LN(), Mathematical Functions

LOAD DATA

and replication, Replication and LOAD DATA INFILE

LOAD DATA FROM MASTER, LOAD DATA FROM MASTER Syntax

LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values

load emulation, mysqlslap — Load Emulation Client

LOAD INDEX INTO CACHE

and partitioning, Restrictions and Limitations on Partitioning

LOAD TABLE FROM MASTER, LOAD TABLE tbl_name FROM MASTER Syntax

loading

tables, Loading Data into a Table

LOAD_FILE(), String Functions

local checkpoints (MySQL Cluster), Configuring MySQL Cluster Parameters for Local Checkpoints

local option

mysqlimport, mysqlimport — A Data Import Program

local-infile option

mysql, mysql Options

mysqld, Security-Related mysqld Options

local-load option

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

localization, Internationalization and Localization

localstatedir option

configure, Typical configure Options

LOCALTIME, Date and Time Functions

LOCALTIMESTAMP, Date and Time Functions

local_infile system variable, Server System Variables

LOCATE(), String Functions

LOCK IN SHARE MODE, SELECT Syntax

Lock Monitor

InnoDB, SHOW ENGINE INNODB STATUS and the InnoDB Monitors

lock option

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax

lock-all-tables option

mysqldump, mysqldump — A Database Backup Program

lock-directory option

mysqlslap, mysqlslap — Load Emulation Client

lock-tables option

mysqldump, mysqldump — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

Locked

thread state, General Thread States

locked_in_memory system variable, Server System Variables

LockExecuteThreadToCPU, Defining MySQL Cluster Data Nodes

locking, System Factors and Startup Parameter Tuning

external, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States

internal, Internal Locking Methods

row-level, Transactions and Atomic Operations, Internal Locking Methods

table-level, Internal Locking Methods

locking methods, Internal Locking Methods

LockMaintThreadsToCPU, Defining MySQL Cluster Data Nodes

LockPagesInMainMemory, Defining MySQL Cluster Data Nodes

log

changes, MySQL Change History

log files, Typical configure Options

maintaining, Server Log Maintenance

log files (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon

ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

log option

mysqld, Server Command Options

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

mysqlmanager, MySQL Instance Manager Command Options

log system variable, Server System Variables

LOG(), Mathematical Functions

log-bin option

mysqld, Binary Log Options and Variables

log-bin-index option

mysqld, Binary Log Options and Variables

log-bin-trust-function-creators option

mysqld, Binary Log Options and Variables

log-error option

mysqld, Server Command Options

mysqldump, mysqldump — A Database Backup Program

mysqld_safe, mysqld_safe — MySQL Server Startup Script

log-isam option

mysqld, Server Command Options

log-long-format option

mysqld, Server Command Options

log-output option

mysqld, Server Command Options

log-queries-not-using-indexes option

mysqld, Server Command Options

log-short-format option

mysqld, Server Command Options

log-slave-updates option

mysqld, Replication Slave Options and Variables

log-slow-admin-statements option

mysqld, Server Command Options

log-slow-queries option

mysqld, Server Command Options

log-slow-slave-statements option

mysqld, Replication Slave Options and Variables

log-tc option

mysqld, Server Command Options

log-tc-size option

mysqld, Server Command Options

log-warnings option

mysqld, Server Command Options, Replication Slave Options and Variables

LOG10(), Mathematical Functions

LOG2(), Mathematical Functions

logbuffers

ndbinfo table, The ndbinfo logbuffers Table

LogDestination, Defining a MySQL Cluster Management Server

logging commands (MySQL Cluster), MySQL Cluster Logging Management Commands

logging slow query

thread state, General Thread States

logical operators, Logical Operators

login

thread state, General Thread States

LogLevelCheckpoint, Defining MySQL Cluster Data Nodes

LogLevelCongestion, Defining MySQL Cluster Data Nodes

LogLevelConnection, Defining MySQL Cluster Data Nodes

LogLevelError, Defining MySQL Cluster Data Nodes

LogLevelInfo, Defining MySQL Cluster Data Nodes

LogLevelNodeRestart, Defining MySQL Cluster Data Nodes

LogLevelShutdown, Defining MySQL Cluster Data Nodes

LogLevelStartup, Defining MySQL Cluster Data Nodes

LogLevelStatistic, Defining MySQL Cluster Data Nodes

logs

flushing, MySQL Server Logs

server, MySQL Server Logs

logspaces

ndbinfo table, The ndbinfo logspaces Table

log_bin system variable, Server System Variables

log_bin_trust_function_creators system variable, Server System Variables

log_error system variable, Server System Variables

log_output system variable, Server System Variables

log_queries_not_using_indexes system variable, Server System Variables

log_slave_updates system variable, Server System Variables

log_slow_queries system variable, Server System Variables

log_warnings system variable, Server System Variables

Long Data

thread command, Thread Command Values

LONG data type, The BLOB and TEXT Types

LONGBLOB data type, Overview of String Types

LongMessageBuffer, Defining MySQL Cluster Data Nodes

LONGTEXT data type, Overview of String Types

long_query_time system variable, Server System Variables

LOOP, LOOP Statement

loops option

ndb_show_tables, ndb_show_tables — Display List of NDB Tables

lost connection errors, Lost connection to MySQL server

low-priority option

mysqlimport, mysqlimport — A Data Import Program

low-priority-updates option

mysqld, Server Command Options

LOWER(), String Functions

lower_case_file_system system variable, Server System Variables

lower_case_table_names system variable, Server System Variables

low_priority_updates system variable, Server System Variables

LPAD(), String Functions

LTRIM(), String Functions

M
[index top]

Mac OS X, MySQL Connector/ODBC

installation, Installing MySQL on Mac OS X

mailing list address, General Information

mailing lists, MySQL Mailing Lists

archive location, MySQL Mailing Lists

guidelines, Guidelines for Using the Mailing Lists

main features of MySQL, The Main Features of MySQL

maintaining

log files, Server Log Maintenance

tables, Setting Up a MyISAM Table Maintenance Schedule

maintenance

tables, mysqlcheck — A Table Maintenance Program

MAKEDATE(), Date and Time Functions

MAKETIME(), Date and Time Functions

make_binary_distribution, Overview of MySQL Programs

MAKE_SET(), String Functions

make_win_bin_dist, Overview of MySQL Programs, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

exe-suffix option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

no-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

no-embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

only-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

Making temp file

thread state, Replication Slave SQL Thread States

malicious SQL statements

and MySQL Cluster, MySQL Cluster and MySQL Privileges

manage keys

thread state, General Thread States

management client (MySQL Cluster), ndb_mgm — The MySQL Cluster Management Client

(see also mgm)

management node (MySQL Cluster)

defined, MySQL Cluster Core Concepts

management nodes (MySQL Cluster), ndb_mgmd — The MySQL Cluster Management Server Daemon

(see also mgmd)

managing MySQL Cluster, Management of MySQL Cluster

managing MySQL Cluster processes, MySQL Cluster Programs

manual

available formats, About This Manual

online location, About This Manual

syntax conventions, Typographical and Syntax Conventions

typographical conventions, Typographical and Syntax Conventions

master-connect-retry option

mysqld, Replication Slave Options and Variables

master-data option

mysqldump, mysqldump — A Database Backup Program

master-host option

mysqld, Replication Slave Options and Variables

master-info-file option

mysqld, Replication Slave Options and Variables

master-password option

mysqld, Replication Slave Options and Variables

master-port option

mysqld, Replication Slave Options and Variables

master-retry-count option

mysqld, Replication Slave Options and Variables

master-ssl option

mysqld, Replication Slave Options and Variables

master-ssl-ca option

mysqld, Replication Slave Options and Variables

master-ssl-capath option

mysqld, Replication Slave Options and Variables

master-ssl-cert option

mysqld, Replication Slave Options and Variables

master-ssl-cipher option

mysqld, Replication Slave Options and Variables

master-ssl-key option

mysqld, Replication Slave Options and Variables

master-user option

mysqld, Replication Slave Options and Variables

MASTER_POS_WAIT(), Miscellaneous Functions, MASTER_POS_WAIT() Syntax

MATCH ... AGAINST(), Full-Text Search Functions

matching

patterns, Pattern Matching

math, Precision Math

mathematical functions, Mathematical Functions

MAX(), GROUP BY (Aggregate) Functions

MAX(DISTINCT), GROUP BY (Aggregate) Functions

max-binlog-dump-events option

mysqld, Binary Log Options and Variables

max-record-length option

myisamchk, myisamchk Repair Options

max-relay-log-size option

mysqld, Replication Slave Options and Variables

MaxBufferedEpochs, Defining MySQL Cluster Data Nodes

MAXDB SQL mode, Server SQL Modes

maximum memory used, mysqladmin — Client for Administering a MySQL Server

maximums

maximum columns per table, The Maximum Number of Columns Per Table

maximum tables per join, Limits of Joins

MaxLCPStartDelay, Defining MySQL Cluster Data Nodes

MaxNoOfAttributes, Defining MySQL Cluster Data Nodes

MaxNoOfConcurrentIndexOperations, Defining MySQL Cluster Data Nodes

MaxNoOfConcurrentOperations, Defining MySQL Cluster Data Nodes

MaxNoOfConcurrentScans, Defining MySQL Cluster Data Nodes

MaxNoOfConcurrentSubOperations, Defining MySQL Cluster Data Nodes

MaxNoOfConcurrentTransactions, Defining MySQL Cluster Data Nodes

MaxNoOfExecutionThreads

ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

MaxNoOfFiredTriggers, Defining MySQL Cluster Data Nodes

MaxNoOfIndexes, Defining MySQL Cluster Data Nodes

MaxNoOfLocalOperations, Defining MySQL Cluster Data Nodes

MaxNoOfLocalScans, Defining MySQL Cluster Data Nodes

MaxNoOfOpenFiles, Defining MySQL Cluster Data Nodes

MaxNoOfOrderedIndexes, Defining MySQL Cluster Data Nodes

MaxNoOfSavedMessages, Defining MySQL Cluster Data Nodes

MaxNoOfSubscribers, Defining MySQL Cluster Data Nodes

MaxNoOfSubscriptions, Defining MySQL Cluster Data Nodes

MaxNoOfTables, Defining MySQL Cluster Data Nodes

MaxNoOfTriggers, Defining MySQL Cluster Data Nodes

MaxNoOfUniqueHashIndexes, Defining MySQL Cluster Data Nodes

MaxScanBatchSize, Defining SQL and Other API Nodes in a MySQL Cluster

max_allowed_packet

and replication, Replication and max_allowed_packet

max_allowed_packet system variable, Server System Variables

max_allowed_packet variable, mysql Options

max_binlog_cache_size system variable, Binary Log Options and Variables

max_binlog_size system variable, Binary Log Options and Variables

max_connections system variable, Server System Variables

MAX_CONNECTIONS_PER_HOUR, Setting Account Resource Limits

max_connect_errors system variable, Server System Variables

max_delayed_threads system variable, Server System Variables

max_error_count system variable, Server System Variables

max_heap_table_size system variable, Server System Variables

max_insert_delayed_threads system variable, Server System Variables

max_join_size system variable, Server System Variables

max_join_size variable, mysql Options

max_length_for_sort_data system variable, Server System Variables

max_prepared_stmt_count system variable, Server System Variables

MAX_QUERIES_PER_HOUR, Setting Account Resource Limits

max_relay_log_size system variable, Server System Variables

max_seeks_for_key system variable, Server System Variables

max_sort_length system variable, Server System Variables

max_sp_recursion_depth system variable, Server System Variables

max_tmp_tables system variable, Server System Variables

MAX_UPDATES_PER_HOUR, Setting Account Resource Limits

MAX_USER_CONNECTIONS, Setting Account Resource Limits

max_user_connections system variable, Server System Variables

max_write_lock_count system variable, Server System Variables

MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRContains(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRDisjoint(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBREqual(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRIntersects(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBROverlaps(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRTouches(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRWithin(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MD5(), Encryption and Compression Functions

medium-check option

myisamchk, myisamchk Check Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

MEDIUMBLOB data type, Overview of String Types

MEDIUMINT data type, Overview of Numeric Types

MEDIUMTEXT data type, Overview of String Types

memlock option

mysqld, Server Command Options

MEMORY storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine

and replication, Replication and MEMORY Tables

memory usage

myisamchk, myisamchk Memory Usage

memory use, mysqladmin — Client for Administering a MySQL Server, How MySQL Uses Memory

in MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits

memoryusage

ndbinfo table, The ndbinfo memoryusage Table

MemReportFrequency, Defining MySQL Cluster Data Nodes

MERGE storage engine, Storage Engines, The MERGE Storage Engine

MERGE tables

defined, The MERGE Storage Engine

metadata

database, INFORMATION_SCHEMA Tables

stored routines, Stored Routine Metadata

triggers, Trigger Metadata

views, View Metadata

method option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

methods

locking, Internal Locking Methods

mgmd (MySQL Cluster)

defined, MySQL Cluster Core Concepts

(see also management node (MySQL Cluster))

MICROSECOND(), Date and Time Functions

Microsoft Access, Microsoft Access

Microsoft ADO, Microsoft ADO

Microsoft Excel, Microsoft Excel and Column Types

Microsoft Visual Basic, Microsoft Visual Basic

Microsoft Visual InterDev, Microsoft Visual InterDev

MID(), String Functions

MIN(), GROUP BY (Aggregate) Functions

MIN(DISTINCT), GROUP BY (Aggregate) Functions

min-examined-row-limit option

mysqld, Server Command Options

Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs)

minus

unary (-), Arithmetic Operators

MINUTE(), Date and Time Functions

min_examined_row_limit system variable, Server System Variables

mirror sites, How to Get MySQL

miscellaneous functions, Miscellaneous Functions

MIT-pthreads, MIT-pthreads Notes

MLineFromText(), Creating Geometry Values Using WKT Functions

MLineFromWKB(), Creating Geometry Values Using WKB Functions

MOD (modulo), Mathematical Functions

MOD(), Mathematical Functions

modes

batch, Using mysql in Batch Mode

modulo (%), Mathematical Functions

modulo (MOD), Mathematical Functions

monitor

terminal, Tutorial

monitoring-interval option

mysqlmanager, MySQL Instance Manager Command Options

Monitors

InnoDB, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations

Mono, MySQL Connector/NET

MONTH(), Date and Time Functions

MONTHNAME(), Date and Time Functions

MPointFromText(), Creating Geometry Values Using WKT Functions

MPointFromWKB(), Creating Geometry Values Using WKB Functions

MPolyFromText(), Creating Geometry Values Using WKT Functions

MPolyFromWKB(), Creating Geometry Values Using WKB Functions

mSQL compatibility, Regular Expressions

msql2mysql, msql2mysql — Convert mSQL Programs for Use with MySQL

MSSQL SQL mode, Server SQL Modes

multi mysqld, mysqld_multi — Manage Multiple MySQL Servers

multi-byte character sets, Can't initialize character set

and MySQL Cluster (replication), Known Issues in MySQL Cluster Replication

multi-byte characters, Multi-Byte Character Support

multi-column indexes, Multiple-Column Indexes

multi-master replication

in MySQL Cluster, MySQL Cluster Replication: Multi-Master and Circular Replication, MySQL Cluster Replication Conflict Resolution

MULTILINESTRING data type, MySQL Spatial Data Types

MultiLineString(), Creating Geometry Values Using MySQL-Specific Functions

MultiLineStringFromText(), Creating Geometry Values Using WKT Functions

MultiLineStringFromWKB(), Creating Geometry Values Using WKB Functions

multiple servers, Running Multiple MySQL Servers on the Same Machine

multiple-part index, CREATE INDEX Syntax

multiplication (*), Arithmetic Operators

MULTIPOINT data type, MySQL Spatial Data Types

MultiPoint(), Creating Geometry Values Using MySQL-Specific Functions

MultiPointFromText(), Creating Geometry Values Using WKT Functions

MultiPointFromWKB(), Creating Geometry Values Using WKB Functions

MULTIPOLYGON data type, MySQL Spatial Data Types

MultiPolygon(), Creating Geometry Values Using MySQL-Specific Functions

MultiPolygonFromText(), Creating Geometry Values Using WKT Functions

MultiPolygonFromWKB(), Creating Geometry Values Using WKB Functions

My

derivation, History of MySQL

my.cnf

and MySQL Cluster, MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files, MySQL Cluster Configuration: Basic Example

in MySQL Cluster, MySQL Server Usage for MySQL Cluster

my.cnf file, Replication Features and Issues

MyISAM

compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics

MyISAM key cache, The MyISAM Key Cache

MyISAM storage engine, Storage Engines, The MyISAM Storage Engine

myisam-block-size option

mysqld, Server Command Options

myisam-recover option

mysqld, Server Command Options, MyISAM Startup Options

myisamchk, Overview of MySQL Programs, myisamchk — MyISAM Table-Maintenance Utility

analyze option, Other myisamchk Options

backup option, myisamchk Repair Options

block-search option, Other myisamchk Options

character-sets-dir option, myisamchk Repair Options

check option, myisamchk Check Options

check-only-changed option, myisamchk Check Options

correct-checksum option, myisamchk Repair Options

data-file-length option, myisamchk Repair Options

debug option, myisamchk General Options

description option, Other myisamchk Options

example output, myisamchk Table Information

extend-check option, myisamchk Check Options, myisamchk Repair Options

fast option, myisamchk Check Options

force option, myisamchk Check Options, myisamchk Repair Options

help option, myisamchk General Options

HELP option, myisamchk General Options

information option, myisamchk Check Options

keys-used option, myisamchk Repair Options

max-record-length option, myisamchk Repair Options

medium-check option, myisamchk Check Options

no-symlinks option, myisamchk Repair Options

options, myisamchk General Options

parallel-recover option, myisamchk Repair Options

quick option, myisamchk Repair Options

read-only option, myisamchk Check Options

recover option, myisamchk Repair Options

safe-recover option, myisamchk Repair Options

set-auto-increment[ option, Other myisamchk Options

set-character-set option, myisamchk Repair Options

set-collation option, myisamchk Repair Options

silent option, myisamchk General Options

sort-index option, Other myisamchk Options

sort-records option, Other myisamchk Options

sort-recover option, myisamchk Repair Options

tmpdir option, myisamchk Repair Options

unpack option, myisamchk Repair Options

update-state option, myisamchk Check Options

verbose option, myisamchk General Options

version option, myisamchk General Options

wait option, myisamchk General Options

myisamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents

myisampack, Overview of MySQL Programs, myisampack — Generate Compressed, Read-Only MyISAM Tables, Silent Column Specification Changes, Compressed Table Characteristics

backup option, myisampack — Generate Compressed, Read-Only MyISAM Tables

character-sets-dir option, myisampack — Generate Compressed, Read-Only MyISAM Tables

debug option, myisampack — Generate Compressed, Read-Only MyISAM Tables

force option, myisampack — Generate Compressed, Read-Only MyISAM Tables

help option, myisampack — Generate Compressed, Read-Only MyISAM Tables

join option, myisampack — Generate Compressed, Read-Only MyISAM Tables

silent option, myisampack — Generate Compressed, Read-Only MyISAM Tables

test option, myisampack — Generate Compressed, Read-Only MyISAM Tables

tmpdir option, myisampack — Generate Compressed, Read-Only MyISAM Tables

verbose option, myisampack — Generate Compressed, Read-Only MyISAM Tables

version option, myisampack — Generate Compressed, Read-Only MyISAM Tables

wait option, myisampack — Generate Compressed, Read-Only MyISAM Tables

myisam_block_size myisamchk variable, myisamchk General Options

myisam_data_pointer_size system variable, Server System Variables

myisam_ftdump, Overview of MySQL Programs, myisam_ftdump — Display Full-Text Index information

count option, myisam_ftdump — Display Full-Text Index information

dump option, myisam_ftdump — Display Full-Text Index information

help option, myisam_ftdump — Display Full-Text Index information

length option, myisam_ftdump — Display Full-Text Index information

stats option, myisam_ftdump — Display Full-Text Index information

verbose option, myisam_ftdump — Display Full-Text Index information

myisam_max_sort_file_size system variable, Server System Variables

myisam_mmap_size system variable, Server System Variables

myisam_recover_options system variable, Server System Variables

myisam_repair_threads system variable, Server System Variables

myisam_sort_buffer_size system variable, Server System Variables

myisam_stats_method system variable, Server System Variables

myisam_use_mmap system variable, Server System Variables

MyODBC, MySQL Connector/ODBC

MySQL

defined, What is MySQL?

introduction, What is MySQL?

pronunciation, What is MySQL?

upgrading, mysql_upgrade — Check Tables for MySQL Upgrade

mysql, Overview of MySQL Programs, mysql — The MySQL Command-Line Tool

auto-rehash option, mysql Options

batch option, mysql Options

character-sets-dir option, mysql Options

charset command, mysql Commands

clear command, mysql Commands

column-names option, mysql Options

column-type-info option, mysql Options

comments option, mysql Options

compress option, mysql Options

connect command, mysql Commands

database option, mysql Options

debug option, mysql Options

debug-check option, mysql Options

debug-info option, mysql Options

default-character-set option, mysql Options

delimiter command, mysql Commands

delimiter option, mysql Options

disable named commands, mysql Options

edit command, mysql Commands

ego command, mysql Commands

execute option, mysql Options

exit command, mysql Commands

force option, mysql Options

go command, mysql Commands

help command, mysql Commands

help option, mysql Options

host option, mysql Options

html option, mysql Options

i-am-a-dummy option, mysql Options

ignore-spaces option, mysql Options

line-numbers option, mysql Options

local-infile option, mysql Options

named-commands option, mysql Options

no-auto-rehash option, mysql Options

no-beep option, mysql Options

no-named-commands option, mysql Options

no-pager option, mysql Options

no-tee option, mysql Options

nopager command, mysql Commands

notee command, mysql Commands

nowarning command, mysql Commands

one-database option, mysql Options

pager command, mysql Commands

pager option, mysql Options

password option, mysql Options

pipe option, mysql Options

port option, mysql Options

print command, mysql Commands

prompt command, mysql Commands

prompt option, mysql Options

protocol option, mysql Options

quick option, mysql Options

quit command, mysql Commands

raw option, mysql Options

reconnect option, mysql Options

rehash command, mysql Commands

safe-updates option, mysql Options

secure-auth option, mysql Options

show-warnings option, mysql Options

sigint-ignore option, mysql Options

silent option, mysql Options

skip-column-names option, mysql Options

skip-line-numbers option, mysql Options

socket option, mysql Options

source command, mysql Commands

SSL options, mysql Options

status command, mysql Commands

system command, mysql Commands

table option, mysql Options

tee command, mysql Commands

tee option, mysql Options

unbuffered option, mysql Options

use command, mysql Commands

user option, mysql Options

verbose option, mysql Options

version option, mysql Options

vertical option, mysql Options

wait option, mysql Options

warnings command, mysql Commands

xml option, mysql Options

MySQL binary distribution, Choosing Which MySQL Distribution to Install

MYSQL C type, C API Data Structures

MySQL Cluster, MySQL Cluster NDB 6.X/7.X

"quick" configuration, Quick Test Setup of MySQL Cluster

administration, mysqld Command Options for MySQL Cluster, ndbd — The MySQL Cluster Data Node Daemon, ndb_mgmd — The MySQL Cluster Management Server Daemon, ndb_mgm — The MySQL Cluster Management Client, Options Common to MySQL Cluster Programs, Commands in the MySQL Cluster Management Client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

and character sets, Known Issues in MySQL Cluster Replication

and DNS, MySQL Cluster Multi-Computer How-To

and INFORMATION_SCHEMA, MySQL Cluster and MySQL Privileges

and IP addressing, MySQL Cluster Multi-Computer How-To

and MySQL privileges, MySQL Cluster and MySQL Privileges

and MySQL root user, MySQL Cluster and MySQL Privileges, MySQL Cluster and MySQL Security Procedures

and networking, MySQL Cluster Hardware, Software, and Networking Requirements

and transactions, MySQL 5.1 FAQ: MySQL Cluster

and virtual machines, MySQL 5.1 FAQ: MySQL Cluster

API node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes in a MySQL Cluster

arbitrator, MySQL 5.1 FAQ: MySQL Cluster

available platforms, MySQL Cluster NDB 6.X/7.X

backups, ndb_restore — Restore a MySQL Cluster Backup, Online Backup of MySQL Cluster, MySQL Cluster Backup Concepts, Using The MySQL Cluster Management Client to Create a Backup, Configuration for MySQL Cluster Backups, MySQL Cluster Backup Troubleshooting

benchmarks, MySQL Cluster Interconnects and Performance

CHECKPOINT Events, MySQL Cluster Log Events

cluster logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands

CLUSTERLOG commands, MySQL Cluster Logging Management Commands

CLUSTERLOG STATISTICS command, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

commands, mysqld Command Options for MySQL Cluster, ndbd — The MySQL Cluster Data Node Daemon, ndb_mgmd — The MySQL Cluster Management Server Daemon, ndb_mgm — The MySQL Cluster Management Client, Commands in the MySQL Cluster Management Client

compiling with icc, Debugging and Porting MySQL

concepts, MySQL Cluster Core Concepts

configuration, MySQL Cluster Multi-Computer How-To, MySQL Cluster Configuration, Quick Test Setup of MySQL Cluster, Defining Computers in a MySQL Cluster, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster, Configuring MySQL Cluster Parameters for Local Checkpoints, MySQL Server Usage for MySQL Cluster, ndb_mgmd — The MySQL Cluster Management Server Daemon

configuration (example), MySQL Cluster Configuration: Basic Example

configuration changes, Performing a Rolling Restart of a MySQL Cluster

configuration files, MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files

configuration parameters, Overview of MySQL Cluster Configuration Parameters, MySQL Cluster Data Node Configuration Parameters, MySQL Cluster Management Node Configuration Parameters, MySQL Cluster SQL Node and API Node Configuration Parameters, Other MySQL Cluster Configuration Parameters

configuring, Configuration for MySQL Cluster Backups

CONNECTION Events, MySQL Cluster Log Events

connectstring, The MySQL Cluster Connectstring

CREATE NODEGROUP command, Commands in the MySQL Cluster Management Client

data node, MySQL Cluster Core Concepts, Defining MySQL Cluster Data Nodes

data nodes, ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

data types supported, MySQL 5.1 FAQ: MySQL Cluster

defining node hosts, Defining Computers in a MySQL Cluster

direct connections between nodes, MySQL Cluster TCP/IP Connections Using Direct Connections

Disk Data tables (see MySQL Cluster Disk Data)

DROP NODEGROUP command, Commands in the MySQL Cluster Management Client

ENTER SINGLE USER MODE command, Commands in the MySQL Cluster Management Client

ERROR Events, MySQL Cluster Log Events

error logs, ndbd — The MySQL Cluster Data Node Daemon

error messages, MySQL 5.1 FAQ: MySQL Cluster

event log format, MySQL Cluster Log Events

event logging thresholds, MySQL Cluster Logging Management Commands

event logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands

event severity levels, MySQL Cluster Logging Management Commands

event types, Event Reports Generated in MySQL Cluster, MySQL Cluster Log Events

execution threads, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

EXIT command, Commands in the MySQL Cluster Management Client

EXIT SINGLE USER MODE command, Commands in the MySQL Cluster Management Client

FAQ, MySQL 5.1 FAQ: MySQL Cluster

features added in MySQL 5.1, Development History of MySQL Cluster in MySQL 5.1

GCP Stop errors, Defining MySQL Cluster Data Nodes

general description, MySQL Cluster Overview

hardware requirements, MySQL 5.1 FAQ: MySQL Cluster

HELP command, Commands in the MySQL Cluster Management Client

HostName parameter

and security, MySQL Cluster Security and Networking Issues

how to obtain, MySQL 5.1 FAQ: MySQL Cluster

importing existing tables, MySQL 5.1 FAQ: MySQL Cluster

INFO Events, MySQL Cluster Log Events

information sources, MySQL Cluster NDB 6.X/7.X

insecurity of communication protocols, MySQL Cluster Security and Networking Issues

installation, MySQL Cluster Multi-Computer How-To, MySQL Cluster Multi-Computer Installation

interconnects, Using High-Speed Interconnects with MySQL Cluster

Java clients, MySQL Cluster Core Concepts

log files, ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

logging commands, MySQL Cluster Logging Management Commands

management client (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client

management commands, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

management node, MySQL Cluster Core Concepts, Defining a MySQL Cluster Management Server

management nodes, ndb_mgmd — The MySQL Cluster Management Server Daemon

managing, Management of MySQL Cluster

master node, MySQL 5.1 FAQ: MySQL Cluster

memory requirements, MySQL 5.1 FAQ: MySQL Cluster

memory usage and recovery, Limits and Differences of MySQL Cluster from Standard MySQL Limits, Performing a Rolling Restart of a MySQL Cluster

mgm, Options Common to MySQL Cluster Programs

mgm client, Commands in the MySQL Cluster Management Client

mgm management client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

mgm process, ndb_mgm — The MySQL Cluster Management Client

mgmd, Options Common to MySQL Cluster Programs

mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon

mysqld process, mysqld Command Options for MySQL Cluster, MySQL Server Usage for MySQL Cluster

ndbd, ndbd — The MySQL Cluster Data Node Daemon, Options Common to MySQL Cluster Programs

ndbd process, ndbd — The MySQL Cluster Data Node Daemon, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)

ndb_mgm, Initial Startup of MySQL Cluster, ndb_mgm — The MySQL Cluster Management Client

ndb_mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon

ndb_size.pl (utility), MySQL 5.1 FAQ: MySQL Cluster

network configuration

and security, MySQL Cluster Security and Networking Issues

network transporters, Using High-Speed Interconnects with MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets

networking, MySQL Cluster TCP/IP Connections Using Direct Connections, MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster

networking requirements, MySQL 5.1 FAQ: MySQL Cluster

node failure (single user mode), MySQL Cluster Single User Mode

node identifiers, MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster

node logs, Event Reports Generated in MySQL Cluster

node types, MySQL 5.1 FAQ: MySQL Cluster

NODERESTART Events, MySQL Cluster Log Events

nodes and node groups, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

nodes and types, MySQL Cluster Core Concepts

number of computers required, MySQL 5.1 FAQ: MySQL Cluster

obtaining, MySQL Cluster Multi-Computer Installation

partitioning support, Noncompliance with SQL Syntax in MySQL Cluster

partitions, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

performance, MySQL Cluster Interconnects and Performance

performing queries, Loading Sample Data into MySQL Cluster and Performing Queries

platforms supported, MySQL 5.1 FAQ: MySQL Cluster

preparing for replication, Preparing the MySQL Cluster for Replication

process management, MySQL Cluster Programs

QUIT command, Commands in the MySQL Cluster Management Client

replicas, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

replication, MySQL Cluster Replication

(see also MySQL Cluster replication)

REPORT command, Commands in the MySQL Cluster Management Client

requirements, MySQL Cluster Hardware, Software, and Networking Requirements

resetting, Performing a Rolling Restart of a MySQL Cluster

RESTART command, Commands in the MySQL Cluster Management Client

restarting, Safe Shutdown and Restart of MySQL Cluster

restoring backups, ndb_restore — Restore a MySQL Cluster Backup

roles of computers, MySQL 5.1 FAQ: MySQL Cluster

runtime statistics, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

SCI (Scalable Coherent Interface), SCI Transport Connections in MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets

security, MySQL Cluster Security Issues, MySQL 5.1 FAQ: MySQL Cluster

and firewalls, MySQL Cluster Security and Networking Issues

and HostName parameter, MySQL Cluster Security and Networking Issues

and network configuration, MySQL Cluster Security and Networking Issues

and network ports, MySQL Cluster Security and Networking Issues

and remote administration, MySQL Cluster Security and Networking Issues

networking, MySQL Cluster Security and Networking Issues

security procedures, MySQL Cluster and MySQL Security Procedures

shared memory transport, MySQL Cluster Shared-Memory Connections

SHOW command, Commands in the MySQL Cluster Management Client

SHUTDOWN command, Commands in the MySQL Cluster Management Client

shutting down, Safe Shutdown and Restart of MySQL Cluster

single user mode, Commands in the MySQL Cluster Management Client, MySQL Cluster Single User Mode

SQL node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes in a MySQL Cluster

SQL nodes, MySQL Server Usage for MySQL Cluster

SQL statements, MySQL 5.1 FAQ: MySQL Cluster

SQL statements for monitoring, Quick Reference: MySQL Cluster SQL Statements

START BACKUP command, MySQL Cluster Backups With MySQL Cluster Replication

START command, Commands in the MySQL Cluster Management Client

start phases (summary), Summary of MySQL Cluster Start Phases

starting, Quick Test Setup of MySQL Cluster

starting and stopping, MySQL 5.1 FAQ: MySQL Cluster

starting nodes, Initial Startup of MySQL Cluster

starting or restarting, Summary of MySQL Cluster Start Phases

STARTUP Events, MySQL Cluster Log Events

STATISTICS Events, MySQL Cluster Log Events

STATUS command, Commands in the MySQL Cluster Management Client

STOP command, Commands in the MySQL Cluster Management Client

storage requirements, Data Type Storage Requirements

Table is full errors, MySQL 5.1 FAQ: MySQL Cluster

thread states, MySQL Cluster Thread States

trace files, ndbd — The MySQL Cluster Data Node Daemon

transaction handling, Limits Relating to Transaction Handling in MySQL Cluster

transactions, Defining MySQL Cluster Data Nodes

transporters

Scalable Coherent Interface (SCI), SCI Transport Connections in MySQL Cluster

shared memory (SHM), MySQL Cluster Shared-Memory Connections

TCP/IP, MySQL Cluster TCP/IP Connections Using Direct Connections

troubleshooting backups, MySQL Cluster Backup Troubleshooting

upgrades and downgrades, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of a MySQL Cluster, MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility

using tables and data, Loading Sample Data into MySQL Cluster and Performing Queries

vs replication, MySQL 5.1 FAQ: MySQL Cluster

MySQL Cluster Disk Data, MySQL Cluster Disk Data Tables

creating log file groups, MySQL Cluster Disk Data Objects

creating tables, MySQL Cluster Disk Data Objects

creating tablespaces, MySQL Cluster Disk Data Objects

dropping Disk Data objects, MySQL Cluster Disk Data Objects

storage requirements, MySQL Cluster Disk Data Storage Requirements

MySQL Cluster How-To, MySQL Cluster Multi-Computer How-To

MySQL Cluster in MySQL 5.1, MySQL Cluster Development History

MySQL Cluster limitations, Known Limitations of MySQL Cluster

and differences from standard MySQL limits, Limits and Differences of MySQL Cluster from Standard MySQL Limits

autodiscovery, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

binary logging, Issues Exclusive to MySQL Cluster

character sets, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

CREATE TABLE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

database objects, Limits Associated with Database Objects in MySQL Cluster

Disk Data storage, Limitations Relating to MySQL Cluster Disk Data Storage

error handling and reporting, MySQL Cluster Error Handling

geometry data types, Noncompliance with SQL Syntax in MySQL Cluster

implementation, Issues Exclusive to MySQL Cluster

imposed by configuration, Limits and Differences of MySQL Cluster from Standard MySQL Limits

INSERT IGNORE, UPDATE IGNORE, and REPLACE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

memory usage and transaction handling, Limits Relating to Transaction Handling in MySQL Cluster

multiple data nodes, MySQL Cluster Development in MySQL Cluster NDB 6.2, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

multiple management servers, Limitations Relating to Multiple MySQL Cluster Nodes, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

multiple MySQL servers, Limitations Relating to Multiple MySQL Cluster Nodes

partitioning, Noncompliance with SQL Syntax in MySQL Cluster

performance, Limitations Relating to Performance in MySQL Cluster

replication, Noncompliance with SQL Syntax in MySQL Cluster, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

resolved in current version from previous versions, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x

syntax, Noncompliance with SQL Syntax in MySQL Cluster

transactions, Limits Relating to Transaction Handling in MySQL Cluster

unsupported features, Unsupported or Missing Features in MySQL Cluster

MySQL Cluster NDB 6.x, MySQL Cluster Development History

MySQL Cluster processes, MySQL Cluster Programs

MySQL Cluster programs, MySQL Cluster Programs

MySQL Cluster replication, MySQL Cluster Replication

and --initial option, Known Issues in MySQL Cluster Replication

and auto_increment* variables, Known Issues in MySQL Cluster Replication

and circular replication, Known Issues in MySQL Cluster Replication

and multi-byte character sets, Known Issues in MySQL Cluster Replication

and primary key, Known Issues in MySQL Cluster Replication

and single point of failure, Using Two Replication Channels for MySQL Cluster Replication

backups, MySQL Cluster Backups With MySQL Cluster Replication

circular replication, MySQL Cluster Replication: Multi-Master and Circular Replication

concepts, MySQL Cluster Replication: Abbreviations and Symbols, MySQL Cluster Replication: Assumptions and General Requirements

conflict resolution, MySQL Cluster Replication Conflict Resolution

failover, Using Two Replication Channels for MySQL Cluster Replication, Implementing Failover with MySQL Cluster Replication

gap event, Known Issues in MySQL Cluster Replication

known issues, Known Issues in MySQL Cluster Replication

loss of connection, Known Issues in MySQL Cluster Replication

multi-master replication, MySQL Cluster Replication: Multi-Master and Circular Replication

point-in-time recovery, Point-In-Time Recovery Using MySQL Cluster Replication

preparing, Preparing the MySQL Cluster for Replication

requirements, MySQL Cluster Replication: Assumptions and General Requirements

reset-slave.pl backup automation script, MySQL Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log

restoring from backup, MySQL Cluster Backups With MySQL Cluster Replication

starting, Starting MySQL Cluster Replication (Single Replication Channel)

storage engines other than NDB on slave, Known Issues in MySQL Cluster Replication

synchronization of master and slave, MySQL Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log

system tables used, MySQL Cluster Replication Schema and Tables

mysql command options, mysql Options

mysql commands

list of, mysql Commands

MySQL Dolphin name, History of MySQL

MySQL history, History of MySQL

mysql history file, mysql Options

MySQL Instance Manager, mysqlmanager — The MySQL Instance Manager

MySQL mailing lists, MySQL Mailing Lists

MySQL name, History of MySQL

MySQL privileges

and MySQL Cluster, MySQL Cluster and MySQL Privileges

mysql prompt command, mysql Commands

MySQL server

mysqld, mysqld — The MySQL Server, The MySQL Server

mysql source (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File

MySQL source distribution, Choosing Which MySQL Distribution to Install

MySQL storage engines, Storage Engines

MySQL system tables

and MySQL Cluster, MySQL Cluster and MySQL Privileges

and replication, Replication of the mysql System Database

MySQL version, How to Get MySQL

mysql \. (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File

MySQL++, MySQL C++ API

mysql.event table, The Event Scheduler and MySQL Privileges

mysql.ndb_binlog_index table, MySQL Cluster Replication Schema and Tables

(see also MySQL Cluster replication)

mysql.server, Overview of MySQL Programs, mysql.server — MySQL Server Startup Script

basedir option, mysql.server — MySQL Server Startup Script

datadir option, mysql.server — MySQL Server Startup Script

pid-file option, mysql.server — MySQL Server Startup Script

service-startup-timeout option, mysql.server — MySQL Server Startup Script

use-manager option, mysql.server — MySQL Server Startup Script

use-mysqld_safe option, mysql.server — MySQL Server Startup Script

user option, mysql.server — MySQL Server Startup Script

mysql.sock

changing location of, Typical configure Options

protection, How to Protect or Change the MySQL Unix Socket File

MYSQL323 SQL mode, Server SQL Modes

MYSQL40 SQL mode, Server SQL Modes

mysqlaccess, Overview of MySQL Programs, mysqlaccess — Client for Checking Access Privileges

brief option, mysqlaccess — Client for Checking Access Privileges

commit option, mysqlaccess — Client for Checking Access Privileges

copy option, mysqlaccess — Client for Checking Access Privileges

db option, mysqlaccess — Client for Checking Access Privileges

debug option, mysqlaccess — Client for Checking Access Privileges

help option, mysqlaccess — Client for Checking Access Privileges

host option, mysqlaccess — Client for Checking Access Privileges

howto option, mysqlaccess — Client for Checking Access Privileges

old_server option, mysqlaccess — Client for Checking Access Privileges

password option, mysqlaccess — Client for Checking Access Privileges

plan option, mysqlaccess — Client for Checking Access Privileges

preview option, mysqlaccess — Client for Checking Access Privileges

relnotes option, mysqlaccess — Client for Checking Access Privileges

rhost option, mysqlaccess — Client for Checking Access Privileges

rollback option, mysqlaccess — Client for Checking Access Privileges

spassword option, mysqlaccess — Client for Checking Access Privileges

superuser option, mysqlaccess — Client for Checking Access Privileges

table option, mysqlaccess — Client for Checking Access Privileges

user option, mysqlaccess — Client for Checking Access Privileges

version option, mysqlaccess — Client for Checking Access Privileges

mysqladmin, Overview of MySQL Programs, mysqladmin — Client for Administering a MySQL Server, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax

character-sets-dir option, mysqladmin — Client for Administering a MySQL Server

compress option, mysqladmin — Client for Administering a MySQL Server

count option, mysqladmin — Client for Administering a MySQL Server

debug option, mysqladmin — Client for Administering a MySQL Server

debug-check option, mysqladmin — Client for Administering a MySQL Server

debug-info option, mysqladmin — Client for Administering a MySQL Server

default-character-set option, mysqladmin — Client for Administering a MySQL Server

force option, mysqladmin — Client for Administering a MySQL Server

help option, mysqladmin — Client for Administering a MySQL Server

host option, mysqladmin — Client for Administering a MySQL Server

no-beep option, mysqladmin — Client for Administering a MySQL Server

password option, mysqladmin — Client for Administering a MySQL Server

pipe option, mysqladmin — Client for Administering a MySQL Server

port option, mysqladmin — Client for Administering a MySQL Server

protocol option, mysqladmin — Client for Administering a MySQL Server

relative option, mysqladmin — Client for Administering a MySQL Server

silent option, mysqladmin — Client for Administering a MySQL Server

sleep option, mysqladmin — Client for Administering a MySQL Server

socket option, mysqladmin — Client for Administering a MySQL Server

SSL options, mysqladmin — Client for Administering a MySQL Server

user option, mysqladmin — Client for Administering a MySQL Server

verbose option, mysqladmin — Client for Administering a MySQL Server

version option, mysqladmin — Client for Administering a MySQL Server

vertical option, mysqladmin — Client for Administering a MySQL Server

wait option, mysqladmin — Client for Administering a MySQL Server

mysqladmin command options, mysqladmin — Client for Administering a MySQL Server

mysqladmin option

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

mysqlbinlog, Overview of MySQL Programs, mysqlbinlog — Utility for Processing Binary Log Files

base64-output option, mysqlbinlog — Utility for Processing Binary Log Files

character-sets-dir option, mysqlbinlog — Utility for Processing Binary Log Files

database option, mysqlbinlog — Utility for Processing Binary Log Files

debug option, mysqlbinlog — Utility for Processing Binary Log Files

debug-check option, mysqlbinlog — Utility for Processing Binary Log Files

debug-info option, mysqlbinlog — Utility for Processing Binary Log Files

disable-log-bin option, mysqlbinlog — Utility for Processing Binary Log Files

force-read option, mysqlbinlog — Utility for Processing Binary Log Files

help option, mysqlbinlog — Utility for Processing Binary Log Files

hexdump option, mysqlbinlog — Utility for Processing Binary Log Files

host option, mysqlbinlog — Utility for Processing Binary Log Files

local-load option, mysqlbinlog — Utility for Processing Binary Log Files

offset option, mysqlbinlog — Utility for Processing Binary Log Files

password option, mysqlbinlog — Utility for Processing Binary Log Files

port option, mysqlbinlog — Utility for Processing Binary Log Files

position option, mysqlbinlog — Utility for Processing Binary Log Files

protocol option, mysqlbinlog — Utility for Processing Binary Log Files

read-from-remote-server option, mysqlbinlog — Utility for Processing Binary Log Files

result-file option, mysqlbinlog — Utility for Processing Binary Log Files

server-id option, mysqlbinlog — Utility for Processing Binary Log Files

set-charset option, mysqlbinlog — Utility for Processing Binary Log Files

short-form option, mysqlbinlog — Utility for Processing Binary Log Files

socket option, mysqlbinlog — Utility for Processing Binary Log Files

start-datetime option, mysqlbinlog — Utility for Processing Binary Log Files

start-position option, mysqlbinlog — Utility for Processing Binary Log Files

stop-datetime option, mysqlbinlog — Utility for Processing Binary Log Files

stop-position option, mysqlbinlog — Utility for Processing Binary Log Files

to-last-log option, mysqlbinlog — Utility for Processing Binary Log Files

user option, mysqlbinlog — Utility for Processing Binary Log Files

verbose option, mysqlbinlog — Utility for Processing Binary Log Files

version option, mysqlbinlog — Utility for Processing Binary Log Files

mysqlbug, mysqlbug — Generate Bug Report

mysqlbug script, How to Report Bugs or Problems

mysqlcheck, Overview of MySQL Programs, mysqlcheck — A Table Maintenance Program

all-databases option, mysqlcheck — A Table Maintenance Program

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

analyze option, mysqlcheck — A Table Maintenance Program

auto-repair option, mysqlcheck — A Table Maintenance Program

character-sets-dir option, mysqlcheck — A Table Maintenance Program

check option, mysqlcheck — A Table Maintenance Program

check-only-changed option, mysqlcheck — A Table Maintenance Program

check-upgrade option, mysqlcheck — A Table Maintenance Program

compress option, mysqlcheck — A Table Maintenance Program

databases option, mysqlcheck — A Table Maintenance Program

debug option, mysqlcheck — A Table Maintenance Program

debug-check option, mysqlcheck — A Table Maintenance Program

debug-info option, mysqlcheck — A Table Maintenance Program

default-character-set option, mysqlcheck — A Table Maintenance Program

extended option, mysqlcheck — A Table Maintenance Program

fast option, mysqlcheck — A Table Maintenance Program

fix-db-names option, mysqlcheck — A Table Maintenance Program

fix-table-names option, mysqlcheck — A Table Maintenance Program

force option, mysqlcheck — A Table Maintenance Program

help option, mysqlcheck — A Table Maintenance Program

host option, mysqlcheck — A Table Maintenance Program

medium-check option, mysqlcheck — A Table Maintenance Program

optimize option, mysqlcheck — A Table Maintenance Program

password option, mysqlcheck — A Table Maintenance Program

pipe option, mysqlcheck — A Table Maintenance Program

port option, mysqlcheck — A Table Maintenance Program

protocol option, mysqlcheck — A Table Maintenance Program

quick option, mysqlcheck — A Table Maintenance Program

repair option, mysqlcheck — A Table Maintenance Program

silent option, mysqlcheck — A Table Maintenance Program

socket option, mysqlcheck — A Table Maintenance Program

SSL options, mysqlcheck — A Table Maintenance Program

tables option, mysqlcheck — A Table Maintenance Program

use-frm option, mysqlcheck — A Table Maintenance Program

user option, mysqlcheck — A Table Maintenance Program

verbose option, mysqlcheck — A Table Maintenance Program

version option, mysqlcheck — A Table Maintenance Program

write-binlog option, mysqlcheck — A Table Maintenance Program

mysqlclient library, Connectors and APIs

mysqld, Overview of MySQL Programs

abort-slave-event-count option, Replication Slave Options and Variables

allow-suspicious-udfs option, Server Command Options, Security-Related mysqld Options

ansi option, Server Command Options

as MySQL Cluster process, mysqld Command Options for MySQL Cluster, MySQL Server Usage for MySQL Cluster

basedir option, Server Command Options

big-tables option, Server Command Options

bind-address option, Server Command Options

binlog-do-db option, Binary Log Options and Variables

binlog-format option, Server Command Options

binlog-ignore-db option, Binary Log Options and Variables

binlog-row-event-max-size option, Binary Log Options and Variables

bootstrap option, Server Command Options

character-set-client-handshake option, Server Command Options

character-set-filesystem option, Server Command Options

character-set-server option, Server Command Options

character-sets-dir option, Server Command Options

chroot option, Server Command Options

collation-server option, Server Command Options

command options, Server Command Options

console option, Server Command Options

core-file option, Server Command Options

datadir option, Server Command Options

debug option, Server Command Options

debug-sync-timeout option, Server Command Options

default-character-set option, Server Command Options

default-collation option, Server Command Options

default-storage-engine option, Server Command Options

default-table-type option, Server Command Options

default-time-zone option, Server Command Options

delay-key-write option, Server Command Options, MyISAM Startup Options

des-key-file option, Server Command Options

disconnect-slave-event-count option, Replication Slave Options and Variables

enable-named-pipe option, Server Command Options

enable-pstack option, Server Command Options

event-scheduler option, Server Command Options

exit-info option, Server Command Options

external-locking option, Server Command Options

flush option, Server Command Options

gdb option, Server Command Options

general-log option, Server Command Options

help option, Server Command Options

ignore-builtin-innodb option, InnoDB Startup Options and System Variables

init-file option, Server Command Options

innodb option, InnoDB Startup Options and System Variables

innodb-status-file option, InnoDB Startup Options and System Variables

language option, Server Command Options

large-pages option, Server Command Options

local-infile option, Security-Related mysqld Options

log option, Server Command Options

log-bin option, Binary Log Options and Variables

log-bin-index option, Binary Log Options and Variables

log-bin-trust-function-creators option, Binary Log Options and Variables

log-error option, Server Command Options

log-isam option, Server Command Options

log-long-format option, Server Command Options

log-output option, Server Command Options

log-queries-not-using-indexes option, Server Command Options

log-short-format option, Server Command Options

log-slave-updates option, Replication Slave Options and Variables

log-slow-admin-statements option, Server Command Options

log-slow-queries option, Server Command Options

log-slow-slave-statements option, Replication Slave Options and Variables

log-tc option, Server Command Options

log-tc-size option, Server Command Options

log-warnings option, Server Command Options, Replication Slave Options and Variables

low-priority-updates option, Server Command Options

master-connect-retry option, Replication Slave Options and Variables

master-host option, Replication Slave Options and Variables

master-info-file option, Replication Slave Options and Variables

master-password option, Replication Slave Options and Variables

master-port option, Replication Slave Options and Variables

master-retry-count option, Replication Slave Options and Variables

master-ssl option, Replication Slave Options and Variables

master-ssl-ca option, Replication Slave Options and Variables

master-ssl-capath option, Replication Slave Options and Variables

master-ssl-cert option, Replication Slave Options and Variables

master-ssl-cipher option, Replication Slave Options and Variables

master-ssl-key option, Replication Slave Options and Variables

master-user option, Replication Slave Options and Variables

max-binlog-dump-events option, Binary Log Options and Variables

max-relay-log-size option, Replication Slave Options and Variables

memlock option, Server Command Options

min-examined-row-limit option, Server Command Options

myisam-block-size option, Server Command Options

myisam-recover option, Server Command Options, MyISAM Startup Options

MySQL server, mysqld — The MySQL Server, The MySQL Server

ndb-batch-size option, mysqld Command Options for MySQL Cluster

ndb-cluster-connection-pool option, mysqld Command Options for MySQL Cluster

ndb-connectstring option, mysqld Command Options for MySQL Cluster

ndb-nodeid, mysqld Command Options for MySQL Cluster

ndbcluster option, mysqld Command Options for MySQL Cluster

old-alter-table option, Server Command Options

old-passwords option, Server Command Options, Security-Related mysqld Options

old-style-user-limits option, Server Command Options

one-thread option, Server Command Options

open-files-limit option, Server Command Options

partition option, Server Command Options

pid-file option, Server Command Options

plugin option prefix, Server Command Options

plugin-load option, Server Command Options

port option, Server Command Options

port-open-timeout option, Server Command Options

read-only option, Replication Slave Options and Variables

relay-log option, Replication Slave Options and Variables

relay-log-index option, Replication Slave Options and Variables

relay-log-info-file option, Replication Slave Options and Variables

relay-log-purge option, Replication Slave Options and Variables

relay-log-space-limit option, Replication Slave Options and Variables

replicate-do-db option, Replication Slave Options and Variables

replicate-do-table option, Replication Slave Options and Variables

replicate-ignore-db option, Replication Slave Options and Variables

replicate-ignore-table option, Replication Slave Options and Variables

replicate-rewrite-db option, Replication Slave Options and Variables

replicate-same-server-id option, Replication Slave Options and Variables

replicate-wild-do-table option, Replication Slave Options and Variables

replicate-wild-ignore-table option, Replication Slave Options and Variables

report-host option, Replication Slave Options and Variables

report-password option, Replication Slave Options and Variables

report-port option, Replication Slave Options and Variables

report-user option, Replication Slave Options and Variables

role in MySQL Cluster (see SQL Node (MySQL Cluster))

safe-mode option, Server Command Options

safe-show-database option, Server Command Options, Security-Related mysqld Options

safe-user-create option, Server Command Options, Security-Related mysqld Options

secure-auth option, Server Command Options, Security-Related mysqld Options

secure-file-priv option, Server Command Options, Security-Related mysqld Options

server-id option, Replication and Binary Logging Options and Variables

shared-memory option, Server Command Options

shared-memory-base-name option, Server Command Options

show-slave-auth-info option, Replication Slave Options and Variables

skip-concurrent-insert option, Server Command Options

skip-event-scheduler option, Server Command Options

skip-external-locking option, Server Command Options

skip-grant-tables option, Server Command Options, Security-Related mysqld Options

skip-host-cache option, Server Command Options

skip-innodb option, Server Command Options

skip-merge option, Security-Related mysqld Options

skip-name-resolve option, Server Command Options, Security-Related mysqld Options

skip-ndbcluster option, mysqld Command Options for MySQL Cluster

skip-networking option, Server Command Options, Security-Related mysqld Options

skip-partition option, Server Command Options

skip-safemalloc option, Server Command Options

skip-show-database option, Server Command Options, Security-Related mysqld Options

skip-slave-start option, Replication Slave Options and Variables

skip-stack-trace option, Server Command Options

skip-symbolic-links option, Server Command Options

skip-thread-priority option, Server Command Options

slave-load-tmpdir option, Replication Slave Options and Variables

slave-net-timeout option, Replication Slave Options and Variables

slave-skip-errors option, Replication Slave Options and Variables

slave_compressed_protocol option, Replication Slave Options and Variables

slow-query-log option, Server Command Options

socket option, Server Command Options

sporadic-binlog-dump-fail option, Binary Log Options and Variables

sql-mode option, Server Command Options

SSL options, Server Command Options, Security-Related mysqld Options

standalone option, Server Command Options

starting, How to Run MySQL as a Normal User

symbolic-links option, Server Command Options

sysdate-is-now option, Server Command Options

tc-heuristic-recover option, Server Command Options

temp-pool option, Server Command Options

tmpdir option, Server Command Options

transaction-isolation option, Server Command Options

user option, Server Command Options

verbose option, Server Command Options

version option, Server Command Options

mysqld (MySQL Cluster), MySQL Cluster Programs

mysqld library, Connectors and APIs

mysqld option

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

mysqld_safe, mysqld_safe — MySQL Server Startup Script

mysqld options, Tuning Server Parameters

mysqld server

buffer sizes, Tuning Server Parameters

mysqld-safe-compatible option

mysqlmanager, MySQL Instance Manager Command Options

mysqld-version option

mysqld_safe, mysqld_safe — MySQL Server Startup Script

mysqldump, Copying MySQL Databases to Another Machine, Overview of MySQL Programs, mysqldump — A Database Backup Program

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

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

add-locks option, mysqldump — A Database Backup Program

all-databases option, mysqldump — A Database Backup Program

all-tablespaces option, mysqldump — A Database Backup Program

allow-keywords option, mysqldump — A Database Backup Program

character-sets-dir option, mysqldump — A Database Backup Program

comments option, mysqldump — A Database Backup Program

compact option, mysqldump — A Database Backup Program

compatible option, mysqldump — A Database Backup Program

complete-insert option, mysqldump — A Database Backup Program

compress option, mysqldump — A Database Backup Program

create-options option, mysqldump — A Database Backup Program

databases option, mysqldump — A Database Backup Program

debug option, mysqldump — A Database Backup Program

debug-check option, mysqldump — A Database Backup Program

debug-info option, mysqldump — A Database Backup Program

default-character-set option, mysqldump — A Database Backup Program

delayed-insert option, mysqldump — A Database Backup Program

delete-master-logs option, mysqldump — A Database Backup Program

disable-keys option, mysqldump — A Database Backup Program

dump-date option, mysqldump — A Database Backup Program

events option, mysqldump — A Database Backup Program

extended-insert option, mysqldump — A Database Backup Program

fields-enclosed-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

fields-escaped-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

fields-optionally-enclosed-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

fields-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

first-slave option, mysqldump — A Database Backup Program

flush-logs option, mysqldump — A Database Backup Program

flush-privileges option, mysqldump — A Database Backup Program

force option, mysqldump — A Database Backup Program

help option, mysqldump — A Database Backup Program

hex-blob option, mysqldump — A Database Backup Program

host option, mysqldump — A Database Backup Program

ignore-table option, mysqldump — A Database Backup Program

insert-ignore option, mysqldump — A Database Backup Program

lines-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program

lock-all-tables option, mysqldump — A Database Backup Program

lock-tables option, mysqldump — A Database Backup Program

log-error option, mysqldump — A Database Backup Program

master-data option, mysqldump — A Database Backup Program

no-autocommit option, mysqldump — A Database Backup Program

no-create-db option, mysqldump — A Database Backup Program

no-create-info option, mysqldump — A Database Backup Program

no-data option, mysqldump — A Database Backup Program

no-set-names option, mysqldump — A Database Backup Program

no-tablespaces option, mysqldump — A Database Backup Program

opt option, mysqldump — A Database Backup Program

order-by-primary option, mysqldump — A Database Backup Program

password option, mysqldump — A Database Backup Program

pipe option, mysqldump — A Database Backup Program

port option, mysqldump — A Database Backup Program

problems, mysqldump — A Database Backup Program, Restrictions on Views

protocol option, mysqldump — A Database Backup Program

quick option, mysqldump — A Database Backup Program

quote-names option, mysqldump — A Database Backup Program

replace option, mysqldump — A Database Backup Program

result-file option, mysqldump — A Database Backup Program

routines option, mysqldump — A Database Backup Program

set-charset option, mysqldump — A Database Backup Program

single-transaction option, mysqldump — A Database Backup Program

skip-comments option, mysqldump — A Database Backup Program

skip-opt option, mysqldump — A Database Backup Program

socket option, mysqldump — A Database Backup Program

SSL options, mysqldump — A Database Backup Program

tab option, mysqldump — A Database Backup Program

tables option, mysqldump — A Database Backup Program

triggers option, mysqldump — A Database Backup Program

tz-utc option, mysqldump — A Database Backup Program

user option, mysqldump — A Database Backup Program

using for backups, Using mysqldump for Backups

verbose option, mysqldump — A Database Backup Program

version option, mysqldump — A Database Backup Program

views, mysqldump — A Database Backup Program, Restrictions on Views

where option, mysqldump — A Database Backup Program

workarounds, mysqldump — A Database Backup Program, Restrictions on Views

xml option, mysqldump — A Database Backup Program

mysqldumpslow, Overview of MySQL Programs, mysqldumpslow — Summarize Slow Query Log Files

debug option, mysqldumpslow — Summarize Slow Query Log Files

help option, mysqldumpslow — Summarize Slow Query Log Files

verbose option, mysqldumpslow — Summarize Slow Query Log Files

mysqld_multi, Overview of MySQL Programs, mysqld_multi — Manage Multiple MySQL Servers

config-file option, mysqld_multi — Manage Multiple MySQL Servers

defaults-extra-file option, mysqld_multi — Manage Multiple MySQL Servers

defaults-file option, mysqld_multi — Manage Multiple MySQL Servers

example option, mysqld_multi — Manage Multiple MySQL Servers

help option, mysqld_multi — Manage Multiple MySQL Servers

log option, mysqld_multi — Manage Multiple MySQL Servers

mysqladmin option, mysqld_multi — Manage Multiple MySQL Servers

mysqld option, mysqld_multi — Manage Multiple MySQL Servers

no-defaults option, mysqld_multi — Manage Multiple MySQL Servers

no-log option, mysqld_multi — Manage Multiple MySQL Servers

password option, mysqld_multi — Manage Multiple MySQL Servers

silent option, mysqld_multi — Manage Multiple MySQL Servers

tcp-ip option, mysqld_multi — Manage Multiple MySQL Servers

user option, mysqld_multi — Manage Multiple MySQL Servers

verbose option, mysqld_multi — Manage Multiple MySQL Servers

version option, mysqld_multi — Manage Multiple MySQL Servers

mysqld_safe, Overview of MySQL Programs, mysqld_safe — MySQL Server Startup Script

autoclose option, mysqld_safe — MySQL Server Startup Script

basedir option, mysqld_safe — MySQL Server Startup Script

core-file-size option, mysqld_safe — MySQL Server Startup Script

datadir option, mysqld_safe — MySQL Server Startup Script

defaults-extra-file option, mysqld_safe — MySQL Server Startup Script

defaults-file option, mysqld_safe — MySQL Server Startup Script

help option, mysqld_safe — MySQL Server Startup Script

ledir option, mysqld_safe — MySQL Server Startup Script

log-error option, mysqld_safe — MySQL Server Startup Script

mysqld option, mysqld_safe — MySQL Server Startup Script

mysqld-version option, mysqld_safe — MySQL Server Startup Script

nice option, mysqld_safe — MySQL Server Startup Script

no-defaults option, mysqld_safe — MySQL Server Startup Script

open-files-limit option, mysqld_safe — MySQL Server Startup Script

pid-file option, mysqld_safe — MySQL Server Startup Script

port option, mysqld_safe — MySQL Server Startup Script

skip-kill-mysqld option, mysqld_safe — MySQL Server Startup Script

skip-syslog option, mysqld_safe — MySQL Server Startup Script

socket option, mysqld_safe — MySQL Server Startup Script

syslog option, mysqld_safe — MySQL Server Startup Script

syslog-tag option, mysqld_safe — MySQL Server Startup Script

timezone option, mysqld_safe — MySQL Server Startup Script

user option, mysqld_safe — MySQL Server Startup Script

mysqlhotcopy, Overview of MySQL Programs, mysqlhotcopy — A Database Backup Program

addtodest option, mysqlhotcopy — A Database Backup Program

allowold option, mysqlhotcopy — A Database Backup Program

checkpoint option, mysqlhotcopy — A Database Backup Program

chroot option, mysqlhotcopy — A Database Backup Program

debug option, mysqlhotcopy — A Database Backup Program

dryrun option, mysqlhotcopy — A Database Backup Program

flushlog option, mysqlhotcopy — A Database Backup Program

help option, mysqlhotcopy — A Database Backup Program

host option, mysqlhotcopy — A Database Backup Program

keepold option, mysqlhotcopy — A Database Backup Program

method option, mysqlhotcopy — A Database Backup Program

noindices option, mysqlhotcopy — A Database Backup Program

password option, mysqlhotcopy — A Database Backup Program

port option, mysqlhotcopy — A Database Backup Program

quiet option, mysqlhotcopy — A Database Backup Program

record_log_pos option, mysqlhotcopy — A Database Backup Program

regexp option, mysqlhotcopy — A Database Backup Program

resetmaster option, mysqlhotcopy — A Database Backup Program

resetslave option, mysqlhotcopy — A Database Backup Program

socket option, mysqlhotcopy — A Database Backup Program

suffix option, mysqlhotcopy — A Database Backup Program

tmpdir option, mysqlhotcopy — A Database Backup Program

user option, mysqlhotcopy — A Database Backup Program

mysqlimport, Copying MySQL Databases to Another Machine, Overview of MySQL Programs, mysqlimport — A Data Import Program, LOAD DATA INFILE Syntax

character-sets-dir option, mysqlimport — A Data Import Program

columns option, mysqlimport — A Data Import Program

compress option, mysqlimport — A Data Import Program

debug option, mysqlimport — A Data Import Program

debug-check option, mysqlimport — A Data Import Program

debug-info option, mysqlimport — A Data Import Program

default-character-set option, mysqlimport — A Data Import Program

delete option, mysqlimport — A Data Import Program

force option, mysqlimport — A Data Import Program

help option, mysqlimport — A Data Import Program

host option, mysqlimport — A Data Import Program

ignore option, mysqlimport — A Data Import Program

ignore-lines option, mysqlimport — A Data Import Program

local option, mysqlimport — A Data Import Program

lock-tables option, mysqlimport — A Data Import Program

low-priority option, mysqlimport — A Data Import Program

password option, mysqlimport — A Data Import Program

pipe option, mysqlimport — A Data Import Program

port option, mysqlimport — A Data Import Program

protocol option, mysqlimport — A Data Import Program

replace option, mysqlimport — A Data Import Program

silent option, mysqlimport — A Data Import Program

socket option, mysqlimport — A Data Import Program

SSL options, mysqlimport — A Data Import Program

use-threads option, mysqlimport — A Data Import Program

user option, mysqlimport — A Data Import Program

verbose option, mysqlimport — A Data Import Program

version option, mysqlimport — A Data Import Program

mysqlmanager, Overview of MySQL Programs, mysqlmanager — The MySQL Instance Manager

add-user option, MySQL Instance Manager Command Options

angel-pid-file option, MySQL Instance Manager Command Options

bind-address option, MySQL Instance Manager Command Options

check-password-file option, MySQL Instance Manager Command Options

clean-password-file option, MySQL Instance Manager Command Options

debug option, MySQL Instance Manager Command Options

default-mysqld-path option, MySQL Instance Manager Command Options

defaults-file option, MySQL Instance Manager Command Options

drop-user option, MySQL Instance Manager Command Options

edit-user option, MySQL Instance Manager Command Options

help option, MySQL Instance Manager Command Options

install option, MySQL Instance Manager Command Options

list-users option, MySQL Instance Manager Command Options

log option, MySQL Instance Manager Command Options

monitoring-interval option, MySQL Instance Manager Command Options

mysqld-safe-compatible option, MySQL Instance Manager Command Options

password option, MySQL Instance Manager Command Options

password-file option, MySQL Instance Manager Command Options

pid-file option, MySQL Instance Manager Command Options

port option, MySQL Instance Manager Command Options

print-defaults option, MySQL Instance Manager Command Options

print-password-line option, MySQL Instance Manager Command Options

remove option, MySQL Instance Manager Command Options

run-as-service option, MySQL Instance Manager Command Options

socket option, MySQL Instance Manager Command Options

standalone option, MySQL Instance Manager Command Options

user option, MySQL Instance Manager Command Options

username option, MySQL Instance Manager Command Options

version option, MySQL Instance Manager Command Options

wait-timeout option, MySQL Instance Manager Command Options

mysqlshow, Overview of MySQL Programs, mysqlshow — Display Database, Table, and Column Information

character-sets-dir option, mysqlshow — Display Database, Table, and Column Information

compress option, mysqlshow — Display Database, Table, and Column Information

count option, mysqlshow — Display Database, Table, and Column Information

debug option, mysqlshow — Display Database, Table, and Column Information

debug-check option, mysqlshow — Display Database, Table, and Column Information

debug-info option, mysqlshow — Display Database, Table, and Column Information

default-character-set option, mysqlshow — Display Database, Table, and Column Information

help option, mysqlshow — Display Database, Table, and Column Information

host option, mysqlshow — Display Database, Table, and Column Information

keys option, mysqlshow — Display Database, Table, and Column Information

password option, mysqlshow — Display Database, Table, and Column Information

pipe option, mysqlshow — Display Database, Table, and Column Information

port option, mysqlshow — Display Database, Table, and Column Information

protocol option, mysqlshow — Display Database, Table, and Column Information

show-table-type option, mysqlshow — Display Database, Table, and Column Information

socket option, mysqlshow — Display Database, Table, and Column Information

SSL options, mysqlshow — Display Database, Table, and Column Information

status option, mysqlshow — Display Database, Table, and Column Information

user option, mysqlshow — Display Database, Table, and Column Information

verbose option, mysqlshow — Display Database, Table, and Column Information

version option, mysqlshow — Display Database, Table, and Column Information

mysqlslap, Overview of MySQL Programs, mysqlslap — Load Emulation Client

auto-generate-sql option, mysqlslap — Load Emulation Client

auto-generate-sql-add-autoincrement option, mysqlslap — Load Emulation Client

auto-generate-sql-execute-number option,