Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
TRUNCATE TABLE does not work for this purpose because this removes only the table data; the data nodes continue to store an NDBCLUSTER table's definition until a DROP TABLE statement is issued that causes the table metadata to be dropped. In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb-log-empty-epochs: When enabled, causes epochs in which there were no changes to be written to ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...The result is that MyISAM data and index files are created in the table's database ...This can cause problems if no corresponding directory exists in the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the INSERT statements are replayed. This method also does not work reliably if the source and replica have ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. If you include ...All changes are subject to the internal row-size limit of 65,535 bytes, which may cause some attempts at data type changes to ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The optimizer may index the table with a hash index to make lookups fast and inexpensive. The index contains unique values to eliminate duplicates and make the table smaller. MySQL can also apply subquery materialization to a single-table UPDATE or ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb-log-empty-epochs: When enabled, causes epochs in which there were no changes to be written to ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
Synchronizing models with objects that differ in case may lead to MySQL Workbench producing a DROP statement for that object, before recreating it as lowercase. Also note that clicking on a row will reveal the associated SQL statement, as shown in ...These three types can be the target (destination), source, or ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The connection errors are, by default, propagated to the client, which has to handle them by, for example, recreating the working objects (Statement, ResultSet, etc.) and restarting the processes. This means the client can rely on the same ...A ...
https://dev.mysql.com/doc/connectors/en/connector-j-logging-slf4j.html
Here is output of the program when the SELECT statement failed: [2021-09-05 12:06:19,624] WARN 0[main] - WARN MySQL - Warning: Select failed! . Besides its default logger com.mysql.cj.log.StandardLogger, which logs to stderr, Connector/J supports ...