Standard Index

SYMBOLS

= (assignment), Section 8.4, “User-Defined Variables”
! (logical NOT), Section 11.2.4, “Logical Operators”
!= (not equal), Section 11.2.3, “Comparison Functions and Operators”
", Section 8.2, “Schema Object Names”
#mysql50 identifier prefix, Section 8.2, “Schema Object Names”, Section 8.2.3, “Mapping of Identifiers to File Names”
%, Section 11.5.1, “Arithmetic Operators”
% (modulo), Section 11.5.2, “Mathematical Functions”
% (wildcard character), Section 8.1.1, “Strings”
& (bitwise AND), Section 11.11.1, “Bit Functions”
&& (logical AND), Section 11.2.4, “Logical Operators”
() (parentheses), Section 11.2.1, “Operator Precedence”
(Control-Z) \Z, Section 8.1.1, “Strings”
* (multiplication), Section 11.5.1, “Arithmetic Operators”
+ (addition), Section 11.5.1, “Arithmetic Operators”
- (subtraction), Section 11.5.1, “Arithmetic Operators”
- (unary minus), Section 11.5.1, “Arithmetic Operators”
--bind-address option (ndb_mgmd), Description
--character-sets-dir option
MySQL Cluster programs, Section 17.6.23, “Options Common to MySQL Cluster Programs”
--config-file option (ndb_mgmd), Description
--configdir option (ndb_mgmd), Description
--connect-string option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--core-file option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--daemon option (ndb_mgmd), Description
--debug option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--execute option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--help option
MySQL Cluster programs, Section 17.6.23, “Options Common to MySQL Cluster Programs”
--initial option (ndb_mgmd), Description
--initial option (ndbd), Description
--initial option (ndbmtd), Description
--initial-start option (ndbd), Description
--initial-start option (ndbmtd), Description
--ndb-mgmd-host option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--ndb-nodeid option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--ndb-optimized-node-selection option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
--nodaemon option (ndb_mgmd), Description
--nodaemon option (ndbd), Description
--nodaemon option (ndbmtd), Description
--nostart option (ndbd), Description
--nostart option (ndbmtd), Description
--nowait-nodes option (ndbd), Description
--nowait-nodes option (ndbmtd), Description
--password option, Section 5.5.6.2, “End-User Guidelines for Password Security”
--print-full-config option (ndb_mgmd), Description
--reload option (ndb_mgmd), Description
--usage option
MySQL Cluster programs, Section 17.6.23, “Options Common to MySQL Cluster Programs”
--version option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
-? option
MySQL Cluster programs, Section 17.6.23, “Options Common to MySQL Cluster Programs”
-P option (ndb_mgmd), Description
-V option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
-c option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
-c option (ndb_mgmd) (OBSOLETE), Description
-d option (ndb_mgmd), Description
-e option (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
-f option (ndb_mgmd), Description
-n option (ndbd), Description
-n option (ndbmtd), Description
-p option, Section 5.5.6.2, “End-User Guidelines for Password Security”
.my.cnf file, Section 5.5.6.2, “End-User Guidelines for Password Security”, Section 4.2.2, “Connecting to the MySQL Server”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 4.2.3.3, “Using Option Files”
.mysql_history file, Section 5.5.6.2, “End-User Guidelines for Password Security”, Section 4.5.1.1, “mysql Options”
.pid (process ID) file, Section 6.4.6, “Setting Up a Table Maintenance Schedule”
/ (division), Section 11.5.1, “Arithmetic Operators”
/etc/passwd, Section 5.3.2, “Making MySQL Secure Against Attackers”
< (less than), Section 11.2.3, “Comparison Functions and Operators”
<<, Section 3.6.8, “Calculating Visits Per Day”
<< (left shift), Section 11.11.1, “Bit Functions”
<= (less than or equal), Section 11.2.3, “Comparison Functions and Operators”
<=> (equal to), Section 11.2.3, “Comparison Functions and Operators”
<> (not equal), Section 11.2.3, “Comparison Functions and Operators”
<errortext>Table is full</errortext> error
MySQL Cluster, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
= (assignment), Section 8.4, “User-Defined Variables”
= (equal), Section 11.2.3, “Comparison Functions and Operators”
> (greater than), Section 11.2.3, “Comparison Functions and Operators”
>= (greater than or equal), Section 11.2.3, “Comparison Functions and Operators”
>> (right shift), Section 11.11.1, “Bit Functions”
\" (double quote), Section 8.1.1, “Strings”
\' (single quote), Section 8.1.1, “Strings”
\. (mysql client command), Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
\0 (ASCII NUL), Section 8.1.1, “Strings”
\Z (Control-Z) ASCII 26, Section 8.1.1, “Strings”
\\ (escape), Section 8.1.1, “Strings”
\b (backspace), Section 8.1.1, “Strings”
\n (linefeed), Section 8.1.1, “Strings”
\n (newline), Section 8.1.1, “Strings”
\r (carriage return), Section 8.1.1, “Strings”
\t (tab), Section 8.1.1, “Strings”
^ (bitwise XOR), Section 11.11.1, “Bit Functions”
_ (wildcard character), Section 8.1.1, “Strings”
`, Section 8.2, “Schema Object Names”
| (bitwise OR), Section 11.11.1, “Bit Functions”
|| (logical OR), Section 11.2.4, “Logical Operators”
~, Section 11.11.1, “Bit Functions”

A

ABS(), Section 11.5.2, “Mathematical Functions”
ACOS(), Section 11.5.2, “Mathematical Functions”
ADDDATE(), Section 11.6, “Date and Time Functions”
ADDTIME(), Section 11.6, “Date and Time Functions”
AES_DECRYPT(), Section 11.11.2, “Encryption and Compression Functions”
AES_ENCRYPT(), Section 11.11.2, “Encryption and Compression Functions”
ANALYZE TABLE
and partitioning, Section 18.3.3, “Maintenance of Partitions”
AND
bitwise, Section 11.11.1, “Bit Functions”
logical, Section 11.2.4, “Logical Operators”
API node (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
API nodes, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
APIs, Chapter 21, Connectors and APIs
Perl, Section 21.12, “MySQL Perl API”
ARCHIVE storage engine, Chapter 13, Storage Engines, Section 13.12, “The ARCHIVE Storage Engine”
ASCII(), Section 11.4, “String Functions”
ASIN(), Section 11.5.2, “Mathematical Functions”
ATAN(), Section 11.5.2, “Mathematical Functions”
ATAN2(), Section 11.5.2, “Mathematical Functions”
AUTO_INCREMENT, Section 10.2, “Numeric Types”, Section 3.6.9, “Using AUTO_INCREMENT
and replication, Section 16.3.1.1, “Replication and AUTO_INCREMENT
AVG(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
AVG(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
Apache, Section 3.8, “Using MySQL with Apache”
Area(), Section 11.13.5.2.6, “MultiPolygon Functions”, Section 11.13.5.2.5, “Polygon Functions”
AsBinary(), Section 11.13.5.1, “Geometry Format Conversion Functions”
AsText(), Section 11.13.5.1, “Geometry Format Conversion Functions”
account privileges
adding, Section 5.5.2, “Adding User Accounts”
add-drop-database option
mysqldump, Description
add-drop-table option
mysqldump, Description
add-locks option
mysqldump, Description
add-user option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
adding
character sets, Section 9.4, “Adding a New Character Set”
native functions, Section 22.3.3, “Adding a New Native Function”
new account privileges, Section 5.5.2, “Adding User Accounts”
new functions, Section 22.3, “Adding New Functions to MySQL”
new user privileges, Section 5.5.2, “Adding User Accounts”
procedures, Section 22.4, “Adding New Procedures to MySQL”
user-defined functions, Section 22.3.2, “Adding a New User-Defined Function”
addition (+), Section 11.5.1, “Arithmetic Operators”
addtodest option
mysqlhotcopy, Description
administration
server, Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
administration of MySQL Cluster, Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”
age
calculating, Section 3.3.4.5, “Date Calculations”
alias names
case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
aliases
for expressions, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
in GROUP BY clauses, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
names, Section 8.2, “Schema Object Names”
all-databases option
mysqlcheck, Description
mysqldump, Description
all-in-1 option
mysqlcheck, Description
all-tablespaces option
mysqldump, Description
allow-keywords option
mysqldump, Description
allow-suspicious-udfs option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
allowold option
mysqlhotcopy, Description
analyze option
myisamchk, Section 4.6.3.4, “Other myisamchk Options”
mysqlcheck, Description
angel-pid-file option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
arbitrator, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
argument processing, Section 22.3.2.3, “UDF Argument Processing”
arithmetic expressions, Section 11.5.1, “Arithmetic Operators”
arithmetic functions, Section 11.11.1, “Bit Functions”
attackers
security against, Section 5.3.2, “Making MySQL Secure Against Attackers”
attribute promotion
ndb_restore, Description
replication, Section 16.3.1.4.2, “Replication of Columns Having Different Data Types”
auto-generate-sql option
mysqlslap, Description
auto-generate-sql-add-autoincrement option
mysqlslap, Description
auto-generate-sql-execute-number option
mysqlslap, Description
auto-generate-sql-guid-primary option
mysqlslap, Description
auto-generate-sql-load-type option
mysqlslap, Description
auto-generate-sql-secondary-indexes option
mysqlslap, Description
auto-generate-sql-unique-query-number option
mysqlslap, Description
auto-generate-sql-unique-write-number option
mysqlslap, Description
auto-generate-sql-write-number option
mysqlslap, Description
auto-rehash option
mysql, Section 4.5.1.1, “mysql Options”
auto-repair option
mysqlcheck, Description
autoclose option
mysqld_safe, Description

B

BENCHMARK(), Section 11.11.3, “Information Functions”
BETWEEN ... AND, Section 11.2.3, “Comparison Functions and Operators”
BIGINT data type, Section 10.1.1, “Overview of Numeric Types”
BIN(), Section 11.4, “String Functions”
BINARY, Section 11.9, “Cast Functions and Operators”
BINARY data type, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
BINLOG statement
mysqlbinlog output, Section 4.6.7.2, “mysqlbinlog Row Event Display”
BIT data type, Section 10.1.1, “Overview of Numeric Types”
BIT_AND(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
BIT_COUNT, Section 3.6.8, “Calculating Visits Per Day”
BIT_COUNT(), Section 11.11.1, “Bit Functions”
BIT_LENGTH(), Section 11.4, “String Functions”
BIT_OR, Section 3.6.8, “Calculating Visits Per Day”
BIT_OR(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
BIT_XOR(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
BLACKHOLE storage engine, Chapter 13, Storage Engines, Section 13.14, “The BLACKHOLE Storage Engine”
BLOB
inserting binary data, Section 8.1.1, “Strings”
size, Section 10.5, “Data Type Storage Requirements”
BLOB columns
default values, Section 10.4.3, “The BLOB and TEXT Types”
BLOB data type, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
BOOL data type, Section 10.1.1, “Overview of Numeric Types”
BOOLEAN data type, Section 10.1.1, “Overview of Numeric Types”
BackupDataBufferSize, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
BackupLogBufferSize, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
BackupMaxWriteSize, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
BackupMemory, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
BackupWriteSize, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
BdMPolyFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
BdMPolyFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
BdPolyFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
BdPolyFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
Boundary(), Section 11.13.5.2.1, “General Geometry Functions”
Buffer(), Section 11.13.5.3.2, “Spatial Operators”
backslash
escape character, Section 8.1, “Literal Values”
backspace (\b), Section 8.1.1, “Strings”
backup identifiers
native backup and restore, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
backup option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
myisampack, Description
backups, Chapter 6, Backup and Recovery
databases and tables, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
in MySQL Cluster, Section 17.7.3.1, “MySQL Cluster Backup Concepts”, Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”, Section 17.7.3, “Online Backup of MySQL Cluster”, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
backups, troubleshooting
in MySQL Cluster, Section 17.7.3.4, “MySQL Cluster Backup Troubleshooting”
base64-output option
mysqlbinlog, Description
basedir option
mysql.server, Description
mysqld_safe, Description
batch SQL files, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
batch mode, Section 3.5, “Using mysql in Batch Mode”
batch option
mysql, Section 4.5.1.1, “mysql Options”
big5, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
binary log
event groups, Section 12.6.2.6, “SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax”
bind-address option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
bit_functions
example, Section 3.6.8, “Calculating Visits Per Day”
block-search option
myisamchk, Section 4.6.3.4, “Other myisamchk Options”
boolean options, Section 4.2.3.2, “Program Option Modifiers”
brackets
square, Chapter 10, Data Types
brief option
mysqlaccess, Description
buffer sizes
client, Chapter 21, Connectors and APIs
bug reports
criteria for, Section 1.6, “How to Report Bugs or Problems”
bugs
MySQL Cluster
reporting, Section 17.6.12, “ndb_error_reporter — NDB Error-Reporting Utility”
reporting, Section 1.6, “How to Report Bugs or Problems”
bugs database, Section 1.6, “How to Report Bugs or Problems”
bugs.mysql.com, Section 1.6, “How to Report Bugs or Problems”
building
client programs, Section 21.10.16, “Building Client Programs”

C

C
\my.cnf file, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
C API
data types, Section 21.10, “MySQL C API”
functions, Section 21.10.2, “C API Function Overview”
linking problems, Section 21.10.10.4, “Problems Linking with the C API”
C prepared statement API
functions, Section 21.10.6, “C API Prepared Statement Function Overview”
C++ APIs, Section 21.13, “MySQL C++ API”
CACHE INDEX
and partitioning, Section 18.5, “Restrictions and Limitations on Partitioning”
CASE, Section 11.3, “Control Flow Functions”
CAST, Section 11.9, “Cast Functions and Operators”
CC environment variable, Section 2.14, “Environment Variables”
CEIL(), Section 11.5.2, “Mathematical Functions”
CEILING(), Section 11.5.2, “Mathematical Functions”
CFLAGS environment variable, Section 2.14, “Environment Variables”
CHANGE MASTER TO, Section 12.6.2.1, “CHANGE MASTER TO Syntax”
CHAR VARYING data type, Section 10.1.3, “Overview of String Types”
CHAR data type, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
CHAR(), Section 11.4, “String Functions”
CHARACTER VARYING data type, Section 10.1.3, “Overview of String Types”
CHARACTER data type, Section 10.1.3, “Overview of String Types”
CHARACTER_LENGTH(), Section 11.4, “String Functions”
CHARACTER_SETS
INFORMATION_SCHEMA table, Section 20.9, “The INFORMATION_SCHEMA CHARACTER_SETS Table”
CHARSET(), Section 11.11.3, “Information Functions”
CHAR_LENGTH(), Section 11.4, “String Functions”
CHECK TABLE
and partitioning, Section 18.3.3, “Maintenance of Partitions”
CHECKPOINT Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
CJK
FAQ, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
CJK (Chinese, Japanese, Korean)
Access, PHP, etc., Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
CJKV, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Database and table names, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Japanese character sets, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Korean character set, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
LIKE and FULLTEXT, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
MySQL 4.0 behavior, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
ORDER BY treatment, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Unicode collations, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Vietnamese, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Yen sign, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
availability of specific characters, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
available character sets, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
big5, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
character sets available, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
characters displayed as question marks, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
collations, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
conversion problems with Japanese character sets, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
data truncation, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
documentation in Chinese, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
documentation in Japanese, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
documentation in Korean, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
gb2312, gbk, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with Access, PHP, etc., Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with Big5 character sets (Chinese), Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with GB character sets (Chinese), Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with LIKE and FULLTEXT, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with Yen sign (Japanese), Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with data truncation, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
problems with euckr character set (Korean), Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
rejected characters, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
sort order problems, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
sorting problems, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
testing availability of characters, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
CLUSTERLOG STATISTICS command (MySQL Cluster), Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
CLUSTERLOG commands (MySQL Cluster), Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
COALESCE(), Section 11.2.3, “Comparison Functions and Operators”
COERCIBILITY(), Section 11.11.3, “Information Functions”
COLLATION(), Section 11.11.3, “Information Functions”
COLLATIONS
INFORMATION_SCHEMA table, Section 20.10, “The INFORMATION_SCHEMA COLLATIONS Table”
COLLATION_CHARACTER_SET_APPLICABILITY
INFORMATION_SCHEMA table, Section 20.11, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”
COLUMNS
INFORMATION_SCHEMA table, Section 20.3, “The INFORMATION_SCHEMA COLUMNS Table”
COLUMN_PRIVILEGES
INFORMATION_SCHEMA table, Section 20.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
COMPRESS(), Section 11.11.2, “Encryption and Compression Functions”
CONCAT(), Section 11.4, “String Functions”
CONCAT_WS(), Section 11.4, “String Functions”
CONNECTION Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
CONNECTION_ID(), Section 11.11.3, “Information Functions”
CONSTRAINTS
INFORMATION_SCHEMA table, Section 20.12, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”
CONV(), Section 11.5.2, “Mathematical Functions”
CONVERT, Section 11.9, “Cast Functions and Operators”
CONVERT_TZ(), Section 11.6, “Date and Time Functions”
COS(), Section 11.5.2, “Mathematical Functions”
COT(), Section 11.5.2, “Mathematical Functions”
COUNT(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
COUNT(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
CRC32(), Section 11.5.2, “Mathematical Functions”
CREATE NODEGROUP command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
CREATE TABLE
DIRECTORY options
and replication, Section 16.3.1.5, “Replication and DIRECTORY Table Options”
CREATE TABLE ... SELECT
and replication, Section 16.3.1.3, “Replication of CREATE TABLE ... SELECT Statements”
CSV storage engine, Section 13.13, “The CSV Storage Engine”, Chapter 13, Storage Engines
CURDATE(), Section 11.6, “Date and Time Functions”
CURRENT_DATE, Section 11.6, “Date and Time Functions”
CURRENT_TIME, Section 11.6, “Date and Time Functions”
CURRENT_TIMESTAMP, Section 11.6, “Date and Time Functions”
CURRENT_USER(), Section 11.11.3, “Information Functions”
CURTIME(), Section 11.6, “Date and Time Functions”
CXX environment variable, Section 2.14, “Environment Variables”
CXXFLAGS environment variable, Section 2.14, “Environment Variables”
Centroid(), Section 11.13.5.2.6, “MultiPolygon Functions”
ChangeLog, Appendix C, MySQL Change History
Character sets, Section 9.1, “Character Set Support”
Chinese, Japanese, Korean character sets
frequently asked questions, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Comment syntax, Section 8.5, “Comment Syntax”
Configuring MySQL Cluster (concepts), Section 17.1.1, “MySQL Cluster Core Concepts”
Connector/C, Chapter 21, Connectors and APIs
Connector/C++, Chapter 21, Connectors and APIs
Connector/JDBC, Chapter 21, Connectors and APIs
Connector/MXJ, Chapter 21, Connectors and APIs
Connector/NET, Chapter 21, Connectors and APIs
Connector/ODBC, Chapter 21, Connectors and APIs, Section 21.1, “MySQL Connector/ODBC”
Connector/OpenOffice.org, Chapter 21, Connectors and APIs
Connectors
MySQL, Chapter 21, Connectors and APIs
Contains(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
ConvexHull(), Section 11.13.5.3.2, “Spatial Operators”
Crosses(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
calculating
dates, Section 3.3.4.5, “Date Calculations”
calendar, Section 11.7, “What Calendar Is Used By MySQL?”
calling sequences for aggregate functions
UDF, Section 22.3.2.2, “UDF Calling Sequences for Aggregate Functions”
calling sequences for simple functions
UDF, Section 22.3.2.1, “UDF Calling Sequences for Simple Functions”
carriage return (\r), Section 8.1.1, “Strings”
case sensitivity
in identifiers, Section 8.2.2, “Identifier Case Sensitivity”
in names, Section 8.2.2, “Identifier Case Sensitivity”
in string comparisons, Section 11.4.1, “String Comparison Functions”
cast functions, Section 11.9, “Cast Functions and Operators”
cast operators, Section 11.9, “Cast Functions and Operators”
casts, Section 11.9, “Cast Functions and Operators”, Section 11.2.3, “Comparison Functions and Operators”, Section 11.2.2, “Type Conversion in Expression Evaluation”
changes
Cluster, Changes in MySQL Cluster
InnoDB, Changes in InnoDB
log, Appendix C, MySQL Change History
character sets, Section 9.2, “The Character Set Used for Data and Sorting”
adding, Section 9.4, “Adding a New Character Set”
and replication, Section 16.3.1.2, “Replication and Character Sets”
character-sets-dir option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
characters
multi-byte, Section 9.4.3, “Multi-Byte Character Support”
charset command
mysql, Section 4.5.1.2, “mysql Commands”
check option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
mysqlcheck, Description
check options
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
check-only-changed option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
mysqlcheck, Description
check-password-file option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
check-upgrade option
mysqlcheck, Description
checking
tables for errors, Section 6.4.2, “How to Check MyISAM Tables for Errors”
checkpoint option
mysqlhotcopy, Description
choosing types, Section 10.6, “Choosing the Right Type for a Column”
chroot option
mysqlhotcopy, Description
clean-password-file option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
clear command
mysql, Section 4.5.1.2, “mysql Commands”
client programs
building, Section 21.10.16, “Building Client Programs”
client tools, Chapter 21, Connectors and APIs
clients
debugging, Section 22.5.2, “Debugging a MySQL Client”
threaded, Section 21.10.17, “How to Make a Threaded Client”
cluster logs, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”, Section 17.7.4, “Event Reports Generated in MySQL Cluster”
collating
strings, Section 9.4.2, “String Collating Support”
collation
adding, Section 9.5, “How to Add a New Collation to a Character Set”
column
types, Chapter 10, Data Types
column names
case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
column-names option
mysql, Section 4.5.1.1, “mysql Options”
column-type-info option
mysql, Section 4.5.1.1, “mysql Options”
columns
displaying, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
names, Section 8.2, “Schema Object Names”
other types, Section 10.7, “Using Data Types from Other Database Engines”
selecting, Section 3.3.4.3, “Selecting Particular Columns”
storage requirements, Section 10.5, “Data Type Storage Requirements”
columns option
mysqlimport, Description
command options
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
command options (MySQL Cluster)
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb_mgm, Description, Section 17.6.24.4, “Program Options for ndb_mgm
ndb_mgmd, Description, Section 17.6.24.3, “Program Options for ndb_mgmd
ndbd, Section 17.6.24.2, “Program Options for ndbd and ndbmtd, Description
command syntax, Section 1.2, “Typographical and Syntax Conventions”
command-line history
mysql, Section 4.5.1.1, “mysql Options”
command-line options (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
command-line tool, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
comments
adding, Section 8.5, “Comment Syntax”
comments option
mysql, Section 4.5.1.1, “mysql Options”
mysqldump, Description
commit option
mysqlaccess, Description
mysqlslap, Description
compact option
mysqldump, Description
comparison operators, Section 11.2.3, “Comparison Functions and Operators”
compatibility
with ODBC, Section 8.2.1, “Identifier Qualifiers”, Section 10.1.1, “Overview of Numeric Types”, Section 11.2.3, “Comparison Functions and Operators”, Section 11.2.2, “Type Conversion in Expression Evaluation”
with Oracle, Section 11.12.1, “GROUP BY (Aggregate) Functions”, Section 12.3.1, “DESCRIBE Syntax”
with Sybase, Section 12.3.4, “USE Syntax”
with mSQL, Section 11.4.2, “Regular Expressions”
compatible option
mysqldump, Description
compiling
user-defined functions, Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
complete-insert option
mysqldump, Description
compliance
Y2K, Section 10.3.4, “Year 2000 Issues and Date Types”
composite partitioning, Section 18.2.5, “Subpartitioning”
compress option
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
compressed tables, Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”, Section 13.5.3.3, “Compressed Table Characteristics”
concatenation
string, Section 8.1.1, “Strings”, Section 11.4, “String Functions”
concurrency option
mysqlslap, Description
config-file option
mysqld_multi, Description
ndb_config, Description
config.ini (MySQL Cluster), Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”, Description
configinfo option
ndb_config, Description
configuring MySQL Cluster, Description, Section 17.2, “MySQL Cluster Multi-Computer How-To”, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
configuring backups
in MySQL Cluster, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
connect command
mysql, Section 4.5.1.2, “mysql Commands”
connect_timeout variable, Description, Section 4.5.1.1, “mysql Options”
connecting
remotely with SSH, Section 5.5.8, “Connecting to MySQL Remotely from Windows with SSH”
to the server, Section 3.1, “Connecting to and Disconnecting from the Server”, Section 4.2.2, “Connecting to the MySQL Server”
control flow functions, Section 11.3, “Control Flow Functions”
conventions
syntax, Section 1.2, “Typographical and Syntax Conventions”
typographical, Section 1.2, “Typographical and Syntax Conventions”
copy option
mysqlaccess, Description
core-file-size option
mysqld_safe, Description
correct-checksum option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
count option
myisam_ftdump, Description
mysqladmin, Description
mysqlshow, Description
counting
table rows, Section 3.3.4.8, “Counting Rows”
crash, Section 22.5.1, “Debugging a MySQL Server”
recovery, Section 6.4.1, “Using myisamchk for Crash Recovery”
replication, Section 16.3.1.14, “Replication During a Master Crash”
create option
mysqlslap, Description
create-options option
mysqldump, Description
create-schema option
mysqlslap, Description
creating
bug reports, Section 1.6, “How to Report Bugs or Problems”
databases, Section 3.3, “Creating and Using a Database”
default startup options, Section 4.2.3.3, “Using Option Files”
tables, Section 3.3.2, “Creating a Table”
csv option
mysqlslap, Description

D

DATA DIRECTORY
and replication, Section 16.3.1.5, “Replication and DIRECTORY Table Options”
DATABASE(), Section 11.11.3, “Information Functions”
DATE data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
DATE(), Section 11.6, “Date and Time Functions”
DATEDIFF(), Section 11.6, “Date and Time Functions”
DATETIME data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
DATE_ADD(), Section 11.6, “Date and Time Functions”
DATE_FORMAT(), Section 11.6, “Date and Time Functions”
DATE_SUB(), Section 11.6, “Date and Time Functions”
DAY(), Section 11.6, “Date and Time Functions”
DAYNAME(), Section 11.6, “Date and Time Functions”
DAYOFMONTH(), Section 11.6, “Date and Time Functions”
DAYOFWEEK(), Section 11.6, “Date and Time Functions”
DAYOFYEAR(), Section 11.6, “Date and Time Functions”
DBI interface, Section 21.12, “MySQL Perl API”
DBI->quote, Section 8.1.1, “Strings”
DBI->trace, Section 22.5.1.4, “Debugging mysqld under gdb
DBI/DBD interface, Section 21.12, “MySQL Perl API”
DBI_TRACE environment variable, Section 22.5.1.4, “Debugging mysqld under gdb, Section 2.14, “Environment Variables”
DBI_USER environment variable, Section 2.14, “Environment Variables”
DBUG package, Section 22.5.3, “The DBUG Package”
DEALLOCATE PREPARE, Section 12.7, “SQL Syntax for Prepared Statements”, Section 12.7.3, “DEALLOCATE PREPARE Syntax”
DEC data type, Section 10.1.1, “Overview of Numeric Types”
DECIMAL data type, Section 10.1.1, “Overview of Numeric Types”
DECODE(), Section 11.11.2, “Encryption and Compression Functions”
DEFAULT value clause, Section 10.1.4, “Data Type Default Values”
DEFAULT(), Section 11.11.4, “Miscellaneous Functions”
DEGREES(), Section 11.5.2, “Mathematical Functions”
DESC, Section 12.3.1, “DESCRIBE Syntax”
DESCRIBE, Section 3.4, “Getting Information About Databases and Tables”, Section 12.3.1, “DESCRIBE Syntax”
DES_DECRYPT(), Section 11.11.2, “Encryption and Compression Functions”
DES_ENCRYPT(), Section 11.11.2, “Encryption and Compression Functions”
DISTINCT, Section 3.3.4.3, “Selecting Particular Columns”
AVG(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
COUNT(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
MAX(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
MIN(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
SUM(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
DIV, Section 11.5.1, “Arithmetic Operators”
DOUBLE PRECISION data type, Section 10.1.1, “Overview of Numeric Types”
DOUBLE data type, Section 10.1.1, “Overview of Numeric Types”
DRBD, Section A.14.1, “Distributed Replicated Block Device (DRBD)”
DRBD license, Section A.14.1, “Distributed Replicated Block Device (DRBD)”
DROP ... IF EXISTS
and replication, Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”
DROP NODEGROUP command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
DROP PREPARE, Section 12.7.3, “DEALLOCATE PREPARE Syntax”
Data truncation with CJK characters, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Date and Time types, Section 10.3, “Date and Time Types”
Difference(), Section 11.13.5.3.2, “Spatial Operators”
Dimension(), Section 11.13.5.2.1, “General Geometry Functions”
Disjoint(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
Distance(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
Documentation
in Chinese, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
in Japanese, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
in Korean, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
data
character sets, Section 9.2, “The Character Set Used for Data and Sorting”
importing, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
loading into tables, Section 3.3.3, “Loading Data into a Table”
retrieving, Section 3.3.4, “Retrieving Information from a Table”
data node (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
data nodes (MySQL Cluster), Section 17.6.2, “ndbd — The MySQL Cluster Data Node Daemon”, Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”
data type
BIGINT, Section 10.1.1, “Overview of Numeric Types”
BINARY, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
BIT, Section 10.1.1, “Overview of Numeric Types”
BLOB, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
BOOL, Section 10.1.1, “Overview of Numeric Types”, Section 10.7, “Using Data Types from Other Database Engines”
BOOLEAN, Section 10.1.1, “Overview of Numeric Types”, Section 10.7, “Using Data Types from Other Database Engines”
CHAR, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
CHAR VARYING, Section 10.1.3, “Overview of String Types”
CHARACTER, Section 10.1.3, “Overview of String Types”
CHARACTER VARYING, Section 10.1.3, “Overview of String Types”
DATE, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
DATETIME, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
DEC, Section 10.1.1, “Overview of Numeric Types”
DECIMAL, Section 10.1.1, “Overview of Numeric Types”
DOUBLE, Section 10.1.1, “Overview of Numeric Types”
DOUBLE PRECISION, Section 10.1.1, “Overview of Numeric Types”
ENUM, Section 10.4.4, “The ENUM Type”, Section 10.1.3, “Overview of String Types”
FIXED, Section 10.1.1, “Overview of Numeric Types”
FLOAT, Section 10.1.1, “Overview of Numeric Types”
GEOMETRY, Section 11.13.4.1, “MySQL Spatial Data Types”
GEOMETRYCOLLECTION, Section 11.13.4.1, “MySQL Spatial Data Types”
INT, Section 10.1.1, “Overview of Numeric Types”
INTEGER, Section 10.1.1, “Overview of Numeric Types”
LINESTRING, Section 11.13.4.1, “MySQL Spatial Data Types”
LONG, Section 10.4.3, “The BLOB and TEXT Types”
LONGBLOB, Section 10.1.3, “Overview of String Types”
LONGTEXT, Section 10.1.3, “Overview of String Types”
MEDIUMBLOB, Section 10.1.3, “Overview of String Types”
MEDIUMINT, Section 10.1.1, “Overview of Numeric Types”
MEDIUMTEXT, Section 10.1.3, “Overview of String Types”
MULTILINESTRING, Section 11.13.4.1, “MySQL Spatial Data Types”
MULTIPOINT, Section 11.13.4.1, “MySQL Spatial Data Types”
MULTIPOLYGON, Section 11.13.4.1, “MySQL Spatial Data Types”
NATIONAL CHAR, Section 10.1.3, “Overview of String Types”
NATIONAL VARCHAR, Section 10.1.3, “Overview of String Types”
NCHAR, Section 10.1.3, “Overview of String Types”
NUMERIC, Section 10.1.1, “Overview of Numeric Types”
NVARCHAR, Section 10.1.3, “Overview of String Types”
POINT, Section 11.13.4.1, “MySQL Spatial Data Types”
POLYGON, Section 11.13.4.1, “MySQL Spatial Data Types”
REAL, Section 10.1.1, “Overview of Numeric Types”
SET, Section 10.1.3, “Overview of String Types”, Section 10.4.5, “The SET Type”
SMALLINT, Section 10.1.1, “Overview of Numeric Types”
TEXT, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
TIME, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.2, “The TIME Type”
TIMESTAMP, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
TINYBLOB, Section 10.1.3, “Overview of String Types”
TINYINT, Section 10.1.1, “Overview of Numeric Types”
TINYTEXT, Section 10.1.3, “Overview of String Types”
VARBINARY, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
VARCHAR, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
VARCHARACTER, Section 10.1.3, “Overview of String Types”
YEAR, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.3, “The YEAR Type”
data types, Chapter 10, Data Types
C API, Section 21.10, “MySQL C API”
overview, Section 10.1, “Data Type Overview”
data-file-length option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
database metadata, Chapter 20, INFORMATION_SCHEMA Tables
database names
case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
database option
mysql, Section 4.5.1.1, “mysql Options”
mysqlbinlog, Description
databases
backups, Chapter 6, Backup and Recovery
creating, Section 3.3, “Creating and Using a Database”
displaying, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
dumping, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
information about, Section 3.4, “Getting Information About Databases and Tables”
names, Section 8.2, “Schema Object Names”
replicating, Chapter 16, Replication
selecting, Section 3.3.1, “Creating and Selecting a Database”
using, Section 3.3, “Creating and Using a Database”
databases option
mysqlcheck, Description
mysqldump, Description
datadir option
mysql.server, Description
mysqld_safe, Description
date and time functions, Section 11.6, “Date and Time Functions”
date calculations, Section 3.3.4.5, “Date Calculations”
date functions
Y2K compliance, Section 10.3.4, “Year 2000 Issues and Date Types”
date types, Section 10.5, “Data Type Storage Requirements”
Y2K issues, Section 10.3.4, “Year 2000 Issues and Date Types”
date values
problems, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
dates
used with partitioning, Section 18.2, “Partition Types”
used with partitioning (examples), Section 18.2.1, “RANGE Partitioning”, Section 18.2.5, “Subpartitioning”, Section 18.4, “Partition Pruning”, Section 18.2.3, “HASH Partitioning”
db option
mysqlaccess, Description
debug option
myisamchk, Section 4.6.3.1, “myisamchk General Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqlaccess, Description
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqldump, Description
mysqldumpslow, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
debug-check option
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
debug-info option
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
debugging
client, Section 22.5.2, “Debugging a MySQL Client”
server, Section 22.5.1, “Debugging a MySQL Server”
decimal point, Chapter 10, Data Types
decode_bits myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
default host name, Section 4.2.2, “Connecting to the MySQL Server”
default options, Section 4.2.3.3, “Using Option Files”
default values, Section 10.1.4, “Data Type Default Values”
BLOB and TEXT columns, Section 10.4.3, “The BLOB and TEXT Types”
explicit, Section 10.1.4, “Data Type Default Values”
implicit, Section 10.1.4, “Data Type Default Values”
default-character-set option
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
default-mysqld-path option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
defaults
embedded, Section 21.9.3, “Options with the Embedded Server”
defaults-extra-file option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
mysqld_multi, Description
mysqld_safe, Description
defaults-file option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
mysqld_multi, Description
mysqld_safe, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
defaults-group-suffix option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
delay-key-write option
mysqld, Section 13.5.1, “MyISAM Startup Options”
delayed-insert option
mysqldump, Description
delete option
mysqlimport, Description
delete-master-logs option
mysqldump, Description
deleting
user, Section 5.5.3, “Removing User Accounts”
users, Section 5.5.3, “Removing User Accounts”
delimiter command
mysql, Section 4.5.1.2, “mysql Commands”
delimiter option
mysql, Section 4.5.1.1, “mysql Options”
mysqlslap, Description
ndb_select_all, Description
descending option
ndb_select_all, Description
description option
myisamchk, Section 4.6.3.4, “Other myisamchk Options”
detach option
mysqlslap, Description
digits, Chapter 10, Data Types
disable named command
mysql, Section 4.5.1.1, “mysql Options”
disable-keys option
mysqldump, Description
disable-log-bin option
mysqlbinlog, Description
disconnecting
from the server, Section 3.1, “Connecting to and Disconnecting from the Server”
disk option
ndb_select_all, Description
display size, Chapter 10, Data Types
display width, Chapter 10, Data Types
displaying
database information, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
division (/), Section 11.5.1, “Arithmetic Operators”
double quote (\"), Section 8.1.1, “Strings”
drbd
FAQ, Section A.14, “MySQL 5.1 FAQ — MySQL, DRBD, and Heartbeat”
drop-user option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
dropping
user, Section 5.5.3, “Removing User Accounts”
dryrun option
mysqlhotcopy, Description
dump option
myisam_ftdump, Description
dump-date option
mysqldump, Description
dumping
databases and tables, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
dynamic table characteristics, Section 13.5.3.2, “Dynamic Table Characteristics”

E

ELT(), Section 11.4, “String Functions”
ENCODE(), Section 11.11.2, “Encryption and Compression Functions”
ENCRYPT(), Section 11.11.2, “Encryption and Compression Functions”
ENGINES
INFORMATION_SCHEMA table, Section 20.18, “The INFORMATION_SCHEMA ENGINES Table”
ENTER SINGLE USER MODE command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
ENUM
size, Section 10.5, “Data Type Storage Requirements”
ENUM data type, Section 10.4.4, “The ENUM Type”, Section 10.1.3, “Overview of String Types”
ERROR Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
EVENTS
INFORMATION_SCHEMA table, Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
EXAMPLE storage engine, Chapter 13, Storage Engines, Section 13.10, “The EXAMPLE Storage Engine”
EXECUTE, Section 12.7.2, “EXECUTE Syntax”, Section 12.7, “SQL Syntax for Prepared Statements”
EXIT SINGLE USER MODE command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
EXIT command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
EXP(), Section 11.5.2, “Mathematical Functions”
EXPLAIN, Section 12.3.2, “EXPLAIN Syntax”
EXPLAIN PARTITIONS, Section 18.3.4, “Obtaining Information About Partitions”
EXPLAIN used with partitioned tables, Section 18.3.4, “Obtaining Information About Partitions”
EXPORT_SET(), Section 11.4, “String Functions”
EXTRACT(), Section 11.6, “Date and Time Functions”
Eiffel Wrapper, Section 21.17, “MySQL Eiffel Wrapper”
EndPoint(), Section 11.13.5.2.3, “LineString Functions”
Envelope(), Section 11.13.5.2.1, “General Geometry Functions”
Equals(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
Event Scheduler
and replication, Section 16.3.1.7, “Replication of Invoked Features”
ExteriorRing(), Section 11.13.5.2.5, “Polygon Functions”
ExtractValue(), Section 11.10, “XML Functions”
edit command
mysql, Section 4.5.1.2, “mysql Commands”
edit-user option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
ego command
mysql, Section 4.5.1.2, “mysql Commands”
embedded MySQL server library, Section 21.9, “libmysqld, the Embedded MySQL Server Library”
encryption, Section 5.5.7.1, “Basic SSL Concepts”
encryption functions, Section 11.11.2, “Encryption and Compression Functions”
engine option
mysqlslap, Description
entering
queries, Section 3.2, “Entering Queries”
environment variable
CC, Section 2.14, “Environment Variables”
CFLAGS, Section 2.14, “Environment Variables”
CXX, Section 2.14, “Environment Variables”
CXXFLAGS, Section 2.14, “Environment Variables”
DBI_TRACE, Section 22.5.1.4, “Debugging mysqld under gdb, Section 2.14, “Environment Variables”
DBI_USER, Section 2.14, “Environment Variables”
HOME, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
LD_RUN_PATH, Section 2.14, “Environment Variables”
MYSQL_DEBUG, Section 22.5.2, “Debugging a MySQL Client”, Section 2.14, “Environment Variables”
MYSQL_GROUP_SUFFIX, Section 2.14, “Environment Variables”
MYSQL_HISTFILE, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
MYSQL_HOME, Section 2.14, “Environment Variables”
MYSQL_HOST, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
MYSQL_PS1, Section 2.14, “Environment Variables”
MYSQL_PWD, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
MYSQL_TCP_PORT, Section 5.6.2, “Running Multiple Servers on Unix”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 2.14, “Environment Variables”
MYSQL_UNIX_PORT, Section 5.6.2, “Running Multiple Servers on Unix”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 2.14, “Environment Variables”
PATH, Section 2.14, “Environment Variables”, Section 4.2.1, “Invoking MySQL Programs”
TMPDIR, Section 2.14, “Environment Variables”
TZ, Section 2.14, “Environment Variables”
UMASK, Section 2.14, “Environment Variables”
UMASK_DIR, Section 2.14, “Environment Variables”
USER, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
environment variables, Section 4.2.4, “Setting Environment Variables”
list of, Section 2.14, “Environment Variables”
equal (=), Section 11.2.3, “Comparison Functions and Operators”
error logs (MySQL Cluster), Description
error messages
languages, Section 9.3, “Setting the Error Message Language”
errors
and replication, Section 16.3.1.20, “Slave Errors during Replication”
checking tables for, Section 6.4.2, “How to Check MyISAM Tables for Errors”
handling for UDFs, Section 22.3.2.4, “UDF Return Values and Error Handling”
reporting, Section 1.6, “How to Report Bugs or Problems”
escape (\\), Section 8.1.1, “Strings”
escape characters, Section 8.1, “Literal Values”
event groups, Section 12.6.2.6, “SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax”
event log format (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
event logs (MySQL Cluster), Section 17.7.4.1, “MySQL Cluster Logging Management Commands”, Section 17.7.4, “Event Reports Generated in MySQL Cluster”
event restrictions, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
event scheduler, Chapter 19, Stored Programs and Views
event severity levels (MySQL Cluster), Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
event types (MySQL Cluster), Section 17.7.4, “Event Reports Generated in MySQL Cluster”, Section 17.7.4.2, “MySQL Cluster Log Events”
events, Chapter 19, Stored Programs and Views
events option
mysqldump, Description
example option
mysqld_multi, Description
examples
compressed tables, Description
myisamchk output, Section 6.4.5, “Getting Information About a Table”
queries, Section 3.6, “Examples of Common Queries”
execute option
mysql, Section 4.5.1.1, “mysql Options”
executing SQL statements from text files, Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
exit command
mysql, Section 4.5.1.2, “mysql Commands”
explicit default values, Section 10.1.4, “Data Type Default Values”
expression aliases, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
expressions
extended, Section 3.3.4.7, “Pattern Matching”
extend-check option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”, Section 4.6.3.2, “myisamchk Check Options”
extended option
mysqlcheck, Description
extended-insert option
mysqldump, Description
external locking, Section 6.4.1, “Using myisamchk for Crash Recovery”
extra-partition-info option
ndb_desc, Description
extracting
dates, Section 3.3.4.5, “Date Calculations”

F

FALSE, Section 8.1.4, “Boolean Values”, Section 8.1.2, “Numbers”
testing for, Section 11.2.3, “Comparison Functions and Operators”
FEDERATED storage engine, Chapter 13, Storage Engines, Section 13.11, “The FEDERATED Storage Engine”
FIELD(), Section 11.4, “String Functions”
FILE, Section 11.4, “String Functions”
FILES
INFORMATION_SCHEMA table, Section 20.21, “The INFORMATION_SCHEMA FILES Table”
FIND_IN_SET(), Section 11.4, “String Functions”
FIXED data type, Section 10.1.1, “Overview of Numeric Types”
FLOAT data type, Section 10.1.1, “Overview of Numeric Types”
FLOOR(), Section 11.5.2, “Mathematical Functions”
FLUSH
and replication, Section 16.3.1.9, “Replication and FLUSH
FORMAT(), Section 11.4, “String Functions”
FOUND_ROWS(), Section 11.11.3, “Information Functions”
FROM_DAYS(), Section 11.6, “Date and Time Functions”
FROM_UNIXTIME(), Section 11.6, “Date and Time Functions”
FULLTEXT, Section 11.8, “Full-Text Search Functions”
fast option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
mysqlcheck, Description
fields option
ndb_config, Description
fields-enclosed-by option
mysqldump, Description, Description
fields-escaped-by option
mysqldump, Description, Description
fields-optionally-enclosed-by option
mysqldump, Description, Description
fields-terminated-by option
mysqldump, Description, Description
files
error messages, Section 9.3, “Setting the Error Message Language”
my.cnf, Section 16.3.1, “Replication Features and Issues”
repairing, Section 4.6.3.3, “myisamchk Repair Options”
script, Section 3.5, “Using mysql in Batch Mode”
text, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
firewalls (software)
and MySQL Cluster, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
first-slave option
mysqldump, Description
fix-db-names option
mysqlcheck, Description
fix-table-names option
mysqlcheck, Description
floating-point number, Section 10.1.1, “Overview of Numeric Types”
floating-point values
and replication, Section 16.3.1.8, “Replication with Floating-Point Values”
floats, Section 8.1.2, “Numbers”
flush tables, Description
flush-logs option
mysqldump, Description
flush-privileges option
mysqldump, Description
flushlog option
mysqlhotcopy, Description
force option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”, Section 4.6.3.2, “myisamchk Check Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
force-read option
mysqlbinlog, Description
foreign keys, Section 3.6.6, “Using Foreign Keys”
frequently-asked questions about DRBD, Section A.14, “MySQL 5.1 FAQ — MySQL, DRBD, and Heartbeat”
frequently-asked questions about MySQL Cluster, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
ft_max_word_len myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
ft_min_word_len myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
ft_stopword_file myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
full-text search, Section 11.8, “Full-Text Search Functions”
fulltext
stopword list, Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
function names
parsing, Section 8.2.4, “Function Name Parsing and Resolution”
resolving ambiguity, Section 8.2.4, “Function Name Parsing and Resolution”
functions, Chapter 11, Functions and Operators
C API, Section 21.10.2, “C API Function Overview”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
C prepared statement API, Section 21.10.6, “C API Prepared Statement Function Overview”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
GROUP BY, Section 11.12.1, “GROUP BY (Aggregate) Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
and replication, Section 16.3.1.10, “Replication and System Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
arithmetic, Section 11.11.1, “Bit Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
bit, Section 11.11.1, “Bit Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
cast, Section 11.9, “Cast Functions and Operators”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
control flow, Section 11.3, “Control Flow Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
date and time, Section 11.6, “Date and Time Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
encryption, Section 11.11.2, “Encryption and Compression Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
grouping, Section 11.2.1, “Operator Precedence”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
information, Section 11.11.3, “Information Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
mathematical, Section 11.5.2, “Mathematical Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
miscellaneous, Section 11.11.4, “Miscellaneous Functions”
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
native
adding, Section 22.3.3, “Adding a New Native Function”
adding, Section 22.3.2, “Adding a New User-Defined Function”
new, Section 22.3, “Adding New Functions to MySQL”
adding, Section 22.3.2, “Adding a New User-Defined Function”
stored, Section 19.2, “Using Stored Routines (Procedures and Functions)”
adding, Section 22.3.2, “Adding a New User-Defined Function”
string, Section 11.4, “String Functions”
adding, Section 22.3.2, “Adding a New User-Defined Function”
string comparison, Section 11.4.1, “String Comparison Functions”
adding, Section 22.3.2, “Adding a New User-Defined Function”
user-defined, Section 22.3, “Adding New Functions to MySQL”
adding, Section 22.3.2, “Adding a New User-Defined Function”
functions for SELECT and WHERE clauses, Chapter 11, Functions and Operators

G

GEOMETRY data type, Section 11.13.4.1, “MySQL Spatial Data Types”
GEOMETRYCOLLECTION data type, Section 11.13.4.1, “MySQL Spatial Data Types”
GET_FORMAT(), Section 11.6, “Date and Time Functions”
GET_LOCK(), Section 11.11.4, “Miscellaneous Functions”
GIS, Section 11.13, “Spatial Extensions”, Section 11.13.1, “Introduction to MySQL Spatial Support”
GLOBAL_STATUS
INFORMATION_SCHEMA table, Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
GLOBAL_VARIABLES
INFORMATION_SCHEMA table, Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”
GLength(), Section 11.13.5.2.4, “MultiLineString Functions”, Section 11.13.5.2.3, “LineString Functions”
GRANT statement, Section 5.5.2, “Adding User Accounts”
GREATEST(), Section 11.2.3, “Comparison Functions and Operators”
GROUP BY
aliases in, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
extensions to standard SQL, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
GROUP BY functions, Section 11.12.1, “GROUP BY (Aggregate) Functions”
GROUP_CONCAT(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
GeomCollFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
GeomCollFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
GeomFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”, Section 11.13.5.1, “Geometry Format Conversion Functions”
GeomFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”, Section 11.13.5.1, “Geometry Format Conversion Functions”
GeometryCollection(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
GeometryCollectionFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
GeometryCollectionFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
GeometryFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
GeometryFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
GeometryN(), Section 11.13.5.2.7, “GeometryCollection Functions”
GeometryType(), Section 11.13.5.2.1, “General Geometry Functions”
gb2312, gbk, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
gci option
ndb_select_all, Description
gdb
using, Section 22.5.1.4, “Debugging mysqld under gdb
geographic feature, Section 11.13.1, “Introduction to MySQL Spatial Support”
geometry, Section 11.13.1, “Introduction to MySQL Spatial Support”
geospatial feature, Section 11.13.1, “Introduction to MySQL Spatial Support”
go command
mysql, Section 4.5.1.2, “mysql Commands”
greater than (>), Section 11.2.3, “Comparison Functions and Operators”
greater than or equal (>=), Section 11.2.3, “Comparison Functions and Operators”
grouping
expressions, Section 11.2.1, “Operator Precedence”

H

HEAP storage engine, Chapter 13, Storage Engines, Section 13.9, “The MEMORY (HEAP) Storage Engine”
HELP command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
HELP option
myisamchk, Section 4.6.3.1, “myisamchk General Options”
HELP statement, Section 12.3.3, “HELP Syntax”
HEX(), Section 11.5.2, “Mathematical Functions”, Section 11.4, “String Functions”
HOME environment variable, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
HOUR(), Section 11.6, “Date and Time Functions”
HostName (MySQL Cluster), Section 17.8.1, “MySQL Cluster Security and Networking Issues”
handling
errors, Section 22.3.2.4, “UDF Return Values and Error Handling”
hash partitioning, Section 18.2.3, “HASH Partitioning”
hash partitions
managing, Section 18.3.2, “Management of HASH and KEY Partitions”
splitting and merging, Section 18.3.2, “Management of HASH and KEY Partitions”
header option
ndb_select_all, Description
help command
mysql, Section 4.5.1.2, “mysql Commands”
help option
myisam_ftdump, Description
myisamchk, Section 4.6.3.1, “myisamchk General Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqlaccess, Description
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_multi, Description
mysqld_safe, Description
mysqldump, Description
mysqldumpslow, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
hex-blob option
mysqldump, Description
hexadecimal values, Section 8.1.3, “Hexadecimal Values”
hexdump option
mysqlbinlog, Description
host name
default, Section 4.2.2, “Connecting to the MySQL Server”
host option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysqlaccess, Description
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqldump, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
ndb_config, Description
howto option
mysqlaccess, Description
html option
mysql, Section 4.5.1.1, “mysql Options”

I

IBMDB2I storage engine, Chapter 13, Storage Engines
ID
unique, Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
IF(), Section 11.3, “Control Flow Functions”
IFNULL(), Section 11.3, “Control Flow Functions”
IN, Section 11.2.3, “Comparison Functions and Operators”
INDEX DIRECTORY
and replication, Section 16.3.1.5, “Replication and DIRECTORY Table Options”
INET_ATON(), Section 11.11.4, “Miscellaneous Functions”
INET_NTOA(), Section 11.11.4, “Miscellaneous Functions”
INFO Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
INFORMATION_SCHEMA, Chapter 20, INFORMATION_SCHEMA Tables
and security issues, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
INFORMATION_SCHEMA.ENGINES table
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
INFORMATION_SCHEMA.GLOBAL_STATUS table
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
INFORMATION_SCHEMA.GLOBAL_VARIABLES table
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
INSERT statement
grant privileges, Section 5.5.2, “Adding User Accounts”
INSERT(), Section 11.4, “String Functions”
INSTR(), Section 11.4, “String Functions”
INT data type, Section 10.1.1, “Overview of Numeric Types”
INTEGER data type, Section 10.1.1, “Overview of Numeric Types”
INTERVAL(), Section 11.2.3, “Comparison Functions and Operators”
IS NOT NULL, Section 11.2.3, “Comparison Functions and Operators”
IS NOT boolean_value, Section 11.2.3, “Comparison Functions and Operators”
IS NULL, Section 11.2.3, “Comparison Functions and Operators”
IS boolean_value, Section 11.2.3, “Comparison Functions and Operators”
ISNULL(), Section 11.2.3, “Comparison Functions and Operators”
IS_FREE_LOCK(), Section 11.11.4, “Miscellaneous Functions”
IS_USED_LOCK(), Section 11.11.4, “Miscellaneous Functions”
InnoDB storage engine, Chapter 13, Storage Engines
InteriorRingN(), Section 11.13.5.2.5, “Polygon Functions”
Intersection(), Section 11.13.5.3.2, “Spatial Operators”
Intersects(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
IsClosed(), Section 11.13.5.2.4, “MultiLineString Functions”
IsEmpty(), Section 11.13.5.2.1, “General Geometry Functions”
IsRing(), Section 11.13.5.2.3, “LineString Functions”
IsSimple(), Section 11.13.5.2.1, “General Geometry Functions”
i-am-a-dummy option
mysql, Section 4.5.1.1, “mysql Options”
icc
and MySQL Cluster support>, Section 22.5, “Debugging and Porting MySQL”
id option
ndb_config, Description
identifiers, Section 8.2, “Schema Object Names”
case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
quoting, Section 8.2, “Schema Object Names”
ignore option
mysqlimport, Description
ignore-lines option
mysqlimport, Description
ignore-spaces option
mysql, Section 4.5.1.1, “mysql Options”
ignore-table option
mysqldump, Description
implicit default values, Section 10.1.4, “Data Type Default Values”
importing
data, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
increasing
performance, Section 16.3.4, “Replication FAQ”
increasing with replication
speed, Chapter 16, Replication
indexes
names, Section 8.2, “Schema Object Names”
information functions, Section 11.11.3, “Information Functions”
information option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
innochecksum, Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
insert-ignore option
mysqldump, Description
insertable views
insertable, Section 19.5.3, “Updatable and Insertable Views”
install option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
installing
user-defined functions, Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
installing MySQL Cluster, Section 17.2.2, “MySQL Cluster Multi-Computer Installation”, Section 17.2, “MySQL Cluster Multi-Computer How-To”
integers, Section 8.1.2, “Numbers”
internals, Section 22.1, “MySQL Internals”
internationalization, Chapter 9, Internationalization and Localization
introducer
string literal, Section 8.1.1, “Strings”, Section 9.1.3.5, “Character String Literal Character Set and Collation”
isamlog, Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
iterations option
mysqlslap, Description

J

Japanese character sets
conversion, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Japanese, Korean, Chinese character sets
frequently asked questions, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
join option
myisampack, Description

K

KEY_COLUMN_USAGE
INFORMATION_SCHEMA table, Section 20.13, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”
Korean, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Korean, Chinese, Japanese character sets
frequently asked questions, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
keepold option
mysqlhotcopy, Description
key partitioning, Section 18.2.4, “KEY Partitioning”
key partitions
managing, Section 18.3.2, “Management of HASH and KEY Partitions”
splitting and merging, Section 18.3.2, “Management of HASH and KEY Partitions”
key space
MyISAM, Section 13.5.2, “Space Needed for Keys”
key_buffer_size myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
keys
foreign, Section 3.6.6, “Using Foreign Keys”
searching on two, Section 3.6.7, “Searching on Two Keys”
keys option
mysqlshow, Description
keys-used option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
keywords, Section 8.3, “Reserved Words”

L

LAST_DAY(), Section 11.6, “Date and Time Functions”
LAST_INSERT_ID()
and replication, Section 16.3.1.1, “Replication and AUTO_INCREMENT
LAST_INSERT_ID() and stored routines, Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
LAST_INSERT_ID() and triggers, Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
LAST_INSERT_ID([<replaceable>expr</replaceable>]), Section 11.11.3, “Information Functions”
LCASE(), Section 11.4, “String Functions”
LD_RUN_PATH environment variable, Section 2.14, “Environment Variables”
LEAST(), Section 11.2.3, “Comparison Functions and Operators”
LEFT(), Section 11.4, “String Functions”
LENGTH(), Section 11.4, “String Functions”
LIKE, Section 11.4.1, “String Comparison Functions”
LIMIT, Section 11.11.3, “Information Functions”
and replication, Section 16.3.1.11, “Replication and LIMIT
LINESTRING data type, Section 11.13.4.1, “MySQL Spatial Data Types”
LN(), Section 11.5.2, “Mathematical Functions”
LOAD DATA
and replication, Section 16.3.1.12, “Replication and LOAD DATA
LOAD DATA FROM MASTER, Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
LOAD INDEX INTO CACHE
and partitioning, Section 18.5, “Restrictions and Limitations on Partitioning”
LOAD TABLE FROM MASTER, Section 12.6.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
LOAD_FILE(), Section 11.4, “String Functions”
LOCALTIME, Section 11.6, “Date and Time Functions”
LOCALTIMESTAMP, Section 11.6, “Date and Time Functions”
LOCATE(), Section 11.4, “String Functions”
LOG(), Section 11.5.2, “Mathematical Functions”
LOG10(), Section 11.5.2, “Mathematical Functions”
LOG2(), Section 11.5.2, “Mathematical Functions”
LONG data type, Section 10.4.3, “The BLOB and TEXT Types”
LONGBLOB data type, Section 10.1.3, “Overview of String Types”
LONGTEXT data type, Section 10.1.3, “Overview of String Types”
LOWER(), Section 11.4, “String Functions”
LPAD(), Section 11.4, “String Functions”
LTRIM(), Section 11.4, “String Functions”
LineFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
LineFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
LineString(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
LineStringFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
LineStringFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
language support
error messages, Section 9.3, “Setting the Error Message Language”
last row
unique ID, Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
ledir option
mysqld_safe, Description
legal names, Section 8.2, “Schema Object Names”
length option
myisam_ftdump, Description
less than (<), Section 11.2.3, “Comparison Functions and Operators”
less than or equal (<=), Section 11.2.3, “Comparison Functions and Operators”
libmysqld, Section 21.9, “libmysqld, the Embedded MySQL Server Library”
options, Section 21.9.3, “Options with the Embedded Server”
library
mysqlclient, Chapter 21, Connectors and APIs
mysqld, Chapter 21, Connectors and APIs
limitations
MySQL Limitations, Section D.7, “Limits in MySQL”
replication, Section 16.3.1, “Replication Features and Issues”
limits
MySQL Limits, limits in MySQL, Section D.7, “Limits in MySQL”
line-numbers option
mysql, Section 4.5.1.1, “mysql Options”
linear hash partitioning, Section 18.2.3.1, “LINEAR HASH Partitioning”
linear key partitioning, Section 18.2.4, “KEY Partitioning”
linefeed (\n), Section 8.1.1, “Strings”
lines-terminated-by option
mysqldump, Description, Description
linking, Section 21.10.16, “Building Client Programs”
problems, Section 21.10.10.4, “Problems Linking with the C API”
list partitioning, Section 18.2.2, “LIST Partitioning”
list partitions
adding and dropping, Section 18.3.1, “Management of RANGE and LIST Partitions”
managing, Section 18.3.1, “Management of RANGE and LIST Partitions”
list-users option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
literals, Section 8.1, “Literal Values”
load emulation, Section 4.5.7, “mysqlslap — Load Emulation Client”
loading
tables, Section 3.3.3, “Loading Data into a Table”
local option
mysqlimport, Description
local-infile option
mysql, Section 4.5.1.1, “mysql Options”
mysqld, Section 5.3.3, “Security-Related mysqld Options”
local-load option
mysqlbinlog, Description
localization, Chapter 9, Internationalization and Localization
lock option
ndb_select_all, Description
lock-all-tables option
mysqldump, Description
lock-directory option
mysqlslap, Description
lock-tables option
mysqldump, Description
mysqlimport, Description
locking
external, Section 6.4.1, “Using myisamchk for Crash Recovery”
log
changes, Appendix C, MySQL Change History
log files (MySQL Cluster), Description
ndbmtd, Description
log option
mysqld_multi, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
log-error option
mysqld_safe, Description
mysqldump, Description
logging commands (MySQL Cluster), Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
logical operators, Section 11.2.4, “Logical Operators”
loops option
ndb_show_tables, Description
low-priority option
mysqlimport, Description

M

MAKEDATE(), Section 11.6, “Date and Time Functions”
MAKETIME(), Section 11.6, “Date and Time Functions”
MAKE_SET(), Section 11.4, “String Functions”
MASTER_POS_WAIT(), Section 12.6.2.4, “MASTER_POS_WAIT() Syntax”, Section 11.11.4, “Miscellaneous Functions”
MATCH ... AGAINST(), Section 11.8, “Full-Text Search Functions”
MAX(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
MAX(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
MAX_CONNECTIONS_PER_HOUR, Section 5.5.4, “Limiting Account Resources”
MAX_QUERIES_PER_HOUR, Section 5.5.4, “Limiting Account Resources”
MAX_UPDATES_PER_HOUR, Section 5.5.4, “Limiting Account Resources”
MAX_USER_CONNECTIONS, Section 5.5.4, “Limiting Account Resources”
MBR, Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBRContains(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBRDisjoint(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBREqual(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBRIntersects(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBROverlaps(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBRTouches(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MBRWithin(), Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MD5(), Section 11.11.2, “Encryption and Compression Functions”
MEDIUMBLOB data type, Section 10.1.3, “Overview of String Types”
MEDIUMINT data type, Section 10.1.1, “Overview of Numeric Types”
MEDIUMTEXT data type, Section 10.1.3, “Overview of String Types”
MEMORY storage engine, Chapter 13, Storage Engines, Section 13.9, “The MEMORY (HEAP) Storage Engine”
and replication, Section 16.3.1.16, “Replication with MEMORY Tables”
MERGE storage engine, Chapter 13, Storage Engines
MICROSECOND(), Section 11.6, “Date and Time Functions”
MID(), Section 11.4, “String Functions”
MIN(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
MIN(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
MINUTE(), Section 11.6, “Date and Time Functions”
MLineFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
MLineFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
MOD (modulo), Section 11.5.2, “Mathematical Functions”
MOD(), Section 11.5.2, “Mathematical Functions”
MONTH(), Section 11.6, “Date and Time Functions”
MONTHNAME(), Section 11.6, “Date and Time Functions”
MPointFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
MPointFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
MPolyFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
MPolyFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
MULTILINESTRING data type, Section 11.13.4.1, “MySQL Spatial Data Types”
MULTIPOINT data type, Section 11.13.4.1, “MySQL Spatial Data Types”
MULTIPOLYGON data type, Section 11.13.4.1, “MySQL Spatial Data Types”
MYSQL C type, Section 21.10.1, “C API Data Types”
MYSQL_BIND C type, Section 21.10.5, “C API Prepared Statement Data types”
MYSQL_DEBUG environment variable, Section 22.5.2, “Debugging a MySQL Client”, Section 2.14, “Environment Variables”
MYSQL_FIELD C type, Section 21.10.1, “C API Data Types”
MYSQL_FIELD_OFFSET C type, Section 21.10.1, “C API Data Types”
MYSQL_GROUP_SUFFIX environment variable, Section 2.14, “Environment Variables”
MYSQL_HISTFILE environment variable, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
MYSQL_HOME environment variable, Section 2.14, “Environment Variables”
MYSQL_HOST environment variable, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
MYSQL_PS1 environment variable, Section 2.14, “Environment Variables”
MYSQL_PWD environment variable, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
MYSQL_RES C type, Section 21.10.1, “C API Data Types”
MYSQL_ROW C type, Section 21.10.1, “C API Data Types”
MYSQL_STMT C type, Section 21.10.5, “C API Prepared Statement Data types”
MYSQL_TCP_PORT environment variable, Section 5.6.2, “Running Multiple Servers on Unix”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 2.14, “Environment Variables”
MYSQL_TIME C type, Section 21.10.5, “C API Prepared Statement Data types”
MYSQL_UNIX_PORT environment variable, Section 5.6.2, “Running Multiple Servers on Unix”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 2.14, “Environment Variables”
Mac OS X, Section 21.1, “MySQL Connector/ODBC”
MaxNoOfExecutionThreads
ndbmtd, Description
Minimum Bounding Rectangle, Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
MultiLineString(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
MultiLineStringFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
MultiLineStringFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
MultiPoint(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
MultiPointFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
MultiPointFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
MultiPolygon(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
MultiPolygonFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
MultiPolygonFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
MyISAM
compressed tables, Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”, Section 13.5.3.3, “Compressed Table Characteristics”
MyISAM storage engine, Section 13.5, “The MyISAM Storage Engine”, Chapter 13, Storage Engines
MyODBC, Section 21.1, “MySQL Connector/ODBC”
MySQL Cluster
<errortext>Table is full</errortext> error, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
<foreignphrase>vs</foreignphrase> replication, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
API node, Section 17.1.1, “MySQL Cluster Core Concepts”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
CHECKPOINT Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
CLUSTERLOG STATISTICS command, Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
CLUSTERLOG commands, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
CONNECTION Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
CREATE NODEGROUP command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
DROP NODEGROUP command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ENTER SINGLE USER MODE command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ERROR Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
EXIT SINGLE USER MODE command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
EXIT command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
FAQ, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
HELP command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
HostName parameter
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
INFO Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
NODERESTART Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
QUIT command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
REPORT command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
RESTART command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SCI (Scalable Coherent Interface), Section 17.11.1, “Configuring MySQL Cluster to use SCI Sockets”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SHOW command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SHUTDOWN command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SQL node, Section 17.1.1, “MySQL Cluster Core Concepts”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SQL nodes, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SQL statements, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
SQL statements for monitoring, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
START command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
STARTUP Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
STATISTICS Events, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
STATUS command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
STOP command, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
administration, Section 17.6.24.4, “Program Options for ndb_mgm, Section 17.6.24.5, “Program Options for ndbd_redo_log_reader, Section 17.6.24.2, “Program Options for ndbd and ndbmtd, Description, Section 17.6.24.3, “Program Options for ndb_mgmd, Description, Section 17.7.2, “Commands in the MySQL Cluster Management Client”, Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”, Description, Section 17.6.23, “Options Common to MySQL Cluster Programs”, Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and DNS, Section 17.2, “MySQL Cluster Multi-Computer How-To”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and INFORMATION_SCHEMA, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and IP addressing, Section 17.2, “MySQL Cluster Multi-Computer How-To”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and MySQL privileges, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and MySQL root user, Section 17.8.2, “MySQL Cluster and MySQL Privileges”, Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and networking, Section 17.2.1, “MySQL Cluster Hardware, Software, and Networking Requirements”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and transactions, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
arbitrator, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
backups, Section 17.7.3.1, “MySQL Cluster Backup Concepts”, Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”, Section 17.7.3.4, “MySQL Cluster Backup Troubleshooting”, Section 17.7.3, “Online Backup of MySQL Cluster”, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
benchmarks, Section 17.11.2, “MySQL Cluster Interconnects and Performance”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
cluster logs, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”, Section 17.7.4, “Event Reports Generated in MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
commands, Section 17.6.24.4, “Program Options for ndb_mgm, Section 17.6.24.2, “Program Options for ndbd and ndbmtd, Description, Section 17.6.24.3, “Program Options for ndb_mgmd, Description, Section 17.7.2, “Commands in the MySQL Cluster Management Client”, Description, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
compiling with icc, Section 22.5, “Debugging and Porting MySQL”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
concepts, Section 17.1.1, “MySQL Cluster Core Concepts”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
configuration, Description, Section 17.2, “MySQL Cluster Multi-Computer How-To”, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
configuration files, Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
configuring, Section 17.7.3.3, “Configuration for MySQL Cluster Backups”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
data node, Section 17.1.1, “MySQL Cluster Core Concepts”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
data nodes, Section 17.6.2, “ndbd — The MySQL Cluster Data Node Daemon”, Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
data types supported, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
error logs, Description
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
error messages, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
event log format, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
event logging thresholds, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
event logs, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”, Section 17.7.4, “Event Reports Generated in MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
event severity levels, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
event types, Section 17.7.4, “Event Reports Generated in MySQL Cluster”, Section 17.7.4.2, “MySQL Cluster Log Events”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
general description, Section 17.1, “MySQL Cluster Overview”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
hardware requirements, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
how to obtain, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
importing existing tables, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
insecurity of communication protocols, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
installation, Section 17.2.2, “MySQL Cluster Multi-Computer Installation”, Section 17.2, “MySQL Cluster Multi-Computer How-To”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
interconnects, Section 17.11, “Using High-Speed Interconnects with MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
log files, Description, Description
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
logging commands, Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
management client (ndb_mgm), Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
management commands, Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
management node, Section 17.1.1, “MySQL Cluster Core Concepts”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
management nodes, Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
managing, Section 17.7, “Management of MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
master node, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
memory requirements, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mgm, Section 17.6.23, “Options Common to MySQL Cluster Programs”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mgm client, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mgm management client, Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mgm process, Description, Section 17.6.24.4, “Program Options for ndb_mgm
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mgmd, Section 17.6.23, “Options Common to MySQL Cluster Programs”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mgmd process, Description, Section 17.6.24.3, “Program Options for ndb_mgmd
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
mysqld process, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_config, Section 17.6.24.6, “Program Options for ndb_config
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_error_reporter, Section 17.6.24.7, “Program Options for ndb_error_reporter
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_mgm, Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”, Section 17.2.4, “Initial Startup of MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_mgmd process, Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_restore, Section 17.6.24.8, “Program Options for ndb_restore
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_show_tables, Section 17.6.24.9, “Program Options for ndb_show_tables
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_size.pl, Section 17.6.24.10, “Program Options for ndb_size.pl
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndb_size.pl (utility), Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndbd, Section 17.6.2, “ndbd — The MySQL Cluster Data Node Daemon”, Section 17.6.23, “Options Common to MySQL Cluster Programs”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndbd process, Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”, Section 17.6.24.2, “Program Options for ndbd and ndbmtd, Description
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndbd_redo_log_reader, Section 17.6.24.5, “Program Options for ndbd_redo_log_reader
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
ndbmtd, Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
network configuration
and security, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
network transporters, Section 17.11.1, “Configuring MySQL Cluster to use SCI Sockets”, Section 17.11, “Using High-Speed Interconnects with MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking requirements, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
node failure (single user mode), Section 17.7.6, “MySQL Cluster Single User Mode”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
node logs, Section 17.7.4, “Event Reports Generated in MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
node types, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
nodes and node groups, Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
nodes and types, Section 17.1.1, “MySQL Cluster Core Concepts”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
number of computers required, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
obtaining, Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
partitions, Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
performance, Section 17.11.2, “MySQL Cluster Interconnects and Performance”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
performing queries, Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
platforms supported, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
process management, Section 17.6, “MySQL Cluster Programs”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
programs, Section 17.6.24.9, “Program Options for ndb_show_tables, Section 17.6.24.8, “Program Options for ndb_restore, Section 17.6.24.6, “Program Options for ndb_config, Section 17.6.24.7, “Program Options for ndb_error_reporter, Section 17.6.24.5, “Program Options for ndbd_redo_log_reader, Section 17.6.24.10, “Program Options for ndb_size.pl
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
replicas, Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
requirements, Section 17.2.1, “MySQL Cluster Hardware, Software, and Networking Requirements”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
restarting, Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
restoring backups, Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
roles of computers, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
runtime statistics, Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
security, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”, Section 17.8, “MySQL Cluster Security Issues”
and HostName parameter, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and firewalls, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network configuration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and network ports, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
and remote administration, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
networking, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
security procedures, Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
shutting down, Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
single user mode, Section 17.7.6, “MySQL Cluster Single User Mode”, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
start phases (summary), Section 17.7.1, “Summary of MySQL Cluster Start Phases”
starting and stopping, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
starting nodes, Section 17.2.4, “Initial Startup of MySQL Cluster”
starting or restarting, Section 17.7.1, “Summary of MySQL Cluster Start Phases”
storage requirements, Section 10.5, “Data Type Storage Requirements”
terminology, Section 17.14, “MySQL Cluster Glossary”
trace files, Description
troubleshooting backups, Section 17.7.3.4, “MySQL Cluster Backup Troubleshooting”
using in a virtual machine, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
using tables and data, Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
MySQL Cluster Glossary, Section 17.14, “MySQL Cluster Glossary”
MySQL Cluster How-To, Section 17.2, “MySQL Cluster Multi-Computer How-To”
MySQL Cluster processes, Section 17.6, “MySQL Cluster Programs”
MySQL Cluster programs, Section 17.6, “MySQL Cluster Programs”
MySQL Instance Manager, Section 4.6.10, “mysqlmanager — The MySQL Instance Manager”
MySQL privileges
and MySQL Cluster, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
MySQL server
mysqld, Section 4.3.1, “mysqld — The MySQL Server”
MySQL storage engines, Chapter 13, Storage Engines
MySQL system tables
and MySQL Cluster, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
and replication, Section 16.3.1.17, “Replication of the System mysql Database”
MySQL++, Section 21.13, “MySQL C++ API”
mSQL compatibility, Section 11.4.2, “Regular Expressions”
maintaining
tables, Section 6.4.6, “Setting Up a Table Maintenance Schedule”
maintenance
tables, Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
malicious SQL statements
and MySQL Cluster, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
management client (MySQL Cluster), Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”
management node (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
management nodes (MySQL Cluster), Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
managing MySQL Cluster, Section 17.7, “Management of MySQL Cluster”
managing MySQL Cluster processes, Section 17.6, “MySQL Cluster Programs”
manual
syntax conventions, Section 1.2, “Typographical and Syntax Conventions”
typographical conventions, Section 1.2, “Typographical and Syntax Conventions”
master-data option
mysqldump, Description
matching
patterns, Section 3.3.4.7, “Pattern Matching”
mathematical functions, Section 11.5.2, “Mathematical Functions”
max-record-length option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
max_allowed_packet variable, Section 4.5.1.1, “mysql Options”
max_join_size variable, Section 4.5.1.1, “mysql Options”
maximum memory used, Description
maximums
maximum columns per table, Section D.7.2, “The Maximum Number of Columns Per Table”
maximum tables per join, Section D.7.1, “Limits of Joins”
medium-check option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
mysqlcheck, Description
memory usage
myisamchk, Section 4.6.3.5, “myisamchk Memory Usage”
memory use, Description
metadata
database, Chapter 20, INFORMATION_SCHEMA Tables
stored routines, Section 19.2.3, “Stored Routine Metadata”
triggers, Section 19.3.2, “Trigger Metadata”
views, Section 19.5.4, “View Metadata”
method option
mysqlhotcopy, Description
mgmd (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
minus
unary (-), Section 11.5.1, “Arithmetic Operators”
miscellaneous functions, Section 11.11.4, “Miscellaneous Functions”
modes
batch, Section 3.5, “Using mysql in Batch Mode”
modulo (%), Section 11.5.2, “Mathematical Functions”
modulo (MOD), Section 11.5.2, “Mathematical Functions”
monitor
terminal, Chapter 3, Tutorial
monitoring-interval option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
multi mysqld, Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
multi-byte characters, Section 9.4.3, “Multi-Byte Character Support”
multiple servers, Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
multiplication (*), Section 11.5.1, “Arithmetic Operators”
my.cnf
and MySQL Cluster, Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
in MySQL Cluster, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
my.cnf file, Section 16.3.1, “Replication Features and Issues”
my_bool C type, Section 21.10.1, “C API Data Types”
my_bool values
printing, Section 21.10.1, “C API Data Types”
my_init(), Section 21.10.8.1, “my_init()
my_ulonglong C type, Section 21.10.1, “C API Data Types”
my_ulonglong values
printing, Section 21.10.1, “C API Data Types”
myisam-recover option
mysqld, Section 13.5.1, “MyISAM Startup Options”
myisam_block_size myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
myisam_ftdump, Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
count option, Description
dump option, Description
help option, Description
length option, Description
stats option, Description
verbose option, Description
myisamchk, Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
HELP option, Section 4.6.3.1, “myisamchk General Options”
analyze option, Section 4.6.3.4, “Other myisamchk Options”
backup option, Section 4.6.3.3, “myisamchk Repair Options”
block-search option, Section 4.6.3.4, “Other myisamchk Options”
character-sets-dir option, Section 4.6.3.3, “myisamchk Repair Options”
check option, Section 4.6.3.2, “myisamchk Check Options”
check-only-changed option, Section 4.6.3.2, “myisamchk Check Options”
correct-checksum option, Section 4.6.3.3, “myisamchk Repair Options”
data-file-length option, Section 4.6.3.3, “myisamchk Repair Options”
debug option, Section 4.6.3.1, “myisamchk General Options”
description option, Section 4.6.3.4, “Other myisamchk Options”
example output, Section 6.4.5, “Getting Information About a Table”
extend-check option, Section 4.6.3.3, “myisamchk Repair Options”, Section 4.6.3.2, “myisamchk Check Options”
fast option, Section 4.6.3.2, “myisamchk Check Options”
force option, Section 4.6.3.3, “myisamchk Repair Options”, Section 4.6.3.2, “myisamchk Check Options”
help option, Section 4.6.3.1, “myisamchk General Options”
information option, Section 4.6.3.2, “myisamchk Check Options”
keys-used option, Section 4.6.3.3, “myisamchk Repair Options”
max-record-length option, Section 4.6.3.3, “myisamchk Repair Options”
medium-check option, Section 4.6.3.2, “myisamchk Check Options”
no-symlinks option, Section 4.6.3.3, “myisamchk Repair Options”
options, Section 4.6.3.1, “myisamchk General Options”
parallel-recover option, Section 4.6.3.3, “myisamchk Repair Options”
quick option, Section 4.6.3.3, “myisamchk Repair Options”
read-only option, Section 4.6.3.2, “myisamchk Check Options”
recover option, Section 4.6.3.3, “myisamchk Repair Options”
safe-recover option, Section 4.6.3.3, “myisamchk Repair Options”
set-auto-increment[ option, Section 4.6.3.4, “Other myisamchk Options”
set-character-set option, Section 4.6.3.3, “myisamchk Repair Options”
set-collation option, Section 4.6.3.3, “myisamchk Repair Options”
silent option, Section 4.6.3.1, “myisamchk General Options”
sort-index option, Section 4.6.3.4, “Other myisamchk Options”
sort-records option, Section 4.6.3.4, “Other myisamchk Options”
sort-recover option, Section 4.6.3.3, “myisamchk Repair Options”
tmpdir option, Section 4.6.3.3, “myisamchk Repair Options”
unpack option, Section 4.6.3.3, “myisamchk Repair Options”
update-state option, Section 4.6.3.2, “myisamchk Check Options”
verbose option, Section 4.6.3.1, “myisamchk General Options”
version option, Section 4.6.3.1, “myisamchk General Options”
wait option, Section 4.6.3.1, “myisamchk General Options”
myisamlog, Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
myisampack, Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”, Section 13.5.3.3, “Compressed Table Characteristics”
backup option, Description
character-sets-dir option, Description
debug option, Description
force option, Description
help option, Description
join option, Description
silent option, Description
test option, Description
tmpdir option, Description
verbose option, Description
version option, Description
wait option, Description
mysql, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
SSL options, Section 4.5.1.1, “mysql Options”
auto-rehash option, Section 4.5.1.1, “mysql Options”
batch option, Section 4.5.1.1, “mysql Options”
character-sets-dir option, Section 4.5.1.1, “mysql Options”
charset command, Section 4.5.1.2, “mysql Commands”
clear command, Section 4.5.1.2, “mysql Commands”
column-names option, Section 4.5.1.1, “mysql Options”
column-type-info option, Section 4.5.1.1, “mysql Options”
comments option, Section 4.5.1.1, “mysql Options”
compress option, Section 4.5.1.1, “mysql Options”
connect command, Section 4.5.1.2, “mysql Commands”
database option, Section 4.5.1.1, “mysql Options”
debug option, Section 4.5.1.1, “mysql Options”
debug-check option, Section 4.5.1.1, “mysql Options”
debug-info option, Section 4.5.1.1, “mysql Options”
default-character-set option, Section 4.5.1.1, “mysql Options”
delimiter command, Section 4.5.1.2, “mysql Commands”
delimiter option, Section 4.5.1.1, “mysql Options”
disable named commands, Section 4.5.1.1, “mysql Options”
edit command, Section 4.5.1.2, “mysql Commands”
ego command, Section 4.5.1.2, “mysql Commands”
execute option, Section 4.5.1.1, “mysql Options”
exit command, Section 4.5.1.2, “mysql Commands”
force option, Section 4.5.1.1, “mysql Options”
go command, Section 4.5.1.2, “mysql Commands”
help command, Section 4.5.1.2, “mysql Commands”
help option, Section 4.5.1.1, “mysql Options”
host option, Section 4.5.1.1, “mysql Options”
html option, Section 4.5.1.1, “mysql Options”
i-am-a-dummy option, Section 4.5.1.1, “mysql Options”
ignore-spaces option, Section 4.5.1.1, “mysql Options”
line-numbers option, Section 4.5.1.1, “mysql Options”
local-infile option, Section 4.5.1.1, “mysql Options”
named-commands option, Section 4.5.1.1, “mysql Options”
no-auto-rehash option, Section 4.5.1.1, “mysql Options”
no-beep option, Section 4.5.1.1, “mysql Options”
no-named-commands option, Section 4.5.1.1, “mysql Options”
no-pager option, Section 4.5.1.1, “mysql Options”
no-tee option, Section 4.5.1.1, “mysql Options”
nopager command, Section 4.5.1.2, “mysql Commands”
notee command, Section 4.5.1.2, “mysql Commands”
nowarning command, Section 4.5.1.2, “mysql Commands”
one-database option, Section 4.5.1.1, “mysql Options”
pager command, Section 4.5.1.2, “mysql Commands”
pager option, Section 4.5.1.1, “mysql Options”
password option, Section 4.5.1.1, “mysql Options”
pipe option, Section 4.5.1.1, “mysql Options”
port option, Section 4.5.1.1, “mysql Options”
print command, Section 4.5.1.2, “mysql Commands”
prompt command, Section 4.5.1.2, “mysql Commands”
prompt option, Section 4.5.1.1, “mysql Options”
protocol option, Section 4.5.1.1, “mysql Options”
quick option, Section 4.5.1.1, “mysql Options”
quit command, Section 4.5.1.2, “mysql Commands”
raw option, Section 4.5.1.1, “mysql Options”
reconnect option, Section 4.5.1.1, “mysql Options”
rehash command, Section 4.5.1.2, “mysql Commands”
safe-updates option, Section 4.5.1.1, “mysql Options”
secure-auth option, Section 4.5.1.1, “mysql Options”
show-warnings option, Section 4.5.1.1, “mysql Options”
sigint-ignore option, Section 4.5.1.1, “mysql Options”
silent option, Section 4.5.1.1, “mysql Options”
skip-column-names option, Section 4.5.1.1, “mysql Options”
skip-line-numbers option, Section 4.5.1.1, “mysql Options”
socket option, Section 4.5.1.1, “mysql Options”
source command, Section 4.5.1.2, “mysql Commands”
status command, Section 4.5.1.2, “mysql Commands”
system command, Section 4.5.1.2, “mysql Commands”
table option, Section 4.5.1.1, “mysql Options”
tee command, Section 4.5.1.2, “mysql Commands”
tee option, Section 4.5.1.1, “mysql Options”
unbuffered option, Section 4.5.1.1, “mysql Options”
use command, Section 4.5.1.2, “mysql Commands”
user option, Section 4.5.1.1, “mysql Options”
verbose option, Section 4.5.1.1, “mysql Options”
version option, Section 4.5.1.1, “mysql Options”
vertical option, Section 4.5.1.1, “mysql Options”
wait option, Section 4.5.1.1, “mysql Options”
warnings command, Section 4.5.1.2, “mysql Commands”
xml option, Section 4.5.1.1, “mysql Options”
mysql \. (command for reading from text files), Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
mysql command options, Section 4.5.1.1, “mysql Options”
mysql commands
list of, Section 4.5.1.2, “mysql Commands”
mysql history file, Section 4.5.1.1, “mysql Options”
mysql prompt command, Section 4.5.1.2, “mysql Commands”
mysql source (command for reading from text files), Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
mysql.server, Section 4.3.3, “mysql.server — MySQL Server Startup Script”
basedir option, Description
datadir option, Description
pid-file option, Description
service-startup-timeout option, Description
use-manager option, Description
use-mysqld_safe option, Description
user option, Description
mysql_affected_rows(), Section 21.10.3.1, “mysql_affected_rows()
mysql_autocommit(), Section 21.10.3.2, “mysql_autocommit()
mysql_change_user(), Section 21.10.3.3, “mysql_change_user()
mysql_character_set_name(), Section 21.10.3.4, “mysql_character_set_name()
mysql_close(), Section 21.10.3.5, “mysql_close()
mysql_commit(), Section 21.10.3.6, “mysql_commit()
mysql_connect(), Section 21.10.3.7, “mysql_connect()
mysql_create_db(), Section 21.10.3.8, “mysql_create_db()
mysql_data_seek(), Section 21.10.3.9, “mysql_data_seek()
mysql_debug(), Section 21.10.3.10, “mysql_debug()
mysql_drop_db(), Section 21.10.3.11, “mysql_drop_db()
mysql_dump_debug_info(), Section 21.10.3.12, “mysql_dump_debug_info()
mysql_eof(), Section 21.10.3.13, “mysql_eof()
mysql_errno(), Section 21.10.3.14, “mysql_errno()
mysql_error(), Section 21.10.3.15, “mysql_error()
mysql_escape_string(), Section 21.10.3.16, “mysql_escape_string()
mysql_fetch_field(), Section 21.10.3.17, “mysql_fetch_field()
mysql_fetch_field_direct(), Section 21.10.3.18, “mysql_fetch_field_direct()
mysql_fetch_fields(), Section 21.10.3.19, “mysql_fetch_fields()
mysql_fetch_lengths(), Section 21.10.3.20, “mysql_fetch_lengths()
mysql_fetch_row(), Section 21.10.3.21, “mysql_fetch_row()
mysql_field_count(), Section 21.10.3.22, “mysql_field_count(), Section 21.10.3.47, “mysql_num_fields()
mysql_field_seek(), Section 21.10.3.23, “mysql_field_seek()
mysql_field_tell(), Section 21.10.3.24, “mysql_field_tell()
mysql_free_result(), Section 21.10.3.25, “mysql_free_result()
mysql_get_character_set_info(), Section 21.10.3.26, “mysql_get_character_set_info()
mysql_get_client_info(), Section 21.10.3.27, “mysql_get_client_info()
mysql_get_client_version(), Section 21.10.3.28, “mysql_get_client_version()
mysql_get_host_info(), Section 21.10.3.29, “mysql_get_host_info()
mysql_get_proto_info(), Section 21.10.3.30, “mysql_get_proto_info()
mysql_get_server_info(), Section 21.10.3.31, “mysql_get_server_info()
mysql_get_server_version(), Section 21.10.3.32, “mysql_get_server_version()
mysql_get_ssl_cipher(), Section 21.10.3.33, “mysql_get_ssl_cipher()
mysql_hex_string(), Section 21.10.3.34, “mysql_hex_string()
mysql_info(), Section 21.10.3.35, “mysql_info()
mysql_init(), Section 21.10.3.36, “mysql_init()
mysql_insert_id(), Section 21.10.3.37, “mysql_insert_id()
mysql_kill(), Section 21.10.3.38, “mysql_kill()
mysql_library_end(), Section 21.10.3.39, “mysql_library_end()
mysql_library_init(), Section 21.10.3.40, “mysql_library_init()
mysql_list_dbs(), Section 21.10.3.41, “mysql_list_dbs()
mysql_list_fields(), Section 21.10.3.42, “mysql_list_fields()
mysql_list_processes(), Section 21.10.3.43, “mysql_list_processes()
mysql_list_tables(), Section 21.10.3.44, “mysql_list_tables()
mysql_more_results(), Section 21.10.3.45, “mysql_more_results()
mysql_next_result(), Section 21.10.3.46, “mysql_next_result()
mysql_num_fields(), Section 21.10.3.47, “mysql_num_fields()
mysql_num_rows(), Section 21.10.3.48, “mysql_num_rows()
mysql_options(), Section 21.10.3.49, “mysql_options()
mysql_ping(), Section 21.10.3.50, “mysql_ping()
mysql_query(), Section 21.10.10, “Common Questions and Problems When Using the C API”, Section 21.10.3.51, “mysql_query()
mysql_real_connect(), Section 21.10.3.52, “mysql_real_connect()
mysql_real_escape_string(), Section 21.10.3.53, “mysql_real_escape_string(), Section 8.1.1, “Strings”
mysql_real_query(), Section 21.10.3.54, “mysql_real_query()
mysql_refresh(), Section 21.10.3.55, “mysql_refresh()
mysql_reload(), Section 21.10.3.56, “mysql_reload()
mysql_rollback(), Section 21.10.3.57, “mysql_rollback()
mysql_row_seek(), Section 21.10.3.58, “mysql_row_seek()
mysql_row_tell(), Section 21.10.3.59, “mysql_row_tell()
mysql_select_db(), Section 21.10.3.60, “mysql_select_db()
mysql_server_end(), Section 21.10.9.2, “mysql_server_end()
mysql_server_init(), Section 21.10.9.1, “mysql_server_init()
mysql_set_character_set(), Section 21.10.3.61, “mysql_set_character_set()
mysql_set_local_infile_default(), Section 21.10.3.62, “mysql_set_local_infile_default()
mysql_set_server_option(), Section 21.10.3.64, “mysql_set_server_option()
mysql_shutdown(), Section 21.10.3.65, “mysql_shutdown()
mysql_sqlstate(), Section 21.10.3.66, “mysql_sqlstate()
mysql_ssl_set(), Section 21.10.3.67, “mysql_ssl_set()
mysql_stat(), Section 21.10.3.68, “mysql_stat()
mysql_stmt_affected_rows(), Section 21.10.7.1, “mysql_stmt_affected_rows()
mysql_stmt_attr_get(), Section 21.10.7.2, “mysql_stmt_attr_get()
mysql_stmt_attr_set(), Section 21.10.7.3, “mysql_stmt_attr_set()
mysql_stmt_bind_param(), Section 21.10.7.4, “mysql_stmt_bind_param()
mysql_stmt_bind_result(), Section 21.10.7.5, “mysql_stmt_bind_result()
mysql_stmt_close(), Section 21.10.7.6, “mysql_stmt_close()
mysql_stmt_data_seek(), Section 21.10.7.7, “mysql_stmt_data_seek()
mysql_stmt_errno(), Section 21.10.7.8, “mysql_stmt_errno()
mysql_stmt_error(), Section 21.10.7.9, “mysql_stmt_error()
mysql_stmt_execute(), Section 21.10.7.10, “mysql_stmt_execute()
mysql_stmt_fetch(), Section 21.10.7.11, “mysql_stmt_fetch()
mysql_stmt_fetch_column(), Section 21.10.7.12, “mysql_stmt_fetch_column()
mysql_stmt_field_count(), Section 21.10.7.13, “mysql_stmt_field_count()
mysql_stmt_free_result(), Section 21.10.7.14, “mysql_stmt_free_result()
mysql_stmt_init(), Section 21.10.7.15, “mysql_stmt_init()
mysql_stmt_insert_id(), Section 21.10.7.16, “mysql_stmt_insert_id()
mysql_stmt_num_rows(), Section 21.10.7.17, “mysql_stmt_num_rows()
mysql_stmt_param_count(), Section 21.10.7.18, “mysql_stmt_param_count()
mysql_stmt_param_metadata(), Section 21.10.7.19, “mysql_stmt_param_metadata()
mysql_stmt_prepare(), Section 21.10.7.20, “mysql_stmt_prepare()
mysql_stmt_reset(), Section 21.10.7.21, “mysql_stmt_reset()
mysql_stmt_result_metadata, Section 21.10.7.22, “mysql_stmt_result_metadata()
mysql_stmt_row_seek(), Section 21.10.7.23, “mysql_stmt_row_seek()
mysql_stmt_row_tell(), Section 21.10.7.24, “mysql_stmt_row_tell()
mysql_stmt_send_long_data(), Section 21.10.7.25, “mysql_stmt_send_long_data()
mysql_stmt_sqlstate(), Section 21.10.7.26, “mysql_stmt_sqlstate()
mysql_stmt_store_result(), Section 21.10.7.27, “mysql_stmt_store_result()
mysql_store_result(), Section 21.10.3.69, “mysql_store_result(), Section 21.10.10, “Common Questions and Problems When Using the C API”
mysql_thread_end(), Section 21.10.8.2, “mysql_thread_end()
mysql_thread_id(), Section 21.10.3.70, “mysql_thread_id()
mysql_thread_init(), Section 21.10.8.3, “mysql_thread_init()
mysql_thread_safe(), Section 21.10.8.4, “mysql_thread_safe()
mysql_use_result(), Section 21.10.3.71, “mysql_use_result()
mysql_warning_count(), Section 21.10.3.72, “mysql_warning_count()
mysqlaccess, Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
brief option, Description
commit option, Description
copy option, Description
db option, Description
debug option, Description
help option, Description
host option, Description
howto option, Description
old_server option, Description
password option, Description
plan option, Description
preview option, Description
relnotes option, Description
rhost option, Description
rollback option, Description
spassword option, Description
superuser option, Description
table option, Description
user option, Description
version option, Description
mysqladmin, Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
SSL options, Description
character-sets-dir option, Description
compress option, Description
count option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
default-character-set option, Description
force option, Description
help option, Description
host option, Description
no-beep option, Description
password option, Description
pipe option, Description
port option, Description
protocol option, Description
relative option, Description
silent option, Description
sleep option, Description
socket option, Description
user option, Description
verbose option, Description
version option, Description
vertical option, Description
wait option, Description
mysqladmin command options, Description
mysqladmin option
mysqld_multi, Description
mysqlbinlog, Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
base64-output option, Description
character-sets-dir option, Description
database option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
disable-log-bin option, Description
force-read option, Description
help option, Description
hexdump option, Description
host option, Description
local-load option, Description
offset option, Description
password option, Description
port option, Description
position option, Description
protocol option, Description
read-from-remote-server option, Description
result-file option, Description
server-id option, Description
set-charset option, Description
short-form option, Description
socket option, Description
start-datetime option, Description
start-position option, Description
stop-datetime option, Description
stop-position option, Description
to-last-log option, Description
user option, Description
verbose option, Description
version option, Description
write-binlog option, Description
mysqlbug script, Section 1.6, “How to Report Bugs or Problems”
mysqlcheck, Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
SSL options, Description
all-databases option, Description
all-in-1 option, Description
analyze option, Description
auto-repair option, Description
character-sets-dir option, Description
check option, Description
check-only-changed option, Description
check-upgrade option, Description
compress option, Description
databases option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
default-character-set option, Description
extended option, Description
fast option, Description
fix-db-names option, Description
fix-table-names option, Description
force option, Description
help option, Description
host option, Description
medium-check option, Description
optimize option, Description
password option, Description
pipe option, Description
port option, Description
protocol option, Description
quick option, Description
repair option, Description
silent option, Description
socket option, Description
tables option, Description
use-frm option, Description
user option, Description
verbose option, Description
version option, Description
mysqlclient library, Chapter 21, Connectors and APIs
mysqld
MySQL server, Section 4.3.1, “mysqld — The MySQL Server”
SSL options, Section 5.3.3, “Security-Related mysqld Options”
allow-suspicious-udfs option, Section 5.3.3, “Security-Related mysqld Options”
as MySQL Cluster process, Section 17.6.1, “MySQL Server Usage for MySQL Cluster”, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
delay-key-write option, Section 13.5.1, “MyISAM Startup Options”
local-infile option, Section 5.3.3, “Security-Related mysqld Options”
myisam-recover option, Section 13.5.1, “MyISAM Startup Options”
ndb-batch-size option, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb-cluster-connection-pool option, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb-connectstring option, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb-nodeid, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndbcluster option, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
old-passwords option, Section 5.3.3, “Security-Related mysqld Options”
role in MySQL Cluster, Section 17.1.1, “MySQL Cluster Core Concepts”
safe-show-database option, Section 5.3.3, “Security-Related mysqld Options”
safe-user-create option, Section 5.3.3, “Security-Related mysqld Options”
secure-auth option, Section 5.3.3, “Security-Related mysqld Options”
secure-file-priv option, Section 5.3.3, “Security-Related mysqld Options”
skip-grant-tables option, Section 5.3.3, “Security-Related mysqld Options”
skip-merge option, Section 5.3.3, “Security-Related mysqld Options”
skip-name-resolve option, Section 5.3.3, “Security-Related mysqld Options”
skip-ndbcluster option, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
skip-networking option, Section 5.3.3, “Security-Related mysqld Options”
skip-show-database option, Section 5.3.3, “Security-Related mysqld Options”
starting, Section 5.3.5, “How to Run MySQL as a Normal User”
mysqld (MySQL Cluster), Section 17.6, “MySQL Cluster Programs”
mysqld library, Chapter 21, Connectors and APIs
mysqld option
mysqld_multi, Description
mysqld_safe, Description
mysqld-safe-compatible option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqld-version option
mysqld_safe, Description
mysqld_multi, Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
config-file option, Description
defaults-extra-file option, Description
defaults-file option, Description
example option, Description
help option, Description
log option, Description
mysqladmin option, Description
mysqld option, Description
no-defaults option, Description
no-log option, Description
password option, Description
silent option, Description
tcp-ip option, Description
user option, Description
verbose option, Description
version option, Description
mysqld_safe, Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
autoclose option, Description
basedir option, Description
core-file-size option, Description
datadir option, Description
defaults-extra-file option, Description
defaults-file option, Description
help option, Description
ledir option, Description
log-error option, Description
mysqld option, Description
mysqld-version option, Description
nice option, Description
no-defaults option, Description
open-files-limit option, Description
pid-file option, Description
port option, Description
skip-kill-mysqld option, Description
skip-syslog option, Description
socket option, Description
syslog option, Description
syslog-tag option, Description
timezone option, Description
user option, Description
mysqldump, Section 4.5.4, “mysqldump — A Database Backup Program”
SSL options, Description
add-drop-database option, Description
add-drop-table option, Description
add-locks option, Description
all-databases option, Description
all-tablespaces option, Description
allow-keywords option, Description
character-sets-dir option, Description
comments option, Description
compact option, Description
compatible option, Description
complete-insert option, Description
compress option, Description
create-options option, Description
databases option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
default-character-set option, Description
delayed-insert option, Description
delete-master-logs option, Description
disable-keys option, Description
dump-date option, Description
events option, Description
extended-insert option, Description
fields-enclosed-by option, Description, Description
fields-escaped-by option, Description, Description
fields-optionally-enclosed-by option, Description, Description
fields-terminated-by option, Description, Description
first-slave option, Description
flush-logs option, Description
flush-privileges option, Description
force option, Description
help option, Description
hex-blob option, Description
host option, Description
ignore-table option, Description
insert-ignore option, Description
lines-terminated-by option, Description, Description
lock-all-tables option, Description
lock-tables option, Description
log-error option, Description
master-data option, Description
no-autocommit option, Description
no-create-db option, Description
no-create-info option, Description
no-data option, Description
no-set-names option, Description
opt option, Description
order-by-primary option, Description
password option, Description
pipe option, Description
port option, Description
problems, Section D.4, “Restrictions on Views”, Description
protocol option, Description
quick option, Description
quote-names option, Description
replace option, Description
result-file option, Description
routines option, Description
set-charset option, Description
single-transaction option, Description
skip-comments option, Description
skip-opt option, Description
socket option, Description
tab option, Description
tables option, Description
triggers option, Description
tz-utc option, Description
user option, Description
verbose option, Description
version option, Description
views, Section D.4, “Restrictions on Views”, Description
where option, Description
workarounds, Section D.4, “Restrictions on Views”, Description
xml option, Description
mysqldumpslow, Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
debug option, Description
help option, Description
verbose option, Description
mysqlhotcopy, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
addtodest option, Description
allowold option, Description
checkpoint option, Description
chroot option, Description
debug option, Description
dryrun option, Description
flushlog option, Description
help option, Description
host option, Description
keepold option, Description
method option, Description
noindices option, Description
password option, Description
port option, Description
quiet option, Description
record_log_pos option, Description
regexp option, Description
resetmaster option, Description
resetslave option, Description
socket option, Description
suffix option, Description
tmpdir option, Description
user option, Description
mysqlimport, Section 4.5.5, “mysqlimport — A Data Import Program”
SSL options, Description
character-sets-dir option, Description
columns option, Description
compress option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
default-character-set option, Description
delete option, Description
force option, Description
help option, Description
host option, Description
ignore option, Description
ignore-lines option, Description
local option, Description
lock-tables option, Description
low-priority option, Description
password option, Description
pipe option, Description
port option, Description
protocol option, Description
replace option, Description
silent option, Description
socket option, Description
use-threads option, Description
user option, Description
verbose option, Description
version option, Description
mysqlmanager, Section 4.6.10, “mysqlmanager — The MySQL Instance Manager”
add-user option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
angel-pid-file option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
bind-address option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
check-password-file option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
clean-password-file option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
debug option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
default-mysqld-path option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
defaults-file option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
drop-user option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
edit-user option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
help option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
install option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
list-users option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
log option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
monitoring-interval option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqld-safe-compatible option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
password option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
password-file option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
pid-file option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
port option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
print-defaults option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
print-password-line option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
remove option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
run-as-service option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
socket option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
standalone option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
user option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
username option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
version option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
wait-timeout option, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
SSL options, Description
character-sets-dir option, Description
compress option, Description
count option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
default-character-set option, Description
help option, Description
host option, Description
keys option, Description
password option, Description
pipe option, Description
port option, Description
protocol option, Description
show-table-type option, Description
socket option, Description
status option, Description
user option, Description
verbose option, Description
version option, Description
mysqlslap, Section 4.5.7, “mysqlslap — Load Emulation Client”
SSL options, Description
auto-generate-sql option, Description
auto-generate-sql-add-autoincrement option, Description
auto-generate-sql-execute-number option, Description
auto-generate-sql-guid-primary option, Description
auto-generate-sql-load-type option, Description
auto-generate-sql-secondary-indexes option, Description
auto-generate-sql-unique-query-number option, Description
auto-generate-sql-unique-write-number option, Description
auto-generate-sql-write-number option, Description
commit option, Description
compress option, Description
concurrency option, Description
create option, Description
create-schema option, Description
csv option, Description
debug option, Description
debug-check option, Description
debug-info option, Description
delimiter option, Description
detach option, Description
engine option, Description
help option, Description
host option, Description
iterations option, Description
lock-directory option, Description
number-char-cols option, Description
number-int-cols option, Description
number-of-queries option, Description
only-print option, Description
password option, Description
pipe option, Description
port option, Description
post-query option, Description
post-system option, Description
pre-query option, Description
pre-system option, Description
preserve-schema option, Description
protocol option, Description
query option, Description
shared-memory-base-name option, Description
silent option, Description
slave option, Description
socket option, Description
use-threads option, Description
user option, Description
verbose option, Description
version option, Description
mysqltest
MySQL Test Suite, Section 22.1.2, “MySQL Test Suite”

N

NAME_CONST(), Section 11.11.4, “Miscellaneous Functions”, Section 19.6, “Binary Logging of Stored Programs”
NATIONAL CHAR data type, Section 10.1.3, “Overview of String Types”
NATIONAL VARCHAR data type, Section 10.1.3, “Overview of String Types”
NCHAR data type, Section 10.1.3, “Overview of String Types”
NDB, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
NDB storage engine
FAQ, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
NDB tables
and MySQL root user, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
NDB utilities
security issues, Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
NDBCLUSTER, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
NODERESTART Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
NOT
logical, Section 11.2.4, “Logical Operators”
NOT BETWEEN, Section 11.2.3, “Comparison Functions and Operators”
NOT IN, Section 11.2.3, “Comparison Functions and Operators”
NOT LIKE, Section 11.4.1, “String Comparison Functions”
NOT REGEXP, Section 11.4.2, “Regular Expressions”
NOW(), Section 11.6, “Date and Time Functions”
NOWAIT (START BACKUP command), Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
NUL, Section 8.1.1, “Strings”
NULL, Section 3.3.4.6, “Working with NULL Values”
testing for null, Section 11.3, “Control Flow Functions”, Section 11.2.3, “Comparison Functions and Operators”
NULL value, Section 8.1.6, “NULL Values”, Section 3.3.4.6, “Working with NULL Values”
NULLIF(), Section 11.3, “Control Flow Functions”
NUMERIC data type, Section 10.1.1, “Overview of Numeric Types”
NVARCHAR data type, Section 10.1.3, “Overview of String Types”
NumGeometries(), Section 11.13.5.2.7, “GeometryCollection Functions”
NumInteriorRings(), Section 11.13.5.2.5, “Polygon Functions”
NumPoints(), Section 11.13.5.2.3, “LineString Functions”
named-commands option
mysql, Section 4.5.1.1, “mysql Options”
names, Section 8.2, “Schema Object Names”
case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
variables, Section 8.4, “User-Defined Variables”
native backup and restore
backup identifiers, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
native functions
adding, Section 22.3.3, “Adding a New Native Function”
ndb-batch-size option
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb-cluster-connection-pool option
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb-connectstring option
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb_config, Description
ndb-nodeid option
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndb_config, Section 17.6.24.6, “Program Options for ndb_config, Section 17.6.6, “ndb_config — Extract MySQL Cluster Configuration Information”, Section 17.6, “MySQL Cluster Programs”
config-file option, Description
configinfo option, Description
fields option, Description
host option, Description
id option, Description
ndb-connectstring option, Description
nodeid option, Description
nodes option, Description
query option, Description
rows option, Description
type option, Description
usage option, Description
version option, Description
xml option, Description
ndb_cpcd, Section 17.6.7, “ndb_cpcd — Automate Testing for NDB Development”, Section 17.6, “MySQL Cluster Programs”
ndb_delete_all, Section 17.6.8, “ndb_delete_all — Delete All Rows from an NDB Table”, Section 17.6, “MySQL Cluster Programs”
transactional option, Description
ndb_desc, Section 17.6.9, “ndb_desc — Describe NDB Tables”, Section 17.6, “MySQL Cluster Programs”
extra-partition-info option, Description
ndb_drop_index, Section 17.6, “MySQL Cluster Programs”, Section 17.6.10, “ndb_drop_index — Drop Index from an NDB Table”
ndb_drop_table, Section 17.6, “MySQL Cluster Programs”, Section 17.6.11, “ndb_drop_table — Drop an NDB Table”
ndb_error_reporter, Section 17.6.12, “ndb_error_reporter — NDB Error-Reporting Utility”, Section 17.6, “MySQL Cluster Programs”, Section 17.6.24.7, “Program Options for ndb_error_reporter
ndb_mgm, Section 17.6, “MySQL Cluster Programs”, Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”
ndb_mgm (MySQL Cluster management node client), Section 17.2.4, “Initial Startup of MySQL Cluster”
ndb_mgmd, Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”, Section 17.6, “MySQL Cluster Programs”
ndb_mgmd (MySQL Cluster process), Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
ndb_mgmd (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
ndb_print_backup_file, Section 17.6, “MySQL Cluster Programs”, Section 17.6.13, “ndb_print_backup_file — Print NDB Backup File Contents”
ndb_print_schema_file, Section 17.6.14, “ndb_print_schema_file — Print NDB Schema File Contents”, Section 17.6, “MySQL Cluster Programs”
ndb_print_sys_file, Section 17.6, “MySQL Cluster Programs”, Section 17.6.15, “ndb_print_sys_file — Print NDB System File Contents”
ndb_restore, Section 17.6.24.8, “Program Options for ndb_restore, Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”
attribute promotion, Description
errors, Description
ndb_select_all, Section 17.6, “MySQL Cluster Programs”, Section 17.6.18, “ndb_select_all — Print Rows from an NDB Table”
delimiter option, Description
descending option, Description
disk option, Description
gci option, Description
header option, Description
lock option, Description
nodata option, Description
order option, Description
rowid option, Description
tupscan option, Description
useHexFormat option, Description
ndb_select_count, Section 17.6.19, “ndb_select_count — Print Row Counts for NDB Tables”, Section 17.6, “MySQL Cluster Programs”
ndb_show_tables, Section 17.6.24.9, “Program Options for ndb_show_tables, Section 17.6.20, “ndb_show_tables — Display List of NDB Tables”, Section 17.6, “MySQL Cluster Programs”
loops option, Description
parsable option, Description
type option, Description
unqualified option, Description
ndb_size.pl, Section 17.6.21, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”, Section 17.6, “MySQL Cluster Programs”, Section 17.6.24.10, “Program Options for ndb_size.pl
ndb_size.pl (utility), Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
ndb_waiter, Section 17.6, “MySQL Cluster Programs”, Section 17.6.22, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”
no-contact option, Description
not-started option, Description
timeout option, Description
ndbcluster option
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
ndbd, Section 17.6.2, “ndbd — The MySQL Cluster Data Node Daemon”, Section 17.6, “MySQL Cluster Programs”
ndbd (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
ndbd_redo_log_reader, Section 17.6.16, “ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log”, Section 17.6.24.5, “Program Options for ndbd_redo_log_reader
ndbmtd, Section 17.6, “MySQL Cluster Programs”, Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”
MaxNoOfExecutionThreads, Description
trace files, Description
negative values, Section 8.1.2, “Numbers”
net_buffer_length variable, Section 4.5.1.1, “mysql Options”
network ports
and MySQL Cluster, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
new procedures
adding, Section 22.4, “Adding New Procedures to MySQL”
newline (\n), Section 8.1.1, “Strings”
nice option
mysqld_safe, Description
no-auto-rehash option
mysql, Section 4.5.1.1, “mysql Options”
no-autocommit option
mysqldump, Description
no-beep option
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
no-contact option
ndb_waiter, Description
no-create-db option
mysqldump, Description
no-create-info option
mysqldump, Description
no-data option
mysqldump, Description
no-defaults option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
mysqld_multi, Description
mysqld_safe, Description
no-log option
mysqld_multi, Description
no-named-commands option
mysql, Section 4.5.1.1, “mysql Options”
no-pager option
mysql, Section 4.5.1.1, “mysql Options”
no-set-names option
mysqldump, Description
no-symlinks option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
no-tee option
mysql, Section 4.5.1.1, “mysql Options”
nodata option
ndb_select_all, Description
node groups (MySQL Cluster), Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
node logs (MySQL Cluster), Section 17.7.4, “Event Reports Generated in MySQL Cluster”
nodeid option
ndb_config, Description
nodes option
ndb_config, Description
noindices option
mysqlhotcopy, Description
nondelimited strings, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
nopager command
mysql, Section 4.5.1.2, “mysql Commands”
not equal (!=), Section 11.2.3, “Comparison Functions and Operators”
not equal (<>), Section 11.2.3, “Comparison Functions and Operators”
not-started option
ndb_waiter, Description
notee command
mysql, Section 4.5.1.2, “mysql Commands”
nowarning command
mysql, Section 4.5.1.2, “mysql Commands”
number-char-cols option
mysqlslap, Description
number-int-cols option
mysqlslap, Description
number-of-queries option
mysqlslap, Description
numbers, Section 8.1.2, “Numbers”
numeric types, Section 10.5, “Data Type Storage Requirements”

O

OCT(), Section 11.5.2, “Mathematical Functions”
OCTET_LENGTH(), Section 11.4, “String Functions”
ODBC, Section 21.1, “MySQL Connector/ODBC”
ODBC compatibility, Section 8.2.1, “Identifier Qualifiers”, Section 10.1.1, “Overview of Numeric Types”, Section 11.2.3, “Comparison Functions and Operators”, Section 11.2.2, “Type Conversion in Expression Evaluation”
OLAP, Section 11.12.2, “GROUP BY Modifiers”
OLD_PASSWORD(), Section 11.11.2, “Encryption and Compression Functions”
ONLY_FULL_GROUP_BY
SQL mode, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
OPTIMIZE TABLE
and partitioning, Section 18.3.3, “Maintenance of Partitions”
OR, Section 3.6.7, “Searching on Two Keys”
bitwise, Section 11.11.1, “Bit Functions”
logical, Section 11.2.4, “Logical Operators”
ORD(), Section 11.4, “String Functions”
ORDER BY, Section 3.3.4.4, “Sorting Rows”
Obtaining MySQL Cluster, Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
OpenGIS, Section 11.13.1, “Introduction to MySQL Spatial Support”
OpenSSL, Section 5.5.7.2, “Using SSL Connections”, Section 5.5.7, “Using SSL for Secure Connections”
Oracle compatibility, Section 11.12.1, “GROUP BY (Aggregate) Functions”, Section 12.3.1, “DESCRIBE Syntax”
Overlaps(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
obtaining information about partitions, Section 18.3.4, “Obtaining Information About Partitions”
offset option
mysqlbinlog, Description
old-passwords option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
old_server option
mysqlaccess, Description
one-database option
mysql, Section 4.5.1.1, “mysql Options”
only-print option
mysqlslap, Description
open tables, Description
open-files-limit option
mysqld_safe, Description
open_files_limit variable, Description
opens, Description
operations
arithmetic, Section 11.5.1, “Arithmetic Operators”
operators, Chapter 11, Functions and Operators
assignment, Section 8.4, “User-Defined Variables”
cast, Section 11.9, “Cast Functions and Operators”, Section 11.5.1, “Arithmetic Operators”
logical, Section 11.2.4, “Logical Operators”
precedence, Section 11.2.1, “Operator Precedence”
opt option
mysqldump, Description
optimize option
mysqlcheck, Description
optimizer
and replication, Section 16.3.1.18, “Replication and the Query Optimizer”
optimizing
tables, Section 6.4.4, “Table Optimization”
option files, Section 4.2.3.3, “Using Option Files”
option modifiers, Section 4.2.3.2, “Program Option Modifiers”
options
boolean, Section 4.2.3.2, “Program Option Modifiers”
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
command-line
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
embedded server, Section 21.9.3, “Options with the Embedded Server”
libmysqld, Section 21.9.3, “Options with the Embedded Server”
myisamchk, Section 4.6.3.1, “myisamchk General Options”
provided by MySQL, Chapter 3, Tutorial
replication, Section 16.3.1, “Replication Features and Issues”
order option
ndb_select_all, Description
order-by-primary option
mysqldump, Description

P

PARTITION, Chapter 18, Partitioning
PARTITIONS
INFORMATION_SCHEMA table, Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
PASSWORD(), Section 5.5.5, “Assigning Account Passwords”, Section 11.11.2, “Encryption and Compression Functions”
PATH environment variable, Section 2.14, “Environment Variables”, Section 4.2.1, “Invoking MySQL Programs”
PERIOD_ADD(), Section 11.6, “Date and Time Functions”
PERIOD_DIFF(), Section 11.6, “Date and Time Functions”
PHP API, Section 21.11, “MySQL PHP API”
PI(), Section 11.5.2, “Mathematical Functions”
PLUGINS
INFORMATION_SCHEMA table, Section 20.17, “The INFORMATION_SCHEMA PLUGINS Table”
POINT data type, Section 11.13.4.1, “MySQL Spatial Data Types”
POLYGON data type, Section 11.13.4.1, “MySQL Spatial Data Types”
POSITION(), Section 11.4, “String Functions”
POW(), Section 11.5.2, “Mathematical Functions”
POWER(), Section 11.5.2, “Mathematical Functions”
PREPARE, Section 12.7, “SQL Syntax for Prepared Statements”, Section 12.7.1, “PREPARE Syntax”
PROCESSLIST
INFORMATION_SCHEMA table, Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”
PROFILING
INFORMATION_SCHEMA table, Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”
PURGE BINARY LOGS, Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
PURGE MASTER LOGS, Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
PURGE STALE SESSIONS, Section 17.7.1, “Summary of MySQL Cluster Start Phases”
Partitioning
maximum number of partitions, Section 18.5, “Restrictions and Limitations on Partitioning”
Perl API, Section 21.12, “MySQL Perl API”
Point(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
PointFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
PointFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
PointN(), Section 11.13.5.2.3, “LineString Functions”
PointOnSurface(), Section 11.13.5.2.6, “MultiPolygon Functions”
PolyFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
PolyFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
Polygon(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
PolygonFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
PolygonFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
Python API, Section 21.14, “MySQL Python API”
pager command
mysql, Section 4.5.1.2, “mysql Commands”
pager option
mysql, Section 4.5.1.1, “mysql Options”
parallel-recover option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
parentheses ( and ), Section 11.2.1, “Operator Precedence”
parsable option
ndb_show_tables, Description
partition management, Section 18.3, “Partition Management”
partition pruning, Section 18.4, “Partition Pruning”
partitioning, Chapter 18, Partitioning
advantages, Section 18.1, “Overview of Partitioning in MySQL”
and FULLTEXT indexes, Section 18.5, “Restrictions and Limitations on Partitioning”
and dates, Section 18.2, “Partition Types”
and foreign keys, Section 18.5, “Restrictions and Limitations on Partitioning”
and key cache, Section 18.5, “Restrictions and Limitations on Partitioning”
and server SQL mode, Section 18.5, “Restrictions and Limitations on Partitioning”
and subqueries, Section 18.5, “Restrictions and Limitations on Partitioning”
and temporary tables, Section 18.5.1, “Partitioning Keys, Primary Keys, and Unique Keys”, Section 18.5, “Restrictions and Limitations on Partitioning”
by hash, Section 18.2.3, “HASH Partitioning”
by key, Section 18.2.4, “KEY Partitioning”
by linear hash, Section 18.2.3.1, “LINEAR HASH Partitioning”
by linear key, Section 18.2.4, “KEY Partitioning”
by list, Section 18.2.2, “LIST Partitioning”
by range, Section 18.2.1, “RANGE Partitioning”
concepts, Section 18.1, “Overview of Partitioning in MySQL”
data type of partitioning key, Section 18.5, “Restrictions and Limitations on Partitioning”
enabling, Chapter 18, Partitioning
functions supported in partitioning expressions, Section 18.5.3, “Partitioning Limitations Relating to Functions”
limitations, Section 18.5, “Restrictions and Limitations on Partitioning”
operators disallowed in partitioning expressions, Section 18.5, “Restrictions and Limitations on Partitioning”
operators supported in partitioning expressions, Section 18.5, “Restrictions and Limitations on Partitioning”
optimization, Section 18.3.4, “Obtaining Information About Partitions”, Section 18.4, “Partition Pruning”
resources, Chapter 18, Partitioning
storage engines (limitations), Section 18.5.2, “Partitioning Limitations Relating to Storage Engines”
subpartitioning, Section 18.5, “Restrictions and Limitations on Partitioning”
support, Chapter 18, Partitioning
types, Section 18.2, “Partition Types”
partitioning information statements, Section 18.3.4, “Obtaining Information About Partitions”
partitioning keys and primary keys, Section 18.5.1, “Partitioning Keys, Primary Keys, and Unique Keys”
partitioning keys and unique keys, Section 18.5.1, “Partitioning Keys, Primary Keys, and Unique Keys”
partitions
adding and dropping, Section 18.3, “Partition Management”
analyzing, Section 18.3.3, “Maintenance of Partitions”
checking, Section 18.3.3, “Maintenance of Partitions”
managing, Section 18.3, “Partition Management”
modifying, Section 18.3, “Partition Management”
optimizing, Section 18.3.3, “Maintenance of Partitions”
repairing, Section 18.3.3, “Maintenance of Partitions”
splitting and merging, Section 18.3, “Partition Management”
partitions (MySQL Cluster), Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
password encryption
reversibility of, Section 11.11.2, “Encryption and Compression Functions”
password option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysqlaccess, Description
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_multi, Description
mysqldump, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
password-file option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
passwords
administrator guidelines, Section 5.5.6.1, “Administrator Guidelines for Password Security”
for users, Section 5.5.1, “User Names and Passwords”
hashing, Section 5.5.6.3, “Password Hashing in MySQL”
security, Section 5.5.6, “Password Security in MySQL”
setting, Section 5.5.5, “Assigning Account Passwords”
user guidelines, Section 5.5.6.2, “End-User Guidelines for Password Security”
pattern matching, Section 3.3.4.7, “Pattern Matching”, Section 11.4.2, “Regular Expressions”
performance
improving, Section 16.3.4, “Replication FAQ”
perror
--ndb option, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
pid-file option
mysql.server, Description
mysqld_safe, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
pipe option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Description, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
plan option
mysqlaccess, Description
plugin API, Section 22.2, “The MySQL Plugin Interface”
plugins
adding, Section 22.2, “The MySQL Plugin Interface”
point in time recovery, Section 6.3, “Point-in-Time Recovery”
port option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_safe, Description
mysqldump, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
portability
types, Section 10.7, “Using Data Types from Other Database Engines”
porting
to other systems, Section 22.5, “Debugging and Porting MySQL”
position option
mysqlbinlog, Description
post-install
multiple servers, Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
post-query option
mysqlslap, Description
post-system option
mysqlslap, Description
pre-query option
mysqlslap, Description
pre-system option
mysqlslap, Description
precedence
operator, Section 11.2.1, “Operator Precedence”
prepared statements, Section 12.7.2, “EXECUTE Syntax”, Section 21.10.4, “C API Prepared Statements”, Section 12.7, “SQL Syntax for Prepared Statements”, Section 12.7.3, “DEALLOCATE PREPARE Syntax”, Section 12.7.1, “PREPARE Syntax”
repreparation, Section 12.7.4, “Automatic Prepared Statement Repreparation”
preserve-schema option
mysqlslap, Description
preview option
mysqlaccess, Description
primary keys
and partitioning keys, Section 18.5.1, “Partitioning Keys, Primary Keys, and Unique Keys”
print command
mysql, Section 4.5.1.2, “mysql Commands”
print-defaults option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
print-password-line option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
privileges
adding, Section 5.5.2, “Adding User Accounts”
and replication, Section 16.3.1.17, “Replication of the System mysql Database”
deleting, Section 5.5.3, “Removing User Accounts”
dropping, Section 5.5.3, “Removing User Accounts”
problems
date values, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
reporting, Section 1.6, “How to Report Bugs or Problems”
procedures
adding, Section 22.4, “Adding New Procedures to MySQL”
stored, Section 19.2, “Using Stored Routines (Procedures and Functions)”
process management (MySQL Cluster), Section 17.6, “MySQL Cluster Programs”
processing
arguments, Section 22.3.2.3, “UDF Argument Processing”
program options (MySQL Cluster), Section 17.6.23, “Options Common to MySQL Cluster Programs”
ndb_config, Section 17.6.24.6, “Program Options for ndb_config
ndb_error_reporter, Section 17.6.24.7, “Program Options for ndb_error_reporter
ndb_restore, Section 17.6.24.8, “Program Options for ndb_restore
ndb_show_tables, Section 17.6.24.9, “Program Options for ndb_show_tables
ndb_size.pl, Section 17.6.24.10, “Program Options for ndb_size.pl
ndbd_redo_log_reader, Section 17.6.24.5, “Program Options for ndbd_redo_log_reader
program variables
setting, Section 4.2.3.4, “Using Options to Set Program Variables”
programs
client, Section 21.10.16, “Building Client Programs”
stored, Chapter 19, Stored Programs and Views
prompt command
mysql, Section 4.5.1.2, “mysql Commands”
prompt option
mysql, Section 4.5.1.1, “mysql Options”
prompts
meanings, Section 3.2, “Entering Queries”
protocol option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description

Q

QUARTER(), Section 11.6, “Date and Time Functions”
QUIT command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
QUOTE(), Section 11.4, “String Functions”
queries
Twin Studies project, Section 3.7, “Queries from the Twin Project”
entering, Section 3.2, “Entering Queries”
examples, Section 3.6, “Examples of Common Queries”
query option
mysqlslap, Description
ndb_config, Description
questions, Description
quick option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
mysql, Section 4.5.1.1, “mysql Options”
mysqlcheck, Description
mysqldump, Description
quiet option
mysqlhotcopy, Description
quit command
mysql, Section 4.5.1.2, “mysql Commands”
quote-names option
mysqldump, Description
quotes
in strings, Section 8.1.1, “Strings”
quoting, Section 8.1.1, “Strings”
quoting binary data, Section 8.1.1, “Strings”
quoting of identifiers, Section 8.2, “Schema Object Names”

R

RADIANS(), Section 11.5.2, “Mathematical Functions”
RAND(), Section 11.5.2, “Mathematical Functions”
REAL data type, Section 10.1.1, “Overview of Numeric Types”
REFERENTIAL_CONSTRAINTS
INFORMATION_SCHEMA table, Section 20.23, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
REGEXP, Section 11.4.2, “Regular Expressions”
REGEXP operator, Section 11.4.2, “Regular Expressions”
RELEASE_LOCK(), Section 11.11.4, “Miscellaneous Functions”
REPAIR TABLE
and partitioning, Section 18.3.3, “Maintenance of Partitions”
REPEAT(), Section 11.4, “String Functions”
REPLACE(), Section 11.4, “String Functions”
REPORT command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
RESET MASTER, Section 12.6.1.2, “RESET MASTER Syntax”
RESET SLAVE, Section 12.6.2.5, “RESET SLAVE Syntax”
RESTART command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
REVERSE(), Section 11.4, “String Functions”
RIGHT(), Section 11.4, “String Functions”
RLIKE, Section 11.4.2, “Regular Expressions”
ROLLUP, Section 11.12.2, “GROUP BY Modifiers”
ROUND(), Section 11.5.2, “Mathematical Functions”
ROUTINES
INFORMATION_SCHEMA table, Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
ROW_COUNT(), Section 11.11.3, “Information Functions”
RPAD(), Section 11.4, “String Functions”
RTRIM(), Section 11.4, “String Functions”
RTS-threads, Section 22.5.4, “Comments about RTS Threads”
Related(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
Ruby API, Section 21.15, “MySQL Ruby APIs”
range partitioning, Section 18.2.1, “RANGE Partitioning”
range partitions
adding and dropping, Section 18.3.1, “Management of RANGE and LIST Partitions”
managing, Section 18.3.1, “Management of RANGE and LIST Partitions”
raw option
mysql, Section 4.5.1.1, “mysql Options”
read-from-remote-server option
mysqlbinlog, Description
read-only option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
read_buffer_size myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
reconnect option
mysql, Section 4.5.1.1, “mysql Options”
record_log_pos option
mysqlhotcopy, Description
recover option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
recovery
from crash, Section 6.4.1, “Using myisamchk for Crash Recovery”
point in time, Section 6.3, “Point-in-Time Recovery”
regexp option
mysqlhotcopy, Description
regular expression syntax, Section 11.4.2, “Regular Expressions”
rehash command
mysql, Section 4.5.1.2, “mysql Commands”
relative option
mysqladmin, Description
relnotes option
mysqlaccess, Description
remote administration (MySQL Cluster)
and security issues, Section 17.8.1, “MySQL Cluster Security and Networking Issues”
remove option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
repair
tables, Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
repair option
mysqlcheck, Description
repair options
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
repairing
tables, Section 6.4.3, “How to Repair Tables”
replace option
mysqldump, Description
mysqlimport, Description
replicas (MySQL Cluster), Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
replication, Chapter 16, Replication
and AUTO_INCREMENT, Section 16.3.1.1, “Replication and AUTO_INCREMENT
and CREATE TABLE ... SELECT, Section 16.3.1.3, “Replication of CREATE TABLE ... SELECT Statements”
and DATA DIRECTORY, Section 16.3.1.5, “Replication and DIRECTORY Table Options”
and DROP ... IF EXISTS, Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”
and FLUSH, Section 16.3.1.9, “Replication and FLUSH
and INDEX DIRECTORY, Section 16.3.1.5, “Replication and DIRECTORY Table Options”
and LAST_INSERT_ID(), Section 16.3.1.1, “Replication and AUTO_INCREMENT
and LIMIT, Section 16.3.1.11, “Replication and LIMIT
and LOAD DATA, Section 16.3.1.12, “Replication and LOAD DATA
and MEMORY tables, Section 16.3.1.16, “Replication with MEMORY Tables”
and TIMESTAMP, Section 16.3.1.1, “Replication and AUTO_INCREMENT
and TRUNCATE, Section 16.3.1.27, “Replication and TRUNCATE
and character sets, Section 16.3.1.2, “Replication and Character Sets”
and errors on slave, Section 16.3.1.20, “Slave Errors during Replication”
and floating-point values, Section 16.3.1.8, “Replication with Floating-Point Values”
and functions, Section 16.3.1.10, “Replication and System Functions”
and invoked features, Section 16.3.1.7, “Replication of Invoked Features”
and mysql (system) database, Section 16.3.1.17, “Replication of the System mysql Database”
and partial updates, Section 16.3.1.25, “Replication and Transactions”
and privileges, Section 16.3.1.17, “Replication of the System mysql Database”
and query optimizer, Section 16.3.1.18, “Replication and the Query Optimizer”
and reserved words, Section 16.3.1.19, “Replication and Reserved Words”
and scheduled events, Section 16.3.1.7, “Replication of Invoked Features”
and slow query log, Section 16.3.1.13, “Replication and the Slow Query Log”
and stored routines, Section 16.3.1.7, “Replication of Invoked Features”
and temporary tables, Section 16.3.1.22, “Replication and Temporary Tables”
and time zones, Section 16.3.1.24, “Replication and Time Zones”
and transactions, Section 16.3.1.25, “Replication and Transactions”, Section 16.3.1.23, “Replication Retries and Timeouts”
and triggers, Section 16.3.1.26, “Replication and Triggers”, Section 16.3.1.7, “Replication of Invoked Features”
and variables, Section 16.3.1.28, “Replication and Variables”
and views, Section 16.3.1.29, “Replication and Views”
attribute promotion, Section 16.3.1.4.2, “Replication of Columns Having Different Data Types”
crashes, Section 16.3.1.14, “Replication During a Master Crash”
shutdown and restart, Section 16.3.1.21, “Replication during a Slave Shutdown”, Section 16.3.1.15, “Replication During a Master Shutdown”, Section 16.3.1.22, “Replication and Temporary Tables”
timeouts, Section 16.3.1.23, “Replication Retries and Timeouts”
with differing tables on master and slave, Section 16.3.1.4, “Replication with Differing Tables on Master and Slave”
replication implementation, Section 16.4, “Replication Implementation”
replication limitations, Section 16.3.1, “Replication Features and Issues”
replication masters, Section 16.3.1.14, “Replication During a Master Crash”
statements, Section 12.6.1, “SQL Statements for Controlling Master Servers”
replication options, Section 16.3.1, “Replication Features and Issues”
replication slaves
statements, Section 12.6.2, “SQL Statements for Controlling Slave Servers”
reporting
bugs, Section 1.6, “How to Report Bugs or Problems”
errors, Section 1.6, “How to Report Bugs or Problems”
reserved words, Section 8.3, “Reserved Words”
and replication, Section 16.3.1.19, “Replication and Reserved Words”
resetmaster option
mysqlhotcopy, Description
resetslave option
mysqlhotcopy, Description
restoring backups
in MySQL Cluster, Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”
restrictions
events, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
server-side cursors, Section D.2, “Restrictions on Server-Side Cursors”
stored routines, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
subqueries, Section D.3, “Restrictions on Subqueries”
triggers, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
views, Section D.4, “Restrictions on Views”
result-file option
mysqlbinlog, Description
mysqldump, Description
retrieving
data from tables, Section 3.3.4, “Retrieving Information from a Table”
return (\r), Section 8.1.1, “Strings”
return values
UDFs, Section 22.3.2.4, “UDF Return Values and Error Handling”
rhost option
mysqlaccess, Description
rollback option
mysqlaccess, Description
rounding errors, Section 10.1.1, “Overview of Numeric Types”
routines option
mysqldump, Description
rowid option
ndb_select_all, Description
rows
counting, Section 3.3.4.8, “Counting Rows”
selecting, Section 3.3.4.2, “Selecting Particular Rows”
sorting, Section 3.3.4.4, “Sorting Rows”
rows option
ndb_config, Description
run-as-service option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
running
batch mode, Section 3.5, “Using mysql in Batch Mode”
multiple servers, Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
queries, Section 3.2, “Entering Queries”

S

SCHEMA(), Section 11.11.3, “Information Functions”
SCHEMATA
INFORMATION_SCHEMA table, Section 20.1, “The INFORMATION_SCHEMA SCHEMATA Table”
SCHEMA_PRIVILEGES
INFORMATION_SCHEMA table, Section 20.6, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
SCI (Scalable Coherent Interface), Section 17.11.1, “Configuring MySQL Cluster to use SCI Sockets”
SECOND(), Section 11.6, “Date and Time Functions”
SEC_TO_TIME(), Section 11.6, “Date and Time Functions”
SELECT
optimizing, Section 12.3.2, “EXPLAIN Syntax”
SEQUENCE, Section 3.6.9, “Using AUTO_INCREMENT
SERIAL, Section 10.1.1, “Overview of Numeric Types”
SERIAL DEFAULT VALUE, Section 10.1.4, “Data Type Default Values”
SESSION_STATUS
INFORMATION_SCHEMA table, Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
SESSION_USER(), Section 11.11.3, “Information Functions”
SESSION_VARIABLES
INFORMATION_SCHEMA table, Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”
SET
CHARACTER SET, Section 9.1.4, “Connection Character Sets and Collations”
NAMES, Section 9.1.4, “Connection Character Sets and Collations”, Section 9.1.5, “Configuring the Character Set and Collation for Applications”
size, Section 10.5, “Data Type Storage Requirements”
SET GLOBAL SQL_SLAVE_SKIP_COUNTER, Section 12.6.2.6, “SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax”
SET PASSWORD statement, Section 5.5.5, “Assigning Account Passwords”
SET data type, Section 10.1.3, “Overview of String Types”, Section 10.4.5, “The SET Type”
SET sql_log_bin, Section 12.6.1.3, “SET sql_log_bin Syntax”
SHA(), Section 11.11.2, “Encryption and Compression Functions”
SHA1(), Section 11.11.2, “Encryption and Compression Functions”
SHOW ENGINE
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SHOW ENGINE NDB STATUS, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SHOW ENGINE NDBCLUSTER STATUS, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SHOW ENGINES
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SHOW ERRORS
and MySQL Cluster, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
SHOW STATUS
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SHOW VARIABLES
used with MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SHOW WARNINGS
and MySQL Cluster, Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
SHOW command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
SHOW extensions, Section 20.28, “Extensions to SHOW Statements”
SHOW with WHERE, Section 20.28, “Extensions to SHOW Statements”, Chapter 20, INFORMATION_SCHEMA Tables
SHUTDOWN command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
SIGN(), Section 11.5.2, “Mathematical Functions”
SIN(), Section 11.5.2, “Mathematical Functions”
SLEEP(), Section 11.11.4, “Miscellaneous Functions”
SMALLINT data type, Section 10.1.1, “Overview of Numeric Types”
SNAPSHOTEND (START BACKUP command), Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
SNAPSHOTSTART (START BACKUP command), Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
SOUNDEX(), Section 11.4, “String Functions”
SOUNDS LIKE, Section 11.4, “String Functions”
SPACE(), Section 11.4, “String Functions”
SQL mode
ONLY_FULL_GROUP_BY, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
SQL node (MySQL Cluster)
defined, Section 17.1.1, “MySQL Cluster Core Concepts”
SQL nodes (MySQL Cluster), Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
SQL scripts, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
SQL statements
replication masters, Section 12.6.1, “SQL Statements for Controlling Master Servers”
replication slaves, Section 12.6.2, “SQL Statements for Controlling Slave Servers”
SQL statements relating to MySQL Cluster, Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
SQL_SLAVE_SKIP_COUNTER, Section 12.6.2.6, “SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax”
SQRT(), Section 11.5.2, “Mathematical Functions”
SRID(), Section 11.13.5.2.1, “General Geometry Functions”
SSH, Section 5.5.8, “Connecting to MySQL Remotely from Windows with SSH”
SSL, Section 5.5.7.2, “Using SSL Connections”
SSL and X509 Basics, Section 5.5.7, “Using SSL for Secure Connections”
SSL command options, Section 5.5.7.3, “SSL Command Options”
SSL options, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlcheck, Description
mysqld, Section 5.3.3, “Security-Related mysqld Options”
mysqldump, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
START BACKUP
NOWAIT, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
SNAPSHOTEND, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
SNAPSHOTSTART, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
WAIT COMPLETED, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
WAIT STARTED, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
syntax, Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
START SLAVE, Section 12.6.2.7, “START SLAVE Syntax”
START command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
STARTUP Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
STATISTICS
INFORMATION_SCHEMA table, Section 20.4, “The INFORMATION_SCHEMA STATISTICS Table”
STATISTICS Events (MySQL Cluster), Section 17.7.4.2, “MySQL Cluster Log Events”
STATUS command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
STD(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
STDDEV(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
STDDEV_POP(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
STDDEV_SAMP(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
STOP SLAVE, Section 12.6.2.8, “STOP SLAVE Syntax”
STOP command (MySQL Cluster), Section 17.7.2, “Commands in the MySQL Cluster Management Client”
STRCMP(), Section 11.4.1, “String Comparison Functions”
STR_TO_DATE(), Section 11.6, “Date and Time Functions”
SUBDATE(), Section 11.6, “Date and Time Functions”
SUBSTR(), Section 11.4, “String Functions”
SUBSTRING(), Section 11.4, “String Functions”
SUBSTRING_INDEX(), Section 11.4, “String Functions”
SUBTIME(), Section 11.6, “Date and Time Functions”
SUM(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
SUM(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
SYSDATE(), Section 11.6, “Date and Time Functions”
SYSTEM_USER(), Section 11.11.3, “Information Functions”
Spatial Extensions in MySQL, Section 11.13.1, “Introduction to MySQL Spatial Support”
StartPoint(), Section 11.13.5.2.3, “LineString Functions”
Starting many servers, Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Sybase compatibility, Section 12.3.4, “USE Syntax”
SymDifference(), Section 11.13.5.3.2, “Spatial Operators”
safe-recover option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
safe-show-database option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
safe-updates option, Section 4.5.1.5.2, “Using the --safe-updates Option”
mysql, Section 4.5.1.1, “mysql Options”
safe-user-create option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
script files, Section 3.5, “Using mysql in Batch Mode”
scripts, Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”, Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
SQL, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
mysqlbug, Section 1.6, “How to Report Bugs or Problems”
searching
MySQL Web pages, Section 1.6, “How to Report Bugs or Problems”
full-text, Section 11.8, “Full-Text Search Functions”
two keys, Section 3.6.7, “Searching on Two Keys”
secure-auth option
mysql, Section 4.5.1.1, “mysql Options”
mysqld, Section 5.3.3, “Security-Related mysqld Options”
secure-file-priv option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
securing a MySQL Cluster, Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
security
against attackers, Section 5.3.2, “Making MySQL Secure Against Attackers”
and NDB utilities, Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
and malicious SQL statements, Section 17.8.2, “MySQL Cluster and MySQL Privileges”
select_limit variable, Section 4.5.1.1, “mysql Options”
selecting
databases, Section 3.3.1, “Creating and Selecting a Database”
sequence emulation, Section 11.11.3, “Information Functions”
sequences, Section 3.6.9, “Using AUTO_INCREMENT
server
connecting, Section 3.1, “Connecting to and Disconnecting from the Server”, Section 4.2.2, “Connecting to the MySQL Server”
debugging, Section 22.5.1, “Debugging a MySQL Server”
disconnecting, Section 3.1, “Connecting to and Disconnecting from the Server”
server administration, Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
server-id option
mysqlbinlog, Description
server-side cursor restrictions, Section D.2, “Restrictions on Server-Side Cursors”
servers
multiple, Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
service-startup-timeout option
mysql.server, Description
session variables
and replication, Section 16.3.1.28, “Replication and Variables”
set-auto-increment[ option
myisamchk, Section 4.6.3.4, “Other myisamchk Options”
set-character-set option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
set-charset option
mysqlbinlog, Description
mysqldump, Description
set-collation option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
setting
passwords, Section 5.5.5, “Assigning Account Passwords”
setting program variables, Section 4.2.3.4, “Using Options to Set Program Variables”
shared-memory-base-name option, Section 4.2.2, “Connecting to the MySQL Server”
mysqlslap, Description
shell syntax, Section 1.2, “Typographical and Syntax Conventions”
short-form option
mysqlbinlog, Description
show-table-type option
mysqlshow, Description
show-warnings option
mysql, Section 4.5.1.1, “mysql Options”
showing
database information, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
shutdown_timeout variable, Description
sigint-ignore option
mysql, Section 4.5.1.1, “mysql Options”
silent option
myisamchk, Section 4.6.3.1, “myisamchk General Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlcheck, Description
mysqld_multi, Description
mysqlimport, Description
mysqlslap, Description
single quote (\'), Section 8.1.1, “Strings”
single user mode (MySQL Cluster), Section 17.7.6, “MySQL Cluster Single User Mode”, Section 17.7.2, “Commands in the MySQL Cluster Management Client”
and ndb_restore, Description
single-transaction option
mysqldump, Description
sizes
display, Chapter 10, Data Types
skip-column-names option
mysql, Section 4.5.1.1, “mysql Options”
skip-comments option
mysqldump, Description
skip-grant-tables option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
skip-kill-mysqld option
mysqld_safe, Description
skip-line-numbers option
mysql, Section 4.5.1.1, “mysql Options”
skip-merge option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
skip-name-resolve option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
skip-ndbcluster option
mysqld, Section 17.4.2, “mysqld Command Options for MySQL Cluster”
skip-networking option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
skip-opt option
mysqldump, Description
skip-show-database option
mysqld, Section 5.3.3, “Security-Related mysqld Options”
skip-syslog option
mysqld_safe, Description
slave option
mysqlslap, Description
sleep option
mysqladmin, Description
slow queries, Description
slow query log
and replication, Section 16.3.1.13, “Replication and the Slow Query Log”
socket option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_safe, Description
mysqldump, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
sort-index option
myisamchk, Section 4.6.3.4, “Other myisamchk Options”
sort-records option
myisamchk, Section 4.6.3.4, “Other myisamchk Options”
sort-recover option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
sort_buffer_size myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
sort_key_blocks myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
sorting
character sets, Section 9.2, “The Character Set Used for Data and Sorting”
data, Section 3.3.4.4, “Sorting Rows”
table rows, Section 3.3.4.4, “Sorting Rows”
source (mysql client command), Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
source command
mysql, Section 4.5.1.2, “mysql Commands”
spassword option
mysqlaccess, Description
speed
increasing with replication, Chapter 16, Replication
square brackets, Chapter 10, Data Types
ssl option, Section 5.5.7.3, “SSL Command Options”
ssl-ca option, Section 5.5.7.3, “SSL Command Options”
ssl-capath option, Section 5.5.7.3, “SSL Command Options”
ssl-cert option, Section 5.5.7.3, “SSL Command Options”
ssl-cipher option, Section 5.5.7.3, “SSL Command Options”
ssl-key option, Section 5.5.7.3, “SSL Command Options”
ssl-verify-server-cert option, Section 5.5.7.3, “SSL Command Options”
standalone option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
start-datetime option
mysqlbinlog, Description
start-position option
mysqlbinlog, Description
starting
mysqld, Section 5.3.5, “How to Run MySQL as a Normal User”
startup options
default, Section 4.2.3.3, “Using Option Files”
startup parameters
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
statements
GRANT, Section 5.5.2, “Adding User Accounts”
INSERT, Section 5.5.2, “Adding User Accounts”
replication masters, Section 12.6.1, “SQL Statements for Controlling Master Servers”
replication slaves, Section 12.6.2, “SQL Statements for Controlling Slave Servers”
stats option
myisam_ftdump, Description
stats_method myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
status command
mysql, Section 4.5.1.2, “mysql Commands”
results, Description
status option
mysqlshow, Description
stop-datetime option
mysqlbinlog, Description
stop-position option
mysqlbinlog, Description
stopword list
user-defined, Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
storage engine
ARCHIVE, Section 13.12, “The ARCHIVE Storage Engine”
storage engines
choosing, Chapter 13, Storage Engines
storage nodes - see data nodes, ndbd, Section 17.6.2, “ndbd — The MySQL Cluster Data Node Daemon”
storage nodes - see data nodes, ndbd, ndbmtd, Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”
storage requirements
data type, Section 10.5, “Data Type Storage Requirements”
stored functions, Section 19.2, “Using Stored Routines (Procedures and Functions)”
stored procedures, Section 19.2, “Using Stored Routines (Procedures and Functions)”
stored programs, Chapter 19, Stored Programs and Views
stored routine restrictions, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
stored routines
LAST_INSERT_ID(), Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
and replication, Section 16.3.1.7, “Replication of Invoked Features”
metadata, Section 19.2.3, “Stored Routine Metadata”
string collating, Section 9.4.2, “String Collating Support”
string comparison functions, Section 11.4.1, “String Comparison Functions”
string comparisons
case sensitivity, Section 11.4.1, “String Comparison Functions”
string concatenation, Section 8.1.1, “Strings”, Section 11.4, “String Functions”
string functions, Section 11.4, “String Functions”
string literal introducer, Section 8.1.1, “Strings”, Section 9.1.3.5, “Character String Literal Character Set and Collation”
string types, Section 10.4, “String Types”
strings
defined, Section 8.1, “Literal Values”
escaping characters, Section 8.1, “Literal Values”
nondelimited, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
subpartitioning, Section 18.2.5, “Subpartitioning”
subpartitions, Section 18.2.5, “Subpartitioning”
subquery restrictions, Section D.3, “Restrictions on Subqueries”
subtraction (-), Section 11.5.1, “Arithmetic Operators”
suffix option
mysqlhotcopy, Description
superuser option
mysqlaccess, Description
syntax
regular expression, Section 11.4.2, “Regular Expressions”
syntax conventions, Section 1.2, “Typographical and Syntax Conventions”
syslog option
mysqld_safe, Description
syslog-tag option
mysqld_safe, Description
system
security, Section 5.3, “General Security Issues”
system command
mysql, Section 4.5.1.2, “mysql Commands”
system variables
and replication, Section 16.3.1.28, “Replication and Variables”

T

TABLES
INFORMATION_SCHEMA table, Section 20.2, “The INFORMATION_SCHEMA TABLES Table”
TABLE_PRIVILEGES
INFORMATION_SCHEMA table, Section 20.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
TAN(), Section 11.5.2, “Mathematical Functions”
TEXT
size, Section 10.5, “Data Type Storage Requirements”
TEXT columns
default values, Section 10.4.3, “The BLOB and TEXT Types”
TEXT data type, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
TIME data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.2, “The TIME Type”
TIME(), Section 11.6, “Date and Time Functions”
TIMEDIFF(), Section 11.6, “Date and Time Functions”
TIMESTAMP
and replication, Section 16.3.1.1, “Replication and AUTO_INCREMENT
TIMESTAMP data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
TIMESTAMP(), Section 11.6, “Date and Time Functions”
TIMESTAMPADD(), Section 11.6, “Date and Time Functions”
TIMESTAMPDIFF(), Section 11.6, “Date and Time Functions”
TIME_FORMAT(), Section 11.6, “Date and Time Functions”
TIME_TO_SEC(), Section 11.6, “Date and Time Functions”
TINYBLOB data type, Section 10.1.3, “Overview of String Types”
TINYINT data type, Section 10.1.1, “Overview of Numeric Types”
TINYTEXT data type, Section 10.1.3, “Overview of String Types”
TMPDIR environment variable, Section 2.14, “Environment Variables”
TO_DAYS(), Section 11.6, “Date and Time Functions”
TRIGGERS
INFORMATION_SCHEMA table, Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
TRIM(), Section 11.4, “String Functions”
TRUE, Section 8.1.4, “Boolean Values”, Section 8.1.2, “Numbers”
testing for, Section 11.2.3, “Comparison Functions and Operators”
TRUNCATE
and replication, Section 16.3.1.27, “Replication and TRUNCATE
TRUNCATE(), Section 11.5.2, “Mathematical Functions”
TZ environment variable, Section 2.14, “Environment Variables”
Tcl API, Section 21.16, “MySQL Tcl API”
Touches(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
Twin Studies
queries, Section 3.7, “Queries from the Twin Project”
tab (\t), Section 8.1.1, “Strings”
tab option
mysqldump, Description
table
row size, Section 10.5, “Data Type Storage Requirements”
table names
case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
table option
mysql, Section 4.5.1.1, “mysql Options”
mysqlaccess, Description
table types
choosing, Chapter 13, Storage Engines
tables
BLACKHOLE, Section 13.14, “The BLACKHOLE Storage Engine”
CSV, Section 13.13, “The CSV Storage Engine”
EXAMPLE, Section 13.10, “The EXAMPLE Storage Engine”
FEDERATED, Section 13.11, “The FEDERATED Storage Engine”
HEAP, Section 13.9, “The MEMORY (HEAP) Storage Engine”
MEMORY, Section 13.9, “The MEMORY (HEAP) Storage Engine”
MyISAM, Section 13.5, “The MyISAM Storage Engine”
checking, Section 4.6.3.2, “myisamchk Check Options”
compressed, Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
compressed format, Section 13.5.3.3, “Compressed Table Characteristics”
counting rows, Section 3.3.4.8, “Counting Rows”
creating, Section 3.3.2, “Creating a Table”
defragment, Section 13.5.3.2, “Dynamic Table Characteristics”
defragmenting, Section 6.4.6, “Setting Up a Table Maintenance Schedule”
displaying, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
dumping, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
dynamic, Section 13.5.3.2, “Dynamic Table Characteristics”
error checking, Section 6.4.2, “How to Check MyISAM Tables for Errors”
flush, Description
information, Section 6.4.5, “Getting Information About a Table”
information about, Section 3.4, “Getting Information About Databases and Tables”
loading data, Section 3.3.3, “Loading Data into a Table”
maintenance, Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
maintenance schedule, Section 6.4.6, “Setting Up a Table Maintenance Schedule”
multiple, Section 3.3.4.9, “Using More Than one Table”
names, Section 8.2, “Schema Object Names”
optimizing, Section 6.4.4, “Table Optimization”
repair, Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
repairing, Section 6.4.3, “How to Repair Tables”
retrieving data, Section 3.3.4, “Retrieving Information from a Table”
selecting columns, Section 3.3.4.3, “Selecting Particular Columns”
selecting rows, Section 3.3.4.2, “Selecting Particular Rows”
sorting rows, Section 3.3.4.4, “Sorting Rows”
unique ID for last row, Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
tables option
mysqlcheck, Description
mysqldump, Description
tcp-ip option
mysqld_multi, Description
tee command
mysql, Section 4.5.1.2, “mysql Commands”
tee option
mysql, Section 4.5.1.1, “mysql Options”
temporary tables
and replication, Section 16.3.1.22, “Replication and Temporary Tables”
terminal monitor
defined, Chapter 3, Tutorial
test option
myisampack, Description
testing mysqld
mysqltest, Section 22.1.2, “MySQL Test Suite”
text files
importing, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
thread packages
differences between, Section 22.5.5, “Differences Between Thread Packages”
threaded clients, Section 21.10.17, “How to Make a Threaded Client”
threads, Description, Section 22.1, “MySQL Internals”
RTS, Section 22.5.4, “Comments about RTS Threads”
time types, Section 10.5, “Data Type Storage Requirements”
time zones
and replication, Section 16.3.1.24, “Replication and Time Zones”
leap seconds, Section 9.7.2, “Time Zone Leap Second Support”
support, Section 9.7, “MySQL Server Time Zone Support”
upgrading, Section 9.7.1, “Staying Current with Time Zone Changes”
timeout, Section 11.11.4, “Miscellaneous Functions”
connect_timeout variable, Description, Section 4.5.1.1, “mysql Options”
shutdown_timeout variable, Description
timeout option
ndb_waiter, Description
timeouts (replication), Section 16.3.1.23, “Replication Retries and Timeouts”
timezone option
mysqld_safe, Description
tmpdir option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
myisampack, Description
mysqlhotcopy, Description
to-last-log option
mysqlbinlog, Description
tools
command-line, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
mysqld_multi, Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
mysqld_safe, Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
trace DBI method, Section 22.5.1.4, “Debugging mysqld under gdb
trace files
ndbmtd, Description
trace files (MySQL Cluster), Description
transactional option
ndb_delete_all, Description
transactions
and replication, Section 16.3.1.25, “Replication and Transactions”, Section 16.3.1.23, “Replication Retries and Timeouts”
trigger restrictions, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
triggers, Chapter 19, Stored Programs and Views, Section 19.3, “Using Triggers”
LAST_INSERT_ID(), Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
and replication, Section 16.3.1.26, “Replication and Triggers”, Section 16.3.1.7, “Replication of Invoked Features”
metadata, Section 19.3.2, “Trigger Metadata”
triggers option
mysqldump, Description
tupscan option
ndb_select_all, Description
tutorial, Chapter 3, Tutorial
type conversions, Section 11.2.3, “Comparison Functions and Operators”, Section 11.2.2, “Type Conversion in Expression Evaluation”
type option
ndb_config, Description
ndb_show_tables, Description
types
Date and Time, Section 10.3, “Date and Time Types”
column, Chapter 10, Data Types
columns, Section 10.6, “Choosing the Right Type for a Column”
data, Chapter 10, Data Types
date, Section 10.5, “Data Type Storage Requirements”
numeric, Section 10.5, “Data Type Storage Requirements”
of tables, Chapter 13, Storage Engines
portability, Section 10.7, “Using Data Types from Other Database Engines”
strings, Section 10.4, “String Types”
time, Section 10.5, “Data Type Storage Requirements”
typographical conventions, Section 1.2, “Typographical and Syntax Conventions”
tz-utc option
mysqldump, Description

U

UCASE(), Section 11.4, “String Functions”
UCS-2, Section 9.1, “Character Set Support”
UDFs
compiling, Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
defined, Section 22.3, “Adding New Functions to MySQL”
return values, Section 22.3.2.4, “UDF Return Values and Error Handling”
UMASK environment variable, Section 2.14, “Environment Variables”
UMASK_DIR environment variable, Section 2.14, “Environment Variables”
UNCOMPRESS(), Section 11.11.2, “Encryption and Compression Functions”
UNCOMPRESSED_LENGTH(), Section 11.11.2, “Encryption and Compression Functions”
UNHEX(), Section 11.4, “String Functions”
UNION, Section 3.6.7, “Searching on Two Keys”
UNIX_TIMESTAMP(), Section 11.6, “Date and Time Functions”
UNKNOWN
testing for, Section 11.2.3, “Comparison Functions and Operators”
UNSIGNED, Section 10.2, “Numeric Types”, Section 10.1.1, “Overview of Numeric Types”
UPPER(), Section 11.4, “String Functions”
USE, Section 12.3.4, “USE Syntax”
USER environment variable, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
USER(), Section 11.11.3, “Information Functions”
USER_PRIVILEGES
INFORMATION_SCHEMA table, Section 20.5, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”
UTC_DATE(), Section 11.6, “Date and Time Functions”
UTC_TIME(), Section 11.6, “Date and Time Functions”
UTC_TIMESTAMP(), Section 11.6, “Date and Time Functions”
UTF-8, Section 9.1, “Character Set Support”
UUID(), Section 11.11.4, “Miscellaneous Functions”
UUID_SHORT(), Section 11.11.4, “Miscellaneous Functions”
Unicode, Section 9.1, “Character Set Support”
Unicode Collation Algorithm, Section 9.1.12.1, “Unicode Character Sets”
Union(), Section 11.13.5.3.2, “Spatial Operators”
Unix, Section 21.1, “MySQL Connector/ODBC”
UpdateXML(), Section 11.10, “XML Functions”
unary minus (-), Section 11.5.1, “Arithmetic Operators”
unbuffered option
mysql, Section 4.5.1.1, “mysql Options”
unique ID, Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
unique keys
and partitioning keys, Section 18.5.1, “Partitioning Keys, Primary Keys, and Unique Keys”
unloading
tables, Section 3.3.4, “Retrieving Information from a Table”
unpack option
myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
unqualified option
ndb_show_tables, Description
updatable views, Section 19.5.3, “Updatable and Insertable Views”
update-state option
myisamchk, Section 4.6.3.2, “myisamchk Check Options”
uptime, Description
usage option
ndb_config, Description
use command
mysql, Section 4.5.1.2, “mysql Commands”
use-frm option
mysqlcheck, Description
use-manager option
mysql.server, Description
use-mysqld_safe option
mysql.server, Description
use-threads option
mysqlimport, Description
mysqlslap, Description
useHexFormat option
ndb_select_all, Description
user names
and passwords, Section 5.5.1, “User Names and Passwords”
user option, Section 4.2.2, “Connecting to the MySQL Server”
mysql, Section 4.5.1.1, “mysql Options”
mysql.server, Description
mysqlaccess, Description
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_multi, Description
mysqld_safe, Description
mysqldump, Description
mysqlhotcopy, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
user privileges
adding, Section 5.5.2, “Adding User Accounts”
deleting, Section 5.5.3, “Removing User Accounts”
dropping, Section 5.5.3, “Removing User Accounts”
user variables, Section 8.4, “User-Defined Variables”
and replication, Section 16.3.1.28, “Replication and Variables”
user-defined functions
adding, Section 22.3, “Adding New Functions to MySQL”, Section 22.3.2, “Adding a New User-Defined Function”
username option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
users
deleting, Section 5.5.3, “Removing User Accounts”
using MySQL Cluster programs, Section 17.6, “MySQL Cluster Programs”

V

VALUES(), Section 11.11.4, “Miscellaneous Functions”
VARBINARY data type, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
VARCHAR
size, Section 10.5, “Data Type Storage Requirements”
VARCHAR data type, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
VARCHARACTER data type, Section 10.1.3, “Overview of String Types”
VARIANCE(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
VAR_POP(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
VAR_SAMP(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
VERSION(), Section 11.11.3, “Information Functions”
VIEWS
INFORMATION_SCHEMA table, Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Vietnamese, Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Views
limitations, Section D.4, “Restrictions on Views”
privileges, Section D.4, “Restrictions on Views”
problems, Section D.4, “Restrictions on Views”
valid numbers
examples, Section 8.1.2, “Numbers”
variables
and replication, Section 16.3.1.28, “Replication and Variables”
user, Section 8.4, “User-Defined Variables”
verbose option
myisam_ftdump, Description
myisamchk, Section 4.6.3.1, “myisamchk General Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_multi, Description
mysqldump, Description
mysqldumpslow, Description
mysqlimport, Description
mysqlshow, Description
mysqlslap, Description
version option
myisamchk, Section 4.6.3.1, “myisamchk General Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqlaccess, Description
mysqladmin, Description
mysqlbinlog, Description
mysqlcheck, Description
mysqld_multi, Description
mysqldump, Description
mysqlimport, Description
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
mysqlshow, Description
mysqlslap, Description
ndb_config, Description
vertical option
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
view restrictions, Section D.4, “Restrictions on Views”
views, Section 19.5, “Using Views”, Chapter 19, Stored Programs and Views
algorithms, Section 19.5.2, “View Processing Algorithms”
and replication, Section 16.3.1.29, “Replication and Views”
metadata, Section 19.5.4, “View Metadata”
updatable, Section 19.5.3, “Updatable and Insertable Views”

W

WAIT COMPLETED (START BACKUP command), Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
WAIT STARTED (START BACKUP command), Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
WEEK(), Section 11.6, “Date and Time Functions”
WEEKDAY(), Section 11.6, “Date and Time Functions”
WEEKOFYEAR(), Section 11.6, “Date and Time Functions”
WHERE
with SHOW, Section 20.28, “Extensions to SHOW Statements”, Chapter 20, INFORMATION_SCHEMA Tables
WKB format, Section 11.13.3.2, “Well-Known Binary (WKB) Format”
WKT format, Section 11.13.3.1, “Well-Known Text (WKT) Format”
Well-Known Binary format, Section 11.13.3.2, “Well-Known Binary (WKB) Format”
Well-Known Text format, Section 11.13.3.1, “Well-Known Text (WKT) Format”
Wildcard character (%), Section 8.1.1, “Strings”
Wildcard character (_), Section 8.1.1, “Strings”
Windows, Section 21.1, “MySQL Connector/ODBC”
Within(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
wait option
myisamchk, Section 4.6.3.1, “myisamchk General Options”
myisampack, Description
mysql, Section 4.5.1.1, “mysql Options”
mysqladmin, Description
wait-timeout option
mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
warnings command
mysql, Section 4.5.1.2, “mysql Commands”
where option
mysqldump, Description
widths
display, Chapter 10, Data Types
wrappers
Eiffel, Section 21.17, “MySQL Eiffel Wrapper”
write-binlog option
mysqlbinlog, Description
write_buffer_size myisamchk variable, Section 4.6.3.1, “myisamchk General Options”

X

X(), Section 11.13.5.2.2, “Point Functions”
X509/Certificate, Section 5.5.7.1, “Basic SSL Concepts”
XOR
bitwise, Section 11.11.1, “Bit Functions”
logical, Section 11.2.4, “Logical Operators”
xml option
mysql, Section 4.5.1.1, “mysql Options”
mysqldump, Description
ndb_config, Description

Y

Y(), Section 11.13.5.2.2, “Point Functions”
YEAR data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.3, “The YEAR Type”
YEAR(), Section 11.6, “Date and Time Functions”
YEARWEEK(), Section 11.6, “Date and Time Functions”
Year 2000 compliance, Section 10.3.4, “Year 2000 Issues and Date Types”
Year 2000 issues, Section 10.3.4, “Year 2000 Issues and Date Types”
Yen sign (Japanese), Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
yaSSL, Section 5.5.7.2, “Using SSL Connections”, Section 5.5.7, “Using SSL for Secure Connections”

Z

ZEROFILL, Section 10.2, “Numeric Types”, Section 10.1.1, “Overview of Numeric Types”, Section 21.10.13, “C API Prepared Statement Problems”