Index

Index
Prev

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

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

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

--help option

MySQL Cluster programs, Options Common to MySQL Cluster Programs

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

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

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

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

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

--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 (MySQL Cluster), Options Common to MySQL Cluster Programs

-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, Causes of Access-Denied Errors, End-User Guidelines for Password Security, 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 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

<errortext>Table is full</errortext> error

MySQL Cluster, MySQL 5.1 FAQ — MySQL Cluster

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

[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

[SQL] (MySQL Cluster), MySQL Cluster SQL Node and API Node 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 tar.gz Packages on Other Unix-Like Systems, 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, Problems with Column Aliases

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

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 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, Session System Variables

automatic_sp_privileges system variable, Server System Variables

AUTO_INCREMENT, Using AUTO_INCREMENT, Numeric Types

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

auto_increment_increment system variable, 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, Literal Values

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

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, Session System Variables

BIN(), String Functions

BINARY, Cast Functions and Operators

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

binary distributions, MySQL Binaries Compiled by Sun Microsystems, Inc.

installing, Installing MySQL from tar.gz Packages on Other Unix-Like Systems
on Linux, Linux Binary Distribution Notes

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_format system variable, Binary Log Options and Variables

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

(see also 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

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

block-search option

myisamchk, Other myisamchk Options

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

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, Unified Changelogs — MySQL Cluster NDB 6.X and 7.X

changes to privileges, When Privilege Changes Take Effect

changing

column, ALTER TABLE Syntax
column order, How to Change the Order of Columns in a Table
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 sets, Typical configure Options, The Character Set Used for Data and Sorting

adding, Adding a New Character Set
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 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, Solaris Notes

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

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), MySQL Cluster Replication Schema and Tables

(see also 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

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

changing, How to Change the Order of Columns in a Table
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, Program Options for ndbd and ndbmtd
ndb_mgm, ndb_mgm — The MySQL Cluster Management Client, Program Options for ndb_mgm
ndb_mgmd, ndb_mgmd — The MySQL Cluster Management Server Daemon, Program Options for ndb_mgmd

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 tar.gz Packages on Other Unix-Like Systems

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

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

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 During a Master Crash

crash-me, The MySQL Benchmark Suite

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

CRC32(), Mathematical Functions

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

customers

of MySQL, What We Have Used MySQL For

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

character sets, The Character Set Used for Data and Sorting
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

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

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

debugging

client, Debugging a MySQL Client
server, Debugging a MySQL Server

debugging support, Typical configure Options

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

DRBD, 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-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, Linux Source Distribution Notes, 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 tar.gz Packages on Other Unix-Like Systems, 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, Solaris Notes
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

error_count session variable, Session System Variables

ERROR_FOR_DIVISION_BY_ZERO SQL mode, Server SQL Modes

escape (\\), Strings

escape characters, Literal Values

estimating

query performance, Estimating Query Performance

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 restrictions, Restrictions on Stored Routines, Triggers, and Events

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

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, Getting Information About a Table
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

EXISTS

with subqueries, EXISTS and 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-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

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

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

Future development of MySQL Cluster, MySQL Cluster Development Roadmap

G

[index top]

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(), 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_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

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

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, Session 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, and SOME

include option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

increasing

performance, Replication FAQ

increasing with replication

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

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

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
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, Solaris Notes
transaction isolation levels, The InnoDB Transaction Model and Locking

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, Session 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 tar.gz Packages on Other Unix-Like Systems
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 MySQL Cluster Software

installing 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

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

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, Session 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, Linux Source Distribution Notes, 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

libraries

list of, Libraries used by and included with MySQL

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

Linux

binary distribution, Linux Binary Distribution Notes
source distribution, Linux Source Distribution Notes

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

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

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 (MySQL Cluster configuration parameter), Defining MySQL Cluster Data Nodes

LogLevelCongestion, Defining MySQL Cluster Data Nodes

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

LogLevelError, Defining MySQL Cluster Data Nodes

LogLevelInfo, Defining MySQL Cluster Data Nodes

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

LogLevelShutdown, Defining MySQL Cluster Data Nodes

LogLevelStartup, Defining MySQL Cluster Data Nodes

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

logs

server, MySQL Server Logs

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

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

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

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 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, Limiting Account Resources

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, Limiting Account Resources

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, Limiting Account Resources

MAX_USER_CONNECTIONS, Limiting Account Resources

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

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

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, Typical configure Options, 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, Getting Information About a Table
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_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 Types

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

"quick" configuration, Quick Test Setup of MySQL Cluster

<errortext>Table is full</errortext> error, MySQL 5.1 FAQ — MySQL Cluster

<foreignphrase>vs</foreignphrase> replication, MySQL 5.1 FAQ — 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, Program Options for ndbd and ndbmtd, Program Options for ndb_mgmd, Program Options for ndb_mgm, Program Options for ndbd_redo_log_reader, Commands in the MySQL Cluster Management Client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

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

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, Program Options for ndbd and ndbmtd, Program Options for ndb_mgmd, Program Options for ndb_mgm, Commands in the MySQL Cluster Management Client

compiling from source, Building MySQL Cluster from Source Code

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

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

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 new in MySQL 5.1, Features Added in MySQL 5.1 Cluster

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, Installing MySQL Cluster Software

interconnects, Using High-Speed Interconnects with MySQL Cluster

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

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, Program Options for ndb_mgm

mgmd, Options Common to MySQL Cluster Programs

mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon, Program Options for ndb_mgmd

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, Program Options for ndbd and ndbmtd, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client

ndbd_redo_log_reader, Program Options for ndbd_redo_log_reader

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

ndb_config, Program Options for ndb_config

ndb_error_reporter, Program Options for ndb_error_reporter

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_restore, Program Options for ndb_restore

ndb_show_tables, Program Options for ndb_show_tables

ndb_size.pl, Program Options for ndb_size.pl

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

programs, Program Options for ndbd_redo_log_reader, Program Options for ndb_config, Program Options for ndb_error_reporter, Program Options for ndb_restore, Program Options for ndb_show_tables, Program Options for ndb_size.pl

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

terminology, MySQL Cluster Glossary

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 in a virtual machine, MySQL 5.1 FAQ — MySQL Cluster

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

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 Glossary, MySQL Cluster Glossary

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

MySQL Cluster in MySQL 5.1, MySQL Cluster Development Roadmap

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 and MySQL Cluster NDB 6.x
binary logging, Issues Exclusive to MySQL Cluster
character sets, Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.x
CREATE TABLE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.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 and MySQL Cluster NDB 6.x
memory usage and transaction handling, Limits Relating to Transaction Handling in MySQL Cluster
multiple data nodes, Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.x, Features Added in MySQL Cluster NDB 6.2
multiple management servers, Limitations Relating to Multiple MySQL Cluster Nodes, Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.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 and MySQL Cluster NDB 6.x
resolved in current version from previous versions, Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.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 Roadmap

MySQL Cluster processes, MySQL Cluster Programs

MySQL Cluster programs, MySQL Cluster Programs

MySQL Cluster replication, MySQL Cluster Replication, Using Two Replication Channels for 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 DDL, 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
backups, MySQL Cluster Backups With MySQL Cluster Replication, MySQL Cluster Replication — Automating Synchronization of the Replication Slave to the Master Binary Log
concepts, MySQL Cluster Replication — Abbreviations and Symbols, MySQL Cluster Replication — Assumptions and General Requirements
failover, Implementing Failover with MySQL Cluster Replication
known issues, Known Issues in MySQL Cluster Replication
loss of connection, Known Issues in MySQL Cluster Replication
preparing, Preparing the MySQL Cluster for Replication
reset-slave.pl backup automation script, MySQL Cluster Replication — Automating Synchronization of the Replication Slave to the Master Binary Log
restoring from backups, 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
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 System mysql 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 (see 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
write-binlog 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

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
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-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
pid-file option, 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-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-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
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
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, mysqlslap — Load Emulation Client
auto-generate-sql-guid-primary option, mysqlslap — Load Emulation Client
auto-generate-sql-load-type option, mysqlslap — Load Emulation Client
auto-generate-sql-secondary-indexes option, mysqlslap — Load Emulation Client
auto-generate-sql-unique-query-number option, mysqlslap — Load Emulation Client
auto-generate-sql-unique-write-number option, mysqlslap — Load Emulation Client
auto-generate-sql-write-number option, mysqlslap — Load Emulation Client
commit option, mysqlslap — Load Emulation Client
compress option, mysqlslap — Load Emulation Client
concurrency option, mysqlslap — Load Emulation Client
create option, mysqlslap — Load Emulation Client
create-schema option, mysqlslap — Load Emulation Client
csv option, mysqlslap — Load Emulation Client
debug option, mysqlslap — Load Emulation Client
debug-check option, mysqlslap — Load Emulation Client
debug-info option, mysqlslap — Load Emulation Client
delimiter option, mysqlslap — Load Emulation Client
detach option, mysqlslap — Load Emulation Client
engine option, mysqlslap — Load Emulation Client
help option, mysqlslap — Load Emulation Client
host option, mysqlslap — Load Emulation Client
iterations option, mysqlslap — Load Emulation Client
lock-directory option, mysqlslap — Load Emulation Client
number-char-cols option, mysqlslap — Load Emulation Client
number-int-cols option, mysqlslap — Load Emulation Client
number-of-queries option, mysqlslap — Load Emulation Client
only-print option, mysqlslap — Load Emulation Client
password option, mysqlslap — Load Emulation Client
pipe option, mysqlslap — Load Emulation Client
port option, mysqlslap — Load Emulation Client
post-query option, mysqlslap — Load Emulation Client
post-system option, mysqlslap — Load Emulation Client
pre-query option, mysqlslap — Load Emulation Client
pre-system option, mysqlslap — Load Emulation Client
preserve-schema option, mysqlslap — Load Emulation Client
protocol option, mysqlslap — Load Emulation Client
query option, mysqlslap — Load Emulation Client
shared-memory-base-name option, mysqlslap — Load Emulation Client
silent option, mysqlslap — Load Emulation Client
slave option, mysqlslap — Load Emulation Client
socket option, mysqlslap — Load Emulation Client
SSL options, mysqlslap — Load Emulation Client
use-threads option, mysqlslap — Load Emulation Client
user option, mysqlslap — Load Emulation Client
verbose option, mysqlslap — Load Emulation Client
version option, mysqlslap — Load Emulation Client

mysqltest

MySQL Test Suite, MySQL Test Suite

mysql_affected_rows(), mysql_affected_rows()

mysql_autocommit(), mysql_autocommit()

MYSQL_BIND C type, C API Prepared Statement Data types

mysql_change_user(), mysql_change_user()

mysql_character_set_name(), mysql_character_set_name()

mysql_close(), mysql_close()

mysql_commit(), mysql_commit()

mysql_config, mysql_config — Get Compile Options for Compiling Clients

cflags option, mysql_config — Get Compile Options for Compiling Clients
embedded option, mysql_config — Get Compile Options for Compiling Clients
include option, mysql_config — Get Compile Options for Compiling Clients
libmysqld-libs option, mysql_config — Get Compile Options for Compiling Clients
libs option, mysql_config — Get Compile Options for Compiling Clients
libs_r option, mysql_config — Get Compile Options for Compiling Clients
plugindir option, mysql_config — Get Compile Options for Compiling Clients
port option, mysql_config — Get Compile Options for Compiling Clients
socket option, mysql_config — Get Compile Options for Compiling Clients
version option, mysql_config — Get Compile Options for Compiling Clients

mysql_connect(), mysql_connect()

mysql_convert_table_format, Overview of MySQL Programs, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine

force option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
help option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
host option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
password option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
port option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
socket option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
type option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
user option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
verbose option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
version option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine

mysql_create_db(), mysql_create_db()

mysql_data_seek(), mysql_data_seek()

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

mysql_debug(), mysql_debug()

mysql_drop_db(), mysql_drop_db()

mysql_dump_debug_info(), mysql_dump_debug_info()

mysql_eof(), mysql_eof()

mysql_errno(), mysql_errno()

mysql_error(), mysql_error()

mysql_escape_string(), mysql_escape_string()

mysql_fetch_field(), mysql_fetch_field()

mysql_fetch_fields(), mysql_fetch_fields()

mysql_fetch_field_direct(), mysql_fetch_field_direct()

mysql_fetch_lengths(), mysql_fetch_lengths()

mysql_fetch_row(), mysql_fetch_row()

MYSQL_FIELD C type, C API Data Types

mysql_field_count(), mysql_field_count(), mysql_num_fields()

MYSQL_FIELD_OFFSET C type, C API Data Types

mysql_field_seek(), mysql_field_seek()

mysql_field_tell(), mysql_field_tell()

mysql_find_rows, Overview of MySQL Programs, mysql_find_rows — Extract SQL Statements from Files

help option, mysql_find_rows — Extract SQL Statements from Files
regexp option, mysql_find_rows — Extract SQL Statements from Files
rows option, mysql_find_rows — Extract SQL Statements from Files
skip-use-db option, mysql_find_rows — Extract SQL Statements from Files
start_row option, mysql_find_rows — Extract SQL Statements from Files

mysql_fix_extensions, Overview of MySQL Programs, mysql_fix_extensions — Normalize Table File Name Extensions

mysql_fix_privilege_tables, Overview of MySQL Programs, mysql_fix_privilege_tables — Upgrade MySQL System Tables

mysql_free_result(), mysql_free_result()

mysql_get_character_set_info(), mysql_get_character_set_info()

mysql_get_client_info(), mysql_get_client_info()

mysql_get_client_version(), mysql_get_client_version()

mysql_get_host_info(), mysql_get_host_info()

mysql_get_proto_info(), mysql_get_proto_info()

mysql_get_server_info(), mysql_get_server_info()

mysql_get_server_version(), mysql_get_server_version()

mysql_get_ssl_cipher(), mysql_get_ssl_cipher()

MYSQL_GROUP_SUFFIX environment variable, Environment Variables

mysql_hex_string(), mysql_hex_string()

MYSQL_HISTFILE environment variable, Environment Variables, mysql Options

MYSQL_HOME environment variable, Environment Variables

MYSQL_HOST environment variable, Environment Variables, Connecting to the MySQL Server

mysql_info(), ALTER TABLE Syntax, INSERT Syntax, LOAD DATA INFILE Syntax, UPDATE Syntax, mysql_info()

mysql_init(), mysql_init()

mysql_insert_id(), Transactions and Atomic Operations, INSERT Syntax, mysql_insert_id()

mysql_install_db, Problems Running mysql_install_db, Overview of MySQL Programs, mysql_install_db — Initialize MySQL Data Directory

basedir option, mysql_install_db — Initialize MySQL Data Directory
datadir option, mysql_install_db — Initialize MySQL Data Directory
force option, mysql_install_db — Initialize MySQL Data Directory
ldata option, mysql_install_db — Initialize MySQL Data Directory
rpm option, mysql_install_db — Initialize MySQL Data Directory
skip-name-resolve option, mysql_install_db — Initialize MySQL Data Directory
srcdir option, mysql_install_db — Initialize MySQL Data Directory
user option, mysql_install_db — Initialize MySQL Data Directory
verbose option, mysql_install_db — Initialize MySQL Data Directory
windows option, mysql_install_db — Initialize MySQL Data Directory

mysql_kill(), mysql_kill()

mysql_library_end(), mysql_library_end()

mysql_library_init(), mysql_library_init()

mysql_list_dbs(), mysql_list_dbs()

mysql_list_fields(), mysql_list_fields()

mysql_list_processes(), mysql_list_processes()

mysql_list_tables(), mysql_list_tables()

mysql_more_results(), mysql_more_results()

mysql_next_result(), mysql_next_result()

mysql_num_fields(), mysql_num_fields()

mysql_num_rows(), mysql_num_rows()

mysql_options(), mysql_options()

mysql_ping(), mysql_ping()

MYSQL_PS1 environment variable, Environment Variables

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

mysql_query(), mysql_query(), Common Questions and Problems When Using the C API

mysql_real_connect(), mysql_real_connect()

mysql_real_escape_string(), Strings, mysql_real_escape_string()

mysql_real_query(), mysql_real_query()

mysql_refresh(), mysql_refresh()

mysql_reload(), mysql_reload()

MYSQL_RES C type, C API Data Types

mysql_rollback(), mysql_rollback()

MYSQL_ROW C type, C API Data Types

mysql_row_seek(), mysql_row_seek()

mysql_row_tell(), mysql_row_tell()

mysql_secure_installation, Overview of MySQL Programs, mysql_secure_installation — Improve MySQL Installation Security

mysql_select_db(), mysql_select_db()

mysql_server_end(), mysql_server_end()

mysql_server_init(), mysql_server_init()

mysql_setpermission, Overview of MySQL Programs, mysql_setpermission — Interactively Set Permissions in Grant Tables

help option, mysql_setpermission — Interactively Set Permissions in Grant Tables
host option, mysql_setpermission — Interactively Set Permissions in Grant Tables
password option, mysql_setpermission — Interactively Set Permissions in Grant Tables
port option, mysql_setpermission — Interactively Set Permissions in Grant Tables
socket option, mysql_setpermission — Interactively Set Permissions in Grant Tables
user option, mysql_setpermission — Interactively Set Permissions in Grant Tables

mysql_set_character_set(), mysql_set_character_set()

mysql_set_local_infile_default(), mysql_set_local_infile_default()

mysql_set_server_option(), mysql_set_server_option()

mysql_shutdown(), mysql_shutdown()

mysql_sqlstate(), mysql_sqlstate()

mysql_ssl_set(), mysql_ssl_set()

mysql_stat(), mysql_stat()

MYSQL_STMT C type, C API Prepared Statement Data types

mysql_stmt_affected_rows(), mysql_stmt_affected_rows()

mysql_stmt_attr_get(), mysql_stmt_attr_get()

mysql_stmt_attr_set(), mysql_stmt_attr_set()

mysql_stmt_bind_param(), mysql_stmt_bind_param()

mysql_stmt_bind_result(), mysql_stmt_bind_result()

mysql_stmt_close(), mysql_stmt_close()

mysql_stmt_data_seek(), mysql_stmt_data_seek()

mysql_stmt_errno(), mysql_stmt_errno()

mysql_stmt_error(), mysql_stmt_error()

mysql_stmt_execute(), mysql_stmt_execute()

mysql_stmt_fetch(), mysql_stmt_fetch()

mysql_stmt_fetch_column(), mysql_stmt_fetch_column()

mysql_stmt_field_count(), mysql_stmt_field_count()

mysql_stmt_free_result(), mysql_stmt_free_result()

mysql_stmt_init(), mysql_stmt_init()

mysql_stmt_insert_id(), mysql_stmt_insert_id()

mysql_stmt_num_rows(), mysql_stmt_num_rows()

mysql_stmt_param_count(), mysql_stmt_param_count()

mysql_stmt_param_metadata(), mysql_stmt_param_metadata()

mysql_stmt_prepare(), mysql_stmt_prepare()

mysql_stmt_reset(), mysql_stmt_reset()

mysql_stmt_result_metadata, mysql_stmt_result_metadata()

mysql_stmt_row_seek(), mysql_stmt_row_seek()

mysql_stmt_row_tell(), mysql_stmt_row_tell()

mysql_stmt_send_long_data(), mysql_stmt_send_long_data()

mysql_stmt_sqlstate(), mysql_stmt_sqlstate()

mysql_stmt_store_result(), mysql_stmt_store_result()

mysql_store_result(), mysql_store_result(), Common Questions and Problems When Using the C API

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

mysql_thread_end(), mysql_thread_end()

mysql_thread_id(), mysql_thread_id()

mysql_thread_init(), mysql_thread_init()

mysql_thread_safe(), mysql_thread_safe()

MYSQL_TIME C type, C API Prepared Statement Data types

mysql_tzinfo_to_sql, Overview of MySQL Programs, mysql_tzinfo_to_sql — Load the Time Zone Tables

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

mysql_upgrade, Overview of MySQL Programs, mysql_upgrade — Check Tables for MySQL Upgrade, Causes of Access-Denied Errors

basedir option, mysql_upgrade — Check Tables for MySQL Upgrade
datadir option, mysql_upgrade — Check Tables for MySQL Upgrade
debug-check option, mysql_upgrade — Check Tables for MySQL Upgrade
debug-info option, mysql_upgrade — Check Tables for MySQL Upgrade
force option, mysql_upgrade — Check Tables for MySQL Upgrade
help option, mysql_upgrade — Check Tables for MySQL Upgrade
mysql_upgrade_info file, mysql_upgrade — Check Tables for MySQL Upgrade
tmpdir option, mysql_upgrade — Check Tables for MySQL Upgrade
user option, mysql_upgrade — Check Tables for MySQL Upgrade
verbose option, mysql_upgrade — Check Tables for MySQL Upgrade

mysql_upgrade_info file

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

mysql_use_result(), mysql_use_result()

mysql_waitpid, Overview of MySQL Programs, mysql_waitpid — Kill Process and Wait for Its Termination

help option, mysql_waitpid — Kill Process and Wait for Its Termination
verbose option, mysql_waitpid — Kill Process and Wait for Its Termination
version option, mysql_waitpid — Kill Process and Wait for Its Termination

mysql_warning_count(), mysql_warning_count()

mysql_zap, Overview of MySQL Programs, mysql_zap — Kill Processes That Match a Pattern

my_bool C type, C API Data Types

my_bool values

printing, C API Data Types

my_init(), my_init()

my_print_defaults, Overview of MySQL Programs, my_print_defaults — Display Options from Option Files

config-file option, my_print_defaults — Display Options from Option Files
debug option, my_print_defaults — Display Options from Option Files
defaults-extra-file option, my_print_defaults — Display Options from Option Files
defaults-file option, my_print_defaults — Display Options from Option Files
defaults-group-suffix option, my_print_defaults — Display Options from Option Files
extra-file option, my_print_defaults — Display Options from Option Files
help option, my_print_defaults — Display Options from Option Files
no-defaults option, my_print_defaults — Display Options from Option Files
verbose option, my_print_defaults — Display Options from Option Files
version option, my_print_defaults — Display Options from Option Files

my_ulonglong C type, C API Data Types

my_ulonglong values

printing, C API Data Types

N

[index top]

named pipes, Selecting a MySQL Server Type, Testing The MySQL Installation

named-commands option

mysql, mysql Options

named_pipe system variable, Server System Variables

names, Schema Object Names

case sensitivity, Identifier Case Sensitivity
variables, User-Defined Variables

NAME_CONST(), Miscellaneous Functions, Binary Logging of Stored Programs

name_file option

comp_err, comp_err — Compile MySQL Error Message File

naming

releases of MySQL, Choosing Which Version of MySQL to Install

NATIONAL CHAR data type, Overview of String Types

NATIONAL VARCHAR data type, Overview of String Types

native backup and restore

backup identifiers, Using The MySQL Cluster Management Client to Create a Backup

native functions

adding, Adding a New Native Function

native thread support, Operating Systems Supported by MySQL Community Server

NATURAL LEFT JOIN, JOIN Syntax

NATURAL LEFT OUTER JOIN, JOIN Syntax

NATURAL RIGHT JOIN, JOIN Syntax

NATURAL RIGHT OUTER JOIN, JOIN Syntax

NCHAR data type, Overview of String Types

NDB, MySQL 5.1 FAQ — MySQL Cluster

ndb option

perror, perror — Explain Error Codes

NDB storage engine (see MySQL Cluster)

FAQ, MySQL 5.1 FAQ — MySQL Cluster

NDB tables

and MySQL root user, MySQL Cluster and MySQL Privileges

NDB utilities

security issues, MySQL Cluster and MySQL Security Procedures

ndb-batch-size option

mysqld, mysqld Command Options for MySQL Cluster

ndb-cluster-connection-pool option

mysqld, mysqld Command Options for MySQL Cluster

ndb-connectstring option

mysqld, mysqld Command Options for MySQL Cluster
ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

ndb-nodeid option

mysqld, mysqld Command Options for MySQL Cluster

NDBCLUSTER, MySQL 5.1 FAQ — MySQL Cluster

ndbcluster option

mysqld, mysqld Command Options for MySQL Cluster

NDBCLUSTER storage engine (see MySQL Cluster)

ndbd, MySQL Cluster Programs, ndbd — The MySQL Cluster Data Node Daemon

ndbd (MySQL Cluster)

defined, MySQL Cluster Core Concepts

(see also data node (MySQL Cluster))

ndbd_redo_log_reader, ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log, Program Options for ndbd_redo_log_reader

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

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

ndb_apply_status table (MySQL Cluster replication), MySQL Cluster Replication Schema and Tables, Implementing Failover with MySQL Cluster Replication

(see also MySQL Cluster replication)

ndb_binlog_index table (MySQL Cluster replication), MySQL Cluster Replication Schema and Tables, Implementing Failover with MySQL Cluster Replication

(see also MySQL Cluster replication)

ndb_config, MySQL Cluster Programs, ndb_config — Extract MySQL Cluster Configuration Information, Program Options for ndb_config

config-file option, ndb_config — Extract MySQL Cluster Configuration Information
configinfo option, ndb_config — Extract MySQL Cluster Configuration Information
fields option, ndb_config — Extract MySQL Cluster Configuration Information
host option, ndb_config — Extract MySQL Cluster Configuration Information
id option, ndb_config — Extract MySQL Cluster Configuration Information
ndb-connectstring option, ndb_config — Extract MySQL Cluster Configuration Information
nodeid option, ndb_config — Extract MySQL Cluster Configuration Information
nodes option, ndb_config — Extract MySQL Cluster Configuration Information
query option, ndb_config — Extract MySQL Cluster Configuration Information
rows option, ndb_config — Extract MySQL Cluster Configuration Information
type option, ndb_config — Extract MySQL Cluster Configuration Information
usage option, ndb_config — Extract MySQL Cluster Configuration Information
version option, ndb_config — Extract MySQL Cluster Configuration Information
xml option, ndb_config — Extract MySQL Cluster Configuration Information

ndb_cpcd, MySQL Cluster Programs, ndb_cpcd — Automate Testing for NDB Development

ndb_delete_all, MySQL Cluster Programs, ndb_delete_all — Delete All Rows from an NDB Table

transactional option, ndb_delete_all — Delete All Rows from an NDB Table

ndb_desc, MySQL Cluster Programs, ndb_desc — Describe NDB Tables

extra-partition-info option, ndb_desc — Describe NDB Tables

ndb_drop_index, MySQL Cluster Programs, ndb_drop_index — Drop Index from an NDB Table

ndb_drop_table, MySQL Cluster Programs, ndb_drop_table — Drop an NDB Table

ndb_error_reporter, MySQL Cluster Programs, ndb_error_reporter — NDB Error-Reporting Utility, Program Options for ndb_error_reporter

ndb_mgm, MySQL Cluster Programs, ndb_mgm — The MySQL Cluster Management Client (see mgm)

ndb_mgm (MySQL Cluster management node client), Initial Startup of MySQL Cluster

ndb_mgmd, MySQL Cluster Programs (see mgmd)

ndb_mgmd (MySQL Cluster process), ndb_mgmd — The MySQL Cluster Management Server Daemon

ndb_mgmd (MySQL Cluster)

defined, MySQL Cluster Core Concepts

(see also management node (MySQL Cluster))

ndb_print_backup_file, MySQL Cluster Programs, ndb_print_backup_file — Print NDB Backup File Contents

ndb_print_schema_file, MySQL Cluster Programs, ndb_print_schema_file — Print NDB Schema File Contents

ndb_print_sys_file, MySQL Cluster Programs, ndb_print_sys_file — Print NDB System File Contents

ndb_restore, ndb_restore — Restore a MySQL Cluster Backup, Program Options for ndb_restore

and circular replication, MySQL Cluster Replication — Multi-Master and Circular Replication
attribute promotion, ndb_restore — Restore a MySQL Cluster Backup
errors, ndb_restore — Restore a MySQL Cluster Backup

ndb_schema table (MySQL Cluster replication), MySQL Cluster Replication Schema and Tables

(see also MySQL Cluster replication)

ndb_select_all, MySQL Cluster Programs, ndb_select_all — Print Rows from an NDB Table

delimiter option, ndb_select_all — Print Rows from an NDB Table
descending option, ndb_select_all — Print Rows from an NDB Table
disk option, ndb_select_all — Print Rows from an NDB Table
gci option, ndb_select_all — Print Rows from an NDB Table
header option, ndb_select_all — Print Rows from an NDB Table
lock option, ndb_select_all — Print Rows from an NDB Table
nodata option, ndb_select_all — Print Rows from an NDB Table
order option, ndb_select_all — Print Rows from an NDB Table
rowid option, ndb_select_all — Print Rows from an NDB Table
tupscan option, ndb_select_all — Print Rows from an NDB Table
useHexFormat option, ndb_select_all — Print Rows from an NDB Table

ndb_select_count, MySQL Cluster Programs, ndb_select_count — Print Row Counts for NDB Tables

ndb_show_tables, MySQL Cluster Programs, ndb_show_tables — Display List of NDB Tables, Program Options for ndb_show_tables

loops option, ndb_show_tables — Display List of NDB Tables
parsable option, ndb_show_tables — Display List of NDB Tables
type option, ndb_show_tables — Display List of NDB Tables
unqualified option, ndb_show_tables — Display List of NDB Tables

ndb_size.pl, MySQL Cluster Programs, ndb_size.pl — NDBCLUSTER Size Requirement Estimator, Program Options for ndb_size.pl

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

ndb_waiter, MySQL Cluster Programs, ndb_waiter — Wait for MySQL Cluster to Reach a Given Status

no-contact option, ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
not-started option, ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
timeout option, ndb_waiter — Wait for MySQL Cluster to Reach a Given Status

negative values, Numbers

nested queries, Subquery Syntax

Nested-Loop join algorithm, Nested-Loop Join Algorithms

nested-loop join algorithm, Nested Join Optimization

net etiquette, Guidelines for Using the Mailing Lists

netmask notation

in account names, Specifying Account Names

NetWare, Installing MySQL on NetWare

network ports

and MySQL Cluster, MySQL Cluster Security and Networking Issues

net_buffer_length system variable, Server System Variables

net_buffer_length variable, mysql Options

net_read_timeout system variable, Server System Variables

net_retry_count system variable, Server System Variables

net_write_timeout system variable, Server System Variables

New features in MySQL Cluster, MySQL Cluster Development Roadmap

new procedures

adding, Adding New Procedures to MySQL

new system variable, Server System Variables

new users

adding, Installing MySQL from tar.gz Packages on Other Unix-Like Systems, Source Installation Overview

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

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

NFS

InnoDB, InnoDB Configuration, Restrictions on InnoDB Tables

nice option

mysqld_safe, mysqld_safe — MySQL Server Startup Script

no matching rows, Solving Problems with No Matching Rows

no-auto-rehash option

mysql, mysql Options

no-autocommit option

mysqldump, mysqldump — A Database Backup Program

no-beep option

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

no-contact option

ndb_waiter, ndb_waiter — Wait for MySQL Cluster to Reach a Given Status

no-create-db option

mysqldump, mysqldump — A Database Backup Program

no-create-info option

mysqldump, mysqldump — A Database Backup Program

no-data option

mysqldump, mysqldump — A Database Backup Program

no-debug option

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

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

no-embedded option

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

no-log option

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

no-named-commands option

mysql, mysql Options

no-pager option

mysql, mysql Options

no-set-names option

mysqldump, mysqldump — A Database Backup Program

no-symlinks option

myisamchk, myisamchk Repair Options

no-tee option

mysql, mysql Options

nodata option

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

node groups (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

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

node logs (MySQL Cluster), Event Reports Generated in MySQL Cluster

NodeGroup, Defining MySQL Cluster Data Nodes

nodeid option

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

NODERESTART Events (MySQL Cluster), MySQL Cluster Log Events

nodes option

ndb_config, ndb_config — Extract MySQL Cluster Configuration Information

noindices option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

nondelimited strings, The DATETIME, DATE, and TIMESTAMP Types

Nontransactional tables, Rollback Failure for Nontransactional Tables

NoOfDiskPagesToDiskAfterRestartACC

calculating, Configuring MySQL Cluster Parameters for Local Checkpoints

NoOfDiskPagesToDiskAfterRestartACC (DEPRECATED), Defining MySQL Cluster Data Nodes

NoOfDiskPagesToDiskAfterRestartTUP

calculating, Configuring MySQL Cluster Parameters for Local Checkpoints

NoOfDiskPagesToDiskAfterRestartTUP (DEPRECATED), Defining MySQL Cluster Data Nodes

NoOfDiskPagesToDiskDuringRestartACC (DEPRECATED), Defining MySQL Cluster Data Nodes

NoOfDiskPagesToDiskDuringRestartTUP (DEPRECATED), Defining MySQL Cluster Data Nodes

NoOfFragmentLogFiles, Defining MySQL Cluster Data Nodes

calculating, Configuring MySQL Cluster Parameters for Local Checkpoints

NoOfReplicas, Defining MySQL Cluster Data Nodes

nopager command

mysql, mysql Commands

NOT

logical, Logical Operators

NOT BETWEEN, Comparison Functions and Operators

not equal (!=), Comparison Functions and Operators

not equal (<>), Comparison Functions and Operators

NOT EXISTS

with subqueries, EXISTS and NOT EXISTS

NOT IN, Comparison Functions and Operators

NOT LIKE, String Comparison Functions

NOT NULL

constraint, Constraints on Invalid Data

NOT REGEXP, Regular Expressions

not-started option

ndb_waiter, ndb_waiter — Wait for MySQL Cluster to Reach a Given Status

notee command

mysql, mysql Commands

Novell NetWare, Installing MySQL on NetWare

NOW(), Date and Time Functions

NOWAIT (START BACKUP command), Using The MySQL Cluster Management Client to Create a Backup

nowarning command

mysql, mysql Commands

NO_AUTO_CREATE_USER SQL mode, Server SQL Modes

NO_AUTO_VALUE_ON_ZERO SQL mode, Server SQL Modes

NO_BACKSLASH_ESCAPES SQL mode, Server SQL Modes

NO_DIR_IN_CREATE SQL mode, Server SQL Modes

NO_ENGINE_SUBSTITUTION SQL mode, Server SQL Modes

NO_FIELD_OPTIONS SQL mode, Server SQL Modes

NO_KEY_OPTIONS SQL mode, Server SQL Modes

NO_TABLE_OPTIONS SQL mode, Server SQL Modes

NO_UNSIGNED_SUBTRACTION SQL mode, Server SQL Modes

NO_ZERO_DATE SQL mode, Server SQL Modes

NO_ZERO_IN_DATE SQL mode, Server SQL Modes

NUL, Strings, LOAD DATA INFILE Syntax

NULL, Working with NULL Values, Problems with NULL Values

ORDER BY, ORDER BY Optimization, SELECT Syntax
testing for null, Comparison Functions and Operators, Control Flow Functions
thread state, General Thread States

NULL value, Working with NULL Values, NULL Values

NULL values

and AUTO_INCREMENT columns, Problems with NULL Values
and indexes, CREATE TABLE Syntax
and TIMESTAMP columns, Problems with NULL Values
vs. empty values, Problems with NULL Values

NULLIF(), Control Flow Functions

number-char-cols option

mysqlslap, mysqlslap — Load Emulation Client

number-int-cols option

mysqlslap, mysqlslap — Load Emulation Client

number-of-queries option

mysqlslap, mysqlslap — Load Emulation Client

numbers, Numbers

NUMERIC data type, Overview of Numeric Types

numeric types, Data Type Storage Requirements

numeric-dump-file option

resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols

NumGeometries(), GeometryCollection Functions

NumInteriorRings(), Polygon Functions

NumPoints(), LineString Functions

NVARCHAR data type, Overview of String Types

O

[index top]

obtaining information about partitions, Obtaining Information About Partitions

Obtaining MySQL Cluster, MySQL Cluster Multi-Computer Installation

OCT(), Mathematical Functions

OCTET_LENGTH(), String Functions

ODBC, MySQL Connector/ODBC

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

ODirect, Defining MySQL Cluster Data Nodes

offset option

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

OLAP, GROUP BY Modifiers

old system variable, Server System Variables

old-passwords option

mysqld, Server Command Options, Security-Related mysqld Options

old-style-user-limits option

mysqld, Server Command Options

OLD_PASSWORD(), Encryption and Compression Functions

old_passwords system variable, Server System Variables

old_server option

mysqlaccess, mysqlaccess — Client for Checking Access Privileges

ON DUPLICATE KEY UPDATE, INSERT Syntax

one-database option

mysql, mysql Options

one-thread option

mysqld, Server Command Options

one_shot system variable, Server System Variables

online location of manual, About This Manual

only-debug option

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

only-print option

mysqlslap, mysqlslap — Load Emulation Client

ONLY_FULL_GROUP_BY

SQL mode, GROUP BY and HAVING with Hidden Columns

ONLY_FULL_GROUP_BY SQL mode, Server SQL Modes

OPEN, Cursor OPEN Statement

Open Source

defined, What is MySQL?

open tables, mysqladmin — Client for Administering a MySQL Server, How MySQL Opens and Closes Tables

open-files-limit option

mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script

OpenGIS, Introduction to MySQL Spatial Support

opening

tables, How MySQL Opens and Closes Tables

Opening master dump table

thread state, Replication Slave Connection Thread States

Opening mysql.ndb_apply_status

thread state, MySQL Cluster Thread States

Opening table

thread state, General Thread States

Opening tables

thread state, General Thread States

opens, mysqladmin — Client for Administering a MySQL Server

OpenSSL, Using SSL for Secure Connections, Using SSL Connections

open_files_limit system variable, Server System Variables

open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files

operating systems

file-size limits, The table is full
supported, Operating Systems Supported by MySQL Community Server
Windows versus Unix, MySQL on Windows Compared to MySQL on Unix

operations

arithmetic, Arithmetic Operators

operators, Functions and Operators

assignment, User-Defined Variables
cast, Arithmetic Operators, Cast Functions and Operators
logical, Logical Operators
precedence, Operator Precedence

opt option

mysqldump, mysqldump — A Database Backup Program

optimization

subquery, Optimizing IN/=ANY Subqueries
tips, Other Optimization Tips

optimizations, WHERE Clause Optimization, Index Merge Optimization

optimize option

mysqlcheck, mysqlcheck — A Table Maintenance Program

OPTIMIZE TABLE, OPTIMIZE TABLE Syntax

and partitioning, Maintenance of Partitions

optimizer

and replication, Replication and the Query Optimizer
controlling, Controlling Query Optimizer Performance

optimizer_prune_level system variable, Server System Variables

optimizer_search_depth system variable, Server System Variables

optimizer_switch system variable, Server System Variables, Using optimizer_switch to Control the Optimizer

optimizing

DISTINCT, DISTINCT Optimization
filesort, ORDER BY Optimization
GROUP BY, GROUP BY Optimization
LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization
LIMIT, LIMIT Optimization
tables, Table Optimization

option files, Using Option Files, Causes of Access-Denied Errors

option modifiers, Program Option Modifiers

options

boolean, Program Option Modifiers

command-line

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

configure, Typical configure Options

embedded server, Options with the Embedded Server

libmysqld, Options with the Embedded Server

myisamchk, myisamchk General Options

provided by MySQL, Tutorial

replication, Replication Features and Issues

OR, Searching on Two Keys, Index Merge Optimization

bitwise, Bit Functions
logical, Logical Operators

OR Index Merge optimization, Index Merge Optimization

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

ORACLE SQL mode, Server SQL Modes

ORD(), String Functions

ORDER BY, Sorting Rows, ALTER TABLE Syntax, SELECT Syntax

NULL, ORDER BY Optimization, SELECT Syntax

order option

ndb_select_all, ndb_select_all — Print Rows from an NDB Table

order-by-primary option

mysqldump, mysqldump — A Database Backup Program

OUTFILE, SELECT Syntax

out_dir option

comp_err, comp_err — Compile MySQL Error Message File

out_file option

comp_err, comp_err — Compile MySQL Error Message File

Overlaps(), Functions That Test Spatial Relationships Between Geometries

OverloadLimit, MySQL Cluster TCP/IP Connections

overview, General Information

P

[index top]

packages

list of, Packages that support MySQL

PAD_CHAR_TO_FULL_LENGTH SQL mode, Server SQL Modes

pager command

mysql, mysql Commands

pager option

mysql, mysql Options

parallel-recover option

myisamchk, myisamchk Repair Options

parameters

server, Tuning Server Parameters

parentheses ( and ), Operator Precedence

parsable option

ndb_show_tables, ndb_show_tables — Display List of NDB Tables

PARTITION, Partitioning

partition management, Partition Management

partition pruning, Partition Pruning

partitioning, Partitioning

advantages, Overview of Partitioning in MySQL
and dates, Partition Types
and foreign keys, Restrictions and Limitations on Partitioning
and FULLTEXT indexes, Restrictions and Limitations on Partitioning
and key cache, Restrictions and Limitations on Partitioning
and server SQL mode, Restrictions and Limitations on Partitioning
and subqueries, Restrictions and Limitations on Partitioning
and temporary tables, Restrictions and Limitations on Partitioning, Partitioning Keys, Primary Keys, and Unique Keys
by hash, HASH Partitioning
by key, KEY Partitioning
by linear hash, LINEAR HASH Partitioning
by linear key, KEY Partitioning
by list, LIST Partitioning
by range, RANGE Partitioning
concepts, Overview of Partitioning in MySQL
data type of partitioning key, Restrictions and Limitations on Partitioning
enabling, Partitioning
functions supported in partitioning expressions, Partitioning Limitations Relating to Functions
limitations, Restrictions and Limitations on Partitioning
operators disallowed in partitioning expressions, Restrictions and Limitations on Partitioning
operators supported in partitioning expressions, Restrictions and Limitations on Partitioning
optimization, Obtaining Information About Partitions, Partition Pruning
resources, Partitioning
storage engines (limitations), Partitioning Limitations Relating to Storage Engines
subpartitioning, Restrictions and Limitations on Partitioning
support, Partitioning
support in MySQL Cluster, Noncompliance with SQL Syntax in MySQL Cluster
types, Partition Types

Partitioning

maximum number of partitions, Restrictions and Limitations on Partitioning

partitioning information statements, Obtaining Information About Partitions

partitioning keys and primary keys, Partitioning Keys, Primary Keys, and Unique Keys

partitioning keys and unique keys, Partitioning Keys, Primary Keys, and Unique Keys

partitions

adding and dropping, Partition Management
analyzing, Maintenance of Partitions
checking, Maintenance of Partitions
managing, Partition Management
modifying, Partition Management
optimizing, Maintenance of Partitions
repairing, Maintenance of Partitions
splitting and merging, Partition Management

PARTITIONS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PARTITIONS Table

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

password

root user, Securing the Initial MySQL Accounts

password encryption

reversibility of, Encryption and Compression Functions

password 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
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
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_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables

PASSWORD(), Access Control, Stage 1: Connection Verification, Assigning Account Passwords, Encryption and Compression Functions, Ignoring user

password-file option

mysqlmanager, MySQL Instance Manager Command Options

passwords

administrator guidelines, Administrator Guidelines for Password Security
for users, User Names and Passwords
forgotten, How to Reset the Root Password
hashing, Password Hashing in MySQL
lost, How to Reset the Root Password
resetting, How to Reset the Root Password
security, The MySQL Access Privilege System, Password Security in MySQL
setting, Assigning Account Passwords, GRANT Syntax, SET PASSWORD Syntax
user guidelines, End-User Guidelines for Password Security

PATH environment variable, Installing MySQL from tar.gz Packages on Other Unix-Like Systems, Environment Variables, Invoking MySQL Programs

pattern matching, Pattern Matching, Regular Expressions

performance

benchmarks, Using Your Own Benchmarks
disk issues, Disk Issues
estimating, Estimating Query Performance
improving, Make Your Data as Small as Possible, Replication FAQ

PERIOD_ADD(), Date and Time Functions

PERIOD_DIFF(), Date and Time Functions

Perl

installing, Perl Installation Notes
installing on Windows, Installing ActiveState Perl on Windows

Perl API, MySQL Perl API

Perl DBI/DBD

installation problems, Problems Using the Perl DBI/DBD Interface

permission checks

effect on speed, Optimizing SELECT and Other Statements

perror, Overview of MySQL Programs, perror — Explain Error Codes

--ndb option, MySQL 5.1 FAQ — MySQL Cluster
he

Sections

Personal tools

Index

Index

Symbols

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P