Memory usage and recovery. Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: • A DELETE statement on an NDB table make...
MERGE Table Advantages and Disadvantages MERGE tables can help you solve the following problems: • Easily manage a set of log tables. For example, you can put data from different months into separate tables, compress some of them with myisampac...
MERGE Table Problems The following are known problems with MERGE tables: • In versions of MySQL Server prior to 5.1.23, it was possible to create temporary merge tables with nontemporary child MyISAM tables. From versions 5.1.23, MERGE children ...
Mixing transactional and nontransactional statements within the same transaction. In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. You should also avoid using a...
Multiple column Mapping • During plugin initialization, when InnoDB memcached is configured with information defined in the containers table, each mapped column that is parsed from value_columns is verified against the mapped table. If multiple c...
Multiple management nodes. When using multiple management servers: • You must give nodes explicit IDs in connect strings because automatic allocation of node IDs does not work across multiple management servers. • When a management server star...
MyISAM Table Storage Formats MyISAM supports three different storage formats. Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you are using. The third, compressed format, can be created only with t...
MySQL Cluster Auto-Installer Overview The MySQL Cluster Auto-Installer is made up of two components. The front end is a GUI client implemented as a Web page that loads and runs in a standard Web browser such as Firefox or Microsoft Internet Explorer (see Section 17.2.1.1, “MySQL Cluster Auto-Inst...
MySQL Cluster Configuration Files Configuring MySQL Cluster requires working with two files: • my.cnf: Specifies options for all MySQL Cluster executables. This file, with which you should be familiar with from previous work with MySQL, must be accessible by each executable running in the cluste...
MySQL Cluster Connection Strings With the exception of the MySQL Cluster management server (ndb_mgmd), each node that is part of a MySQL Cluster requires a connection string that points to the management server's location. This connection string is used in establishing a connection to the managem...
