Management nodes. When building from source and running the default make install, the management server and management client binaries (ndb_mgmd and ndb_mgm) can be found in / usr/local/mysql/bin. Only ndb_mgmd is required to be present on a mana...
memcached General Statistics The output of the general statistics provides an overview of the performance and use of the memcached instance. The statistics returned by the command and thei...
MySqlCommand Class For a list of all members of this type, see MySqlCommand Members. Syntax: Visual Basic NotInheritable Public Class MySqlCommand_ Inherits Component_ Implements IDbCommand, ICloneable Syntax: C# public sealed class MySqlCommand : Component, IDbCommand, ICloneable Thread Saf...
Other Storage Engines Other storage engines may be available from third parties and community members that have used the Custom Storage Engine interface. Third party engines are not supported by MySQL. For further information, documentation, installation guides, bug reporting or for any help or ...
Overview of MySQL with Windows Failover Clustering Microsoft Windows is consistently ranked as the top development platform for MySQL, based on surveys of the MySQL user community. MySQL Enterprise Edition is certified and supported with Windows Server 2008 R2 Failover Clustering (WSFC), enablin...
RBL and synchronization of nontransactional tables. When many rows are affected, the set of changes is split into several events; when the statement commits, all of these events are written to the binary log. When executing on the slave, a table lock is taken on all tables involved, and then the ...
Replication and the Query Optimizer It is possible for the data on the master and slave to become different if a statement is written in such a way that the data modification is nondeterministic; that is, left up the query optimizer. (In general, this is not a good practice, even outside of repli...
Replication Retries and Timeouts The global system variable slave_transaction_retries [2033] affects replication as follows: If the slave SQL thread fails to execute a transaction because of an InnoDB deadlock or because it exceeded the InnoDB in...
Restrictions on foreign keys. Support for foreign key constraints in MySQL Cluster NDB 7.3 is comparable to that provided by InnoDB, subject to the following restrictions: • ON UPDATE CASCADE is ...
Statement Instrument Components • statement/com: An instrumented command operation. These have names corresponding to COM_xxx operations (see the mysql_com.h header file and sql/sql_parse.cc. For example, the statement/com/Connect and statement/com/Fetch instruments correspond to the COM_CONNECT...
