- MySQL 5.1 Reference Manual :: Index
-
- MySQL 5.1 Reference Manual
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
Symbols
[index top]- ! (logical NOT), Logical Operators
- != (not equal), Comparison Functions and Operators
- ", Schema Object Names
- #mysql50 identifier prefix, Schema Object Names, Mapping of Identifiers to File Names
- %, Arithmetic Operators
- % (modulo), Mathematical Functions
- % (wildcard character), Strings
- & (bitwise AND), Bit Functions
- && (logical AND), Logical Operators
- () (parentheses), Operator Precedence
- (Control-Z) \Z, Strings, LOAD DATA INFILE Syntax
- * (multiplication), Arithmetic Operators
- + (addition), Arithmetic Operators
- - (subtraction), Arithmetic Operators
- - (unary minus), Arithmetic Operators
- --append option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --bind-address option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --character-sets-dir option
- MySQL Cluster programs, Options Common to MySQL Cluster Programs
- --config-cache option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --config-file option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --configdir option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --connect-string option (MySQL Cluster), Options Common to MySQL Cluster Programs
- --core-file option (MySQL Cluster), Options Common to MySQL Cluster Programs
- --daemon option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --debug option (MySQL Cluster), Options Common to MySQL Cluster Programs
- --disable option prefix, Program Option Modifiers
- --disable-indexes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --enable option prefix, Program Option Modifiers
- --exclude-databases option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --exclude-missing-columns option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --exclude-tables option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --execute option (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client
- --fields-enclosed-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --fields-optionally-enclosed-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --fields-terminated-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --help option
- MySQL Cluster programs, Options Common to MySQL Cluster Programs
- --hex option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --include-databases option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --include-tables option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --initial option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
- --initial option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
- --initial option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --initial-start option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
- --initial-start option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
- --log-name option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --loose option prefix, Program Option Modifiers
- --maximum option prefix, Program Option Modifiers
- --ndb-log-update-as-write (mysqld option), MySQL Cluster Replication Conflict Resolution
- --ndb-mgmd-host option (MySQL Cluster), Options Common to MySQL Cluster Programs
- --ndb-nodeid option (MySQL Cluster), Options Common to MySQL Cluster Programs
- --ndb-optimized-node-selection option (MySQL Cluster), Options Common to MySQL Cluster Programs
- --nodaemon option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
- --nodaemon option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
- --nodaemon option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --nostart option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
- --nostart option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
- --nowait-nodes option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
- --nowait-nodes option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
- --nowait-nodes option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --password option, End-User Guidelines for Password Security
- --print-full-config option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --rebuild-indexes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --reload option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- --restore_backupid option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_backup_path option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_connect option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_epoch option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_nodeid option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_preserve-trailing-spaces option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_print_data option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_promote-attributes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --restore_skip-table-check option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --skip option prefix, Program Option Modifiers
- --skip-unknown-objects option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --tab option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
- --usage option
- MySQL Cluster programs, Options Common to MySQL Cluster Programs
- --version option (MySQL Cluster), Options Common to MySQL Cluster Programs
- -? option
- MySQL Cluster programs, Options Common to MySQL Cluster Programs
- -c option (MySQL Cluster), Options Common to MySQL Cluster Programs
- -c option (ndb_mgmd) (OBSOLETE), ndb_mgmd — The MySQL Cluster Management Server Daemon
- -d option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- -e option (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client
- -f option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- -n option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
- -n option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
- -p option, End-User Guidelines for Password Security
- -P option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
- -V option (MySQL Cluster), Options Common to MySQL Cluster Programs
- .my.cnf file, Connecting to the MySQL Server, Using Option Files, End-User Guidelines for Password Security, Causes of Access-Denied Errors, Using Client Programs in a Multiple-Server Environment
- .mysql_history file, mysql Options, End-User Guidelines for Password Security
- .pid (process ID) file, Setting Up a MyISAM Table Maintenance Schedule
- / (division), Arithmetic Operators
- /etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax
- := (assignment), User-Defined Variables
- < (less than), Comparison Functions and Operators
- <<, Calculating Visits Per Day
- << (left shift), Bit Functions
- <= (less than or equal), Comparison Functions and Operators
- <=> (equal to), Comparison Functions and Operators
- <> (not equal), Comparison Functions and Operators
- = (assignment), User-Defined Variables
- = (equal), Comparison Functions and Operators
- > (greater than), Comparison Functions and Operators
- >= (greater than or equal), Comparison Functions and Operators
- >> (right shift), Bit Functions
- [api] (MySQL Cluster), MySQL Cluster SQL Node and API Node Configuration Parameters
- [computer] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
- [mgm] (MySQL Cluster), MySQL Cluster Management Node Configuration Parameters
- [ndbd default] (MySQL Cluster), MySQL Cluster Data Node Configuration Parameters
- [ndbd] (MySQL Cluster), MySQL Cluster Data Node Configuration Parameters
- [ndb_mgmd] (MySQL Cluster), MySQL Cluster Management Node Configuration Parameters
- [sci] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
- [shm] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
- [SQL] (MySQL Cluster), MySQL Cluster SQL Node and API Node Configuration Parameters
- [tcp] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
- \" (double quote), Strings
- \' (single quote), Strings
- \. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
- \0 (ASCII NUL), Strings, LOAD DATA INFILE Syntax
- \b (backspace), Strings, LOAD DATA INFILE Syntax
- \n (linefeed), Strings, LOAD DATA INFILE Syntax
- \n (newline), Strings, LOAD DATA INFILE Syntax
- \N (NULL), LOAD DATA INFILE Syntax
- \r (carriage return), Strings, LOAD DATA INFILE Syntax
- \t (tab), Strings, LOAD DATA INFILE Syntax
- \Z (Control-Z) ASCII 26, Strings, LOAD DATA INFILE Syntax
- \\ (escape), Strings
- ^ (bitwise XOR), Bit Functions
- _ (wildcard character), Strings
- _rowid, CREATE TABLE Syntax
- `, Schema Object Names
- | (bitwise OR), Bit Functions
- || (logical OR), Logical Operators
- ~, Bit Functions
A
[index top]- abort-slave-event-count option
- aborted clients, Communication Errors and Aborted Connections
- aborted connection, Communication Errors and Aborted Connections
- ABS(), Mathematical Functions
- access control, Access Control, Stage 1: Connection Verification
- access denied errors, Access denied
- access privileges, The MySQL Access Privilege System
- account names, Specifying Account Names
- account privileges
- adding, Adding User Accounts
- accounts
- anonymous user, Securing the Initial MySQL Accounts
- root, Securing the Initial MySQL Accounts
- ACID, Transactions and Atomic Operations, The InnoDB Storage Engine
- ACLs, The MySQL Access Privilege System
- ACOS(), Mathematical Functions
- Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP)
- ActiveState Perl, Installing ActiveState Perl on Windows
- add-drop-database option
- mysqldump, mysqldump — A Database Backup Program
- add-drop-table option
- mysqldump, mysqldump — A Database Backup Program
- add-locks option
- mysqldump, mysqldump — A Database Backup Program
- add-user option
- mysqlmanager, MySQL Instance Manager Command Options
- ADDDATE(), Date and Time Functions
- adding
- character sets, Adding a New Character Set
- native functions, Adding a New Native Function
- new account privileges, Adding User Accounts
- new functions, Adding New Functions to MySQL
- new user privileges, Adding User Accounts
- new users, Installing MySQL from Generic Binaries on Unix/Linux, Source Installation Overview
- procedures, Adding New Procedures to MySQL
- user-defined functions, Adding a New User-Defined Function
- addition (+), Arithmetic Operators
- ADDTIME(), Date and Time Functions
- addtodest option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- administration
- administration of MySQL Cluster, ndb_mgm — The MySQL Cluster Management Client
- administrative programs, Overview of MySQL Programs
- AES_DECRYPT(), Encryption and Compression Functions
- AES_ENCRYPT(), Encryption and Compression Functions
- After create
- thread state, General Thread States
- age
- calculating, Date Calculations
- alias names
- case sensitivity, Identifier Case Sensitivity
- aliases
- for expressions, GROUP BY and HAVING with Hidden Columns
- for tables, SELECT Syntax
- in GROUP BY clauses, GROUP BY and HAVING with Hidden Columns
- names, Schema Object Names
- on expressions, SELECT Syntax
- ALL, SELECT Syntax, Subqueries with ALL
- ALL join type
- optimizer, Optimizing Queries with EXPLAIN
- all-databases option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- all-in-1 option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- all-tablespaces option
- mysqldump, mysqldump — A Database Backup Program
- allocating local table
- thread state, Delayed-Insert Thread States
- allow-keywords option
- mysqldump, mysqldump — A Database Backup Program
- allow-suspicious-udfs option
- allowold option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- ALLOW_INVALID_DATES SQL mode, Server SQL Modes
- ALTER COLUMN, ALTER TABLE Syntax
- ALTER DATABASE, ALTER DATABASE Syntax
- ALTER EVENT, ALTER EVENT Syntax
- ALTER FUNCTION, ALTER FUNCTION Syntax
- ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Syntax
- (see also MySQL Cluster Disk Data)
- ALTER PROCEDURE, ALTER PROCEDURE Syntax
- ALTER SCHEMA, ALTER DATABASE Syntax
- ALTER SERVER, ALTER SERVER Syntax
- ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE
- ALTER TABLESPACE, ALTER TABLESPACE Syntax
- (see also MySQL Cluster Disk Data)
- ALTER VIEW, ALTER VIEW Syntax
- altering
- database, ALTER DATABASE Syntax
- schema, ALTER DATABASE Syntax
- analyze option
- myisamchk, Other myisamchk Options
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- ANALYZE TABLE, ANALYZE TABLE Syntax
- and partitioning, Maintenance of Partitions
- Analyzing
- thread state, General Thread States
- AND
- bitwise, Bit Functions
- logical, Logical Operators
- angel-pid-file option
- mysqlmanager, MySQL Instance Manager Command Options
- anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
- ANSI mode
- running, Running MySQL in ANSI Mode
- ansi option
- mysqld, Server Command Options
- ANSI SQL mode, Server SQL Modes
- ANSI_QUOTES SQL mode, Server SQL Modes
- answering questions
- etiquette, Guidelines for Using the Mailing Lists
- ANY, Subqueries with ANY, IN, or SOME
- Apache, Using MySQL with Apache
- API node (MySQL Cluster)
- defined, MySQL Cluster Core Concepts
- API nodes (see SQL nodes)
- API's
- list of, Packages that support MySQL
- APIs, Connectors and APIs
- Perl, MySQL Perl API
- apply_status table (OBSOLETE), MySQL Cluster Replication Schema and Tables
- (see also MySQL Cluster replication)
- approximate-value literals, Precision Math
- Arbitration, Defining MySQL Cluster Data Nodes
- ArbitrationDelay, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster
- ArbitrationRank, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster
- ArbitrationTimeout (DEPRECATED), Defining MySQL Cluster Data Nodes
- arbitrator, MySQL 5.1 FAQ: MySQL Cluster
- ARCHIVE storage engine, Storage Engines, The ARCHIVE Storage Engine
- Area(), Polygon Functions, MultiPolygon Functions
- argument processing, UDF Argument Processing
- arithmetic expressions, Arithmetic Operators
- arithmetic functions, Bit Functions
- AS, SELECT Syntax, JOIN Syntax
- AS/400, Installing MySQL on i5/OS
- AsBinary(), Geometry Format Conversion Functions
- ASCII(), String Functions
- ASIN(), Mathematical Functions
- AsText(), Geometry Format Conversion Functions
- asynchronous replication (see MySQL Cluster replication)
- ATAN(), Mathematical Functions
- ATAN2(), Mathematical Functions
- attackers
- security against, Making MySQL Secure Against Attackers
- attribute demotion
- replication, Replication of Columns Having Different Data Types
- attribute promotion
- ndb_restore, ndb_restore — Restore a MySQL Cluster Backup
- replication, Replication of Columns Having Different Data Types
- auto-generate-sql option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-add-autoincrement option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-execute-number option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-guid-primary option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-load-type option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-secondary-indexes option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-unique-query-number option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-unique-write-number option
- mysqlslap, mysqlslap — Load Emulation Client
- auto-generate-sql-write-number option
- mysqlslap, mysqlslap — Load Emulation Client
- AUTO-INCREMENT
- auto-rehash option
- mysql, mysql Options
- auto-repair option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- autoclose option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- autocommit session variable, Server System Variables
- automatic_sp_privileges system variable, Server System Variables
- AutoReconnect
- API and SQL nodes, Defining SQL and Other API Nodes in a MySQL Cluster
- AUTO_INCREMENT, Using AUTO_INCREMENT, Numeric Types
- and NULL values, Problems with NULL Values
- and replication, Replication and AUTO_INCREMENT
- auto_increment_increment system variable, Replication Master Options and Variables
- auto_increment_offset system variable, Replication Master Options and Variables
- AVG(), GROUP BY (Aggregate) Functions
- AVG(DISTINCT), GROUP BY (Aggregate) Functions
B
[index top]- backslash
- escape character, Strings
- backspace (\b), Strings, LOAD DATA INFILE Syntax
- backup identifiers
- native backup and restore, Using The MySQL Cluster Management Client to Create a Backup
- backup option
- myisamchk, myisamchk Repair Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- BACKUP TABLE, BACKUP TABLE Syntax
- BackupDataBufferSize, Configuration for MySQL Cluster Backups
- BackupDataBufferSize (MySQL Cluster configuration parameter), Defining MySQL Cluster Data Nodes
- BackupDataDir, Defining MySQL Cluster Data Nodes
- BackupLogBufferSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
- BackupMaxWriteSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
- BackupMemory, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
- BackupReportFrequency, Defining MySQL Cluster Data Nodes
- backups, Backup and Recovery
- database, BACKUP TABLE Syntax
- databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
- in MySQL Cluster, ndb_restore — Restore a MySQL Cluster Backup, Online Backup of MySQL Cluster, MySQL Cluster Backup Concepts, Using The MySQL Cluster Management Client to Create a Backup, Configuration for MySQL Cluster Backups
- in MySQL Cluster replication, MySQL Cluster Backups With MySQL Cluster Replication
- InnoDB, Backing Up and Recovering an InnoDB Database
- with mysqldump, Using mysqldump for Backups
- backups, troubleshooting
- in MySQL Cluster, MySQL Cluster Backup Troubleshooting
- BackupWriteSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
- back_log system variable, Server System Variables
- base64-output option
- basedir option
- mysql.server, mysql.server — MySQL Server Startup Script
- mysqld, Server Command Options
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- basedir system variable, Server System Variables
- batch mode, Using mysql in Batch Mode
- batch option
- mysql, mysql Options
- batch SQL files, mysql — The MySQL Command-Line Tool
- BatchByteSize, Defining SQL and Other API Nodes in a MySQL Cluster
- batched updates (MySQL Cluster Replication), Starting MySQL Cluster Replication (Single Replication Channel)
- BatchSize, Defining SQL and Other API Nodes in a MySQL Cluster
- BatchSizePerLocalScan, Defining MySQL Cluster Data Nodes
- Bazaar tree, Installing from the Development Source Tree
- BdMPolyFromText(), Creating Geometry Values Using WKT Functions
- BdMPolyFromWKB(), Creating Geometry Values Using WKB Functions
- BdPolyFromText(), Creating Geometry Values Using WKT Functions
- BdPolyFromWKB(), Creating Geometry Values Using WKB Functions
- BEGIN, START TRANSACTION, COMMIT, and ROLLBACK Syntax, BEGIN ... END Compound Statement Syntax
- XA transactions, XA Transaction SQL Syntax
- benchmark suite, The MySQL Benchmark Suite
- BENCHMARK(), Information Functions
- benchmarks, Using Your Own Benchmarks
- BETWEEN ... AND, Comparison Functions and Operators
- big-tables option
- mysqld, Server Command Options
- big5, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- BIGINT data type, Overview of Numeric Types
- big_tables session variable, Server System Variables
- BIN(), String Functions
- BINARY, Cast Functions and Operators
- BINARY data type, Overview of String Types, The BINARY and VARBINARY Types
- binary distributions
- binary log, The Binary Log
- event groups, SET GLOBAL sql_slave_skip_counter Syntax
- binary logging
- and MySQL Cluster, Issues Exclusive to MySQL Cluster
- bind-address option
- mysqld, Server Command Options
- mysqlmanager, MySQL Instance Manager Command Options
- BINLOG, BINLOG Syntax
- Binlog Dump
- thread command, Thread Command Values
- BINLOG statement
- mysqlbinlog output, mysqlbinlog Row Event Display
- binlog-do-db option
- mysqld, Binary Log Options and Variables
- binlog-format option
- mysqld, Server Command Options
- binlog-ignore-db option
- mysqld, Binary Log Options and Variables
- binlog-row-event-max-size option
- mysqld, Binary Log Options and Variables
- binlog_cache_size system variable, Binary Log Options and Variables
- binlog_direct_non_transactional_updates system variable, Binary Log Options and Variables
- binlog_format system variable, Binary Log Options and Variables
- binlog_index table (OBSOLETE) (see MySQL Cluster replication)
- BIT data type, Overview of Numeric Types
- BitKeeper tree, Installing from the Development Source Tree
- BIT_AND(), GROUP BY (Aggregate) Functions
- BIT_COUNT, Calculating Visits Per Day
- BIT_COUNT(), Bit Functions
- bit_functions
- example, Calculating Visits Per Day
- BIT_LENGTH(), String Functions
- BIT_OR, Calculating Visits Per Day
- BIT_OR(), GROUP BY (Aggregate) Functions
- BIT_XOR(), GROUP BY (Aggregate) Functions
- BLACKHOLE storage engine, Storage Engines, The BLACKHOLE Storage Engine
- BLOB
- inserting binary data, Strings
- size, Data Type Storage Requirements
- BLOB columns
- default values, The BLOB and TEXT Types
- indexing, Column Indexes, CREATE TABLE Syntax
- BLOB data type, Overview of String Types, The BLOB and TEXT Types
- blob-info option
- ndb_desc, ndb_desc — Describe NDB Tables
- Block Nested-Loop join algorithm, Nested-Loop Join Algorithms
- block-search option
- myisamchk, Other myisamchk Options
- blocks
- ndbinfo table, The ndbinfo blocks Table
- BOOL data type, Overview of Numeric Types
- BOOLEAN data type, Overview of Numeric Types
- boolean options, Program Option Modifiers
- bootstrap option
- mysqld, Server Command Options
- Borland Builder 4, Using Connector/ODBC with Borland Builder 4
- Boundary(), General Geometry Functions
- brackets
- square, Data Types
- brief option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- Buffer pool
- InnoDB, The InnoDB Buffer Pool
- buffer sizes
- client, Connectors and APIs
- mysqld server, Tuning Server Parameters
- Buffer(), Spatial Operators
- bug reports
- criteria for, How to Report Bugs or Problems
- bugs
- known, Known Issues in MySQL
- MySQL Cluster
- reporting, How to Report Bugs or Problems
- bugs database, How to Report Bugs or Problems
- bugs.mysql.com, How to Report Bugs or Problems
- building
- client programs, Building Client Programs
- bulk_insert_buffer_size system variable, Server System Variables
C
[index top]- C API
- data types, MySQL C API
- functions, C API Function Overview
- linking problems, Problems Linking with the C API
- C prepared statement API
- C++ APIs, MySQL C++ API
- C++ Builder, Using Connector/ODBC with C++ Builder
- C++ compiler
- C++ compiler cannot create executables, Dealing with Problems Compiling MySQL
- C:\my.cnf file, Using Client Programs in a Multiple-Server Environment
- CACHE INDEX, CACHE INDEX Syntax
- and partitioning, Restrictions and Limitations on Partitioning
- caches
- clearing, FLUSH Syntax
- calculating
- dates, Date Calculations
- calendar, What Calendar Is Used By MySQL?
- CALL, CALL Syntax
- calling sequences for aggregate functions
- calling sequences for simple functions
- can't create/write to file, Can't create/write to file
- carriage return (\r), Strings, LOAD DATA INFILE Syntax
- CASE, Control Flow Functions, CASE Statement
- case sensitivity
- in access checking, Privilege System Grant Tables
- in identifiers, Identifier Case Sensitivity
- in names, Identifier Case Sensitivity
- in searches, Case Sensitivity in String Searches
- in string comparisons, String Comparison Functions
- case-sensitivity
- of database names, MySQL Extensions to Standard SQL
- of table names, MySQL Extensions to Standard SQL
- CAST, Cast Functions and Operators
- cast functions, Cast Functions and Operators
- cast operators, Cast Functions and Operators
- casts, Type Conversion in Expression Evaluation, Comparison Functions and Operators, Cast Functions and Operators
- CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- cc1plus problems, Dealing with Problems Compiling MySQL
- CEIL(), Mathematical Functions
- CEILING(), Mathematical Functions
- Centroid(), MultiPolygon Functions
- CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- cflags option
- mysql_config, mysql_config — Get Compile Options for Compiling Clients
- CHANGE MASTER TO, CHANGE MASTER TO Syntax
- in MySQL Cluster, Preparing the MySQL Cluster for Replication
- Change user
- thread command, Thread Command Values
- ChangeLog, MySQL Change History
- changes
- changes to privileges, When Privilege Changes Take Effect
- changing
- column, ALTER TABLE Syntax
- field, ALTER TABLE Syntax
- table, ALTER TABLE Syntax, Problems with ALTER TABLE
- Changing master
- thread state, Replication Slave Connection Thread States
- changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Unix Socket File
- CHAR data type, Overview of String Types, String Types
- CHAR VARYING data type, Overview of String Types
- CHAR(), String Functions
- CHARACTER data type, Overview of String Types
- character set repertoire, String Repertoire
- character sets, Typical configure Options
- adding, Adding a New Character Set
- and MySQL Cluster (replication), Known Issues in MySQL Cluster Replication
- and replication, Replication and Character Sets
- Character sets, Character Set Support
- CHARACTER VARYING data type, Overview of String Types
- character-set-client-handshake option
- mysqld, Server Command Options
- character-set-filesystem option
- mysqld, Server Command Options
- character-set-server option
- mysqld, Server Command Options
- character-sets-dir option
- myisamchk, myisamchk Repair Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqld, Server Command Options
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- characters
- multi-byte, Multi-Byte Character Support
- CHARACTER_LENGTH(), String Functions
- CHARACTER_SETS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table
- character_sets_dir system variable, Server System Variables
- character_set_client system variable, Server System Variables
- character_set_connection system variable, Server System Variables
- character_set_database system variable, Server System Variables
- character_set_filesystem system variable, Server System Variables
- character_set_results system variable, Server System Variables
- character_set_server system variable, Server System Variables
- character_set_system system variable, Server System Variables
- charset command
- mysql, mysql Commands
- charset option
- CHARSET(), Information Functions
- CHAR_LENGTH(), String Functions
- check option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- check options
- myisamchk, myisamchk Check Options
- CHECK TABLE, CHECK TABLE Syntax
- and partitioning, Maintenance of Partitions
- check-only-changed option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- check-password-file option
- mysqlmanager, MySQL Instance Manager Command Options
- check-upgrade option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- checking
- tables for errors, How to Check MyISAM Tables for Errors
- Checking master version
- thread state, Replication Slave I/O Thread States
- checking permissions
- thread state, General Thread States
- checking privileges on cached query
- thread state, Query Cache Thread States
- checking query cache for query
- thread state, Query Cache Thread States
- Checking table
- thread state, General Thread States
- CHECKPOINT Events (MySQL Cluster), MySQL Cluster Log Events
- checkpoint option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- Checksum, MySQL Cluster TCP/IP Connections
- Checksum (MySQL Cluster), MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster
- checksum errors, Installing MySQL on Solaris
- CHECKSUM TABLE, CHECKSUM TABLE Syntax
- Chinese, Japanese, Korean character sets
- frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- choosing
- a MySQL version, Choosing Which MySQL Distribution to Install
- choosing types, Choosing the Right Type for a Column
- chroot option
- mysqld, Server Command Options
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- circular replication
- CJK
- CJK (Chinese, Japanese, Korean)
- Access, PHP, etc., MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- availability of specific characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- available character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- big5, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- character sets available, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- characters displayed as question marks, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- CJKV, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- collations, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- conversion problems with Japanese character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- data truncation, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Database and table names, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- documentation in Chinese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- documentation in Japanese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- documentation in Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- gb2312, gbk, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Japanese character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Korean character set, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- LIKE and FULLTEXT, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- MySQL 4.0 behavior, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- ORDER BY treatment, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with Access, PHP, etc., MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with Big5 character sets (Chinese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with data truncation, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with euckr character set (Korean), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with GB character sets (Chinese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with LIKE and FULLTEXT, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- problems with Yen sign (Japanese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- rejected characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- sort order problems, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- sorting problems, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- testing availability of characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Unicode collations, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Vietnamese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Yen sign, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- clean-password-file option
- mysqlmanager, MySQL Instance Manager Command Options
- cleaning up
- thread state, General Thread States
- clear command
- mysql, mysql Commands
- Clearing
- thread state, Event Scheduler Thread States
- clearing
- caches, FLUSH Syntax
- client connection threads, How MySQL Uses Threads for Client Connections
- client programs, Overview of MySQL Programs
- building, Building Client Programs
- client tools, Connectors and APIs
- clients
- debugging, Debugging a MySQL Client
- threaded, How to Make a Threaded Client
- CLOSE, Cursor CLOSE Statement
- Close stmt
- thread command, Thread Command Values
- closing
- closing tables
- thread state, General Thread States
- cluster database (OBSOLETE) (see MySQL Cluster replication)
- cluster logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
- cluster.binlog_index table (OBSOLETE) (see MySQL Cluster replication)
- clustered index
- InnoDB, Clustered and Secondary Indexes
- Clustering (see MySQL Cluster)
- CLUSTERLOG commands (MySQL Cluster), MySQL Cluster Logging Management Commands
- CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- cluster_replication database (OBSOLETE) (see MySQL Cluster replication)
- CMake, Building MySQL from Source Using CMake and Visual Studio
- COALESCE(), Comparison Functions and Operators
- COERCIBILITY(), Information Functions
- ColdFusion, Using Connector/ODBC with ColdFusion
- collating
- strings, String Collating Support
- collation
- adding, How to Add a New Collation to a Character Set
- INFORMATION_SCHEMA, Collation and INFORMATION_SCHEMA Searches
- COLLATION(), Information Functions
- collation-server option
- mysqld, Server Command Options
- COLLATIONS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table
- COLLATION_CHARACTER_SET_APPLICABILITY
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- collation_connection system variable, Server System Variables
- collation_database system variable, Server System Variables
- collation_server system variable, Server System Variables
- column
- changing, ALTER TABLE Syntax
- types, Data Types
- column alias
- problems, Problems with Column Aliases
- quoting, Schema Object Names, Problems with Column Aliases
- column comments, CREATE TABLE Syntax
- column format, CREATE TABLE Syntax
- column names
- case sensitivity, Identifier Case Sensitivity
- column storage, CREATE TABLE Syntax
- column-names option
- mysql, mysql Options
- column-type-info option
- mysql, mysql Options
- columns
- displaying, mysqlshow — Display Database, Table, and Column Information
- indexes, Column Indexes
- names, Schema Object Names
- other types, Using Data Types from Other Database Engines
- selecting, Selecting Particular Columns
- storage requirements, Data Type Storage Requirements
- COLUMNS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table
- columns option
- mysqlimport, mysqlimport — A Data Import Program
- COLUMN_PRIVILEGES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- comma-separated values data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
- command options
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqld, Server Command Options
- command options (MySQL Cluster)
- command syntax, Typographical and Syntax Conventions, Conventions Used in This Document
- command-line history
- mysql, mysql Options
- command-line options (MySQL Cluster), Options Common to MySQL Cluster Programs
- command-line tool, mysql — The MySQL Command-Line Tool
- commands
- for binary distribution, Installing MySQL from Generic Binaries on Unix/Linux
- commands out of sync, Commands out of sync
- Comment syntax, Comment Syntax
- comments
- adding, Comment Syntax
- starting, '--' as the Start of a Comment
- comments option
- mysql, mysql Options
- mysqldump, mysqldump — A Database Backup Program
- COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
- XA transactions, XA Transaction SQL Syntax
- commit option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- mysqlslap, mysqlslap — Load Emulation Client
- Committing events to binlog
- thread state, MySQL Cluster Thread States
- compact option
- mysqldump, mysqldump — A Database Backup Program
- comparison operators, Comparison Functions and Operators
- compatibility
- between MySQL versions, Upgrading from MySQL 5.0 to 5.1
- with mSQL, Regular Expressions
- with ODBC, Server System Variables, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
- with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax
- with PostgreSQL, MySQL Extensions to Standard SQL
- with standard SQL, MySQL Standards Compliance
- with Sybase, USE Syntax
- compatible option
- mysqldump, mysqldump — A Database Backup Program
- compiler
- C++ gcc, Typical configure Options
- compiling
- on Windows, Compiling MySQL Clients on Windows
- optimizing, System Factors and Startup Parameter Tuning
- problems, Dealing with Problems Compiling MySQL
- speed, How Compiling and Linking Affects the Speed of MySQL
- statically, Typical configure Options
- user-defined functions, Compiling and Installing User-Defined Functions
- complete-insert option
- mysqldump, mysqldump — A Database Backup Program
- completion_type system variable, Server System Variables
- compliance
- composite partitioning, Subpartitioning
- compound statements, MySQL Compound-Statement Syntax
- compress option
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- COMPRESS(), Encryption and Compression Functions
- compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics
- CompressedBackup, Defining MySQL Cluster Data Nodes
- CompressedLCP, Defining MySQL Cluster Data Nodes
- comp_err, Overview of MySQL Programs, comp_err — Compile MySQL Error Message File
- charset option, comp_err — Compile MySQL Error Message File
- debug option, comp_err — Compile MySQL Error Message File
- debug-info option, comp_err — Compile MySQL Error Message File
- header_file option, comp_err — Compile MySQL Error Message File
- help option, comp_err — Compile MySQL Error Message File
- in_file option, comp_err — Compile MySQL Error Message File
- name_file option, comp_err — Compile MySQL Error Message File
- out_dir option, comp_err — Compile MySQL Error Message File
- out_file option, comp_err — Compile MySQL Error Message File
- statefile option, comp_err — Compile MySQL Error Message File
- version option, comp_err — Compile MySQL Error Message File
- CONCAT(), String Functions
- concatenation
- string, Strings, String Functions
- CONCAT_WS(), String Functions
- concurrency option
- mysqlslap, mysqlslap — Load Emulation Client
- concurrent inserts, Internal Locking Methods, Concurrent Inserts
- concurrent_insert system variable, Server System Variables
- Conditions, DECLARE for Conditions
- config-file option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- my_print_defaults, my_print_defaults — Display Options from Option Files
- ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
- config.cache, Dealing with Problems Compiling MySQL
- config.cache file, Dealing with Problems Compiling MySQL
- config.ini (MySQL Cluster), MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files, MySQL Cluster Configuration: Basic Example, ndb_mgmd — The MySQL Cluster Management Server Daemon
- configinfo option
- configuration
- MySQL Cluster, Overview of MySQL Cluster Configuration Parameters
- configuration files, Causes of Access-Denied Errors
- configuration options, Typical configure Options
- configure
- disable-grant-options option, Typical configure Options
- enable-community-features option, Typical configure Options
- enable-debug-sync option, Typical configure Options
- enable-profiling option, Typical configure Options
- enable-thread-safe-client option, Typical configure Options
- localstatedir option, Typical configure Options
- prefix option, Typical configure Options
- running after prior invocation, Dealing with Problems Compiling MySQL
- with-big-tables option, Typical configure Options
- with-charset option, Typical configure Options
- with-client-ldflags option, Typical configure Options
- with-collation option, Typical configure Options
- with-debug option, Typical configure Options
- with-embedded-server option, Typical configure Options
- with-extra-charsets option, Typical configure Options
- with-tcp-port option, Typical configure Options
- with-unix-socket-path option, Typical configure Options
- with-zlib-dir option, Typical configure Options
- without-server option, Typical configure Options
- configure option
- --with-low-memory, Dealing with Problems Compiling MySQL
- configure script, Typical configure Options
- configuring backups
- in MySQL Cluster, Configuration for MySQL Cluster Backups
- configuring MySQL Cluster, MySQL Cluster Multi-Computer How-To, MySQL Cluster Configuration, MySQL Server Usage for MySQL Cluster, ndb_mgmd — The MySQL Cluster Management Server Daemon
- Configuring MySQL Cluster (concepts), MySQL Cluster Core Concepts
- config_params
- ndbinfo table, The ndbinfo config_params Table
- conflict resolution
- and ndb_replication system table, MySQL Cluster Replication Conflict Resolution
- enabling, MySQL Cluster Replication Conflict Resolution
- in MySQL Cluster Replication, MySQL Cluster Replication Conflict Resolution
- mysqld startup options, MySQL Cluster Replication Conflict Resolution
- Connect
- thread command, Thread Command Values
- connect command
- mysql, mysql Commands
- Connect Out
- thread command, Thread Command Values
- connecting
- remotely with SSH, Connecting to MySQL Remotely from Windows with SSH
- to the server, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
- verification, Access Control, Stage 1: Connection Verification
- Connecting to master
- thread state, Replication Slave I/O Thread States
- connection
- CONNECTION Events (MySQL Cluster), MySQL Cluster Log Events
- CONNECTION_ID(), Information Functions
- Connector/C, Connectors and APIs
- Connector/C++, Connectors and APIs
- Connector/JDBC, Connectors and APIs
- Connector/MXJ, Connectors and APIs
- Connector/NET, Connectors and APIs, MySQL Connector/NET
- reporting problems, Connector/NET Support
- Connector/ODBC, Connectors and APIs, MySQL Connector/ODBC
- Borland, Using Connector/ODBC with Borland Applications
- Borland Database Engine, Using Connector/ODBC with Borland Applications
- reporting problems, Connector/ODBC Support
- Connector/OpenOffice.org, Connectors and APIs
- Connectors
- MySQL, Connectors and APIs
- connectstring (see MySQL Cluster)
- connect_timeout system variable, Server System Variables
- connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
- console option
- mysqld, Server Command Options
- const table
- optimizer, Optimizing Queries with EXPLAIN, SELECT Syntax
- constant table, WHERE Clause Optimization
- constraints, How MySQL Deals with Constraints
- CONSTRAINTS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- Contains(), Functions That Test Spatial Relationships Between Geometries
- contributing companies
- list of, Supporters of MySQL
- contributors
- list of, Contributors to MySQL
- control flow functions, Control Flow Functions
- CONV(), Mathematical Functions
- conventions
- CONVERT, Cast Functions and Operators
- CONVERT TO, ALTER TABLE Syntax
- converting HEAP to MyISAM
- thread state, General Thread States
- CONVERT_TZ(), Date and Time Functions
- ConvexHull(), Spatial Operators
- copy option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- copy to tmp table
- thread state, General Thread States
- copying databases, Copying MySQL Databases to Another Machine
- copying tables, CREATE TABLE Syntax
- Copying to group table
- thread state, General Thread States
- Copying to tmp table
- thread state, General Thread States
- Copying to tmp table on disk
- thread state, General Thread States
- core-file option
- mysqld, Server Command Options
- core-file-size option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- correct-checksum option
- myisamchk, myisamchk Repair Options
- correlated subqueries, Correlated Subqueries
- COS(), Mathematical Functions
- COT(), Mathematical Functions
- count option
- COUNT(), GROUP BY (Aggregate) Functions
- COUNT(DISTINCT), GROUP BY (Aggregate) Functions
- counters
- ndbinfo table, The ndbinfo counters Table
- counting
- table rows, Counting Rows
- crash, Debugging a MySQL Server
- recovery, Using myisamchk for Crash Recovery
- repeated, What to Do If MySQL Keeps Crashing
- replication, Replication and Master or Slave Shutdowns
- crash-me, The MySQL Benchmark Suite
- crash-me program, Designing Applications for Portability, The MySQL Benchmark Suite
- CRC32(), Mathematical Functions
- CREATE ... IF NOT EXISTS
- and replication, Replication of CREATE ... IF NOT EXISTS Statements
- CREATE DATABASE, CREATE DATABASE Syntax
- Create DB
- thread command, Thread Command Values
- CREATE EVENT, CREATE EVENT Syntax
- CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax, CREATE FUNCTION Syntax
- CREATE INDEX, CREATE INDEX Syntax
- CREATE LOGFILE GROUP, CREATE LOGFILE GROUP Syntax
- (see also MySQL Cluster Disk Data)
- CREATE NODEGROUP command (MySQL Cluster), Commands in the MySQL Cluster Management Client
- create option
- mysqlslap, mysqlslap — Load Emulation Client
- CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION Syntax
- CREATE SCHEMA, CREATE DATABASE Syntax
- CREATE SERVER, CREATE SERVER Syntax
- CREATE TABLE, CREATE TABLE Syntax
- DIRECTORY options
- and replication, Replication and DIRECTORY Table Options
- CREATE TABLE ... SELECT
- and replication, Replication of CREATE TABLE ... SELECT Statements
- CREATE TABLESPACE, CREATE TABLESPACE Syntax
- (see also MySQL Cluster Disk Data)
- CREATE TRIGGER, CREATE TRIGGER Syntax
- CREATE USER, CREATE USER Syntax
- CREATE VIEW, CREATE VIEW Syntax
- create-options option
- mysqldump, mysqldump — A Database Backup Program
- create-schema option
- mysqlslap, mysqlslap — Load Emulation Client
- creating
- bug reports, How to Report Bugs or Problems
- database, CREATE DATABASE Syntax
- databases, Creating and Using a Database
- default startup options, Using Option Files
- function, CREATE FUNCTION Syntax
- schema, CREATE DATABASE Syntax
- tables, Creating a Table
- Creating delayed handler
- thread state, Delayed-Insert Thread States
- Creating index
- thread state, General Thread States
- Creating sort index
- thread state, General Thread States
- creating table
- thread state, General Thread States
- Creating table from master dump
- thread state, Replication Slave Connection Thread States
- Creating tmp table
- thread state, General Thread States
- creating user accounts, CREATE USER Syntax
- CROSS JOIN, JOIN Syntax
- Crosses(), Functions That Test Spatial Relationships Between Geometries
- CR_SERVER_GONE_ERROR, MySQL server has gone away
- CR_SERVER_LOST_ERROR, MySQL server has gone away
- CSV data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
- csv option
- mysqlslap, mysqlslap — Load Emulation Client
- CSV storage engine, Storage Engines, The CSV Storage Engine
- CURDATE(), Date and Time Functions
- CURRENT_DATE, Date and Time Functions
- CURRENT_TIME, Date and Time Functions
- CURRENT_TIMESTAMP, Date and Time Functions
- CURRENT_USER(), Information Functions
- Cursors, Cursors
- CURTIME(), Date and Time Functions
- CXX environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CXXFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
D
[index top]- Daemon
- thread command, Thread Command Values
- data
- importing, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program
- loading into tables, Loading Data into a Table
- retrieving, Retrieving Information from a Table
- size, Make Your Data as Small as Possible
- DATA DIRECTORY
- and replication, Replication and DIRECTORY Table Options
- data node (MySQL Cluster)
- defined, MySQL Cluster Core Concepts
- data nodes (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- Data truncation with CJK characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- data type
- BIGINT, Overview of Numeric Types
- BINARY, Overview of String Types, The BINARY and VARBINARY Types
- BIT, Overview of Numeric Types
- BLOB, Overview of String Types, The BLOB and TEXT Types
- BOOL, Overview of Numeric Types, Using Data Types from Other Database Engines
- BOOLEAN, Overview of Numeric Types, Using Data Types from Other Database Engines
- CHAR, Overview of String Types, String Types
- CHAR VARYING, Overview of String Types
- CHARACTER, Overview of String Types
- CHARACTER VARYING, Overview of String Types
- DATE, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- DATETIME, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- DEC, Overview of Numeric Types
- DECIMAL, Overview of Numeric Types, Precision Math
- DOUBLE, Overview of Numeric Types
- DOUBLE PRECISION, Overview of Numeric Types
- ENUM, Overview of String Types, The ENUM Type
- FIXED, Overview of Numeric Types
- FLOAT, Overview of Numeric Types
- GEOMETRY, MySQL Spatial Data Types
- GEOMETRYCOLLECTION, MySQL Spatial Data Types
- INT, Overview of Numeric Types
- INTEGER, Overview of Numeric Types
- LINESTRING, MySQL Spatial Data Types
- LONG, The BLOB and TEXT Types
- LONGBLOB, Overview of String Types
- LONGTEXT, Overview of String Types
- MEDIUMBLOB, Overview of String Types
- MEDIUMINT, Overview of Numeric Types
- MEDIUMTEXT, Overview of String Types
- MULTILINESTRING, MySQL Spatial Data Types
- MULTIPOINT, MySQL Spatial Data Types
- MULTIPOLYGON, MySQL Spatial Data Types
- NATIONAL CHAR, Overview of String Types
- NATIONAL VARCHAR, Overview of String Types
- NCHAR, Overview of String Types
- NUMERIC, Overview of Numeric Types
- NVARCHAR, Overview of String Types
- POINT, MySQL Spatial Data Types
- POLYGON, MySQL Spatial Data Types
- REAL, Overview of Numeric Types
- SET, Overview of String Types, The SET Type
- SMALLINT, Overview of Numeric Types
- TEXT, Overview of String Types, The BLOB and TEXT Types
- TIME, Overview of Date and Time Types, The TIME Type
- TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- TINYBLOB, Overview of String Types
- TINYINT, Overview of Numeric Types
- TINYTEXT, Overview of String Types
- VARBINARY, Overview of String Types, The BINARY and VARBINARY Types
- VARCHAR, Overview of String Types, String Types
- VARCHARACTER, Overview of String Types
- YEAR, Overview of Date and Time Types, The YEAR Type
- data types, Data Types
- C API, MySQL C API
- overview, Data Type Overview
- data-file-length option
- myisamchk, myisamchk Repair Options
- database
- altering, ALTER DATABASE Syntax
- creating, CREATE DATABASE Syntax
- deleting, DROP DATABASE Syntax
- Database information
- obtaining, SHOW Syntax
- database metadata, INFORMATION_SCHEMA Tables
- database names
- case sensitivity, Identifier Case Sensitivity
- case-sensitivity, MySQL Extensions to Standard SQL
- database option
- mysql, mysql Options
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- ndb_show_tables, ndb_show_tables — Display List of NDB Tables
- DATABASE(), Information Functions
- databases
- backups, Backup and Recovery
- copying, Copying MySQL Databases to Another Machine
- creating, Creating and Using a Database
- defined, What is MySQL?
- displaying, mysqlshow — Display Database, Table, and Column Information
- dumping, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
- information about, Getting Information About Databases and Tables
- names, Schema Object Names
- replicating, Replication
- selecting, Creating and Selecting a Database
- symbolic links, Using Symbolic Links for Databases on Unix
- using, Creating and Using a Database
- databases option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- DataDir, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes
- datadir option
- mysql.server, mysql.server — MySQL Server Startup Script
- mysqld, Server Command Options
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- datadir system variable, Server System Variables
- DataJunction, Using Connector/ODBC with Pervasive Software DataJunction
- DataMemory, Defining MySQL Cluster Data Nodes, Configuring MySQL Cluster Parameters for Local Checkpoints
- DATE, Problems Using DATE Columns
- date and time functions, Date and Time Functions
- Date and Time types, Date and Time Types
- date calculations, Date Calculations
- DATE columns
- problems, Problems Using DATE Columns
- DATE data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- date functions
- Y2K compliance, Year 2000 Issues and Date Types
- date types, Data Type Storage Requirements
- Y2K issues, Year 2000 Issues and Date Types
- date values, Date and Time Values
- problems, The DATETIME, DATE, and TIMESTAMP Types
- DATE(), Date and Time Functions
- DATEDIFF(), Date and Time Functions
- dates
- used with partitioning, Partition Types
- used with partitioning (examples), RANGE Partitioning, HASH Partitioning, Subpartitioning, Partition Pruning
- DATETIME data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
- datetime_format system variable, Server System Variables
- DATE_ADD(), Date and Time Functions
- date_format system variable, Server System Variables
- DATE_FORMAT(), Date and Time Functions
- DATE_SUB(), Date and Time Functions
- DAY(), Date and Time Functions
- DAYNAME(), Date and Time Functions
- DAYOFMONTH(), Date and Time Functions
- DAYOFWEEK(), Date and Time Functions
- DAYOFYEAR(), Date and Time Functions
- db option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- db table
- DB2 SQL mode, Server SQL Modes
- DBI interface, MySQL Perl API
- DBI->quote, Strings
- DBI->trace, Debugging mysqld under gdb
- DBI/DBD interface, MySQL Perl API
- DBI_TRACE environment variable, Environment Variables, Debugging mysqld under gdb
- DBI_USER environment variable, Environment Variables
- DBUG package, The DBUG Package
- DEALLOCATE PREPARE, SQL Syntax for Prepared Statements, DEALLOCATE PREPARE Syntax
- Debug
- thread command, Thread Command Values
- debug option
- comp_err, comp_err — Compile MySQL Error Message File
- make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- myisamchk, myisamchk General Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- mysql, mysql Options
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqld, Server Command Options
- mysqldump, mysqldump — A Database Backup Program
- mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlmanager, MySQL Instance Manager Command Options
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- my_print_defaults, my_print_defaults — Display Options from Option Files
- debug system variable, Server System Variables
- debug-check option
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- debug-info option
- comp_err, comp_err — Compile MySQL Error Message File
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- debug-sync-timeout option
- mysqld, Server Command Options
- debugging
- client, Debugging a MySQL Client
- server, Debugging a MySQL Server
- debugging support, Typical configure Options
- debug_sync system variable, Server System Variables
- DEC data type, Overview of Numeric Types
- decimal arithmetic, Precision Math
- DECIMAL data type, Overview of Numeric Types, Precision Math
- decimal point, Data Types
- DECLARE, DECLARE Syntax
- DECODE(), Encryption and Compression Functions
- decode_bits myisamchk variable, myisamchk General Options
- DEFAULT
- constraint, Constraints on Invalid Data
- default
- privileges, Securing the Initial MySQL Accounts
- default host name, Connecting to the MySQL Server
- default installation location, Installation Layouts
- default options, Using Option Files
- DEFAULT value clause, Data Type Default Values, CREATE TABLE Syntax
- default values, MySQL Design Limitations and Tradeoffs, Data Type Default Values, CREATE TABLE Syntax, INSERT Syntax
- BLOB and TEXT columns, The BLOB and TEXT Types
- explicit, Data Type Default Values
- implicit, Data Type Default Values
- suppression, Constraints on Invalid Data
- DEFAULT(), Miscellaneous Functions
- default-character-set option
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqld, Server Command Options
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- default-collation option
- mysqld, Server Command Options
- default-mysqld-path option
- mysqlmanager, MySQL Instance Manager Command Options
- default-storage-engine option
- mysqld, Server Command Options
- default-table-type option
- mysqld, Server Command Options
- default-time-zone option
- mysqld, Server Command Options
- defaults
- embedded, Options with the Embedded Server
- defaults-extra-file option, Command-Line Options that Affect Option-File Handling
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- my_print_defaults, my_print_defaults — Display Options from Option Files
- defaults-file option, Command-Line Options that Affect Option-File Handling
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysqlmanager, MySQL Instance Manager Command Options
- my_print_defaults, my_print_defaults — Display Options from Option Files
- defaults-group-suffix option, Command-Line Options that Affect Option-File Handling
- my_print_defaults, my_print_defaults — Display Options from Option Files
- default_week_format system variable, Server System Variables
- DEGREES(), Mathematical Functions
- delay-key-write option
- DELAYED, INSERT DELAYED Syntax
- when ignored, INSERT Syntax
- Delayed insert
- thread command, Thread Command Values
- delayed inserts
- thread states, Delayed-Insert Thread States
- delayed-insert option
- mysqldump, mysqldump — A Database Backup Program
- delayed_insert_limit, INSERT DELAYED Syntax
- delayed_insert_limit system variable, Server System Variables
- delayed_insert_timeout system variable, Server System Variables
- delayed_queue_size system variable, Server System Variables
- delay_key_write system variable, Server System Variables
- DELETE, DELETE Syntax
- and MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits
- delete option
- mysqlimport, mysqlimport — A Data Import Program
- delete-master-logs option
- mysqldump, mysqldump — A Database Backup Program
- deleting
- database, DROP DATABASE Syntax
- foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
- function, DROP FUNCTION Syntax
- index, ALTER TABLE Syntax, DROP INDEX Syntax
- primary key, ALTER TABLE Syntax
- rows, Deleting Rows from Related Tables
- schema, DROP DATABASE Syntax
- table, DROP TABLE Syntax
- user, Removing User Accounts, DROP USER Syntax
- users, Removing User Accounts, DROP USER Syntax
- deleting from main table
- thread state, General Thread States
- deleting from reference tables
- thread state, General Thread States
- deletion
- delimiter command
- mysql, mysql Commands
- delimiter option
- mysql, mysql Options
- mysqlslap, mysqlslap — Load Emulation Client
- ndb_select_all, ndb_select_all — Print Rows from an NDB Table
- Delphi, Using Connector/ODBC with Delphi
- derived tables, Subqueries in the FROM Clause
- des-key-file option
- mysqld, Server Command Options
- DESC, DESCRIBE Syntax
- descending option
- ndb_select_all, ndb_select_all — Print Rows from an NDB Table
- DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax
- description option
- myisamchk, Other myisamchk Options
- design
- issues, Known Issues in MySQL
- limitations, MySQL Design Limitations and Tradeoffs
- DES_DECRYPT(), Encryption and Compression Functions
- DES_ENCRYPT(), Encryption and Compression Functions
- detach option
- mysqlslap, mysqlslap — Load Emulation Client
- development of MySQL Cluster, MySQL Cluster Development History
- development source tree, Installing from the Development Source Tree
- Difference(), Spatial Operators
- digits, Data Types
- Dimension(), General Geometry Functions
- directory structure
- default, Installation Layouts
- disable named command
- mysql, mysql Options
- disable-grant-options option
- configure, Typical configure Options
- disable-keys option
- mysqldump, mysqldump — A Database Backup Program
- disable-log-bin option
- DISCARD TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
- discard_or_import_tablespace
- thread state, General Thread States
- disconnect-slave-event-count option
- disconnecting
- from the server, Connecting to and Disconnecting from the Server
- Disjoint(), Functions That Test Spatial Relationships Between Geometries
- Disk Data tables (MySQL Cluster) (see MySQL Cluster Disk Data)
- disk full, How MySQL Handles a Full Disk
- disk issues, Disk Issues
- disk option
- ndb_select_all, ndb_select_all — Print Rows from an NDB Table
- DiskCheckpointSpeed, Defining MySQL Cluster Data Nodes
- DiskCheckpointSpeedInRestart, Defining MySQL Cluster Data Nodes
- DiskIOThreadPool, Defining MySQL Cluster Data Nodes
- Diskless, Defining MySQL Cluster Data Nodes
- DiskPageBufferMemory, Defining MySQL Cluster Data Nodes
- disks
- splitting data across, Using Symbolic Links for Databases on Windows
- DiskSyncSize, Defining MySQL Cluster Data Nodes
- display size, Data Types
- display triggers, SHOW TRIGGERS Syntax
- display width, Data Types
- displaying
- database information, mysqlshow — Display Database, Table, and Column Information
- information
- Cardinality, SHOW INDEX Syntax
- Collation, SHOW INDEX Syntax
- SHOW, SHOW Syntax, SHOW COLUMNS Syntax, SHOW INDEX Syntax, SHOW OPEN TABLES Syntax, SHOW TABLES Syntax
- table status, SHOW TABLE STATUS Syntax
- Distance(), Functions That Test Spatial Relationships Between Geometries
- DISTINCT, Selecting Particular Columns, DISTINCT Optimization, SELECT Syntax
- AVG(), GROUP BY (Aggregate) Functions
- COUNT(), GROUP BY (Aggregate) Functions
- MAX(), GROUP BY (Aggregate) Functions
- MIN(), GROUP BY (Aggregate) Functions
- SUM(), GROUP BY (Aggregate) Functions
- DISTINCTROW, SELECT Syntax
- DIV, Arithmetic Operators
- division (/), Arithmetic Operators
- div_precision_increment system variable, Server System Variables
- DNS, How MySQL Uses DNS
- DO, DO Syntax
- DocBook XML
- documentation source format, About This Manual
- Documentation
- Documenters
- list of, Documenters and translators
- DOUBLE data type, Overview of Numeric Types
- DOUBLE PRECISION data type, Overview of Numeric Types
- double quote (\"), Strings
- downgrades
- downgrading, Upgrading or Downgrading MySQL, Downgrading MySQL
- downloading, How to Get MySQL
- drbd
- DRBD license, Distributed Replicated Block Device (DRBD)
- DROP ... IF EXISTS
- and replication, Replication of DROP ... IF EXISTS Statements
- DROP DATABASE, DROP DATABASE Syntax
- Drop DB
- thread command, Thread Command Values
- DROP EVENT, DROP EVENT Syntax
- DROP FOREIGN KEY, ALTER TABLE Syntax, FOREIGN KEY Constraints
- DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION Syntax, DROP FUNCTION Syntax
- DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax
- DROP LOGFILE GROUP, DROP LOGFILE GROUP Syntax
- (see also MySQL Cluster Disk Data)
- DROP NODEGROUP command (MySQL Cluster), Commands in the MySQL Cluster Management Client
- DROP PREPARE, DEALLOCATE PREPARE Syntax
- DROP PRIMARY KEY, ALTER TABLE Syntax
- DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax
- DROP SCHEMA, DROP DATABASE Syntax
- DROP SERVER, DROP SERVER Syntax
- DROP TABLE, DROP TABLE Syntax
- and MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits
- DROP TABLESPACE, DROP TABLESPACE Syntax
- (see also MySQL Cluster Disk Data)
- DROP TRIGGER, DROP TRIGGER Syntax
- DROP USER, DROP USER Syntax
- DROP VIEW, DROP VIEW Syntax
- drop-user option
- mysqlmanager, MySQL Instance Manager Command Options
- dropping
- dryrun option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- DUAL, SELECT Syntax
- dump option
- myisam_ftdump, myisam_ftdump — Display Full-Text Index information
- dump-date option
- mysqldump, mysqldump — A Database Backup Program
- DUMPFILE, SELECT Syntax
- dumping
- databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
- dynamic table characteristics, Dynamic Table Characteristics
E
[index top]- edit command
- mysql, mysql Commands
- edit-user option
- mysqlmanager, MySQL Instance Manager Command Options
- ego command
- mysql, mysql Commands
- Eiffel Wrapper, MySQL Eiffel Wrapper
- ELT(), String Functions
- email lists, MySQL Mailing Lists
- embedded MySQL server library, libmysqld, the Embedded MySQL Server Library
- embedded option
- make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- mysql_config, mysql_config — Get Compile Options for Compiling Clients
- enable-community-features option
- configure, Typical configure Options
- enable-debug-sync option
- configure, Typical configure Options
- enable-named-pipe option
- mysqld, Server Command Options
- enable-profiling option
- configure, Typical configure Options
- enable-pstack option
- mysqld, Server Command Options
- enable-thread-safe-client option
- configure, Typical configure Options
- ENCODE(), Encryption and Compression Functions
- ENCRYPT(), Encryption and Compression Functions
- encryption, Basic SSL Concepts
- encryption functions, Encryption and Compression Functions
- end
- thread state, General Thread States
- END, BEGIN ... END Compound Statement Syntax
- EndPoint(), LineString Functions
- engine option
- mysqlslap, mysqlslap — Load Emulation Client
- ENGINES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ENGINES Table
- engine_condition_pushdown system variable, Server System Variables
- ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client
- entering
- queries, Entering Queries
- ENUM
- ENUM data type, Overview of String Types, The ENUM Type
- Envelope(), General Geometry Functions
- environment variable
- CC, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CXX, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
- DBI_TRACE, Environment Variables, Debugging mysqld under gdb
- DBI_USER, Environment Variables
- HOME, Environment Variables, mysql Options
- LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
- LD_RUN_PATH, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface
- MYSQL_DEBUG, Environment Variables, Overview of MySQL Programs, Debugging a MySQL Client
- MYSQL_GROUP_SUFFIX, Environment Variables
- MYSQL_HISTFILE, Environment Variables, mysql Options
- MYSQL_HOME, Environment Variables
- MYSQL_HOST, Environment Variables, Connecting to the MySQL Server
- MYSQL_PS1, Environment Variables
- MYSQL_PWD, Environment Variables, Overview of MySQL Programs, Connecting to the MySQL Server
- MYSQL_TCP_PORT, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
- MYSQL_UNIX_PORT, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
- PATH, Installing MySQL from Generic Binaries on Unix/Linux, Environment Variables, Invoking MySQL Programs
- TMPDIR, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Where MySQL Stores Temporary Files
- TZ, Environment Variables, Time Zone Problems
- UMASK, Environment Variables, Problems with File Permissions
- UMASK_DIR, Environment Variables, Problems with File Permissions
- USER, Environment Variables, Connecting to the MySQL Server
- environment variables, Overview of MySQL Programs, Setting Environment Variables, Causes of Access-Denied Errors
- CXX, Dealing with Problems Compiling MySQL
- list of, Environment Variables
- equal (=), Comparison Functions and Operators
- Equals(), Functions That Test Spatial Relationships Between Geometries
- eq_ref join type
- optimizer, Optimizing Queries with EXPLAIN
- Errcode, perror — Explain Error Codes
- errno, perror — Explain Error Codes
- Error
- thread command, Thread Command Values
- ERROR Events (MySQL Cluster), MySQL Cluster Log Events
- error logs (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon
- error messages
- can't find file, Problems with File Permissions
- displaying, perror — Explain Error Codes
- languages, Setting the Error Message Language
- errors
- access denied, Access denied
- and replication, Slave Errors During Replication
- checking tables for, How to Check MyISAM Tables for Errors
- common, Problems and Common Errors
- directory checksum, Installing MySQL on Solaris
- handling for UDFs, UDF Return Values and Error Handling
- in subqueries, Subquery Errors
- known, Known Issues in MySQL
- linking, Problems Linking to the MySQL Client Library
- list of, Common Errors When Using MySQL Programs
- lost connection, Lost connection to MySQL server
- reporting, General Information, How to Report Bugs or Problems
- sources of information, Sources of Error Information
- error_count session variable, Server System Variables
- ERROR_FOR_DIVISION_BY_ZERO SQL mode, Server SQL Modes
- escape (\\), Strings
- escape sequences
- option files, Using Option Files
- strings, Strings
- estimating
- query performance, Estimating Query Performance
- event
- restrictions, Restrictions on Stored Routines, Triggers, and Events
- event groups, SET GLOBAL sql_slave_skip_counter Syntax
- event log format (MySQL Cluster), MySQL Cluster Log Events
- event logs (MySQL Cluster), Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
- event scheduler, Stored Programs and Views
- thread states, Event Scheduler Thread States
- Event Scheduler, Using the Event Scheduler
- altering events, ALTER EVENT Syntax
- and MySQL privileges, The Event Scheduler and MySQL Privileges
- and mysqladmin debug, Event Scheduler Status
- and replication, Replication of Invoked Features
- and SHOW PROCESSLIST, Event Scheduler Configuration
- concepts, Event Scheduler Overview
- creating events, CREATE EVENT Syntax
- dropping events, DROP EVENT Syntax
- enabling and disabling, Event Scheduler Configuration
- event metadata, Event Metadata
- obtaining status information, SHOW SCHEDULER STATUS Syntax, Event Scheduler Status
- SQL statements, Event Syntax
- starting and stopping, Event Scheduler Configuration
- time representation, Event Metadata
- event severity levels (MySQL Cluster), MySQL Cluster Logging Management Commands
- event types (MySQL Cluster), Event Reports Generated in MySQL Cluster, MySQL Cluster Log Events
- event-scheduler option
- mysqld, Server Command Options
- events, Stored Programs and Views, Using the Event Scheduler
- altering, ALTER EVENT Syntax
- creating, CREATE EVENT Syntax
- dropping, DROP EVENT Syntax
- metadata, Event Metadata
- status variables, The Event Scheduler and MySQL Privileges
- EVENTS
- INFORMATION_SCHEMA table, The Event Scheduler and MySQL Privileges, The INFORMATION_SCHEMA EVENTS Table
- events option
- mysqldump, mysqldump — A Database Backup Program
- event_scheduler system variable, Server System Variables
- exact-value literals, Precision Math
- example option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- EXAMPLE storage engine, Storage Engines, The EXAMPLE Storage Engine
- examples
- compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables
- myisamchk output, myisamchk Table Information
- queries, Examples of Common Queries
- exe-suffix option
- make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- Execute
- thread command, Thread Command Values
- EXECUTE, SQL Syntax for Prepared Statements, EXECUTE Syntax
- execute option
- mysql, mysql Options
- ExecuteOnComputer, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster
- executing
- thread state, General Thread States
- executing SQL statements from text files, Using mysql in Batch Mode, Executing SQL Statements from a Text File
- Execution of init_command
- thread state, General Thread States
- execution threads (MySQL Cluster), ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- EXISTS
- with subqueries, Subqueries with EXISTS or NOT EXISTS
- exit command
- mysql, mysql Commands
- EXIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client
- EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client
- exit-info option
- mysqld, Server Command Options
- EXP(), Mathematical Functions
- expire_logs_days system variable, Server System Variables
- EXPLAIN, Optimizing Queries with EXPLAIN, EXPLAIN Syntax
- EXPLAIN PARTITIONS, Obtaining Information About Partitions
- EXPLAIN used with partitioned tables, Obtaining Information About Partitions
- explicit default values, Data Type Default Values
- EXPORT_SET(), String Functions
- expression aliases, GROUP BY and HAVING with Hidden Columns, SELECT Syntax
- expressions
- extended, Pattern Matching
- extend-check option
- myisamchk, myisamchk Check Options, myisamchk Repair Options
- extended option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- extended-insert option
- mysqldump, mysqldump — A Database Backup Program
- extensions
- to standard SQL, MySQL Standards Compliance
- ExteriorRing(), Polygon Functions
- external locking, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
- external-locking option
- mysqld, Server Command Options
- extra-file option
- my_print_defaults, my_print_defaults — Display Options from Option Files
- extra-node-info option
- ndb_desc, ndb_desc — Describe NDB Tables
- extra-partition-info option
- ndb_desc, ndb_desc — Describe NDB Tables
- EXTRACT(), Date and Time Functions
- extracting
- dates, Date Calculations
- ExtractValue(), XML Functions
F
[index top]- failover
- in MySQL Cluster replication, Implementing Failover with MySQL Cluster Replication
- Java clients, MySQL Cluster Core Concepts
- FALSE, Numbers, Boolean Values
- testing for, Comparison Functions and Operators
- fast option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- fatal signal 11, Dealing with Problems Compiling MySQL
- features of MySQL, The Main Features of MySQL
- FEDERATED storage engine, Storage Engines, The FEDERATED Storage Engine
- Fetch
- thread command, Thread Command Values
- FETCH, Cursor FETCH Statement
- field
- changing, ALTER TABLE Syntax
- Field List
- thread command, Thread Command Values
- FIELD(), String Functions
- fields option
- fields-enclosed-by option
- fields-escaped-by option
- fields-optionally-enclosed-by option
- fields-terminated-by option
- FILE, String Functions
- files
- binary log, The Binary Log
- config.cache, Dealing with Problems Compiling MySQL
- error messages, Setting the Error Message Language
- general query log, The General Query Log
- log, Typical configure Options, Server Log Maintenance
- my.cnf, Replication Features and Issues
- not found message, Problems with File Permissions
- permissions, Problems with File Permissions
- repairing, myisamchk Repair Options
- script, Using mysql in Batch Mode
- size limits, The table is full
- slow query log, The Slow Query Log
- text, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program
- tmp, Problems Running mysql_install_db
- FILES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA FILES Table
- (see also MySQL Cluster Disk Data)
- filesort optimization, ORDER BY Optimization
- FileSystemPath, Defining MySQL Cluster Data Nodes
- FileSystemPathDataFiles, Defining MySQL Cluster Data Nodes
- FileSystemPathDD, Defining MySQL Cluster Data Nodes
- FileSystemPathUndoFiles, Defining MySQL Cluster Data Nodes
- FIND_IN_SET(), String Functions
- Finished reading one binlog; switching to next binlog
- thread state, Replication Master Thread States
- firewalls (software)
- and MySQL Cluster, MySQL Cluster Security and Networking Issues
- first-slave option
- mysqldump, mysqldump — A Database Backup Program
- fix-db-names option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- fix-table-names option
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- FIXED data type, Overview of Numeric Types
- fixed-point arithmetic, Precision Math
- FLOAT data type, Overview of Numeric Types
- floating-point number, Overview of Numeric Types
- floating-point values
- and replication, Replication and Floating-Point Values
- floats, Numbers
- FLOOR(), Mathematical Functions
- FLUSH, FLUSH Syntax
- and replication, Replication and FLUSH
- flush option
- mysqld, Server Command Options
- flush system variable, Server System Variables
- flush tables, mysqladmin — Client for Administering a MySQL Server
- flush-logs option
- mysqldump, mysqldump — A Database Backup Program
- flush-privileges option
- mysqldump, mysqldump — A Database Backup Program
- Flushing tables
- thread state, General Thread States
- flushlog option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- flush_time system variable, Server System Variables
- FOR UPDATE, SELECT Syntax
- FORCE INDEX, Index Hint Syntax, Optimizer-Related Issues
- FORCE KEY, Index Hint Syntax
- force option
- myisamchk, myisamchk Check Options, myisamchk Repair Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- mysql, mysql Options
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- force-read option
- foreign key
- constraint, PRIMARY KEY and UNIQUE Index Constraints
- deleting, ALTER TABLE Syntax, FOREIGN KEY Constraints
- foreign keys, Foreign Keys, Using Foreign Keys, ALTER TABLE Syntax
- foreign_key_checks session variable, Server System Variables
- FORMAT(), String Functions
- Forums, MySQL Community Support at the MySQL Forums
- FOUND_ROWS(), Information Functions
- FragmentLogFileSize, Defining MySQL Cluster Data Nodes
- FreeBSD troubleshooting, Dealing with Problems Compiling MySQL
- freeing items
- thread state, General Thread States
- frequently-asked questions about DRBD, MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat, Distributed Replicated Block Device (DRBD)
- frequently-asked questions about MySQL Cluster, MySQL 5.1 FAQ: MySQL Cluster
- FROM, SELECT Syntax
- FROM_DAYS(), Date and Time Functions
- FROM_UNIXTIME(), Date and Time Functions
- ft_boolean_syntax system variable, Server System Variables
- ft_max_word_len myisamchk variable, myisamchk General Options
- ft_max_word_len system variable, Server System Variables
- ft_min_word_len myisamchk variable, myisamchk General Options
- ft_min_word_len system variable, Server System Variables
- ft_query_expansion_limit system variable, Server System Variables
- ft_stopword_file myisamchk variable, myisamchk General Options
- ft_stopword_file system variable, Server System Variables
- full disk, How MySQL Handles a Full Disk
- full-text search, Full-Text Search Functions
- FULLTEXT, Full-Text Search Functions
- fulltext
- stopword list, Fine-Tuning MySQL Full-Text Search
- FULLTEXT initialization
- thread state, General Thread States
- fulltext join type
- optimizer, Optimizing Queries with EXPLAIN
- function
- creating, CREATE FUNCTION Syntax
- deleting, DROP FUNCTION Syntax
- function names
- parsing, Function Name Parsing and Resolution
- resolving ambiguity, Function Name Parsing and Resolution
- functions, Functions and Operators
- and replication, Replication and System Functions
- arithmetic, Bit Functions
- bit, Bit Functions
- C API, C API Function Overview
- C prepared statement API, C API Prepared Statement Type Conversions, C API Prepared Statement Function Overview
- cast, Cast Functions and Operators
- control flow, Control Flow Functions
- date and time, Date and Time Functions
- encryption, Encryption and Compression Functions
- GROUP BY, GROUP BY (Aggregate) Functions
- grouping, Operator Precedence
- information, Information Functions
- mathematical, Mathematical Functions
- miscellaneous, Miscellaneous Functions
- native
- adding, Adding a New Native Function
- new, Adding New Functions to MySQL
- stored, Using Stored Routines (Procedures and Functions)
- string, String Functions
- string comparison, String Comparison Functions
- user-defined, Adding New Functions to MySQL
- Functions
- user-defined, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
- functions for SELECT and WHERE clauses, Functions and Operators
G
[index top]- gap event, Known Issues in MySQL Cluster Replication
- gap lock
- gb2312, gbk, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- gcc, Typical configure Options
- gci option
- ndb_select_all, ndb_select_all — Print Rows from an NDB Table
- GCP Stop errors (MySQL Cluster), Defining MySQL Cluster Data Nodes
- gdb
- using, Debugging mysqld under gdb
- gdb option
- mysqld, Server Command Options
- general information, General Information
- General Public License, What is MySQL?
- general query log, The General Query Log
- general-log option
- mysqld, Server Command Options
- general_log system variable, Server System Variables
- general_log_file system variable, Server System Variables
- geographic feature, Introduction to MySQL Spatial Support
- GeomCollFromText(), Creating Geometry Values Using WKT Functions
- GeomCollFromWKB(), Creating Geometry Values Using WKB Functions
- geometry, Introduction to MySQL Spatial Support
- GEOMETRY data type, MySQL Spatial Data Types
- GEOMETRYCOLLECTION data type, MySQL Spatial Data Types
- GeometryCollection(), Creating Geometry Values Using MySQL-Specific Functions
- GeometryCollectionFromText(), Creating Geometry Values Using WKT Functions
- GeometryCollectionFromWKB(), Creating Geometry Values Using WKB Functions
- GeometryFromText(), Creating Geometry Values Using WKT Functions
- GeometryFromWKB(), Creating Geometry Values Using WKB Functions
- GeometryN(), GeometryCollection Functions
- GeometryType(), General Geometry Functions
- GeomFromText(), Creating Geometry Values Using WKT Functions, Geometry Format Conversion Functions
- GeomFromWKB(), Creating Geometry Values Using WKB Functions, Geometry Format Conversion Functions
- geospatial feature, Introduction to MySQL Spatial Support
- getting MySQL, How to Get MySQL
- GET_FORMAT(), Date and Time Functions
- GET_LOCK(), Miscellaneous Functions
- GIS, Spatial Extensions, Introduction to MySQL Spatial Support
- GLength(), LineString Functions, MultiLineString Functions
- global privileges, GRANT Syntax, REVOKE Syntax
- GLOBAL_STATUS
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- GLOBAL_VARIABLES
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- go command
- mysql, mysql Commands
- goals of MySQL, What is MySQL?
- got handler lock
- thread state, Delayed-Insert Thread States
- got old table
- thread state, Delayed-Insert Thread States
- GRANT, GRANT Syntax
- GRANT statement, Adding User Accounts
- grant tables
- granting
- privileges, GRANT Syntax
- GRANTS, SHOW GRANTS Syntax
- greater than (>), Comparison Functions and Operators
- greater than or equal (>=), Comparison Functions and Operators
- greatest timestamp wins (conflict resolution), MySQL Cluster Replication Conflict Resolution
- greatest timestamp, delete wins (conflict resolution), MySQL Cluster Replication Conflict Resolution
- GREATEST(), Comparison Functions and Operators
- GROUP BY, GROUP BY Optimization
- aliases in, GROUP BY and HAVING with Hidden Columns
- extensions to standard SQL, GROUP BY and HAVING with Hidden Columns, SELECT Syntax
- GROUP BY functions, GROUP BY (Aggregate) Functions
- grouping
- expressions, Operator Precedence
- GROUP_CONCAT(), GROUP BY (Aggregate) Functions
- group_concat_max_len system variable, Server System Variables
H
[index top]- HANDLER, HANDLER Syntax
- Handlers, DECLARE for Handlers
- handling
- Has read all relay log; waiting for the slave I/O thread to update it
- thread state, Replication Slave SQL Thread States
- Has sent all binlog to slave; waiting for binlog to be updated
- thread state, Replication Master Thread States
- hash partitioning, HASH Partitioning
- hash partitions
- managing, Management of HASH and KEY Partitions
- splitting and merging, Management of HASH and KEY Partitions
- have_archive system variable, Server System Variables
- have_blackhole_engine system variable, Server System Variables
- have_community_features system variable, Server System Variables
- have_compress system variable, Server System Variables
- have_crypt system variable, Server System Variables
- have_csv system variable, Server System Variables
- have_dynamic_loading system variable, Server System Variables
- have_example_engine system variable, Server System Variables
- have_federated_engine system variable, Server System Variables
- have_geometry system variable, Server System Variables
- have_innodb system variable, Server System Variables
- have_isam system variable, Server System Variables
- have_merge_engine system variable, Server System Variables
- have_openssl system variable, Server System Variables
- have_partitioning system variable, Server System Variables
- have_query_cache system variable, Server System Variables
- have_raid system variable, Server System Variables
- have_row_based_replication system variable, Server System Variables
- have_rtree_keys system variable, Server System Variables
- have_ssl system variable, Server System Variables
- have_symlink system variable, Server System Variables
- HAVING, SELECT Syntax
- header option
- ndb_select_all, ndb_select_all — Print Rows from an NDB Table
- header_file option
- HEAP storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine
- HeartbeatIntervalDbApi, Defining MySQL Cluster Data Nodes
- HeartbeatIntervalDbDb, Defining MySQL Cluster Data Nodes
- HeartbeatThreadPriority, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster
- help command
- mysql, mysql Commands
- HELP command (MySQL Cluster), Commands in the MySQL Cluster Management Client
- help option
- comp_err, comp_err — Compile MySQL Error Message File
- myisamchk, myisamchk General Options
- myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
- myisam_ftdump, myisam_ftdump — Display Full-Text Index information
- mysql, mysql Options
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqld, Server Command Options
- mysqldump, mysqldump — A Database Backup Program
- mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlmanager, MySQL Instance Manager Command Options
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
- mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
- mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
- mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination
- my_print_defaults, my_print_defaults — Display Options from Option Files
- perror, perror — Explain Error Codes
- resolveip, resolveip — Resolve Host name to IP Address or Vice Versa
- resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
- HELP option
- myisamchk, myisamchk General Options
- HELP statement, HELP Syntax
- HEX(), String Functions, Mathematical Functions
- hex-blob option
- mysqldump, mysqldump — A Database Backup Program
- hexadecimal values, Hexadecimal Values
- hexdump option
- HIGH_NOT_PRECEDENCE SQL mode, Server SQL Modes
- HIGH_PRIORITY, SELECT Syntax
- hints, MySQL Extensions to Standard SQL
- index, SELECT Syntax, Index Hint Syntax
- history of MySQL, History of MySQL
- HOME environment variable, Environment Variables, mysql Options
- host name
- default, Connecting to the MySQL Server
- host name caching, How MySQL Uses DNS
- host name resolution, How MySQL Uses DNS
- host option, Connecting to the MySQL Server
- mysql, mysql Options
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- mysqladmin, mysqladmin — Client for Administering a MySQL Server
- mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- mysqldump, mysqldump — A Database Backup Program
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- mysqlshow, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, mysqlslap — Load Emulation Client
- mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
- ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
- host table, Access Control, Stage 2: Request Verification
- Host*SciId* parameters, SCI Transport Connections in MySQL Cluster
- host.frm
- problems finding, Unix Post-Installation Procedures
- HostName, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster
- HostName (MySQL Cluster), MySQL Cluster Security and Networking Issues
- hostname system variable, Server System Variables
- HOUR(), Date and Time Functions
- howto option
- mysqlaccess, mysqlaccess — Client for Checking Access Privileges
- html option
- mysql, mysql Options
I
[index top]- i-am-a-dummy option
- mysql, mysql Options
- i5/OS, Installing MySQL on i5/OS
- IBM i5/OS, Installing MySQL on i5/OS
- IBMDB2I storage engine, Storage Engines
- icc
- and MySQL Cluster support>, Debugging and Porting MySQL
- MySQL builds, Compiler-Specific Build Characteristics
- Id, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster
- ID
- id option
- identifiers, Schema Object Names
- case sensitivity, Identifier Case Sensitivity
- quoting, Schema Object Names
- identity session variable, Server System Variables
- IF, IF Statement
- IF(), Control Flow Functions
- IFNULL(), Control Flow Functions
- IGNORE
- with partitioned tables, INSERT Syntax
- IGNORE INDEX, Index Hint Syntax
- IGNORE KEY, Index Hint Syntax
- ignore option
- mysqlimport, mysqlimport — A Data Import Program
- ignore-builtin-innodb option
- ignore-lines option
- mysqlimport, mysqlimport — A Data Import Program
- ignore-spaces option
- mysql, mysql Options
- ignore-table option
- mysqldump, mysqldump — A Database Backup Program
- IGNORE_SPACE SQL mode, Server SQL Modes
- implicit default values, Data Type Default Values
- IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
- importing
- IN, Comparison Functions and Operators, Subqueries with ANY, IN, or SOME
- include option
- mysql_config, mysql_config — Get Compile Options for Compiling Clients
- increasing
- performance, Replication FAQ
- increasing with replication
- speed, Replication
- incremental recovery, Point-in-Time (Incremental) Recovery Using the Binary Log
- using MySQL Cluster replication, Point-In-Time Recovery Using MySQL Cluster Replication
- index
- deleting, ALTER TABLE Syntax, DROP INDEX Syntax
- rebuilding, Rebuilding or Repairing Tables or Indexes
- INDEX DIRECTORY
- and replication, Replication and DIRECTORY Table Options
- index hints, SELECT Syntax, Index Hint Syntax
- index join type
- optimizer, Optimizing Queries with EXPLAIN
- index-record lock
- indexes, CREATE INDEX Syntax
- and BLOB columns, Column Indexes, CREATE TABLE Syntax
- and IS NULL, How MySQL Uses Indexes
- and LIKE, How MySQL Uses Indexes
- and NULL values, CREATE TABLE Syntax
- and TEXT columns, Column Indexes, CREATE TABLE Syntax
- assigning to key cache, CACHE INDEX Syntax
- block size, Server System Variables
- columns, Column Indexes
- leftmost prefix of, How MySQL Uses Indexes
- multi-column, Multiple-Column Indexes
- multiple-part, CREATE INDEX Syntax
- names, Schema Object Names
- use of, How MySQL Uses Indexes
- IndexMemory, Defining MySQL Cluster Data Nodes, Configuring MySQL Cluster Parameters for Local Checkpoints
- index_merge join type
- optimizer, Optimizing Queries with EXPLAIN
- index_subquery join type
- optimizer, Optimizing Queries with EXPLAIN
- INET_ATON(), Miscellaneous Functions
- INET_NTOA(), Miscellaneous Functions
- INFO Events (MySQL Cluster), MySQL Cluster Log Events
- information functions, Information Functions
- information option
- myisamchk, myisamchk Check Options
- INFORMATION_SCHEMA, INFORMATION_SCHEMA Tables
- and security issues, MySQL Cluster and MySQL Privileges
- collation and searching, Collation and INFORMATION_SCHEMA Searches
- INFORMATION_SCHEMA.ENGINES table
- used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
- INFORMATION_SCHEMA.GLOBAL_STATUS table
- used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
- INFORMATION_SCHEMA.GLOBAL_VARIABLES table
- used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
- init
- thread state, General Thread States
- Init DB
- thread command, Thread Command Values
- init-file option
- mysqld, Server Command Options
- InitFragmentLogFiles, Defining MySQL Cluster Data Nodes
- Initialized
- thread state, Event Scheduler Thread States
- InitialLogFileGroup, Defining MySQL Cluster Data Nodes
- InitialNoOfOpenFiles, Defining MySQL Cluster Data Nodes
- InitialTablespace, Defining MySQL Cluster Data Nodes
- init_connect system variable, Server System Variables
- init_file system variable, Server System Variables
- init_slave system variable, Replication Slave Options and Variables
- INNER JOIN, JOIN Syntax
- innochecksum, Overview of MySQL Programs, innochecksum — Offline InnoDB File Checksum Utility
- InnoDB, The InnoDB Storage Engine
- backups, Backing Up and Recovering an InnoDB Database
- clustered index, Clustered and Secondary Indexes
- gap lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
- index-record lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
- Monitors, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations
- next-key lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
- NFS, InnoDB Configuration, Restrictions on InnoDB Tables
- page size, Physical Structure of an Index, Restrictions on InnoDB Tables
- record-level locks, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
- secondary index, Clustered and Secondary Indexes
- semi-consistent read, InnoDB Startup Options and System Variables
- Solaris 10 x86_64 issues, Installing MySQL on Solaris
- transaction isolation levels, The InnoDB Transaction Model and Locking
- InnoDB buffer pool, The InnoDB Buffer Pool
- innodb option
- InnoDB storage engine, Storage Engines, The InnoDB Storage Engine
- InnoDB tables, Transactions and Atomic Operations
- innodb-status-file option
- INSERT, Speed of INSERT Statements, INSERT Syntax
- insert
- thread state, Delayed-Insert Thread States
- INSERT ... SELECT, INSERT ... SELECT Syntax
- INSERT DELAYED, INSERT DELAYED Syntax
- INSERT statement
- grant privileges, Adding User Accounts
- INSERT(), String Functions
- insert-ignore option
- mysqldump, mysqldump — A Database Backup Program
- insertable views
- insertable, Updatable and Insertable Views
- inserting
- speed of, Speed of INSERT Statements
- inserts
- concurrent, Internal Locking Methods, Concurrent Inserts
- insert_id session variable, Server System Variables
- install option
- mysqlmanager, MySQL Instance Manager Command Options
- INSTALL PLUGIN, INSTALL PLUGIN Syntax
- installation layouts, Installation Layouts
- installation overview, MySQL Installation Using a Source Distribution
- installing
- binary distribution, Installing MySQL from Generic Binaries on Unix/Linux
- Linux RPM packages, Installing MySQL from RPM Packages on Linux
- Mac OS X PKG packages, Installing MySQL on Mac OS X
- overview, Installing and Upgrading MySQL
- Perl, Perl Installation Notes
- Perl on Windows, Installing ActiveState Perl on Windows
- Solaris PKG packages, Installing MySQL on Solaris
- source distribution, MySQL Installation Using a Source Distribution
- user-defined functions, Compiling and Installing User-Defined Functions
- installing MySQL Cluster, MySQL Cluster Multi-Computer How-To, MySQL Cluster Multi-Computer Installation
- installing plugins, Installing and Uninstalling Plugins, INSTALL PLUGIN Syntax
- INSTR(), String Functions
- INT data type, Overview of Numeric Types
- integer arithmetic, Precision Math
- INTEGER data type, Overview of Numeric Types
- integers, Numbers
- interactive_timeout system variable, Server System Variables
- InteriorRingN(), Polygon Functions
- internal compiler errors, Dealing with Problems Compiling MySQL
- internal locking, Internal Locking Methods
- internals, MySQL Internals
- internationalization, Internationalization and Localization
- Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC)
- Intersection(), Spatial Operators
- Intersects(), Functions That Test Spatial Relationships Between Geometries
- INTERVAL(), Comparison Functions and Operators
- introducer
- string literal, Strings, Character String Literal Character Set and Collation
- invalid data
- constraint, Constraints on Invalid Data
- invalidating query cache entries
- thread state, Query Cache Thread States
- in_file option
- IRC, MySQL Community Support on Internet Relay Chat (IRC)
- IS boolean_value, Comparison Functions and Operators
- IS NOT boolean_value, Comparison Functions and Operators
- IS NOT NULL, Comparison Functions and Operators
- IS NULL, IS NULL Optimization, Comparison Functions and Operators
- and indexes, How MySQL Uses Indexes
- isamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents
- IsClosed(), MultiLineString Functions
- IsEmpty(), General Geometry Functions
- ISNULL(), Comparison Functions and Operators
- ISOLATION LEVEL, SET TRANSACTION Syntax
- IsRing(), LineString Functions
- IsSimple(), General Geometry Functions
- IS_FREE_LOCK(), Miscellaneous Functions
- IS_USED_LOCK(), Miscellaneous Functions
- ITERATE, ITERATE Statement
- iterations option
- mysqlslap, mysqlslap — Load Emulation Client
J
[index top]- Japanese character sets
- Japanese, Korean, Chinese character sets
- frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- jdbc:mysql:loadbalance://, MySQL Cluster Core Concepts
- join
- nested-loop algorithm, Nested Join Optimization
- JOIN, JOIN Syntax
- join algorithm
- Block Nested-Loop, Nested-Loop Join Algorithms
- Nested-Loop, Nested-Loop Join Algorithms
- join option
- join type
- ALL, Optimizing Queries with EXPLAIN
- const, Optimizing Queries with EXPLAIN
- eq_ref, Optimizing Queries with EXPLAIN
- fulltext, Optimizing Queries with EXPLAIN
- index, Optimizing Queries with EXPLAIN
- index_merge, Optimizing Queries with EXPLAIN
- index_subquery, Optimizing Queries with EXPLAIN
- range, Optimizing Queries with EXPLAIN
- ref, Optimizing Queries with EXPLAIN
- ref_or_null, Optimizing Queries with EXPLAIN
- system, Optimizing Queries with EXPLAIN
- unique_subquery, Optimizing Queries with EXPLAIN
- join_buffer_size system variable, Server System Variables
K
[index top]- keepold option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- keep_files_on_create system variable, Server System Variables
- Key cache
- MyISAM, The MyISAM Key Cache
- key cache
- assigning indexes to, CACHE INDEX Syntax
- key partitioning, KEY Partitioning
- key partitions
- managing, Management of HASH and KEY Partitions
- splitting and merging, Management of HASH and KEY Partitions
- key space
- MyISAM, Space Needed for Keys
- keys, Column Indexes
- foreign, Foreign Keys, Using Foreign Keys
- multi-column, Multiple-Column Indexes
- searching on two, Searching on Two Keys
- keys option
- keys-used option
- myisamchk, myisamchk Repair Options
- keywords, Reserved Words
- key_buffer_size myisamchk variable, myisamchk General Options
- key_buffer_size system variable, Server System Variables
- key_cache_age_threshold system variable, Server System Variables
- key_cache_block_size system variable, Server System Variables
- key_cache_division_limit system variable, Server System Variables
- KEY_COLUMN_USAGE
- INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- Kill
- thread command, Thread Command Values
- KILL, KILL Syntax
- Killed
- thread state, General Thread States
- Killing slave
- thread state, Replication Slave Connection Thread States
- known errors, Known Issues in MySQL
- Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- Korean, Chinese, Japanese character sets
- frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
L
[index top]- language option
- mysqld, Server Command Options
- language support
- error messages, Setting the Error Message Language
- language system variable, Server System Variables
- large page support, Enabling Large Page Support
- large-pages option
- mysqld, Server Command Options
- large_files_support system variable, Server System Variables
- large_pages system variable, Server System Variables
- large_page_size system variable, Server System Variables
- last row
- LAST_DAY(), Date and Time Functions
- last_insert_id session variable, Server System Variables
- LAST_INSERT_ID(), Transactions and Atomic Operations, INSERT Syntax
- and replication, Replication and AUTO_INCREMENT
- LAST_INSERT_ID() and stored routines, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
- LAST_INSERT_ID() and triggers, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
- LAST_INSERT_ID([<replaceable>expr</replaceable>]), Information Functions
- layout of installation, Installation Layouts
- LCASE(), String Functions
- lc_time_names system variable, Server System Variables
- ldata option
- mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
- LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD Interface
- LD_RUN_PATH environment variable, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface
- LEAST(), Comparison Functions and Operators
- LEAVE, LEAVE Statement
- ledir option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization, JOIN Syntax
- LEFT OUTER JOIN, JOIN Syntax
- LEFT(), String Functions
- leftmost prefix of indexes, How MySQL Uses Indexes
- legal names, Schema Object Names
- length option
- myisam_ftdump, myisam_ftdump — Display Full-Text Index information
- LENGTH(), String Functions
- less than (<), Comparison Functions and Operators
- less than or equal (<=), Comparison Functions and Operators
- libmysqld, libmysqld, the Embedded MySQL Server Library
- options, Options with the Embedded Server
- libmysqld-libs option
- mysql_config, mysql_config — Get Compile Options for Compiling Clients
- library
- mysqlclient, Connectors and APIs
- mysqld, Connectors and APIs
- libs option
- mysql_config, mysql_config — Get Compile Options for Compiling Clients
- libs_r option
- mysql_config, mysql_config — Get Compile Options for Compiling Clients
- license system variable, Server System Variables
- LIKE, String Comparison Functions
- and indexes, How MySQL Uses Indexes
- and wildcards, How MySQL Uses Indexes
- LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax
- and replication, Replication and LIMIT
- limitations
- design, MySQL Design Limitations and Tradeoffs
- MySQL Limitations, Limits in MySQL
- replication, Replication Features and Issues
- limitations of MySQL Cluster, Known Limitations of MySQL Cluster
- limits
- file-size, The table is full
- MySQL Limits, limits in MySQL, Limits in MySQL
- line-numbers option
- mysql, mysql Options
- linear hash partitioning, LINEAR HASH Partitioning
- linear key partitioning, KEY Partitioning
- linefeed (\n), Strings, LOAD DATA INFILE Syntax
- LineFromText(), Creating Geometry Values Using WKT Functions
- LineFromWKB(), Creating Geometry Values Using WKB Functions
- lines-terminated-by option
- LINESTRING data type, MySQL Spatial Data Types
- LineString(), Creating Geometry Values Using MySQL-Specific Functions
- LineStringFromText(), Creating Geometry Values Using WKT Functions
- LineStringFromWKB(), Creating Geometry Values Using WKB Functions
- linking, Building Client Programs
- links
- symbolic, Using Symbolic Links
- list partitioning, LIST Partitioning
- list partitions
- adding and dropping, Management of RANGE and LIST Partitions
- managing, Management of RANGE and LIST Partitions
- list-users option
- mysqlmanager, MySQL Instance Manager Command Options
- literals, Literal Values
- LN(), Mathematical Functions
- LOAD DATA
- and replication, Replication and LOAD DATA INFILE
- LOAD DATA FROM MASTER, LOAD DATA FROM MASTER Syntax
- LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values
- load emulation, mysqlslap — Load Emulation Client
- LOAD INDEX INTO CACHE
- and partitioning, Restrictions and Limitations on Partitioning
- LOAD TABLE FROM MASTER, LOAD TABLE tbl_name FROM MASTER Syntax
- loading
- tables, Loading Data into a Table
- LOAD_FILE(), String Functions
- local checkpoints (MySQL Cluster), Configuring MySQL Cluster Parameters for Local Checkpoints
- local option
- mysqlimport, mysqlimport — A Data Import Program
- local-infile option
- mysql, mysql Options
- mysqld, Security-Related mysqld Options
- local-load option
- localization, Internationalization and Localization
- localstatedir option
- configure, Typical configure Options
- LOCALTIME, Date and Time Functions
- LOCALTIMESTAMP, Date and Time Functions
- local_infile system variable, Server System Variables
- LOCATE(), String Functions
- LOCK IN SHARE MODE, SELECT Syntax
- Lock Monitor
- lock option
- ndb_select_all, ndb_select_all — Print Rows from an NDB Table
- LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax
- lock-all-tables option
- mysqldump, mysqldump — A Database Backup Program
- lock-directory option
- mysqlslap, mysqlslap — Load Emulation Client
- lock-tables option
- mysqldump, mysqldump — A Database Backup Program
- mysqlimport, mysqlimport — A Data Import Program
- Locked
- thread state, General Thread States
- locked_in_memory system variable, Server System Variables
- LockExecuteThreadToCPU, Defining MySQL Cluster Data Nodes
- locking, System Factors and Startup Parameter Tuning
- external, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
- internal, Internal Locking Methods
- row-level, Transactions and Atomic Operations, Internal Locking Methods
- table-level, Internal Locking Methods
- locking methods, Internal Locking Methods
- LockMaintThreadsToCPU, Defining MySQL Cluster Data Nodes
- LockPagesInMainMemory, Defining MySQL Cluster Data Nodes
- log
- changes, MySQL Change History
- log files, Typical configure Options
- maintaining, Server Log Maintenance
- log files (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon
- log option
- mysqld, Server Command Options
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqlmanager, MySQL Instance Manager Command Options
- log system variable, Server System Variables
- LOG(), Mathematical Functions
- log-bin option
- mysqld, Binary Log Options and Variables
- log-bin-index option
- mysqld, Binary Log Options and Variables
- log-bin-trust-function-creators option
- mysqld, Binary Log Options and Variables
- log-error option
- mysqld, Server Command Options
- mysqldump, mysqldump — A Database Backup Program
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- log-isam option
- mysqld, Server Command Options
- log-long-format option
- mysqld, Server Command Options
- log-output option
- mysqld, Server Command Options
- log-queries-not-using-indexes option
- mysqld, Server Command Options
- log-short-format option
- mysqld, Server Command Options
- log-slave-updates option
- log-slow-admin-statements option
- mysqld, Server Command Options
- log-slow-queries option
- mysqld, Server Command Options
- log-slow-slave-statements option
- log-tc option
- mysqld, Server Command Options
- log-tc-size option
- mysqld, Server Command Options
- log-warnings option
- LOG10(), Mathematical Functions
- LOG2(), Mathematical Functions
- logbuffers
- ndbinfo table, The ndbinfo logbuffers Table
- LogDestination, Defining a MySQL Cluster Management Server
- logging commands (MySQL Cluster), MySQL Cluster Logging Management Commands
- logging slow query
- thread state, General Thread States
- logical operators, Logical Operators
- login
- thread state, General Thread States
- LogLevelCheckpoint, Defining MySQL Cluster Data Nodes
- LogLevelCongestion, Defining MySQL Cluster Data Nodes
- LogLevelConnection, Defining MySQL Cluster Data Nodes
- LogLevelError, Defining MySQL Cluster Data Nodes
- LogLevelInfo, Defining MySQL Cluster Data Nodes
- LogLevelNodeRestart, Defining MySQL Cluster Data Nodes
- LogLevelShutdown, Defining MySQL Cluster Data Nodes
- LogLevelStartup, Defining MySQL Cluster Data Nodes
- LogLevelStatistic, Defining MySQL Cluster Data Nodes
- logs
- flushing, MySQL Server Logs
- server, MySQL Server Logs
- logspaces
- ndbinfo table, The ndbinfo logspaces Table
- log_bin system variable, Server System Variables
- log_bin_trust_function_creators system variable, Server System Variables
- log_error system variable, Server System Variables
- log_output system variable, Server System Variables
- log_queries_not_using_indexes system variable, Server System Variables
- log_slave_updates system variable, Server System Variables
- log_slow_queries system variable, Server System Variables
- log_warnings system variable, Server System Variables
- Long Data
- thread command, Thread Command Values
- LONG data type, The BLOB and TEXT Types
- LONGBLOB data type, Overview of String Types
- LongMessageBuffer, Defining MySQL Cluster Data Nodes
- LONGTEXT data type, Overview of String Types
- long_query_time system variable, Server System Variables
- LOOP, LOOP Statement
- loops option
- ndb_show_tables, ndb_show_tables — Display List of NDB Tables
- lost connection errors, Lost connection to MySQL server
- low-priority option
- mysqlimport, mysqlimport — A Data Import Program
- low-priority-updates option
- mysqld, Server Command Options
- LOWER(), String Functions
- lower_case_file_system system variable, Server System Variables
- lower_case_table_names system variable, Server System Variables
- low_priority_updates system variable, Server System Variables
- LPAD(), String Functions
- LTRIM(), String Functions
M
[index top]- Mac OS X, MySQL Connector/ODBC
- installation, Installing MySQL on Mac OS X
- mailing list address, General Information
- mailing lists, MySQL Mailing Lists
- archive location, MySQL Mailing Lists
- guidelines, Guidelines for Using the Mailing Lists
- main features of MySQL, The Main Features of MySQL
- maintaining
- log files, Server Log Maintenance
- tables, Setting Up a MyISAM Table Maintenance Schedule
- maintenance
- MAKEDATE(), Date and Time Functions
- MAKETIME(), Date and Time Functions
- make_binary_distribution, Overview of MySQL Programs
- MAKE_SET(), String Functions
- make_win_bin_dist, Overview of MySQL Programs, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- exe-suffix option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- no-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- no-embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- only-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
- Making temp file
- thread state, Replication Slave SQL Thread States
- malicious SQL statements
- and MySQL Cluster, MySQL Cluster and MySQL Privileges
- manage keys
- thread state, General Thread States
- management client (MySQL Cluster), ndb_mgm — The MySQL Cluster Management Client
- (see also mgm)
- management node (MySQL Cluster)
- defined, MySQL Cluster Core Concepts
- management nodes (MySQL Cluster), ndb_mgmd — The MySQL Cluster Management Server Daemon
- (see also mgmd)
- managing MySQL Cluster, Management of MySQL Cluster
- managing MySQL Cluster processes, MySQL Cluster Programs
- manual
- available formats, About This Manual
- online location, About This Manual
- syntax conventions, Typographical and Syntax Conventions
- typographical conventions, Typographical and Syntax Conventions
- master-connect-retry option
- master-data option
- mysqldump, mysqldump — A Database Backup Program
- master-host option
- master-info-file option
- master-password option
- master-port option
- master-retry-count option
- master-ssl option
- master-ssl-ca option
- master-ssl-capath option
- master-ssl-cert option
- master-ssl-cipher option
- master-ssl-key option
- master-user option
- MASTER_POS_WAIT(), Miscellaneous Functions, MASTER_POS_WAIT() Syntax
- MATCH ... AGAINST(), Full-Text Search Functions
- matching
- patterns, Pattern Matching
- math, Precision Math
- mathematical functions, Mathematical Functions
- MAX(), GROUP BY (Aggregate) Functions
- MAX(DISTINCT), GROUP BY (Aggregate) Functions
- max-binlog-dump-events option
- mysqld, Binary Log Options and Variables
- max-record-length option
- myisamchk, myisamchk Repair Options
- max-relay-log-size option
- MaxBufferedEpochs, Defining MySQL Cluster Data Nodes
- MAXDB SQL mode, Server SQL Modes
- maximum memory used, mysqladmin — Client for Administering a MySQL Server
- maximums
- maximum columns per table, The Maximum Number of Columns Per Table
- maximum tables per join, Limits of Joins
- MaxLCPStartDelay, Defining MySQL Cluster Data Nodes
- MaxNoOfAttributes, Defining MySQL Cluster Data Nodes
- MaxNoOfConcurrentIndexOperations, Defining MySQL Cluster Data Nodes
- MaxNoOfConcurrentOperations, Defining MySQL Cluster Data Nodes
- MaxNoOfConcurrentScans, Defining MySQL Cluster Data Nodes
- MaxNoOfConcurrentSubOperations, Defining MySQL Cluster Data Nodes
- MaxNoOfConcurrentTransactions, Defining MySQL Cluster Data Nodes
- MaxNoOfExecutionThreads
- MaxNoOfFiredTriggers, Defining MySQL Cluster Data Nodes
- MaxNoOfIndexes, Defining MySQL Cluster Data Nodes
- MaxNoOfLocalOperations, Defining MySQL Cluster Data Nodes
- MaxNoOfLocalScans, Defining MySQL Cluster Data Nodes
- MaxNoOfOpenFiles, Defining MySQL Cluster Data Nodes
- MaxNoOfOrderedIndexes, Defining MySQL Cluster Data Nodes
- MaxNoOfSavedMessages, Defining MySQL Cluster Data Nodes
- MaxNoOfSubscribers, Defining MySQL Cluster Data Nodes
- MaxNoOfSubscriptions, Defining MySQL Cluster Data Nodes
- MaxNoOfTables, Defining MySQL Cluster Data Nodes
- MaxNoOfTriggers, Defining MySQL Cluster Data Nodes
- MaxNoOfUniqueHashIndexes, Defining MySQL Cluster Data Nodes
- MaxScanBatchSize, Defining SQL and Other API Nodes in a MySQL Cluster
- max_allowed_packet
- and replication, Replication and max_allowed_packet
- max_allowed_packet system variable, Server System Variables
- max_allowed_packet variable, mysql Options
- max_binlog_cache_size system variable, Binary Log Options and Variables
- max_binlog_size system variable, Binary Log Options and Variables
- max_connections system variable, Server System Variables
- MAX_CONNECTIONS_PER_HOUR, Setting Account Resource Limits
- max_connect_errors system variable, Server System Variables
- max_delayed_threads system variable, Server System Variables
- max_error_count system variable, Server System Variables
- max_heap_table_size system variable, Server System Variables
- max_insert_delayed_threads system variable, Server System Variables
- max_join_size system variable, Server System Variables
- max_join_size variable, mysql Options
- max_length_for_sort_data system variable, Server System Variables
- max_prepared_stmt_count system variable, Server System Variables
- MAX_QUERIES_PER_HOUR, Setting Account Resource Limits
- max_relay_log_size system variable, Server System Variables
- max_seeks_for_key system variable, Server System Variables
- max_sort_length system variable, Server System Variables
- max_sp_recursion_depth system variable, Server System Variables
- max_tmp_tables system variable, Server System Variables
- MAX_UPDATES_PER_HOUR, Setting Account Resource Limits
- MAX_USER_CONNECTIONS, Setting Account Resource Limits
- max_user_connections system variable, Server System Variables
- max_write_lock_count system variable, Server System Variables
- MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBRContains(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBRDisjoint(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBREqual(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBRIntersects(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBROverlaps(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBRTouches(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MBRWithin(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
- MD5(), Encryption and Compression Functions
- medium-check option
- myisamchk, myisamchk Check Options
- mysqlcheck, mysqlcheck — A Table Maintenance Program
- MEDIUMBLOB data type, Overview of String Types
- MEDIUMINT data type, Overview of Numeric Types
- MEDIUMTEXT data type, Overview of String Types
- memlock option
- mysqld, Server Command Options
- MEMORY storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine
- and replication, Replication and MEMORY Tables
- memory usage
- myisamchk, myisamchk Memory Usage
- memory use, mysqladmin — Client for Administering a MySQL Server, How MySQL Uses Memory
- in MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits
- memoryusage
- ndbinfo table, The ndbinfo memoryusage Table
- MemReportFrequency, Defining MySQL Cluster Data Nodes
- MERGE storage engine, Storage Engines, The MERGE Storage Engine
- MERGE tables
- defined, The MERGE Storage Engine
- metadata
- database, INFORMATION_SCHEMA Tables
- stored routines, Stored Routine Metadata
- triggers, Trigger Metadata
- views, View Metadata
- method option
- mysqlhotcopy, mysqlhotcopy — A Database Backup Program
- methods
- locking, Internal Locking Methods
- mgmd (MySQL Cluster)
- defined, MySQL Cluster Core Concepts
- (see also management node (MySQL Cluster))
- MICROSECOND(), Date and Time Functions
- Microsoft Access, Microsoft Access
- Microsoft ADO, Microsoft ADO
- Microsoft Excel, Microsoft Excel and Column Types
- Microsoft Visual Basic, Microsoft Visual Basic
- Microsoft Visual InterDev, Microsoft Visual InterDev
- MID(), String Functions
- MIN(), GROUP BY (Aggregate) Functions
- MIN(DISTINCT), GROUP BY (Aggregate) Functions
- min-examined-row-limit option
- mysqld, Server Command Options
- Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs)
- minus
- unary (-), Arithmetic Operators
- MINUTE(), Date and Time Functions
- min_examined_row_limit system variable, Server System Variables
- mirror sites, How to Get MySQL
- miscellaneous functions, Miscellaneous Functions
- MIT-pthreads, MIT-pthreads Notes
- MLineFromText(), Creating Geometry Values Using WKT Functions
- MLineFromWKB(), Creating Geometry Values Using WKB Functions
- MOD (modulo), Mathematical Functions
- MOD(), Mathematical Functions
- modes
- batch, Using mysql in Batch Mode
- modulo (%), Mathematical Functions
- modulo (MOD), Mathematical Functions
- monitor
- terminal, Tutorial
- monitoring-interval option
- mysqlmanager, MySQL Instance Manager Command Options
- Monitors
- Mono, MySQL Connector/NET
- MONTH(), Date and Time Functions
- MONTHNAME(), Date and Time Functions
- MPointFromText(), Creating Geometry Values Using WKT Functions
- MPointFromWKB(), Creating Geometry Values Using WKB Functions
- MPolyFromText(), Creating Geometry Values Using WKT Functions
- MPolyFromWKB(), Creating Geometry Values Using WKB Functions
- mSQL compatibility, Regular Expressions
- msql2mysql, msql2mysql — Convert mSQL Programs for Use with MySQL
- MSSQL SQL mode, Server SQL Modes
- multi mysqld, mysqld_multi — Manage Multiple MySQL Servers
- multi-byte character sets, Can't initialize character set
- and MySQL Cluster (replication), Known Issues in MySQL Cluster Replication
- multi-byte characters, Multi-Byte Character Support
- multi-column indexes, Multiple-Column Indexes
- multi-master replication
- MULTILINESTRING data type, MySQL Spatial Data Types
- MultiLineString(), Creating Geometry Values Using MySQL-Specific Functions
- MultiLineStringFromText(), Creating Geometry Values Using WKT Functions
- MultiLineStringFromWKB(), Creating Geometry Values Using WKB Functions
- multiple servers, Running Multiple MySQL Servers on the Same Machine
- multiple-part index, CREATE INDEX Syntax
- multiplication (*), Arithmetic Operators
- MULTIPOINT data type, MySQL Spatial Data Types
- MultiPoint(), Creating Geometry Values Using MySQL-Specific Functions
- MultiPointFromText(), Creating Geometry Values Using WKT Functions
- MultiPointFromWKB(), Creating Geometry Values Using WKB Functions
- MULTIPOLYGON data type, MySQL Spatial Data Types
- MultiPolygon(), Creating Geometry Values Using MySQL-Specific Functions
- MultiPolygonFromText(), Creating Geometry Values Using WKT Functions
- MultiPolygonFromWKB(), Creating Geometry Values Using WKB Functions
- My
- derivation, History of MySQL
- my.cnf
- and MySQL Cluster, MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files, MySQL Cluster Configuration: Basic Example
- in MySQL Cluster, MySQL Server Usage for MySQL Cluster
- my.cnf file, Replication Features and Issues
- MyISAM
- MyISAM key cache, The MyISAM Key Cache
- MyISAM storage engine, Storage Engines, The MyISAM Storage Engine
- myisam-block-size option
- mysqld, Server Command Options
- myisam-recover option
- myisamchk, Overview of MySQL Programs, myisamchk — MyISAM Table-Maintenance Utility
- analyze option, Other myisamchk Options
- backup option, myisamchk Repair Options
- block-search option, Other myisamchk Options
- character-sets-dir option, myisamchk Repair Options
- check option, myisamchk Check Options
- check-only-changed option, myisamchk Check Options
- correct-checksum option, myisamchk Repair Options
- data-file-length option, myisamchk Repair Options
- debug option, myisamchk General Options
- description option, Other myisamchk Options
- example output, myisamchk Table Information
- extend-check option, myisamchk Check Options, myisamchk Repair Options
- fast option, myisamchk Check Options
- force option, myisamchk Check Options, myisamchk Repair Options
- help option, myisamchk General Options
- HELP option, myisamchk General Options
- information option, myisamchk Check Options
- keys-used option, myisamchk Repair Options
- max-record-length option, myisamchk Repair Options
- medium-check option, myisamchk Check Options
- no-symlinks option, myisamchk Repair Options
- options, myisamchk General Options
- parallel-recover option, myisamchk Repair Options
- quick option, myisamchk Repair Options
- read-only option, myisamchk Check Options
- recover option, myisamchk Repair Options
- safe-recover option, myisamchk Repair Options
- set-auto-increment[ option, Other myisamchk Options
- set-character-set option, myisamchk Repair Options
- set-collation option, myisamchk Repair Options
- silent option, myisamchk General Options
- sort-index option, Other myisamchk Options
- sort-records option, Other myisamchk Options
- sort-recover option, myisamchk Repair Options
- tmpdir option, myisamchk Repair Options
- unpack option, myisamchk Repair Options
- update-state option, myisamchk Check Options
- verbose option, myisamchk General Options
- version option, myisamchk General Options
- wait option, myisamchk General Options
- myisamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents
- myisampack, Overview of MySQL Programs, myisampack — Generate Compressed, Read-Only MyISAM Tables, Silent Column Specification Changes, Compressed Table Characteristics
- backup option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- character-sets-dir option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- debug option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- force option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- help option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- join option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- silent option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- test option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- tmpdir option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- verbose option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- version option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- wait option, myisampack — Generate Compressed, Read-Only MyISAM Tables
- myisam_block_size myisamchk variable, myisamchk General Options
- myisam_data_pointer_size system variable, Server System Variables
- myisam_ftdump, Overview of MySQL Programs, myisam_ftdump — Display Full-Text Index information
- count option, myisam_ftdump — Display Full-Text Index information
- dump option, myisam_ftdump — Display Full-Text Index information
- help option, myisam_ftdump — Display Full-Text Index information
- length option, myisam_ftdump — Display Full-Text Index information
- stats option, myisam_ftdump — Display Full-Text Index information
- verbose option, myisam_ftdump — Display Full-Text Index information
- myisam_max_sort_file_size system variable, Server System Variables
- myisam_mmap_size system variable, Server System Variables
- myisam_recover_options system variable, Server System Variables
- myisam_repair_threads system variable, Server System Variables
- myisam_sort_buffer_size system variable, Server System Variables
- myisam_stats_method system variable, Server System Variables
- myisam_use_mmap system variable, Server System Variables
- MyODBC, MySQL Connector/ODBC
- MySQL
- defined, What is MySQL?
- introduction, What is MySQL?
- pronunciation, What is MySQL?
- upgrading, mysql_upgrade — Check Tables for MySQL Upgrade
- mysql, Overview of MySQL Programs, mysql — The MySQL Command-Line Tool
- auto-rehash option, mysql Options
- batch option, mysql Options
- character-sets-dir option, mysql Options
- charset command, mysql Commands
- clear command, mysql Commands
- column-names option, mysql Options
- column-type-info option, mysql Options
- comments option, mysql Options
- compress option, mysql Options
- connect command, mysql Commands
- database option, mysql Options
- debug option, mysql Options
- debug-check option, mysql Options
- debug-info option, mysql Options
- default-character-set option, mysql Options
- delimiter command, mysql Commands
- delimiter option, mysql Options
- disable named commands, mysql Options
- edit command, mysql Commands
- ego command, mysql Commands
- execute option, mysql Options
- exit command, mysql Commands
- force option, mysql Options
- go command, mysql Commands
- help command, mysql Commands
- help option, mysql Options
- host option, mysql Options
- html option, mysql Options
- i-am-a-dummy option, mysql Options
- ignore-spaces option, mysql Options
- line-numbers option, mysql Options
- local-infile option, mysql Options
- named-commands option, mysql Options
- no-auto-rehash option, mysql Options
- no-beep option, mysql Options
- no-named-commands option, mysql Options
- no-pager option, mysql Options
- no-tee option, mysql Options
- nopager command, mysql Commands
- notee command, mysql Commands
- nowarning command, mysql Commands
- one-database option, mysql Options
- pager command, mysql Commands
- pager option, mysql Options
- password option, mysql Options
- pipe option, mysql Options
- port option, mysql Options
- print command, mysql Commands
- prompt command, mysql Commands
- prompt option, mysql Options
- protocol option, mysql Options
- quick option, mysql Options
- quit command, mysql Commands
- raw option, mysql Options
- reconnect option, mysql Options
- rehash command, mysql Commands
- safe-updates option, mysql Options
- secure-auth option, mysql Options
- show-warnings option, mysql Options
- sigint-ignore option, mysql Options
- silent option, mysql Options
- skip-column-names option, mysql Options
- skip-line-numbers option, mysql Options
- socket option, mysql Options
- source command, mysql Commands
- SSL options, mysql Options
- status command, mysql Commands
- system command, mysql Commands
- table option, mysql Options
- tee command, mysql Commands
- tee option, mysql Options
- unbuffered option, mysql Options
- use command, mysql Commands
- user option, mysql Options
- verbose option, mysql Options
- version option, mysql Options
- vertical option, mysql Options
- wait option, mysql Options
- warnings command, mysql Commands
- xml option, mysql Options
- MySQL binary distribution, Choosing Which MySQL Distribution to Install
- MYSQL C type, C API Data Structures
- MySQL Cluster, MySQL Cluster NDB 6.X/7.X
- "quick" configuration, Quick Test Setup of MySQL Cluster
- administration, mysqld Command Options for MySQL Cluster, ndbd — The MySQL Cluster Data Node Daemon, ndb_mgmd — The MySQL Cluster Management Server Daemon, ndb_mgm — The MySQL Cluster Management Client, Options Common to MySQL Cluster Programs, Commands in the MySQL Cluster Management Client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- and character sets, Known Issues in MySQL Cluster Replication
- and DNS, MySQL Cluster Multi-Computer How-To
- and INFORMATION_SCHEMA, MySQL Cluster and MySQL Privileges
- and IP addressing, MySQL Cluster Multi-Computer How-To
- and MySQL privileges, MySQL Cluster and MySQL Privileges
- and MySQL root user, MySQL Cluster and MySQL Privileges, MySQL Cluster and MySQL Security Procedures
- and networking, MySQL Cluster Hardware, Software, and Networking Requirements
- and transactions, MySQL 5.1 FAQ: MySQL Cluster
- and virtual machines, MySQL 5.1 FAQ: MySQL Cluster
- API node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes in a MySQL Cluster
- arbitrator, MySQL 5.1 FAQ: MySQL Cluster
- available platforms, MySQL Cluster NDB 6.X/7.X
- backups, ndb_restore — Restore a MySQL Cluster Backup, Online Backup of MySQL Cluster, MySQL Cluster Backup Concepts, Using The MySQL Cluster Management Client to Create a Backup, Configuration for MySQL Cluster Backups, MySQL Cluster Backup Troubleshooting
- benchmarks, MySQL Cluster Interconnects and Performance
- CHECKPOINT Events, MySQL Cluster Log Events
- cluster logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
- CLUSTERLOG commands, MySQL Cluster Logging Management Commands
- CLUSTERLOG STATISTICS command, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- commands, mysqld Command Options for MySQL Cluster, ndbd — The MySQL Cluster Data Node Daemon, ndb_mgmd — The MySQL Cluster Management Server Daemon, ndb_mgm — The MySQL Cluster Management Client, Commands in the MySQL Cluster Management Client
- compiling with icc, Debugging and Porting MySQL
- concepts, MySQL Cluster Core Concepts
- configuration, MySQL Cluster Multi-Computer How-To, MySQL Cluster Configuration, Quick Test Setup of MySQL Cluster, Defining Computers in a MySQL Cluster, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster, Configuring MySQL Cluster Parameters for Local Checkpoints, MySQL Server Usage for MySQL Cluster, ndb_mgmd — The MySQL Cluster Management Server Daemon
- configuration (example), MySQL Cluster Configuration: Basic Example
- configuration changes, Performing a Rolling Restart of a MySQL Cluster
- configuration files, MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files
- configuration parameters, Overview of MySQL Cluster Configuration Parameters, MySQL Cluster Data Node Configuration Parameters, MySQL Cluster Management Node Configuration Parameters, MySQL Cluster SQL Node and API Node Configuration Parameters, Other MySQL Cluster Configuration Parameters
- configuring, Configuration for MySQL Cluster Backups
- CONNECTION Events, MySQL Cluster Log Events
- connectstring, The MySQL Cluster Connectstring
- CREATE NODEGROUP command, Commands in the MySQL Cluster Management Client
- data node, MySQL Cluster Core Concepts, Defining MySQL Cluster Data Nodes
- data nodes, ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- data types supported, MySQL 5.1 FAQ: MySQL Cluster
- defining node hosts, Defining Computers in a MySQL Cluster
- direct connections between nodes, MySQL Cluster TCP/IP Connections Using Direct Connections
- Disk Data tables (see MySQL Cluster Disk Data)
- DROP NODEGROUP command, Commands in the MySQL Cluster Management Client
- ENTER SINGLE USER MODE command, Commands in the MySQL Cluster Management Client
- ERROR Events, MySQL Cluster Log Events
- error logs, ndbd — The MySQL Cluster Data Node Daemon
- error messages, MySQL 5.1 FAQ: MySQL Cluster
- event log format, MySQL Cluster Log Events
- event logging thresholds, MySQL Cluster Logging Management Commands
- event logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
- event severity levels, MySQL Cluster Logging Management Commands
- event types, Event Reports Generated in MySQL Cluster, MySQL Cluster Log Events
- execution threads, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- EXIT command, Commands in the MySQL Cluster Management Client
- EXIT SINGLE USER MODE command, Commands in the MySQL Cluster Management Client
- FAQ, MySQL 5.1 FAQ: MySQL Cluster
- features added in MySQL 5.1, Development History of MySQL Cluster in MySQL 5.1
- GCP Stop errors, Defining MySQL Cluster Data Nodes
- general description, MySQL Cluster Overview
- hardware requirements, MySQL 5.1 FAQ: MySQL Cluster
- HELP command, Commands in the MySQL Cluster Management Client
- HostName parameter
- and security, MySQL Cluster Security and Networking Issues
- how to obtain, MySQL 5.1 FAQ: MySQL Cluster
- importing existing tables, MySQL 5.1 FAQ: MySQL Cluster
- INFO Events, MySQL Cluster Log Events
- information sources, MySQL Cluster NDB 6.X/7.X
- insecurity of communication protocols, MySQL Cluster Security and Networking Issues
- installation, MySQL Cluster Multi-Computer How-To, MySQL Cluster Multi-Computer Installation
- interconnects, Using High-Speed Interconnects with MySQL Cluster
- Java clients, MySQL Cluster Core Concepts
- log files, ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- logging commands, MySQL Cluster Logging Management Commands
- management client (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client
- management commands, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- management node, MySQL Cluster Core Concepts, Defining a MySQL Cluster Management Server
- management nodes, ndb_mgmd — The MySQL Cluster Management Server Daemon
- managing, Management of MySQL Cluster
- master node, MySQL 5.1 FAQ: MySQL Cluster
- memory requirements, MySQL 5.1 FAQ: MySQL Cluster
- memory usage and recovery, Limits and Differences of MySQL Cluster from Standard MySQL Limits, Performing a Rolling Restart of a MySQL Cluster
- mgm, Options Common to MySQL Cluster Programs
- mgm client, Commands in the MySQL Cluster Management Client
- mgm management client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- mgm process, ndb_mgm — The MySQL Cluster Management Client
- mgmd, Options Common to MySQL Cluster Programs
- mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon
- mysqld process, mysqld Command Options for MySQL Cluster, MySQL Server Usage for MySQL Cluster
- ndbd, ndbd — The MySQL Cluster Data Node Daemon, Options Common to MySQL Cluster Programs
- ndbd process, ndbd — The MySQL Cluster Data Node Daemon, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- ndb_mgm, Initial Startup of MySQL Cluster, ndb_mgm — The MySQL Cluster Management Client
- ndb_mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon
- ndb_size.pl (utility), MySQL 5.1 FAQ: MySQL Cluster
- network configuration
- and security, MySQL Cluster Security and Networking Issues
- network transporters, Using High-Speed Interconnects with MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets
- networking, MySQL Cluster TCP/IP Connections Using Direct Connections, MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster
- networking requirements, MySQL 5.1 FAQ: MySQL Cluster
- node failure (single user mode), MySQL Cluster Single User Mode
- node identifiers, MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster
- node logs, Event Reports Generated in MySQL Cluster
- node types, MySQL 5.1 FAQ: MySQL Cluster
- NODERESTART Events, MySQL Cluster Log Events
- nodes and node groups, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- nodes and types, MySQL Cluster Core Concepts
- number of computers required, MySQL 5.1 FAQ: MySQL Cluster
- obtaining, MySQL Cluster Multi-Computer Installation
- partitioning support, Noncompliance with SQL Syntax in MySQL Cluster
- partitions, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- performance, MySQL Cluster Interconnects and Performance
- performing queries, Loading Sample Data into MySQL Cluster and Performing Queries
- platforms supported, MySQL 5.1 FAQ: MySQL Cluster
- preparing for replication, Preparing the MySQL Cluster for Replication
- process management, MySQL Cluster Programs
- QUIT command, Commands in the MySQL Cluster Management Client
- replicas, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- replication, MySQL Cluster Replication
- (see also MySQL Cluster replication)
- REPORT command, Commands in the MySQL Cluster Management Client
- requirements, MySQL Cluster Hardware, Software, and Networking Requirements
- resetting, Performing a Rolling Restart of a MySQL Cluster
- RESTART command, Commands in the MySQL Cluster Management Client
- restarting, Safe Shutdown and Restart of MySQL Cluster
- restoring backups, ndb_restore — Restore a MySQL Cluster Backup
- roles of computers, MySQL 5.1 FAQ: MySQL Cluster
- runtime statistics, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
- SCI (Scalable Coherent Interface), SCI Transport Connections in MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets
- security, MySQL Cluster Security Issues, MySQL 5.1 FAQ: MySQL Cluster
- and firewalls, MySQL Cluster Security and Networking Issues
- and HostName parameter, MySQL Cluster Security and Networking Issues
- and network configuration, MySQL Cluster Security and Networking Issues
- and network ports, MySQL Cluster Security and Networking Issues
- and remote administration, MySQL Cluster Security and Networking Issues
- networking, MySQL Cluster Security and Networking Issues
- security procedures, MySQL Cluster and MySQL Security Procedures
- shared memory transport, MySQL Cluster Shared-Memory Connections
- SHOW command, Commands in the MySQL Cluster Management Client
- SHUTDOWN command, Commands in the MySQL Cluster Management Client
- shutting down, Safe Shutdown and Restart of MySQL Cluster
- single user mode, Commands in the MySQL Cluster Management Client, MySQL Cluster Single User Mode
- SQL node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes in a MySQL Cluster
- SQL nodes, MySQL Server Usage for MySQL Cluster
- SQL statements, MySQL 5.1 FAQ: MySQL Cluster
- SQL statements for monitoring, Quick Reference: MySQL Cluster SQL Statements
- START BACKUP command, MySQL Cluster Backups With MySQL Cluster Replication
- START command, Commands in the MySQL Cluster Management Client
- start phases (summary), Summary of MySQL Cluster Start Phases
- starting, Quick Test Setup of MySQL Cluster
- starting and stopping, MySQL 5.1 FAQ: MySQL Cluster
- starting nodes, Initial Startup of MySQL Cluster
- starting or restarting, Summary of MySQL Cluster Start Phases
- STARTUP Events, MySQL Cluster Log Events
- STATISTICS Events, MySQL Cluster Log Events
- STATUS command, Commands in the MySQL Cluster Management Client
- STOP command, Commands in the MySQL Cluster Management Client
- storage requirements, Data Type Storage Requirements
- Table is full errors, MySQL 5.1 FAQ: MySQL Cluster
- thread states, MySQL Cluster Thread States
- trace files, ndbd — The MySQL Cluster Data Node Daemon
- transaction handling, Limits Relating to Transaction Handling in MySQL Cluster
- transactions, Defining MySQL Cluster Data Nodes
- transporters
- Scalable Coherent Interface (SCI), SCI Transport Connections in MySQL Cluster
- shared memory (SHM), MySQL Cluster Shared-Memory Connections
- TCP/IP, MySQL Cluster TCP/IP Connections Using Direct Connections
- troubleshooting backups, MySQL Cluster Backup Troubleshooting
- upgrades and downgrades, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of a MySQL Cluster, MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility
- using tables and data, Loading Sample Data into MySQL Cluster and Performing Queries
- vs replication, MySQL 5.1 FAQ: MySQL Cluster
- MySQL Cluster Disk Data, MySQL Cluster Disk Data Tables
- creating log file groups, MySQL Cluster Disk Data Objects
- creating tables, MySQL Cluster Disk Data Objects
- creating tablespaces, MySQL Cluster Disk Data Objects
- dropping Disk Data objects, MySQL Cluster Disk Data Objects
- storage requirements, MySQL Cluster Disk Data Storage Requirements
- MySQL Cluster How-To, MySQL Cluster Multi-Computer How-To
- MySQL Cluster in MySQL 5.1, MySQL Cluster Development History
- MySQL Cluster limitations, Known Limitations of MySQL Cluster
- and differences from standard MySQL limits, Limits and Differences of MySQL Cluster from Standard MySQL Limits
- autodiscovery, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- binary logging, Issues Exclusive to MySQL Cluster
- character sets, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- CREATE TABLE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- database objects, Limits Associated with Database Objects in MySQL Cluster
- Disk Data storage, Limitations Relating to MySQL Cluster Disk Data Storage
- error handling and reporting, MySQL Cluster Error Handling
- geometry data types, Noncompliance with SQL Syntax in MySQL Cluster
- implementation, Issues Exclusive to MySQL Cluster
- imposed by configuration, Limits and Differences of MySQL Cluster from Standard MySQL Limits
- INSERT IGNORE, UPDATE IGNORE, and REPLACE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- memory usage and transaction handling, Limits Relating to Transaction Handling in MySQL Cluster
- multiple data nodes, MySQL Cluster Development in MySQL Cluster NDB 6.2, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- multiple management servers, Limitations Relating to Multiple MySQL Cluster Nodes, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- multiple MySQL servers, Limitations Relating to Multiple MySQL Cluster Nodes
- partitioning, Noncompliance with SQL Syntax in MySQL Cluster
- performance, Limitations Relating to Performance in MySQL Cluster
- replication, Noncompliance with SQL Syntax in MySQL Cluster, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- resolved in current version from previous versions, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
- syntax, Noncompliance with SQL Syntax in MySQL Cluster
- transactions, Limits Relating to Transaction Handling in MySQL Cluster
- unsupported features, Unsupported or Missing Features in MySQL Cluster
- MySQL Cluster NDB 6.x, MySQL Cluster Development History
- MySQL Cluster processes, MySQL Cluster Programs
- MySQL Cluster programs, MySQL Cluster Programs
- MySQL Cluster replication, MySQL Cluster Replication
- and --initial option, Known Issues in MySQL Cluster Replication
- and auto_increment* variables, Known Issues in MySQL Cluster Replication
- and circular replication, Known Issues in MySQL Cluster Replication
- and multi-byte character sets, Known Issues in MySQL Cluster Replication
- and primary key, Known Issues in MySQL Cluster Replication
- and single point of failure, Using Two Replication Channels for MySQL Cluster Replication
- backups, MySQL Cluster Backups With MySQL Cluster Replication
- circular replication, MySQL Cluster Replication: Multi-Master and Circular Replication
- concepts, MySQL Cluster Replication: Abbreviations and Symbols, MySQL Cluster Replication: Assumptions and General Requirements
- conflict resolution, MySQL Cluster Replication Conflict Resolution
- failover, Using Two Replication Channels for MySQL Cluster Replication, Implementing Failover with MySQL Cluster Replication
- gap event, Known Issues in MySQL Cluster Replication
- known issues, Known Issues in MySQL Cluster Replication
- loss of connection, Known Issues in MySQL Cluster Replication
- multi-master replication, MySQL Cluster Replication: Multi-Master and Circular Replication
- point-in-time recovery, Point-In-Time Recovery Using MySQL Cluster Replication
- preparing, Preparing the MySQL Cluster for Replication
- requirements, MySQL Cluster Replication: Assumptions and General Requirements
- reset-slave.pl backup automation script, MySQL Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log
- restoring from backup, MySQL Cluster Backups With MySQL Cluster Replication
- starting, Starting MySQL Cluster Replication (Single Replication Channel)
- storage engines other than NDB on slave, Known Issues in MySQL Cluster Replication
- synchronization of master and slave, MySQL Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log
- system tables used, MySQL Cluster Replication Schema and Tables
- mysql command options, mysql Options
- mysql commands
- list of, mysql Commands
- MySQL Dolphin name, History of MySQL
- MySQL history, History of MySQL
- mysql history file, mysql Options
- MySQL Instance Manager, mysqlmanager — The MySQL Instance Manager
- MySQL mailing lists, MySQL Mailing Lists
- MySQL name, History of MySQL
- MySQL privileges
- and MySQL Cluster, MySQL Cluster and MySQL Privileges
- mysql prompt command, mysql Commands
- MySQL server
- mysql source (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File
- MySQL source distribution, Choosing Which MySQL Distribution to Install
- MySQL storage engines, Storage Engines
- MySQL system tables
- and MySQL Cluster, MySQL Cluster and MySQL Privileges
- and replication, Replication of the mysql System Database
- MySQL version, How to Get MySQL
- mysql \. (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File
- MySQL++, MySQL C++ API
- mysql.event table, The Event Scheduler and MySQL Privileges
- mysql.ndb_binlog_index table, MySQL Cluster Replication Schema and Tables
- (see also MySQL Cluster replication)
- mysql.server, Overview of MySQL Programs, mysql.server — MySQL Server Startup Script
- basedir option, mysql.server — MySQL Server Startup Script
- datadir option, mysql.server — MySQL Server Startup Script
- pid-file option, mysql.server — MySQL Server Startup Script
- service-startup-timeout option, mysql.server — MySQL Server Startup Script
- use-manager option, mysql.server — MySQL Server Startup Script
- use-mysqld_safe option, mysql.server — MySQL Server Startup Script
- user option, mysql.server — MySQL Server Startup Script
- mysql.sock
- changing location of, Typical configure Options
- protection, How to Protect or Change the MySQL Unix Socket File
- MYSQL323 SQL mode, Server SQL Modes
- MYSQL40 SQL mode, Server SQL Modes
- mysqlaccess, Overview of MySQL Programs, mysqlaccess — Client for Checking Access Privileges
- brief option, mysqlaccess — Client for Checking Access Privileges
- commit option, mysqlaccess — Client for Checking Access Privileges
- copy option, mysqlaccess — Client for Checking Access Privileges
- db option, mysqlaccess — Client for Checking Access Privileges
- debug option, mysqlaccess — Client for Checking Access Privileges
- help option, mysqlaccess — Client for Checking Access Privileges
- host option, mysqlaccess — Client for Checking Access Privileges
- howto option, mysqlaccess — Client for Checking Access Privileges
- old_server option, mysqlaccess — Client for Checking Access Privileges
- password option, mysqlaccess — Client for Checking Access Privileges
- plan option, mysqlaccess — Client for Checking Access Privileges
- preview option, mysqlaccess — Client for Checking Access Privileges
- relnotes option, mysqlaccess — Client for Checking Access Privileges
- rhost option, mysqlaccess — Client for Checking Access Privileges
- rollback option, mysqlaccess — Client for Checking Access Privileges
- spassword option, mysqlaccess — Client for Checking Access Privileges
- superuser option, mysqlaccess — Client for Checking Access Privileges
- table option, mysqlaccess — Client for Checking Access Privileges
- user option, mysqlaccess — Client for Checking Access Privileges
- version option, mysqlaccess — Client for Checking Access Privileges
- mysqladmin, Overview of MySQL Programs, mysqladmin — Client for Administering a MySQL Server, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax
- character-sets-dir option, mysqladmin — Client for Administering a MySQL Server
- compress option, mysqladmin — Client for Administering a MySQL Server
- count option, mysqladmin — Client for Administering a MySQL Server
- debug option, mysqladmin — Client for Administering a MySQL Server
- debug-check option, mysqladmin — Client for Administering a MySQL Server
- debug-info option, mysqladmin — Client for Administering a MySQL Server
- default-character-set option, mysqladmin — Client for Administering a MySQL Server
- force option, mysqladmin — Client for Administering a MySQL Server
- help option, mysqladmin — Client for Administering a MySQL Server
- host option, mysqladmin — Client for Administering a MySQL Server
- no-beep option, mysqladmin — Client for Administering a MySQL Server
- password option, mysqladmin — Client for Administering a MySQL Server
- pipe option, mysqladmin — Client for Administering a MySQL Server
- port option, mysqladmin — Client for Administering a MySQL Server
- protocol option, mysqladmin — Client for Administering a MySQL Server
- relative option, mysqladmin — Client for Administering a MySQL Server
- silent option, mysqladmin — Client for Administering a MySQL Server
- sleep option, mysqladmin — Client for Administering a MySQL Server
- socket option, mysqladmin — Client for Administering a MySQL Server
- SSL options, mysqladmin — Client for Administering a MySQL Server
- user option, mysqladmin — Client for Administering a MySQL Server
- verbose option, mysqladmin — Client for Administering a MySQL Server
- version option, mysqladmin — Client for Administering a MySQL Server
- vertical option, mysqladmin — Client for Administering a MySQL Server
- wait option, mysqladmin — Client for Administering a MySQL Server
- mysqladmin command options, mysqladmin — Client for Administering a MySQL Server
- mysqladmin option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqlbinlog, Overview of MySQL Programs, mysqlbinlog — Utility for Processing Binary Log Files
- base64-output option, mysqlbinlog — Utility for Processing Binary Log Files
- character-sets-dir option, mysqlbinlog — Utility for Processing Binary Log Files
- database option, mysqlbinlog — Utility for Processing Binary Log Files
- debug option, mysqlbinlog — Utility for Processing Binary Log Files
- debug-check option, mysqlbinlog — Utility for Processing Binary Log Files
- debug-info option, mysqlbinlog — Utility for Processing Binary Log Files
- disable-log-bin option, mysqlbinlog — Utility for Processing Binary Log Files
- force-read option, mysqlbinlog — Utility for Processing Binary Log Files
- help option, mysqlbinlog — Utility for Processing Binary Log Files
- hexdump option, mysqlbinlog — Utility for Processing Binary Log Files
- host option, mysqlbinlog — Utility for Processing Binary Log Files
- local-load option, mysqlbinlog — Utility for Processing Binary Log Files
- offset option, mysqlbinlog — Utility for Processing Binary Log Files
- password option, mysqlbinlog — Utility for Processing Binary Log Files
- port option, mysqlbinlog — Utility for Processing Binary Log Files
- position option, mysqlbinlog — Utility for Processing Binary Log Files
- protocol option, mysqlbinlog — Utility for Processing Binary Log Files
- read-from-remote-server option, mysqlbinlog — Utility for Processing Binary Log Files
- result-file option, mysqlbinlog — Utility for Processing Binary Log Files
- server-id option, mysqlbinlog — Utility for Processing Binary Log Files
- set-charset option, mysqlbinlog — Utility for Processing Binary Log Files
- short-form option, mysqlbinlog — Utility for Processing Binary Log Files
- socket option, mysqlbinlog — Utility for Processing Binary Log Files
- start-datetime option, mysqlbinlog — Utility for Processing Binary Log Files
- start-position option, mysqlbinlog — Utility for Processing Binary Log Files
- stop-datetime option, mysqlbinlog — Utility for Processing Binary Log Files
- stop-position option, mysqlbinlog — Utility for Processing Binary Log Files
- to-last-log option, mysqlbinlog — Utility for Processing Binary Log Files
- user option, mysqlbinlog — Utility for Processing Binary Log Files
- verbose option, mysqlbinlog — Utility for Processing Binary Log Files
- version option, mysqlbinlog — Utility for Processing Binary Log Files
- mysqlbug, mysqlbug — Generate Bug Report
- mysqlbug script, How to Report Bugs or Problems
- mysqlcheck, Overview of MySQL Programs, mysqlcheck — A Table Maintenance Program
- all-databases option, mysqlcheck — A Table Maintenance Program
- all-in-1 option, mysqlcheck — A Table Maintenance Program
- analyze option, mysqlcheck — A Table Maintenance Program
- auto-repair option, mysqlcheck — A Table Maintenance Program
- character-sets-dir option, mysqlcheck — A Table Maintenance Program
- check option, mysqlcheck — A Table Maintenance Program
- check-only-changed option, mysqlcheck — A Table Maintenance Program
- check-upgrade option, mysqlcheck — A Table Maintenance Program
- compress option, mysqlcheck — A Table Maintenance Program
- databases option, mysqlcheck — A Table Maintenance Program
- debug option, mysqlcheck — A Table Maintenance Program
- debug-check option, mysqlcheck — A Table Maintenance Program
- debug-info option, mysqlcheck — A Table Maintenance Program
- default-character-set option, mysqlcheck — A Table Maintenance Program
- extended option, mysqlcheck — A Table Maintenance Program
- fast option, mysqlcheck — A Table Maintenance Program
- fix-db-names option, mysqlcheck — A Table Maintenance Program
- fix-table-names option, mysqlcheck — A Table Maintenance Program
- force option, mysqlcheck — A Table Maintenance Program
- help option, mysqlcheck — A Table Maintenance Program
- host option, mysqlcheck — A Table Maintenance Program
- medium-check option, mysqlcheck — A Table Maintenance Program
- optimize option, mysqlcheck — A Table Maintenance Program
- password option, mysqlcheck — A Table Maintenance Program
- pipe option, mysqlcheck — A Table Maintenance Program
- port option, mysqlcheck — A Table Maintenance Program
- protocol option, mysqlcheck — A Table Maintenance Program
- quick option, mysqlcheck — A Table Maintenance Program
- repair option, mysqlcheck — A Table Maintenance Program
- silent option, mysqlcheck — A Table Maintenance Program
- socket option, mysqlcheck — A Table Maintenance Program
- SSL options, mysqlcheck — A Table Maintenance Program
- tables option, mysqlcheck — A Table Maintenance Program
- use-frm option, mysqlcheck — A Table Maintenance Program
- user option, mysqlcheck — A Table Maintenance Program
- verbose option, mysqlcheck — A Table Maintenance Program
- version option, mysqlcheck — A Table Maintenance Program
- write-binlog option, mysqlcheck — A Table Maintenance Program
- mysqlclient library, Connectors and APIs
- mysqld, Overview of MySQL Programs
- abort-slave-event-count option, Replication Slave Options and Variables
- allow-suspicious-udfs option, Server Command Options, Security-Related mysqld Options
- ansi option, Server Command Options
- as MySQL Cluster process, mysqld Command Options for MySQL Cluster, MySQL Server Usage for MySQL Cluster
- basedir option, Server Command Options
- big-tables option, Server Command Options
- bind-address option, Server Command Options
- binlog-do-db option, Binary Log Options and Variables
- binlog-format option, Server Command Options
- binlog-ignore-db option, Binary Log Options and Variables
- binlog-row-event-max-size option, Binary Log Options and Variables
- bootstrap option, Server Command Options
- character-set-client-handshake option, Server Command Options
- character-set-filesystem option, Server Command Options
- character-set-server option, Server Command Options
- character-sets-dir option, Server Command Options
- chroot option, Server Command Options
- collation-server option, Server Command Options
- command options, Server Command Options
- console option, Server Command Options
- core-file option, Server Command Options
- datadir option, Server Command Options
- debug option, Server Command Options
- debug-sync-timeout option, Server Command Options
- default-character-set option, Server Command Options
- default-collation option, Server Command Options
- default-storage-engine option, Server Command Options
- default-table-type option, Server Command Options
- default-time-zone option, Server Command Options
- delay-key-write option, Server Command Options, MyISAM Startup Options
- des-key-file option, Server Command Options
- disconnect-slave-event-count option, Replication Slave Options and Variables
- enable-named-pipe option, Server Command Options
- enable-pstack option, Server Command Options
- event-scheduler option, Server Command Options
- exit-info option, Server Command Options
- external-locking option, Server Command Options
- flush option, Server Command Options
- gdb option, Server Command Options
- general-log option, Server Command Options
- help option, Server Command Options
- ignore-builtin-innodb option, InnoDB Startup Options and System Variables
- init-file option, Server Command Options
- innodb option, InnoDB Startup Options and System Variables
- innodb-status-file option, InnoDB Startup Options and System Variables
- language option, Server Command Options
- large-pages option, Server Command Options
- local-infile option, Security-Related mysqld Options
- log option, Server Command Options
- log-bin option, Binary Log Options and Variables
- log-bin-index option, Binary Log Options and Variables
- log-bin-trust-function-creators option, Binary Log Options and Variables
- log-error option, Server Command Options
- log-isam option, Server Command Options
- log-long-format option, Server Command Options
- log-output option, Server Command Options
- log-queries-not-using-indexes option, Server Command Options
- log-short-format option, Server Command Options
- log-slave-updates option, Replication Slave Options and Variables
- log-slow-admin-statements option, Server Command Options
- log-slow-queries option, Server Command Options
- log-slow-slave-statements option, Replication Slave Options and Variables
- log-tc option, Server Command Options
- log-tc-size option, Server Command Options
- log-warnings option, Server Command Options, Replication Slave Options and Variables
- low-priority-updates option, Server Command Options
- master-connect-retry option, Replication Slave Options and Variables
- master-host option, Replication Slave Options and Variables
- master-info-file option, Replication Slave Options and Variables
- master-password option, Replication Slave Options and Variables
- master-port option, Replication Slave Options and Variables
- master-retry-count option, Replication Slave Options and Variables
- master-ssl option, Replication Slave Options and Variables
- master-ssl-ca option, Replication Slave Options and Variables
- master-ssl-capath option, Replication Slave Options and Variables
- master-ssl-cert option, Replication Slave Options and Variables
- master-ssl-cipher option, Replication Slave Options and Variables
- master-ssl-key option, Replication Slave Options and Variables
- master-user option, Replication Slave Options and Variables
- max-binlog-dump-events option, Binary Log Options and Variables
- max-relay-log-size option, Replication Slave Options and Variables
- memlock option, Server Command Options
- min-examined-row-limit option, Server Command Options
- myisam-block-size option, Server Command Options
- myisam-recover option, Server Command Options, MyISAM Startup Options
- MySQL server, mysqld — The MySQL Server, The MySQL Server
- ndb-batch-size option, mysqld Command Options for MySQL Cluster
- ndb-cluster-connection-pool option, mysqld Command Options for MySQL Cluster
- ndb-connectstring option, mysqld Command Options for MySQL Cluster
- ndb-nodeid, mysqld Command Options for MySQL Cluster
- ndbcluster option, mysqld Command Options for MySQL Cluster
- old-alter-table option, Server Command Options
- old-passwords option, Server Command Options, Security-Related mysqld Options
- old-style-user-limits option, Server Command Options
- one-thread option, Server Command Options
- open-files-limit option, Server Command Options
- partition option, Server Command Options
- pid-file option, Server Command Options
- plugin option prefix, Server Command Options
- plugin-load option, Server Command Options
- port option, Server Command Options
- port-open-timeout option, Server Command Options
- read-only option, Replication Slave Options and Variables
- relay-log option, Replication Slave Options and Variables
- relay-log-index option, Replication Slave Options and Variables
- relay-log-info-file option, Replication Slave Options and Variables
- relay-log-purge option, Replication Slave Options and Variables
- relay-log-space-limit option, Replication Slave Options and Variables
- replicate-do-db option, Replication Slave Options and Variables
- replicate-do-table option, Replication Slave Options and Variables
- replicate-ignore-db option, Replication Slave Options and Variables
- replicate-ignore-table option, Replication Slave Options and Variables
- replicate-rewrite-db option, Replication Slave Options and Variables
- replicate-same-server-id option, Replication Slave Options and Variables
- replicate-wild-do-table option, Replication Slave Options and Variables
- replicate-wild-ignore-table option, Replication Slave Options and Variables
- report-host option, Replication Slave Options and Variables
- report-password option, Replication Slave Options and Variables
- report-port option, Replication Slave Options and Variables
- report-user option, Replication Slave Options and Variables
- role in MySQL Cluster (see SQL Node (MySQL Cluster))
- safe-mode option, Server Command Options
- safe-show-database option, Server Command Options, Security-Related mysqld Options
- safe-user-create option, Server Command Options, Security-Related mysqld Options
- secure-auth option, Server Command Options, Security-Related mysqld Options
- secure-file-priv option, Server Command Options, Security-Related mysqld Options
- server-id option, Replication and Binary Logging Options and Variables
- shared-memory option, Server Command Options
- shared-memory-base-name option, Server Command Options
- show-slave-auth-info option, Replication Slave Options and Variables
- skip-concurrent-insert option, Server Command Options
- skip-event-scheduler option, Server Command Options
- skip-external-locking option, Server Command Options
- skip-grant-tables option, Server Command Options, Security-Related mysqld Options
- skip-host-cache option, Server Command Options
- skip-innodb option, Server Command Options
- skip-merge option, Security-Related mysqld Options
- skip-name-resolve option, Server Command Options, Security-Related mysqld Options
- skip-ndbcluster option, mysqld Command Options for MySQL Cluster
- skip-networking option, Server Command Options, Security-Related mysqld Options
- skip-partition option, Server Command Options
- skip-safemalloc option, Server Command Options
- skip-show-database option, Server Command Options, Security-Related mysqld Options
- skip-slave-start option, Replication Slave Options and Variables
- skip-stack-trace option, Server Command Options
- skip-symbolic-links option, Server Command Options
- skip-thread-priority option, Server Command Options
- slave-load-tmpdir option, Replication Slave Options and Variables
- slave-net-timeout option, Replication Slave Options and Variables
- slave-skip-errors option, Replication Slave Options and Variables
- slave_compressed_protocol option, Replication Slave Options and Variables
- slow-query-log option, Server Command Options
- socket option, Server Command Options
- sporadic-binlog-dump-fail option, Binary Log Options and Variables
- sql-mode option, Server Command Options
- SSL options, Server Command Options, Security-Related mysqld Options
- standalone option, Server Command Options
- starting, How to Run MySQL as a Normal User
- symbolic-links option, Server Command Options
- sysdate-is-now option, Server Command Options
- tc-heuristic-recover option, Server Command Options
- temp-pool option, Server Command Options
- tmpdir option, Server Command Options
- transaction-isolation option, Server Command Options
- user option, Server Command Options
- verbose option, Server Command Options
- version option, Server Command Options
- mysqld (MySQL Cluster), MySQL Cluster Programs
- mysqld library, Connectors and APIs
- mysqld option
- mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysqld options, Tuning Server Parameters
- mysqld server
- buffer sizes, Tuning Server Parameters
- mysqld-safe-compatible option
- mysqlmanager, MySQL Instance Manager Command Options
- mysqld-version option
- mysqld_safe, mysqld_safe — MySQL Server Startup Script
- mysqldump, Copying MySQL Databases to Another Machine, Overview of MySQL Programs, mysqldump — A Database Backup Program
- add-drop-database option, mysqldump — A Database Backup Program
- add-drop-table option, mysqldump — A Database Backup Program
- add-locks option, mysqldump — A Database Backup Program
- all-databases option, mysqldump — A Database Backup Program
- all-tablespaces option, mysqldump — A Database Backup Program
- allow-keywords option, mysqldump — A Database Backup Program
- character-sets-dir option, mysqldump — A Database Backup Program
- comments option, mysqldump — A Database Backup Program
- compact option, mysqldump — A Database Backup Program
- compatible option, mysqldump — A Database Backup Program
- complete-insert option, mysqldump — A Database Backup Program
- compress option, mysqldump — A Database Backup Program
- create-options option, mysqldump — A Database Backup Program
- databases option, mysqldump — A Database Backup Program
- debug option, mysqldump — A Database Backup Program
- debug-check option, mysqldump — A Database Backup Program
- debug-info option, mysqldump — A Database Backup Program
- default-character-set option, mysqldump — A Database Backup Program
- delayed-insert option, mysqldump — A Database Backup Program
- delete-master-logs option, mysqldump — A Database Backup Program
- disable-keys option, mysqldump — A Database Backup Program
- dump-date option, mysqldump — A Database Backup Program
- events option, mysqldump — A Database Backup Program
- extended-insert option, mysqldump — A Database Backup Program
- fields-enclosed-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
- fields-escaped-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
- fields-optionally-enclosed-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
- fields-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
- first-slave option, mysqldump — A Database Backup Program
- flush-logs option, mysqldump — A Database Backup Program
- flush-privileges option, mysqldump — A Database Backup Program
- force option, mysqldump — A Database Backup Program
- help option, mysqldump — A Database Backup Program
- hex-blob option, mysqldump — A Database Backup Program
- host option, mysqldump — A Database Backup Program
- ignore-table option, mysqldump — A Database Backup Program
- insert-ignore option, mysqldump — A Database Backup Program
- lines-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
- lock-all-tables option, mysqldump — A Database Backup Program
- lock-tables option, mysqldump — A Database Backup Program
- log-error option, mysqldump — A Database Backup Program
- master-data option, mysqldump — A Database Backup Program
- no-autocommit option, mysqldump — A Database Backup Program
- no-create-db option, mysqldump — A Database Backup Program
- no-create-info option, mysqldump — A Database Backup Program
- no-data option, mysqldump — A Database Backup Program
- no-set-names option, mysqldump — A Database Backup Program
- no-tablespaces option, mysqldump — A Database Backup Program
- opt option, mysqldump — A Database Backup Program
- order-by-primary option, mysqldump — A Database Backup Program
- password option, mysqldump — A Database Backup Program
- pipe option, mysqldump — A Database Backup Program
- port option, mysqldump — A Database Backup Program
- problems, mysqldump — A Database Backup Program, Restrictions on Views
- protocol option, mysqldump — A Database Backup Program
- quick option, mysqldump — A Database Backup Program
- quote-names option, mysqldump — A Database Backup Program
- replace option, mysqldump — A Database Backup Program
- result-file option, mysqldump — A Database Backup Program
- routines option, mysqldump — A Database Backup Program
- set-charset option, mysqldump — A Database Backup Program
- single-transaction option, mysqldump — A Database Backup Program
- skip-comments option, mysqldump — A Database Backup Program
- skip-opt option, mysqldump — A Database Backup Program
- socket option, mysqldump — A Database Backup Program
- SSL options, mysqldump — A Database Backup Program
- tab option, mysqldump — A Database Backup Program
- tables option, mysqldump — A Database Backup Program
- triggers option, mysqldump — A Database Backup Program
- tz-utc option, mysqldump — A Database Backup Program
- user option, mysqldump — A Database Backup Program
- using for backups, Using mysqldump for Backups
- verbose option, mysqldump — A Database Backup Program
- version option, mysqldump — A Database Backup Program
- views, mysqldump — A Database Backup Program, Restrictions on Views
- where option, mysqldump — A Database Backup Program
- workarounds, mysqldump — A Database Backup Program, Restrictions on Views
- xml option, mysqldump — A Database Backup Program
- mysqldumpslow, Overview of MySQL Programs, mysqldumpslow — Summarize Slow Query Log Files
- debug option, mysqldumpslow — Summarize Slow Query Log Files
- help option, mysqldumpslow — Summarize Slow Query Log Files
- verbose option, mysqldumpslow — Summarize Slow Query Log Files
- mysqld_multi, Overview of MySQL Programs, mysqld_multi — Manage Multiple MySQL Servers
- config-file option, mysqld_multi — Manage Multiple MySQL Servers
- defaults-extra-file option, mysqld_multi — Manage Multiple MySQL Servers
- defaults-file option, mysqld_multi — Manage Multiple MySQL Servers
- example option, mysqld_multi — Manage Multiple MySQL Servers
- help option, mysqld_multi — Manage Multiple MySQL Servers
- log option, mysqld_multi — Manage Multiple MySQL Servers
- mysqladmin option, mysqld_multi — Manage Multiple MySQL Servers
- mysqld option, mysqld_multi — Manage Multiple MySQL Servers
- no-defaults option, mysqld_multi — Manage Multiple MySQL Servers
- no-log option, mysqld_multi — Manage Multiple MySQL Servers
- password option, mysqld_multi — Manage Multiple MySQL Servers
- silent option, mysqld_multi — Manage Multiple MySQL Servers
- tcp-ip option, mysqld_multi — Manage Multiple MySQL Servers
- user option, mysqld_multi — Manage Multiple MySQL Servers
- verbose option, mysqld_multi — Manage Multiple MySQL Servers
- version option, mysqld_multi — Manage Multiple MySQL Servers
- mysqld_safe, Overview of MySQL Programs, mysqld_safe — MySQL Server Startup Script
- autoclose option, mysqld_safe — MySQL Server Startup Script
- basedir option, mysqld_safe — MySQL Server Startup Script
- core-file-size option, mysqld_safe — MySQL Server Startup Script
- datadir option, mysqld_safe — MySQL Server Startup Script
- defaults-extra-file option, mysqld_safe — MySQL Server Startup Script
- defaults-file option, mysqld_safe — MySQL Server Startup Script
- help option, mysqld_safe — MySQL Server Startup Script
- ledir option, mysqld_safe — MySQL Server Startup Script
- log-error option, mysqld_safe — MySQL Server Startup Script
- mysqld option, mysqld_safe — MySQL Server Startup Script
- mysqld-version option, mysqld_safe — MySQL Server Startup Script
- nice option, mysqld_safe — MySQL Server Startup Script
- no-defaults option, mysqld_safe — MySQL Server Startup Script
- open-files-limit option, mysqld_safe — MySQL Server Startup Script
- pid-file option, mysqld_safe — MySQL Server Startup Script
- port option, mysqld_safe — MySQL Server Startup Script
- skip-kill-mysqld option, mysqld_safe — MySQL Server Startup Script
- skip-syslog option, mysqld_safe — MySQL Server Startup Script
- socket option, mysqld_safe — MySQL Server Startup Script
- syslog option, mysqld_safe — MySQL Server Startup Script
- syslog-tag option, mysqld_safe — MySQL Server Startup Script
- timezone option, mysqld_safe — MySQL Server Startup Script
- user option, mysqld_safe — MySQL Server Startup Script
- mysqlhotcopy, Overview of MySQL Programs, mysqlhotcopy — A Database Backup Program
- addtodest option, mysqlhotcopy — A Database Backup Program
- allowold option, mysqlhotcopy — A Database Backup Program
- checkpoint option, mysqlhotcopy — A Database Backup Program
- chroot option, mysqlhotcopy — A Database Backup Program
- debug option, mysqlhotcopy — A Database Backup Program
- dryrun option, mysqlhotcopy — A Database Backup Program
- flushlog option, mysqlhotcopy — A Database Backup Program
- help option, mysqlhotcopy — A Database Backup Program
- host option, mysqlhotcopy — A Database Backup Program
- keepold option, mysqlhotcopy — A Database Backup Program
- method option, mysqlhotcopy — A Database Backup Program
- noindices option, mysqlhotcopy — A Database Backup Program
- password option, mysqlhotcopy — A Database Backup Program
- port option, mysqlhotcopy — A Database Backup Program
- quiet option, mysqlhotcopy — A Database Backup Program
- record_log_pos option, mysqlhotcopy — A Database Backup Program
- regexp option, mysqlhotcopy — A Database Backup Program
- resetmaster option, mysqlhotcopy — A Database Backup Program
- resetslave option, mysqlhotcopy — A Database Backup Program
- socket option, mysqlhotcopy — A Database Backup Program
- suffix option, mysqlhotcopy — A Database Backup Program
- tmpdir option, mysqlhotcopy — A Database Backup Program
- user option, mysqlhotcopy — A Database Backup Program
- mysqlimport, Copying MySQL Databases to Another Machine, Overview of MySQL Programs, mysqlimport — A Data Import Program, LOAD DATA INFILE Syntax
- character-sets-dir option, mysqlimport — A Data Import Program
- columns option, mysqlimport — A Data Import Program
- compress option, mysqlimport — A Data Import Program
- debug option, mysqlimport — A Data Import Program
- debug-check option, mysqlimport — A Data Import Program
- debug-info option, mysqlimport — A Data Import Program
- default-character-set option, mysqlimport — A Data Import Program
- delete option, mysqlimport — A Data Import Program
- force option, mysqlimport — A Data Import Program
- help option, mysqlimport — A Data Import Program
- host option, mysqlimport — A Data Import Program
- ignore option, mysqlimport — A Data Import Program
- ignore-lines option, mysqlimport — A Data Import Program
- local option, mysqlimport — A Data Import Program
- lock-tables option, mysqlimport — A Data Import Program
- low-priority option, mysqlimport — A Data Import Program
- password option, mysqlimport — A Data Import Program
- pipe option, mysqlimport — A Data Import Program
- port option, mysqlimport — A Data Import Program
- protocol option, mysqlimport — A Data Import Program
- replace option, mysqlimport — A Data Import Program
- silent option, mysqlimport — A Data Import Program
- socket option, mysqlimport — A Data Import Program
- SSL options, mysqlimport — A Data Import Program
- use-threads option, mysqlimport — A Data Import Program
- user option, mysqlimport — A Data Import Program
- verbose option, mysqlimport — A Data Import Program
- version option, mysqlimport — A Data Import Program
- mysqlmanager, Overview of MySQL Programs, mysqlmanager — The MySQL Instance Manager
- add-user option, MySQL Instance Manager Command Options
- angel-pid-file option, MySQL Instance Manager Command Options
- bind-address option, MySQL Instance Manager Command Options
- check-password-file option, MySQL Instance Manager Command Options
- clean-password-file option, MySQL Instance Manager Command Options
- debug option, MySQL Instance Manager Command Options
- default-mysqld-path option, MySQL Instance Manager Command Options
- defaults-file option, MySQL Instance Manager Command Options
- drop-user option, MySQL Instance Manager Command Options
- edit-user option, MySQL Instance Manager Command Options
- help option, MySQL Instance Manager Command Options
- install option, MySQL Instance Manager Command Options
- list-users option, MySQL Instance Manager Command Options
- log option, MySQL Instance Manager Command Options
- monitoring-interval option, MySQL Instance Manager Command Options
- mysqld-safe-compatible option, MySQL Instance Manager Command Options
- password option, MySQL Instance Manager Command Options
- password-file option, MySQL Instance Manager Command Options
- pid-file option, MySQL Instance Manager Command Options
- port option, MySQL Instance Manager Command Options
- print-defaults option, MySQL Instance Manager Command Options
- print-password-line option, MySQL Instance Manager Command Options
- remove option, MySQL Instance Manager Command Options
- run-as-service option, MySQL Instance Manager Command Options
- socket option, MySQL Instance Manager Command Options
- standalone option, MySQL Instance Manager Command Options
- user option, MySQL Instance Manager Command Options
- username option, MySQL Instance Manager Command Options
- version option, MySQL Instance Manager Command Options
- wait-timeout option, MySQL Instance Manager Command Options
- mysqlshow, Overview of MySQL Programs, mysqlshow — Display Database, Table, and Column Information
- character-sets-dir option, mysqlshow — Display Database, Table, and Column Information
- compress option, mysqlshow — Display Database, Table, and Column Information
- count option, mysqlshow — Display Database, Table, and Column Information
- debug option, mysqlshow — Display Database, Table, and Column Information
- debug-check option, mysqlshow — Display Database, Table, and Column Information
- debug-info option, mysqlshow — Display Database, Table, and Column Information
- default-character-set option, mysqlshow — Display Database, Table, and Column Information
- help option, mysqlshow — Display Database, Table, and Column Information
- host option, mysqlshow — Display Database, Table, and Column Information
- keys option, mysqlshow — Display Database, Table, and Column Information
- password option, mysqlshow — Display Database, Table, and Column Information
- pipe option, mysqlshow — Display Database, Table, and Column Information
- port option, mysqlshow — Display Database, Table, and Column Information
- protocol option, mysqlshow — Display Database, Table, and Column Information
- show-table-type option, mysqlshow — Display Database, Table, and Column Information
- socket option, mysqlshow — Display Database, Table, and Column Information
- SSL options, mysqlshow — Display Database, Table, and Column Information
- status option, mysqlshow — Display Database, Table, and Column Information
- user option, mysqlshow — Display Database, Table, and Column Information
- verbose option, mysqlshow — Display Database, Table, and Column Information
- version option, mysqlshow — Display Database, Table, and Column Information
- mysqlslap, Overview of MySQL Programs, mysqlslap — Load Emulation Client
- auto-generate-sql option, mysqlslap — Load Emulation Client
- auto-generate-sql-add-autoincrement option, mysqlslap — Load Emulation Client
- auto-generate-sql-execute-number option,