Column Filtering When using row-based replication, (binlog_format=ROW [2047]), a slave where the last columns are missing from a table is supported, as described in the section Section 16.4.1.9, “Replication with Differing Table Definitions on Master and Slave”. This filtering works on the slave...
Compressed Table Characteristics Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables can be uncompressed with myisamchk. Compressed tables have the following characteristics: • Compressed tables take very little disk space. This minimizes...
Config options Table Table config_options stores memcached-related settings that are appropriate to change at runtime, through SQL. Currently, MySQL supports the following configuration options through this table: separator: The separator used...
Configuration of MySQL Cluster NDB 7.3 A MySQL server that is part of a MySQL Cluster differs in one chief respect from a normal (nonclustered) MySQL server, in that it employs the NDB storage engine. This engine is also referred to sometimes as NDBCLUSTER, although NDB is preferred. To avoid un...
Configuring MySQL Cluster Send Buffer Parameters Formerly, the NDB kernel employed a send buffer whose size was fixed at 2MB for each node in the cluster, this buffer being allocated when the node started. Because the size of this buffer could not be changed after the cluster was started, it was ...
Connector Net Support for Windows Store Starting with 6.7, Connector/Net fully supports building Windows Store apps. Windows Store are based on .NET but use a very restrictive subset of that functionality. The main difference is the complete lack of the ADO.Net data subsystem. Below is a list of ...
containers Table Column Constraints • key_columns: The maximum limit for a memcached key is 250 characters, which is enforced by memcached. If a mapped key longer than the maximum limit is used, the operation will fail. The mapped key must be ...
Controlling Transactional Behavior of the InnoDB memcached Plugin Unlike with the traditional memcached, with the InnoDB + memcached combin...
Copying data and transactions to the slave. Playing back the entire transaction history can be time-consuming, and represents a major bottleneck when setting up a new replication slave. To eliminate this requirement, we can take from the master a backup that includes, in addition to a dump contai...
Corrupted MyISAM Tables Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: • T...
