Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
It connects to a current MySQL (not NDB Cluster) database and creates a report on how much space that database would require if it used the NDB storage engine. Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type ...
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 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-import-config.html
import config requires a single argument, cluster_name, which is the name of the cluster created using MySQL Cluster Manager into which you wish to import the configuration of a MySQL NDB Cluster created externally. The cluster named in the command ... import config [--dryrun|-y] [--retry] cluster_name This command imports the configuration of an autonomous or “wild” cluster into the cluster named ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/mysql-threads.html
The MySQL server creates the following threads: Connection manager threads handle client connection requests on the network interfaces that the server listens to. The server does not create threads to handle interfaces that it does not listen to.