Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-exclusive-to-cluster.html
The following are limitations specific to the NDB storage engine: Machine architecture. All machines used in the cluster must have the same architecture. That is, all machines hosting nodes must be either big-endian or little-endian, and you cannot ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
Execute one or more CREATE NODEGROUP commands in the NDB Cluster management client to create the new node group or node groups to which the new data nodes belong. Exception: For tables created using the MAX_ROWS option, this statement does not work; ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. For optimal performance when loading data into an InnoDB FULLTEXT index, ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-table-problems.html
Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. It may occur for temporary tables created outside stored functions ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it ...For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-single-file.html
To avoid having a large number of backup files to keep track, store, and transport, mysqlbackup conveniently creates backups in a single-file format. Example 4.1 Single-File Backup to Absolute Path This command creates a single backup image on the ...It can also pack an existing backup directory into a single file, unpack the single file back to a backup directory, list the contents of a single-file backup, verify the contents of a single-file backup against embedded checksums, or extract a single file into a directory ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-faq.html
Set the configuration option innodb_file_per_table=1 before creating your biggest or most active InnoDB tables. This is because the directory backup contains metadata created by mysqlbackup that the MySQL server would not understand; also, the raw ... This section lists some common questions about MySQL Enterprise Backup, with answers and pointers to further ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-backup-agents.html
The backup for each agent is created in a subfolder named rep_backup/timestamp under the agent repository (the mcm_data folder), with timestamp reflecting the time the backup began. If you want the backup to be at another place, create a soft link ... backup agents [--hosts=host_list] [site_name] host_list: host[, host[, ...]] This command backs up the configuration data for the mcmd agents on the hosts specified in host_list with the --hosts option (short form: -h) for the site named ...