Mysql 5 reference manual

Text in this style is used in table headings and to convey especially strong emphasis. Text in this style is used to indicate a program option that affects how the program is executed, or that supplies information that is needed for the program to function in a certain way. Commands are issued in your command interpreter. On Unix, this is typically a program such as sh , csh , or bash. On Windows, the equivalent program is command.

Statements prefixed by mysql are issued in the mysql command-line client. When you enter a command or statement shown in an example, do not type the prompt shown in the example.

In some areas different systems may be distinguished from each other to show that commands should be executed in two different environments.

For example, while working with replication the commands might be prefixed with source and replica :. Replication Implementation Replication Implementation Details Replication Relay and Status Files Replication Solutions Using Replication for Backups Using Replication for Scale-Out Replicating Different Databases to Different Slaves Improving Replication Performance Switching Masters During Failover Semisynchronous Replication Replication Notes and Tips Replication Features and Issues Upgrading a Replication Setup Replication FAQ Troubleshooting Replication How to Report Replication Bugs or Problems Partitioning Partitioning Types LIST Partitioning HASH Partitioning KEY Partitioning Subpartitioning Partition Management Maintenance of Partitions Obtaining Information About Partitions Partition Pruning Restrictions and Limitations on Partitioning Partitioning Limitations Relating to Storage Engines Partitioning Limitations Relating to Functions Stored Programs and Views Defining Stored Programs Using Stored Routines Procedures and Functions Stored Routine Syntax Stored Routine Metadata Using Triggers Trigger Syntax Trigger Metadata Using the Event Scheduler Event Scheduler Overview Event Scheduler Configuration Event Syntax Event Metadata Event Scheduler Status Using Views View Syntax View Processing Algorithms Updatable and Insertable Views View Metadata Access Control for Stored Programs and Views Binary Logging of Stored Programs Performance Schema Quick Start Performance Schema Configuration Performance Schema Build Configuration Performance Schema Startup and Runtime Configuration Performance Schema Status Monitoring Performance Schema Event Timing Performance Schema Table General Characteristics Performance Schema Table Descriptions Performance Schema Setup Tables Performance Schema Events Current Table Performance Schema History Tables Performance Schema Summary Tables Performance Schema Instance Tables Performance Schema Miscellaneous Tables Performance Schema and Plugins Performance Schema System Variables Performance Schema Status Variables Using Performance Schema to Diagnose Problems Connectors and APIs Getting Started: Usage Examples References Known Bugs Contact Compiling Programs with libmysqld Options with the Embedded Server Embedded Server Examples Licensing the Embedded Server Controlling Automatic Reconnection Behavior Building Client Programs MySQL Enabling Both mysql and mysqli in PHP Extending MySQL MySQL Internals MySQL Threads Plugin API Characteristics Plugin API Components Types of Plugins Plugin Data Structures and Functions Writing Plugins Features of the User-Defined Function Interface Adding a New User-Defined Function Adding a New Native Function Writing a Procedure Licenses for Third-Party Components A.

Ant-Contrib License A. Apache Commons Collections License A. Apache Commons Digester License A. Apache Commons Lang License A. Apache Commons Logging License A. Apache Commons Pool License A. Apache Commons Validator License A. Apache License Version 2. Apache log4j License A. Apache log4j Version 1. Apache Tomcat License A. ASM License A. Boost Library License A.

LPeg Library License A. Netlib License A. OpenSSL v0. Richard A. Spring Framework License A. Linux Heartbeat B. Sources of Error Information C. Types of Error Values C. Server Error Codes and Messages C. Client Error Codes and Messages C. Problems and Common Errors C. Installation-Related Issues C. Administration-Related Issues C. Query-Related Issues C. Optimizer-Related Issues C. Table Definition-Related Issues C. Changes in Release 5. Changes in MySQL 5. Restrictions and Limits E.

Restrictions on Signals E. Restrictions on Server-Side Cursors E. Restrictions on Subqueries E. Restrictions on Views E. Restrictions on XA Transactions E. Restrictions on Character Sets E. Performance Schema Restrictions E. Limits of Joins E. List of Figures 2. Heartbeat Architecture Memory Allocation in memcached Typical memcached Application Flowchart The What's New Tab What's New Configuration Redundancy Using Replication, Initial Structure Add Connection Context Menu Choose Data Source Add Connection Dialog New Data Connection Editing New Table Choose Table Name Newly Created Table Table Designer Main Menu Indexes Dialog Foreign Key Relationships Dialog Table Properties Menu Item Table Properties Editing View SQL View SQL Added View SQL Saved World Database Application Authentication Type Select Membership and Role Provider Membership and Role Provider Tables Security Tab Create User Membership and Roles Table Contents Simple Profile Application The Password Validation Plugin.

Password Validation Plugin Installation. Password Validation Plugin Options and Variables. Keyring Plugin Installation. Supported Keyring Key Types and Lengths. Migrating Keys Between Keyring Keystores. Keyring System Variables. Configuring Audit Logging Characteristics. Reading Audit Log Files. Writing Audit Log Filter Definitions. Legacy Mode Audit Log Filtering. Troubleshooting SELinux. InnoDB Cluster. Error Messages and Common Problems. MySQL 5.

The What's New Page Setting What's New Configuration The Advisors Page Installing and Updating Advisors Scheduling Rules Editing Built-in Rules Creating Advisors and Rules Creating a Custom Data Collection Item Disabling and Unscheduling Rules Advisor Blackout Periods The Events Page Closing an Event Notification of Events The Graphs Page Displaying Graphs Setting an Interval Setting a Time Span The Query Analyzer Page Enabling Query Analyzer Getting Detailed Query Information Using Graphs to Identify Queries Filtering Query Analyzer Data Using Query Analyzer Data Troubleshooting Query Analyzer Query Analyzer Settings The Replication Page Replication Page Details Supported Browsers Installation Requirements Configuring Tomcat Parameters Migrating 1.

Replication Replication Configuration How to Set Up Replication Replication and Binary Logging Options and Variables Common Replication Administration Tasks Replication Implementation Replication Implementation Details Replication Relay and Status Files Replication Solutions Using Replication for Backups Using Replication for Scale-Out Replicating Different Databases to Different Slaves Improving Replication Performance Switching Masters During Failover Replication Notes and Tips Replication Features and Issues Upgrading a Replication Setup Replication FAQ Troubleshooting Replication How to Report Replication Bugs or Problems MySQL Cluster Stored Programs and Views Defining Stored Programs Using Stored Routines Procedures and Functions Stored Routine Syntax Stored Routine Metadata Using Triggers Trigger Syntax Trigger Metadata Using Views View Syntax View Processing Algorithms Updatable and Insertable Views View Metadata Access Control for Stored Programs and Views Binary Logging of Stored Programs Connectors and APIs Installation Getting Started: Usage Examples References Known Bugs Contact Controlling Automatic Reconnection Behavior Building Client Programs MySQL Enabling Both mysql and mysqli in PHP Extending MySQL MySQL Internals MySQL Threads Features of the User-Defined Function Interface Adding a New User-Defined Function Adding a New Native Function Writing a Procedure Linux Heartbeat A.

Sources of Error Information B. Types of Error Values B. Server Error Codes and Messages B. Client Error Codes and Messages B. Problems and Common Errors B. Installation-Related Issues B. Administration-Related Issues B. Query-Related Issues B. Optimizer-Related Issues B. Table Definition-Related Issues B. Changes in Release 5. Changes in MySQL 5. Restrictions and Limits D.

Restrictions on Stored Routines and Triggers D. Restrictions on Server-Side Cursors D. Restrictions on Subqueries D. Restrictions on Views D. Restrictions on XA Transactions D. Restrictions on Character Sets D. Limits of Joins D. List of Figures Heartbeat Architecture Memory Allocation in memcached Typical memcached Application Flowchart The What's New Tab What's New Configuration Redundancy Using Replication, Initial Structure Add Connection Context Menu Choose Data Source Add Connection Dialog New Data Connection Editing New Table Choose Table Name Newly Created Table Table Designer Main Menu Indexes Dialog Foreign Key Relationships Dialog Table Properties Menu Item Table Properties Editing View SQL View SQL Added View SQL Saved World Database Application Authentication Type Select Membership and Role Provider Membership and Role Provider Tables Security Tab Create User Membership and Roles Table Contents Simple Profile Application Add Entity Data Model Entity Data Model Wizard Screen 1 Entity Data Model Wizard Screen 2 Entity Data Model Wizard Screen 3 Entity Data Model Diagram