- MySQL 5.1 Reference Manual
-
- 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
Including MySQL Cluster NDB 6.X/7.X Reference Guide
Copyright © 1997, 2010, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark of Oracle Corporation and/or its affiliates, and shall not be used without Oracle's express written authorization. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle or as specifically provided below. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.
This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms:
You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how Oracle disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of Oracle. Oracle and/or its affiliates reserve any and all rights to this documentation not expressly granted above.
For more information on the terms of this license, for details on how the MySQL documentation is built and produced, or if you are interested in doing a translation, please visit MySQL Contact & Questions.
For additional licensing information, including licenses for libraries used by MySQL products, see Preface, Notes, Licenses.
If you want 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.
Abstract
This is the MySQL™ Reference Manual. It documents MySQL 5.1 through 5.1.49, as well as MySQL Cluster releases based on versions 6.1, 6.2, 6.3, 7.0, and 7.1 of
NDBCLUSTER
through 5.1.15-ndb-6.1.23, 5.1.44-ndb-6.2.19, 5.1.44-ndb-6.3.35, 5.1.44-ndb-7.0.16, and 5.1.44-ndb-7.1.5.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.
Document generated on: 2010-06-15 (revision: 21235)
Table of Contents [+/-]
- Preface, Notes, Licenses [+/-]
- 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. MySQL Development History
- 1.5. What Is New in MySQL 5.1
- 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 from Generic Binaries on Unix/Linux
- 2.3. MySQL Installation Using a Source Distribution [+/-]
- 2.4. Upgrading or Downgrading MySQL [+/-]
- 2.5. Installing MySQL on Windows [+/-]
- 2.5.1. Windows Installation Layout
- 2.5.2. Choosing An Installation Package
- 2.5.3. Installing MySQL with the MSI Package
- 2.5.4. MySQL Server Instance Config Wizard
- 2.5.5. Installing MySQL from a
noinstall
Zip Archive - 2.5.6. Troubleshooting a MySQL Installation Under Windows
- 2.5.7. Upgrading MySQL on Windows
- 2.5.8. Windows Post-Installation Procedures
- 2.5.9. MySQL on Windows Compared to MySQL on Unix
- 2.5.10. Installing MySQL from Source on Windows
- 2.5.11. Compiling MySQL Clients on Windows
- 2.6. Installing MySQL on Linux [+/-]
- 2.7. Installing MySQL on Mac OS X [+/-]
- 2.8. Installing MySQL on Solaris [+/-]
- 2.9. Installing MySQL on i5/OS
- 2.10. Installing MySQL on FreeBSD
- 2.11. Installing MySQL on HP-UX
- 2.12. Installing MySQL on AIX
- 2.13. Post-Installation Setup and Testing [+/-]
- 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. Queries from the Twin Project [+/-]
- 3.8. Using MySQL with Apache
- 4. MySQL Programs [+/-]
- 4.1. Overview of MySQL Programs
- 4.2. Using MySQL Programs [+/-]
- 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 Tables for MySQL Upgrade
- 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 Command Options
- 5.1.3. Server Options for Loading Plugins
- 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-Side Help
- 5.1.9. Server Response to Signals
- 5.1.10. The Shutdown Process
- 5.2. MySQL Server Logs [+/-]
- 5.3. General Security Issues [+/-]
- 5.4. The MySQL Access Privilege System [+/-]
- 5.5. MySQL User Account Management [+/-]
- 5.5.1. User Names and Passwords
- 5.5.2. Adding User Accounts
- 5.5.3. Removing User Accounts
- 5.5.4. Setting Account Resource Limits
- 5.5.5. Assigning Account Passwords
- 5.5.6. Using SSL for Secure Connections
- 5.5.7. Connecting to MySQL Remotely from Windows with SSH
- 5.5.8. Auditing MySQL Account Activity
- 5.6. Running Multiple MySQL Servers on the Same Machine [+/-]
- 6. Backup and Recovery [+/-]
- 7. Optimization [+/-]
- 7.1. Optimization Overview [+/-]
-
7.2. Optimizing
SELECT
and Other Statements [+/-] - 7.2.1. Optimizing Queries with
EXPLAIN
- 7.2.2. Estimating Query Performance
- 7.2.3. Speed of
SELECT
Queries - 7.2.4.
WHERE
Clause Optimization - 7.2.5. Range Optimization
- 7.2.6. Index Merge Optimization
- 7.2.7. Condition Pushdown Optimization
- 7.2.8.
IS NULL
Optimization - 7.2.9.
LEFT JOIN
andRIGHT JOIN
Optimization - 7.2.10. Nested-Loop Join Algorithms
- 7.2.11. Nested Join Optimization
- 7.2.12. Outer Join Simplification
- 7.2.13.
ORDER BY
Optimization - 7.2.14.
GROUP BY
Optimization - 7.2.15.
DISTINCT
Optimization - 7.2.16. Optimizing
IN
/=ANY
Subqueries - 7.2.17.
LIMIT
Optimization - 7.2.18. Using
optimizer_switch
to Control the Optimizer - 7.2.19. How to Avoid Table Scans
- 7.2.20.
INFORMATION_SCHEMA
Optimization - 7.2.21. Speed of
INSERT
Statements - 7.2.22. Speed of
UPDATE
Statements - 7.2.23. Speed of
DELETE
Statements - 7.2.24. Other Optimization Tips
- 7.2.1. Optimizing Queries with
- 7.3. Locking Issues [+/-]
- 7.4. Optimizing Database Structure [+/-]
- 7.4.1. Make Your Data as Small as Possible
- 7.4.2. Column Indexes
- 7.4.3. Multiple-Column Indexes
- 7.4.4. How MySQL Uses Indexes
- 7.4.5. The
MyISAM
Key Cache - 7.4.6. The
InnoDB
Buffer Pool - 7.4.7.
MyISAM
Index Statistics Collection - 7.4.8. How MySQL Opens and Closes Tables
- 7.4.9. Disadvantages of Creating Many Tables in the Same Database
- 7.5. Optimizing the MySQL Server [+/-]
- 7.5.1. How Compiling and Linking Affects the Speed of MySQL
- 7.5.2. System Factors and Startup Parameter Tuning
- 7.5.3. Tuning Server Parameters
- 7.5.4. Controlling Query Optimizer Performance
- 7.5.5. The MySQL Query Cache
- 7.5.6. Examining Thread Information
- 7.5.7. How MySQL Uses Threads for Client Connections
- 7.5.8. How MySQL Uses Memory
- 7.5.9. Enabling Large Page Support
- 7.5.10. How MySQL Uses Internal Temporary Tables
- 7.5.11. How MySQL Uses DNS
- 7.6. Disk Issues [+/-]
- 8. Language Structure [+/-]
- 9. Internationalization and Localization [+/-]
- 9.1. Character Set Support [+/-]
- 9.1.1. Character Sets and Collations in General
- 9.1.2. Character Sets and Collations in MySQL
- 9.1.3. Specifying Character Sets and Collations
- 9.1.4. Connection Character Sets and Collations
- 9.1.5. Configuring the Character Set and Collation for Applications
- 9.1.6. Character Set for Error Messages
- 9.1.7. Collation Issues
- 9.1.8. String Repertoire
- 9.1.9. Operations Affected by Character Set Support
- 9.1.10. Unicode Support
- 9.1.11. UTF-8 for Metadata
- 9.1.12. Column Character Set Conversion
- 9.1.13. Character Sets and Collations That MySQL Supports
- 9.2. Setting the Error Message Language
- 9.3. Adding a New Character Set [+/-]
- 9.4. How to Add a New Collation to a Character Set [+/-]
- 9.5. Character Set Configuration
- 9.6. MySQL Server Time Zone Support [+/-]
- 9.7. MySQL Server Locale Support
- 10. Data Types [+/-]
- 11. Functions and Operators [+/-]
- 11.1. Operator and Function Reference
- 11.2. Operators [+/-]
- 11.3. Control Flow Functions
- 11.4. String Functions [+/-]
- 11.5. Numeric Functions [+/-]
- 11.6. Date and Time Functions
- 11.7. What Calendar Is Used By MySQL?
- 11.8. Full-Text Search Functions [+/-]
- 11.9. Cast Functions and Operators
- 11.10. XML Functions
- 11.11. Other Functions [+/-]
-
11.12. Functions and Modifiers for Use with
GROUP BY
Clauses [+/-] - 11.13. Spatial Extensions [+/-]
- 11.14. Precision Math [+/-]
- 12. SQL Statement Syntax [+/-]
- 12.1. Data Definition Statements [+/-]
- 12.1.1.
ALTER DATABASE
Syntax - 12.1.2.
ALTER EVENT
Syntax - 12.1.3.
ALTER LOGFILE GROUP
Syntax - 12.1.4.
ALTER FUNCTION
Syntax - 12.1.5.
ALTER PROCEDURE
Syntax - 12.1.6.
ALTER SERVER
Syntax - 12.1.7.
ALTER TABLE
Syntax - 12.1.8.
ALTER TABLESPACE
Syntax - 12.1.9.
ALTER VIEW
Syntax - 12.1.10.
CREATE DATABASE
Syntax - 12.1.11.
CREATE EVENT
Syntax - 12.1.12.
CREATE FUNCTION
Syntax - 12.1.13.
CREATE INDEX
Syntax - 12.1.14.
CREATE LOGFILE GROUP
Syntax - 12.1.15.
CREATE PROCEDURE
andCREATE FUNCTION
Syntax - 12.1.16.
CREATE SERVER
Syntax - 12.1.17.
CREATE TABLE
Syntax - 12.1.18.
CREATE TABLESPACE
Syntax - 12.1.19.
CREATE TRIGGER
Syntax - 12.1.20.
CREATE VIEW
Syntax - 12.1.21.
DROP DATABASE
Syntax - 12.1.22.
DROP EVENT
Syntax - 12.1.23.
DROP FUNCTION
Syntax - 12.1.24.
DROP INDEX
Syntax - 12.1.25.
DROP LOGFILE GROUP
Syntax - 12.1.26.
DROP PROCEDURE
andDROP FUNCTION
Syntax - 12.1.27.
DROP SERVER
Syntax - 12.1.28.
DROP TABLE
Syntax - 12.1.29.
DROP TABLESPACE
Syntax - 12.1.30.
DROP TRIGGER
Syntax - 12.1.31.
DROP VIEW
Syntax - 12.1.32.
RENAME DATABASE
Syntax - 12.1.33.
RENAME TABLE
Syntax
- 12.1.1.
- 12.2. Data Manipulation Statements [+/-]
- 12.3. MySQL Transactional and Locking Statements [+/-]
- 12.3.1.
START TRANSACTION
,COMMIT
, andROLLBACK
Syntax - 12.3.2. Statements That Cannot Be Rolled Back
- 12.3.3. Statements That Cause an Implicit Commit
- 12.3.4.
SAVEPOINT
andROLLBACK TO SAVEPOINT
Syntax - 12.3.5.
LOCK TABLES
andUNLOCK TABLES
Syntax - 12.3.6.
SET TRANSACTION
Syntax - 12.3.7. XA Transactions
- 12.3.1.
- 12.4. Database Administration Statements [+/-]
- 12.5. Replication Statements [+/-]
- 12.6. SQL Syntax for Prepared Statements [+/-]
- 12.7. MySQL Compound-Statement Syntax [+/-]
- 12.8. MySQL Utility Statements [+/-]
- 13. Storage Engines [+/-]
- 13.1. Comparing Transaction and Nontransaction Engines
- 13.2. Other Storage Engines
- 13.3. Setting the Storage Engine
- 13.4. Overview of MySQL Storage Engine Architecture [+/-]
-
13.5. The
MyISAM
Storage Engine [+/-] -
13.6. The
InnoDB
Storage Engine [+/-] - 13.6.1.
InnoDB
Contact Information - 13.6.2.
InnoDB
Configuration - 13.6.3.
InnoDB
Startup Options and System Variables - 13.6.4. Creating and Using
InnoDB
Tables - 13.6.5. Adding, Removing, or Resizing
InnoDB
Data and Log Files - 13.6.6. Backing Up and Recovering an
InnoDB
Database - 13.6.7. Moving an
InnoDB
Database to Another Machine - 13.6.8. The
InnoDB
Transaction Model and Locking - 13.6.9.
InnoDB
Multi-Versioning - 13.6.10.
InnoDB
Table and Index Structures - 13.6.11.
InnoDB
Disk I/O and File Space Management - 13.6.12.
InnoDB
Error Handling - 13.6.13.
InnoDB
Performance Tuning and Troubleshooting - 13.6.14. Restrictions on
InnoDB
Tables
- 13.6.1.
-
13.7. The
IBMDB2I
Storage Engine [+/-] - 13.7.1. Installation
- 13.7.2. Configuration Options
- 13.7.3. Creating schemas and tables
- 13.7.4. Database/metadata management
- 13.7.5. Transaction behavior
- 13.7.6. Principles and Terminology
- 13.7.7. Notes and Limitations
- 13.7.8. Character sets and collations
- 13.7.9. Error codes and trouble-shooting information
-
13.8. The
MERGE
Storage Engine [+/-] - 13.9. The
MEMORY
(HEAP
) Storage Engine - 13.10. The
EXAMPLE
Storage Engine -
13.11. The
FEDERATED
Storage Engine [+/-] - 13.12. The
ARCHIVE
Storage Engine -
13.13. The
CSV
Storage Engine [+/-] - 13.14. The
BLACKHOLE
Storage Engine
- 14. High Availability and Scalability [+/-]
- 15. MySQL Enterprise Monitor [+/-]
- 15.1. An Overview of the Service [+/-]
- 15.2. Conventions Used in This Document
- 15.3. Installation and Upgrades [+/-]
- 15.4. MySQL Enterprise Dashboard [+/-]
- 15.5. The Settings Page [+/-]
- 15.6. The What's New Page [+/-]
- 15.7. The Advisors Page [+/-]
- 15.8. The Events Page [+/-]
- 15.9. The Graphs Page [+/-]
- 15.10. The Query Analyzer Page [+/-]
- 15.11. The Replication Page [+/-]
- 15.12. MySQL Enterprise Monitor Reference [+/-]
- 15.12.1. MySQL Enterprise Monitor Limitations
- 15.12.2. Supported Browsers
- 15.12.3. Installation Requirements
- 15.12.4. Creating a new SSL KeyStore
- 15.12.5. Choosing Suitable MySQL Enterprise Service Manager Hardware Configurations
- 15.12.6. MySQL Enterprise Monitor Agent Reference
- 15.12.7. Configuring Tomcat Parameters
- 15.12.8. Backing up MySQL Enterprise Service Manager
- 15.12.9. Migrating 1.3.x Historical Data to MySQL Enterprise Monitor 2.0
- 15.12.10. Regular MySQL Enterprise Monitor Maintenance
- 15.12.11. Advisor/Graph Reference
- 15.13. MySQL Enterprise Monitor Frequently Asked Questions
- 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.X/7.X [+/-]
- 17.1. MySQL Cluster Overview [+/-]
- 17.2. MySQL Cluster Multi-Computer How-To [+/-]
- 17.2.1. MySQL Cluster Multi-Computer Installation
- 17.2.2. MySQL Cluster Multi-Computer Configuration
- 17.2.3. Initial Startup of MySQL Cluster
- 17.2.4. Loading Sample Data into MySQL Cluster and Performing Queries
- 17.2.5. Safe Shutdown and Restart of MySQL Cluster
- 17.2.6. Upgrading and Downgrading MySQL Cluster
- 17.3. MySQL Cluster Configuration [+/-]
- 17.4. MySQL Cluster Programs [+/-]
- 17.4.1. MySQL Server Usage for MySQL Cluster
- 17.4.2. ndbd — The MySQL Cluster Data Node Daemon
- 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_config — Extract MySQL Cluster Configuration Information
- 17.4.7. ndb_cpcd — Automate Testing for NDB Development
- 17.4.8. ndb_delete_all — Delete All Rows from an NDB Table
- 17.4.9. ndb_desc — Describe NDB Tables
- 17.4.10. ndb_drop_index — Drop Index from an NDB Table
- 17.4.11. ndb_drop_table — Drop an NDB Table
- 17.4.12. ndb_error_reporter — NDB Error-Reporting Utility
- 17.4.13. ndb_print_backup_file — Print NDB Backup File Contents
- 17.4.14. ndb_print_schema_file — Print NDB Schema File Contents
- 17.4.15. ndb_print_sys_file — Print NDB System File Contents
- 17.4.16. ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log
- 17.4.17. ndb_restore — Restore a MySQL Cluster Backup
- 17.4.18. ndb_select_all — Print Rows from an NDB Table
- 17.4.19. ndb_select_count — Print Row Counts for NDB Tables
- 17.4.20. ndb_show_tables — Display List of NDB Tables
- 17.4.21. ndb_size.pl — NDBCLUSTER Size Requirement Estimator
- 17.4.22. ndb_waiter — Wait for MySQL Cluster to Reach a Given Status
- 17.4.23. 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. Event Reports Generated in MySQL Cluster
- 17.5.5. MySQL Cluster Log Messages
- 17.5.6. MySQL Cluster Single User Mode
- 17.5.7. Quick Reference: MySQL Cluster SQL Statements
- 17.5.8. The
ndbinfo
MySQL Cluster Information Database - 17.5.9. MySQL Cluster Security Issues
- 17.5.10. MySQL Cluster Disk Data Tables
- 17.5.11. Adding MySQL Cluster Data Nodes Online
- 17.6. MySQL Cluster Replication [+/-]
- 17.6.1. MySQL Cluster Replication: Abbreviations and Symbols
- 17.6.2. MySQL Cluster Replication: Assumptions and General Requirements
- 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. Changes in MySQL Cluster NDB 6.X and 7.X [+/-]
- 18. Partitioning [+/-]
- 19. Stored Programs and Views [+/-]
-
20.
INFORMATION_SCHEMA
Tables [+/-] - 20.1. The
INFORMATION_SCHEMA SCHEMATA
Table - 20.2. The
INFORMATION_SCHEMA TABLES
Table - 20.3. The
INFORMATION_SCHEMA COLUMNS
Table - 20.4. The
INFORMATION_SCHEMA STATISTICS
Table - 20.5. The
INFORMATION_SCHEMA USER_PRIVILEGES
Table - 20.6. The
INFORMATION_SCHEMA SCHEMA_PRIVILEGES
Table - 20.7. The
INFORMATION_SCHEMA TABLE_PRIVILEGES
Table - 20.8. The
INFORMATION_SCHEMA COLUMN_PRIVILEGES
Table - 20.9. The
INFORMATION_SCHEMA CHARACTER_SETS
Table - 20.10. The
INFORMATION_SCHEMA COLLATIONS
Table - 20.11. The
INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY
Table - 20.12. The
INFORMATION_SCHEMA TABLE_CONSTRAINTS
Table - 20.13. The
INFORMATION_SCHEMA KEY_COLUMN_USAGE
Table - 20.14. The
INFORMATION_SCHEMA ROUTINES
Table - 20.15. The
INFORMATION_SCHEMA VIEWS
Table - 20.16. The
INFORMATION_SCHEMA TRIGGERS
Table - 20.17. The
INFORMATION_SCHEMA PLUGINS
Table - 20.18. The
INFORMATION_SCHEMA ENGINES
Table - 20.19. The
INFORMATION_SCHEMA PARTITIONS
Table - 20.20. The
INFORMATION_SCHEMA EVENTS
Table - 20.21. The
INFORMATION_SCHEMA FILES
Table - 20.22. The
INFORMATION_SCHEMA PROCESSLIST
Table - 20.23. The
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS
Table - 20.24. The
INFORMATION_SCHEMA GLOBAL_STATUS
andSESSION_STATUS
Tables - 20.25. The
INFORMATION_SCHEMA GLOBAL_VARIABLES
andSESSION_VARIABLES
Tables - 20.26. The
INFORMATION_SCHEMA PROFILING
Table - 20.27. Other
INFORMATION_SCHEMA
Tables - 20.28. Extensions to
SHOW
Statements
- 20.1. The
- 21. Connectors and APIs [+/-]
- 21.1. MySQL Connector/ODBC [+/-]
- 21.2. MySQL Connector/NET [+/-]
- 21.2.1. Connector/NET Versions
- 21.2.2. Connector/NET Installation
- 21.2.3. Connector/NET Visual Studio Integration
- 21.2.4. Connector/NET Tutorials
- 21.2.5. Connector/NET Programming
- 21.2.6. Connector/NET Connection String Options Reference
- 21.2.7. Connector/NET API Reference
- 21.2.8. Connector/NET Support
- 21.2.9. Connector/NET FAQ
- 21.3. MySQL Connector/J [+/-]
- 21.4. MySQL Connector/MXJ [+/-]
- 21.5. MySQL Connector/C++ [+/-]
- 21.5.1. MySQL Connector/C++ Binary Installation
- 21.5.2. MySQL Connector/C++ Source Installation
- 21.5.3. MySQL Connector/C++ Building Windows applications with Microsoft Visual Studio
- 21.5.4. MySQL Connector/C++ Building Linux applications with NetBeans
- 21.5.5. MySQL Connector/C++ Getting Started: Usage Examples
- 21.5.6. MySQL Connector/C++ Tutorials
- 21.5.7. MySQL Connector/C++ Debug Tracing
- 21.5.8. MySQL Connector/C++ Usage Notes
- 21.5.9. MySQL Connector/C++ Known Bugs and Issues
- 21.5.10. MySQL Connector/C++ Feature requests
- 21.5.11. MySQL Connector/C++ Support
- 21.5.12. MySQL Connector/C++ FAQ
- 21.6. MySQL Connector/C [+/-]
- 21.7. MySQL Connector/OpenOffice.org [+/-]
- 21.8. libmysqld, the Embedded MySQL Server Library [+/-]
- 21.9. MySQL C API [+/-]
- 21.9.1. C API Data Structures
- 21.9.2. C API Function Overview
- 21.9.3. C API Function Descriptions
- 21.9.4. C API Prepared Statements
- 21.9.5. C API Prepared Statement Data Structures
- 21.9.6. C API Prepared Statement Function Overview
- 21.9.7. C API Prepared Statement Function Descriptions
- 21.9.8. C API Threaded Function Descriptions
- 21.9.9. C API Embedded Server Function Descriptions
- 21.9.10. Common Questions and Problems When Using the C API
- 21.9.11. Controlling Automatic Reconnection Behavior
- 21.9.12. C API Support for Multiple Statement Execution
- 21.9.13. C API Prepared Statement Problems
- 21.9.14. C API Prepared Statement Handling of Date and Time Values
- 21.9.15. C API Support for Prepared
CALL
Statements - 21.9.16. Building Client Programs
- 21.10. MySQL PHP API [+/-]
- 21.11. MySQL Perl API
- 21.12. MySQL C++ API
- 21.13. MySQL Python API
- 21.14. MySQL Ruby APIs [+/-]
- 21.15. MySQL Tcl API
- 21.16. MySQL Eiffel Wrapper
- 22. Extending MySQL [+/-]
- 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
- A.14. MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat [+/-]
- A.14.1. Distributed Replicated Block Device (DRBD)
- A.14.2. Linux Heartbeat
- A.14.3. DRBD Architecture
- A.14.4. DRBD and MySQL Replication
- A.14.5. DRBD and File Systems
- A.14.6. DRBD and LVM
- A.14.7. DRBD and Virtualization
- A.14.8. DRBD and Security
- A.14.9. DRBD and System Requirements
- A.14.10. DBRD and Support and Consulting
- B. Errors, Error Codes, and Common Problems [+/-]
- C. MySQL Change History [+/-]
- C.1. Changes in Release 5.1.x (Production) [+/-]
- C.1.1. Changes in MySQL 5.1.48 (Not yet released)
- C.1.2. Changes in MySQL 5.1.47 (06 May 2010)
- C.1.3. Changes in MySQL 5.1.46 (06 April 2010)
- C.1.4. Changes in MySQL 5.1.45 (01 March 2010)
- C.1.5. Changes in MySQL 5.1.44 (04 February 2010)
- C.1.6. Release Notes for MySQL Enterprise 5.1.43sp1 [QSP] (25 March 2010)
- C.1.7. Changes in MySQL 5.1.43 (15 January 2010)
- C.1.8. Changes in MySQL 5.1.42 (15 December 2009)
- C.1.9. Changes in MySQL 5.1.41 (05 November 2009)
- C.1.10. Release Notes for MySQL Enterprise 5.1.40sp1 [QSP] (25 November 2009)
- C.1.11. Changes in MySQL 5.1.40 (06 October 2009)
- C.1.12. Changes in MySQL 5.1.39 (04 September 2009)
- C.1.13. Changes in MySQL 5.1.38 (01 September 2009)
- C.1.14. Release Notes for MySQL Enterprise 5.1.37sp1 [QSP] (10 October 2009)
- C.1.15. Changes in MySQL 5.1.37 (13 July 2009)
- C.1.16. Changes in MySQL 5.1.36 (16 June 2009)
- C.1.17. Changes in MySQL 5.1.35 (13 May 2009)
- C.1.18. Release Notes for MySQL Enterprise 5.1.34sp1 [QSP] (25 June 2009)
- C.1.19. Changes in MySQL 5.1.34 (02 April 2009)
- C.1.20. Changes in MySQL 5.1.33 (13 March 2009)
- C.1.21. Changes in MySQL 5.1.32 (14 February 2009)
- C.1.22. Release Notes for MySQL Enterprise 5.1.31sp1 [QSP] (19 March 2009)
- C.1.23. Changes in MySQL 5.1.31 (19 January 2009)
- C.1.24. Changes in MySQL 5.1.30 (14 November 2008 General Availability)
- C.1.25. Changes in MySQL 5.1.29 (11 October 2008)
- C.1.26. Changes in MySQL 5.1.28 (28 August 2008)
- C.1.27. Changes in MySQL 5.1.27 (Not released)
- C.1.28. Changes in MySQL 5.1.26 (30 June 2008)
- C.1.29. Changes in MySQL 5.1.25 (28 May 2008)
- C.1.30. Changes in MySQL 5.1.24 (08 April 2008)
- C.1.31. Changes in MySQL 5.1.23 (29 January 2008)
- C.1.32. Changes in MySQL 5.1.22 (24 September 2007 Release Candidate)
- C.1.33. Changes in MySQL 5.1.21 (16 August 2007)
- C.1.34. Changes in MySQL 5.1.20 (25 June 2007)
- C.1.35. Changes in MySQL 5.1.19 (25 May 2007)
- C.1.36. Changes in MySQL 5.1.18 (08 May 2007)
- C.1.37. Changes in MySQL 5.1.17 (04 April 2007)
- C.1.38. Changes in MySQL 5.1.16 (26 February 2007)
- C.1.39. Changes in MySQL 5.1.15 (25 January 2007)
- C.1.40. Changes in MySQL 5.1.14 (05 December 2006)
- C.1.41. Changes in MySQL 5.1.13 (Not released)
- C.1.42. Changes in MySQL 5.1.12 (24 October 2006)
- C.1.43. Changes in MySQL 5.1.11 (26 May 2006)
- C.1.44. Changes in MySQL 5.1.10 (Not released)
- C.1.45. Changes in MySQL 5.1.9 (12 April 2006)
- C.1.46. Changes in MySQL 5.1.8 (Not released)
- C.1.47. Changes in MySQL 5.1.7 (27 February 2006)
- C.1.48. Changes in MySQL 5.1.6 (01 February 2006)
- C.1.49. Changes in MySQL 5.1.5 (10 January 2006)
- C.1.50. Changes in MySQL 5.1.4 (21 December 2005)
- C.1.51. Changes in MySQL 5.1.3 (29 November 2005)
- C.1.52. Changes in MySQL 5.1.2 (Not released)
- C.1.53. Changes in MySQL 5.1.1 (Not released)
- C.2. MySQL Enterprise Monitor Change History [+/-]
- C.3. MySQL Connector/ODBC (MyODBC) Change History [+/-]
- C.3.1. Changes in MySQL Connector/ODBC 5.1.7 (Not yet released)
- C.3.2. Changes in MySQL Connector/ODBC 5.1.6 (09 November 2009)
- C.3.3. Changes in MySQL Connector/ODBC 5.1.5 (18 August 2008)
- C.3.4. Changes in MySQL Connector/ODBC 5.1.4 (15 April 2008)
- C.3.5. Changes in MySQL Connector/ODBC 5.1.3 (26 March 2008)
- C.3.6. Changes in MySQL Connector/ODBC 5.1.2 (13 February 2008)
- C.3.7. Changes in MySQL Connector/ODBC 5.1.1 (13 December 2007)
- C.3.8. Changes in MySQL Connector/ODBC 5.1.0 (10 September 2007)
- C.3.9. Changes in MySQL Connector/ODBC 5.0.12 (Never released)
- C.3.10. Changes in MySQL Connector/ODBC 5.0.11 (31 January 2007)
- C.3.11. Changes in MySQL Connector/ODBC 5.0.10 (14 December 2006)
- C.3.12. Changes in MySQL Connector/ODBC 5.0.9 (22 November 2006)
- C.3.13. Changes in MySQL Connector/ODBC 5.0.8 (17 November 2006)
- C.3.14. Changes in MySQL Connector/ODBC 5.0.7 (08 November 2006)
- C.3.15. Changes in MySQL Connector/ODBC 5.0.6 (03 November 2006)
- C.3.16. Changes in MySQL Connector/ODBC 5.0.5 (17 October 2006)
- C.3.17. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June 2006)
- C.3.18. Changes in Connector/ODBC 5.0.2 (Never released)
- C.3.19. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June 2006)
- C.3.20. Changes in MySQL Connector/ODBC 3.51.28 (Not yet released)
- C.3.21. Changes in MySQL Connector/ODBC 3.51.27 (20 November 2008)
- C.3.22. Changes in MySQL Connector/ODBC 3.51.26 (07 July 2008)
- C.3.23. Changes in MySQL Connector/ODBC 3.51.25 (11 April 2008)
- C.3.24. Changes in MySQL Connector/ODBC 3.51.24 (14 March 2008)
- C.3.25. Changes in MySQL Connector/ODBC 3.51.23 (09 January 2008)
- C.3.26. Changes in MySQL Connector/ODBC 3.51.22 (13 November 2007)
- C.3.27. Changes in MySQL Connector/ODBC 3.51.21 (08 October 2007)
- C.3.28. Changes in MySQL Connector/ODBC 3.51.20 (10 September 2007)
- C.3.29. Changes in MySQL Connector/ODBC 3.51.19 (10 August 2007)
- C.3.30. Changes in MySQL Connector/ODBC 3.51.18 (08 August 2007)
- C.3.31. Changes in MySQL Connector/ODBC 3.51.17 (14 July 2007)
- C.3.32. Changes in MySQL Connector/ODBC 3.51.16 (14 June 2007)
- C.3.33. Changes in MySQL Connector/ODBC 3.51.15 (07 May 2007)
- C.3.34. Changes in MySQL Connector/ODBC 3.51.14 (08 March 2007)
- C.3.35. Changes in MySQL Connector/ODBC 3.51.13 (Never released)
- C.3.36. Changes in MySQL Connector/ODBC 3.51.12 (11 February 2005)
- C.3.37. Changes in MySQL Connector/ODBC 3.51.11 (28 January 2005)
- C.4. MySQL Connector/NET Change History [+/-]
- C.4.1. Changes in MySQL Connector/NET Version 6.3.x
- C.4.2. Changes in MySQL Connector/NET Version 6.2.x
- C.4.3. Changes in MySQL Connector/NET Version 6.1.x
- C.4.4. Changes in MySQL Connector/NET Version 6.0.x
- C.4.5. Changes in MySQL Connector/NET Version 5.3.x
- C.4.6. Changes in MySQL Connector/NET Version 5.2.x
- C.4.7. Changes in MySQL Connector/NET Version 5.1.x
- C.4.8. Changes in MySQL Connector/NET Version 5.0.x
- C.4.9. Changes in MySQL Connector/NET Version 1.0.x
- C.4.10. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
- C.4.11. Changes in MySQL Connector/NET Version 0.76
- C.4.12. Changes in MySQL Connector/NET Version 0.75
- C.4.13. Changes in MySQL Connector/NET Version 0.74
- C.4.14. Changes in MySQL Connector/NET Version 0.71
- C.4.15. Changes in MySQL Connector/NET Version 0.70
- C.4.16. Changes in MySQL Connector/NET Version 0.68
- C.4.17. Changes in MySQL Connector/NET Version 0.65
- C.4.18. Changes in MySQL Connector/NET Version 0.60
- C.4.19. Changes in MySQL Connector/NET Version 0.50
- C.5. MySQL Visual Studio Plugin Change History [+/-]
- C.6. MySQL Connector/J Change History [+/-]
- C.6.1. Changes in MySQL Connector/J 5.1.x
- C.6.2. Changes in MySQL Connector/J 5.0.x
- C.6.3. Changes in MySQL Connector/J 3.1.x
- C.6.4. Changes in MySQL Connector/J 3.0.x
- C.6.5. Changes in MySQL Connector/J 2.0.x
- C.6.6. Changes in MySQL Connector/J 1.2b (04 July 1999)
- C.6.7. Changes in MySQL Connector/J 1.2.x and lower
- C.7. MySQL Connector/MXJ Change History [+/-]
- C.7.1. Changes in MySQL Connector/MXJ 5.0.11 (24th November 2009)
- C.7.2. Changes in MySQL Connector/MXJ 5.0.10 (Never released)
- C.7.3. Changes in MySQL Connector/MXJ 5.0.9 (19 August 2008)
- C.7.4. Changes in MySQL Connector/MXJ 5.0.8 (06 August 2007)
- C.7.5. Changes in MySQL Connector/MXJ 5.0.7 (27 May 2007)
- C.7.6. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)
- C.7.7. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)
- C.7.8. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)
- C.7.9. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)
- C.7.10. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)
- C.7.11. Changes in MySQL Connector/MXJ 5.0.1 (Never released)
- C.7.12. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)
- C.8. MySQL Connector/C++ Change History [+/-]
- C.9. MySQL Proxy Change History [+/-]
- C.9.1. Changes in MySQL Proxy 0.8.1 (Not yet released)
- C.9.2. Changes in MySQL Proxy 0.8.0 (21 Jan 2010)
- C.9.3. Changes in MySQL Proxy 0.7.2 (30 June 2009)
- C.9.4. Changes in MySQL Proxy 0.7.1 (15 May 2009)
- C.9.5. Changes in MySQL Proxy 0.7.0 (Never Released)
- C.9.6. Changes in MySQL Proxy 0.6.1 (06 February 2008)
- C.9.7. Changes in MySQL Proxy 0.6.0 (11 September 2007)
- C.9.8. Changes in MySQL Proxy 0.5.1 (30 June 2007)
- C.9.9. Changes in MySQL Proxy 0.5.0 (19 June 2007)
- 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
List of Figures [+/-]
- 2.1. Installation Workflow for Windows using MSI
- 2.2. Installation Workflow for Windows using Zip
- 2.3. Installation Workflow for Windows using MSI Installer
- 2.4. MySQL Server Instance Config Wizard Workflow
- 13.1. MySQL Architecture with Pluggable Storage Engines
- 13.2.
FEDERATED
Table Structure - 14.1. DRBD Architecture Overview
- 14.2. DRBD Architecture Using Separate Network Interfaces
- 14.3. Heartbeat Architecture
- 14.4. memcached Architecture Overview
- 14.5. memcached Hash Selection
- 14.6. memcached Hash Selection with New memcached instance
- 14.7. Memory Allocation in memcached
- 14.8. Typical memcached Application Flowchart
- 15.1. MySQL Enterprise Monitor Architecture
- 15.2. MySQL Enterprise Monitor: Installing Monitor on Windows: Language Selection
- 15.3. MySQL Enterprise Monitor: Installing Monitor on Windows: Installation Directory
- 15.4. MySQL Enterprise Monitor: Installing Monitor on Windows: Tomcat Server Options
- 15.5. MySQL Enterprise Monitor: Installing Monitor on Windows: Repository Configuration
- 15.6. MySQL Enterprise Monitor: Installing Monitor on OS X: Language Selection
- 15.7. MySQL Enterprise Monitor: Installing Monitor on OS X: Java Selection
- 15.8. MySQL Enterprise Monitor: Installing Monitor on OS X: Installation Directory
- 15.9. MySQL Enterprise Monitor: Installing Monitor on OS X: Tomcat Server Options
- 15.10. MySQL Enterprise Monitor: Installing Monitor on OS X: Repository Configuration
- 15.11. MySQL Enterprise Monitor: Initial Dashboard Log-In
- 15.12. MySQL Enterprise Monitor: Outgoing Email Settings
- 15.13. MySQL Enterprise Monitor: Installing Agent on Windows: Language Selection
- 15.14. MySQL Enterprise Monitor: Installing Agent on Windows: Installation Directory
- 15.15. MySQL Enterprise Monitor: Installing Agent on Windows: Monitored Database Information
- 15.16. MySQL Enterprise Monitor: Installing Agent on Windows: Query Analyzer Configuration
- 15.17. MySQL Enterprise Monitor: Installing Agent on Windows: MySQL Enterprise Service Manager Options
- 15.18. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Language Selection
- 15.19. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Installation Directory
- 15.20. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information
- 15.21. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored Database Information
- 15.22. MySQL Enterprise Monitor: Installing Agent on Mac OS X: Query Analyzer Configuration
- 15.23. MySQL Enterprise Monitor: Installing Agent on Mac OS X: MySQL Enterprise Service Manager Options
- 15.24. MySQL Enterprise Monitor: Server Update: Language Selection
- 15.25. MySQL Enterprise Monitor: Server Update: Previous Installation
- 15.26. MySQL Enterprise Monitor: Server Update: Backup of Previous Installation
- 15.27. MySQL Enterprise Monitor: Server Update: Completed installing files
- 15.28. MySQL Enterprise Monitor: Server Update: Final Setup
- 15.29. MySQL Enterprise Dashboard: The Graphs Screen
- 15.30. MySQL Enterprise Dashboard: The Heat Chart
- 15.31. MySQL Enterprise Dashboard: The Heat Chart Legend
- 15.32. MySQL Enterprise Dashboard: Settings
- 15.33. MySQL Enterprise Dashboard: User Preferences
- 15.34. MySQL Enterprise Dashboard: Manage Servers
- 15.35. MySQL Enterprise Dashboard: Server Renaming
- 15.36. MySQL Enterprise Dashboard: Manage Users
- 15.37. MySQL Enterprise Dashboard: Manage Notification Groups
- 15.38. MySQL Enterprise Dashboard: Edit Notification Groups
- 15.39. MySQL Enterprise Dashboard: Logs
- 15.40. The What's New Tab
- 15.41. What's New Configuration
- 15.42. MySQL Enterprise Dashboard: Scheduling Dialog
- 15.43. MySQL Enterprise Dashboard: Editing Rules
- 15.44. MySQL Enterprise Dashboard: Events Screen
- 15.45. MySQL Enterprise Dashboard: Query Analyzer
- 15.46. MySQL Enterprise Dashboard: Standard Agent/Monitor Topology
- 15.47. MySQL Enterprise Dashboard: Query Analyzer Agent/Monitor Topology
- 15.48. MySQL Enterprise Dashboard: Canonical Query Tab for a Query
- 15.49. MySQL Enterprise Dashboard: Example Query Tab for a Query
- 15.50. MySQL Enterprise Dashboard: Explain Query Tab for a Query
- 15.51. MySQL Enterprise Dashboard: Correlated Graphs
- 15.52. MySQL Enterprise Dashboard: Query Analyzer Configuration
- 15.53. MySQL Enterprise Dashboard: Replication Groups
- 15.54. MySQL Enterprise Monitor: Historical Data Migration Availability
- 15.55. MySQL Enterprise Monitor: Confirming Historical Data Migration
- 15.56. MySQL Enterprise Monitor: Historical Data Migration Progress
- 16.1. Using Replication to Improve Performance During Scale-Out
- 16.2. Using Replication to Replicate Databases to Separate Replication Slaves
- 16.3. Using an Additional Replication Host to Improve Performance
- 16.4. Redundancy Using Replication, Initial Structure
- 16.5. Redundancy Using Replication, After Master Failure
- 21.1. Add Connection Context Menu
- 21.2. Choose Data Source
- 21.3. Add Connection Dialog
- 21.4. New Data Connection
- 21.5. Editing New Table
- 21.6. Choose Table Name
- 21.7. Newly Created Table
- 21.8. Table Designer Main Menu
- 21.9. Indexes Dialog
- 21.10. Foreign Key Relationships Dialog
- 21.11. Table Properties Menu Item
- 21.12. Table Properties
- 21.13. Editing View SQL
- 21.14. View SQL Added
- 21.15. View SQL Saved
- 21.16. Edit Stored Procedure SQL
- 21.17. Stored Procedure SQL Saved
- 21.18. MySQL Website Configuration Tool
- 21.19. MySQL Website Configuration Tool - Membership
- 21.20. MySQL Website Configuration Tool - Connection String Editor
- 21.21. MySQL Website Configuration Tool - Advanced Options
- 21.22. MySQL Website Configuration Tool - Roles
- 21.23. MySQL Website Configuration Tool - Profiles
- 21.24. MySQL Website Configuration Tool - Session State
- 21.25. MySQL Website Configuration Tool - Tables
- 21.26. MySQL SQL Editor - New File
- 21.27. MySQL SQL Editor - Query
- 21.28. World Database Application
- 21.29. Authentication Type
- 21.30. Select Membership and Role Provider
- 21.31. Membership and Role Provider Tables
- 21.32. Security Tab
- 21.33. Create User
- 21.34. Membership and Roles Table Contents
- 21.35. Simple Profile Application
- 21.36. Add Entity Data Model
- 21.37. Entity Data Model Wizard Screen 1
- 21.38. Entity Data Model Wizard Screen 2
- 21.39. Entity Data Model Wizard Screen 3
- 21.40. Entity Data Model Diagram
- 21.41. Entity Data Source Configuration Wizard Screen 1
- 21.42. Entity Data Source Configuration Wizard Screen 2
- 21.43. Entity Data Source Configuration Wizard Screen 3
- 21.44. Data Sources
- 21.45. Data Form Designer
- 21.46. Adding Code to the Form
- 21.47. The Populated Grid Control
- 21.48. Save Button Enabled
- 21.49. Adding Save Code to the Form
- 21.50. The Design Tab
- 21.51. Drop Down List
- 21.52. Enable AutoPostBack
- 21.53. Grid View Control
- 21.54. Placed Grid Vew Control
- 21.55. Source Code
- 21.56. The Working Web Site
- 21.57. Windows Installer Welcome Screen
- 21.58. Windows Installer Overview Screen
- 21.59. Windows Installer Custom Setup Screen
- 21.60. Creating a New Project
- 21.61. The New Project Dialog Box
- 21.62. The Win32 Application Wizard
- 21.63. Selecting the Release Build
- 21.64. Selecting Project Properties from the Main Menu
- 21.65. Setting Properties
- 21.66. MySQL Include Directory
- 21.67. Select Directory Dialog
- 21.68. Typical Contents of MySQL lib/opt Directory
- 21.69. Additional Library Directories
- 21.70. Additional Library Directories Dialog
- 21.71.
- 21.72. Adding Additional Dependencies
- 21.73. Setting the CPPCONN_PUBLIC_FUNC Define
- 21.74. The NetBeans IDE
- 21.75. Setting the Header Include Directory
- 21.76. Setting the Static Library Directories and File Names
- 21.77. Setting the Dynamic Library Directory and File Name
- 21.78. The Example Application Running
- 21.79. Adding an Extension
- 21.80. Selecting the Database
- 21.81. Selecting the connection type
- 21.82. Entering Connection Settings
- 21.83. Setting Up User Authentication
- 21.84. After Connecting to the Database
- 21.85. Entering the Database File Name
- 21.86. Listing Tables
- A.1. Active-Master MySQL Server
List of Tables [+/-]
- 2.1. Build (
configure
) Reference - 2.2. Installation Layout for Windows using MySQL 5.1.23 and earlier
- 2.3. Installation Layout for Windows using MySQL 5.1.24 and later
- 2.4. MySQL Server Instance Config Wizard Command Line Options
- 2.5. MySQL Server Instance Config Wizard Parameters
- 2.6. Return Value from MySQL Server Instance Config Wizard
- 4.1.
mysqld_safe
Options - 4.2.
mysql
Options - 4.3.
mysqladmin
Options - 4.4.
mysqlcheck
Options - 4.5.
mysqldump
Options - 4.6.
mysqlimport
Options - 4.7.
mysqlshow
Options - 4.8.
mysqlslap
Options - 4.9.
myisamchk
Options - 4.10.
mysqlaccess
Options - 4.11.
mysqlbinlog
Options - 4.12.
mysqldumpslow
Options - 4.13.
mysqlhotcopy
Options - 5.1. Option/Variable Summary
- 5.2. System Variable Summary
- 5.3. Dynamic Variable Summary
- 5.4. Status Variable Summary
- 5.5. Security Option/Variable Summary
- 5.6. SSL Option/Variable Summary
- 11.1. Operators/Functions
- 11.2. Operators
- 11.3. Comparison Operators
- 11.4. Logical Operators
- 11.5. Flow Control Operators
- 11.6. String Operators
- 11.7. String Comparison Operators
- 11.8. String Regular Expression Operators
- 11.9. Numeric Functions
- 11.10. Arithmetic Functions
- 11.11. Mathematical Functions
- 11.12. Date/Time Functions
- 11.13. Cast Functions
- 11.14. XML Functions
- 11.15. Other Functions
- 11.16. Bitwise Functions
- 11.17. Encryption Functions
- 11.18. Information Functions
- 11.19. Miscellaneous Functions
- 11.20. Aggregate (
GROUP BY
) Functions - 13.1. Storage Engine Features
- 13.2.
MyISAM
Storage Engine Features - 13.3. MyISAM Option/Variable Reference
- 13.4.
InnoDB
Storage Engine Features - 13.5.
InnoDB
Option/Variable Reference - 13.6.
IBMDB2I
Storage Engine Features - 13.7. Naming Behavior in DB2 Storage Engine
- 13.8.
IBMDB2I
Isolation Levels - 13.9. Data Type Restrictions in
IBMDB2I
- 13.10. Collation Compatibility in
IBMDB2I
and MySQL - 13.11. Error Codes from
IBMDB2I
- 13.12. Error Codes and Messages in
IBMDB2I
- 13.13.
MEMORY
Storage Engine Features - 13.14.
ARCHIVE
Storage Engine Features - 14.1. memcached Command Reference
- 14.2. memcached Protocol Responses
- 14.3. mysql-proxy Help Options
- 14.4. mysql-proxy Admin Options
- 14.5. mysql-proxy Proxy Options
- 14.6. mysql-proxy Applications Options
- 15.1. MySQL Enterprise Monitor: Wiki Formatting
- 15.2. mysql-monitor-agent Help Options
- 15.3. mysql-monitor-agent Admin Options
- 15.4. mysql-monitor-agent Agent Options
- 15.5. mysql-monitor-agent Monitor Options
- 15.6. mysql-monitor-agent Proxy Options
- 15.7. mysql-monitor-agent Application Options
- 16.1. Replication Option/Variable Summary
- 16.2. Binary Logging Option/Variable Summary
- 17.1. Data Node Configuration Parameters
- 17.2. Management Node Configuration Parameters
- 17.3. API Node Configuration Parameters
- 17.4. COMPUTER Configuration Parameters
- 17.5. TCP Configuration Parameters
- 17.6. SHM Configuration Parameters
- 17.7. SCI Configuration Parameters
- 17.8. Command Options for MySQL Cluster
- 17.9. ndbd Command Line Options
- 17.10. ndb_mgmd Command Line Options
- 17.11. ndb_mgm Command Line Options
- 17.12. ndb_config Command Line Options
- 17.13. ndbd_redo_log_reader Command Line Options
- 17.14. ndb_restore Command Line Options
- 17.15. ndb_show_tables Command Line Options
- 17.16. ndb_size.pl Command Line Options
- 17.17. Common MySQL Cluster Command Line Options
- 21.1. MySQL APIs and Interfaces
- 21.2. MySQL Connector Versions and MySQL Server Versions
- 21.3. Mapping of MySQL Error Numbers to SQLStates
- 21.4. MySQL Configuration Options
- 21.5. MySQL client constants
- 21.6. MySQL fetch constants
- 21.7. MySQLi Configuration Options
- 21.8. Possible mysqli_info return values
- 21.9. Valid options
- 21.10. Supported flags
- 21.11. Attribute values
- 21.12. Type specification chars
- 21.13. Return Values
- 21.14. Object attributes
- 21.15. Object properties
- 21.16. Object properties
- 21.17. Supported flags
List of Examples [+/-]
- 21.1. Connector/J: Obtaining a connection from the
DriverManager
- 21.2. Connector/J: Using java.sql.Statement to execute a
SELECT
query - 21.3. Connector/J: Calling Stored Procedures
- 21.4. Connector/J: Using
Connection.prepareCall()
- 21.5. Connector/J: Registering output parameters
- 21.6. Connector/J: Setting
CallableStatement
input parameters - 21.7. Connector/J: Retrieving results and output parameter values
- 21.8. Connector/J: Retrieving
AUTO_INCREMENT
column values usingStatement.getGeneratedKeys()
- 21.9. Connector/J: Retrieving
AUTO_INCREMENT
column values usingSELECT LAST_INSERT_ID()
- 21.10. Connector/J: Retrieving
AUTO_INCREMENT
column values inUpdatable ResultSets
- 21.11. Connector/J: Using a connection pool with a J2EE application server
- 21.12. Connector/J: Example of transaction with retry logic
- 21.13. MySQL extension overview example
- 21.14.
mysql_affected_rows
example - 21.15.
mysql_affected_rows
example using transactions - 21.16.
mysql_client_encoding
example - 21.17.
mysql_close
example - 21.18.
mysql_connect
example - 21.19.
mysql_connect
example usinghostname:port
syntax - 21.20.
mysql_connect
example using ":/path/to/socket" syntax - 21.21.
mysql_create_db
alternative example - 21.22.
mysql_data_seek
example - 21.23.
mysql_db_name
example - 21.24.
mysql_db_query
alternative example - 21.25.
mysql_drop_db
alternative example - 21.26.
mysql_errno
example - 21.27.
mysql_error
example - 21.28.
mysql_escape_string
example - 21.29. Query with aliased duplicate field names
- 21.30.
mysql_fetch_array
withMYSQL_NUM
- 21.31.
mysql_fetch_array
withMYSQL_ASSOC
- 21.32.
mysql_fetch_array
withMYSQL_BOTH
- 21.33. An expanded
mysql_fetch_assoc
example - 21.34.
mysql_fetch_field
example - 21.35. A
mysql_fetch_lengths
example - 21.36.
mysql_fetch_object
example - 21.37.
mysql_fetch_object
example - 21.38. Fetching one row with
mysql_fetch_row
- 21.39. A
mysql_field_flags
example - 21.40.
mysql_field_len
example - 21.41.
mysql_field_name
example - 21.42. A
mysql_field_table
example - 21.43.
mysql_field_type
example - 21.44. A
mysql_free_result
example - 21.45.
mysql_get_client_info
example - 21.46.
mysql_get_host_info
example - 21.47.
mysql_get_proto_info
example - 21.48.
mysql_get_server_info
example - 21.49. Relevant MySQL Statements
- 21.50.
mysql_insert_id
example - 21.51.
mysql_list_dbs
example - 21.52. Alternate to deprecated
mysql_list_fields
- 21.53.
mysql_list_processes
example - 21.54.
mysql_list_tables
alternative example - 21.55. A
mysql_num_fields
example - 21.56.
mysql_num_rows
example - 21.57. A
mysql_ping
example - 21.58. Invalid Query
- 21.59. Valid Query
- 21.60. Simple
mysql_real_escape_string
example - 21.61. An example SQL Injection Attack
- 21.62.
mysql_result
example - 21.63.
mysql_select_db
example - 21.64.
mysql_stat
example - 21.65. Alternative
mysql_stat
example - 21.66.
mysql_tablename
example - 21.67.
mysql_thread_id
example - 21.68. Object oriented style
- 21.69. Procedural style
- 21.70. Object oriented style
- 21.71. Procedural style
- 21.72. Object oriented style
- 21.73. Procedural style
- 21.74. Object oriented style
- 21.75. Procedural style
- 21.76. mysqli_get_client_info
- 21.77. mysqli_get_client_version
- 21.78. Object oriented style
- 21.79. Procedural style
- 21.80. Object oriented style
- 21.81. Procedural style
- 21.82. Object oriented style
- 21.83. Procedural style
- 21.84. Object oriented style
- 21.85. Object oriented style when extending mysqli class
- 21.86. Procedural style
- 21.87. Generating a Trace File
- 21.88. Object oriented style
- 21.89. Procedural style
- 21.90. Object oriented style
- 21.91. Procedural style
- 21.92. Object oriented style
- 21.93. Procedural style
- 21.94. Object oriented style
- 21.95. Procedural style
- 21.96. mysqli_get_client_info
- 21.97. mysqli_get_client_version
- 21.98. A
mysqli_get_connection_stats
example - 21.99. Object oriented style
- 21.100. Procedural style
- 21.101. Object oriented style
- 21.102. Procedural style
- 21.103. Object oriented style
- 21.104. Procedural style
- 21.105. Object oriented style
- 21.106. Procedural style
- 21.107. Object oriented style
- 21.108. Procedural style
- 21.109. Object oriented style
- 21.110. Procedural style
- 21.111. Object oriented style
- 21.112. Procedural style
- 21.113. Object oriented style
- 21.114. Procedural style
- 21.115. Object oriented style
- 21.116. Procedural style
- 21.117. A
mysqli_poll
example - 21.118. Object oriented style
- 21.119. Procedural style
- 21.120. Object oriented style
- 21.121. Procedural style
- 21.122. Object oriented style
- 21.123. Object oriented style when extending mysqli class
- 21.124. Procedural style
- 21.125. Object oriented style
- 21.126. Procedural style
- 21.127. Object oriented style
- 21.128. Procedural style
- 21.129. Object oriented style
- 21.130. Procedural style
- 21.131. Object oriented style
- 21.132. Procedural style
- 21.133. Object oriented style
- 21.134. Procedural style
- 21.135. Object oriented style
- 21.136. Procedural style
- 21.137. Object oriented style
- 21.138. Procedural style
- 21.139. Object oriented style
- 21.140. Procedural style
- 21.141. Object oriented style
- 21.142. Procedural style
- 21.143. Object oriented style
- 21.144. Procedural style
- 21.145. Object oriented style
- 21.146. Procedural style
- 21.147. Object oriented style
- 21.148. Procedural style
- 21.149. Object oriented style
- 21.150. Procedural style
- 21.151. Object oriented style
- 21.152. Procedural style
- 21.153. Object oriented style
- 21.154. Procedural style
- 21.155. Object oriented style
- 21.156. Procedural style
- 21.157. Object oriented style
- 21.158. Procedural style
- 21.159. Object oriented style
- 21.160. Procedural style
- 21.161. Object oriented style
- 21.162. Procedural style
- 21.163. Object oriented style
- 21.164. Procedural style
- 21.165. Object oriented style
- 21.166. Procedural style
- 21.167. Object oriented style
- 21.168. Procedural style
- 21.169. Object oriented style
- 21.170. Object oriented style
- 21.171. Procedural style
- 21.172. Object oriented style
- 21.173. Procedural style
- 21.174. Object oriented style
- 21.175. Procedural style
- 21.176. Object oriented style
- 21.177. Procedural style
- 21.178. Object oriented style
- 21.179. Procedural style
- 21.180. Object oriented style
- 21.181. Procedural style
- 21.182. Object oriented style
- 21.183. Procedural style
- 21.184. Object oriented style
- 21.185. Procedural style
- 21.186. Object oriented style
- 21.187. Procedural style
- 21.188. Object oriented style
- 21.189. Procedural style
- 21.190. Object oriented style
- 21.191. Procedural style
- 21.192. Object oriented style
- 21.193. Procedural style
- 21.194. Object oriented style
- 21.195. Procedural style
- 21.196. Object oriented style
- 21.197. Procedural style
- 21.198. Object oriented style
- 21.199. Procedural style
- 21.200. A
mysqli_get_cache_stats
example - 21.201. A
mysqli_get_client_stats
example - 21.202. Object oriented style
- 21.203. Forcing queries to be buffered in mysql
- 21.204. PDO_MYSQL DSN examples