Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-api.html
DefaultHashMapSize: Set size (in buckets) to use for table hash maps. ArbitrationDelay: When asked to arbitrate, arbitrator waits this many milliseconds before voting. AutoReconnect: Specifies whether an API node should reconnect fully when ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/9.7/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab and adding or editing a foreign key is similar to adding or editing an index. The following figure shows an example of the Foreign Keys tab. Figure 8.16 The Foreign ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-triggers-tab.html
The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT. To add a new trigger, click the [+] icon ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-commmitting-statements.html
(R-log-commit-statement) All other statements that have a pre-commit are written directly to the binlog. (Note: this is semantically equivalent to writing it to the SC and flushing the SC. However, due to requirements by NDB (which have not been ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mgmd.html
ArbitrationDelay: When asked to arbitrate, arbitrator waits this long before voting (milliseconds). ExtraSendBufferMemory: Memory to use for send buffers in addition to any allocated by TotalSendBufferMemory or SendBufferMemory.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-other.html
AllowUnresolvedHostNames: When false (default), failure by management node to resolve host name results in fatal error; when true, unresolved host names are reported as warnings only. Checksum: If checksum is enabled, all signals between nodes are ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 − 1. To specify more than one database, use this option multiple times, once for each database; however, ...