Other MySQL Cluster Configuration Parameters The summary tables in this section provide information about parameters used in the [computer], [tcp], [shm], and [sci] sections of a config.ini file for configuring MySQL Cluster management nodes. For detailed descriptions and other additional informa...
Overview of MySQL Storage Engine Architecture The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding requiremen...
Parameters for configuring send buffer memory allocation. Send buffer memory is allocated dynamically from a memory pool shared between all transporters, which means that the size of the send buffer can be adjusted as necessary. (Previously, the N...
Pausing Replication on the Slave You can stop and start the replication of statements on the slave using the STOP SLAVE and START SLAVE statements. To stop processing of the binary log from the master, use STOP SLAVE: mysql STOP SLAVE; When replication is stopped, the slave I/O thread stops rea...
Performance Characteristics MEMORY performance is constrained by contention resulting from single-thread execution and table lock overhead when processing updates. This limits scalability when load increases, particularly for statement mixes...
Performance Schema Event Timing Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the Performance Schema provides an idea of how long events take. It is also possible to c...
Performance Schema General Table Characteristics The name of the performance_schema database is lowercase, as are the names of tables within it. Queries should specify the names in lowercase. Most tables in the performance_schema database ar...
Performance Schema Instrument Naming Conventions An instrument name consists of a sequence of components separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch...
Performance Schema Queries Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE cl...
Performance Schema Statement Digests As of MySQL 5.6.5, the Performance Schema maintains statement digest information. Digesting converts a SQL statement to normalized form and computes a hash value for the result. Normalization permits stat...
