Index

Symbols

! (logical NOT), Logical Operators
!= (not equal), Comparison Functions and Operators
", Database, Table, Index, Column, and Alias Names
%, Arithmetic Operators
% (modulo), Mathematical Functions
% (wildcard character), Strings
& (bitwise AND), Bit Functions
&& (logical AND), Logical Operators
() (parentheses), Operator Precedence
(Control-Z) \Z, Strings
* (multiplication), Arithmetic Operators
+ (addition), Arithmetic Operators
- (subtraction), Arithmetic Operators
- (unary minus), Arithmetic Operators
--password option, Keeping Your Password Secure
--with-raid link errors, Dealing with Problems Compiling MySQL
-p option, Keeping Your Password Secure
.my.cnf file, Using Option Files, Connecting to the MySQL Server, Causes of Access denied Errors, Keeping Your Password Secure, Using Client Programs in a Multiple-Server Environment
.mysql_history file, mysql Options
.pid (process ID) file, Setting Up a Table Maintenance Schedule
/ (division), Arithmetic Operators
/etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax
< (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
= (equal), Comparison Functions and Operators
> (greater than), Comparison Functions and Operators
>= (greater than or equal), Comparison Functions and Operators
>> (right shift), Bit Functions
[API] (MySQL Cluster), SQL Node and API Node Configuration Parameters
[MGM] (MySQL Cluster), Management Node Configuration Parameters
[NDBD] (MySQL Cluster), Data Node Configuration Parameters
[NDBD_DEFAULT] (MySQL Cluster), Data Node Configuration Parameters
[NDB_MGMD] (MySQL Cluster), Management Node Configuration Parameters
[SQL] (MySQL Cluster), SQL Node and API Node Configuration Parameters
\" (double quote), Strings
\' (single quote), Strings
\0 (ASCII 0), Strings
\b (backspace), Strings
\n (linefeed), Strings
\n (newline), Strings
\r (carriage return), Strings
\t (tab), Strings
\Z (Control-Z) ASCII 26, Strings
\\ (escape), Strings
^ (bitwise XOR), Bit Functions
_ (wildcard character), Strings
_rowid, CREATE TABLE Syntax
`, Database, Table, Index, Column, and Alias Names
| (bitwise OR), Bit Functions
|| (logical OR), Logical Operators
~, Bit Functions

A

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 privileges
adding, Adding New User Accounts to MySQL
accounts
anonymous user, Securing the Initial MySQL Accounts
root, Securing the Initial MySQL Accounts
ACID, Transactions and Atomic Operations, InnoDB Overview
ACLs, The MySQL Access Privilege System
ACOS(), Mathematical Functions
Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP)
ActiveState Perl, Installing ActiveState Perl on Windows
add-drop-database option
mysqldump, mysqldump — A Database Backup Program
add-drop-table option
mysqldump, mysqldump — A Database Backup Program
add-locks option
mysqldump, mysqldump — A Database Backup Program
ADDDATE(), Date and Time Functions
adding
character sets, Adding a New Character Set
native functions, Adding a New Native Function
new account privileges, Adding New User Accounts to MySQL
new functions, Adding New Functions to MySQL
new user privileges, Adding New User Accounts to MySQL
new users, Installing MySQL on Other Unix-Like Systems, Source Installation Overview
procedures, Adding New Procedures to MySQL
user-defined functions, Adding a New User-Defined Function
addition (+), Arithmetic Operators
ADDTIME(), Date and Time Functions
addtodest option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
administration of MySQL Cluster, ndb_mgm, the Management Client Process
AES_DECRYPT(), Encryption and Compression Functions
AES_ENCRYPT(), Encryption and Compression Functions
age
calculating, Date Calculations
alias, Problems with Column Aliases
alias names
case sensitivity, Identifier Case Sensitivity
aliases
for expressions, GROUP BY and HAVING with Hidden Fields
for tables, SELECT Syntax
in GROUP BY clauses, GROUP BY and HAVING with Hidden Fields
names, Database, Table, Index, Column, and Alias Names
on expressions, SELECT Syntax
ALL, SELECT Syntax
all-databases option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
all-in-1 option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
allow-keywords option
mysqldump, mysqldump — A Database Backup Program
allow-suspicious-udfs option
mysqld, Command Options, Security-Related mysqld Options
allowold option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
ALTER COLUMN, ALTER TABLE Syntax
ALTER DATABASE, ALTER DATABASE Syntax
ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE
altering
database, ALTER DATABASE Syntax
analyze option
myisamchk, Other myisamchk Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
ANALYZE TABLE, ANALYZE TABLE Syntax
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, Command Options
ANSI SQL mode, SQL Modes
ANSI_QUOTES SQL mode, SQL Modes
answering questions
etiquette, Guidelines for Using the Mailing Lists
Apache, Using MySQL with Apache
API node (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
API nodes, MySQL Server Process Usage for MySQL Cluster
API's
list of, Packages that support MySQL
APIs, APIs and Libraries
Perl, MySQL Perl API
ArbitrationDelay, Defining the Management Server, Defining SQL and Other API Nodes
ArbitrationRank, Defining the Management Server, Defining SQL and Other API Nodes
ArbitrationTimeout (MySQL Cluster configuration parameter), Defining Data Nodes
arbitrator, MySQL Cluster FAQ
ARCHIVE storage engine, Storage Engines and Table Types, 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
AsBinary(), Geometry Format Conversion Functions
ASCII(), String Functions
ASIN(), Mathematical Functions
AsText(), Geometry Format Conversion Functions
ATAN(), Mathematical Functions
ATAN2(), Mathematical Functions
attackers
security against, Making MySQL Secure Against Attackers
AUTO-INCREMENT
ODBC, Obtaining Auto-Increment Values
auto-rehash option
mysql, mysql Options
auto-repair option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
autoclose option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
AUTO_INCREMENT, Using AUTO_INCREMENT
and NULL values, Problems with NULL Values
AVG(), GROUP BY (Aggregate) Functions

B

backslash
escape character, Literal Values
backspace (\b), Strings
backup option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
BACKUP TABLE, BACKUP TABLE Syntax
BackupDataBufferSize, Configuration for Cluster Backup
BackupDataBufferSize (MySQL Cluster configuration parameter), Defining Data Nodes
BackupDataDir, Defining Data Nodes
BackupLogBufferSize, Defining Data Nodes, Configuration for Cluster Backup
BackupMaxWriteSize, Defining Data Nodes, Configuration for Cluster Backup
BackupMemory, Defining Data Nodes, Configuration for Cluster Backup
backups, Database Backups
database, BACKUP TABLE Syntax
in MySQL Cluster, On-line Backup of MySQL Cluster, Cluster Backup Concepts, Using The Management Client to Create a Backup, How to Restore a Cluster Backup, Configuration for Cluster Backup
backups, troubleshooting
in MySQL Cluster, Backup Troubleshooting
BackupWriteSize, Defining Data Nodes, Configuration for Cluster Backup
basedir option
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
batch mode, Using mysql in Batch Mode
batch option
mysql, mysql Options
BatchByteSize, Defining SQL and Other API Nodes
BatchSize, Defining SQL and Other API Nodes
BatchSizePerLocalScan, Defining Data Nodes
BDB storage engine, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine
BDB tables, Transactions and Atomic Operations
bdb-home option
mysqld, BDB Startup Options
bdb-lock-detect option
mysqld, BDB Startup Options
bdb-logdir option
mysqld, BDB Startup Options
bdb-no-recover option
mysqld, BDB Startup Options
bdb-no-sync option
mysqld, BDB Startup Options
bdb-shared-data option
mysqld, BDB Startup Options
bdb-tmpdir option
mysqld, BDB Startup Options
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
benchmark suite, The MySQL Benchmark Suite
BENCHMARK(), Information Functions
benchmarks, Using Your Own Benchmarks
BerkeleyDB storage engine, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine
BETWEEN ... AND, Comparison Functions and Operators
big-tables option
mysqld, Command Options
Big5 Chinese character encoding, Case Sensitivity in Searches
BIGINT data type, Overview of Numeric Types
BIN(), String Functions
BINARY, Cast Functions and Operators
BINARY data type, Overview of String Types, The BINARY and VARBINARY Types
binary distributions, MySQL Binaries Compiled by MySQL AB
installing, Installing MySQL on Other Unix-Like Systems
on Linux, Linux Binary Distribution Notes
binary log, The Binary Log
bind-address option
mysqld, Command Options
binlog-do-db option
mysqld, The Binary Log
binlog-ignore-db option
mysqld, The Binary Log
BIT data type, Overview of Numeric Types
BitKeeper tree, Installing from the Development Source Tree
BIT_AND(), GROUP BY (Aggregate) Functions
BIT_COUNT, Calculating Visits Per Day
BIT_COUNT(), Bit Functions
bit_functions
example, Calculating Visits Per Day
BIT_LENGTH(), String Functions
BIT_OR, Calculating Visits Per Day
BIT_OR(), GROUP BY (Aggregate) Functions
BIT_XOR(), GROUP BY (Aggregate) Functions
BLACKHOLE storage engine, Storage Engines and Table Types, 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-search option
myisamchk, Other myisamchk Options
BOOL data type, Overview of Numeric Types
BOOLEAN data type, Overview of Numeric Types
bootstrap option
mysqld, Command Options
Borland Builder 4, Using Connector/ODBC with Borland Builder 4
Borland C++ compiler, Building MySQL from Source Using Borland C++
Boundary(), General Geometry Functions
brackets
square, Data Types
brief option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
buffer sizes
client, APIs and Libraries
mysqld server, Tuning Server Parameters
Buffer(), Spatial Operators
bug reports
criteria for, How to Report Bugs or Problems
bugs
known, Known Issues in MySQL
MySQL Cluster
reporting, ndb_error_reporter
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

C

C API
data types, MySQL C API
functions, C API Function Overview
linking problems, Problems Linking with the C API
C Prepared statement API
functions, C API Prepared Statement Function Overview
C++ APIs, MySQL C++ API
C++ Builder, Using Connector/ODBC with C++ Builder
C++ compiler
gcc, Typical configure Options
C++ compiler cannot create executables, Dealing with Problems Compiling MySQL
C:\my.cnf file, Using Client Programs in a Multiple-Server Environment
CACHE INDEX, CACHE INDEX Syntax
caches
clearing, FLUSH Syntax
calculating
dates, Date Calculations
calendar, What Calendar Is Used By MySQL?
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
CASE, Control Flow Functions
case sensitivity
in access checking, How the Privilege System Works
in identifiers, Identifier Case Sensitivity
in names, Identifier Case Sensitivity
in searches, Case Sensitivity in Searches
in string comparisons, String Comparison Functions
case-sensitivity
of database names, MySQL Extensions to Standard SQL
of table names, MySQL Extensions to Standard SQL
CAST, Cast Functions and Operators
cast functions, Cast Functions and Operators
cast operators, Cast Functions and Operators
casts, Type Conversion in Expression Evaluation, Comparison Functions and Operators, Cast Functions and Operators
CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
cc1plus problems, Dealing with Problems Compiling MySQL
CEILING(), Mathematical Functions
Centroid(), MultiPolygon Functions
CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
CHANGE MASTER TO, CHANGE MASTER TO Syntax
ChangeLog, MySQL Change History
changes
Cluster, Changes in MySQL Cluster
InnoDB, Changes in InnoDB
log, MySQL Change History
MySQL 3.23, Changes in release 3.23.x
MySQL 4.0, Changes in release 4.0.x
MySQL 4.1, Changes in release 4.1.x (Production)
changes to privileges, Access Control, Stage 2: Request Verification
changing
column, ALTER TABLE Syntax
column order, How to Change the Order of Columns in a Table
field, ALTER TABLE Syntax
table, ALTER TABLE Syntax, Problems with ALTER TABLE
changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Unix Socket File
CHAR data type, Overview of String Types, String Types
CHAR VARYING data type, Overview of String Types
CHAR(), String Functions
CHARACTER data type, Overview of String Types
character sets, Typical configure Options, The Character Set Used for Data and Sorting
adding, Adding a New Character Set
Character sets, Character Set Support
CHARACTER VARYING data type, Overview of String Types
character-set-client-handshake option
mysqld, Command Options
character-set-server option
mysqld, 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 and Repair Program
mysqld, 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
CHARSET(), Information Functions
CHAR_LENGTH(), String Functions
check option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
check options
myisamchk, myisamchk Check Options
CHECK TABLE, CHECK TABLE Syntax
check-only-changed option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
checking
tables for errors, How to Check MyISAM Tables for Errors
CHECKPOINT Events (MySQL Cluster), Log Events
checkpoint option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
Checksum, Cluster TCP/IP Connections
Checksum (MySQL Cluster), Shared-Memory Connections, SCI Transport Connections
checksum errors, Solaris Notes
CHECKSUM TABLE, CHECKSUM TABLE Syntax
Chinese, Case Sensitivity in Searches
choosing
a MySQL version, Choosing Which MySQL Distribution to Install
choosing types, Choosing the Right Type for a Column
chroot option
mysqld, Command Options
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
clearing
caches, FLUSH Syntax
client programs, Overview of Client and Utility Programs
building, Building Client Programs
client tools, APIs and Libraries
clients
debugging, Debugging a MySQL Client
threaded, How to Make a Threaded Client
closing
tables, How MySQL Opens and Closes Tables
cluster logs, Event Reports Generated in MySQL Cluster, Logging Management Commands
Clustering, MySQL Cluster
CLUSTERLOG commands (MySQL Cluster), Logging Management Commands
CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS
COALESCE(), Comparison Functions and Operators
COERCIBILITY(), Information Functions
ColdFusion, Using Connector/ODBC with ColdFusion
collating
strings, String Collating Support
COLLATION(), Information Functions
collation-server option
mysqld, Command Options
column
changing, ALTER TABLE Syntax
types, Data Types
column comments, CREATE TABLE Syntax
column names
case sensitivity, Identifier Case Sensitivity
column-names option
mysql, mysql Options
columns
changing, How to Change the Order of Columns in a Table
indexes, Column Indexes
names, Database, Table, Index, Column, and Alias Names
other types, Using Data Types from Other Database Engines
selecting, Selecting Particular Columns
storage requirements, Data Type Storage Requirements
columns option
mysqlimport, mysqlimport — A Data Import Program
comma-separated values data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
command options
mysql, mysql Options
MySQL Cluster, Command Options for MySQL Cluster Processes, MySQL Cluster-Related Command Options for mysqld, Command Options for ndbd, Command Options for ndb_mgmd, Command Options for ndb_mgm
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqld, Command Options
command syntax, Conventions Used in This Manual
command-line history
mysql, mysql Options
commands
for binary distribution, Installing MySQL on Other Unix-Like Systems
commands out of sync, Commands out of sync
Comment syntax, Comment Syntax
comments
adding, Comment Syntax
starting, '--' as the Start of a Comment
comments option
mysqldump, mysqldump — A Database Backup Program
COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
commit option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
compact option
mysqldump, mysqldump — A Database Backup Program
comparison operators, Comparison Functions and Operators
compatibility
between MySQL versions, Upgrading from MySQL 4.0 to 4.1, Upgrading from MySQL 3.23 to 4.0
with mSQL, String Comparison Functions
with ODBC, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax
with PostgreSQL, MySQL Extensions to Standard SQL
with standard SQL, MySQL Standards Compliance
with Sybase, USE Syntax
compatible option
mysqldump, mysqldump — A Database Backup Program
compiler
C++ gcc, Typical configure Options
compiling
on Windows, Compiling MySQL Clients on Windows
optimizing, System Factors and Startup Parameter Tuning
problems, Dealing with Problems Compiling MySQL
speed, How Compiling and Linking Affects the Speed of MySQL
statically, Typical configure Options
user-defined functions, Compiling and Installing User-Defined Functions
complete-insert option
mysqldump, mysqldump — A Database Backup Program
compliance
Y2K, Year 2000 Issues and Date Types
compress option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
COMPRESS(), Encryption and Compression Functions
compressed tables, Compressed Table Characteristics
CONCAT(), String Functions
CONCAT_WS(), String Functions
concurrent inserts, Locking Methods, Concurrent Inserts
config-file option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
my_print_defaults, my_print_defaults — Display Options from Option Files
config.cache, Dealing with Problems Compiling MySQL
config.cache file, Dealing with Problems Compiling MySQL
config.ini (MySQL Cluster), Multi-Computer Configuration, Configuration File, Basic Example Configuration, ndb_mgmd, the Management Server Process
configuration
MySQL Cluster, Overview of Cluster Configuration Parameters
configuration files, Causes of Access denied Errors
configuration options, Typical configure Options
configure
enable-thread-safe-client option, Typical configure Options
localstatedir option, Typical configure Options
previx option, Typical configure Options
running after prior invocation, Dealing with Problems Compiling MySQL
with-big-tables option, Typical configure Options
with-charset option, Typical configure Options
with-collation option, Typical configure Options
with-debug option, Typical configure Options
with-embedded-server option, Typical configure Options
with-extra-charsets option, Typical configure Options
with-unix-socket-path option, Typical configure Options
without-server option, Typical configure Options
configure option
--with-low-memory, Dealing with Problems Compiling MySQL
configure script, Typical configure Options
configuring backups
in MySQL Cluster, Configuration for Cluster Backup
configuring MySQL Cluster, Simple Multi-Computer How-To, MySQL Cluster Configuration, MySQL Server Process Usage for MySQL Cluster, ndb_mgmd, the Management Server Process
Configuring MySQL Cluster (concepts), Basic MySQL Cluster Concepts
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
connection
aborted, Communication Errors and Aborted Connections
CONNECTION Events (MySQL Cluster), Log Events
CONNECTION_ID(), Information Functions
Connector/JDBC, Connectors
Connector/MXJ, Connectors
Connector/NET, Connectors, MySQL Connector/NET
reporting problems, Connector/NET Support
Connector/ODBC, Connectors, MySQL Connector/ODBC
Borland, Using Connector/ODBC with Borland Applications
Borland Database Engine, Using Connector/ODBC with Borland Applications
reporting problems, Connector/ODBC Support
Connectors
MySQL, Connectors
connectstring, The Cluster connectstring
connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
console option
mysqld, Command Options
constant table, Optimizing Queries with EXPLAIN, WHERE Clause Optimization
constraints, How MySQL Deals with Constraints
Contains(), Functions That Test Spatial Relationships Between Geometries
contributing companies
list of, Supporters of MySQL
contributors
list of, Contributors to MySQL
control access, Access Control, Stage 1: Connection Verification
control flow functions, Control Flow Functions
CONV(), String Functions
conventions
typographical, Conventions Used in This Manual
CONVERT, Cast Functions and Operators
CONVERT TO, ALTER TABLE Syntax
CONVERT_TZ(), Date and Time Functions
ConvexHull(), Spatial Operators
copy option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
copying databases, Copying MySQL Databases to Another Machine
copying tables, CREATE TABLE Syntax
core-file option
mysqld, Command Options
core-file-size option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
correct-checksum option
myisamchk, myisamchk Repair Options
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
COUNT(), GROUP BY (Aggregate) Functions
COUNT(DISTINCT), GROUP BY (Aggregate) Functions
counting
table rows, Counting Rows
crash, Debugging a MySQL Server
recovery, Using myisamchk for Crash Recovery
repeated, What to Do If MySQL Keeps Crashing
crash-me, The MySQL Benchmark Suite
crash-me program, Designing Applications for Portability, The MySQL Benchmark Suite
CRC32(), Mathematical Functions
CREATE DATABASE, CREATE DATABASE Syntax
CREATE FUNCTION, CREATE FUNCTION Syntax
CREATE INDEX, CREATE INDEX Syntax
CREATE TABLE, CREATE TABLE Syntax
create-options option
mysqldump, mysqldump — A Database Backup Program
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
tables, Creating a Table
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 storage engine, Storage Engines and Table Types, 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
CURTIME(), Date and Time Functions
customers
of MySQL, What We Have Used MySQL For
CXX environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
CXXFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

D

data
character sets, The Character Set Used for Data and Sorting
loading into tables, Loading Data into a Table
retrieving, Retrieving Information from a Table
size, Make Your Data as Small as Possible
data node (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
data nodes (MySQL Cluster), ndbd, the Storage Engine Node Process
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
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
NCHAR, Overview of String Types
NUMERIC, Overview of Numeric 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 design, Design Choices
Database information
obtaining, SHOW Syntax
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, Database Backups
copying, Copying MySQL Databases to Another Machine
creating, Creating and Using a Database
defined, What is MySQL?
information about, Getting Information About Databases and Tables
names, Database, Table, Index, Column, and Alias 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 and Repair Program
mysqldump, mysqldump — A Database Backup Program
DataDir, Defining the Management Server, Defining Data Nodes
datadir option
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
DataJunction, Using Connector/ODBC with Pervasive Software DataJunction
DataMemory, Defining Data Nodes, Configuring Parameters for Local Checkpoints
DATE, Problems Using DATE Columns
date and time functions, Date and Time Functions
Date and Time types, Date and Time Types
date calculations, Date Calculations
DATE columns
problems, Problems Using DATE Columns
DATE data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
date functions
Y2K compliance, Year 2000 Issues and Date Types
date option
mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log
date types, Data Type Storage Requirements
Y2K issues, Year 2000 Issues and Date Types
date values
problems, The DATETIME, DATE, and TIMESTAMP Types
DATE(), Date and Time Functions
DATEDIFF(), Date and Time Functions
DATETIME data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
DATE_ADD(), Date and Time Functions
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, 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, Debugging mysqld under gdb, Environment Variables
DBI_USER environment variable, Environment Variables
DBUG package, The DBUG Package
DEALLOCATE PREPARE, SQL Syntax for Prepared Statements
debug option
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 and Repair Program
mysqld, Command Options
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
my_print_defaults, my_print_defaults — Display Options from Option Files
debug-info option
mysql, mysql Options
debugging
client, Debugging a MySQL Client
server, Debugging a MySQL Server
debugging support, Typical configure Options
DEC data type, Overview of Numeric Types
DECIMAL data type, Overview of Numeric Types
decimal point, Data Types
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 hostname, Connecting to the MySQL Server
default installation location, Installation Layouts
default options, Using Option Files
DEFAULT value clause, Data Type Default Values, CREATE TABLE Syntax
default values, MySQL Design Limitations and Tradeoffs, Data Type Default Values, CREATE TABLE Syntax, INSERT Syntax
BLOB and TEXT columns, The BLOB and TEXT Types
explicit, Data Type Default Values
implicit, Data Type Default Values
suppression, Constraints on Invalid Data
DEFAULT(), Miscellaneous Functions
default-character-set option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqld, 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, Command Options
default-storage-engine option
mysqld, Command Options
default-table-type option
mysqld, Command Options
default-time-zone option
mysqld, Command Options
defaults
embedded, Options with the Embedded Server
defaults-extra-file option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
my_print_defaults, my_print_defaults — Display Options from Option Files
defaults-file option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
my_print_defaults, my_print_defaults — Display Options from Option Files
defaults-group-suffix option
my_print_defaults, my_print_defaults — Display Options from Option Files
DEGREES(), Mathematical Functions
delay-key-write option
mysqld, Command Options, MyISAM Startup Options
delay-key-write-for-all-tables option
mysqld, Command Options
DELAYED, INSERT DELAYED Syntax
delayed-insert option
mysqldump, mysqldump — A Database Backup Program
delayed_insert_limit, INSERT DELAYED Syntax
DELETE, DELETE Syntax
and MySQL Cluster, Known Limitations of MySQL Cluster
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
table, DROP TABLE Syntax
user, Removing User Accounts from MySQL, DROP USER Syntax
users, Removing User Accounts from MySQL, DROP USER Syntax
deletion
mysql.sock, How to Protect or Change the MySQL Unix Socket File
delimiter option
mysql, mysql Options
Delphi, Using Connector/ODBC with Delphi
derived tables, Subqueries in the FROM clause
des-key-file option
mysqld, Command Options
DESC, DESCRIBE Syntax
DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax
description option
myisamchk, Other myisamchk Options
design
choices, Design Choices
issues, Known Issues in MySQL
limitations, MySQL Design Limitations and Tradeoffs
DES_DECRYPT(), Encryption and Compression Functions
DES_ENCRYPT(), Encryption and Compression Functions
developers
list of, Credits
development source tree, Installing from the Development Source Tree
Difference(), Spatial Operators
digits, Data Types
Dimension(), General Geometry Functions
directory structure
default, Installation Layouts
disable-keys option
mysqldump, mysqldump — A Database Backup Program
disable-log-bin option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
DISCARD TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
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, Disk Issues
Diskless, Defining Data Nodes
disks
splitting data across, Using Symbolic Links for Databases on Windows
display size, Data Types
display width, Data Types
displaying
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
COUNT(), GROUP BY (Aggregate) Functions
DISTINCTROW, SELECT Syntax
DIV, Arithmetic Operators
division (/), Arithmetic Operators
DNS, How MySQL Uses DNS
DO, DO Syntax
DocBook XML
documentation source format, About This Manual
Documenters
list of, Documenters and translators
DOUBLE data type, Overview of Numeric Types
DOUBLE PRECISION data type, Overview of Numeric Types
double quote (\"), Strings
downgrades
MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility
downgrading, Downgrading MySQL
downloading, How to Get MySQL
DROP DATABASE, DROP DATABASE Syntax
DROP FOREIGN KEY, ALTER TABLE Syntax, FOREIGN KEY Constraints
DROP FUNCTION, DROP FUNCTION Syntax
DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax
DROP PREPARE, SQL Syntax for Prepared Statements
DROP PRIMARY KEY, ALTER TABLE Syntax
DROP TABLE, DROP TABLE Syntax
and MySQL Cluster, Known Limitations of MySQL Cluster
DROP USER, DROP USER Syntax
dropping
user, Removing User Accounts from MySQL, 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
DUMPFILE, SELECT Syntax
dynamic table characteristics, Dynamic Table Characteristics

E

Eiffel Wrapper, MySQL Eiffel Wrapper
ELT(), String Functions
email lists, MySQL Mailing Lists
embedded MySQL server library, libmysqld, the Embedded MySQL Server Library
enable-named-pipe option
mysqld, Command Options
enable-thread-safe-client option
configure, Typical configure Options
ENCODE(), Encryption and Compression Functions
ENCRYPT(), Encryption and Compression Functions
encryption, Basic SSL Concepts
encryption functions, Encryption and Compression Functions
EndPoint(), LineString Functions
ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the Management Client
entering
queries, Entering Queries
ENUM
size, Data Type Storage Requirements
ENUM data type, Overview of String Types, The ENUM Type
Envelope(), General Geometry Functions
environment variable
CC, Typical configure Options, Dealing with Problems Compiling MySQL
CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL
CXX, Typical configure Options, Dealing with Problems Compiling MySQL
CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL
HOME, mysql Options
LD_RUN_PATH, Linux Source Distribution Notes, Solaris Notes
MYSQL_DEBUG, Overview of Client and Utility Programs
MYSQL_HISTFILE, mysql Options
MYSQL_HOST, Connecting to the MySQL Server
MYSQL_PWD, Connecting to the MySQL Server, Overview of Client and Utility Programs
MYSQL_TCP_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs
MYSQL_UNIX_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs
PATH, Installing MySQL on Other Unix-Like Systems, Invoking MySQL Programs
USER, Connecting to the MySQL Server
Environment variable
CC, Environment Variables
CFLAGS, Environment Variables
CXX, Dealing with Problems Compiling MySQL, Environment Variables
CXXFLAGS, Environment Variables
DBI_TRACE, Debugging mysqld under gdb, Environment Variables
DBI_USER, Environment Variables
HOME, Environment Variables
LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
LD_RUN_PATH, Problems Using the Perl DBI/DBD Interface, Environment Variables
MYSQL_DEBUG, Debugging a MySQL Client, Environment Variables
MYSQL_GROUP_SUFFIX, Environment Variables
MYSQL_HISTFILE, Environment Variables
MYSQL_HOME, Environment Variables
MYSQL_HOST, Environment Variables
MYSQL_PS1, Environment Variables
MYSQL_PWD, Environment Variables
MYSQL_TCP_PORT, Environment Variables
MYSQL_UNIX_PORT, Problems Running mysql_install_db, Environment Variables
PATH, Environment Variables
TMPDIR, Problems Running mysql_install_db, Environment Variables
TZ, Time Zone Problems, Environment Variables
UMASK, Problems with File Permissions, Environment Variables
UMASK_DIR, Problems with File Permissions, Environment Variables
USER, Environment Variables
Environment variables
CXX, Dealing with Problems Compiling MySQL
environment variables, Using Environment Variables to Specify Options, Causes of Access denied Errors, Overview of Client and Utility Programs
list of, Environment Variables
equal (=), Comparison Functions and Operators
Equals(), Functions That Test Spatial Relationships Between Geometries
ERROR Events (MySQL Cluster), Log Events
error logs (MySQL Cluster), ndbd, the Storage Engine Node Process
error messages
can't find file, Problems with File Permissions
languages, Setting the Error Message Language
errors
access denied, Access denied
checking tables for, How to Check MyISAM Tables for Errors
common, Problems and Common Errors
directory checksum, Solaris Notes
handling for UDFs, UDF Return Values and Error Handling
known, Known Issues in MySQL
linking, Problems Linking to the MySQL Client Library
list of, Common Errors When Using MySQL Programs
reporting, General Information, How to Report Bugs or Problems
escape (\\), Strings
escape characters, Literal Values
estimating
query performance, Estimating Query Performance
event log format (MySQL Cluster), Log Events
event logs (MySQL Cluster), Event Reports Generated in MySQL Cluster, Logging Management Commands
event severity levels (MySQL Cluster), Logging Management Commands
event types (MySQL Cluster), Event Reports Generated in MySQL Cluster, Log Events
example option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
EXAMPLE storage engine, Storage Engines and Table Types, The EXAMPLE Storage Engine
examples
compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables
myisamchk output, Getting Information About a Table
queries, Examples of Common Queries
EXECUTE, SQL Syntax for Prepared Statements
execute option
mysql, mysql Options
EXECUTE statement, SQL Syntax for Prepared Statements
ExecuteOnComputer, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes
EXIT command (MySQL Cluster), Commands in the Management Client
EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the Management Client
exit-info option
mysqld, Command Options
EXP(), Mathematical Functions
EXPLAIN, Optimizing Queries with EXPLAIN
explicit default values, Data Type Default Values
EXPORT_SET(), String Functions
expression aliases, GROUP BY and HAVING with Hidden Fields, SELECT Syntax
expressions
extended, Pattern Matching
extend-check option
myisamchk, myisamchk Check Options, myisamchk Repair Options
extended option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
extended-insert option
mysqldump, mysqldump — A Database Backup Program
extensions
to standard SQL, MySQL Standards Compliance
ExteriorRing(), Polygon Functions
external locking, Command Options, System Variables, Using myisamchk for Crash Recovery, SHOW PROCESSLIST Syntax
external-locking option
mysqld, Command Options
extra-file option
my_print_defaults, my_print_defaults — Display Options from Option Files
EXTRACT(), Date and Time Functions
extracting
dates, Date Calculations

F

FALSE, Numbers, Boolean Values
fast option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
fatal signal 11, Dealing with Problems Compiling MySQL
features of MySQL, The Main Features of MySQL
field
changing, ALTER TABLE Syntax
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
files
binary log, The Binary Log
config.cache, Dealing with Problems Compiling MySQL
error messages, Setting the Error Message Language
general query log, The General Query Log
log, Typical configure Options, Server Log Maintenance
my.cnf, Replication Features and Known Problems
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
tmp, Problems Running mysql_install_db
update log, The Update Log
filesort optimization, ORDER BY Optimization
FileSystemPath, Defining Data Nodes
FIND_IN_SET(), String Functions
FIXED data type, Overview of Numeric Types
FLOAT data type, Overview of Numeric Types
floating-point number, Overview of Numeric Types
floats, Numbers
FLOOR(), Mathematical Functions
FLUSH, FLUSH Syntax
flush option
mysqld, Command Options
flush tables, mysqladmin — Client for Administering a MySQL Server
flush-logs option
mysqldump, mysqldump — A Database Backup Program
flushlog option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
FOR UPDATE, SELECT Syntax
FORCE INDEX, SELECT Syntax, JOIN Syntax, Optimizer-Related Issues
FORCE KEY, SELECT Syntax, JOIN 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 and Repair Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
force-read option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
foreign key
constraint, PRIMARY KEY and UNIQUE Index Constraints
deleting, ALTER TABLE Syntax, FOREIGN KEY Constraints
foreign keys, Foreign Keys, Using Foreign Keys, ALTER TABLE Syntax
FORMAT(), String Functions
Forums, MySQL Community Support at the MySQL Forums
FOUND_ROWS(), Information Functions
FreeBSD troubleshooting, Dealing with Problems Compiling MySQL
frequently-asked questions about MySQL Cluster, MySQL Cluster FAQ
FROM, SELECT Syntax
FROM_DAYS(), Date and Time Functions
FROM_UNIXTIME(), Date and Time Functions
ft_max_word_len myisamchk variable, myisamchk General Options
ft_min_word_len myisamchk variable, myisamchk General Options
ft_stopword_file myisamchk variable, myisamchk General Options
full disk, How MySQL Handles a Full Disk
full-text search, Full-Text Search Functions
fulltext
stopword list, Fine-Tuning MySQL Full-Text Search
function
creating, CREATE FUNCTION Syntax
deleting, DROP FUNCTION Syntax
function names
parsing, Function Name Parsing and Resolution
resolving ambiguity, Function Name Parsing and Resolution
functions, Functions and Operators
arithmetic, Bit Functions
bit, Bit Functions
C API, C API Function Overview
C Prepared statement API, C API Prepared Statement Function Overview
cast, Cast Functions and Operators
control flow, Control Flow Functions
date and time, Date and Time Functions
encryption, Encryption and Compression Functions
GROUP BY, GROUP BY (Aggregate) Functions
grouping, Operator Precedence
information, Information Functions
mathematical, Mathematical Functions
miscellaneous, Miscellaneous Functions
native
adding, Adding a New Native Function
new, Adding New Functions to MySQL
string, String Functions
string comparison, String Comparison Functions
user-defined, Adding New Functions to MySQL
adding, Adding a New User-Defined Function
Functions
user-defined, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
functions for SELECT and WHERE clauses, Functions and Operators

G

gcc, Typical configure Options
gdb
using, Debugging mysqld under gdb
general information, General Information
General Public License, What is MySQL?
general query log, The General Query Log
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
goals of MySQL, What is MySQL?
GPL
General Public License, GNU General Public License
GNU General Public License, GNU General Public License
MySQL FLOSS License Exception, MySQL FLOSS License Exception
GRANT, GRANT Syntax
GRANT statement, Adding New User Accounts to MySQL
grant tables, Access Control, Stage 2: Request Verification
re-creating, Problems Running mysql_install_db
sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
granting
privileges, GRANT Syntax
GRANTS, SHOW GRANTS Syntax
greater than (>), Comparison Functions and Operators
greater than or equal (>=), Comparison Functions and Operators
GREATEST(), Comparison Functions and Operators
GROUP BY, GROUP BY Optimization
aliases in, GROUP BY and HAVING with Hidden Fields
extensions to standard SQL, GROUP BY and HAVING with Hidden Fields, SELECT Syntax
GROUP BY functions, GROUP BY (Aggregate) Functions
grouping
expressions, Operator Precedence
GROUP_CONCAT(), GROUP BY (Aggregate) Functions

H

HANDLER, HANDLER Syntax
handling
errors, UDF Return Values and Error Handling
HAVING, SELECT Syntax
HEAP storage engine, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine
HeartbeatIntervalDbApi (MySQL Cluster configuration parameter), Defining Data Nodes
HeartbeatIntervalDbDb (MySQL Cluster configuration parameter), Defining Data Nodes
HELP command (MySQL Cluster), Commands in the Management Client
help option
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 and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
my_print_defaults, my_print_defaults — Display Options from Option Files
perror, perror — Explain Error Codes
HELP statement, HELP Syntax
HEX(), String Functions
hex-blob option
mysqldump, mysqldump — A Database Backup Program
hexadecimal values, Hexadecimal Values
HIGH_PRIORITY, SELECT Syntax
hints, MySQL Extensions to Standard SQL, SELECT Syntax, JOIN Syntax
index, SELECT Syntax, JOIN Syntax
history of MySQL, History of MySQL
HOME environment variable, mysql Options, Environment Variables
host option
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 and Repair 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
mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log
host table, Access Control, Stage 2: Request Verification
sorting, Access Control, Stage 2: Request Verification
Host*SciId* parameters, SCI Transport Connections
host.frm
problems finding, Unix Post-Installation Procedures
hostname
default, Connecting to the MySQL Server
HostName, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes
hostname caching, How MySQL Uses DNS
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
Id, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes
ID
unique, How to Get the Unique ID for the Last Inserted Row
identifiers, Database, Table, Index, Column, and Alias Names
case sensitivity, Identifier Case Sensitivity
quoting, Database, Table, Index, Column, and Alias Names
IF(), Control Flow Functions
IFNULL(), Control Flow Functions
IGNORE INDEX, SELECT Syntax, JOIN Syntax
IGNORE KEY, SELECT Syntax, JOIN Syntax
ignore option
mysqlimport, mysqlimport — A Data Import Program
ignore-lines option
mysqlimport, mysqlimport — A Data Import Program
ignore-spaces option
mysql, mysql Options
ignore-table option
mysqldump, mysqldump — A Database Backup Program
IGNORE_SPACE SQL mode, SQL Modes
implicit default values, Data Type Default Values
IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
IN, Comparison Functions and Operators
increasing
performance, Replication FAQ
increasing with replication
speed, Replication
index
deleting, ALTER TABLE Syntax, DROP INDEX Syntax
index hints, SELECT Syntax, JOIN Syntax
indexes, CREATE INDEX Syntax
and BLOB columns, Column Indexes, CREATE TABLE Syntax
and IS NULL, How MySQL Uses Indexes
and LIKE, How MySQL Uses Indexes
and NULL values, CREATE TABLE Syntax
and TEXT columns, Column Indexes, CREATE TABLE Syntax
assigning to key cache, CACHE INDEX Syntax
block size, System Variables
columns, Column Indexes
leftmost prefix of, How MySQL Uses Indexes
multi-column, Multiple-Column Indexes
multiple-part, CREATE INDEX Syntax
names, Database, Table, Index, Column, and Alias Names
use of, How MySQL Uses Indexes
IndexMemory, Defining Data Nodes, Configuring Parameters for Local Checkpoints
INET_ATON(), Miscellaneous Functions
INET_NTOA(), Miscellaneous Functions
INFO Events (MySQL Cluster), Log Events
information functions, Information Functions
information option
myisamchk, myisamchk Check Options
init-file option
mysqld, Command Options
INNER JOIN, JOIN Syntax
InnoDB, InnoDB Overview
Solaris 10 x86_64 issues, Solaris Notes
innodb option
mysqld, InnoDB Startup Options and System Variables
InnoDB storage engine, Storage Engines and Table Types, The InnoDB Storage Engine
InnoDB tables, Transactions and Atomic Operations
innodb-safe-binlog option
mysqld, Command Options
innodb_status_file option
mysqld, InnoDB Startup Options and System Variables
INSERT, Speed of INSERT Statements, INSERT Syntax
INSERT ... SELECT, INSERT ... SELECT Syntax
INSERT DELAYED, INSERT DELAYED Syntax
INSERT statement
grant privileges, Adding New User Accounts to MySQL
INSERT(), String Functions
insert-ignore option
mysqldump, mysqldump — A Database Backup Program
inserting
speed of, Speed of INSERT Statements
inserts
concurrent, Locking Methods, Concurrent Inserts
installation layouts, Installation Layouts
installation overview, MySQL Installation Using a Source Distribution
installing
binary distribution, Installing MySQL on Other Unix-Like Systems
Linux RPM packages, Installing MySQL on Linux
Mac OS X PKG packages, Installing MySQL on Mac OS X
overview, Installing and Upgrading MySQL
Perl, Perl Installation Notes
Perl on Windows, Installing ActiveState Perl on Windows
Solaris PKG packages, Installing MySQL on Solaris
source distribution, MySQL Installation Using a Source Distribution
user-defined functions, Compiling and Installing User-Defined Functions
installing MySQL Cluster, Simple Multi-Computer How-To, Multi-Computer Installation, Installing the Software
INSTR(), String Functions
INT data type, Overview of Numeric Types
INTEGER data type, Overview of Numeric Types
integers, Numbers
InteriorRingN(), Polygon Functions
internal compiler errors, Dealing with Problems Compiling MySQL
internal locking, Locking Methods
internals, MySQL Internals
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
IRC, MySQL Community Support on Internet Relay Chat (IRC)
IS NOT NULL, Comparison Functions and Operators
IS NULL, IS NULL Optimization, Comparison Functions and Operators
and indexes, How MySQL Uses Indexes
ISAM storage engine, Storage Engines and Table Types, The ISAM Storage Engine
isamchk, Overview of Client and Utility Programs
isamlog, Overview of Client and Utility Programs
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

K

keepold option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
Key cache
MyISAM, The MyISAM Key Cache
key cache
assigning indexes to, CACHE INDEX Syntax
key space
MyISAM, Space Needed for Keys
keys, Column Indexes
foreign, Foreign Keys, Using Foreign Keys
multi-column, Multiple-Column Indexes
searching on two, Searching on Two Keys
keys option
mysqlshow, mysqlshow — Display Database, Table, and Column Information
keys-used option
myisamchk, myisamchk Repair Options
keywords, Reserved Words
key_buffer_size myisamchk variable, myisamchk General Options
KILL, KILL Syntax
known errors, Known Issues in MySQL

L

language option
mysqld, Command Options
language support
error messages, Setting the Error Message Language
last row
unique ID, How to Get the Unique ID for the Last Inserted Row
LAST_DAY(), Date and Time Functions
LAST_INSERT_ID(), Transactions and Atomic Operations, INSERT Syntax
LAST_INSERT_ID([expr]), Information Functions
layout of installation, Installation Layouts
LCASE(), String Functions
LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD Interface
LD_RUN_PATH environment variable, Linux Source Distribution Notes, Solaris Notes, Problems Using the Perl DBI/DBD Interface, Environment Variables
LEAST(), Comparison Functions and Operators
ledir option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization, JOIN Syntax
LEFT OUTER JOIN, JOIN Syntax
LEFT(), String Functions
leftmost prefix of indexes, How MySQL Uses Indexes
legal names, Database, Table, Index, Column, and Alias 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
libraries
list of, Libraries used by and included with MySQL
library
mysqlclient, APIs and Libraries
mysqld, APIs and Libraries
License, MySQL FLOSS License Exception
LIKE, String Comparison Functions
and indexes, How MySQL Uses Indexes
and wildcards, How MySQL Uses Indexes
LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax
limitations
design, MySQL Design Limitations and Tradeoffs
MySQL Limitations, Limits in MySQL
replication, Replication Features and Known Problems
limitations of MySQL Cluster, Known Limitations of MySQL Cluster
limits
file-size, The table is full
MySQL Limits, limits in MySQL, Limits in MySQL
line-numbers option
mysql, mysql Options
linefeed (\n), Strings
LineFromText(), Creating Geometry Values Using WKT Functions
LineFromWKB(), Creating Geometry Values Using WKB Functions
lines-terminated-by option
mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
LINESTRING data type, MySQL Spatial Data Types
LineString(), Creating Geometry Values Using MySQL-Specific Functions
LineStringFromText(), Creating Geometry Values Using WKT Functions
LineStringFromWKB(), Creating Geometry Values Using WKB Functions
linking, Building Client Programs
errors, Problems Linking to the MySQL Client Library
problems, Problems Linking with the C API
speed, How Compiling and Linking Affects the Speed of MySQL
links
symbolic, Using Symbolic Links
Linux
binary distribution, Linux Binary Distribution Notes
source distribution, Linux Source Distribution Notes
literals, Literal Values
LN(), Mathematical Functions
LOAD DATA FROM MASTER, LOAD DATA FROM MASTER Syntax
LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values
LOAD TABLE FROM MASTER, LOAD TABLE tbl_name FROM MASTER Syntax
loading
tables, Loading Data into a Table
LOAD_FILE(), String Functions
local checkpoints (MySQL Cluster), Configuring Parameters for Local Checkpoints
local option
mysqlimport, mysqlimport — A Data Import Program
local-infile option
mysql, mysql Options
mysqld, Security-Related mysqld Options
local-load option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
localstatedir option
configure, Typical configure Options
LOCALTIME, Date and Time Functions
LOCALTIMESTAMP, Date and Time Functions
LOCATE(), String Functions
LOCK IN SHARE MODE, SELECT Syntax
LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax
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
locking, System Factors and Startup Parameter Tuning
external, Command Options, System Variables, Using myisamchk for Crash Recovery, SHOW PROCESSLIST Syntax
page-level, Locking Methods
row-level, Transactions and Atomic Operations, Locking Methods
table-level, Locking Methods
locking methods, Locking Methods
LockPagesInMainMemory, Defining Data Nodes
log
changes, MySQL Change History
log files, Typical configure Options, MySQL Server Logs
maintaining, Server Log Maintenance
names, Database Backups
log files (MySQL Cluster), ndbd, the Storage Engine Node Process
log option
mysqld, Command Options
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
LOG(), Mathematical Functions
log-bin option
mysqld, Command Options
log-bin-index option
mysqld, Command Options
log-error option
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
log-isam option
mysqld, Command Options
log-long-format option
mysqld, Command Options
log-queries-not-using-indexes option
mysqld, Command Options
log-short-format option
mysqld, Command Options
log-slave-updates option
mysqld, Replication Startup Options
log-slow-admin-statements option
mysqld, Command Options
log-slow-queries option
mysqld, Command Options
log-update option
mysqld, Command Options
log-warnings option
mysqld, Command Options, Replication Startup Options
LOG10(), Mathematical Functions
LOG2(), Mathematical Functions
LogDestination, Defining the Management Server
logging commands (MySQL Cluster), Logging Management Commands
logical operators, Logical Operators
LogLevelCheckpoint (MySQL Cluster configuration parameter), Defining Data Nodes
LogLevelConnection (MySQL Cluster configuration parameter), Defining Data Nodes
LogLevelError, Defining Data Nodes
LogLevelInfo, Defining Data Nodes
LogLevelNodeRestart (MySQL Cluster configuration parameter), Defining Data Nodes
LogLevelShutdown (MySQL Cluster configuration parameter), Defining Data Nodes
LogLevelStartup (MySQL Cluster configuration parameter), Defining Data Nodes
LogLevelStatistic (MySQL Cluster configuration parameter), Defining Data Nodes
LONG data type, The BLOB and TEXT Types
LONGBLOB data type, Overview of String Types
LongMessageBuffer, Defining Data Nodes
LONGTEXT data type, Overview of String Types
low-priority option
mysqlimport, mysqlimport — A Data Import Program
low-priority-updates option
mysqld, Command Options
LOWER(), String Functions
LPAD(), String Functions
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 Table Maintenance Schedule
MAKEDATE(), Date and Time Functions
MAKETIME(), Date and Time Functions
make_binary_distribution, Overview of Server-Side Programs
MAKE_SET(), String Functions
make_win_src_distribution, Creating a Windows Source Package from the Latest Development Source
management client (MySQL Cluster), ndb_mgm, the Management Client Process
management node (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
management nodes (MySQL Cluster), ndb_mgmd, the Management Server Process
managing MySQL Cluster, Management of MySQL Cluster
managing MySQL Cluster processes, Process Management in MySQL Cluster
manual
available formats, About This Manual
online location, About This Manual
typographical conventions, Conventions Used in This Manual
master-connect-retry option
mysqld, Replication Startup Options
master-data option
mysqldump, mysqldump — A Database Backup Program
master-host option
mysqld, Replication Startup Options
master-info-file option
mysqld, Replication Startup Options
master-password option
mysqld, Replication Startup Options
master-port option
mysqld, Replication Startup Options
master-retry-count option
mysqld, Replication Startup Options
master-ssl option
mysqld, Replication Startup Options
master-ssl-ca option
mysqld, Replication Startup Options
master-ssl-capath option
mysqld, Replication Startup Options
master-ssl-cert option
mysqld, Replication Startup Options
master-ssl-cipher option
mysqld, Replication Startup Options
master-ssl-key option
mysqld, Replication Startup Options
master-user option
mysqld, Replication Startup Options
master/slave setup, Replication Implementation Overview
MASTER_POS_WAIT(), Miscellaneous Functions, MASTER_POS_WAIT() Syntax
MATCH ... AGAINST(), Full-Text Search Functions
matching
patterns, Pattern Matching
mathematical functions, Mathematical Functions
MAX(), GROUP BY (Aggregate) Functions
max-record-length option
myisamchk, myisamchk Repair Options
max-relay-log-size option
mysqld, Replication Startup Options
MAXDB SQL mode, SQL Modes
maximum memory used, mysqladmin — Client for Administering a MySQL Server
maximums
maximum tables per join, Limits of Joins
MaxNoOfAttributes, Defining Data Nodes
MaxNoOfConcurrentIndexOperations, Defining Data Nodes
MaxNoOfConcurrentOperations, Defining Data Nodes
MaxNoOfConcurrentScans, Defining Data Nodes
MaxNoOfConcurrentTransactions, Defining Data Nodes
MaxNoOfFiredTriggers, Defining Data Nodes
MaxNoOfIndexes, Defining Data Nodes
MaxNoOfLocalOperations, Defining Data Nodes
MaxNoOfLocalScans, Defining Data Nodes
MaxNoOfOpenFiles, Defining Data Nodes
MaxNoOfOrderedIndexes, Defining Data Nodes
MaxNoOfSavedMessages, Defining Data Nodes
MaxNoOfTables, Defining Data Nodes
MaxNoOfTriggers, Defining Data Nodes
MaxNoOfUniqueHashIndexes, Defining Data Nodes
MaxScanBatchSize, Defining SQL and Other API Nodes
max_allowed_packet variable, mysql Options
MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources
max_join_size variable, mysql Options
MAX_QUERIES_PER_HOUR, Limiting Account Resources
MAX_UPDATES_PER_HOUR, Limiting Account Resources
MAX_USER_CONNECTIONS, Limiting Account Resources
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 and Repair 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, Command Options
MEMORY storage engine, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine
memory usage
myisamchk, myisamchk Memory Usage
memory use, How MySQL Uses Memory, mysqladmin — Client for Administering a MySQL Server
in MySQL Cluster, Known Limitations of MySQL Cluster
MERGE storage engine, Storage Engines and Table Types, The MERGE Storage Engine
MERGE tables
defined, The MERGE Storage Engine
method option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
methods
locking, Locking Methods
mgm (MySQL Cluster process), ndb_mgm, the Management Client Process
mgmd (MySQL Cluster process), ndb_mgmd, the Management Server Process
mgmd (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
MICROSECOND(), Date and Time Functions
Microsoft Access, Microsoft Access
Microsoft ADO, Microsoft ADO
Microsoft Excel, Microsoft Excel and Column Types
Microsoft Visual Basic, Microsoft Visual Basic
Microsoft Visual InterDev, Microsoft Visual InterDev
MID(), String Functions
MIN(), GROUP BY (Aggregate) Functions
Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs)
minus
unary (-), Arithmetic Operators
MINUTE(), Date and Time Functions
mirror sites, How to Get MySQL
miscellaneous functions, Miscellaneous Functions
MIT-pthreads, MIT-pthreads Notes
MLineFromText(), Creating Geometry Values Using WKT Functions
MLineFromWKB(), Creating Geometry Values Using WKB Functions
MOD (modulo), Mathematical Functions
MOD(), Mathematical Functions
modes
batch, Using mysql in Batch Mode
modulo (%), Mathematical Functions
modulo (MOD), Mathematical Functions
monitor
terminal, Tutorial
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, String Comparison Functions
MSSQL SQL mode, SQL Modes
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 servers, Running Multiple MySQL Servers on the Same Machine
multiple-part index, CREATE INDEX Syntax
multiplication (*), Arithmetic Operators
MULTIPOINT data type, MySQL Spatial Data Types
MultiPoint(), Creating Geometry Values Using MySQL-Specific Functions
MultiPointFromText(), Creating Geometry Values Using WKT Functions
MultiPointFromWKB(), Creating Geometry Values Using WKB Functions
MULTIPOLYGON data type, MySQL Spatial Data Types
MultiPolygon(), Creating Geometry Values Using MySQL-Specific Functions
MultiPolygonFromText(), Creating Geometry Values Using WKT Functions
MultiPolygonFromWKB(), Creating Geometry Values Using WKB Functions
My
derivation, History of MySQL
my.cnf
and MySQL Cluster, Multi-Computer Configuration, Configuration File, Basic Example Configuration
in MySQL Cluster, MySQL Server Process Usage for MySQL Cluster
my.cnf file, Replication Features and Known Problems
MyISAM
compressed tables, Compressed Table Characteristics
size, Data Type Storage Requirements
MyISAM key cache, The MyISAM Key Cache
MyISAM storage engine, Storage Engines and Table Types, The MyISAM Storage Engine
myisam-recover option
mysqld, Command Options, MyISAM Startup Options
myisamchk, Typical configure Options, Overview of Client and Utility Programs
analyze option, Other myisamchk Options
backup option, myisamchk Repair Options
block-search option, Other myisamchk Options
character-sets-dir option, myisamchk Repair Options
check option, myisamchk Check Options
check-only-changed option, myisamchk Check Options
correct-checksum option, myisamchk Repair Options
data-file-length option, myisamchk Repair Options
debug option, myisamchk General Options
description option, Other myisamchk Options
example output, Getting Information About a Table
extend-check option, myisamchk Check Options, myisamchk Repair Options
fast option, myisamchk Check Options
force option, myisamchk Check Options, myisamchk Repair Options
help option, myisamchk General Options
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 Client and Utility Programs
myisampack, Overview of Client and Utility Programs, 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
packlength 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_ftdump, Overview of Client and Utility Programs
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
MyODBC, MySQL Connector/ODBC
MySQL
defined, What is MySQL?
introduction, What is MySQL?
pronunciation, What is MySQL?
mysql, Overview of Client and Utility Programs
auto-rehash option, mysql Options
batch option, mysql Options
character-sets-dir option, mysql Options
column-names option, mysql Options
compress option, mysql Options
database option, mysql Options
debug option, mysql Options
debug-info option, mysql Options
default-character-set option, mysql Options
delimiter option, mysql Options
execute option, mysql Options
force option, mysql Options
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
one-database option, mysql Options
pager option, mysql Options
password option, mysql Options
port option, mysql Options
prompt option, mysql Options
protocol option, mysql Options
quick option, mysql Options
raw option, mysql Options
reconnect option, mysql Options
safe-updates option, mysql Options
secure-auth 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
SSL options, mysql Options
table option, mysql Options
tee option, mysql Options
unbuffered option, mysql Options
user option, mysql Options
verbose option, mysql Options
version option, mysql Options
vertical option, mysql Options
wait option, mysql Options
xml option, mysql Options
MySQL AB
defined, Overview of MySQL AB
MySQL binary distribution, Choosing Which MySQL Distribution to Install
MYSQL C type, C API Data types
MySQL Cluster, MySQL Cluster
administration, ndb_mgm, the Management Client Process, Command Options for MySQL Cluster Processes, MySQL Cluster-Related Command Options for mysqld, Command Options for ndbd, Command Options for ndb_mgmd, Command Options for ndb_mgm, Commands in the Management Client, Using CLUSTERLOG STATISTICS
and DNS, Simple Multi-Computer How-To
and IP addressing, Simple Multi-Computer How-To
and networking, Hardware, Software, and Networking
API node, Basic MySQL Cluster Concepts, Defining SQL and Other API Nodes
arbitrator, MySQL Cluster FAQ
available platforms, MySQL Cluster
backups, On-line Backup of MySQL Cluster, Cluster Backup Concepts, Using The Management Client to Create a Backup, How to Restore a Cluster Backup, Configuration for Cluster Backup, Backup Troubleshooting
benchmarks, Understanding the Impact of Cluster Interconnects
CHECKPOINT Events, Log Events
cluster logs, Event Reports Generated in MySQL Cluster, Logging Management Commands
CLUSTERLOG commands, Logging Management Commands
CLUSTERLOG STATISTICS command, Using CLUSTERLOG STATISTICS
commands, Command Options for MySQL Cluster Processes, MySQL Cluster-Related Command Options for mysqld, Command Options for ndbd, Command Options for ndb_mgmd, Command Options for ndb_mgm, Commands in the Management Client
compiling from source, Building MySQL Cluster from Source Code
concepts, Basic MySQL Cluster Concepts
configuration, Simple Multi-Computer How-To, MySQL Cluster Configuration, Quick Test Setup of MySQL Cluster, Defining Cluster Computers, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes, Configuring Parameters for Local Checkpoints, MySQL Server Process Usage for MySQL Cluster, ndb_mgmd, the Management Server Process
configuration (example), Basic Example Configuration
configuration changes, Performing a Rolling Restart of the Cluster
configuration files, Multi-Computer Configuration, Configuration File
configuration parameters, Overview of Cluster Configuration Parameters, Data Node Configuration Parameters, Management Node Configuration Parameters, SQL Node and API Node Configuration Parameters
configuring, Configuration for Cluster Backup
CONNECTION Events, Log Events
connectstring, The Cluster connectstring
data node, Basic MySQL Cluster Concepts, Defining Data Nodes
data nodes, ndbd, the Storage Engine Node Process
data types supported, MySQL Cluster FAQ
defining node hosts, Defining Cluster Computers
direct connections between nodes, TCP/IP Connections Using Direct Connections
ENTER SINGLE USER MODE command, Commands in the Management Client
ERROR Events, Log Events
error logs, ndbd, the Storage Engine Node Process
error messages, MySQL Cluster FAQ
event log format, Log Events
event logging thresholds, Logging Management Commands
event logs, Event Reports Generated in MySQL Cluster, Logging Management Commands
event severity levels, Logging Management Commands
event types, Event Reports Generated in MySQL Cluster, Log Events
EXIT command, Commands in the Management Client
EXIT SINGLE USER MODE command, Commands in the Management Client
FAQ, MySQL Cluster FAQ
general description, MySQL Cluster Overview
hardware requirements, MySQL Cluster FAQ
HELP command, Commands in the Management Client
how to obtain, MySQL Cluster FAQ
importing existing tables, MySQL Cluster FAQ
INFO Events, Log Events
information sources, MySQL Cluster
installation, Simple Multi-Computer How-To, Multi-Computer Installation, Installing the Software
interconnects, Using High-Speed Interconnects with MySQL Cluster
log files, ndbd, the Storage Engine Node Process
logging commands, Logging Management Commands
management client (mgm), ndb_mgm, the Management Client Process
management commands, Using CLUSTERLOG STATISTICS
management node, Basic MySQL Cluster Concepts, Defining the Management Server
management nodes, ndb_mgmd, the Management Server Process
managing, Management of MySQL Cluster
memory requirements, MySQL Cluster FAQ
memory usage and recovery, Performing a Rolling Restart of the Cluster, Known Limitations of MySQL Cluster
mgm, Command Options for MySQL Cluster Processes
mgm client, Commands in the Management Client
mgm management client, Using CLUSTERLOG STATISTICS
mgm process, ndb_mgm, the Management Client Process, Command Options for ndb_mgm
mgmd, Command Options for MySQL Cluster Processes
mgmd process, ndb_mgmd, the Management Server Process, Command Options for ndb_mgmd
mysqld process, MySQL Server Process Usage for MySQL Cluster, MySQL Cluster-Related Command Options for mysqld
ndbd, Command Options for MySQL Cluster Processes
ndbd process, ndbd, the Storage Engine Node Process, Command Options for ndbd, Using CLUSTERLOG STATISTICS
ndb_mgm, Initial Startup
ndb_size.pl (utility), MySQL Cluster FAQ
network configuration (SCI), Configuring MySQL Cluster to use SCI Sockets
network transporters, Using High-Speed Interconnects with MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets
networking, TCP/IP Connections Using Direct Connections, Shared-Memory Connections, SCI Transport Connections
networking requirements, MySQL Cluster FAQ
node failure (single user mode), Single User Mode
node identifiers, Shared-Memory Connections, SCI Transport Connections
node logs, Event Reports Generated in MySQL Cluster
node types, MySQL Cluster FAQ
NODERESTART Events, Log Events
nodes and node groups, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
nodes and types, Basic MySQL Cluster Concepts
number of computers required, MySQL Cluster FAQ
obtaining, Multi-Computer Installation
partitions, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
performance, Understanding the Impact of Cluster Interconnects
performing queries, Loading Sample Data and Performing Queries
platforms supported, MySQL Cluster FAQ
process management, Process Management in MySQL Cluster
quick configuration, Quick Test Setup of MySQL Cluster
QUIT command, Commands in the Management Client
replicas, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
requirements, Hardware, Software, and Networking
resetting, Performing a Rolling Restart of the Cluster
RESTART command, Commands in the Management Client
restarting, Safe Shutdown and Restart
restoring backups, How to Restore a Cluster Backup
roles of computers, MySQL Cluster FAQ
runtime statistics, Using CLUSTERLOG STATISTICS
SCI (Scalable Coherent Interface), SCI Transport Connections, Configuring MySQL Cluster to use SCI Sockets
SCI drivers, Configuring MySQL Cluster to use SCI Sockets
SCI network configuration, Configuring MySQL Cluster to use SCI Sockets
SCI software installation, Configuring MySQL Cluster to use SCI Sockets
SCI software requirements, Configuring MySQL Cluster to use SCI Sockets
SCI, performance vs TCP/IP, Understanding the Impact of Cluster Interconnects
shared memory transport, Shared-Memory Connections
SHOW command, Commands in the Management Client
SHUTDOWN command, Commands in the Management Client
shutting down, Safe Shutdown and Restart
single user mode, Commands in the Management Client, Single User Mode
SQL node, Basic MySQL Cluster Concepts, Defining SQL and Other API Nodes
SQL nodes, MySQL Server Process Usage for MySQL Cluster
SQL statements, MySQL Cluster FAQ
START BACKUP command, Using The Management Client to Create a Backup
START command, Commands in the Management Client
starting and stopping, MySQL Cluster FAQ
starting nodes, Initial Startup
starting or restarting, MySQL Cluster Startup Phases
starting with --initial, Quick Test Setup of MySQL Cluster
STARTUP Events, Log Events
STATISTICS Events, Log Events
STATUS command, Commands in the Management Client
STOP command, Commands in the Management Client
storage requirements, Data Type Storage Requirements
terminology, MySQL Cluster Glossary
trace files, ndbd, the Storage Engine Node Process
transaction isolation levels supported, MySQL Cluster FAQ
transactions, Defining Data Nodes, MySQL Cluster FAQ
transporters
Scalable Coherent Interface (SCI), SCI Transport Connections
shared memory (SHM), Shared-Memory Connections
TCP/IP, TCP/IP Connections Using Direct Connections
troubleshooting backups, Backup Troubleshooting
upgrades and downgrades, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility
using tables and data, Loading Sample Data and Performing Queries
vs replication, MySQL Cluster FAQ
MySQL Cluster Glossary, MySQL Cluster Glossary
MySQL Cluster How-To, Simple Multi-Computer How-To
MySQL Cluster limitations, Known Limitations of MySQL Cluster
causing errors, Known Limitations of MySQL Cluster
database objects, Known Limitations of MySQL Cluster
geometry datatypes, Known Limitations of MySQL Cluster
implementation, Known Limitations of MySQL Cluster
imposed by configuration, Known Limitations of MySQL Cluster
multiple management servers, Known Limitations of MySQL Cluster
multiple MySQL servers, Known Limitations of MySQL Cluster
performance, Known Limitations of MySQL Cluster
syntax, Known Limitations of MySQL Cluster
transactions, Known Limitations of MySQL Cluster
unsupported features, Known Limitations of MySQL Cluster
MySQL Cluster processes (types), Process Management in MySQL Cluster
MySQL Cluster utilities, Cluster Utility Programs
mysql command options, mysql Options
mysql commands
list of, mysql Commands
MySQL Dolphin name, History of MySQL
MySQL history, History of MySQL
mysql history file, mysql Options
MySQL mailing lists, MySQL Mailing Lists
MySQL name, History of MySQL
mysql prompt command, mysql Commands
MySQL source distribution, Choosing Which MySQL Distribution to Install
mysql status command, mysql Commands
MySQL storage engines, Storage Engines and Table Types
MySQL version, How to Get MySQL
MySQL++, MySQL C++ API
mysql.server, Overview of Server-Side Programs
mysql.sock
changing location of, Typical configure Options
protection, How to Protect or Change the MySQL Unix Socket File
MYSQL323 SQL mode, SQL Modes
MYSQL40 SQL mode, SQL Modes
mysqlaccess, Overview of Client and Utility Programs
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 Client and Utility Programs, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax
character-sets-dir option, mysqladmin — Client for Administering a MySQL Server
compress option, mysqladmin — Client for Administering a MySQL Server
count option, mysqladmin — Client for Administering a MySQL Server
debug option, mysqladmin — Client for Administering a MySQL Server
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
password 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 Client and Utility Programs
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
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
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
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
version option, mysqlbinlog — Utility for Processing Binary Log Files
mysqlbug script, How to Report Bugs or Problems
mysqlcheck, Overview of Client and Utility Programs
all-databases option, mysqlcheck — A Table Maintenance and Repair Program
all-in-1 option, mysqlcheck — A Table Maintenance and Repair Program
analyze option, mysqlcheck — A Table Maintenance and Repair Program
auto-repair option, mysqlcheck — A Table Maintenance and Repair Program
character-sets-dir option, mysqlcheck — A Table Maintenance and Repair Program
check option, mysqlcheck — A Table Maintenance and Repair Program
check-only-changed option, mysqlcheck — A Table Maintenance and Repair Program
compress option, mysqlcheck — A Table Maintenance and Repair Program
databases option, mysqlcheck — A Table Maintenance and Repair Program
debug option, mysqlcheck — A Table Maintenance and Repair Program
default-character-set option, mysqlcheck — A Table Maintenance and Repair Program
extended option, mysqlcheck — A Table Maintenance and Repair Program
fast option, mysqlcheck — A Table Maintenance and Repair Program
force option, mysqlcheck — A Table Maintenance and Repair Program
help option, mysqlcheck — A Table Maintenance and Repair Program
host option, mysqlcheck — A Table Maintenance and Repair Program
medium-check option, mysqlcheck — A Table Maintenance and Repair Program
optimize option, mysqlcheck — A Table Maintenance and Repair Program
password option, mysqlcheck — A Table Maintenance and Repair Program
port option, mysqlcheck — A Table Maintenance and Repair Program
protocol option, mysqlcheck — A Table Maintenance and Repair Program
quick option, mysqlcheck — A Table Maintenance and Repair Program
repair option, mysqlcheck — A Table Maintenance and Repair Program
silent option, mysqlcheck — A Table Maintenance and Repair Program
socket option, mysqlcheck — A Table Maintenance and Repair Program
SSL options, mysqlcheck — A Table Maintenance and Repair Program
tables option, mysqlcheck — A Table Maintenance and Repair Program
use-frm option, mysqlcheck — A Table Maintenance and Repair Program
user option, mysqlcheck — A Table Maintenance and Repair Program
verbose option, mysqlcheck — A Table Maintenance and Repair Program
version option, mysqlcheck — A Table Maintenance and Repair Program
mysqlclient library, APIs and Libraries
mysqld, Overview of Server-Side Programs
allow-suspicious-udfs option, Command Options, Security-Related mysqld Options
ansi option, Command Options
as MySQL Cluster process, MySQL Server Process Usage for MySQL Cluster, MySQL Cluster-Related Command Options for mysqld
basedir option, Command Options
bdb-home option, BDB Startup Options
bdb-lock-detect option, BDB Startup Options
bdb-logdir option, BDB Startup Options
bdb-no-recover option, BDB Startup Options
bdb-no-sync option, BDB Startup Options
bdb-shared-data option, BDB Startup Options
bdb-tmpdir option, BDB Startup Options
big-tables option, Command Options
bind-address option, Command Options
binlog-do-db option, The Binary Log
binlog-ignore-db option, The Binary Log
bootstrap option, Command Options
character-set-client-handshake option, Command Options
character-set-server option, Command Options
character-sets-dir option, Command Options
chroot option, Command Options
collation-server option, Command Options
command options, Command Options
console option, Command Options
core-file option, Command Options
datadir option, Command Options
debug option, Command Options
default-character-set option, Command Options
default-collation option, Command Options
default-storage-engine option, Command Options
default-table-type option, Command Options
default-time-zone option, Command Options
delay-key-write option, Command Options, MyISAM Startup Options
delay-key-write-for-all-tables option, Command Options
des-key-file option, Command Options
enable-named-pipe option, Command Options
exit-info option, Command Options
external-locking option, Command Options
flush option, Command Options
help option, Command Options
init-file option, Command Options
innodb option, InnoDB Startup Options and System Variables
innodb-safe-binlog option, Command Options
innodb_status_file option, InnoDB Startup Options and System Variables
language option, Command Options
local-infile option, Security-Related mysqld Options
log option, Command Options
log-bin option, Command Options
log-bin-index option, Command Options
log-error option, Command Options
log-isam option, Command Options
log-long-format option, Command Options
log-queries-not-using-indexes option, Command Options
log-short-format option, Command Options
log-slave-updates option, Replication Startup Options
log-slow-admin-statements option, Command Options
log-slow-queries option, Command Options
log-update option, Command Options
log-warnings option, Command Options, Replication Startup Options
low-priority-updates option, Command Options
master-connect-retry option, Replication Startup Options
master-host option, Replication Startup Options
master-info-file option, Replication Startup Options
master-password option, Replication Startup Options
master-port option, Replication Startup Options
master-retry-count option, Replication Startup Options
master-ssl option, Replication Startup Options
master-ssl-ca option, Replication Startup Options
master-ssl-capath option, Replication Startup Options
master-ssl-cert option, Replication Startup Options
master-ssl-cipher option, Replication Startup Options
master-ssl-key option, Replication Startup Options
master-user option, Replication Startup Options
max-relay-log-size option, Replication Startup Options
memlock option, Command Options
myisam-recover option, Command Options, MyISAM Startup Options
ndb-connectstring option, Command Options
ndbcluster option, Command Options
new option, Command Options
old-passwords option, Command Options, Security-Related mysqld Options
old-protocol option, Command Options
one-thread option, Command Options
open-files-limit option, Command Options
pid-file option, Command Options
port option, Command Options
read-only option, Replication Startup Options
relay-log option, Replication Startup Options
relay-log-index option, Replication Startup Options
relay-log-info-file option, Replication Startup Options
relay-log-purge option, Replication Startup Options
relay-log-space-limit option, Replication Startup Options
replicate-do-db option, Replication Startup Options
replicate-do-table option, Replication Startup Options
replicate-ignore-db option, Replication Startup Options
replicate-ignore-table option, Replication Startup Options
replicate-rewrite-db option, Replication Startup Options
replicate-same-server-id option, Replication Startup Options
replicate-wild-do-table option, Replication Startup Options
replicate-wild-ignore-table option, Replication Startup Options
report-host option, Replication Startup Options
report-port option, Replication Startup Options
role in MySQL Cluster, Basic MySQL Cluster Concepts
safe-mode option, Command Options
safe-show-database option, Command Options, Security-Related mysqld Options
safe-user-create option, Command Options, Security-Related mysqld Options
secure-auth option, Command Options, Security-Related mysqld Options
shared-memory option, Command Options
shared-memory-base-name option, Command Options
skip-bdb option, Command Options, BDB Startup Options
skip-concurrent-insert option, Command Options
skip-delay-key-write option, Command Options
skip-external-locking option, Command Options
skip-grant-tables option, Command Options, Security-Related mysqld Options
skip-host-cache option, Command Options
skip-innodb option, Command Options
skip-isam option, Command Options
skip-merge option, Command Options
skip-name-resolve option, Command Options, Security-Related mysqld Options
skip-ndbcluster option, Command Options
skip-networking option, Command Options, Security-Related mysqld Options
skip-new option, Command Options
skip-safemalloc option, Command Options
skip-show-database option, Command Options, Security-Related mysqld Options
skip-slave-start option, Replication Startup Options
skip-stack-trace option, Command Options
skip-symbolic-links option, Command Options
skip-symlink option, Command Options
skip-thread-priority option, Command Options
slave-load-tmpdir option, Replication Startup Options
slave-net-timeout option, Replication Startup Options
slave-skip-errors option, Replication Startup Options
slave_compressed_protocol option, Replication Startup Options
socket option, Command Options
sql-mode option, Command Options
SSL options, Command Options, Connecting to the MySQL Server
standalone option, Command Options
starting, How to Run MySQL as a Normal User
symbolic-links option, Command Options
sync-bdb-logs option, BDB Startup Options
temp-pool option, Command Options
tmpdir option, Command Options
transaction-isolation option, Command Options
user option, Command Options
version option, Command Options
mysqld library, APIs and Libraries
mysqld option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysqld options, Tuning Server Parameters
mysqld server
buffer sizes, Tuning Server Parameters
mysqld-max, Overview of Server-Side Programs, The mysqld-max Extended MySQL Server
mysqld-version option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysqldump, Copying MySQL Databases to Another Machine, Overview of Client and Utility Programs
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
allow-keywords option, mysqldump — A Database Backup Program
character-sets-dir option, mysqldump — A Database Backup Program
comments option, mysqldump — A Database Backup Program
compact option, mysqldump — A Database Backup Program
compatible option, mysqldump — A Database Backup Program
complete-insert option, mysqldump — A Database Backup Program
compress option, mysqldump — A Database Backup Program
create-options option, mysqldump — A Database Backup Program
databases option, mysqldump — A Database Backup Program
debug option, mysqldump — A Database Backup Program
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
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
flush-logs option, mysqldump — A Database Backup Program
force option, mysqldump — A Database Backup Program
help option, mysqldump — A Database Backup Program
hex-blob option, mysqldump — A Database Backup Program
host option, mysqldump — A Database Backup Program
ignore-table option, mysqldump — A Database Backup Program
insert-ignore option, mysqldump — A Database Backup Program
lines-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
lock-all-tables option, mysqldump — A Database Backup Program
lock-tables option, mysqldump — A Database Backup Program
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
opt option, mysqldump — A Database Backup Program
order-by-primary option, mysqldump — A Database Backup Program
password option, mysqldump — A Database Backup Program
port option, mysqldump — A Database Backup Program
protocol option, mysqldump — A Database Backup Program
quick option, mysqldump — A Database Backup Program
quote-names option, mysqldump — A Database Backup Program
result-file 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
user option, mysqldump — A Database Backup Program
verbose option, mysqldump — A Database Backup Program
version option, mysqldump — A Database Backup Program
where option, mysqldump — A Database Backup Program
xml option, mysqldump — A Database Backup Program
mysqld_multi, Overview of Server-Side Programs
config-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-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 Server-Side Programs
autoclose option, mysqld_safe — MySQL Server Startup Script
basedir option, mysqld_safe — MySQL Server Startup Script
core-file-size option, mysqld_safe — MySQL Server Startup Script
datadir option, mysqld_safe — MySQL Server Startup Script
defaults-extra-file option, mysqld_safe — MySQL Server Startup Script
defaults-file option, mysqld_safe — MySQL Server Startup Script
ledir option, mysqld_safe — MySQL Server Startup Script
log-error option, mysqld_safe — MySQL Server Startup Script
mysqld option, mysqld_safe — MySQL Server Startup Script
mysqld-version option, mysqld_safe — MySQL Server Startup Script
nice option, mysqld_safe — MySQL Server Startup Script
no-defaults option, mysqld_safe — MySQL Server Startup Script
open-files-limit option, mysqld_safe — MySQL Server Startup Script
pid-file option, mysqld_safe — MySQL Server Startup Script
port option, mysqld_safe — MySQL Server Startup Script
socket 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 Client and Utility Programs
addtodest option, mysqlhotcopy — A Database Backup Program
allowold option, mysqlhotcopy — A Database Backup Program
checkpoint option, mysqlhotcopy — A Database Backup Program
chroot option, mysqlhotcopy — A Database Backup Program
debug option, mysqlhotcopy — A Database Backup Program
dryrun option, mysqlhotcopy — A Database Backup Program
flushlog option, mysqlhotcopy — A Database Backup Program
help option, mysqlhotcopy — A Database Backup Program
host option, mysqlhotcopy — A Database Backup Program
keepold option, mysqlhotcopy — A Database Backup Program
method option, mysqlhotcopy — A Database Backup Program
noindices option, mysqlhotcopy — A Database Backup Program
password option, mysqlhotcopy — A Database Backup Program
port option, mysqlhotcopy — A Database Backup Program
quiet option, mysqlhotcopy — A Database Backup Program
record_log_pos option, mysqlhotcopy — A Database Backup Program
regexp option, mysqlhotcopy — A Database Backup Program
resetmaster option, mysqlhotcopy — A Database Backup Program
resetslave option, mysqlhotcopy — A Database Backup Program
socket option, mysqlhotcopy — A Database Backup Program
suffix option, mysqlhotcopy — A Database Backup Program
tmpdir option, mysqlhotcopy — A Database Backup Program
user option, mysqlhotcopy — A Database Backup Program
mysqlimport, Copying MySQL Databases to Another Machine, Overview of Client and Utility Programs, LOAD DATA INFILE Syntax
character-sets-dir option, mysqlimport — A Data Import Program
columns option, mysqlimport — A Data Import Program
compress option, mysqlimport — A Data Import Program
debug option, mysqlimport — A Data Import Program
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
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
user option, mysqlimport — A Data Import Program
verbose option, mysqlimport — A Data Import Program
version option, mysqlimport — A Data Import Program
mysqlshow, Overview of Client and Utility Programs
character-sets-dir option, mysqlshow — Display Database, Table, and Column Information
compress option, mysqlshow — Display Database, Table, and Column Information
debug 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
port option, mysqlshow — Display Database, Table, and Column Information
protocol 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
mysqltest
MySQL Test Suite, MySQL Test Suite
mysql_affected_rows(), mysql_affected_rows()
mysql_autocommit(), mysql_autocommit()
MYSQL_BIND C type, C API Prepared Statement Data types
mysql_change_user(), mysql_change_user()
mysql_character_set_name(), mysql_character_set_name()
mysql_close(), mysql_close()
mysql_commit(), mysql_commit()
mysql_connect(), mysql_connect()
mysql_create_db(), mysql_create_db()
mysql_data_seek(), mysql_data_seek()
MYSQL_DEBUG environment variable, Overview of Client and Utility Programs, Debugging a MySQL Client, Environment Variables
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_explain_log, Overview of Client and Utility Programs
date option, mysql_explain_log — Use EXPLAIN on Statements in Query Log
host option, mysql_explain_log — Use EXPLAIN on Statements in Query Log
password option, mysql_explain_log — Use EXPLAIN on Statements in Query Log
printerror option, mysql_explain_log — Use EXPLAIN on Statements in Query Log
socket option, mysql_explain_log — Use EXPLAIN on Statements in Query Log
user option, mysql_explain_log — Use EXPLAIN on Statements in Query Log
mysql_fetch_field(), mysql_fetch_field()
mysql_fetch_fields(), mysql_fetch_fields()
mysql_fetch_field_direct(), mysql_fetch_field_direct()
mysql_fetch_lengths(), mysql_fetch_lengths()
mysql_fetch_row(), mysql_fetch_row()
MYSQL_FIELD C type, C API Data types
mysql_field_count(), mysql_field_count(), mysql_num_fields()
MYSQL_FIELD_OFFSET C type, C API Data types
mysql_field_seek(), mysql_field_seek()
mysql_field_tell(), mysql_field_tell()
mysql_fix_privilege_tables, Overview of Server-Side Programs, Causes of Access denied Errors
mysql_free_result(), mysql_free_result()
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_GROUP_SUFFIX environment variable, Environment Variables
mysql_hex_string(), mysql_hex_string()
MYSQL_HISTFILE environment variable, mysql Options, Environment Variables
MYSQL_HOME environment variable, Environment Variables
MYSQL_HOST environment variable, Connecting to the MySQL Server, Environment Variables
mysql_info(), ALTER TABLE Syntax, INSERT Syntax, LOAD DATA INFILE Syntax, UPDATE Syntax, mysql_info()
mysql_init(), mysql_init()
mysql_insert_id(), Transactions and Atomic Operations, INSERT Syntax, mysql_insert_id()
mysql_install_db, Overview of Server-Side Programs
mysql_install_db script, Problems Running mysql_install_db
mysql_kill(), mysql_kill()
mysql_library_end(), mysql_library_end()
mysql_library_init(), mysql_library_init()
mysql_list_dbs(), mysql_list_dbs()
mysql_list_fields(), mysql_list_fields()
mysql_list_processes(), mysql_list_processes()
mysql_list_tables(), mysql_list_tables()
mysql_more_results(), mysql_more_results()
mysql_next_result(), mysql_next_result()
mysql_num_fields(), mysql_num_fields()
mysql_num_rows(), mysql_num_rows()
mysql_options(), mysql_options()
mysql_ping(), mysql_ping()
MYSQL_PS1 environment variable, Environment Variables
MYSQL_PWD environment variable, Connecting to the MySQL Server, Overview of Client and Utility Programs, Environment Variables
mysql_query(), mysql_query(), Common Questions and Problems When Using the C API
mysql_real_connect(), mysql_real_connect()
mysql_real_escape_string(), Strings, mysql_real_escape_string()
mysql_real_query(), mysql_real_query()
mysql_refresh(), mysql_refresh()
mysql_reload(), mysql_reload()
MYSQL_RES C type, C API Data types
mysql_rollback(), mysql_rollback()
MYSQL_ROW C type, C API Data types
mysql_row_seek(), mysql_row_seek()
mysql_row_tell(), mysql_row_tell()
mysql_select_db(), mysql_select_db()
mysql_server_end(), mysql_server_end()
mysql_server_init(), mysql_server_init()
mysql_set_character_set(), mysql_set_character_set()
mysql_set_local_infile_default(), mysql_set_local_infile_default()
mysql_set_server_option(), mysql_set_server_option()
mysql_shutdown(), mysql_shutdown()
mysql_sqlstate(), mysql_sqlstate()
mysql_ssl_set(), mysql_ssl_set()
mysql_stat(), mysql_stat()
MYSQL_STMT C type, C API Prepared Statement Data types
mysql_stmt_affected_rows(), mysql_stmt_affected_rows()
mysql_stmt_attr_get(), mysql_stmt_attr_get()
mysql_stmt_attr_set(), mysql_stmt_attr_set()
mysql_stmt_bind_param(), mysql_stmt_bind_param()
mysql_stmt_bind_result(), mysql_stmt_bind_result()
mysql_stmt_close(), mysql_stmt_close()
mysql_stmt_data_seek(), mysql_stmt_data_seek()
mysql_stmt_errno(), mysql_stmt_errno()
mysql_stmt_error(), mysql_stmt_error()
mysql_stmt_execute(), mysql_stmt_execute()
mysql_stmt_fetch(), mysql_stmt_fetch()
mysql_stmt_fetch_column(), mysql_stmt_fetch_column()
mysql_stmt_field_count(), mysql_stmt_field_count()
mysql_stmt_free_result(), mysql_stmt_free_result()
mysql_stmt_init(), mysql_stmt_init()
mysql_stmt_insert_id(), mysql_stmt_insert_id()
mysql_stmt_num_rows(), mysql_stmt_num_rows()
mysql_stmt_param_count(), mysql_stmt_param_count()
mysql_stmt_param_metadata(), mysql_stmt_param_metadata()
mysql_stmt_prepare(), mysql_stmt_prepare()
mysql_stmt_reset(), mysql_stmt_reset()
mysql_stmt_result_metadata, mysql_stmt_result_metadata()
mysql_stmt_row_seek(), mysql_stmt_row_seek()
mysql_stmt_row_tell(), mysql_stmt_row_tell()
mysql_stmt_send_long_data(), mysql_stmt_send_long_data()
mysql_stmt_sqlstate(), mysql_stmt_sqlstate()
mysql_stmt_store_result(), mysql_stmt_store_result()
mysql_store_result(), mysql_store_result(), Common Questions and Problems When Using the C API
MYSQL_TCP_PORT environment variable, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs, Environment Variables
mysql_thread_end(), mysql_thread_end()
mysql_thread_id(), mysql_thread_id()
mysql_thread_init(), mysql_thread_init()
mysql_thread_safe(), mysql_thread_safe()
MYSQL_TIME C type, C API Prepared Statement Data types
mysql_tzinfo_to_sql, Overview of Server-Side Programs
MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs, Environment Variables
mysql_use_result(), mysql_use_result()
mysql_warning_count(), mysql_warning_count()
mysql_zap, Overview of Client and Utility Programs
my_bool C type, C API Data types
my_bool values
printing, C API Data types
my_init(), my_init()
my_print_defaults, Overview of Client and Utility Programs
config-file option, my_print_defaults — Display Options from Option Files
debug option, my_print_defaults — Display Options from Option Files
defaults-extra-file option, my_print_defaults — Display Options from Option Files
defaults-file option, my_print_defaults — Display Options from Option Files
defaults-group-suffix option, my_print_defaults — Display Options from Option Files
extra-file option, my_print_defaults — Display Options from Option Files
help option, my_print_defaults — Display Options from Option Files
no-defaults option, my_print_defaults — Display Options from Option Files
verbose option, my_print_defaults — Display Options from Option Files
version option, my_print_defaults — Display Options from Option Files
my_ulonglong C type, C API Data types
my_ulonglong values
printing, C API Data types

N

named pipes, Selecting a MySQL Server type, Testing The MySQL Installation
named-commands option
mysql, mysql Options
names, Database, Table, Index, Column, and Alias Names
case sensitivity, Identifier Case Sensitivity
variables, User-Defined Variables
naming
releases of MySQL, Choosing Which Version of MySQL to Install
NATIONAL CHAR data type, Overview of String Types
native functions
adding, Adding a New Native Function
native thread support, Operating Systems On Which MySQL Is Known To Run
NATURAL LEFT JOIN, JOIN Syntax
NATURAL LEFT OUTER JOIN, JOIN Syntax
NATURAL RIGHT JOIN, JOIN Syntax
NATURAL RIGHT OUTER JOIN, JOIN Syntax
NCHAR data type, Overview of String Types
NDB, MySQL Cluster FAQ
ndb option
perror, perror — Explain Error Codes
NDB storage engine, MySQL Cluster
ndb-connectstring option
mysqld, Command Options
ndbcluster option
mysqld, Command Options
ndbd (MySQL Cluster process), ndbd, the Storage Engine Node Process
ndbd (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
ndb_config, Cluster Utility Programs
ndb_delete_all, Cluster Utility Programs, ndb_delete_all
ndb_desc, Cluster Utility Programs, ndb_desc
ndb_drop_index, Cluster Utility Programs, ndb_drop_index
ndb_drop_table, Cluster Utility Programs, ndb_drop_table
ndb_error_reporter, Cluster Utility Programs, ndb_error_reporter
ndb_mgm, ndb_mgm, the Management Client Process
ndb_mgm (MySQL Cluster management node client), Initial Startup
ndb_mgmd, ndb_mgmd, the Management Server Process
ndb_mgmd (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
ndb_print_backup_file, Cluster Utility Programs, ndb_print_backup_file
ndb_print_schema_file, Cluster Utility Programs, ndb_print_schema_file
ndb_print_sys_file, Cluster Utility Programs, ndb_print_sys_file
ndb_restore, How to Restore a Cluster Backup
errors, How to Restore a Cluster Backup
ndb_select_all, Cluster Utility Programs, ndb_select_all
ndb_select_count, Cluster Utility Programs, ndb_select_count
ndb_show_tables, Cluster Utility Programs, ndb_show_tables
ndb_size.pl, Cluster Utility Programs
ndb_size.pl (utility), MySQL Cluster FAQ
ndb_waiter, Cluster Utility Programs, ndb_waiter
negative values, Numbers
nested queries, Subquery Syntax
net etiquette, Guidelines for Using the Mailing Lists
netmask notation
in mysql.user table, Access Control, Stage 1: Connection Verification
NetWare, Installing MySQL on NetWare
net_buffer_length variable, mysql Options
new option
mysqld, Command Options
new procedures
adding, Adding New Procedures to MySQL
new users
adding, Installing MySQL on Other Unix-Like Systems, Source Installation Overview
newline (\n), Strings
nice option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
no matching rows, Solving Problems with No Matching Rows
no-auto-rehash option
mysql, mysql Options
no-autocommit option
mysqldump, mysqldump — A Database Backup Program
no-beep option
mysql, mysql Options
no-create-db option
mysqldump, mysqldump — A Database Backup Program
no-create-info option
mysqldump, mysqldump — A Database Backup Program
no-data option
mysqldump, mysqldump — A Database Backup Program
no-defaults option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
my_print_defaults, my_print_defaults — Display Options from Option Files
no-log option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
no-named-commands option
mysql, mysql Options
no-pager option
mysql, mysql Options
no-symlinks option
myisamchk, myisamchk Repair Options
no-tee option
mysql, mysql Options
node groups (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
node identifiers (MySQL Cluster), Shared-Memory Connections, SCI Transport Connections
node logs (MySQL Cluster), Event Reports Generated in MySQL Cluster
NODERESTART Events (MySQL Cluster), Log Events
noindices option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
non-delimited strings, The DATETIME, DATE, and TIMESTAMP Types
Non-transactional tables, Rollback Failure for Non-Transactional Tables
NoOfDiskPagesToDiskAfterRestartACC
calculating, Configuring Parameters for Local Checkpoints
NoOfDiskPagesToDiskAfterRestartACC (MySQL Cluster configuration parameter), Defining Data Nodes
NoOfDiskPagesToDiskAfterRestartTUP
calculating, Configuring Parameters for Local Checkpoints
NoOfDiskPagesToDiskAfterRestartTUP (MySQL Cluster configuration parameter), Defining Data Nodes
NoOfDiskPagesToDiskDuringRestartACC (MySQL Cluster configuration parameter), Defining Data Nodes
NoOfDiskPagesToDiskDuringRestartTUP (MySQL Cluster configuration parameter), Defining Data Nodes
NoOfFragmentLogFiles, Defining Data Nodes
calculating, Configuring Parameters for Local Checkpoints
NoOfReplicas, Defining Data Nodes
NOT
logical, Logical Operators
NOT BETWEEN, Comparison Functions and Operators
not equal (!=), Comparison Functions and Operators
not equal (<>), Comparison Functions and Operators
NOT IN, Comparison Functions and Operators
NOT LIKE, String Comparison Functions
NOT NULL
constraint, Constraints on Invalid Data
NOT REGEXP, String Comparison Functions
Novell NetWare, Installing MySQL on NetWare
NOW(), Date and Time Functions
NO_AUTO_VALUE_ON_ZERO SQL mode, SQL Modes
NO_DIR_IN_CREATE SQL mode, SQL Modes
NO_FIELD_OPTIONS SQL mode, SQL Modes
NO_KEY_OPTIONS SQL mode, SQL Modes
NO_TABLE_OPTIONS SQL mode, SQL Modes
NO_UNSIGNED_SUBTRACTION SQL mode, SQL Modes
NUL, Strings
NULL, Working with NULL Values, Problems with NULL Values
ORDER BY, ORDER BY Optimization, SELECT Syntax
testing for null, Comparison Functions and Operators, Control Flow Functions
NULL value, Working with NULL Values, NULL Values
NULL values
and AUTO_INCREMENT columns, Problems with NULL Values
and indexes, CREATE TABLE Syntax
and TIMESTAMP columns, Problems with NULL Values
vs. empty values, Problems with NULL Values
NULLIF(), Control Flow Functions
numbers, Numbers
NUMERIC data type, Overview of Numeric Types
numeric types, Data Type Storage Requirements
NumGeometries(), GeometryCollection Functions
NumInteriorRings(), Polygon Functions
NumPoints(), LineString Functions

O

Obtaining MySQL Cluster, Multi-Computer Installation
OCT(), String Functions
OCTET_LENGTH(), String Functions
ODBC, MySQL Connector/ODBC
ODBC compatibility, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
offset option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
OLAP, GROUP BY Modifiers
old-passwords option
mysqld, Command Options, Security-Related mysqld Options
old-protocol option
mysqld, Command Options
OLD_PASSWORD(), Encryption and Compression Functions
old_server option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
ON DUPLICATE KEY, INSERT Syntax, Changes in release 4.1.x (Production)
one-database option
mysql, mysql Options
one-thread option
mysqld, Command Options
online location of manual, About This Manual
ONLY_FULL_GROUP_BY
SQL mode, GROUP BY and HAVING with Hidden Fields
ONLY_FULL_GROUP_BY SQL mode, SQL Modes
Open Source
defined, What is MySQL?
open tables, How MySQL Opens and Closes Tables, mysqladmin — Client for Administering a MySQL Server
open-files-limit option
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
OpenGIS, Introduction to MySQL Spatial Support
opening
tables, How MySQL Opens and Closes Tables
opens, mysqladmin — Client for Administering a MySQL Server
OpenSSL, Using Secure Connections
open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files
operating systems
file-size limits, The table is full
supported, Operating Systems On Which MySQL Is Known To Run
Windows versus Unix, MySQL on Windows Compared to MySQL on Unix
operations
arithmetic, Arithmetic Operators
operators, Functions and Operators
cast, Arithmetic Operators, Cast Functions and Operators
logical, Logical Operators
precedence, Operator Precedence
opt option
mysqldump, mysqldump — A Database Backup Program
optimization
tips, Other Optimization Tips
optimizations, WHERE Clause Optimization
optimize option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
OPTIMIZE TABLE, OPTIMIZE TABLE Syntax
optimizing
DISTINCT, DISTINCT Optimization
filesort, ORDER BY Optimization
GROUP BY, GROUP BY Optimization
LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization
LIMIT, LIMIT Optimization
tables, Table Optimization
option files, Using Option Files, Causes of Access denied Errors
options
command-line
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
configure, Typical configure Options
embedded server, Options with the Embedded Server
libmysqld, Options with the Embedded Server
myisamchk, myisamchk General Options
provided by MySQL, Tutorial
replication, Replication Features and Known Problems
OR, Searching on Two Keys
bitwise, Bit Functions
logical, Logical Operators
Oracle compatibility, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax
ORACLE SQL mode, SQL Modes
ORD(), String Functions
ORDER BY, Sorting Rows, ALTER TABLE Syntax, SELECT Syntax
NULL, ORDER BY Optimization, SELECT Syntax
order-by-primary option
mysqldump, mysqldump — A Database Backup Program
OUTFILE, SELECT Syntax
Overlaps(), Functions That Test Spatial Relationships Between Geometries
overview, General Information

P

packages
list of, Packages that support MySQL
packlength option
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
pack_isam, Overview of Client and Utility Programs
page-level locking, Locking Methods
pager option
mysql, mysql Options
parallel-recover option
myisamchk, myisamchk Repair Options
parameters
server, Tuning Server Parameters
parentheses ( and ), Operator Precedence
partitions (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
password
root user, Securing the Initial MySQL Accounts
password encryption
reversibility of, Encryption and Compression Functions
password option
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 and Repair Program
mysqldump, mysqldump — A Database Backup Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log
PASSWORD(), Access Control, Stage 1: Connection Verification, Assigning Account Passwords, Encryption and Compression Functions, Ignoring user
passwords
for users, MySQL Usernames and Passwords
forgotten, How to Reset the Root Password
lost, How to Reset the Root Password
resetting, How to Reset the Root Password
security, What the Privilege System Does
setting, Assigning Account Passwords, GRANT Syntax, SET PASSWORD Syntax
PATH environment variable, Installing MySQL on Other Unix-Like Systems, Invoking MySQL Programs, Environment Variables
pattern matching, Pattern Matching, Regular Expressions
performance
benchmarks, Using Your Own Benchmarks
disk issues, Disk Issues
estimating, Estimating Query Performance
improving, Replication FAQ, Make Your Data as Small as Possible
PERIOD_ADD(), Date and Time Functions
PERIOD_DIFF(), Date and Time Functions
Perl
installing, Perl Installation Notes
installing on Windows, Installing ActiveState Perl on Windows
Perl API, MySQL Perl API
Perl DBI/DBD
installation problems, Problems Using the Perl DBI/DBD Interface
permission checks
effect on speed, Optimizing SELECT and Other Statements
perror, Overview of Client and Utility Programs
help option, perror — Explain Error Codes
ndb option, perror — Explain Error Codes
silent option, perror — Explain Error Codes
verbose option, perror — Explain Error Codes
version option, perror — Explain Error Codes
PHP API, MySQL PHP API
PI(), Mathematical Functions
pid-file option
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
PIPES_AS_CONCAT SQL mode, SQL Modes
plan option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
POINT data type, MySQL Spatial Data Types
point in time recovery, Point-in-Time Recovery
Point(), Creating Geometry Values Using MySQL-Specific Functions
PointFromText(), Creating Geometry Values Using WKT Functions
PointFromWKB(), Creating Geometry Values Using WKB Functions
PointN(), LineString Functions
PointOnSurface(), MultiPolygon Functions
PolyFromText(), Creating Geometry Values Using WKT Functions
PolyFromWKB(), Creating Geometry Values Using WKB Functions
POLYGON data type, MySQL Spatial Data Types
Polygon(), Creating Geometry Values Using MySQL-Specific Functions
PolygonFromText(), Creating Geometry Values Using WKT Functions
PolygonFromWKB(), Creating Geometry Values Using WKB Functions
port 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 and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
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
portability, Designing Applications for Portability
types, Using Data Types from Other Database Engines
porting
to other systems, Porting to Other Systems
PortNumber, Defining the Management Server, Cluster TCP/IP Connections
position option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
POSITION(), String Functions
post-install
multiple servers, Running Multiple MySQL Servers on the Same Machine
post-installation
setup and testing, Post-Installation Setup and Testing
PostgreSQL compatibility, MySQL Extensions to Standard SQL
POSTGRESQL SQL mode, SQL Modes
POW(), Mathematical Functions
POWER(), Mathematical Functions
precedence
operator, Operator Precedence
PREPARE, SQL Syntax for Prepared Statements
preview option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
previx option
configure, Typical configure Options
PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax
constraint, PRIMARY KEY and UNIQUE Index Constraints
primary key
deleting, ALTER TABLE Syntax
printerror option
mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log
privilege
changes, Access Control, Stage 2: Request Verification
privilege information
location, Privileges Provided by MySQL
privilege system, What the Privilege System Does
described, How the Privilege System Works
privileges
access, The MySQL Access Privilege System
adding, Adding New User Accounts to MySQL
default, Securing the Initial MySQL Accounts
deleting, Removing User Accounts from MySQL, DROP USER Syntax
display, SHOW GRANTS Syntax
dropping, Removing User Accounts from MySQL, DROP USER Syntax
granting, GRANT Syntax
revoking, REVOKE Syntax
problems
access denied errors, Access denied
common errors, Problems and Common Errors
compiling, Dealing with Problems Compiling MySQL
DATE columns, Problems Using DATE Columns
date values, The DATETIME, DATE, and TIMESTAMP Types
installing on IBM-AIX, IBM-AIX notes
installing on Solaris, Solaris Notes
installing Perl, Problems Using the Perl DBI/DBD Interface
linking, Problems Linking to the MySQL Client Library
ODBC, Connector/ODBC Support
reporting, How to Report Bugs or Problems
starting the server, Starting and Troubleshooting the MySQL Server
table locking, Table Locking Issues
time zone, Time Zone Problems
PROCEDURE, SELECT Syntax
procedures
adding, Adding New Procedures to MySQL
stored, Stored Routines and Triggers
process management (MySQL Cluster), Process Management in MySQL Cluster
process support, Operating Systems On Which MySQL Is Known To Run
processes
display, SHOW PROCESSLIST Syntax
processing
arguments, UDF Argument Processing
PROCESSLIST, SHOW PROCESSLIST Syntax
program variables
setting, Using Options to Set Program Variables
programs
client, Overview of Client and Utility Programs, Building Client Programs
crash-me, Designing Applications for Portability
server side, Overview of Server-Side Programs
utility, Overview of Client and Utility Programs
prompt option
mysql, mysql Options
prompts
meanings, Entering Queries
pronunciation
MySQL, What is MySQL?
protocol 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 and Repair Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
PURGE MASTER LOGS, PURGE MASTER LOGS Syntax
PURGE STALE SESSIONS, MySQL Cluster Startup Phases
Python API, MySQL Python API

R

RADIANS(), Mathematical Functions
RAID
compile errors, Dealing with Problems Compiling MySQL
table type, CREATE TABLE Syntax
RAND(), Mathematical Functions
raw option
mysql, mysql Options
re-creating
grant tables, Problems Running mysql_install_db
read-from-remote-server option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
read-only option
myisamchk, myisamchk Check Options
mysqld, Replication Startup Options
read_buffer_size myisamchk variable, myisamchk General Options
REAL data type, Overview of Numeric Types
REAL_AS_FLOAT SQL mode, SQL Modes
ReceiveBufferMemory, Cluster TCP/IP Connections
reconfiguring, Dealing with Problems Compiling MySQL
reconnect option
mysql, mysql Options
record_log_pos option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
recover option
myisamchk, myisamchk Repair Options
recovery
from crash, Using myisamchk for Crash Recovery
point in time, Point-in-Time Recovery
RedoBuffer, Defining Data Nodes
reducing
data size, Make Your Data as Small as Possible
references, ALTER TABLE Syntax
ref_or_null, IS NULL Optimization
REGEXP, String Comparison Functions
REGEXP operator, Regular Expressions
regexp option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
regular expression syntax, Regular Expressions
Related(), Functions That Test Spatial Relationships Between Geometries
relational databases
defined, What is MySQL?
relative option
mysqladmin, mysqladmin — Client for Administering a MySQL Server
relay-log option
mysqld, Replication Startup Options
relay-log-index option
mysqld, Replication Startup Options
relay-log-info-file option
mysqld, Replication Startup Options
relay-log-purge option
mysqld, Replication Startup Options
relay-log-space-limit option
mysqld, Replication Startup Options
release numbers, Choosing Which MySQL Distribution to Install
releases
naming scheme, Choosing Which Version of MySQL to Install
testing, Choosing Which Version of MySQL to Install
updating, How and When Updates Are Released
RELEASE_LOCK(), Miscellaneous Functions
relnotes option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
RENAME TABLE, RENAME TABLE Syntax
reordering
columns, How to Change the Order of Columns in a Table
repair option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
repair options
myisamchk, myisamchk Repair Options
REPAIR TABLE, REPAIR TABLE Syntax
repairing
tables, How to Repair Tables
REPEAT(), String Functions
replace, Overview of Client and Utility Programs
REPLACE, REPLACE Syntax
replace option
mysqlimport, mysqlimport — A Data Import Program
REPLACE(), String Functions
replicas (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
replicate-do-db option
mysqld, Replication Startup Options
replicate-do-table option
mysqld, Replication Startup Options
replicate-ignore-db option
mysqld, Replication Startup Options
replicate-ignore-table option
mysqld, Replication Startup Options
replicate-rewrite-db option
mysqld, Replication Startup Options
replicate-same-server-id option
mysqld, Replication Startup Options
replicate-wild-do-table option
mysqld, Replication Startup Options
replicate-wild-ignore-table option
mysqld, Replication Startup Options
replication, Replication
replication limitations, Replication Features and Known Problems
replication masters
statements, SQL Statements for Controlling Master Servers
replication options, Replication Features and Known Problems
replication slaves
statements, SQL Statements for Controlling Slave Servers
report-host option
mysqld, Replication Startup Options
report-port option
mysqld, Replication Startup Options
reporting
bugs, How to Report Bugs or Problems
Connector/NET problems, Connector/NET Support
Connector/ODBC problems, Connector/ODBC Support
errors, General Information, How to Report Bugs or Problems
REQUIRE GRANT option, GRANT Syntax
reserved words, Reserved Words
RESET MASTER, RESET MASTER Syntax
RESET SLAVE, RESET SLAVE Syntax
resetmaster option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
resetslave option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
RESTART command (MySQL Cluster), Commands in the Management Client
restarting
the server, Unix Post-Installation Procedures
RestartOnErrorInsert, Defining Data Nodes
RESTORE TABLE, RESTORE TABLE Syntax
restoring backups
in MySQL Cluster, How to Restore a Cluster Backup
restrictions
subqueries, Restrictions on Subqueries
result-file option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqldump, mysqldump — A Database Backup Program
retrieving
data from tables, Retrieving Information from a Table
return (\r), Strings
return values
UDFs, UDF Return Values and Error Handling
REVERSE(), String Functions
REVOKE, REVOKE Syntax
revoking
privileges, REVOKE Syntax
rhost option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
RIGHT JOIN, JOIN Syntax
RIGHT OUTER JOIN, JOIN Syntax
RIGHT(), String Functions
RLIKE, String Comparison Functions
ROLLBACK, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
rollback option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
ROLLBACK TO SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
rolling restart (MySQL Cluster), Performing a Rolling Restart of the Cluster
rolling upgrades and downgrades (MySQL Cluster), Performing a Rolling Restart of the Cluster
ROLLUP, GROUP BY Modifiers
root password, Securing the Initial MySQL Accounts
root user
password resetting, How to Reset the Root Password
ROUND(), Mathematical Functions
rounding errors, Overview of Numeric Types
row-level locking, Locking Methods
rows
counting, Counting Rows
deleting, Deleting Rows from Related Tables
locking, Transactions and Atomic Operations
matching problems, Solving Problems with No Matching Rows
selecting, Selecting Particular Rows
sorting, Sorting Rows
RPAD(), String Functions
RPM file, Installing MySQL on Linux
RPM Package Manager, Installing MySQL on Linux
RTRIM(), String Functions
RTS-threads, Comments about RTS Threads
running
ANSI mode, Running MySQL in ANSI Mode
batch mode, Using mysql in Batch Mode
multiple servers, Running Multiple MySQL Servers on the Same Machine
queries, Entering Queries
running configure after prior invocation, Dealing with Problems Compiling MySQL

S

safe-mode option
mysqld, Command Options
safe-recover option
myisamchk, myisamchk Repair Options
safe-show-database option
mysqld, Command Options, Security-Related mysqld Options
safe-updates option, Using the --safe-updates Option
mysql, mysql Options
safe-user-create option
mysqld, Command Options, Security-Related mysqld Options
Sakila, History of MySQL
SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
SCI (Scalable Coherent Interface), SCI Transport Connections, Configuring MySQL Cluster to use SCI Sockets
script files, Using mysql in Batch Mode
scripts
mysqlbug, How to Report Bugs or Problems
mysql_install_db, Problems Running mysql_install_db
searching
and case sensitivity, Case Sensitivity in Searches
full-text, Full-Text Search Functions
MySQL Web pages, How to Report Bugs or Problems
two keys, Searching on Two Keys
SECOND(), Date and Time Functions
secure-auth option
mysql, mysql Options
mysqld, Command Options, Security-Related mysqld Options
security
against attackers, Making MySQL Secure Against Attackers
security system, The MySQL Access Privilege System
SEC_TO_TIME(), Date and Time Functions
SELECT
LIMIT, SELECT Syntax
optimizing, Optimizing Queries with EXPLAIN
Query Cache, The MySQL Query Cache
SELECT INTO TABLE, SELECT INTO TABLE
SELECT speed, Speed of SELECT Queries
selecting
databases, Creating and Selecting a Database
select_limit variable, mysql Options
SendBufferMemory, Cluster TCP/IP Connections
SendLimit, SCI Transport Connections
SendSignalId, Cluster TCP/IP Connections, Shared-Memory Connections, SCI Transport Connections
SEQUENCE, Using AUTO_INCREMENT
sequence emulation, Information Functions
sequences, Using AUTO_INCREMENT
server
connecting, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
debugging, Debugging a MySQL Server
disconnecting, Connecting to and Disconnecting from the Server
restart, Unix Post-Installation Procedures
shutdown, Unix Post-Installation Procedures
starting, Unix Post-Installation Procedures
starting and stopping, Starting and Stopping MySQL Automatically
starting problems, Starting and Troubleshooting the MySQL Server
server variables, System Variables, SHOW VARIABLES Syntax
server-side programs, Overview of Server-Side Programs
ServerPort, Defining Data Nodes
servers
multiple, Running Multiple MySQL Servers on the Same Machine
SESSION_USER(), Information Functions
SET, SET Syntax
AUTOCOMMIT, SET Syntax
BIG_TABLES, SET Syntax
CHARACTER SET, Connection Character Sets and Collations, SET Syntax
FOREIGN_KEY_CHECKS, SET Syntax
IDENTITY, SET Syntax
INSERT_ID, SET Syntax
LAST_INSERT_ID, SET Syntax
NAMES, Connection Character Sets and Collations, SET Syntax
ONE_SHOT, SET Syntax
size, Data Type Storage Requirements
SQL_AUTO_IS_NULL, SET Syntax
SQL_BIG_SELECTS, SET Syntax
SQL_BUFFER_SELECT, SET Syntax
SQL_LOG_BIN, SET Syntax
SQL_LOG_OFF, SET Syntax
SQL_LOG_UPDATE, SET Syntax
SQL_NOTES, SET Syntax
SQL_QUOTE_SHOW_CREATE, SET Syntax
SQL_SAFE_UPDATES, SET Syntax
SQL_SELECT_LIMIT, SET Syntax
SQL_WARNINGS, SET Syntax
TIMESTAMP, SET Syntax
UNIQUE_CHECKS, SET Syntax
SET data type, Overview of String Types, The SET Type
SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax
SET OPTION, SET Syntax
SET PASSWORD, SET PASSWORD Syntax
SET PASSWORD statement, Assigning Account Passwords
SET SQL_LOG_BIN, SET SQL_LOG_BIN Syntax
SET TRANSACTION, SET TRANSACTION Syntax
set-auto-increment[ option
myisamchk, Other myisamchk Options
set-character-set option
myisamchk, myisamchk Repair Options
set-charset option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqldump, mysqldump — A Database Backup Program
set-collation option
myisamchk, myisamchk Repair Options
setting
passwords, Assigning Account Passwords
setting passwords, SET PASSWORD Syntax
setting program variables, Using Options to Set Program Variables
setup
post-installation, Post-Installation Setup and Testing
SHA(), Encryption and Compression Functions
SHA1(), Encryption and Compression Functions
shared memory transporter, Shared-Memory Connections
shared-memory option
mysqld, Command Options
shared-memory-base-name option
mysqld, Command Options
SharedBufferSize, SCI Transport Connections
shell syntax, Conventions Used in This Manual
ShmKey, Shared-Memory Connections
ShmSize, Shared-Memory Connections
short-form option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
SHOW
in MySQL Cluster management client, Quick Test Setup of MySQL Cluster
SHOW BINARY LOGS, SHOW BINARY LOGS Syntax
SHOW BINLOG EVENTS, SHOW Syntax, SHOW BINLOG EVENTS Syntax
SHOW CHARACTER SET, SHOW CHARACTER SET Syntax
SHOW COLLATION, SHOW COLLATION Syntax
SHOW COLUMNS, SHOW Syntax, SHOW COLUMNS Syntax
SHOW command (MySQL Cluster), Commands in the Management Client
SHOW CREATE DATABASE, SHOW Syntax, SHOW CREATE DATABASE Syntax
SHOW CREATE TABLE, SHOW Syntax, SHOW CREATE TABLE Syntax
SHOW DATABASES, SHOW Syntax, SHOW DATABASES Syntax
SHOW ENGINE, SHOW Syntax, SHOW ENGINE Syntax
SHOW ENGINE BDB LOGS, SHOW ENGINE Syntax
SHOW ENGINE INNODB STATUS, SHOW ENGINE Syntax
SHOW ENGINE NDB STATUS, SHOW ENGINE Syntax
SHOW ENGINES, SHOW Syntax, SHOW ENGINES Syntax
SHOW ERRORS, SHOW Syntax, SHOW ERRORS Syntax
SHOW FIELDS, SHOW Syntax
SHOW GRANTS, SHOW Syntax, SHOW GRANTS Syntax
SHOW INDEX, SHOW Syntax, SHOW INDEX Syntax
SHOW INNODB STATUS, SHOW Syntax
SHOW KEYS, SHOW Syntax, SHOW INDEX Syntax
SHOW MASTER LOGS, SHOW Syntax, SHOW BINARY LOGS Syntax
SHOW MASTER STATUS, SHOW Syntax, SHOW MASTER STATUS Syntax
SHOW OPEN TABLES, SHOW Syntax, SHOW OPEN TABLES Syntax
SHOW PRIVILEGES, SHOW Syntax, SHOW PRIVILEGES Syntax
SHOW PROCESSLIST, SHOW Syntax, SHOW PROCESSLIST Syntax
SHOW SLAVE HOSTS, SHOW Syntax, SHOW SLAVE HOSTS Syntax
SHOW SLAVE STATUS, SHOW Syntax, SHOW SLAVE STATUS Syntax
SHOW STATUS, SHOW Syntax
SHOW STORAGE ENGINES, SHOW ENGINES Syntax
SHOW TABLE STATUS, SHOW Syntax
SHOW TABLE TYPES, SHOW Syntax, SHOW ENGINES Syntax
SHOW TABLES, SHOW Syntax, SHOW TABLES Syntax
SHOW VARIABLES, SHOW Syntax
SHOW WARNINGS, SHOW Syntax, SHOW WARNINGS Syntax
SHUTDOWN command (MySQL Cluster), Commands in the Management Client
shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
shutting down
the server, Unix Post-Installation Procedures
sigint-ignore option
mysql, mysql Options
SIGN(), Mathematical Functions
silent column changes, Silent Column Specification Changes
silent option
myisamchk, myisamchk General 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 and Repair Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlimport, mysqlimport — A Data Import Program
perror, perror — Explain Error Codes
SIN(), Mathematical Functions
single quote (\'), Strings
single user mode (MySQL Cluster), Commands in the Management Client, Single User Mode
and ndb_restore, How to Restore a Cluster Backup
single-transaction option
mysqldump, mysqldump — A Database Backup Program
size of tables, The table is full
sizes
display, Data Types
skip-bdb option
mysqld, Command Options, BDB Startup Options
skip-column-names option
mysql, mysql Options
skip-comments option
mysqldump, mysqldump — A Database Backup Program
skip-concurrent-insert option
mysqld, Command Options
skip-delay-key-write option
mysqld, Command Options
skip-external-locking option
mysqld, Command Options
skip-grant-tables option
mysqld, Command Options, Security-Related mysqld Options
skip-host-cache option
mysqld, Command Options
skip-innodb option
mysqld, Command Options
skip-isam option
mysqld, Command Options
skip-line-numbers option
mysql, mysql Options
skip-merge option
mysqld, Command Options
skip-name-resolve option
mysqld, Command Options, Security-Related mysqld Options
skip-ndbcluster option
mysqld, Command Options
skip-networking option
mysqld, Command Options, Security-Related mysqld Options
skip-new option
mysqld, Command Options
skip-opt option
mysqldump, mysqldump — A Database Backup Program
skip-safemalloc option
mysqld, Command Options
skip-show-database option
mysqld, Command Options, Security-Related mysqld Options
skip-slave-start option
mysqld, Replication Startup Options
skip-stack-trace option
mysqld, Command Options
skip-symbolic-links option
mysqld, Command Options
skip-symlink option
mysqld, Command Options
skip-thread-priority option
mysqld, Command Options
slave-load-tmpdir option
mysqld, Replication Startup Options
slave-net-timeout option
mysqld, Replication Startup Options
slave-skip-errors option
mysqld, Replication Startup Options
slave_compressed_protocol option
mysqld, Replication Startup Options
sleep option
mysqladmin, mysqladmin — Client for Administering a MySQL Server
slow queries, mysqladmin — Client for Administering a MySQL Server
slow query log, The Slow Query Log
SMALLINT data type, Overview of Numeric Types
socket location
changing, Typical configure Options
socket 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 and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
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
mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log
Solaris
installation, Installing MySQL on Solaris
Solaris installation problems, Solaris Notes
Solaris troubleshooting, Dealing with Problems Compiling MySQL
Solaris x86_64 issues, InnoDB Performance Tuning Tips
sort-index option
myisamchk, Other myisamchk Options
sort-records option
myisamchk, Other myisamchk Options
sort-recover option
myisamchk, myisamchk Repair Options
sorting
character sets, The Character Set Used for Data and Sorting
data, Sorting Rows
grant tables, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
table rows, Sorting Rows
sort_buffer_size myisamchk variable, myisamchk General Options
sort_key_blocks myisamchk variable, myisamchk General Options
SOUNDEX(), String Functions
SOUNDS LIKE, String Functions
source distribution
installing, MySQL Installation Using a Source Distribution
source distributions
on Linux, Linux Source Distribution Notes
SPACE(), String Functions
spassword option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
Spatial Extensions in MySQL, Introduction to MySQL Spatial Support
speed
compiling, How Compiling and Linking Affects the Speed of MySQL
increasing with replication, Replication
inserting, Speed of INSERT Statements
linking, How Compiling and Linking Affects the Speed of MySQL
of queries, Optimizing SELECT and Other Statements, Speed of SELECT Queries
SQL
defined, What is MySQL?
SQL mode
ONLY_FULL_GROUP_BY, GROUP BY and HAVING with Hidden Fields
SQL node (MySQL Cluster)
defined, Basic MySQL Cluster Concepts
SQL nodes (MySQL Cluster), MySQL Server Process Usage for MySQL Cluster
SQL statements
replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers
SQL-92
extensions to, MySQL Standards Compliance
sql-mode option
mysqld, Command Options
SQL_BIG_RESULT, SELECT Syntax
SQL_BUFFER_RESULT, SELECT Syntax
SQL_CACHE, Query Cache SELECT Options, SELECT Syntax
SQL_CALC_FOUND_ROWS, SELECT Syntax
SQL_NO_CACHE, Query Cache SELECT Options, SELECT Syntax
SQL_SMALL_RESULT, SELECT Syntax
sql_yacc.cc problems, Dealing with Problems Compiling MySQL
SQRT(), Mathematical Functions
square brackets, Data Types
SRID(), General Geometry Functions
SSH, Connecting to MySQL Remotely from Windows with SSH
SSL and X509 Basics, Using Secure Connections
SSL command options, SSL Command Options
ssl option, SSL Command Options
SSL options
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqld, Command Options, Connecting to the MySQL Server
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
SSL related options, GRANT Syntax
ssl-ca option, SSL Command Options
ssl-capath option, SSL Command Options
ssl-cert option, SSL Command Options
ssl-cipher option, SSL Command Options
ssl-key option, SSL Command Options
standalone option
mysqld, Command Options
Standard SQL
differences from, MySQL Differences from Standard SQL, GRANT Syntax
extensions to, MySQL Standards Compliance, MySQL Extensions to Standard SQL
standards compatibility, MySQL Standards Compliance
START BACKUP command (MySQL Cluster), Using The Management Client to Create a Backup
START command (MySQL Cluster), Commands in the Management Client
START SLAVE, START SLAVE Syntax
START TRANSACTION, START TRANSACTION, COMMIT, and ROLLBACK Syntax
start-datetime option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
start-position option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
StartFailureTimeout (MySQL Cluster configuration parameter), Defining Data Nodes
starting
comments, '--' as the Start of a Comment
mysqld, How to Run MySQL as a Normal User
the server, Unix Post-Installation Procedures
the server automatically, Starting and Stopping MySQL Automatically
Starting many servers, Running Multiple MySQL Servers on the Same Machine
StartPartialTimeout, Defining Data Nodes
StartPartitionedTimeout (MySQL Cluster configuration parameter), Defining Data Nodes
StartPoint(), LineString Functions
STARTUP Events (MySQL Cluster), Log Events
startup options
default, Using Option Files
startup parameters, Tuning Server Parameters
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
tuning, System Factors and Startup Parameter Tuning
statements
GRANT, Adding New User Accounts to MySQL
INSERT, Adding New User Accounts to MySQL
replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers
statically
compiling, Typical configure Options
STATISTICS Events (MySQL Cluster), Log Events
stats option
myisam_ftdump, myisam_ftdump — Display Full-Text Index information
stats_method myisamchk variable, myisamchk General Options
status
tables, SHOW TABLE STATUS Syntax
status command
results, mysqladmin — Client for Administering a MySQL Server
STATUS command (MySQL Cluster), Commands in the Management Client
status option
mysqlshow, mysqlshow — Display Database, Table, and Column Information
status variables, Status Variables, SHOW STATUS Syntax
STD(), GROUP BY (Aggregate) Functions
STDDEV(), GROUP BY (Aggregate) Functions
STOP command (MySQL Cluster), Commands in the Management Client
STOP SLAVE, STOP SLAVE Syntax
stop-datetime option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
stop-position option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
StopOnError, Defining Data Nodes
stopping
the server, Starting and Stopping MySQL Automatically
stopword list
user-defined, Fine-Tuning MySQL Full-Text Search
storage engine
ARCHIVE, The ARCHIVE Storage Engine
storage engines
choosing, Storage Engines and Table Types
storage nodes - see data nodes, ndbd, ndbd, the Storage Engine Node Process
storage of data, Design Choices
storage requirements
data type, Data Type Storage Requirements
storage space
minimizing, Make Your Data as Small as Possible
stored procedures and triggers
defined, Stored Routines and Triggers
STRAIGHT_JOIN, SELECT Syntax, JOIN Syntax
STRCMP(), String Comparison Functions
string collating, String Collating Support
string comparison functions, String Comparison Functions
string comparisons
case sensitivity, String Comparison Functions
string functions, String Functions
string literal introducer, Strings, Character String Literal Character Set and Collation
string types, String Types
StringMemory, Defining Data Nodes
strings
defined, Literal Values
escaping characters, Literal Values
non-delimited, The DATETIME, DATE, and TIMESTAMP Types
striping
defined, Disk Issues
STR_TO_DATE(), Date and Time Functions
SUBDATE(), Date and Time Functions
subqueries, Subquery Syntax
subquery, Subquery Syntax
subquery restrictions, Restrictions on Subqueries
subselects, Subquery Syntax
SUBSTR(), String Functions
SUBSTRING(), String Functions
SUBSTRING_INDEX(), String Functions
SUBTIME(), Date and Time Functions
subtraction (-), Arithmetic Operators
suffix option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
SUM(), GROUP BY (Aggregate) Functions
superuser, Securing the Initial MySQL Accounts
superuser option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
support
for operating systems, Operating Systems On Which MySQL Is Known To Run
suppression
default values, Constraints on Invalid Data
Sybase compatibility, USE Syntax
symbolic links, Using Symbolic Links, Using Symbolic Links for Databases on Windows
symbolic-links option
mysqld, Command Options
SymDifference(), Spatial Operators
sync-bdb-logs option
mysqld, BDB Startup Options
syntax
regular expression, Regular Expressions
SYSDATE(), Date and Time Functions
system
privilege, What the Privilege System Does
security, General Security Issues
system optimization, System Factors and Startup Parameter Tuning
system table, Optimizing Queries with EXPLAIN
system variables, System Variables, Using System Variables, SHOW VARIABLES Syntax
SYSTEM_USER(), Information Functions

T

tab (\t), Strings
tab option
mysqldump, mysqldump — A Database Backup Program
table
changing, ALTER TABLE Syntax, Problems with ALTER TABLE
deleting, DROP TABLE Syntax
table aliases, SELECT Syntax
table cache, How MySQL Opens and Closes Tables
table is full, SET Syntax, The table is full
table names
case sensitivity, Identifier Case Sensitivity
case-sensitivity, MySQL Extensions to Standard SQL
table option
mysql, mysql Options
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
Table scans
avoiding, How to Avoid Table Scans
table types
choosing, Storage Engines and Table Types
table-level locking, Locking Methods
tables
BDB, The BDB (BerkeleyDB) Storage Engine
Berkeley DB, The BDB (BerkeleyDB) Storage Engine
BLACKHOLE, The BLACKHOLE Storage Engine
changing column order, How to Change the Order of Columns in a Table
checking, myisamchk Check Options
closing, How MySQL Opens and Closes Tables
compressed format, Compressed Table Characteristics
constant, Optimizing Queries with EXPLAIN, WHERE Clause Optimization
copying, CREATE TABLE Syntax
counting rows, Counting Rows
creating, Creating a Table
CSV, The CSV Storage Engine
defragment, Dynamic Table Characteristics
defragmenting, Setting Up a Table Maintenance Schedule, OPTIMIZE TABLE Syntax
deleting rows, Deleting Rows from Related Tables
displaying status, SHOW TABLE STATUS Syntax
dynamic, Dynamic Table Characteristics
error checking, How to Check MyISAM Tables for Errors
EXAMPLE, The EXAMPLE Storage Engine
flush, mysqladmin — Client for Administering a MySQL Server
fragmentation, OPTIMIZE TABLE Syntax
grant, Access Control, Stage 2: Request Verification
HEAP, The MEMORY (HEAP) Storage Engine
host, Access Control, Stage 2: Request Verification
improving performance, Make Your Data as Small as Possible
information, Getting Information About a Table
information about, Getting Information About Databases and Tables
InnoDB, The InnoDB Storage Engine
ISAM, The ISAM Storage Engine
loading data, Loading Data into a Table
maintenance schedule, Setting Up a Table Maintenance Schedule
maximum size, The table is full
MEMORY, The MEMORY (HEAP) Storage Engine
MERGE, The MERGE Storage Engine
merging, The MERGE Storage Engine
multiple, Using More Than one Table
MyISAM, The MyISAM Storage Engine
names, Database, Table, Index, Column, and Alias Names
open, How MySQL Opens and Closes Tables
opening, How MySQL Opens and Closes Tables
optimizing, Table Optimization
partitioning, The MERGE Storage Engine
RAID, CREATE TABLE Syntax
repairing, How to Repair Tables
retrieving data, Retrieving Information from a Table
selecting columns, Selecting Particular Columns
selecting rows, Selecting Particular Rows
sorting rows, Sorting Rows
symbolic links, Using Symbolic Links for Tables on Unix
system, Optimizing Queries with EXPLAIN
too many, Drawbacks to Creating Many Tables in the Same Database
unique ID for last row, How to Get the Unique ID for the Last Inserted Row
updating, Transactions and Atomic Operations
tables option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
table_cache, How MySQL Opens and Closes Tables
TAN(), Mathematical Functions
tar
problems on Solaris, Installing MySQL on Solaris, Solaris Notes
Tcl API, MySQL Tcl API
tcp-ip option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
TCP/IP, Selecting a MySQL Server type, Testing The MySQL Installation
tee option
mysql, mysql Options
temp-pool option
mysqld, Command Options
temporary file
write access, Problems Running mysql_install_db
temporary tables
problems, TEMPORARY TABLE Problems
terminal monitor
defined, Tutorial
test option
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
testing
connection to the server, Access Control, Stage 1: Connection Verification
installation, Unix Post-Installation Procedures
of MySQL releases, Choosing Which Version of MySQL to Install
post-installation, Post-Installation Setup and Testing
testing mysqld
mysqltest, MySQL Test Suite
TEXT
size, Data Type Storage Requirements
TEXT columns
default values, The BLOB and TEXT Types
indexing, Column Indexes, CREATE TABLE Syntax
TEXT data type, Overview of String Types, The BLOB and TEXT Types
thread packages
differences between, Differences Between Thread Packages
thread support, Operating Systems On Which MySQL Is Known To Run
non-native, MIT-pthreads Notes
threaded clients, How to Make a Threaded Client
threads, mysqladmin — Client for Administering a MySQL Server, SHOW PROCESSLIST Syntax, MySQL Internals
display, SHOW PROCESSLIST Syntax
RTS, Comments about RTS Threads
TIME data type, Overview of Date and Time Types, The TIME Type
time types, Data Type Storage Requirements
time zone problems, Time Zone Problems
TIME(), Date and Time Functions
TimeBetweenGlobalCheckpoints (MySQL Cluster configuration parameter), Defining Data Nodes
TimeBetweenInactiveTransactionAbortCheck (MySQL Cluster configuration parameter), Defining Data Nodes
TimeBetweenLocalCheckpoints (MySQL Cluster configuration parameter), Defining Data Nodes
TimeBetweenWatchDogCheck, Defining Data Nodes
TIMEDIFF(), Date and Time Functions
timeout, System Variables, Miscellaneous Functions, INSERT DELAYED Syntax
connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
TIMESTAMP
and NULL values, Problems with NULL Values
TIMESTAMP data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
TIMESTAMP(), Date and Time Functions
timezone option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
TIME_FORMAT(), Date and Time Functions
TIME_TO_SEC(), Date and Time Functions
TINYBLOB data type, Overview of String Types
TINYINT data type, Overview of Numeric Types
TINYTEXT data type, Overview of String Types
tips
optimization, Other Optimization Tips
TMPDIR environment variable, Problems Running mysql_install_db, Environment Variables
tmpdir option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
mysqld, Command Options
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
to-last-log option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
TODO
symlinks, Using Symbolic Links for Tables on Unix
tools
list of, Tools that were used to create MySQL
Touches(), Functions That Test Spatial Relationships Between Geometries
TO_DAYS(), Date and Time Functions
trace DBI method, Debugging mysqld under gdb
trace files (MySQL Cluster), ndbd, the Storage Engine Node Process
transaction-isolation option
mysqld, Command Options
transaction-safe tables, Transactions and Atomic Operations, InnoDB Overview
TransactionBufferMemory, Defining Data Nodes
TransactionDeadlockDetectionTimeout (MySQL Cluster configuration parameter), Defining Data Nodes
TransactionInactiveTimeout (MySQL Cluster configuration parameter), Defining Data Nodes
transactions
support, Transactions and Atomic Operations, InnoDB Overview
Translators
list of, Documenters and translators
triggers, Stored Routines and Triggers
TRIM(), String Functions
troubleshooting
FreeBSD, Dealing with Problems Compiling MySQL
Solaris, Dealing with Problems Compiling MySQL
TRUE, Numbers, Boolean Values
TRUNCATE, TRUNCATE Syntax
and MySQL Cluster, Known Limitations of MySQL Cluster
TRUNCATE(), Mathematical Functions
tutorial, Tutorial
Twin Studies
queries, Queries from the Twin Project
type conversions, Type Conversion in Expression Evaluation, Comparison Functions and Operators
types
column, Data Types
columns, Choosing the Right Type for a Column
data, Data Types
date, Data Type Storage Requirements
Date and Time, Date and Time Types
numeric, Data Type Storage Requirements
of tables, Storage Engines and Table Types
portability, Using Data Types from Other Database Engines
strings, String Types
time, Data Type Storage Requirements
typographical conventions, Conventions Used in This Manual
TZ environment variable, Time Zone Problems, Environment Variables

U

UCASE(), String Functions
UCS-2, Character Set Support
UDFs, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
compiling, Compiling and Installing User-Defined Functions
defined, Adding New Functions to MySQL
return values, UDF Return Values and Error Handling
ulimit, 'File' Not Found and Similar Errors
UMASK environment variable, Problems with File Permissions, Environment Variables
UMASK_DIR environment variable, Problems with File Permissions, Environment Variables
unary minus (-), Arithmetic Operators
unbuffered option
mysql, mysql Options
UNCOMPRESS(), Encryption and Compression Functions
UNCOMPRESSED_LENGTH(), Encryption and Compression Functions
UndoDataBuffer, Defining Data Nodes
UndoIndexBuffer, Defining Data Nodes
UNHEX(), String Functions
Unicode, Character Set Support
Unicode Collation Algorithm, Unicode Character Sets
UNION, Searching on Two Keys, UNION Syntax
Union(), Spatial Operators
UNIQUE, ALTER TABLE Syntax
constraint, PRIMARY KEY and UNIQUE Index Constraints
unique ID, How to Get the Unique ID for the Last Inserted Row
Unix, MySQL Connector/ODBC, MySQL Connector/NET
UNIX_TIMESTAMP(), Date and Time Functions
unloading
tables, Retrieving Information from a Table
UNLOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax
unnamed views, Subqueries in the FROM clause
unpack option
myisamchk, myisamchk Repair Options
UPDATE, UPDATE Syntax
update log, The Update Log
update-state option
myisamchk, myisamchk Check Options
updating
releases of MySQL, How and When Updates Are Released
tables, Transactions and Atomic Operations
upgrades
MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility
upgrades and downgrades (MySQL Cluster)
compatibility between versions, Cluster Upgrade and Downgrade Compatibility
upgrading, Upgrading MySQL
3.23 to 4.0, Upgrading from MySQL 3.23 to 4.0
4.0 to 4.1, Upgrading from MySQL 4.0 to 4.1
different architecture, Copying MySQL Databases to Another Machine
UPPER(), String Functions
uptime, mysqladmin — Client for Administering a MySQL Server
URLs for downloading MySQL, How to Get MySQL
USE, USE Syntax
USE INDEX, SELECT Syntax, JOIN Syntax
USE KEY, SELECT Syntax, JOIN Syntax
use-frm option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
USER environment variable, Connecting to the MySQL Server, Environment Variables
user option
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 and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
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
mysql_explain_log, mysql_explain_log — Use EXPLAIN on Statements in Query Log
user privileges
adding, Adding New User Accounts to MySQL
deleting, Removing User Accounts from MySQL, DROP USER Syntax
dropping, Removing User Accounts from MySQL, DROP USER Syntax
user table
sorting, Access Control, Stage 1: Connection Verification
user variables, User-Defined Variables
USER(), Information Functions
user-defined functions
adding, Adding New Functions to MySQL, Adding a New User-Defined Function
User-defined functions, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
usernames
and passwords, MySQL Usernames and Passwords
users
adding, Installing MySQL on Other Unix-Like Systems, Source Installation Overview
deleting, Removing User Accounts from MySQL, DROP USER Syntax
root, Securing the Initial MySQL Accounts
uses
of MySQL, What We Have Used MySQL For
using multiple disks to start data, Using Symbolic Links for Databases on Windows
UTC_DATE(), Date and Time Functions
UTC_TIME(), Date and Time Functions
UTC_TIMESTAMP(), Date and Time Functions
UTF-8, Character Set Support
utility programs, Overview of Client and Utility Programs
UUID(), Miscellaneous Functions

V

valid numbers
examples, Numbers
VALUES(), Miscellaneous Functions
VARBINARY data type, Overview of String Types, The BINARY and VARBINARY Types
VARCHAR
size, Data Type Storage Requirements
VARCHAR data type, Overview of String Types, String Types
VARCHARACTER data type, Overview of String Types
variables
mysqld, Tuning Server Parameters
server, System Variables, SHOW VARIABLES Syntax
status, Status Variables, SHOW STATUS Syntax
system, System Variables, Using System Variables, SHOW VARIABLES Syntax
user, User-Defined Variables
VARIANCE(), GROUP BY (Aggregate) Functions
verbose option
myisamchk, myisamchk General Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
myisam_ftdump, myisam_ftdump — Display Full-Text Index information
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
my_print_defaults, my_print_defaults — Display Options from Option Files
perror, perror — Explain Error Codes
version
choosing, Choosing Which MySQL Distribution to Install
latest, How to Get MySQL
version option
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 and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
my_print_defaults, my_print_defaults — Display Options from Option Files
perror, perror — Explain Error Codes
VERSION(), Information Functions
vertical option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
views, Views
updatable, Views
virtual memory
problems while compiling, Dealing with Problems Compiling MySQL
Vision, Using Connector/ODBC with SunSystems Vision
Visual Objects, Visual Objects
Visual Studio Plugin, Connectors

W

wait option
myisamchk, myisamchk General Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
WEEK(), Date and Time Functions
WEEKDAY(), Date and Time Functions
WEEKOFYEAR(), Date and Time Functions
Well-Known Binary format, Well-Known Binary (WKB) Format
Well-Known Text format, Well-Known Text (WKT) Format
WHERE, WHERE Clause Optimization
where option
mysqldump, mysqldump — A Database Backup Program
widths
display, Data Types
Wildcard character (%), Strings
Wildcard character (_), Strings
wildcards
and LIKE, How MySQL Uses Indexes
in mysql.columns_priv table, Access Control, Stage 2: Request Verification
in mysql.db table, Access Control, Stage 2: Request Verification
in mysql.host table, Access Control, Stage 2: Request Verification
in mysql.procs_priv table, Access Control, Stage 2: Request Verification
in mysql.tables_priv table, Access Control, Stage 2: Request Verification
in mysql.user table, Access Control, Stage 1: Connection Verification
Windows, MySQL Connector/ODBC, MySQL Connector/NET
compiling on, Compiling MySQL Clients on Windows
open issues, MySQL on Windows Compared to MySQL on Unix
upgrading, Upgrading MySQL on Windows
versus Unix, MySQL on Windows Compared to MySQL on Unix
with-big-tables option, Typical configure Options
configure, Typical configure Options
with-debug option
configure, Typical configure Options
with-embedded-server option
configure, Typical configure Options
with-extra-charsets option
configure, Typical configure Options
with-unix-socket-path option
configure, Typical configure Options
Within(), Functions That Test Spatial Relationships Between Geometries
without-server option, Typical configure Options
configure, Typical configure Options
WKB format, Well-Known Binary (WKB) Format
WKT format, Well-Known Text (WKT) Format
wrappers
Eiffel, MySQL Eiffel Wrapper
write access
tmp, Problems Running mysql_install_db
write_buffer_size myisamchk variable, myisamchk General Options