MySQL 5.1 Release Notes
Related Documentation
PDF (US Ltr)
- 23.2Mb
PDF (A4) - 23.3Mb
EPUB - 5.8Mb
HTML Download (TGZ) - 5.6Mb
HTML Download (Zip) - 5.7Mb
Eclipse Doc Plugin (TGZ) - 6.2Mb
Eclipse Doc Plugin (Zip) - 7.7Mb
Man Pages (TGZ) - 197.1Kb
Man Pages (Zip) - 303.4Kb
Info (Gzip) - 2.2Mb
Info (Zip) - 2.2Mb
PDF (A4) - 23.3Mb
EPUB - 5.8Mb
HTML Download (TGZ) - 5.6Mb
HTML Download (Zip) - 5.7Mb
Eclipse Doc Plugin (TGZ) - 6.2Mb
Eclipse Doc Plugin (Zip) - 7.7Mb
Man Pages (TGZ) - 197.1Kb
Man Pages (Zip) - 303.4Kb
Info (Gzip) - 2.2Mb
Info (Zip) - 2.2Mb
MySQL Backup and Recovery
MySQL Cluster NDB 6.1-7.1
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Replication
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL Cluster NDB 6.1-7.1
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Replication
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
Including MySQL Cluster NDB 6.X/7.X Reference Guide
Abstract
This is the MySQL™ Reference Manual. It documents MySQL
5.1 through 5.1.73, as well as MySQL
Cluster releases based on versions 6.1, 6.2, 6.3, 7.0, and 7.1
of the NDB storage engine through
5.1.15-ndb-6.1.23, 5.1.51-ndb-6.2.19,
5.1.73-ndb-6.3.55, 5.1.73-ndb-7.0.42, and
5.1.73-ndb-7.1.36.
End of Product Lifecycle. Active development for MySQL Database Server version 5.1 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products (http://www.oracle.com/us/support/lifetime-support/index.html). Please consider upgrading to a recent version.
MySQL 5.1 features. This manual describes features that are not included in every edition of MySQL 5.1; such features may not be included in the edition of MySQL 5.1 licensed to you. If you have any questions about the features included in your edition of MySQL 5.1, refer to your MySQL 5.1 license agreement or contact your Oracle sales representative.
For notes detailing the changes in each release, see the MySQL 5.1 Release Notes.
For legal information, see the Legal Notices.
For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.
For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.
Document generated on: 2016-01-06 (revision: 46014)
Table of Contents [+/-]
- Preface and Legal Notices
- 1 General Information [+/-]
- 1.1 About This Manual
- 1.2 Typographical and Syntax Conventions
- 1.3 Overview of the MySQL Database Management System [+/-]
- 1.4 What Is New in MySQL 5.1
- 1.5 MySQL Development History
- 1.6 MySQL Information Sources [+/-]
- 1.7 How to Report Bugs or Problems
- 1.8 MySQL Standards Compliance [+/-]
- 1.9 Credits [+/-]
- 2 Installing and Upgrading MySQL [+/-]
- 2.1 General Installation Guidance [+/-]
- 2.2 Installing MySQL on Unix/Linux Using Generic Binaries
- 2.3 Installing MySQL on Microsoft Windows [+/-]
- 2.3.1 MySQL Installation Layout on Microsoft Windows
- 2.3.2 Choosing the Installation Package for Microsoft Windows
- 2.3.3 MySQL Notifier
- 2.3.4 Installing MySQL on Microsoft Windows Using an MSI Package
- 2.3.5 Using the MySQL Server Instance Config Wizard
- 2.3.6 Installing MySQL on Microsoft Windows Using a noinstall Zip Archive
- 2.3.7 Troubleshooting a Microsoft Windows MySQL Server Installation
- 2.3.8 Windows Postinstallation Procedures
- 2.3.9 Upgrading MySQL Server on Microsoft Windows
- 2.4 Installing MySQL on OS X [+/-]
- 2.5 Installing MySQL on Linux [+/-]
- 2.6 Installing MySQL on Solaris and OpenSolaris [+/-]
- 2.7 Installing MySQL on IBM AIX [+/-]
- 2.8 Installing MySQL on HP-UX [+/-]
- 2.9 Installing MySQL on FreeBSD
- 2.10 Installing MySQL on i5/OS
- 2.11 Installing MySQL from Source [+/-]
- 2.11.1 MySQL Layout for Source Installation
- 2.11.2 Installing MySQL Using a Standard Source Distribution
- 2.11.3 Installing MySQL Using a Development Source Tree
- 2.11.4 MySQL Source-Configuration Options
- 2.11.5 Dealing with Problems Compiling MySQL
- 2.11.6 Compiling and Linking an Optimized mysqld Server
- 2.11.7 Installing MySQL from Source on Windows
- 2.11.8 Notes on Installing MySQL on Solaris from Source
- 2.11.9 Notes on Installing MySQL on AIX from Source
- 2.11.10 Notes on Installing MySQL on HP-UX from Source
- 2.12 Postinstallation Setup and Testing [+/-]
- 2.13 Upgrading or Downgrading MySQL [+/-]
- 2.14 Environment Variables
- 2.15 Perl Installation Notes [+/-]
- 3 Tutorial [+/-]
- 3.1 Connecting to and Disconnecting from the Server
- 3.2 Entering Queries
- 3.3 Creating and Using a Database [+/-]
- 3.4 Getting Information About Databases and Tables
- 3.5 Using mysql in Batch Mode
- 3.6 Examples of Common Queries [+/-]
- 3.6.1 The Maximum Value for a Column
- 3.6.2 The Row Holding the Maximum of a Certain Column
- 3.6.3 Maximum of Column per Group
- 3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column
- 3.6.5 Using User-Defined Variables
- 3.6.6 Using Foreign Keys
- 3.6.7 Searching on Two Keys
- 3.6.8 Calculating Visits Per Day
- 3.6.9 Using AUTO_INCREMENT
- 3.7 Using MySQL with Apache
- 4 MySQL Programs [+/-]
- 4.1 Overview of MySQL Programs
- 4.2 Using MySQL Programs [+/-]
- 4.2.1 Invoking MySQL Programs
- 4.2.2 Connecting to the MySQL Server
- 4.2.3 Specifying Program Options
- 4.2.4 Using Options on the Command Line
- 4.2.5 Program Option Modifiers
- 4.2.6 Using Option Files
- 4.2.7 Command-Line Options that Affect Option-File Handling
- 4.2.8 Using Options to Set Program Variables
- 4.2.9 Option Defaults, Options Expecting Values, and the = Sign
- 4.2.10 Setting Environment Variables
- 4.3 MySQL Server and Server-Startup Programs [+/-]
- 4.4 MySQL Installation-Related Programs [+/-]
- 4.4.1 comp_err — Compile MySQL Error Message File
- 4.4.2 make_win_bin_dist — Package MySQL Distribution as Zip Archive
- 4.4.3 mysqlbug — Generate Bug Report
- 4.4.4 mysql_fix_privilege_tables — Upgrade MySQL System Tables
- 4.4.5 mysql_install_db — Initialize MySQL Data Directory
- 4.4.6 mysql_secure_installation — Improve MySQL Installation Security
- 4.4.7 mysql_tzinfo_to_sql — Load the Time Zone Tables
- 4.4.8 mysql_upgrade — Check and Upgrade MySQL Tables
- 4.5 MySQL Client Programs [+/-]
- 4.5.1 mysql — The MySQL Command-Line Tool
- 4.5.2 mysqladmin — Client for Administering a MySQL Server
- 4.5.3 mysqlcheck — A Table Maintenance Program
- 4.5.4 mysqldump — A Database Backup Program
- 4.5.5 mysqlimport — A Data Import Program
- 4.5.6 mysqlshow — Display Database, Table, and Column Information
- 4.5.7 mysqlslap — Load Emulation Client
- 4.6 MySQL Administrative and Utility Programs [+/-]
- 4.6.1 innochecksum — Offline InnoDB File Checksum Utility
- 4.6.2 myisam_ftdump — Display Full-Text Index information
- 4.6.3 myisamchk — MyISAM Table-Maintenance Utility
- 4.6.4 myisamlog — Display MyISAM Log File Contents
- 4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.6 mysqlaccess — Client for Checking Access Privileges
- 4.6.7 mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.8 mysqldumpslow — Summarize Slow Query Log Files
- 4.6.9 mysqlhotcopy — A Database Backup Program
- 4.6.10 mysqlmanager — The MySQL Instance Manager
- 4.6.11 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.12 mysql_find_rows — Extract SQL Statements from Files
- 4.6.13 mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.14 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.15 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.16 mysql_zap — Kill Processes That Match a Pattern
- 4.7 MySQL Program Development Utilities [+/-]
- 4.8 Miscellaneous Programs [+/-]
- 5 MySQL Server Administration [+/-]
- 5.1 The MySQL Server [+/-]
- 5.1.1 Server Option and Variable Reference
- 5.1.2 Server Configuration Defaults
- 5.1.3 Server Command Options
- 5.1.4 Server System Variables
- 5.1.5 Using System Variables
- 5.1.6 Server Status Variables
- 5.1.7 Server SQL Modes
- 5.1.8 Server Plugins
- 5.1.9 Server-Side Help
- 5.1.10 Server Response to Signals
- 5.1.11 The Server Shutdown Process
- 5.2 MySQL Server Logs [+/-]
- 5.3 Running Multiple MySQL Instances on One Machine [+/-]
- 6 Security [+/-]
- 6.1 General Security Issues [+/-]
- 6.2 The MySQL Access Privilege System [+/-]
- 6.3 MySQL User Account Management [+/-]
- 6.3.1 User Names and Passwords
- 6.3.2 Adding User Accounts
- 6.3.3 Removing User Accounts
- 6.3.4 Setting Account Resource Limits
- 6.3.5 Assigning Account Passwords
- 6.3.6 Using Secure Connections
- 6.3.7 Creating SSL Certificates and Keys Using openssl
- 6.3.8 Connecting to MySQL Remotely from Windows with SSH
- 6.3.9 SQL-Based MySQL Account Activity Auditing
- 7 Backup and Recovery [+/-]
- 8 Optimization [+/-]
- 8.1 Optimization Overview
- 8.2 Optimizing SQL Statements [+/-]
- 8.3 Optimization and Indexes [+/-]
- 8.4 Optimizing Database Structure [+/-]
- 8.5 Optimizing for MyISAM Tables [+/-]
- 8.6 Optimizing for InnoDB Tables [+/-]
- 8.6.1 Optimizing Storage Layout for InnoDB Tables
- 8.6.2 Optimizing InnoDB Transaction Management
- 8.6.3 Optimizing InnoDB Redo Logging
- 8.6.4 Bulk Data Loading for InnoDB Tables
- 8.6.5 Optimizing InnoDB Queries
- 8.6.6 Optimizing InnoDB DDL Operations
- 8.6.7 Optimizing InnoDB Disk I/O
- 8.6.8 Optimizing InnoDB for Systems with Many Tables
- 8.7 Optimizing for MEMORY Tables
- 8.8 Understanding the Query Execution Plan [+/-]
- 8.9 Controlling the Query Optimizer [+/-]
- 8.10 Buffering and Caching [+/-]
- 8.11 Optimizing Locking Operations [+/-]
- 8.12 Optimizing the MySQL Server [+/-]
- 8.13 Measuring Performance (Benchmarking) [+/-]
- 8.14 Examining Thread Information [+/-]
- 8.14.1 Thread Command Values
- 8.14.2 General Thread States
- 8.14.3 Delayed-Insert Thread States
- 8.14.4 Query Cache Thread States
- 8.14.5 Replication Master Thread States
- 8.14.6 Replication Slave I/O Thread States
- 8.14.7 Replication Slave SQL Thread States
- 8.14.8 Replication Slave Connection Thread States
- 8.14.9 MySQL Cluster Thread States
- 8.14.10 Event Scheduler Thread States
- 9 Language Structure [+/-]
- 10 Globalization [+/-]
- 10.1 Character Set Support [+/-]
- 10.1.1 Character Sets and Collations in General
- 10.1.2 Character Sets and Collations in MySQL
- 10.1.3 Specifying Character Sets and Collations
- 10.1.4 Connection Character Sets and Collations
- 10.1.5 Configuring the Character Set and Collation for Applications
- 10.1.6 Character Set for Error Messages
- 10.1.7 Collation Issues
- 10.1.8 String Repertoire
- 10.1.9 Operations Affected by Character Set Support
- 10.1.10 Unicode Support
- 10.1.11 UTF-8 for Metadata
- 10.1.12 Column Character Set Conversion
- 10.1.13 Character Sets and Collations That MySQL Supports
- 10.2 Setting the Error Message Language
- 10.3 Adding a Character Set [+/-]
- 10.4 Adding a Collation to a Character Set [+/-]
- 10.5 Character Set Configuration
- 10.6 MySQL Server Time Zone Support [+/-]
- 10.7 MySQL Server Locale Support
- 11 Data Types [+/-]
- 11.1 Data Type Overview [+/-]
- 11.2 Numeric Types [+/-]
- 11.2.1 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
- 11.2.2 Fixed-Point Types (Exact Value) - DECIMAL, NUMERIC
- 11.2.3 Floating-Point Types (Approximate Value) - FLOAT, DOUBLE
- 11.2.4 Bit-Value Type - BIT
- 11.2.5 Numeric Type Attributes
- 11.2.6 Out-of-Range and Overflow Handling
- 11.3 Date and Time Types [+/-]
- 11.3.1 The DATE, DATETIME, and TIMESTAMP Types
- 11.3.2 The TIME Type
- 11.3.3 The YEAR Type
- 11.3.4 YEAR(2) Limitations and Migrating to YEAR(4)
- 11.3.5 Automatic Initialization and Updating for TIMESTAMP
- 11.3.6 Fractional Seconds in Time Values
- 11.3.7 Conversion Between Date and Time Types
- 11.3.8 Two-Digit Years in Dates
- 11.4 String Types [+/-]
- 11.5 Extensions for Spatial Data [+/-]
- 11.6 Data Type Default Values
- 11.7 Data Type Storage Requirements
- 11.8 Choosing the Right Type for a Column
- 11.9 Using Data Types from Other Database Engines
- 12 Functions and Operators [+/-]
- 12.1 Function and Operator Reference
- 12.2 Type Conversion in Expression Evaluation
- 12.3 Operators [+/-]
- 12.4 Control Flow Functions
- 12.5 String Functions [+/-]
- 12.6 Numeric Functions and Operators [+/-]
- 12.7 Date and Time Functions
- 12.8 What Calendar Is Used By MySQL?
- 12.9 Full-Text Search Functions [+/-]
- 12.10 Cast Functions and Operators
- 12.11 XML Functions
- 12.12 Bit Functions and Operators
- 12.13 Encryption and Compression Functions
- 12.14 Information Functions
- 12.15 Spatial Analysis Functions [+/-]
- 12.15.1 Spatial Function Reference
- 12.15.2 Argument Handling by Spatial Functions
- 12.15.3 Functions That Create Geometry Values from WKT Values
- 12.15.4 Functions That Create Geometry Values from WKB Values
- 12.15.5 MySQL-Specific Functions That Create Geometry Values
- 12.15.6 Geometry Format Conversion Functions
- 12.15.7 Geometry Property Functions
- 12.15.8 Spatial Operator Functions
- 12.15.9 Functions That Test Spatial Relations Between Geometry Objects
- 12.16 Miscellaneous Functions
- 12.17 Functions and Modifiers for Use with GROUP BY Clauses [+/-]
- 12.18 Precision Math [+/-]
- 13 SQL Statement Syntax [+/-]
- 13.1 Data Definition Statements [+/-]
- 13.1.1 ALTER DATABASE Syntax
- 13.1.2 ALTER EVENT Syntax
- 13.1.3 ALTER LOGFILE GROUP Syntax
- 13.1.4 ALTER FUNCTION Syntax
- 13.1.5 ALTER PROCEDURE Syntax
- 13.1.6 ALTER SERVER Syntax
- 13.1.7 ALTER TABLE Syntax
- 13.1.8 ALTER TABLESPACE Syntax
- 13.1.9 ALTER VIEW Syntax
- 13.1.10 CREATE DATABASE Syntax
- 13.1.11 CREATE EVENT Syntax
- 13.1.12 CREATE FUNCTION Syntax
- 13.1.13 CREATE INDEX Syntax
- 13.1.14 CREATE LOGFILE GROUP Syntax
- 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 13.1.16 CREATE SERVER Syntax
- 13.1.17 CREATE TABLE Syntax
- 13.1.18 CREATE TABLESPACE Syntax
- 13.1.19 CREATE TRIGGER Syntax
- 13.1.20 CREATE VIEW Syntax
- 13.1.21 DROP DATABASE Syntax
- 13.1.22 DROP EVENT Syntax
- 13.1.23 DROP FUNCTION Syntax
- 13.1.24 DROP INDEX Syntax
- 13.1.25 DROP LOGFILE GROUP Syntax
- 13.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
- 13.1.27 DROP SERVER Syntax
- 13.1.28 DROP TABLE Syntax
- 13.1.29 DROP TABLESPACE Syntax
- 13.1.30 DROP TRIGGER Syntax
- 13.1.31 DROP VIEW Syntax
- 13.1.32 RENAME DATABASE Syntax
- 13.1.33 RENAME TABLE Syntax
- 13.1.34 TRUNCATE TABLE Syntax
- 13.2 Data Manipulation Statements [+/-]
- 13.3 MySQL Transactional and Locking Statements [+/-]
- 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax
- 13.3.2 Statements That Cannot Be Rolled Back
- 13.3.3 Statements That Cause an Implicit Commit
- 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax
- 13.3.5 LOCK TABLES and UNLOCK TABLES Syntax
- 13.3.6 SET TRANSACTION Syntax
- 13.3.7 XA Transactions
- 13.4 Replication Statements [+/-]
- 13.5 SQL Syntax for Prepared Statements [+/-]
- 13.6 MySQL Compound-Statement Syntax [+/-]
- 13.7 Database Administration Statements [+/-]
- 13.8 MySQL Utility Statements [+/-]
- 14 Storage Engines [+/-]
- 14.1 Comparing Transaction and Nontransaction Engines
- 14.2 Other Storage Engines
- 14.3 Setting the Storage Engine
- 14.4 Overview of MySQL Storage Engine Architecture [+/-]
- 14.5 The MyISAM Storage Engine [+/-]
- 14.6 The InnoDB Storage Engine [+/-]
- 14.6.1 Introduction to InnoDB
- 14.6.2 InnoDB Configuration
- 14.6.3 InnoDB Concepts and Architecture
- 14.6.4 InnoDB Tablespace Management
- 14.6.5 InnoDB Table Management
- 14.6.6 InnoDB Disk I/O and File Space Management
- 14.6.7 InnoDB Startup Options and System Variables
- 14.6.8 InnoDB Monitors
- 14.6.9 InnoDB Backup and Recovery
- 14.6.10 InnoDB and MySQL Replication
- 14.6.11 InnoDB Troubleshooting
- 14.7 The IBMDB2I Storage Engine [+/-]
- 14.8 The MERGE Storage Engine [+/-]
- 14.9 The MEMORY Storage Engine
- 14.10 The EXAMPLE Storage Engine
- 14.11 The FEDERATED Storage Engine [+/-]
- 14.12 The ARCHIVE Storage Engine
- 14.13 The CSV Storage Engine [+/-]
- 14.14 The BLACKHOLE Storage Engine
- 15 High Availability and Scalability [+/-]
- 16 Replication [+/-]
- 16.1 Replication Configuration [+/-]
- 16.2 Replication Implementation [+/-]
- 16.3 Replication Solutions [+/-]
- 16.3.1 Using Replication for Backups
- 16.3.2 Using Replication with Different Master and Slave Storage Engines
- 16.3.3 Using Replication for Scale-Out
- 16.3.4 Replicating Different Databases to Different Slaves
- 16.3.5 Improving Replication Performance
- 16.3.6 Switching Masters During Failover
- 16.3.7 Setting Up Replication Using SSL
- 16.4 Replication Notes and Tips [+/-]
- 17 MySQL Cluster NDB 6.1 - 7.1 [+/-]
- 17.1 MySQL Cluster Overview [+/-]
- 17.1.1 MySQL Cluster Core Concepts
- 17.1.2 MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
- 17.1.3 MySQL Cluster Hardware, Software, and Networking Requirements
- 17.1.4 MySQL Cluster Development History
- 17.1.5 MySQL Server Using InnoDB Compared with MySQL Cluster
- 17.1.6 Known Limitations of MySQL Cluster
- 17.2 MySQL Cluster Installation and Upgrades [+/-]
- 17.2.1 Installing MySQL Cluster on Linux
- 17.2.2 Installing MySQL Cluster on Windows
- 17.2.3 Initial Configuration of MySQL Cluster
- 17.2.4 Initial Startup of MySQL Cluster
- 17.2.5 MySQL Cluster Example with Tables and Data
- 17.2.6 Safe Shutdown and Restart of MySQL Cluster
- 17.2.7 Upgrading and Downgrading MySQL Cluster
- 17.3 Configuration of MySQL Cluster NDB 6.1-7.1 [+/-]
- 17.4 MySQL Cluster Programs [+/-]
- 17.4.1 ndbd — The MySQL Cluster Data Node Daemon
- 17.4.2 ndbinfo_select_all — Select From ndbinfo Tables
- 17.4.3 ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
- 17.4.4 ndb_mgmd — The MySQL Cluster Management Server Daemon
- 17.4.5 ndb_mgm — The MySQL Cluster Management Client
- 17.4.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of MySQL Cluster Tables
- 17.4.7 ndb_config — Extract MySQL Cluster Configuration Information
- 17.4.8 ndb_cpcd — Automate Testing for NDB Development
- 17.4.9 ndb_delete_all — Delete All Rows from an NDB Table
- 17.4.10 ndb_desc — Describe NDB Tables
- 17.4.11 ndb_drop_index — Drop Index from an NDB Table
- 17.4.12 ndb_drop_table — Drop an NDB Table
- 17.4.13 ndb_error_reporter — NDB Error-Reporting Utility
- 17.4.14 ndb_index_stat — NDB Index Statistics Utility
- 17.4.15 ndb_print_backup_file — Print NDB Backup File Contents
- 17.4.16 ndb_print_file — Print NDB Disk Data File Contents
- 17.4.17 ndb_print_schema_file — Print NDB Schema File Contents
- 17.4.18 ndb_print_sys_file — Print NDB System File Contents
- 17.4.19 ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log
- 17.4.20 ndb_restore — Restore a MySQL Cluster Backup
- 17.4.21 ndb_select_all — Print Rows from an NDB Table
- 17.4.22 ndb_select_count — Print Row Counts for NDB Tables
- 17.4.23 ndb_show_tables — Display List of NDB Tables
- 17.4.24 ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 17.4.25 ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 17.4.26 Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs
- 17.5 Management of MySQL Cluster [+/-]
- 17.5.1 Summary of MySQL Cluster Start Phases
- 17.5.2 Commands in the MySQL Cluster Management Client
- 17.5.3 Online Backup of MySQL Cluster
- 17.5.4 MySQL Server Usage for MySQL Cluster
- 17.5.5 Performing a Rolling Restart of a MySQL Cluster
- 17.5.6 Event Reports Generated in MySQL Cluster
- 17.5.7 MySQL Cluster Log Messages
- 17.5.8 MySQL Cluster Single User Mode
- 17.5.9 Quick Reference: MySQL Cluster SQL Statements
- 17.5.10 The ndbinfo MySQL Cluster Information Database
- 17.5.11 MySQL Cluster Security Issues
- 17.5.12 MySQL Cluster Disk Data Tables
- 17.5.13 Adding MySQL Cluster Data Nodes Online
- 17.5.14 Distributed MySQL Privileges for MySQL Cluster
- 17.5.15 NDB API Statistics Counters and Variables
- 17.6 MySQL Cluster Replication [+/-]
- 17.6.1 MySQL Cluster Replication: Abbreviations and Symbols
- 17.6.2 General Requirements for MySQL Cluster Replication
- 17.6.3 Known Issues in MySQL Cluster Replication
- 17.6.4 MySQL Cluster Replication Schema and Tables
- 17.6.5 Preparing the MySQL Cluster for Replication
- 17.6.6 Starting MySQL Cluster Replication (Single Replication Channel)
- 17.6.7 Using Two Replication Channels for MySQL Cluster Replication
- 17.6.8 Implementing Failover with MySQL Cluster Replication
- 17.6.9 MySQL Cluster Backups With MySQL Cluster Replication
- 17.6.10 MySQL Cluster Replication: Multi-Master and Circular Replication
- 17.6.11 MySQL Cluster Replication Conflict Resolution
- 17.7 MySQL Cluster NDB 6.1 - 7.1 Release Notes
- 18 Partitioning [+/-]
- 19 Stored Programs and Views [+/-]
- 20 INFORMATION_SCHEMA Tables [+/-]
- 20.1 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 20.2 The INFORMATION_SCHEMA COLLATIONS Table
- 20.3 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 20.4 The INFORMATION_SCHEMA COLUMNS Table
- 20.5 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 20.6 The INFORMATION_SCHEMA ENGINES Table
- 20.7 The INFORMATION_SCHEMA EVENTS Table
- 20.8 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- 20.9 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- 20.10 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 20.11 The INFORMATION_SCHEMA PARTITIONS Table
- 20.12 The INFORMATION_SCHEMA PLUGINS Table
- 20.13 The INFORMATION_SCHEMA PROCESSLIST Table
- 20.14 The INFORMATION_SCHEMA PROFILING Table
- 20.15 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 20.16 The INFORMATION_SCHEMA ROUTINES Table
- 20.17 The INFORMATION_SCHEMA SCHEMATA Table
- 20.18 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 20.19 The INFORMATION_SCHEMA STATISTICS Table
- 20.20 The INFORMATION_SCHEMA TABLES Table
- 20.21 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 20.22 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 20.23 The INFORMATION_SCHEMA TRIGGERS Table
- 20.24 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 20.25 The INFORMATION_SCHEMA VIEWS Table
- 20.26 INFORMATION_SCHEMA Tables for MySQL Cluster [+/-]
- 20.27 Extensions to SHOW Statements
- 21 Connectors and APIs [+/-]
- 21.1 MySQL Connector/ODBC
- 21.2 MySQL Connector/Net
- 21.3 MySQL Connector/J
- 21.4 MySQL Connector/C++
- 21.5 MySQL Connector/C
- 21.6 MySQL Connector/Python
- 21.7 libmysqld, the Embedded MySQL Server Library [+/-]
- 21.8 MySQL C API [+/-]
- 21.8.1 MySQL C API Implementations
- 21.8.2 Simultaneous MySQL Server and Connector/C Installations
- 21.8.3 Example C API Client Programs
- 21.8.4 Building and Running C API Client Programs
- 21.8.5 C API Data Structures
- 21.8.6 C API Function Overview
- 21.8.7 C API Function Descriptions
- 21.8.8 C API Prepared Statements
- 21.8.9 C API Prepared Statement Data Structures
- 21.8.10 C API Prepared Statement Function Overview
- 21.8.11 C API Prepared Statement Function Descriptions
- 21.8.12 C API Threaded Function Descriptions
- 21.8.13 C API Embedded Server Function Descriptions
- 21.8.14 Common Questions and Problems When Using the C API
- 21.8.15 Controlling Automatic Reconnection Behavior
- 21.8.16 C API Support for Multiple Statement Execution
- 21.8.17 C API Prepared Statement Problems
- 21.8.18 C API Prepared Statement Handling of Date and Time Values
- 21.8.19 C API Support for Prepared CALL Statements
- 21.9 MySQL PHP API
- 21.10 MySQL Perl API
- 21.11 MySQL Python API
- 21.12 MySQL Ruby APIs [+/-]
- 21.13 MySQL Tcl API
- 21.14 MySQL Eiffel Wrapper
- 22 Extending MySQL [+/-]
- 23 MySQL Enterprise Edition [+/-]
- 24 MySQL Workbench
- A MySQL 5.1 Frequently Asked Questions [+/-]
- A.1 MySQL 5.1 FAQ: General
- A.2 MySQL 5.1 FAQ: Storage Engines
- A.3 MySQL 5.1 FAQ: Server SQL Mode
- A.4 MySQL 5.1 FAQ: Stored Procedures and Functions
- A.5 MySQL 5.1 FAQ: Triggers
- A.6 MySQL 5.1 FAQ: Views
- A.7 MySQL 5.1 FAQ: INFORMATION_SCHEMA
- A.8 MySQL 5.1 FAQ: Migration
- A.9 MySQL 5.1 FAQ: Security
- A.10 MySQL 5.1 FAQ: MySQL Cluster
- A.11 MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
- A.12 MySQL 5.1 FAQ: Connectors & APIs
- A.13 MySQL 5.1 FAQ: Replication
- B Errors, Error Codes, and Common Problems [+/-]
- C Restrictions and Limits [+/-]
- D Licenses for Third-Party Components [+/-]
- D.1 ANTLR 3 License
- D.2 dtoa.c License
- D.3 Editline Library (libedit) License
- D.4 FindGTest.cmake License
- D.5 Fred Fish's Dbug Library License
- D.6 getarg License
- D.7 GNU General Public License Version 2.0, June 1991
- D.8 GNU Lesser General Public License Version 2.1, February 1999
- D.9 GNU Libtool License
- D.10 GNU Readline License
- D.11 Google Controlling Master Thread I/O Rate Patch License
- D.12 Google Perftools (TCMalloc utility) License
- D.13 Google SMP Patch License
- D.14 lib_sql.cc License
- D.15 libevent License
- D.16 Linux-PAM License
- D.17 md5 (Message-Digest Algorithm 5) License
- D.18 memcached License
- D.19 nt_servc (Windows NT Service class library) License
- D.20 OpenPAM License
- D.21 Paramiko License
- D.22 Percona Multiple I/O Threads Patch License
- D.23 RegEX-Spencer Library License
- D.24 RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
- D.25 Richard A. O'Keefe String Library License
- D.26 SHA-1 in C License
- D.27 zlib License
- General Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Join Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Statement/Syntax Index
- Status Variable Index
- System Variable Index
- Transaction Isolation Level Index
Download
this Manual
PDF (US Ltr)
- 23.2Mb
PDF (A4) - 23.3Mb
EPUB - 5.8Mb
HTML Download (TGZ) - 5.6Mb
HTML Download (Zip) - 5.7Mb
Eclipse Doc Plugin (TGZ) - 6.2Mb
Eclipse Doc Plugin (Zip) - 7.7Mb
Man Pages (TGZ) - 197.1Kb
Man Pages (Zip) - 303.4Kb
Info (Gzip) - 2.2Mb
Info (Zip) - 2.2Mb
PDF (A4) - 23.3Mb
EPUB - 5.8Mb
HTML Download (TGZ) - 5.6Mb
HTML Download (Zip) - 5.7Mb
Eclipse Doc Plugin (TGZ) - 6.2Mb
Eclipse Doc Plugin (Zip) - 7.7Mb
Man Pages (TGZ) - 197.1Kb
Man Pages (Zip) - 303.4Kb
Info (Gzip) - 2.2Mb
Info (Zip) - 2.2Mb