Index
Prev |  |

## Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

### Symbols

[index top]

! (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, LOAD DATA INFILE Syntax
* (multiplication), Arithmetic Operators
+ (addition), Arithmetic Operators
- (subtraction), Arithmetic Operators
- (unary minus), Arithmetic Operators
--config-file option (ndb_mgmd), Command Options for ndb_mgmd
--connect-string option (MySQL Cluster), Command Options for MySQL Cluster Processes
--daemon option (ndb_mgmd), Command Options for ndb_mgmd
--debug option (MySQL Cluster), Command Options for MySQL Cluster Processes
--execute option (MySQL Cluster), Command Options for MySQL Cluster Processes
--help option
  MySQL Cluster programs, Command Options for MySQL Cluster Processes
--initial option (ndbd), Command Options for ndbd
--ndb-connectstring option (MySQL Cluster), MySQL Cluster-Related Command Options for mysqld
--ndbcluster option (MySQL Cluster), MySQL Cluster-Related Command Options for mysqld
--nodaemon option (ndbd), Command Options for ndbd
--nodaemon option (ndb_mgmd), Command Options for ndb_mgmd
--nostart option (ndbd), Command Options for ndbd
--password option, Keeping Your Password Secure
--print-full-config option (ndb_mgmd), Command Options for ndb_mgmd
--usage option
  MySQL Cluster programs, Command Options for MySQL Cluster Processes
--version option (MySQL Cluster), Command Options for MySQL Cluster Processes
--with-raid link errors, Dealing with Problems Compiling MySQL
-? option
  MySQL Cluster programs, Command Options for MySQL Cluster Processes
-c option (ndb_mgmd) (OBSOLETE), Command Options for ndb_mgmd
-d option (ndb_mgmd), Command Options for ndb_mgmd
-e option (MySQL Cluster), Command Options for MySQL Cluster Processes
-f option (ndb_mgmd), Command Options for ndb_mgmd
-n option (ndbd), Command Options for ndbd
-p option, Keeping Your Password Secure
-P option (ndb_mgmd), Command Options for ndb_mgmd
-V option (MySQL Cluster), Command Options for MySQL Cluster Processes
.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
:= (assignment), Comment 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
= (assignment), Comment Syntax
= (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 default] (MySQL Cluster), Data Node Configuration Parameters
[ndbd] (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
\. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
\0 (ASCII 0), Strings, LOAD DATA INFILE Syntax
\b (backspace), Strings, LOAD DATA INFILE Syntax
\n (linefeed), Strings, LOAD DATA INFILE Syntax
\n (newline), Strings, LOAD DATA INFILE Syntax
\N (NULL), LOAD DATA INFILE Syntax
\r (carriage return), Strings, LOAD DATA INFILE Syntax
\t (tab), Strings, LOAD DATA INFILE Syntax
\Z (Control-Z) ASCII 26, Strings, LOAD DATA INFILE Syntax
\\ (escape), Strings
^ (bitwise XOR), Bit Functions
_ (wildcard character), Strings
_rowid, CREATE TABLE Syntax
`, Database, Table, Index, Column, and Alias Names
| (bitwise OR), Bit Functions
|| (logical OR), Logical Operators
~, Bit Functions

### A

[index top]

abort-slave-event-count option
  mysqld, Command Options
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 from tar.gz Packages on Other Unix-Like Systems, Source Installation Overview
  procedures, Adding New Procedures to MySQL
  user-defined functions, Adding a New User-Defined Function
addition (+), Arithmetic Operators
ADDTIME(), Date and Time Functions
addtodest option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
administrative programs, Overview of MySQL Programs
AES_DECRYPT(), Encryption and Compression Functions
AES_ENCRYPT(), Encryption and Compression Functions
After create
  thread state, General Thread States
age
  calculating, Date Calculations
alias, Problems with Column Aliases
alias names
  case sensitivity, Identifier Case Sensitivity
aliases
  for expressions, GROUP BY and HAVING with Hidden 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, Subqueries with ALL
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
allocating local table
  thread state, Delayed-Insert Thread States
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
Analyzing
  thread state, General Thread States
AND
  bitwise, Bit Functions
  logical, Logical Operators
anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
ANSI mode
  running, Running MySQL in ANSI Mode
ansi option
  mysqld, Command Options
ANSI SQL mode, SQL Modes
ANSI_QUOTES SQL mode, SQL Modes
answering questions
  etiquette, Guidelines for Using the Mailing Lists
ANY, Subqueries with ANY, IN, and SOME
Apache, Using MySQL with Apache
API node (MySQL Cluster)
  defined, MySQL Cluster Core Concepts
API nodes, 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, Defining Data Nodes
arbitrator, MySQL Cluster FAQ
ARCHIVE storage engine, Storage Engines, The ARCHIVE Storage Engine
Area(), Polygon Functions, MultiPolygon Functions
argument processing, UDF Argument Processing
arithmetic expressions, Arithmetic Operators
arithmetic functions, Bit Functions
AS, SELECT Syntax, JOIN Syntax
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

[index top]

backslash
  escape character, Literal Values
backspace (\b), Strings, LOAD DATA INFILE Syntax
backup identifiers
  native backup and restore, Using The Management Client to Create a Backup
backup option
  myisamchk, myisamchk Repair Options
  myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
BACKUP TABLE, BACKUP TABLE Syntax
BackupDataBufferSize, Configuration for 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, Configuration for Cluster Backup
backups, troubleshooting
  in MySQL Cluster, Backup Troubleshooting
BackupWriteSize, Defining Data Nodes, Configuration for Cluster Backup
basedir option
  mysql.server, mysql.server — MySQL Server Startup Script
  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, 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, 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 from tar.gz Packages on Other Unix-Like Systems
  on Linux, Linux Binary Distribution Notes
binary log, The Binary Log
binary logging
  and MySQL Cluster, Issues Exclusive to MySQL Cluster
bind-address option
  mysqld, Command Options
Binlog Dump
  thread command, Thread Command Values
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, 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
  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

[index top]

C API
  data types, MySQL C API
  functions, C API Function Overview
  linking problems, Problems Linking with the C API
C prepared statement API
  functions, C API Prepared Statement Function Overview
C++ APIs, MySQL C++ API
C++ Builder, Using Connector/ODBC with C++ Builder
C++ compiler
  gcc, Typical configure Options
C++ compiler cannot create executables, Dealing with Problems Compiling MySQL
C:\my.cnf file, Using Client Programs in a Multiple-Server Environment
CACHE INDEX, CACHE INDEX Syntax
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, LOAD DATA INFILE Syntax
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
CEIL(), Mathematical Functions
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
Change user
  thread command, Thread Command Values
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 master
  thread state, Replication Slave Connection Thread States
changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Unix Socket File
CHAR data type, Overview of String Types, String Types
CHAR VARYING data type, Overview of String Types
CHAR(), String Functions
CHARACTER data type, Overview of String Types
character sets, Typical configure Options, The Character Set Used for Data and Sorting
  adding, Adding a New Character Set
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
Checking master version
  thread state, Replication Slave I/O Thread States
Checking table
  thread state, General Thread States
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
cleaning up
  thread state, General Thread States
clear option
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
clear-only option
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
clearing
  caches, FLUSH Syntax
client programs, Overview of MySQL Programs
  building, Building Client Programs
client tools, APIs and Libraries
clients
  debugging, Debugging a MySQL Client
  threaded, How to Make a Threaded Client
Close stmt
  thread command, Thread Command Values
closing
  tables, How MySQL Opens and Closes Tables
closing tables
  thread state, General Thread States
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
col option
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
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
  mysqladmin, mysqladmin — Client for Administering a MySQL Server
  mysqld, Command Options
command options (MySQL Cluster), Command Options for MySQL Cluster Processes
  mysqld, MySQL Cluster-Related Command Options for mysqld
  ndbd, Command Options for ndbd
  ndb_mgm, Command Options for ndb_mgm
  ndb_mgmd, Command Options for ndb_mgmd
command syntax, Conventions Used in This Manual
command-line history
  mysql, mysql Options
commands
  for binary distribution, Installing MySQL from tar.gz Packages on Other Unix-Like Systems
commands out of sync, Commands out of sync
Comment syntax, Comment Syntax
comments
  adding, Comment Syntax
  starting, '--' as the Start of a Comment
comments option
  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
Committing events to binlog
  thread state, MySQL Cluster Thread States
compact option
  mysqldump, mysqldump — A Database Backup Program
comparison operators, Comparison Functions and Operators
compatibility
  between MySQL versions, Upgrading from MySQL 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
comp_err, Overview of MySQL Programs
CONCAT(), String Functions
CONCAT_WS(), String Functions
concurrent inserts, Internal 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
  ndb_config, ndb_config — Extract NDB Configuration Information
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), MySQL Cluster Core Concepts
Connect
  thread command, Thread Command Values
Connect Out
  thread command, Thread Command Values
connecting
  remotely with SSH, Connecting to MySQL Remotely from Windows with SSH
  to the server, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
  verification, Access Control, Stage 1: Connection Verification
Connecting to master
  thread state, Replication Slave I/O Thread States
connection
  aborted, Communication Errors and Aborted Connections
CONNECTION Events (MySQL Cluster), 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(), Mathematical Functions
conventions
  typographical, Conventions Used in This Manual
CONVERT, Cast Functions and Operators
CONVERT TO, ALTER TABLE Syntax
converting HEAP to MyISAM
  thread state, General Thread States
CONVERT_TZ(), Date and Time Functions
ConvexHull(), Spatial Operators
copy option
  mysqlaccess, mysqlaccess — Client for Checking Access Privileges
copy to tmp table
  thread state, General Thread States
copying databases, Copying MySQL Databases to Another Machine
copying tables, CREATE TABLE Syntax
Copying to group table
  thread state, General Thread States
Copying to tmp table
  thread state, General Thread States
Copying to tmp table on disk
  thread state, General Thread States
core-file option
  mysqld, Command Options
core-file-size option
  mysqld_safe, mysqld_safe — MySQL Server Startup Script
correct-checksum option
  myisamchk, myisamchk Repair Options
correlated subqueries, Correlated Subqueries
COS(), Mathematical Functions
COT(), Mathematical Functions
count option
  myisam_ftdump, myisam_ftdump — Display Full-Text Index information
  mysqladmin, mysqladmin — Client for Administering a MySQL Server
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 DB
  thread command, Thread Command Values
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
Creating delayed handler
  thread state, Delayed-Insert Thread States
Creating index
  thread state, General Thread States
Creating sort index
  thread state, General Thread States
creating table
  thread state, General Thread States
Creating table from master dump
  thread state, Replication Slave Connection Thread States
Creating tmp table
  thread state, General Thread States
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, 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

[index top]

Daemon
  thread command, Thread Command Values
data
  character sets, The Character Set Used for Data and Sorting
  importing, Executing SQL Statements from a Text File
  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, MySQL Cluster Core Concepts
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
  NATIONAL VARCHAR, Overview of String Types
  NCHAR, Overview of String Types
  NUMERIC, Overview of Numeric Types
  NVARCHAR, Overview of String Types
  POINT, MySQL Spatial Data Types
  POLYGON, MySQL Spatial Data Types
  REAL, Overview of Numeric Types
  SET, Overview of String Types, The SET Type
  SMALLINT, Overview of Numeric Types
  TEXT, Overview of String Types, The BLOB and TEXT Types
  TIME, Overview of Date and Time Types, The TIME Type
  TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
  TINYBLOB, Overview of String Types
  TINYINT, Overview of Numeric Types
  TINYTEXT, Overview of String Types
  VARBINARY, Overview of String Types, The BINARY and VARBINARY Types
  VARCHAR, Overview of String Types, String Types
  VARCHARACTER, Overview of String Types
  YEAR, Overview of Date and Time Types, The YEAR Type
data types, Data Types
  C API, MySQL C API
  overview, Data Type Overview
data-file-length option
  myisamchk, myisamchk Repair Options
database
  altering, ALTER DATABASE Syntax
  creating, CREATE DATABASE Syntax
  deleting, DROP DATABASE Syntax
database 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
  mysql.server, mysql.server — MySQL Server Startup Script
  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, Environment Variables, Debugging mysqld under gdb
DBI_USER environment variable, Environment Variables
DBUG package, The DBUG Package
DEALLOCATE PREPARE, SQL Syntax for Prepared Statements
Debug
  thread command, Thread Command Values
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, Command-Line Options that Affect Option-File Handling
  mysqld_safe, mysqld_safe — MySQL Server Startup Script
  my_print_defaults, my_print_defaults — Display Options from Option Files
defaults-file option, Command-Line Options that Affect Option-File Handling
  mysqld_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
  thread command, Thread Command Values
delayed inserts
  thread states, Delayed-Insert Thread States
delayed-insert option
  mysqldump, mysqldump — A Database Backup Program
delayed_insert_limit, INSERT DELAYED Syntax
DELETE, DELETE Syntax
  and MySQL Cluster, Limits and Differences from Standard MySQL Limits
delete option
  mysqlimport, mysqlimport — A Data Import Program
delete-master-logs option
  mysqldump, mysqldump — A Database Backup Program
deleting
  database, DROP DATABASE Syntax
  foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
  function, DROP FUNCTION Syntax
  index, ALTER TABLE Syntax, DROP INDEX Syntax
  primary key, ALTER TABLE Syntax
  rows, Deleting Rows from Related Tables
  table, DROP TABLE Syntax
  user, Removing User Accounts from MySQL, DROP USER Syntax
  users, Removing User Accounts from MySQL, DROP USER Syntax
deleting from main table
  thread state, General Thread States
deleting from reference tables
  thread state, General Thread States
deletion
  mysql.sock, How to Protect or Change the MySQL Unix Socket File
delimiter option
  mysql, mysql Options
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
Delphi, Using Connector/ODBC with Delphi
derived tables, Subqueries in the FROM clause
des-key-file option
  mysqld, Command Options
DESC, DESCRIBE Syntax
descending option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
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
discard_or_import_tablespace
  thread state, General Thread States
disconnect-slave-event-count option
  mysqld, Command Options
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 DB
  thread command, Thread Command Values
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, Limits and Differences from Standard MySQL Limits
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

[index top]

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-pstack 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
end
  thread state, General Thread States
EndPoint(), LineString Functions
ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client
entering
  queries, Entering Queries
ENUM
  size, Data Type Storage Requirements
ENUM data type, Overview of String Types, The ENUM Type
Envelope(), General Geometry Functions
environment variable
  CC, Typical configure Options, Dealing with Problems Compiling MySQL
  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 MySQL Programs
  MYSQL_HISTFILE, mysql Options
  MYSQL_HOST, Connecting to the MySQL Server
  MYSQL_PWD, Overview of MySQL Programs, Connecting to the MySQL Server
  MYSQL_TCP_PORT, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
  MYSQL_UNIX_PORT, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
  PATH, Installing MySQL from tar.gz Packages on Other Unix-Like Systems, 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, Environment Variables, Debugging mysqld under gdb
  DBI_USER, Environment Variables
  HOME, Environment Variables
  LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
  LD_RUN_PATH, Environment Variables, Problems Using the Perl DBI/DBD Interface
  MYSQL_DEBUG, Environment Variables, Debugging a MySQL Client
  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, Environment Variables, Time Zone Problems
  UMASK, Environment Variables, Problems with File Permissions
  UMASK_DIR, Environment Variables, Problems with File Permissions
  USER, Environment Variables
Environment variables
  CXX, Dealing with Problems Compiling MySQL
environment variables, Overview of MySQL Programs, Setting Environment Variables, Causes of Access denied Errors
  list of, Environment Variables
equal (=), Comparison Functions and Operators
Equals(), Functions That Test Spatial Relationships Between Geometries
Error
  thread command, Thread Command Values
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
  in subqueries, Subquery Errors
  known, Known Issues in MySQL
  linking, Problems Linking to the MySQL Client Library
  list of, Common Errors When Using MySQL Programs
  lost connection, Lost connection to MySQL server
  reporting, General Information, How to Report Bugs or Problems
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, 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
  thread command, Thread Command Values
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
executing SQL statements from text files, Using mysql in Batch Mode, Executing SQL Statements from a Text File
Execution of init_command
  thread state, General Thread States
EXISTS
  with subqueries, EXISTS and NOT EXISTS
EXIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client
EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client
exit-info option
  mysqld, 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, External Locking, General Thread States
external-locking option
  mysqld, Command Options
extra-file option
  my_print_defaults, my_print_defaults — Display Options from Option Files
extra-partition-info option
  ndb_desc, ndb_desc — Describe NDB Tables
EXTRACT(), Date and Time Functions
extracting
  dates, Date Calculations

### F

[index top]

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
Fetch
  thread command, Thread Command Values
field
  changing, ALTER TABLE Syntax
Field List
  thread command, Thread Command Values
FIELD(), String Functions
fields option
  ndb_config, ndb_config — Extract NDB Configuration Information
fields-enclosed-by option
  mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
fields-escaped-by option
  mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
fields-optionally-enclosed-by option
  mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
fields-terminated-by option
  mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
FILE, String Functions
files
  binary log, The Binary Log
  config.cache, Dealing with Problems Compiling MySQL
  error messages, Setting the Error Message Language
  general query log, The General Query Log
  log, Typical configure Options, Server Log Maintenance
  my.cnf, Replication Features and 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
  text, Executing SQL Statements from a Text File
  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
Finished reading one binlog; switching to next binlog
  thread state, Replication Master Thread States
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
Flushing tables
  thread state, General Thread States
flushlog option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
FOR UPDATE, SELECT Syntax
FORCE INDEX, Index Hint Syntax, Optimizer-Related Issues
FORCE KEY, Index Hint Syntax
force option
  myisamchk, myisamchk Check Options, myisamchk Repair Options
  myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
  mysql, mysql Options
  mysqladmin, mysqladmin — Client for Administering a MySQL Server
  mysqlcheck, mysqlcheck — A Table Maintenance 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
freeing items
  thread state, General Thread States
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
FULLTEXT initialization
  thread state, General Thread States
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

[index top]

gap lock, InnoDB Startup Options and System Variables, InnoDB and TRANSACTION ISOLATION LEVEL, Next-Key Locking: Avoiding the Phantom Problem
gcc, Typical configure Options
gci option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
gdb
  using, Debugging mysqld under gdb
gdb option
  mysqld, Command Options
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?
got handler lock
  thread state, Delayed-Insert Thread States
got old table
  thread state, Delayed-Insert Thread States
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

[index top]

HANDLER, HANDLER Syntax
handling
  errors, UDF Return Values and Error Handling
Has read all relay log; waiting for the slave I/O thread to update it
  thread state, Replication Slave SQL Thread States
Has sent all binlog to slave; waiting for binlog to be updated
  thread state, Replication Master Thread States
HAVING, SELECT Syntax
header option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
HEAP storage engine, Storage Engines, 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 MySQL Cluster 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
  mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
  mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
  mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination
  my_print_defaults, my_print_defaults — Display Options from Option Files
  perror, perror — Explain Error Codes
  resolveip, resolveip — Resolve Hostname to IP Address or Vice Versa
  resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
HELP statement, HELP Syntax
HEX(), String Functions, Mathematical 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, Index Hint Syntax
history of MySQL, History of MySQL
HOME environment variable, Environment Variables, mysql Options
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
  mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
  ndb_config, ndb_config — Extract NDB Configuration Information
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

[index top]

i-am-a-dummy option
  mysql, mysql Options
icc
  and MySQL Cluster support>, Porting to Other Systems
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
id option
  ndb_config, ndb_config — Extract NDB Configuration Information
identifiers, Database, Table, Index, Column, and Alias Names
  case sensitivity, Identifier Case Sensitivity
  quoting, Database, Table, Index, Column, and Alias Names
idx option
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
IF(), Control Flow Functions
IFNULL(), Control Flow Functions
IGNORE INDEX, Index Hint Syntax
IGNORE KEY, Index Hint 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
importing
  data, Executing SQL Statements from a Text File
IN, Comparison Functions and Operators, Subqueries with ANY, IN, and SOME
increasing
  performance, Replication FAQ
increasing with replication
  speed, Replication
index
  deleting, ALTER TABLE Syntax, DROP INDEX Syntax
index hints, SELECT Syntax, Index Hint 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
  thread state, General Thread States
Init DB
  thread command, Thread Command Values
init-file option
  mysqld, Command Options
INNER JOIN, JOIN Syntax
InnoDB, InnoDB Overview
  NFS, InnoDB Startup Options and System Variables, Restrictions on InnoDB Tables
  Solaris 10 x86_64 issues, Solaris Notes
innodb option
  mysqld, InnoDB Startup Options and System Variables
InnoDB storage engine, Storage Engines, The InnoDB Storage Engine
InnoDB tables, Transactions and Atomic Operations
innodb-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
  thread state, Delayed-Insert Thread States
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, Internal Locking Methods, Concurrent Inserts
installation layouts, Installation Layouts
installation overview, MySQL Installation Using a Source Distribution
installing
  binary distribution, Installing MySQL from tar.gz Packages on Other Unix-Like Systems
  Linux RPM packages, Installing MySQL from RPM Packages on Linux
  Mac OS X PKG packages, Installing MySQL on Mac OS X
  overview, Installing and Upgrading MySQL
  Perl, Perl Installation Notes
  Perl on Windows, Installing ActiveState Perl on Windows
  Solaris PKG packages, Installing MySQL on Solaris
  source distribution, MySQL Installation Using a Source Distribution
  user-defined functions, Compiling and Installing User-Defined Functions
installing MySQL Cluster, Simple Multi-Computer How-To, Multi-Computer Installation, Installing the Cluster 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, Internal Locking Methods
internals, MySQL Internals
internationalization, Internationalization and Localization
Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC)
Intersection(), Spatial Operators
Intersects(), Functions That Test Spatial Relationships Between Geometries
INTERVAL(), Comparison Functions and Operators
introducer
  string literal, Strings, Character String Literal Character Set and Collation
invalid data
  constraint, Constraints on Invalid Data
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, The ISAM Storage Engine
isamchk, Overview of MySQL Programs
isamlog, Overview of MySQL 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

### J

[index top]

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

### K

[index top]

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
  thread command, Thread Command Values
KILL, KILL Syntax
Killed
  thread state, General Thread States
Killing slave
  thread state, Replication Slave Connection Thread States
known errors, Known Issues in MySQL

### L

[index top]

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([<replaceable>expr</replaceable>]), 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, Environment Variables, Problems Using the Perl DBI/DBD Interface
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
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, LOAD DATA INFILE Syntax
LineFromText(), Creating Geometry Values Using WKT Functions
LineFromWKB(), Creating Geometry Values Using WKB Functions
lines-terminated-by option
  mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
LINESTRING data type, MySQL Spatial Data Types
LineString(), Creating Geometry Values Using MySQL-Specific Functions
LineStringFromText(), Creating Geometry Values Using WKT Functions
LineStringFromWKB(), Creating Geometry Values Using WKB Functions
linking, Building Client Programs
  errors, Problems Linking to the MySQL Client Library
  problems, Problems Linking with the C API
  speed, How Compiling and Linking Affects the Speed of MySQL
links
  symbolic, Using Symbolic Links
Linux
  binary distribution, Linux Binary Distribution Notes
  source distribution, Linux Source Distribution Notes
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
localization, Internationalization and Localization
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 option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
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
Locked
  thread state, General Thread States
locking, System Factors and Startup Parameter Tuning
  external, Command Options, System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
  internal, Internal Locking Methods
  page-level, Internal Locking Methods
  row-level, Transactions and Atomic Operations, Internal Locking Methods
  table-level, Internal Locking Methods
locking methods, Internal 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
logging slow query
  thread state, General Thread States
logical operators, Logical Operators
login
  thread state, General Thread States
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, Defining Data Nodes
LogLevelStartup, Defining Data Nodes
LogLevelStatistic (MySQL Cluster configuration parameter), Defining Data Nodes
Long Data
  thread command, Thread Command Values
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
loops option
  ndb_show_tables, ndb_show_tables — Display List of NDB Tables
lost connection errors, Lost connection to MySQL server
low-priority option
  mysqlimport, mysqlimport — A Data Import Program
low-priority-updates option
  mysqld, Command Options
LOWER(), String Functions
LPAD(), String Functions
LTRIM(), String Functions

### M

[index top]

Mac OS X, MySQL Connector/ODBC
  installation, Installing MySQL on Mac OS X
mailing list address, General Information
mailing lists, MySQL Mailing Lists
  archive location, MySQL Mailing Lists
  guidelines, Guidelines for Using the Mailing Lists
main features of MySQL, The Main Features of MySQL
maintaining
  log files, Server Log Maintenance
  tables, Setting Up a Table Maintenance Schedule
MAKEDATE(), Date and Time Functions
MAKETIME(), Date and Time Functions
make_binary_distribution, Overview of MySQL Programs
MAKE_SET(), String Functions
make_win_src_distribution, Creating a Windows Source Package from the Latest Development Source, Overview of MySQL Programs
Making temp file
  thread state, Replication Slave SQL Thread States
management node (MySQL Cluster)
  defined, MySQL Cluster Core Concepts
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-binlog-dump-events option
  mysqld, Command Options
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 columns per table, The Maximum Number of Columns Per Table
  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, The MEMORY (HEAP) Storage Engine
memory usage
  myisamchk, myisamchk Memory Usage
memory use, mysqladmin — Client for Administering a MySQL Server, How MySQL Uses Memory
  in MySQL Cluster, Limits and Differences from Standard MySQL Limits
MERGE storage engine, Storage Engines, The MERGE Storage Engine
MERGE tables
  defined, The MERGE Storage Engine
method option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
methods
  locking, Internal Locking Methods
mgmd (MySQL Cluster)
  defined, MySQL Cluster Core 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
  row size, Data Type Storage Requirements
MyISAM key cache, The MyISAM Key Cache
MyISAM storage engine, Storage Engines, The MyISAM Storage Engine
myisam-recover option
  mysqld, Command Options, MyISAM Startup Options
myisamchk, Typical configure Options, Overview of MySQL 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 MySQL Programs
myisampack, Overview of MySQL 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
  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 MySQL 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 MySQL 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
  "quick" configuration, Quick Test Setup of MySQL Cluster
  <foreignphrase>vs</foreignphrase> replication, MySQL Cluster FAQ
  administration, 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 MySQL Cluster 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, MySQL Cluster Core 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, 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 MySQL Cluster Management Client
  compiling from source, Building MySQL Cluster from Source Code
  compiling with icc, Porting to Other Systems
  concepts, MySQL Cluster Core 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, MySQL Cluster Core Concepts, Defining Data Nodes
  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 MySQL Cluster 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 MySQL Cluster Management Client
  EXIT SINGLE USER MODE command, Commands in the MySQL Cluster Management Client
  FAQ, MySQL Cluster FAQ
  general description, MySQL Cluster Overview
  hardware requirements, MySQL Cluster FAQ
  HELP command, Commands in the MySQL Cluster 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 Cluster Software
  interconnects, Using High-Speed Interconnects with MySQL Cluster
  log files, ndbd — The Storage Engine Node Process
  logging commands, Logging Management Commands
  management commands, Using CLUSTERLOG STATISTICS
  management node, MySQL Cluster Core Concepts, Defining the Management Server
  managing, Management of MySQL Cluster
  memory requirements, MySQL Cluster FAQ
  memory usage and recovery, Performing a Rolling Restart of the Cluster, Limits and Differences from Standard MySQL Limits
  mgm, Command Options for MySQL Cluster Processes
  mgm client, Commands in the MySQL Cluster Management Client
  mgm management client, Using CLUSTERLOG STATISTICS
  mgm process, Command Options for ndb_mgm
  mgmd, Command Options for MySQL Cluster Processes
  mgmd 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, 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, MySQL Cluster Core 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
  QUIT command, Commands in the MySQL Cluster 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 MySQL Cluster Management Client
  restarting, Safe Shutdown and Restart
  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 <foreignphrase>vs</foreignphrase> TCP/IP, Understanding the Impact of Cluster Interconnects
  shared memory transport, Shared-Memory Connections
  SHOW command, Commands in the MySQL Cluster Management Client
  SHUTDOWN command, Commands in the MySQL Cluster Management Client
  shutting down, Safe Shutdown and Restart
  single user mode, Commands in the MySQL Cluster Management Client, Single User Mode
  SQL node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes
  SQL nodes, MySQL Server Process Usage for MySQL Cluster
  SQL statements, MySQL Cluster FAQ
  SQL statements for monitoring, Quick Reference: MySQL Cluster SQL Statements
  START command, Commands in the MySQL Cluster Management Client
  start phases (summary), Summary of MySQL Cluster Start Phases
  starting, Quick Test Setup of MySQL Cluster
  starting and stopping, MySQL Cluster FAQ
  starting nodes, Initial Startup
  starting or restarting, Summary of MySQL Cluster Start Phases
  STARTUP Events, Log Events
  STATISTICS Events, Log Events
  STATUS command, Commands in the MySQL Cluster Management Client
  STOP command, Commands in the MySQL Cluster Management Client
  storage requirements, Data Type Storage Requirements
  terminology, MySQL Cluster Glossary
  thread states, MySQL Cluster Thread States
  trace files, ndbd — The Storage Engine Node Process
  transaction handling, Limits Relating to Transaction Handling
  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
MySQL Cluster Glossary, MySQL Cluster Glossary
MySQL Cluster How-To, Simple Multi-Computer How-To
MySQL Cluster limitations, Known Limitations of MySQL Cluster
  and differences from standard MySQL limits, Limits and Differences from Standard MySQL Limits
  binary logging, Issues Exclusive to MySQL Cluster
  database objects, Limits Associated with Database Objects
  error handling and reporting, Error Handling
  geometry data types, Non-Compliance In SQL Syntax
  implementation, Issues Exclusive to MySQL Cluster
  imposed by configuration, Limits and Differences from Standard MySQL Limits
  memory usage and transaction handling, Limits Relating to Transaction Handling
  multiple management servers, Limitations Relating to Multiple Cluster Nodes
  multiple MySQL servers, Limitations Relating to Multiple Cluster Nodes
  performance, Limitations Relating to Performance
  replication, Non-Compliance In SQL Syntax
  syntax, Non-Compliance In SQL Syntax
  transactions, Limits Relating to Transaction Handling
  unsupported features, Unsupported Or Missing Features
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 server
  mysqld, The MySQL Server
mysql source (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File
MySQL source distribution, Choosing Which MySQL Distribution to Install
mysql status command, mysql Commands
MySQL storage engines, Storage Engines
MySQL version, How to Get MySQL
mysql \. (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File
MySQL++, MySQL C++ API
mysql.server, Overview of MySQL Programs
  basedir option, mysql.server — MySQL Server Startup Script
  datadir option, mysql.server — MySQL Server Startup Script
  pid-file option, mysql.server — MySQL Server Startup Script
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 MySQL 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 MySQL 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 MySQL 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 MySQL 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 MySQL Programs
  abort-slave-event-count option, Command Options
  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
  disconnect-slave-event-count option, Command Options
  enable-named-pipe option, Command Options
  enable-pstack option, Command Options
  exit-info option, Command Options
  external-locking option, Command Options
  flush option, Command Options
  gdb 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-binlog-dump-events option, Command Options
  max-relay-log-size option, Replication Startup Options
  memlock option, Command Options
  myisam-recover option, Command Options, MyISAM Startup Options
  MySQL server, The MySQL Server
  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-password option, Replication Startup Options
  report-port option, Replication Startup Options
  report-user option, Replication Startup Options
  role in MySQL Cluster, MySQL Cluster Core 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
  show-slave-auth-info option, Replication Startup 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
  sporadic-binlog-dump-fail 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 MySQL 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 MySQL 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 MySQL 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 MySQL 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
  skip-kill-mysqld 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 MySQL 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 MySQL 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 MySQL 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_convert_table_format, Overview of MySQL Programs
mysql_create_db(), mysql_create_db()
mysql_create_system_tables, Overview of MySQL Programs
mysql_data_seek(), mysql_data_seek()
MYSQL_DEBUG environment variable, Environment Variables, Debugging a MySQL Client, Overview of MySQL Programs
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 MySQL 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_find_rows, Overview of MySQL Programs
  help option, mysql_find_rows — Extract SQL Statements from Files
  regexp option, mysql_find_rows — Extract SQL Statements from Files
  rows option, mysql_find_rows — Extract SQL Statements from Files
  skip-use-db option, mysql_find_rows — Extract SQL Statements from Files
  start_row option, mysql_find_rows — Extract SQL Statements from Files
mysql_fix_extensions, Overview of MySQL Programs
mysql_fix_privilege_tables, Overview of MySQL 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, Environment Variables, mysql Options
MYSQL_HOME environment variable, Environment Variables
MYSQL_HOST environment variable, Environment Variables, Connecting to the MySQL Server
mysql_info(), ALTER TABLE Syntax, INSERT Syntax, LOAD DATA INFILE Syntax, UPDATE Syntax, mysql_info()
mysql_init(), mysql_init()
mysql_insert_id(), Transactions and Atomic Operations, INSERT Syntax, mysql_insert_id()
mysql_install_db, Overview of MySQL 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, Environment Variables, Overview of MySQL Programs, Connecting to the MySQL Server
mysql_query(), mysql_query(), Common Questions and Problems When Using the C API
mysql_real_connect(), mysql_real_connect()
mysql_real_escape_string(), Strings, mysql_real_escape_string()
mysql_real_query(), mysql_real_query()
mysql_refresh(), mysql_refresh()
mysql_reload(), mysql_reload()
MYSQL_RES C type, C API Data Types
mysql_rollback(), mysql_rollback()
MYSQL_ROW C type, C API Data Types
mysql_row_seek(), mysql_row_seek()
mysql_row_tell(), mysql_row_tell()
mysql_secure_installation, Overview of MySQL Programs
mysql_select_db(), mysql_select_db()
mysql_server_end(), mysql_server_end()
mysql_server_init(), mysql_server_init()
mysql_setpermission, Overview of MySQL Programs
  help option, mysql_setpermission — Interactively Set Permissions in Grant Tables
  host option, mysql_setpermission — Interactively Set Permissions in Grant Tables
  password option, mysql_setpermission — Interactively Set Permissions in Grant Tables
  port option, mysql_setpermission — Interactively Set Permissions in Grant Tables
  socket option, mysql_setpermission — Interactively Set Permissions in Grant Tables
  user option, mysql_setpermission — Interactively Set Permissions in Grant Tables
mysql_set_character_set(), mysql_set_character_set()
mysql_set_local_infile_default(), mysql_set_local_infile_default()
mysql_set_server_option(), mysql_set_server_option()
mysql_shutdown(), mysql_shutdown()
mysql_sqlstate(), mysql_sqlstate()
mysql_ssl_set(), mysql_ssl_set()
mysql_stat(), mysql_stat()
MYSQL_STMT C type, C API Prepared Statement Data types
mysql_stmt_affected_rows(), mysql_stmt_affected_rows()
mysql_stmt_attr_get(), mysql_stmt_attr_get()
mysql_stmt_attr_set(), mysql_stmt_attr_set()
mysql_stmt_bind_param(), mysql_stmt_bind_param()
mysql_stmt_bind_result(), mysql_stmt_bind_result()
mysql_stmt_close(), mysql_stmt_close()
mysql_stmt_data_seek(), mysql_stmt_data_seek()
mysql_stmt_errno(), mysql_stmt_errno()
mysql_stmt_error(), mysql_stmt_error()
mysql_stmt_execute(), mysql_stmt_execute()
mysql_stmt_fetch(), mysql_stmt_fetch()
mysql_stmt_fetch_column(), mysql_stmt_fetch_column()
mysql_stmt_field_count(), mysql_stmt_field_count()
mysql_stmt_free_result(), mysql_stmt_free_result()
mysql_stmt_init(), mysql_stmt_init()
mysql_stmt_insert_id(), mysql_stmt_insert_id()
mysql_stmt_num_rows(), mysql_stmt_num_rows()
mysql_stmt_param_count(), mysql_stmt_param_count()
mysql_stmt_param_metadata(), mysql_stmt_param_metadata()
mysql_stmt_prepare(), mysql_stmt_prepare()
mysql_stmt_reset(), mysql_stmt_reset()
mysql_stmt_result_metadata, mysql_stmt_result_metadata()
mysql_stmt_row_seek(), mysql_stmt_row_seek()
mysql_stmt_row_tell(), mysql_stmt_row_tell()
mysql_stmt_send_long_data(), mysql_stmt_send_long_data()
mysql_stmt_sqlstate(), mysql_stmt_sqlstate()
mysql_stmt_store_result(), mysql_stmt_store_result()
mysql_store_result(), mysql_store_result(), Common Questions and Problems When Using the C API
mysql_tableinfo, Overview of MySQL Programs
  clear option, mysql_tableinfo — Generate Database Metadata
  clear-only option, mysql_tableinfo — Generate Database Metadata
  col option, mysql_tableinfo — Generate Database Metadata
  help option, mysql_tableinfo — Generate Database Metadata
  host option, mysql_tableinfo — Generate Database Metadata
  idx option, mysql_tableinfo — Generate Database Metadata
  password option, mysql_tableinfo — Generate Database Metadata
  port option, mysql_tableinfo — Generate Database Metadata
  prefix option, mysql_tableinfo — Generate Database Metadata
  quiet option, mysql_tableinfo — Generate Database Metadata
  socket option, mysql_tableinfo — Generate Database Metadata
  tbl-status option, mysql_tableinfo — Generate Database Metadata
  user option, mysql_tableinfo — Generate Database Metadata
MYSQL_TCP_PORT environment variable, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
mysql_thread_end(), mysql_thread_end()
mysql_thread_id(), mysql_thread_id()
mysql_thread_init(), mysql_thread_init()
mysql_thread_safe(), mysql_thread_safe()
MYSQL_TIME C type, C API Prepared Statement Data types
mysql_tzinfo_to_sql, Overview of MySQL Programs
MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
mysql_use_result(), mysql_use_result()
mysql_waitpid, Overview of MySQL Programs
  help option, mysql_waitpid — Kill Process and Wait for Its Termination
  verbose option, mysql_waitpid — Kill Process and Wait for Its Termination
  version option, mysql_waitpid — Kill Process and Wait for Its Termination
mysql_warning_count(), mysql_warning_count()
mysql_zap, Overview of MySQL Programs
my_bool C type, C API Data Types
my_bool values
  printing, C API Data Types
my_init(), my_init()
my_print_defaults, Overview of MySQL Programs
  config-file option, my_print_defaults — Display Options from Option Files
  debug option, my_print_defaults — Display Options from Option Files
  defaults-extra-file option, my_print_defaults — Display Options from Option Files
  defaults-file option, my_print_defaults — Display Options from Option Files
  defaults-group-suffix option, my_print_defaults — Display Options from Option Files
  extra-file option, my_print_defaults — Display Options from Option Files
  help option, my_print_defaults — Display Options from Option Files
  no-defaults option, my_print_defaults — Display Options from Option Files
  verbose option, my_print_defaults — Display Options from Option Files
  version option, my_print_defaults — Display Options from Option Files
my_ulonglong C type, C API Data Types
my_ulonglong values
  printing, C API Data Types

### N

[index top]

named pipes, Selecting a MySQL Server Type, Testing The MySQL Installation
named-commands option
  mysql, mysql Options
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
NATIONAL VARCHAR data type, Overview of String Types
native backup and restore
  and management client, Using The Management Client to Create a Backup
  backup identifiers, Using The Management Client to Create a Backup
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
  ndb_config, ndb_config — Extract NDB Configuration Information
ndbcluster option
  mysqld, Command Options
ndbd (MySQL Cluster)
  defined, MySQL Cluster Core Concepts
ndb_config, Cluster Utility Programs
  config-file option, ndb_config — Extract NDB Configuration Information
  fields option, ndb_config — Extract NDB Configuration Information
  host option, ndb_config — Extract NDB Configuration Information
  id option, ndb_config — Extract NDB Configuration Information
  ndb-connectstring option, ndb_config — Extract NDB Configuration Information
  nodeid option, ndb_config — Extract NDB Configuration Information
  nodes option, ndb_config — Extract NDB Configuration Information
  query option, ndb_config — Extract NDB Configuration Information
  rows option, ndb_config — Extract NDB Configuration Information
  type option, ndb_config — Extract NDB Configuration Information
  usage option, ndb_config — Extract NDB Configuration Information
  version option, ndb_config — Extract NDB Configuration Information
ndb_cpcd, Cluster Utility Programs
ndb_delete_all, Cluster Utility Programs
  transactional option, ndb_delete_all — Delete All Rows from NDB Table
ndb_desc, Cluster Utility Programs
  extra-partition-info option, ndb_desc — Describe NDB Tables
ndb_drop_index, Cluster Utility Programs
ndb_drop_table, Cluster Utility Programs
ndb_error_reporter, Cluster Utility Programs
ndb_mgm (MySQL Cluster management node client), Initial Startup
ndb_mgmd (MySQL Cluster)
  defined, MySQL Cluster Core Concepts
ndb_print_backup_file, Cluster Utility Programs
ndb_print_schema_file, Cluster Utility Programs
ndb_print_sys_file, Cluster Utility Programs
ndb_restore
  errors, ndb_restore — Restore a Cluster Backup
ndb_select_all, Cluster Utility Programs
  delimiter option, ndb_select_all — Print Rows from NDB Table
  descending option, ndb_select_all — Print Rows from NDB Table
  gci option, ndb_select_all — Print Rows from NDB Table
  header option, ndb_select_all — Print Rows from NDB Table
  lock option, ndb_select_all — Print Rows from NDB Table
  nodata option, ndb_select_all — Print Rows from NDB Table
  order option, ndb_select_all — Print Rows from NDB Table
  rowid option, ndb_select_all — Print Rows from NDB Table
  tupscan option, ndb_select_all — Print Rows from NDB Table
  useHexFormat option, ndb_select_all — Print Rows from NDB Table
ndb_select_count, Cluster Utility Programs
ndb_show_tables, Cluster Utility Programs
  loops option, ndb_show_tables — Display List of NDB Tables
  parsable option, ndb_show_tables — Display List of NDB Tables
  type option, ndb_show_tables — Display List of NDB Tables
  unqualified option, ndb_show_tables — Display List of NDB Tables
ndb_size.pl, Cluster Utility Programs
ndb_size.pl (utility), MySQL Cluster FAQ
ndb_waiter, Cluster Utility Programs
  no-contact option, ndb_waiter — Wait for Cluster to Reach a Given Status
  not-started option, ndb_waiter — Wait for Cluster to Reach a Given Status
  timeout option, ndb_waiter — Wait for Cluster to Reach a Given Status
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 from tar.gz Packages on Other Unix-Like Systems, Source Installation Overview
newline (\n), Strings, LOAD DATA INFILE Syntax
next-key lock, InnoDB Startup Options and System Variables, InnoDB and TRANSACTION ISOLATION LEVEL, Next-Key Locking: Avoiding the Phantom Problem
NFS
  InnoDB, InnoDB Startup Options and System Variables, Restrictions on InnoDB Tables
nice option
  mysqld_safe, mysqld_safe — MySQL Server Startup Script
no matching rows, Solving Problems with No Matching Rows
no-auto-rehash option
  mysql, mysql Options
no-autocommit option
  mysqldump, mysqldump — A Database Backup Program
no-beep option
  mysql, mysql Options
no-contact option
  ndb_waiter, ndb_waiter — Wait for Cluster to Reach a Given Status
no-create-db option
  mysqldump, mysqldump — A Database Backup Program
no-create-info option
  mysqldump, mysqldump — A Database Backup Program
no-data option
  mysqldump, mysqldump — A Database Backup Program
no-defaults option, Command-Line Options that Affect Option-File Handling
  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
nodata option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
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
nodeid option
  ndb_config, ndb_config — Extract NDB Configuration Information
NODERESTART Events (MySQL Cluster), Log Events
nodes option
  ndb_config, ndb_config — Extract NDB Configuration Information
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, Defining Data Nodes
  calculating, Configuring Parameters for Local Checkpoints
NoOfDiskPagesToDiskAfterRestartTUP, Defining Data Nodes
  calculating, Configuring Parameters for Local Checkpoints
NoOfDiskPagesToDiskDuringRestartACC, Defining Data Nodes
NoOfDiskPagesToDiskDuringRestartTUP, 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 EXISTS
  with subqueries, EXISTS and NOT EXISTS
NOT IN, Comparison Functions and Operators
NOT LIKE, String Comparison Functions
NOT NULL
  constraint, Constraints on Invalid Data
NOT REGEXP, String Comparison Functions
not-started option
  ndb_waiter, ndb_waiter — Wait for Cluster to Reach a Given Status
Novell NetWare, Installing MySQL on NetWare
NOW(), Date and Time Functions
NOWAIT (START BACKUP command), Using The Management Client to Create a Backup
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, LOAD DATA INFILE Syntax
NULL, Working with NULL Values, Problems with NULL Values
  ORDER BY, ORDER BY Optimization, SELECT Syntax
  testing for null, Comparison Functions and Operators, Control Flow Functions
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
numeric-dump-file option
  resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
NumGeometries(), GeometryCollection Functions
NumInteriorRings(), Polygon Functions
NumPoints(), LineString Functions
NVARCHAR data type, Overview of String Types

### O

[index top]

Obtaining MySQL Cluster, Multi-Computer Installation
OCT(), Mathematical Functions
OCTET_LENGTH(), String Functions
ODBC, MySQL Connector/ODBC
ODBC compatibility, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
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, mysqladmin — Client for Administering a MySQL Server, How MySQL Opens and Closes Tables
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
Opening master dump table
  thread state, Replication Slave Connection Thread States
Opening mysql.ndb_apply_status
  thread state, MySQL Cluster Thread States
Opening table
  thread state, General Thread States
Opening tables
  thread state, General Thread States
opens, mysqladmin — Client for Administering a MySQL Server
OpenSSL, Using 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
  assignment, Comment Syntax
  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
option modifiers, Program Option Modifiers
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 option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
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

[index top]

packages
  list of, Packages that support MySQL
pack_isam, Overview of MySQL Programs
page-level locking, Internal Locking Methods
pager option
  mysql, mysql Options
parallel-recover option
  myisamchk, myisamchk Repair Options
parameters
  server, Tuning Server Parameters
parentheses ( and ), Operator Precedence
parsable option
  ndb_show_tables, ndb_show_tables — Display List of NDB Tables
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
  mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
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 from tar.gz Packages on Other Unix-Like Systems, Environment Variables, Invoking MySQL Programs
pattern matching, Pattern Matching, Regular Expressions
performance
  benchmarks, Using Your Own Benchmarks
  disk issues, Disk Issues
  estimating, Estimating Query Performance
  improving, 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 MySQL 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
  mysql.server, mysql.server — MySQL Server Startup Script
  mysqld, Command Options
  mysqld_safe, mysqld_safe — MySQL Server Startup Script
Ping
  thread command, Thread Command Values
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
  mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
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
prefix option
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
Prepare
  thread command, Thread Command Values
PREPARE, SQL Syntax for Prepared Statements
preparing
  thread state, General Thread States
preview option
  mysqlaccess, mysqlaccess — Client for Checking Access Privileges
previx option
  configure, Typical configure Options
primary key
  constraint, PRIMARY KEY and UNIQUE Index Constraints
  deleting, ALTER TABLE Syntax
PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax
print-defaults option, Command-Line Options that Affect Option-File Handling
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
  lost connection errors, Lost connection to MySQL server
  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
Processing events
  thread state, MySQL Cluster Thread States
Processing events from schema table
  thread state, MySQL Cluster Thread States
Processlist
  thread command, Thread Command Values
PROCESSLIST, SHOW PROCESSLIST Syntax
program variables
  setting, Using Options to Set Program Variables
program-development utilities, Overview of MySQL Programs
programs
  administrative, Overview of MySQL Programs
  client, Overview of MySQL Programs, Building Client Programs
  crash-me, Designing Applications for Portability
  utility, Overview of MySQL 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, Summary of MySQL Cluster Start Phases
Purging old relay logs
  thread state, General Thread States
Python API, MySQL Python API

### Q

[index top]

QUARTER(), Date and Time Functions
queries
  entering, Entering Queries
  estimating performance, Estimating Query Performance
  examples, Examples of Common Queries
  speed of, Optimizing SELECT and Other Statements
  Twin Studies project, Queries from the Twin Project
Query
  thread command, Thread Command Values
Query Cache, The MySQL Query Cache
query end
  thread state, General Thread States
query option
  ndb_config, ndb_config — Extract NDB Configuration Information
questions, mysqladmin — Client for Administering a MySQL Server
  answering, Guidelines for Using the Mailing Lists
Queueing master event to the relay log
  thread state, Replication Slave I/O Thread States
quick option
  myisamchk, myisamchk Repair Options
  mysql, mysql Options
  mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
  mysqldump, mysqldump — A Database Backup Program
quiet option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
Quit
  thread command, Thread Command Values
QUIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client
QUOTE(), String Functions
quote-names option
  mysqldump, mysqldump — A Database Backup Program
quotes
  in strings, Strings
quoting, Strings
quoting binary data, Strings
quoting of identifiers, Database, Table, Index, Column, and Alias Names

### R

[index top]

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
Reading event from the relay log
  thread state, Replication Slave SQL Thread States
Reading from net
  thread state, General Thread States
Reading master dump table data
  thread state, Replication Slave Connection Thread States
read_buffer_size myisamchk variable, myisamchk General Options
REAL data type, Overview of Numeric Types
REAL_AS_FLOAT SQL mode, SQL Modes
Rebuilding the index on master dump table
  thread state, Replication Slave Connection Thread States
ReceiveBufferMemory, Cluster TCP/IP Connections
reconfiguring, Dealing with Problems Compiling MySQL
reconnect option
  mysql, mysql Options
Reconnecting after a failed binlog dump request
  thread state, Replication Slave I/O Thread States
Reconnecting after a failed master event read
  thread state, Replication Slave I/O Thread States
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
Refresh
  thread command, Thread Command Values
ref_or_null, IS NULL Optimization
REGEXP, String Comparison Functions
REGEXP operator, Regular Expressions
regexp option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
  mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
Register Slave
  thread command, Thread Command Values
Registering slave on master
  thread state, Replication Slave I/O Thread States
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
Removing duplicates
  thread state, General Thread States
removing tmp table
  thread state, General Thread States
rename
  thread state, General Thread States
rename result table
  thread state, General Thread States
RENAME TABLE, RENAME TABLE Syntax
Reopen tables
  thread state, General Thread States
reordering
  columns, How to Change the Order of Columns in a Table
Repair by sorting
  thread state, General Thread States
Repair done
  thread state, General Thread States
repair option
  mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
repair options
  myisamchk, myisamchk Repair Options
REPAIR TABLE, REPAIR TABLE Syntax
Repair with keycache
  thread state, General Thread States
repairing
  tables, How to Repair Tables
REPEAT(), String Functions
replace, Overview of MySQL 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 master
  thread states, Replication Master Thread States
replication masters
  statements, SQL Statements for Controlling Master Servers
replication options, Replication Features and Known Problems
replication slave
  thread states, Replication Slave I/O Thread States, Replication Slave SQL Thread States, Replication Slave Connection Thread States
replication slaves
  statements, SQL Statements for Controlling Slave Servers
report-host option
  mysqld, Replication Startup Options
report-password option
  mysqld, Replication Startup Options
report-port option
  mysqld, Replication Startup Options
report-user 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
Requesting binlog dump
  thread state, Replication Slave I/O Thread States
REQUIRE GRANT option, GRANT Syntax
reschedule
  thread state, Delayed-Insert Thread States
reserved words, Reserved Words
RESET MASTER, RESET MASTER Syntax
RESET SLAVE, RESET SLAVE Syntax
Reset stmt
  thread command, Thread Command Values
resetmaster option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
resetslave option
  mysqlhotcopy, mysqlhotcopy — A Database Backup Program
resolveip, Overview of MySQL Programs
  help option, resolveip — Resolve Hostname to IP Address or Vice Versa
  silent option, resolveip — Resolve Hostname to IP Address or Vice Versa
  version option, resolveip — Resolve Hostname to IP Address or Vice Versa
resolve_stack_dump, Overview of MySQL Programs
  help option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
  numeric-dump-file option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
  symbols-file option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
  version option, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
RESTART command (MySQL Cluster), Commands in the MySQL Cluster Management Client
restarting
  the server, Unix Post-Installation Procedures
RestartOnErrorInsert, Defining Data Nodes
RESTORE TABLE, RESTORE TABLE Syntax
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, LOAD DATA INFILE Syntax
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 back
  thread state, General Thread States
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, Row Subqueries
row subqueries, Row Subqueries
row-level locking, Internal Locking Methods
rowid option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
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
rows option
  mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
  ndb_config, ndb_config — Extract NDB Configuration Information
RPAD(), String Functions
RPM file, Installing MySQL from RPM Packages on Linux
RPM Package Manager, Installing MySQL from RPM Packages 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

[index top]

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
Saving state
  thread state, General Thread States
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
Searching rows for update
  thread state, General Thread States
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
Sending binlog event to slave
  thread state, Replication Master Thread States
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
SERIAL, Overview of Numeric Types
SERIAL DEFAULT VALUE, Data Type Default Values
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
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
  thread command, Thread Command Values
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
  thread state, General Thread States
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 MySQL Cluster 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
  used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
SHOW ENGINE BDB LOGS, SHOW ENGINE Syntax
SHOW ENGINE INNODB STATUS, SHOW ENGINE Syntax
SHOW ENGINE NDB STATUS, SHOW ENGINE Syntax, Quick Reference: MySQL Cluster SQL Statements
SHOW ENGINE NDBCLUSTER STATUS, SHOW ENGINE Syntax, Quick Reference: MySQL Cluster SQL Statements
SHOW ENGINES, SHOW Syntax, SHOW ENGINES Syntax
  used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
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
  used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
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
  used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
SHOW WARNINGS, SHOW Syntax, SHOW WARNINGS Syntax
show-slave-auth-info option
  mysqld, Replication Startup Options
Shutdown
  thread command, Thread Command Values
SHUTDOWN command (MySQL Cluster), Commands in the MySQL Cluster Management Client
shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
shutting down
  the server, Unix Post-Installation Procedures
Shutting down
  thread state, MySQL Cluster Thread States
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
  resolveip, resolveip — Resolve Hostname to IP Address or Vice Versa
SIN(), Mathematical Functions
single quote (\'), Strings
single user mode (MySQL Cluster), Commands in the MySQL Cluster Management Client, Single User Mode
  and ndb_restore, ndb_restore — 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-kill-mysqld option
  mysqld_safe, mysqld_safe — MySQL Server Startup Script
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
skip-use-db option
  mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
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
  thread command, Thread Command Values
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
  mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
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
SOME, Subqueries with ANY, IN, and SOME
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
Sorting for group
  thread state, General Thread States
Sorting for order
  thread state, General Thread States
Sorting index
  thread state, General Thread States
Sorting result
  thread state, General Thread States
sort_buffer_size myisamchk variable, myisamchk General Options
sort_key_blocks myisamchk variable, myisamchk General Options
SOUNDEX(), String Functions
SOUNDS LIKE, String Functions
source (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
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
sporadic-binlog-dump-fail option
  mysqld, Command Options
SQL
  defined, What is MySQL?
SQL mode
  ONLY_FULL_GROUP_BY, GROUP BY and HAVING with Hidden Fields
SQL node (MySQL Cluster)
  defined, MySQL Cluster Core 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 statements relating to MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
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, Using The Management Client to Create a Backup
  NOWAIT, Using The Management Client to Create a Backup
  WAIT COMPLETED, Using The Management Client to Create a Backup
  WAIT STARTED, Using The Management Client to Create a Backup
START command (MySQL Cluster), Commands in the MySQL Cluster 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
starting slave
  thread state, Replication Slave Connection Thread States
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
start_row option
  mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
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
  thread command, Thread Command Values
statistics
  thread state, General Thread States
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 MySQL Cluster 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 MySQL Cluster 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
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
storing row into queue
  thread state, Delayed-Insert Thread States
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
  correlated, Correlated Subqueries
  errors, Subquery Errors
  rewriting as joins, Rewriting Subqueries as Joins for Earlier MySQL Versions
  with ALL, Subqueries with ALL
  with ANY, IN, SOME, Subqueries with ANY, IN, and SOME
  with EXISTS, EXISTS and NOT EXISTS
  with NOT EXISTS, EXISTS and NOT EXISTS
  with ROW, Row Subqueries
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
symbols-file option
  resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
SymDifference(), Spatial Operators
sync-bdb-logs option
  mysqld, BDB Startup Options
Syncing ndb table schema operation and binlog
  thread state, MySQL Cluster Thread States
syntax
  regular expression, Regular Expressions
SYSDATE(), Date and Time Functions
system
  privilege, What the Privilege System Does
  security, General Security Issues
System lock
  thread state, General Thread States
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

[index top]

tab (\t), Strings, LOAD DATA INFILE Syntax
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 Dump
  thread command, Thread Command Values
table is full, SET Syntax, The table is full
Table lock
  thread state, General Thread States
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
table-level locking, Internal 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
tbl-status option
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
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
  internal, How MySQL Uses Internal 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
text files
  importing, Executing SQL Statements from a Text File
thread command
  Binlog Dump, Thread Command Values
  Change user, Thread Command Values
  Close stmt, Thread Command Values
  Connect, Thread Command Values
  Connect Out, Thread Command Values
  Create DB, Thread Command Values
  Daemon, Thread Command Values
  Debug, Thread Command Values
  Delayed insert, Thread Command Values
  Drop DB, Thread Command Values
  Error, Thread Command Values
  Execute, Thread Command Values
  Fetch, Thread Command Values
  Field List, Thread Command Values
  Init DB, Thread Command Values
  Kill, Thread Command Values
  Long Data, Thread Command Values
  Ping, Thread Command Values
  Prepare, Thread Command Values
  Processlist, Thread Command Values
  Query, Thread Command Values
  Quit, Thread Command Values
  Refresh, Thread Command Values
  Register Slave, Thread Command Values
  Reset stmt, Thread Command Values
  Set option, Thread Command Values
  Shutdown, Thread Command Values
  Sleep, Thread Command Values
  Statistics, Thread Command Values
  Table Dump, Thread Command Values
  Time, Thread Command Values
thread commands, Thread Command Values
thread packages
  differences between, Differences Between Thread Packages
thread state
  After create, General Thread States
  allocating local table, Delayed-Insert Thread States
  Analyzing, General Thread States
  Changing master, Replication Slave Connection Thread States
  Checking master version, Replication Slave I/O Thread States
  Checking table, General Thread States
  cleaning up, General Thread States
  closing tables, General Thread States
  Committing events to binlog, MySQL Cluster Thread States
  Connecting to master, Replication Slave I/O Thread States
  converting HEAP to MyISAM, General Thread States
  copy to tmp table, General Thread States
  Copying to group table, General Thread States
  Copying to tmp table, General Thread States
  Copying to tmp table on disk, General Thread States
  Creating delayed handler, Delayed-Insert Thread States
  Creating index, General Thread States
  Creating sort index, General Thread States
  creating table, General Thread States
  Creating table from master dump, Replication Slave Connection Thread States
  Creating tmp table, General Thread States
  deleting from main table, General Thread States
  deleting from reference tables, General Thread States
  discard_or_import_tablespace, General Thread States
  end, General Thread States
  Execution of init_command, General Thread States
  Finished reading one binlog; switching to next binlog, Replication Master Thread States
  Flushing tables, General Thread States
  freeing items, General Thread States
  FULLTEXT initialization, General Thread States
  got handler lock, Delayed-Insert Thread States
  got old table, Delayed-Insert Thread States
  Has read all relay log; waiting for the slave I/O thread to update it, Replication Slave SQL Thread States
  Has sent all binlog to slave; waiting for binlog to be updated, Replication Master Thread States
  init, General Thread States
  insert, Delayed-Insert Thread States
  Killed, General Thread States
  Killing slave, Replication Slave Connection Thread States
  Locked, General Thread States
  logging slow query, General Thread States
  login, General Thread States
  Making temp file, Replication Slave SQL Thread States
  Opening master dump table, Replication Slave Connection Thread States
  Opening mysql.ndb_apply_status, MySQL Cluster Thread States
  Opening table, General Thread States
  Opening tables, General Thread States
  preparing, General Thread States
  Processing events, MySQL Cluster Thread States
  Processing events from schema table, MySQL Cluster Thread States
  Purging old relay logs, General Thread States
  query end, General Thread States
  Queueing master event to the relay log, Replication Slave I/O Thread States
  Reading event from the relay log, Replication Slave SQL Thread States
  Reading from net, General Thread States
  Reading master dump table data, Replication Slave Connection Thread States
  Rebuilding the index on master dump table, Replication Slave Connection Thread States
  Reconnecting after a failed binlog dump request, Replication Slave I/O Thread States
  Reconnecting after a failed master event read, Replication Slave I/O Thread States
  Registering slave on master, Replication Slave I/O Thread States
  Removing duplicates, General Thread States
  removing tmp table, General Thread States
  rename, General Thread States
  rename result table, General Thread States
  Reopen tables, General Thread States
  Repair by sorting, General Thread States
  Repair done, General Thread States
  Repair with keycache, General Thread States
  Requesting binlog dump, Replication Slave I/O Thread States
  reschedule, Delayed-Insert Thread States
  Rolling back, General Thread States
  Saving state, General Thread States
  Searching rows for update, General Thread States
  Sending binlog event to slave, Replication Master Thread States
  setup, General Thread States
  Shutting down, MySQL Cluster Thread States
  Sorting for group, General Thread States
  Sorting for order, General Thread States
  Sorting index, General Thread States
  Sorting result, General Thread States
  starting slave, Replication Slave Connection Thread States
  statistics, General Thread States
  storing row into queue, Delayed-Insert Thread States
  Syncing ndb table schema operation and binlog, MySQL Cluster Thread States
  System lock, General Thread States
  Table lock, General Thread States
  update, Delayed-Insert Thread States
  Updating, General Thread States
  updating main table, General Thread States
  updating reference tables, General Thread States
  upgrading lock, Delayed-Insert Thread States
  User lock, General Thread States
  waiting for delay_list, Delayed-Insert Thread States
  Waiting for event from ndbcluster, MySQL Cluster Thread States
  Waiting for first event from ndbcluster, MySQL Cluster Thread States
  waiting for handler insert, Delayed-Insert Thread States
  waiting for handler lock, Delayed-Insert Thread States
  waiting for handler open, Delayed-Insert Thread States
  Waiting for INSERT, Delayed-Insert Thread States
  Waiting for master to send event, Replication Slave I/O Thread States
  Waiting for master update, Replication Slave I/O Thread States
  Waiting for ndbcluster binlog update to reach current position, MySQL Cluster Thread States
  Waiting for ndbcluster to start, MySQL Cluster Thread States
  Waiting for schema epoch, MySQL Cluster Thread States
  Waiting for slave mutex on exit, Replication Slave I/O Thread States, Replication Slave SQL Thread States
  Waiting for table, General Thread States
  Waiting for tables, General Thread States
  Waiting for the next event in relay log, Replication Slave SQL Thread States
  Waiting for the slave SQL thread to free enough relay log space, Replication Slave I/O Thread States
  Waiting on cond, General Thread States
  Waiting to finalize termination, Replication Master Thread States
  Waiting to reconnect after a failed binlog dump request, Replication Slave I/O Thread States
  Waiting to reconnect after a failed master event read, Replication Slave I/O Thread States
  Writing to net, General Thread States
thread states
  delayed inserts, Delayed-Insert Thread States
  general, General Thread States
  MySQL Cluster, MySQL Cluster Thread States
  replication master, Replication Master Thread States
  replication slave, Replication Slave I/O Thread States, Replication Slave SQL Thread States, Replication Slave Connection Thread States
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
  thread command, Thread Command Values
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
timeout option
  ndb_waiter, ndb_waiter — Wait for Cluster to Reach a Given Status
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
transactional option
  ndb_delete_all, ndb_delete_all — Delete All Rows from NDB Table
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, Limits and Differences from Standard MySQL Limits
TRUNCATE(), Mathematical Functions
tupscan option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
tutorial, Tutorial
Twin Studies
  queries, Queries from the Twin Project
type conversions, Type Conversion in Expression Evaluation, Comparison Functions and Operators
type option
  ndb_config, ndb_config — Extract NDB Configuration Information
  ndb_show_tables, ndb_show_tables — Display List of NDB Tables
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
  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, Environment Variables, Time Zone Problems

### U

[index top]

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, Environment Variables, Problems with File Permissions
UMASK_DIR environment variable, Environment Variables, Problems with File Permissions
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
unique ID, How to Get the Unique ID for the Last Inserted Row
unique key
  constraint, PRIMARY KEY and UNIQUE Index Constraints
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
unqualified option
  ndb_show_tables, ndb_show_tables — Display List of NDB Tables
update
  thread state, Delayed-Insert Thread States
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
Updating
  thread state, General Thread States
updating main table
  thread state, General Thread States
updating reference tables
  thread state, General Thread States
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
upgrading lock
  thread state, Delayed-Insert Thread States
UPPER(), String Functions
uptime, mysqladmin — Client for Administering a MySQL Server
URLs for downloading MySQL, How to Get MySQL
usage option
  ndb_config, ndb_config — Extract NDB Configuration Information
USE, USE Syntax
USE INDEX, Index Hint Syntax
USE KEY, Index Hint Syntax
use-frm option
  mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
useHexFormat option
  ndb_select_all, ndb_select_all — Print Rows from NDB Table
USER environment variable, Environment Variables, Connecting to the MySQL Server
User lock
  thread state, General Thread States
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
  mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
  mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
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 from tar.gz Packages 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
utilities
  program-development, Overview of MySQL Programs
utility programs, Overview of MySQL Programs
UUID(), Miscellaneous Functions

### V

[index top]

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
  environment, Overview of MySQL Programs
  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
  mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination
  my_print_defaults, my_print_defaults — Display Options from Option Files
  perror, perror — Explain Error Codes
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
  mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination
  my_print_defaults, my_print_defaults — Display Options from Option Files
  ndb_config, ndb_config — Extract NDB Configuration Information
  perror, perror — Explain Error Codes
  resolveip, resolveip — Resolve Hostname to IP Address or Vice Versa
  resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
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

[index top]

WAIT COMPLETED (START BACKUP command), Using The Management Client to Create a Backup
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
WAIT STARTED (START BACKUP command), Using The Management Client to Create a Backup
waiting for delay_list
  thread state, Delayed-Insert Thread States
Waiting for event from ndbcluster
  thread state, MySQL Cluster Thread States
Waiting for first event from ndbcluster
  thread state, MySQL Cluster Thread States
waiting for handler insert
  thread state, Delayed-Insert Thread States
waiting for handler lock
  thread state, Delayed-Insert Thread States
waiting for handler open
  thread state, Delayed-Insert Thread States
Waiting for INSERT
  thread state, Delayed-Insert Thread States
Waiting for master to send event
  thread state, Replication Slave I/O Thread States
Waiting for master update
  thread state, Replication Slave I/O Thread States
Waiting for ndbcluster binlog update to reach current position
  thread state, MySQL Cluster Thread States
Waiting for ndbcluster to start
  thread state, MySQL Cluster Thread States
Waiting for schema epoch
  thread state, MySQL Cluster Thread States
Waiting for slave mutex on exit
  thread state, Replication Slave I/O Thread States, Replication Slave SQL Thread States
Waiting for table
  thread state, General Thread States
Waiting for tables
  thread state, General Thread States
Waiting for the next event in relay log
  thread state, Replication Slave SQL Thread States
Waiting for the slave SQL thread to free enough relay log space
  thread state, Replication Slave I/O Thread States
Waiting on cond
  thread state, General Thread States
Waiting to finalize termination
  thread state, Replication Master Thread States
Waiting to reconnect after a failed binlog dump request
  thread state, Replication Slave I/O Thread States
Waiting to reconnect after a failed master event read
  thread state, Replication Slave I/O Thread States
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
Writing to net
  thread state, General Thread States

### X

[index top]

X(), Point Functions
X509/Certificate, Basic SSL Concepts
xml option
  mysql, mysql Options
  mysqldump, mysqldump — A Database Backup Program
XOR
  bitwise, Bit Functions
  logical, Logical Operators

### Y

[index top]

Y(), Point Functions
Year 2000 compliance, Year 2000 Issues and Date Types
Year 2000 issues, Year 2000 Issues and Date Types
YEAR data type, Overview of Date and Time Types, The YEAR Type
YEAR(), Date and Time Functions
YEARWEEK(), Date and Time Functions

Prev |  |
Appendix D. Credits | Home |