Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/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/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/8.4/en/explain-output.html
EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while processing the statement. This means that MySQL reads a row from the first table, then ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym ...Note It is not possible to issue FLUSH statements within stored functions or ...