Symbols

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

--disable option prefix, Program Option Modifiers

--enable option prefix, Program Option Modifiers

--loose option prefix, Program Option Modifiers

--maximum option prefix, Program Option Modifiers

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

--skip option prefix, Program Option Modifiers

-p option, End-User Guidelines for Password Security

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

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

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

/ (division), Arithmetic Operators

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

:= (assignment operator), Assignment Operators

:= (assignment), User-Defined Variables

< (less than), Comparison Functions and Operators

<<, Calculating Visits Per Day

<< (left shift), Bit Functions

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

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

<> (not equal), Comparison Functions and Operators

= (assignment operator), Assignment Operators

= (assignment), User-Defined Variables

= (equal), Comparison Functions and Operators

> (greater than), Comparison Functions and Operators

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

>> (right shift), Bit Functions

\" (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

, COLUMNS Partitioning

(see also list partitioning)

(see also range partitioning)

A

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

default, Securing the Initial MySQL Accounts

root, Securing the Initial MySQL Accounts

ACID, Transaction and Atomic Operation Differences, 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

adaptive hash index, Adaptive Hash Indexes, Controlling Adaptive Hash Indexing, Dynamically Changing innodb_adaptive_hash_index

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

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, Unix Postinstallation Procedures

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

administrative programs, Overview of MySQL Programs

Advisors tab, The Advisors Tab

AES_DECRYPT(), Encryption and Compression Functions

AES_ENCRYPT(), Encryption and Compression Functions

After create

thread state, General Thread States

age

calculating, Date Calculations

agent

installation, Monitor Agent Installation

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, EXPLAIN Output Format

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

and replication, Replication of Invoked Features

ALTER FUNCTION, ALTER FUNCTION Syntax

ALTER PROCEDURE, ALTER PROCEDURE Syntax

ALTER SCHEMA, ALTER DATABASE Syntax

ALTER SERVER, ALTER SERVER Syntax

ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE

ROW_FORMAT, Specifying a Table’s Row Format

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

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

Antelope file format, InnoDB File Format Management

ANY, Subqueries with ANY, IN, or SOME

Apache, Using MySQL with Apache

API's

list of, Packages that support MySQL

APIs, Connectors and APIs

Perl, MySQL Perl API

apply-slave-statements option

mysqldump, mysqldump — A Database Backup Program

approximate-value literals, Precision Math

architecture, MySQL Enterprise Monitor

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

assignment operator

:=, Assignment Operators

=, Assignment Operators

assignment operators, Assignment Operators

AsText(), Geometry Format Conversion Functions

asynchronous I/O, Asynchronous I/O on Linux

ATAN(), Mathematical Functions

ATAN2(), Mathematical Functions

attackers

security against, Making MySQL Secure Against Attackers

attribute demotion

replication, Replication of Columns Having Different Data Types

attribute promotion

replication, Replication of Columns Having Different Data Types

audit plugins, Audit Plugins

authentication plugins, Authentication Plugins

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

auto-vertical-output option

mysql, mysql Options

autocommit session variable, Server 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

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

background threads

master, Controlling the Master Thread I/O Rate, Controlling the Flushing Rate of Dirty Pages

read, Multiple Background I/O Threads

write, Multiple Background I/O Threads

backslash

escape character, Strings

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

backup option

myisamchk, myisamchk Repair Options

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

backups, Backup and Recovery

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

InnoDB, Backing Up and Recovering an InnoDB Database

with mysqldump, Using mysqldump for Backups

back_log system variable, Server System Variables

Barracuda file format, InnoDB File Format Management

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

Bazaar tree, Installing MySQL from a 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(), Information Functions

benchmarks, Using Your Own Benchmarks

benchmark suite, The MySQL Benchmark Suite

BETWEEN ... AND, Comparison Functions and Operators

big-tables option

mysqld, Server Command Options

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

BIGINT data type, Overview of Numeric Types

big_tables session variable, Server System Variables

BIN(), String Functions

BINARY, Cast Functions and Operators

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

binary distributions

installing, Installing MySQL from Generic Binaries on Unix/Linux

binary log, The Binary Log

event groups, SET GLOBAL sql_slave_skip_counter Syntax

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

mysqld, Server Command Options

mysqldump, mysqldump — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

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

BINLOG, BINLOG Syntax

Binlog Dump

thread command, Thread Command Values

BINLOG statement

mysqlbinlog output, mysqlbinlog Row Event Display

binlog-do-db option

mysqld, Binary Log Options and Variables

binlog-format option

mysqld, Server Command Options

binlog-ignore-db option

mysqld, Binary Log Options and Variables

binlog-row-event-max-size option

mysqld, Binary Log Options and Variables

binlog_cache_size system variable, Binary Log Options and Variables

binlog_direct_non_transactional_updates system variable, Binary Log Options and Variables

binlog_format system variable, Binary Log Options and Variables

binlog_stmt_cache_size system variable, Binary Log Options and Variables

BIT data type, Overview of Numeric Types

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

browsers, Supported Browsers

buffer cache, Making Buffer Cache Scan Resistant

buffer pool, The InnoDB Buffer Pool

buffer sizes

client, Connectors and APIs

mysqld server, Tuning Server Parameters

Buffer(), Spatial Operators

bug reports

criteria for, How to Report Bugs or Problems

bugs

known, Known Issues in MySQL

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

BUILD_CONFIG option

CMake, MySQL Source-Configuration Options

bulk_insert_buffer_size system variable, Server System Variables

C

C API

data types, MySQL C API

functions, C API Function Overview

linking problems, Problems Linking to the MySQL Client Library

C prepared statement API

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

type codes, C API Prepared Statement Type Codes

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

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

of replication filtering options, How Servers Evaluate Replication Filtering Rules

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, Dealing with Problems Compiling MySQL, Environment Variables

CEIL(), Mathematical Functions

CEILING(), Mathematical Functions

Centroid(), MultiPolygon Functions

CFLAGS environment variable, Dealing with Problems Compiling MySQL, Environment Variables

cflags option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

change buffering, Issues with the Insert Buffer

disabling, Controlling InnoDB Change Buffering

change history, MySQL Enterprise Monitor Change History

CHANGE MASTER TO, CHANGE MASTER TO Syntax

Change user

thread command, Thread Command Values

ChangeLog, MySQL Change History

changes

log, MySQL Change History

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

changes to privileges, When Privilege Changes Take Effect

changing

column, ALTER TABLE Syntax

field, ALTER TABLE Syntax

table, ALTER TABLE Syntax, Problems with ALTER TABLE

Changing master

thread state, Replication Slave Connection Thread States

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

CHAR data type, Overview of String Types, String Types

CHAR VARYING data type, Overview of String Types

CHAR(), String Functions

CHARACTER data type, Overview of String Types

character set repertoire, String Repertoire, The utf8 Character Set (Three-Byte UTF-8 Unicode Encoding)

Character sets, Character Set Support

character sets

adding, Adding a New Character Set

and replication, Replication and Character Sets

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

mysqlcheck, mysqlcheck — A Table Maintenance Program

checking

tables for errors, How to Check MyISAM Tables for Errors

Checking master version

thread state, Replication Slave I/O Thread States

checking permissions

thread state, General Thread States

checking privileges on cached query

thread state, Query Cache Thread States

checking query cache for query

thread state, Query Cache Thread States

Checking table

thread state, General Thread States

checkpoint option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

checksum errors, Installing MySQL on Solaris and OpenSolaris

CHECKSUM TABLE, CHECKSUM TABLE Syntax

Chinese, Japanese, Korean character sets

frequently asked questions, MySQL 5.5 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

CJK

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

CJK (Chinese, Japanese, Korean)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

clustered index

InnoDB, Clustered and Secondary Indexes

CMake

BUILD_CONFIG option, MySQL Source-Configuration Options

CMAKE_BUILD_TYPE option, MySQL Source-Configuration Options

CMAKE_INSTALL_PREFIX option, MySQL Source-Configuration Options

CPACK_MONOLITHIC_INSTALL option, MySQL Source-Configuration Options

DEFAULT_CHARSET option, MySQL Source-Configuration Options

DEFAULT_COLLATION option, MySQL Source-Configuration Options

DISABLE_GRANT_OPTIONS option, MySQL Source-Configuration Options

ENABLED_LOCAL_INFILE option, MySQL Source-Configuration Options

ENABLED_PROFILING option, MySQL Source-Configuration Options

ENABLE_DEBUG_SYNC option, MySQL Source-Configuration Options

ENABLE_DOWNLOADS option, MySQL Source-Configuration Options

ENABLE_DTRACE option, MySQL Source-Configuration Options

HAVE_EMBEDDED_PRIVILEGE_CONTROL option, MySQL Source-Configuration Options

INSTALL_BINDIR option, MySQL Source-Configuration Options

INSTALL_DOCDIR option, MySQL Source-Configuration Options

INSTALL_DOCREADMEDIR option, MySQL Source-Configuration Options

INSTALL_INCLUDEDIR option, MySQL Source-Configuration Options

INSTALL_INFODIR option, MySQL Source-Configuration Options

INSTALL_LAYOUT option, MySQL Source-Configuration Options

INSTALL_LIBDIR option, MySQL Source-Configuration Options

INSTALL_MANDIR option, MySQL Source-Configuration Options

INSTALL_MYSQLSHAREDIR option, MySQL Source-Configuration Options

INSTALL_MYSQLTESTDIR option, MySQL Source-Configuration Options

INSTALL_PLUGINDIR option, MySQL Source-Configuration Options

INSTALL_SBINDIR option, MySQL Source-Configuration Options

INSTALL_SCRIPTDIR option, MySQL Source-Configuration Options

INSTALL_SHAREDIR option, MySQL Source-Configuration Options

INSTALL_SQLBENCHDIR option, MySQL Source-Configuration Options

INSTALL_SUPPORTFILESDIR option, MySQL Source-Configuration Options

MYSQL_DATADIR option, MySQL Source-Configuration Options

MYSQL_MAINTAINER_MODE option, MySQL Source-Configuration Options

MYSQL_TCP_PORT option, MySQL Source-Configuration Options

MYSQL_UNIX_ADDR option, MySQL Source-Configuration Options

options, MySQL Source-Configuration Options

running after prior invocation, Installing MySQL from a Standard Source Distribution, Dealing with Problems Compiling MySQL

SYSCONFDIR option, MySQL Source-Configuration Options

VERSION file, MySQL Configuration and Third-Party Tools

WITH_COMMENT option, MySQL Source-Configuration Options

WITH_DEBUG option, MySQL Source-Configuration Options

WITH_EMBEDDED_SERVER option, MySQL Source-Configuration Options

WITH_EXTRA_CHARSETS option, MySQL Source-Configuration Options

WITH_LIBWRAP option, MySQL Source-Configuration Options

WITH_READLINE option, MySQL Source-Configuration Options

WITH_SSL option, MySQL Source-Configuration Options

WITH_ZLIB option, MySQL Source-Configuration Options

CMake options, MySQL Source-Configuration Options

CMakeCache.txt file, Dealing with Problems Compiling MySQL

CMAKE_BUILD_TYPE option

CMake, MySQL Source-Configuration Options

CMAKE_INSTALL_PREFIX option

CMake, MySQL Source-Configuration Options

COALESCE(), Comparison Functions and Operators

COERCIBILITY(), Information Functions

ColdFusion, Using Connector/ODBC with ColdFusion

collating

strings, String Collating Support

collation

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

INFORMATION_SCHEMA, Collation and INFORMATION_SCHEMA Searches

collation names, Collation Names

COLLATION(), Information Functions

collation-server option

mysqld, Server Command Options

collations

naming conventions, Collation Names

COLLATIONS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table

COLLATION_CHARACTER_SET_APPLICABILITY

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table

collation_connection system variable, Server System Variables

collation_database system variable, Server System Variables

collation_server system variable, Server System Variables

column

changing, ALTER TABLE Syntax

types, Data Types

column alias

problems, Problems with Column Aliases

quoting, Schema Object Names, Problems with Column Aliases

column comments, CREATE TABLE Syntax

column names

case sensitivity, Identifier Case Sensitivity

column-names option

mysql, mysql Options

column-type-info option

mysql, mysql Options

columns

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

indexes, Column Indexes

names, Schema Object Names

other types, Using Data Types from Other Database Engines

selecting, Selecting Particular Columns

storage requirements, Data Type Storage Requirements

COLUMNS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table

columns option

mysqlimport, mysqlimport — A Data Import Program

columns partitioning, COLUMNS Partitioning

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 syntax, Typographical and Syntax Conventions

command-line history

mysql, mysql History File

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

commands

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

commands out of sync, Commands out of sync

comment syntax, Comment Syntax

comments

adding, Comment Syntax

starting, '--' as the Start of a Comment

comments option

mysql, mysql Options

mysqldump, mysqldump — A Database Backup Program

COMMIT, Transaction and Atomic Operation Differences, 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

compact option

mysqldump, mysqldump — A Database Backup Program

comparison operators, Comparison Functions and Operators

compatibility

between MySQL versions, Upgrading from MySQL 5.1 to 5.5, Upgrading from MySQL 5.4 to 5.5

with mSQL, Regular Expressions

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

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

with PostgreSQL, MySQL Extensions to Standard SQL

with standard SQL, MySQL Standards Compliance

with Sybase, USE Syntax

compatible option

mysqldump, mysqldump — A Database Backup Program

compiling

optimizing, System Factors and Startup Parameter Tuning

problems, Dealing with Problems Compiling MySQL

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

compiling clients

on Unix, Building Client Programs

on Windows, Building Client Programs

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

compression

algorithms, Compression Algorithms

application and schema design, Compression and Application and Schema Design

BLOBs, VARCHAR and TEXT, Compressing BLOB, VARCHAR and TEXT Columns

buffer pool, Compression and the InnoDB Buffer Pool

data and indexes, InnoDB Data Storage and Compression

data characteristics, Data Characteristics and Compression

enabling for a table, Enabling Compression for a Table

implementation, How Compression Works in InnoDB

log files, Compression and the InnoDB Log Files

modification log, Compression of B-Tree Pages

overview, Overview of Table Compression

tuning, Tuning InnoDB Compression

Compression

compressed page size, Choosing the Compressed Page Size

configuration characteristics, Configuration Characteristics and Compression

information schema, InnoDB INFORMATION_SCHEMA tables, Information Schema Tables about Compression

innodb_strict_mode, InnoDB Strict Mode

KEY_BLOCK_SIZE, Choosing the Compressed Page Size

monitoring, Monitoring Compression at Runtime

overflow pages, Compressing BLOB, VARCHAR and TEXT Columns

workload characteristics, Workload Characteristics and Compression

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

configuration files, Causes of Access-Denied Errors

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

connect_timeout system variable, Server System Variables

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

consistent reads, Consistent Nonlocking Reads

console option

mysqld, Server Command Options

const table

optimizer, EXPLAIN Output Format, SELECT Syntax

constant table, How MySQL Optimizes WHERE Clauses

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

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, CREATE TABLE ... SELECT Syntax

Copying to group table

thread state, General Thread States

Copying to tmp table

thread state, General Thread States

Copying to tmp table on disk

thread state, General Thread States

core-file option

mysqld, Server Command Options

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

CPACK_MONOLITHIC_INSTALL option

CMake, MySQL Source-Configuration Options

crash, Debugging a MySQL Server

recovery, Using myisamchk for Crash Recovery

repeated, What to Do If MySQL Keeps Crashing

replication, Replication and Master or Slave Shutdowns

crash-me, The MySQL Benchmark Suite

crash-me program, The MySQL Benchmark Suite

CRC32(), Mathematical Functions

CREATE ... IF NOT EXISTS

and replication, Replication of CREATE ... IF NOT EXISTS Statements

CREATE DATABASE, CREATE DATABASE Syntax

Create DB

thread command, Thread Command Values

CREATE EVENT, CREATE EVENT Syntax

and replication, Replication of Invoked Features

CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax, CREATE FUNCTION Syntax for User-Defined Functions

CREATE INDEX, CREATE INDEX Syntax, Overview of Fast Index Creation

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

KEY_BLOCK_SIZE, Choosing the Compressed Page Size

options for table compression, Enabling Compression for a Table

ROW_FORMAT, Specifying a Table’s Row Format

CREATE TABLE ... SELECT

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

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 for User-Defined Functions

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

thread state, General Thread States

creating user accounts, CREATE USER Syntax

CROSS JOIN, JOIN Syntax

Crosses(), Functions That Test Spatial Relationships Between Geometries

CR_SERVER_GONE_ERROR, MySQL server has gone away

CR_SERVER_LOST_ERROR, MySQL server has gone away

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

csv option

mysqlslap, mysqlslap — Load Emulation Client

CSV storage engine, Storage Engines, The CSV Storage Engine

CURDATE(), Date and Time Functions

CURRENT_DATE, Date and Time Functions

CURRENT_TIME, Date and Time Functions

CURRENT_TIMESTAMP, Date and Time Functions

CURRENT_USER(), Information Functions

Cursors, Cursors

CURTIME(), Date and Time Functions

CXX environment variable, Dealing with Problems Compiling MySQL, Environment Variables

CXXFLAGS environment variable, Dealing with Problems Compiling MySQL, Environment Variables

D

Daemon

thread command, Thread Command Values

data

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

loading into tables, Loading Data into a Table

retrieving, Retrieving Information from a Table

size, Optimizing Data Size

DATA DIRECTORY

and replication, Replication and DIRECTORY Table Options

Data truncation with CJK characters, MySQL 5.5 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 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

DATE, Problems Using DATE Columns

date and time functions, Date and Time Functions

Date and Time types, Date and Time Types

date calculations, Date Calculations

DATE columns

problems, Problems Using DATE Columns

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

date functions

Y2K compliance, Year 2000 Issues and Date Types

date types, Data Type Storage Requirements

Y2K issues, Year 2000 Issues and Date Types

date values, Date and Time Values

problems, The DATETIME, DATE, and TIMESTAMP Types

DATE(), Date and Time Functions

DATEDIFF(), Date and Time Functions

dates

used with partitioning, Partitioning 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

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

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

mysqlslap, mysqlslap — Load Emulation Client

my_print_defaults, my_print_defaults — Display Options from Option Files

debug system variable, Server System Variables

debug-check option

mysql, mysql Options

mysqladmin, mysqladmin — Client for Administering a MySQL Server

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

mysqlcheck, mysqlcheck — A Table Maintenance Program

mysqldump, mysqldump — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

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

mysqlslap, mysqlslap — Load Emulation Client

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

debug-info option

comp_err, comp_err — Compile MySQL Error Message File

mysql, mysql Options

mysqladmin, mysqladmin — Client for Administering a MySQL Server

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

mysqlcheck, mysqlcheck — A Table Maintenance Program

mysqldump, mysqldump — A Database Backup Program

mysqlimport, mysqlimport — A Data Import Program

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

mysqlslap, mysqlslap — Load Emulation Client

mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade

debug-sync-timeout option

mysqld, Server Command Options

debugging

client, Debugging a MySQL Client

server, Debugging a MySQL Server

debugging support, MySQL Source-Configuration Options

debug_sync system variable, Server System Variables

DEC data type, Overview of Numeric Types

decimal arithmetic, Precision Math

DECIMAL data type, Overview of Numeric Types, Precision Math

decimal point, Data Types

DECLARE, DECLARE Syntax

DECODE(), Encryption and Compression Functions

decode_bits myisamchk variable, myisamchk General Options

DEFAULT

constraint, Constraints on Invalid Data

default

privileges, Securing the Initial MySQL Accounts

default accounts, 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, Data Type Default Values, CREATE TABLE Syntax, INSERT Syntax

BLOB and TEXT columns, The BLOB and TEXT Types

explicit, Data Type Default Values

implicit, Data Type Default Values

suppression, Constraints on Invalid Data

DEFAULT(), Miscellaneous Functions

default-auth option

mysql, mysql Options

mysqladmin, mysqladmin — Client for Administering a MySQL Server

mysqldump, mysqldump — A Database Backup Program

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

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

CMake, MySQL Source-Configuration Options

DEFAULT_COLLATION option

CMake, MySQL Source-Configuration Options

default_storage_engine system variable, Server System Variables

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

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

Delphi, Using Connector/ODBC with Delphi

derived tables, Subqueries in the FROM Clause

des-key-file option

mysqld, Server Command Options

DESC, DESCRIBE Syntax

DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax

description option

myisamchk, Other myisamchk Options

design

issues, Known Issues in MySQL

DES_DECRYPT(), Encryption and Compression Functions

DES_ENCRYPT(), Encryption and Compression Functions

detach option

mysqlslap, mysqlslap — Load Emulation Client

development source tree, Installing MySQL from a 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-keys option

mysqldump, mysqldump — A Database Backup Program

disable-log-bin option

mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files

DISABLE_GRANT_OPTIONS option

CMake, MySQL Source-Configuration Options

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 full, How MySQL Handles a Full Disk

disk issues, Optimizing Disk I/O

disks

splitting data across, Using Symbolic Links for Databases on Windows

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.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

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

in Korean, MySQL 5.5 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

downgrading, Upgrading or Downgrading MySQL, Downgrading MySQL, Overview

downloading, How to Get MySQL

drbd

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

DRBD license, Distributed Replicated Block Device (DRBD)

DROP ... IF EXISTS

and replication, Replication of DROP ... IF EXISTS Statements

DROP DATABASE, DROP DATABASE Syntax

Drop DB

thread command, Thread Command Values

DROP EVENT, DROP EVENT Syntax

DROP FOREIGN KEY, ALTER TABLE Syntax, FOREIGN KEY Constraints

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

DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax, Overview of Fast Index Creation

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

DROP TRIGGER, DROP TRIGGER Syntax

DROP USER, DROP USER Syntax

DROP VIEW, DROP VIEW Syntax

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

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

edit command

mysql, mysql Commands

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

mysql_config, mysql_config — Get Compile Options for Compiling Clients

enable-named-pipe option

mysqld, Server Command Options

enable-pstack option

mysqld, Server Command Options

ENABLED_LOCAL_INFILE option

CMake, MySQL Source-Configuration Options

ENABLED_PROFILING option

CMake, MySQL Source-Configuration Options

ENABLE_DEBUG_SYNC option

CMake, MySQL Source-Configuration Options

ENABLE_DOWNLOADS option

CMake, MySQL Source-Configuration Options

ENABLE_DTRACE option

CMake, MySQL Source-Configuration 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

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, Dealing with Problems Compiling MySQL, Environment Variables

CFLAGS, Dealing with Problems Compiling MySQL, Environment Variables

CXX, Dealing with Problems Compiling MySQL, Environment Variables

CXXFLAGS, Dealing with Problems Compiling MySQL, Environment Variables

DBI_TRACE, Environment Variables, Debugging mysqld under gdb

DBI_USER, Environment Variables

HOME, Environment Variables, mysql History File

LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface

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

LIBMYSQL_PLUGINS, mysql_load_plugin()

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

MYSQL_GROUP_SUFFIX, Environment Variables

MYSQL_HISTFILE, Environment Variables, mysql History File

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, Unix Postinstallation Procedures, 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

list of, Environment Variables

equal (=), Comparison Functions and Operators

Equals(), Functions That Test Spatial Relationships Between Geometries

eq_ref join type

optimizer, EXPLAIN Output Format

Errcode, perror — Explain Error Codes

errno, perror — Explain Error Codes

Error

thread command, Thread Command Values

error messages

can't find file, Problems with File Permissions

displaying, perror — Explain Error Codes

languages, Setting the Error Message Language

errors

access denied, Access denied

and replication, Slave Errors During Replication

checking tables for, How to Check MyISAM Tables for Errors

common, Problems and Common Errors

directory checksum, Installing MySQL on Solaris and OpenSolaris

handling for UDFs, UDF Return Values and Error Handling

in subqueries, Subquery Errors

known, Known Issues in MySQL

linking, Problems Linking to the MySQL Client Library

list of, Common Errors When Using MySQL Programs

lost connection, Lost connection to MySQL server

reporting, General Information, How to Report Bugs or Problems

sources of information, Sources of Error Information

error_count session variable, Server System Variables

ERROR_FOR_DIVISION_BY_ZERO SQL mode, Server SQL Modes

escape (\\), Strings

escape sequences

option files, Using Option Files

strings, Strings

estimating

query performance, Estimating Query Performance

event

restrictions, Restrictions on Stored Routines, Triggers, and Events

event groups, SET GLOBAL sql_slave_skip_counter Syntax

event 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, Event Scheduler Status

SQL statements, Event Syntax

starting and stopping, Event Scheduler Configuration

time representation, Event Metadata

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

Events tab, The Events Tab

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, Obtaining Table Information with myisamchk

queries, Examples of Common Queries

Execute

thread command, Thread Command Values

EXECUTE, SQL Syntax for Prepared Statements, EXECUTE Syntax

execute option

mysql, mysql Options

executing

thread state, General Thread States

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

Execution of init_command

thread state, General Thread States

execution plan, Understanding the Query Execution Plan

EXISTS

with subqueries, Subqueries with EXISTS or NOT EXISTS

exit command

mysql, mysql Commands

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

expression syntax, Expression 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

external_user session variable, Server System Variables

extra-file option

my_print_defaults, my_print_defaults — Display Options from Option Files

EXTRACT(), Date and Time Functions

extracting

dates, Date Calculations

ExtractValue(), XML Functions

F

FALSE, Numbers, Boolean Values

testing for, Comparison Functions and Operators

FAQs, MySQL Enterprise Monitor Frequently Asked Questions

Fast Index Creation

concurrency, Concurrency Considerations for Fast Index Creation

crash recovery, How Crash Recovery Works with Fast Index Creation

examples, Examples of Fast Index Creation

implementation, Implementation Details of Fast Index Creation

limitations, Limitations of Fast Index Creation

overview, Overview of Fast Index Creation

fast option

myisamchk, myisamchk Check Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

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

file format, InnoDB File Format Management

Antelope, Compressing BLOB, VARCHAR and TEXT Columns

Barracuda, Enabling Compression for a Table

downgrading, Downgrading the File Format

identifying, Identifying the File Format in Use

file format management

downgrading, Overview

enabling new file formats, Enabling New File Formats

file per table, Dynamically Changing innodb_file_per_table

files

binary log, The Binary Log

error messages, Setting the Error Message Language

general query log, The General Query Log

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

filesort optimization, ORDER BY Optimization

FIND_IN_SET(), String Functions

Finished reading one binlog; switching to next binlog

thread state, Replication Master Thread States

first-slave option

mysqldump, mysqldump — A Database Backup Program

fix-db-names option

mysqlcheck, mysqlcheck — A Table Maintenance Program

fix-table-names option

mysqlcheck, mysqlcheck — A Table Maintenance Program

FIXED data type, Overview of Numeric Types

fixed-point arithmetic, Precision Math

FLOAT data type, Overview of Numeric Types

floating-point number, Overview of Numeric Types

floating-point values

and replication, Replication and Floating-Point Values

floats, Numbers

FLOOR(), Mathematical Functions

FLUSH, FLUSH Syntax

and replication, Replication and FLUSH

flush list mutex, Separate Flush List Mutex

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

deleting, ALTER TABLE Syntax, FOREIGN KEY Constraints

FOREIGN KEY constraints

and fast index creation, Limitations of Fast Index Creation

and TRUNCATE TABLE, TRUNCATE TABLE Reclaims Space

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

foreign_key_checks session variable, Server System Variables

FORMAT(), String Functions

Forums, MySQL Community Support at the MySQL Forums

FOUND_ROWS(), Information Functions

FreeBSD troubleshooting, Dealing with Problems Compiling MySQL

freeing items

thread state, General Thread States

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

frequently-asked questions about MySQL Cluster, MySQL 5.5 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 parser plugins, Full-Text Parser Plugins

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, EXPLAIN Output Format

function

creating, CREATE FUNCTION Syntax for User-Defined Functions

deleting, DROP FUNCTION Syntax

function names

parsing, Function Name Parsing and Resolution

resolving ambiguity, Function Name Parsing and Resolution

functions, Functions and Operators

and replication, Replication and System Functions

arithmetic, Bit Functions

bit, Bit Functions

C API, C API Function Overview

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

cast, Cast Functions and Operators

control flow, Control Flow Functions

date and time, Date and Time Functions

encryption, Encryption and Compression Functions

GROUP BY, GROUP BY (Aggregate) Functions

grouping, Operator Precedence

information, Information Functions

mathematical, Mathematical Functions

miscellaneous, Miscellaneous Functions

native

adding, Adding a New Native Function

new, Adding New Functions to MySQL

stored, Using Stored Routines (Procedures and Functions)

string, String Functions

string comparison, String Comparison Functions

user-defined, Adding New Functions to MySQL

adding, Adding a New User-Defined Function

Functions

user-defined, CREATE FUNCTION Syntax for User-Defined Functions, DROP FUNCTION Syntax

functions for SELECT and WHERE clauses, Functions and Operators

G

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.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

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?

Google Test, MySQL Source-Configuration Options

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

granting

privileges, GRANT Syntax

GRANTS, SHOW GRANTS Syntax

Graphs tab, The Graphs Tab

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

group commit, Group Commit

grouping

expressions, Operator Precedence

GROUP_CONCAT(), GROUP BY (Aggregate) Functions

group_concat_max_len system variable, Server System Variables

H

HANDLER, HANDLER Syntax

Handlers, DECLARE for Handlers

handling

errors, UDF Return Values and Error Handling

hash indexes, Comparison of B-Tree and Hash Indexes

hash partitioning, HASH Partitioning

hash partitions

managing, Management of HASH and KEY Partitions

splitting and merging, Management of HASH and KEY Partitions

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

CMake, MySQL Source-Configuration Options

have_geometry system variable, Server System Variables

have_innodb system variable, Server System Variables

have_openssl system variable, Server System Variables

have_partitioning system variable, Server System Variables

have_profiling system variable, Server System Variables

have_query_cache 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_file option

comp_err, comp_err — Compile MySQL Error Message File

HEAP storage engine, Storage Engines, The MEMORY Storage Engine

help command

mysql, mysql Commands

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

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

host name

default, Connecting to the MySQL Server

host name caching, How MySQL Uses DNS

host name resolution, How MySQL Uses DNS

host names

in account names, Specifying Account Names

in default accounts, Securing the Initial MySQL Accounts

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

host table, Access Control, Stage 2: Request Verification

sorting, Access Control, Stage 2: Request Verification

host.frm

problems finding, Unix Postinstallation Procedures

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

i-am-a-dummy option

mysql, mysql Options

i5/OS, Installing MySQL on i5/OS

ib-file set, File Format Compatibility

IBM i5/OS, Installing MySQL on i5/OS

icc

and MySQL Cluster support>, Debugging and Porting MySQL

MySQL builds, Compiler-Specific Build Characteristics

ID

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

identifiers, Schema Object Names

case sensitivity, Identifier Case Sensitivity

quoting, Schema Object Names

identity session variable, Server System Variables

IF, IF Statement

IF(), Control Flow Functions

IFNULL(), Control Flow Functions

IGNORE

with partitioned tables, INSERT Syntax

IGNORE INDEX, Index Hint Syntax

IGNORE KEY, Index Hint Syntax

ignore option

mysqlimport, mysqlimport — A Data Import Program

ignore-builtin-innodb option

mysqld, InnoDB Startup Options and System Variables

ignore-lines option

mysqlimport, mysqlimport — A Data Import Program

ignore-spaces option

mysql, mysql Options

ignore-table option

mysqldump, mysqldump — A Database Backup Program

ignore_builtin_innodb system variable, InnoDB Startup Options and System Variables

IGNORE_SPACE SQL mode, Server SQL Modes

implicit default values, Data Type Default Values

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

importing

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

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

include option

mysql_config, mysql_config — Get Compile Options for Compiling Clients

include-master-host-port option

mysqldump, mysqldump — A Database Backup Program

increasing

performance, Replication FAQ

increasing with replication

speed, Replication

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

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 dives (for statistics estimation), Controlling Optimizer Statistics Estimation

index hints, SELECT Syntax, Index Hint Syntax

index join type

optimizer, EXPLAIN Output Format

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, Comparison of B-Tree and Hash Indexes

and LIKE, Comparison of B-Tree and Hash 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, Multiple-Column Indexes

multi-column, Multiple-Column Indexes

multiple-part, CREATE INDEX Syntax

names, Schema Object Names

use of, How MySQL Uses Indexes

Indexes

creating and dropping, Implementation Details of Fast Index Creation

primary (clustered) and secondary, Implementation Details of Fast Index Creation

index_merge join type

optimizer, EXPLAIN Output Format

index_subquery join type

optimizer, EXPLAIN Output Format

INET_ATON(), Miscellaneous Functions

INET_NTOA(), Miscellaneous Functions

information functions, Information Functions

information option

myisamchk, myisamchk Check Options

information schema tables, InnoDB INFORMATION_SCHEMA tables

INNODB_CMP, INNODB_CMP and INNODB_CMP_RESET

INNODB_CMPMEM, INNODB_CMPMEM and INNODB_CMPMEM_RESET

INNODB_CMPMEM_RESET, INNODB_CMPMEM and INNODB_CMPMEM_RESET

INNODB_CMP_RESET, INNODB_CMP and INNODB_CMP_RESET

INNODB_LOCKS, INNODB_LOCKS

INNODB_LOCK_WAITS, INNODB_LOCK_WAITS

INNODB_TRX, INNODB_TRX

INFORMATION_SCHEMA, INFORMATION_SCHEMA Tables

collation and searching, Collation and INFORMATION_SCHEMA Searches

INFORMATION_SCHEMA plugins, INFORMATION_SCHEMA Plugins

init

thread state, General Thread States

Init DB

thread command, Thread Command Values

init-file option

mysqld, Server Command Options

Initialized

thread state, Event Scheduler Thread States

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

adaptive hash index, Adaptive Hash Indexes

auto-increment columns, AUTO_INCREMENT Handling in InnoDB

autocommit mode, Using InnoDB Transactions, Implicit Transaction Commit and Rollback

backups, Backing Up and Recovering an InnoDB Database

buffer pool, The InnoDB Buffer Pool

checkpoints, InnoDB Checkpoints

clustered index, Clustered and Secondary Indexes

configuration parameters, InnoDB Startup Options and System Variables

configuring data files and memory allocation, Configuring InnoDB

considerations as default storage engine, InnoDB as the Default MySQL Storage Engine

consistent reads, Consistent Nonlocking Reads

crash recovery, The InnoDB Recovery Process

data files, Adding, Removing, or Resizing InnoDB Data and Log Files

deadlock detection, Deadlock Detection and Rollback

disk I/O, InnoDB Disk I/O

file space management, File Space Management

file-per-table setting, Using Per-Table Tablespaces

foreign key constraints, FOREIGN KEY Constraints

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

indexes, InnoDB Table and Index Structures

insert buffering, Insert Buffering

limits and restrictions, Limits on InnoDB Tables

lock modes, InnoDB Lock Modes

locking, The InnoDB Transaction Model and Locking

locking reads, SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads

log files, Adding, Removing, or Resizing InnoDB Data and Log Files

migrating a database, Moving an InnoDB Database to Another Machine

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

multi-versioning, InnoDB Multi-Versioning

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, Configuring InnoDB, Limits on InnoDB Tables

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

raw devices, Using Raw Devices for the Shared Tablespace

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

replication, InnoDB and MySQL Replication

row structure, Physical Row Structure

secondary index, Clustered and Secondary Indexes

semi-consistent read, InnoDB Startup Options and System Variables

Solaris 10 x86_64 issues, Installing MySQL on Solaris and OpenSolaris

system tablespace setup, Creating the InnoDB Tablespace

system variables, InnoDB Startup Options and System Variables

tables, Creating and Using InnoDB Tables, InnoDB Table and Index Structures

converting from other storage engines, Converting Tables from Other Storage Engines to InnoDB

transaction isolation levels, The InnoDB Transaction Model and Locking

transaction model, The InnoDB Transaction Model and Locking

troubleshooting, InnoDB General Troubleshooting

data dictionary problems, Troubleshooting InnoDB Data Dictionary Operations

deadlocks, Deadlock Detection and Rollback

defragmenting tables, Defragmenting a Table

I/O problems, Troubleshooting InnoDB I/O Problems

InnoDB error codes, InnoDB Error Codes

OS error codes, Operating System Error Codes

performance problems, Optimizing for InnoDB Tables

recovery problems, Forcing InnoDB Recovery

SQL errors, InnoDB Error Handling

innodb option

mysqld, InnoDB Startup Options and System Variables

InnoDB parameters, deprecated, Deprecated Parameters

innodb_file_io_threads, Multiple Background I/O Threads

InnoDB parameters, new, New Parameters

innodb_adaptive_flushing, Controlling the Flushing Rate of Dirty Pages

innodb_change_buffering, Controlling InnoDB Change Buffering

innodb_file_format, Enabling New File Formats

innodb_file_format_check, Compatibility Check When InnoDB Is Started

innodb_io_capacity, Controlling the Master Thread I/O Rate

innodb_read_ahead_threshold, Changes in the Read-Ahead Algorithm

innodb_read_io_threads, Multiple Background I/O Threads

innodb_spin_wait_delay, Control of Spin Lock Polling

innodb_stats_sample_pages, Controlling Optimizer Statistics Estimation

innodb_strict_mode, InnoDB Strict Mode

innodb_use_sys_malloc, Using Operating System Memory Allocators

innodb_write_io_threads, Multiple Background I/O Threads

InnoDB parameters, with new defaults, Parameters with New Defaults

innodb_additional_mem_pool_size, Parameters with New Defaults

innodb_buffer_pool_size, Parameters with New Defaults

innodb_change_buffering, Parameters with New Defaults

innodb_file_format_check, Parameters with New Defaults

innodb_log_buffer_size, Parameters with New Defaults

innodb_max_dirty_pages_pct, Controlling the Flushing Rate of Dirty Pages, Parameters with New Defaults

innodb_sync_spin_loops, Parameters with New Defaults

innodb_thread_concurrency, Parameters with New Defaults

InnoDB storage engine, Storage Engines, The InnoDB Storage Engine

compatibility, Features of the InnoDB Storage Engine

downloading, Obtaining and Installing the InnoDB Storage Engine

features, Features of the InnoDB Storage Engine

installing, Obtaining and Installing the InnoDB Storage Engine

restrictions, Compatibility Considerations for Downgrade and Backup

InnoDB tables, Transaction and Atomic Operation Differences

innodb-status-file option

mysqld, InnoDB Startup Options and System Variables

innodb_adaptive_flushing, Controlling the Flushing Rate of Dirty Pages

innodb_adaptive_flushing system variable, InnoDB Startup Options and System Variables

innodb_adaptive_hash_index, Controlling Adaptive Hash Indexing

and innodb_thread_concurrency, Changes Regarding Thread Concurrency

dynamically changing, Dynamically Changing innodb_adaptive_hash_index

innodb_adaptive_hash_index system variable, InnoDB Startup Options and System Variables

innodb_additional_mem_pool_size

and innodb_use_sys_malloc, Using Operating System Memory Allocators

innodb_additional_mem_pool_size system variable, InnoDB Startup Options and System Variables

innodb_autoextend_increment system variable, InnoDB Startup Options and System Variables

innodb_autoinc_lock_mode system variable, InnoDB Startup Options and System Variables

innodb_buffer_pool_instances system variable, InnoDB Startup Options and System Variables

innodb_buffer_pool_size system variable, InnoDB Startup Options and System Variables

innodb_change_buffering, Controlling InnoDB Change Buffering

innodb_change_buffering system variable, InnoDB Startup Options and System Variables

innodb_checksums system variable, InnoDB Startup Options and System Variables

INNODB_CMP

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables

INNODB_CMPMEM

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables

INNODB_CMPMEM_RESET

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables

INNODB_CMP_RESET

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables

innodb_commit_concurrency system variable, InnoDB Startup Options and System Variables

innodb_concurrency_tickets, Changes Regarding Thread Concurrency

innodb_concurrency_tickets system variable, InnoDB Startup Options and System Variables

innodb_data_file_path system variable, InnoDB Startup Options and System Variables

innodb_data_home_dir system variable, InnoDB Startup Options and System Variables

innodb_doublewrite system variable, InnoDB Startup Options and System Variables

innodb_fast_shutdown system variable, InnoDB Startup Options and System Variables

innodb_file_format, InnoDB File Format Management

Antelope, Compressing BLOB, VARCHAR and TEXT Columns

Barracuda, Enabling Compression for a Table

downgrading, Overview

enabling new file formats, Enabling New File Formats

identifying, Identifying the File Format in Use

innodb_file_format system variable, InnoDB Startup Options and System Variables

innodb_file_format_check, Compatibility Check When InnoDB Is Started

innodb_file_format_check system variable, InnoDB Startup Options and System Variables

innodb_file_format_max system variable, InnoDB Startup Options and System Variables

innodb_file_io_threads, Multiple Background I/O Threads

innodb_file_per_table, Enabling Compression for a Table

dynamically changing, Dynamically Changing innodb_file_per_table

innodb_file_per_table system variable, InnoDB Startup Options and System Variables

innodb_flush_log_at_trx_commit system variable, InnoDB Startup Options and System Variables

innodb_flush_method system variable, InnoDB Startup Options and System Variables

innodb_force_recovery system variable, InnoDB Startup Options and System Variables

innodb_io_capacity, Controlling the Master Thread I/O Rate

innodb_io_capacity system variable, InnoDB Startup Options and System Variables

INNODB_LOCKS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_LOCKS Table

innodb_locks_unsafe_for_binlog system variable, InnoDB Startup Options and System Variables

INNODB_LOCK_WAITS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table

innodb_lock_wait_timeout

dynamically changing, Dynamically Changing innodb_lock_wait_timeout

innodb_lock_wait_timeout system variable, InnoDB Startup Options and System Variables

innodb_log_buffer_size system variable, InnoDB Startup Options and System Variables

innodb_log_files_in_group system variable, InnoDB Startup Options and System Variables

innodb_log_file_size system variable, InnoDB Startup Options and System Variables

innodb_log_group_home_dir system variable, InnoDB Startup Options and System Variables

innodb_max_dirty_pages_pct, Controlling the Flushing Rate of Dirty Pages

innodb_max_dirty_pages_pct system variable, InnoDB Startup Options and System Variables

innodb_max_purge_lag system variable, InnoDB Startup Options and System Variables

innodb_mirrored_log_groups system variable, InnoDB Startup Options and System Variables

innodb_old_blocks_pct, Making Buffer Cache Scan Resistant

innodb_old_blocks_pct system variable, InnoDB Startup Options and System Variables

innodb_old_blocks_time, Making Buffer Cache Scan Resistant

innodb_old_blocks_time system variable, InnoDB Startup Options and System Variables

innodb_open_files system variable, InnoDB Startup Options and System Variables

innodb_purge_batch_size system variable, InnoDB Startup Options and System Variables

innodb_purge_threads system variable, InnoDB Startup Options and System Variables

innodb_read_ahead_threshold, Changes in the Read-Ahead Algorithm

innodb_read_ahead_threshold system variable, InnoDB Startup Options and System Variables

innodb_read_io_threads, Multiple Background I/O Threads

innodb_read_io_threads system variable, InnoDB Startup Options and System Variables

innodb_replication_delay system variable, InnoDB Startup Options and System Variables

innodb_rollback_on_timeout system variable, InnoDB Startup Options and System Variables

innodb_spin_wait_delay, Control of Spin Lock Polling

innodb_spin_wait_delay system variable, InnoDB Startup Options and System Variables

innodb_stats_on_metadata

dynamically changing, Dynamically Changing innodb_stats_on_metadata

innodb_stats_on_metadata system variable, InnoDB Startup Options and System Variables

innodb_stats_sample_pages, Controlling Optimizer Statistics Estimation

innodb_stats_sample_pages system variable, InnoDB Startup Options and System Variables

innodb_strict_mode, InnoDB Strict Mode

innodb_strict_mode system variable, InnoDB Startup Options and System Variables

innodb_support_xa system variable, InnoDB Startup Options and System Variables

innodb_sync_spin_loops system variable, InnoDB Startup Options and System Variables

innodb_table_locks system variable, InnoDB Startup Options and System Variables

innodb_thread_concurrency, Changes Regarding Thread Concurrency

innodb_thread_concurrency system variable, InnoDB Startup Options and System Variables

innodb_thread_sleep_delay, Changes Regarding Thread Concurrency

innodb_thread_sleep_delay system variable, InnoDB Startup Options and System Variables

INNODB_TRX

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA INNODB_TRX Table

innodb_use_native_aio system variable, InnoDB Startup Options and System Variables

innodb_use_sys_malloc, Using Operating System Memory Allocators

and innodb_thread_concurrency, Changes Regarding Thread Concurrency

innodb_use_sys_malloc system variable, InnoDB Startup Options and System Variables

innodb_version system variable, InnoDB Startup Options and System Variables

innodb_write_io_threads, Multiple Background I/O Threads

innodb_write_io_threads system variable, 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 buffering, Insert Buffering, Issues with the Insert Buffer

disabling, Controlling InnoDB Change Buffering

INSERT DELAYED, INSERT DELAYED Syntax

INSERT statement

grant privileges, Adding User Accounts

INSERT(), String Functions

insert-ignore option

mysqldump, mysqldump — A Database Backup Program

insertable views

insertable, Updatable and Insertable Views

inserting

speed of, Speed of INSERT Statements

inserts

concurrent, Internal Locking Methods, Concurrent Inserts

insert_id session variable, Server System Variables

INSTALL PLUGIN, INSTALL PLUGIN Syntax

installation

agent, Monitor Agent Installation

postinstall tasks, Postinstallation Considerations

service manager, Installing the Service Manager

unattended, Unattended Installation

uninstalling, Uninstalling the MySQL Enterprise Monitor

upgrading, Upgrading, Re-Installing or Changing Your Installation

installation layouts, Installation Layouts

installation overview, Installing MySQL from Source

installing

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

installing on HP-UX, Installing MySQL on HP-UX

installing on IBM-AIX, Installing MySQL on IBM AIX

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

source distribution, Installing MySQL from Source

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

installing plugins, Installing and Uninstalling Plugins, INSTALL PLUGIN Syntax

INSTALL_BINDIR option

CMake, MySQL Source-Configuration Options

INSTALL_DOCDIR option

CMake, MySQL Source-Configuration Options

INSTALL_DOCREADMEDIR option

CMake, MySQL Source-Configuration Options

INSTALL_INCLUDEDIR option

CMake, MySQL Source-Configuration Options

INSTALL_INFODIR option

CMake, MySQL Source-Configuration Options

INSTALL_LAYOUT option

CMake, MySQL Source-Configuration Options

INSTALL_LIBDIR option

CMake, MySQL Source-Configuration Options

INSTALL_MANDIR option

CMake, MySQL Source-Configuration Options

INSTALL_MYSQLSHAREDIR option

CMake, MySQL Source-Configuration Options

INSTALL_MYSQLTESTDIR option

CMake, MySQL Source-Configuration Options

INSTALL_PLUGINDIR option

CMake, MySQL Source-Configuration Options

INSTALL_SBINDIR option

CMake, MySQL Source-Configuration Options

INSTALL_SCRIPTDIR option

CMake, MySQL Source-Configuration Options

INSTALL_SHAREDIR option

CMake, MySQL Source-Configuration Options

INSTALL_SQLBENCHDIR option

CMake, MySQL Source-Configuration Options

INSTALL_SUPPORTFILESDIR option

CMake, MySQL Source-Configuration Options

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 locking, Internal Locking Methods

internal memory allocator

disabling, Using Operating System Memory Allocators

internals, MySQL Internals

internationalization, Internationalization and Localization

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

Intersection(), Spatial Operators

Intersects(), Functions That Test Spatial Relationships Between Geometries

INTERVAL(), Comparison Functions and Operators

introducer

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

invalid data

constraint, Constraints on Invalid Data

invalidating query cache entries

thread state, Query Cache Thread States

in_file option

comp_err, comp_err — Compile MySQL Error Message File

IP addresses

in account names, Specifying Account Names

in default accounts, Securing the Initial MySQL Accounts

IPv6 addresses

in account names, Specifying Account Names

in default accounts, Securing the Initial MySQL Accounts

IPv6 connections, Securing the Initial MySQL Accounts

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, Comparison of B-Tree and Hash 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

Japanese character sets

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

Japanese, Korean, Chinese character sets

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

Java VM

installation, Installing the Service Manager

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, EXPLAIN Output Format

const, EXPLAIN Output Format

eq_ref, EXPLAIN Output Format

fulltext, EXPLAIN Output Format

index, EXPLAIN Output Format

index_merge, EXPLAIN Output Format

index_subquery, EXPLAIN Output Format

range, EXPLAIN Output Format

ref, EXPLAIN Output Format

ref_or_null, EXPLAIN Output Format

system, EXPLAIN Output Format

unique_subquery, EXPLAIN Output Format

join_buffer_size system variable, Server System Variables

K

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

key-value store, Comparison of B-Tree and Hash Indexes

keys, Column Indexes

foreign, Foreign Key Differences, 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_BLOCK_SIZE, Enabling Compression for a Table, Choosing the Compressed Page Size

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.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

Korean, Chinese, Japanese character sets

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

L

language option

mysqld, Server Command Options

language support

error messages, Setting the Error Message Language

language system variable, Server System Variables

large page support, Enabling Large Page Support

large-pages option

mysqld, Server Command Options

large_files_support system variable, Server System Variables

large_pages system variable, Server System Variables

large_page_size system variable, Server System Variables

last row

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

LAST_DAY(), Date and Time Functions

last_insert_id session variable, Server System Variables

LAST_INSERT_ID(), Transaction and Atomic Operation Differences, 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

lc-messages option

mysqld, Server Command Options

lc-messages-dir option

mysqld, Server Command Options

LCASE(), String Functions

lc_messages system variable, Server System Variables

lc_messages_dir system variable, Server System Variables

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

LIBMYSQL_PLUGINS environment variable, mysql_load_plugin()

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, Comparison of B-Tree and Hash Indexes

and wildcards, Comparison of B-Tree and Hash Indexes

LIMIT, Optimizing LIMIT Queries, Information Functions, SELECT Syntax

and replication, Replication and LIMIT

limitations, MySQL Enterprise Monitor Limitations

MySQL Limitations, Limits in MySQL

replication, Replication Features and Issues

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 to the MySQL Client Library

links

symbolic, Using Symbolic Links

list partitioning, LIST Partitioning

list partitions

adding and dropping, Management of RANGE and LIST Partitions

managing, Management of RANGE and LIST Partitions

literals, Literal Values

LN(), Mathematical Functions

LOAD DATA

and replication, Replication and LOAD DATA INFILE

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 XML, LOAD XML Syntax

loading

tables, Loading Data into a Table

LOAD_FILE(), String Functions

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

localhost

special treatment of, Connecting to the MySQL Server

localization, Internationalization and Localization

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 TABLES, LOCK TABLES and UNLOCK TABLES Syntax

lock wait timeout, Dynamically Changing innodb_lock_wait_timeout

lock-all-tables option

mysqldump, mysqldump — A Database Backup Program

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

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

metadata, Metadata Locking Within Transactions

row-level, Transaction and Atomic Operation Differences, Internal Locking Methods

table-level, Internal Locking Methods

Locking

information schema, InnoDB INFORMATION_SCHEMA tables, Information Schema Tables about Transactions, Notes on Locking in InnoDB

locking methods, Internal Locking Methods

lock_wait_timeout system variable, Server System Variables

log

changes, MySQL Change History

log buf mutex, Improved Log Sys Mutex

log files

maintaining, Server Log Maintenance

log option

mysqld, Server Command Options

mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers

log sys mutex, Improved Log Sys Mutex

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

logging slow query

thread state, General Thread States

logical operators, Logical Operators

login

thread state, General Thread States

logs

flushing, MySQL Server 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

LONGTEXT data type, Overview of String Types

long_query_time system variable, Server System Variables

LOOP, LOOP Statement

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

LRU page replacement, Making Buffer Cache Scan Resistant

LTRIM(), String Functions

M

Mac OS X, MySQL Connector/ODBC

installation, Installing MySQL on Mac OS X

mailing list address, General Information

mailing lists, MySQL Mailing Lists

archive location, MySQL Mailing Lists

guidelines, Guidelines for Using the Mailing Lists

main features of MySQL, The Main Features of MySQL

maintaining

log files, Server Log Maintenance

tables, Setting Up a MyISAM Table Maintenance Schedule

maintenance

tables, mysqlcheck — A Table Maintenance Program

MAKEDATE(), Date and Time Functions

MAKETIME(), Date and Time Functions

MAKE_SET(), String Functions

make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive

Making temp file

thread state, Replication Slave SQL Thread States

manage keys

thread state, General Thread States

manual

available formats, About This Manual

online location, About This Manual

syntax conventions, Typographical and Syntax Conventions

typographical conventions, Typographical and Syntax Conventions

Master has sent all binlog to slave; waiting for binlog to be updated

thread state, Replication Master Thread States

master-data option

mysqldump, mysqldump — A Database Backup Program

master-info-file option

mysqld, Replication Slave Options and Variables

master-retry-count 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

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

max_allowed_packet

and replication, Replication and max_allowed_packet

max_allowed_packet system variable, Server System Variables

max_allowed_packet variable, mysql Options

max_binlog_cache_size system variable, Binary Log Options and Variables

max_binlog_size system variable, Binary Log Options and Variables

max_binlog_stmt_cache_size system variable, Binary Log Options and Variables

max_connections system variable, Server System Variables

MAX_CONNECTIONS_PER_HOUR, Setting Account Resource Limits

max_connect_errors system variable, Server System Variables

max_delayed_threads system variable, Server System Variables

max_error_count system variable, Server System Variables

max_heap_table_size system variable, Server System Variables

max_insert_delayed_threads system variable, Server System Variables

max_join_size system variable, Server System Variables

max_join_size variable, mysql Options

max_length_for_sort_data system variable, Server System Variables

max_prepared_stmt_count system variable, Server System Variables

MAX_QUERIES_PER_HOUR, Setting Account Resource Limits

max_relay_log_size system variable, Server System Variables

max_seeks_for_key system variable, Server System Variables

max_sort_length system variable, Server System Variables

max_sp_recursion_depth system variable, Server System Variables

max_tmp_tables system variable, Server System Variables

MAX_UPDATES_PER_HOUR, Setting Account Resource Limits

MAX_USER_CONNECTIONS, Setting Account Resource Limits

max_user_connections system variable, Server System Variables

max_write_lock_count system variable, Server System Variables

MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs)

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

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

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

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

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

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

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

MD5(), Encryption and Compression Functions

medium-check option

myisamchk, myisamchk Check Options

mysqlcheck, mysqlcheck — A Table Maintenance Program

MEDIUMBLOB data type, Overview of String Types

MEDIUMINT data type, Overview of Numeric Types

MEDIUMTEXT data type, Overview of String Types

memlock option

mysqld, Server Command Options

memory allocator

innodb_use_sys_malloc, Using Operating System Memory Allocators

MEMORY storage engine, Storage Engines, The MEMORY Storage Engine

and replication, Replication and MEMORY Tables

memory usage

myisamchk, myisamchk Memory Usage

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

Performance Schema, Performance Schema Startup and Runtime Configuration

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

metadata locking

transactions, Metadata Locking Within Transactions

method option

mysqlhotcopy, mysqlhotcopy — A Database Backup Program

methods

locking, Internal Locking Methods

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

midpoint insertion, Making Buffer Cache Scan Resistant

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

mixed statements (Replication), Replication and Transactions

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

installation, Installing the Service Manager

terminal, Tutorial

monitoring

threads, Examining Thread Information

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

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 buffer pools, Improvements to Performance from Multiple Buffer Pools

multiple rollback segments, Better Scalability with Multiple Rollback Segments

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

MVCC (multi-version concurrency control), InnoDB Multi-Versioning

My

derivation, History of MySQL

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-recover-options option

mysqld, Server Command Options, MyISAM Startup Options

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

analyze option, Other myisamchk Options

backup option, myisamchk Repair Options

block-search option, Other myisamchk Options

character-sets-dir option, myisamchk Repair Options

check option, myisamchk Check Options

check-only-changed option, myisamchk Check Options

correct-checksum option, myisamchk Repair Options

data-file-length option, myisamchk Repair Options

debug option, myisamchk General Options

description option, Other myisamchk Options

example output, Obtaining Table Information with myisamchk

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

fast option, myisamchk Check Options

force option, myisamchk Check Options, myisamchk Repair Options

help option, myisamchk General Options

HELP option, myisamchk General Options

information option, myisamchk Check Options

keys-used option, myisamchk Repair Options

max-record-length option, myisamchk Repair Options

medium-check option, myisamchk Check Options

no-symlinks option, myisamchk Repair Options

options, myisamchk General Options

parallel-recover option, myisamchk Repair Options

quick option, myisamchk Repair Options

read-only option, myisamchk Check Options

recover option, myisamchk Repair Options

safe-recover option, myisamchk Repair Options

set-auto-increment[ option, Other myisamchk Options

set-character-set option, myisamchk Repair Options

set-collation option, myisamchk Repair Options

silent option, myisamchk General Options

sort-index option, Other myisamchk Options

sort-records option, Other myisamchk Options

sort-recover option, myisamchk Repair Options

tmpdir option, myisamchk Repair Options

unpack option, myisamchk Repair Options

update-state option, myisamchk Check Options

verbose option, myisamchk General Options

version option, myisamchk General Options

wait option, myisamchk General Options

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

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

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

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

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

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

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

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

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

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

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

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

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

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

myisam_block_size myisamchk variable, myisamchk General Options

myisam_data_pointer_size system variable, Server System Variables

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

count option, myisam_ftdump — Display Full-Text Index information

dump option, myisam_ftdump — Display Full-Text Index information

help option, myisam_ftdump — Display Full-Text Index information

length option, myisam_ftdump — Display Full-Text Index information

stats option, myisam_ftdump — Display Full-Text Index information

verbose option, myisam_ftdump — Display Full-Text Index information

myisam_max_sort_file_size system variable, Server System Variables

myisam_mmap_size system variable, Server System Variables

myisam_recover_options system variable, Server System Variables

myisam_repair_threads system variable, Server System Variables

myisam_sort_buffer_size system variable, Server System Variables

myisam_stats_method system variable, Server System Variables

myisam_use_mmap system variable, Server System Variables

MyODBC, MySQL Connector/ODBC

MySQL

defined, What is MySQL?

introduction, What is MySQL?

pronunciation, What is MySQL?

upgrading, mysql_upgrade — Check Tables for MySQL Upgrade

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

auto-rehash option, mysql Options

auto-vertical-output option, mysql Options

batch option, mysql Options

bind-address 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-auth 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

plugin-dir option, mysql Options

port option, mysql Options

print command, mysql Commands

prompt command, mysql Commands

prompt option, mysql Options

protocol option, mysql Options

quick option, mysql Options

quit command, mysql Commands

raw option, mysql Options

reconnect option, mysql Options

rehash command, mysql Commands

safe-updates option, mysql Options

secure-auth option, mysql Options

show-warnings option, mysql Options

sigint-ignore option, mysql Options

silent option, mysql Options

skip-column-names option, mysql Options

skip-line-numbers option, mysql Options

socket option, mysql Options

source command, mysql Commands

SSL options, mysql Options

status command, mysql Commands

system command, mysql Commands

table option, mysql Options

tee command, mysql Commands

tee option, mysql Options

unbuffered option, mysql Options

use command, mysql Commands

user option, mysql Options

verbose option, mysql Options

version option, mysql Options

vertical option, mysql Options

wait option, mysql Options

warnings command, mysql Commands

xml option, mysql Options

MySQL binary distribution, Choosing Which MySQL Distribution to Install

MYSQL C type, C API Data Structures

MySQL Cluster

compiling with icc, Debugging and Porting MySQL

FAQ, MySQL 5.5 FAQ: MySQL Cluster

storage requirements, Data Type Storage Requirements

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

MySQL mailing lists, MySQL Mailing Lists

MySQL name, History of MySQL

mysql prompt command, mysql Commands

MySQL server

mysqld, mysqld — The MySQL Server, The MySQL Server

MySQL Server

installation, Installing the Service Manager

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 replication, Replication of the mysql System Database

MySQL version, How to Get MySQL

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

mysql.event table, The Event Scheduler and MySQL Privileges

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-mysqld_safe option, mysql.server — MySQL Server Startup Script

user option, mysql.server — MySQL Server Startup Script

mysql.sock

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

bind-address option, mysqladmin — Client for Administering a MySQL Server

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

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

bind-address option, mysqlbinlog — Utility for Processing Binary Log Files

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

database option, mysqlbinlog — Utility for Processing Binary Log Files

debug option, mysqlbinlog — Utility for Processing Binary Log Files

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

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

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

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

help option, mysqlbinlog — Utility for Processing Binary Log Files

hexdump option, mysqlbinlog — Utility for Processing Binary Log Files

host option, mysqlbinlog — Utility for Processing Binary Log Files

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

offset option, mysqlbinlog — Utility for Processing Binary Log Files

password option, mysqlbinlog — Utility for Processing Binary Log Files

port option, mysqlbinlog — Utility for Processing Binary Log Files

position option, mysqlbinlog — Utility for Processing Binary Log Files

protocol option, mysqlbinlog — Utility for Processing Binary Log Files

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

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

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

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

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

socket option, mysqlbinlog — Utility for Processing Binary Log Files

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

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

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

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

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

user option, mysqlbinlog — Utility for Processing Binary Log Files

verbose option, mysqlbinlog — Utility for Processing Binary Log Files

version option, mysqlbinlog — Utility for Processing Binary Log Files

mysqlbug, mysqlbug — Generate Bug Report

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

bind-address option, mysqlcheck — A Table Maintenance Program

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

check option, mysqlcheck — A Table Maintenance Program

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

check-upgrade option, mysqlcheck — A Table Maintenance Program

compress option, mysqlcheck — A Table Maintenance Program

databases option, mysqlcheck — A Table Maintenance Program

debug option, mysqlcheck — A Table Maintenance Program

debug-check option, mysqlcheck — A Table Maintenance Program

debug-info option, mysqlcheck — A Table Maintenance Program

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

extended option, mysqlcheck — A Table Maintenance Program

fast option, mysqlcheck — A Table Maintenance Program

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

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

force option, mysqlcheck — A Table Maintenance Program

help option, mysqlcheck — A Table Maintenance Program

host option, mysqlcheck — A Table Maintenance Program

medium-check option, mysqlcheck — A Table Maintenance Program

optimize option, mysqlcheck — A Table Maintenance Program

password option, mysqlcheck — A Table Maintenance Program

pipe option, mysqlcheck — A Table Maintenance Program

port option, mysqlcheck — A Table Maintenance Program

protocol option, mysqlcheck — A Table Maintenance Program

quick option, mysqlcheck — A Table Maintenance Program

repair option, mysqlcheck — A Table Maintenance Program

silent option, mysqlcheck — A Table Maintenance Program

socket option, mysqlcheck — A Table Maintenance Program

SSL options, mysqlcheck — A Table Maintenance Program

tables option, mysqlcheck — A Table Maintenance Program

use-frm option, mysqlcheck — A Table Maintenance Program

user option, mysqlcheck — A Table Maintenance Program

verbose option, mysqlcheck — A Table Maintenance Program

version option, mysqlcheck — A Table Maintenance Program

write-binlog option, mysqlcheck — A Table Maintenance Program

mysqlclient library, Connectors and APIs

mysqld, Overview of MySQL Programs

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

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

ansi option, Server Command Options

basedir option, Server Command Options

big-tables option, Server Command Options

bind-address option, Server Command Options

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

binlog-format option, Server Command Options

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

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

bootstrap option, Server Command Options

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

character-set-filesystem option, Server Command Options

character-set-server option, Server Command Options

character-sets-dir option, Server Command Options

chroot option, Server Command Options

collation-server option, Server Command Options

command options, Server Command Options

console option, Server Command Options

core-file option, Server Command Options

datadir option, Server Command Options

debug option, Server Command Options

debug-sync-timeout option, Server Command Options

default-character-set option, Server Command Options

default-collation option, Server Command Options

default-storage-engine option, Server Command Options

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

lc-messages option, Server Command Options

lc-messages-dir 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-info-file option, Replication Slave Options and Variables

master-retry-count 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-recover-options option, Server Command Options, MyISAM Startup Options

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

old-alter-table option, Server Command Options

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

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

one-thread option, Server Command Options

open-files-limit option, Server Command Options

partition option, Server Command Options

pid-file option, Server Command Options

plugin option prefix, Server Command Options

plugin-load option, Server Command Options

port option, Server Command Options

port-open-timeout option, Server Command Options

read-only option, Replication Slave Options and Variables

relay-log option, Replication Slave Options and Variables

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

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

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

relay-log-recovery 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

safe-mode option, Server Command Options

safe-show-database option, Server Command Options

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

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

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

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

shared-memory option, Server Command Options

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

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

skip-concurrent-insert option, Server Command Options

skip-event-scheduler option, Server Command Options

skip-external-locking option, Server Command Options

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

skip-host-cache option, Server Command Options

skip-innodb option, Server Command Options, InnoDB Startup Options and System Variables

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

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

skip-partition option, Server Command Options

skip-safemalloc option, Server Command Options

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

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

skip-stack-trace option, Server Command Options

skip-symbolic-links option, Server Command Options

skip-thread-priority option, Server Command Options

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

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

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

slave_compressed_protocol option, Replication Slave Options and Variables

slow-query-log option, Server Command Options

socket option, Server Command Options

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

sql-mode option, Server Command Options

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

standalone option, Server Command Options

starting, How to Run MySQL as a Normal User

super-large-pages option, Server Command Options

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 library, Connectors and APIs

mysqld option

malloc-lib, mysqld_safe — MySQL Server Startup Script

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

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

bind-address 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-auth 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

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

include-master-host-port option, mysqldump — A Database Backup Program

insert-ignore option, mysqldump — A Database Backup Program

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

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

lock-tables option, mysqldump — A Database Backup Program

log-error option, mysqldump — A Database Backup Program

master-data option, mysqldump — A Database Backup Program

no-autocommit option, mysqldump — A Database Backup Program

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

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

no-data option, mysqldump — A Database Backup Program

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

no-tablespaces option, mysqldump — A Database Backup Program

opt option, mysqldump — A Database Backup Program

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

password option, mysqldump — A Database Backup Program

pipe option, mysqldump — A Database Backup Program

plugin-dir option, mysqldump — A Database Backup Program

port option, mysqldump — A Database Backup Program

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

protocol option, mysqldump — A Database Backup Program

quick option, mysqldump — A Database Backup Program

quote-names option, mysqldump — A Database Backup Program

replace option, mysqldump — A Database Backup Program

result-file option, mysqldump — A Database Backup Program

routines option, mysqldump — A Database Backup Program

set-charset option, mysqldump — A Database Backup Program

single-transaction option, mysqldump — A Database Backup Program

skip-comments option, mysqldump — A Database Backup Program

skip-opt option, mysqldump — A Database Backup Program

socket option, mysqldump — A Database Backup Program

SSL options, mysqldump — A Database Backup Program

tab option, mysqldump — A Database Backup Program

tables option, mysqldump — A Database Backup Program

triggers option, mysqldump — A Database Backup Program

tz-utc option, mysqldump — A Database Backup Program

user option, mysqldump — A Database Backup Program

using for backups, Using mysqldump for Backups

verbose option, mysqldump — A Database Backup Program

version option, mysqldump — A Database Backup Program

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

where option, mysqldump — A Database Backup Program

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

xml option, mysqldump — A Database Backup Program

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

debug option, mysqldumpslow — Summarize Slow Query Log Files

help option, mysqldumpslow — Summarize Slow Query Log Files

verbose option, mysqldumpslow — Summarize Slow Query Log Files

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

config-file option, mysqld_multi — Manage Multiple MySQL Servers

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

defaults-file option, mysqld_multi — Manage Multiple MySQL Servers

example option, mysqld_multi — Manage Multiple MySQL Servers

help option, mysqld_multi — Manage Multiple MySQL Servers

log option, mysqld_multi — Manage Multiple MySQL Servers

mysqladmin option, mysqld_multi — Manage Multiple MySQL Servers

mysqld option, mysqld_multi — Manage Multiple MySQL Servers

no-defaults option, mysqld_multi — Manage Multiple MySQL Servers

no-log option, mysqld_multi — Manage Multiple MySQL Servers

password option, mysqld_multi — Manage Multiple MySQL Servers

silent option, mysqld_multi — Manage Multiple MySQL Servers

tcp-ip option, mysqld_multi — Manage Multiple MySQL Servers

user option, mysqld_multi — Manage Multiple MySQL Servers

verbose option, mysqld_multi — Manage Multiple MySQL Servers

version option, mysqld_multi — Manage Multiple MySQL Servers

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

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

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

old_server 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

bind-address option, mysqlimport — A Data Import Program

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

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

bind-address option, 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

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

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

socket option, mysqlslap — Load Emulation Client

SSL options, 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, The MySQL Test Suite

mysql_affected_rows(), mysql_affected_rows()

mysql_autocommit(), mysql_autocommit()

MYSQL_BIND C type, C API Prepared Statement Data Structures

mysql_change_user(), mysql_change_user()

mysql_character_set_name(), mysql_character_set_name()

mysql_client_find_plugin(), mysql_client_find_plugin()

mysql_client_register_plugin(), mysql_client_register_plugin()

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

CMake, MySQL Source-Configuration Options

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 Structures

mysql_field_count(), mysql_field_count(), mysql_num_fields()

MYSQL_FIELD_OFFSET C type, C API Data Structures

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_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 History File

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(), Transaction and Atomic Operation Differences, 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_load_plugin(), mysql_load_plugin()

mysql_load_plugin_v(), mysql_load_plugin_v()

MYSQL_MAINTAINER_MODE option

CMake, MySQL Source-Configuration Options

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_plugin_options(), mysql_plugin_options()

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 Structures

mysql_rollback(), mysql_rollback()

MYSQL_ROW C type, C API Data Structures

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 Structures

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_next_result(), mysql_stmt_next_result()

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

CMake, MySQL Source-Configuration Options

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 Structures

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

MYSQL_UNIX_ADDR option

CMake, MySQL Source-Configuration Options

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

upgrade-system-tables 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

write-binlog 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 Structures

my_bool values

printing, C API Data Structures

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 Structures

my_ulonglong values

printing, C API Data Structures