Search Results
https://dev.mysql.com/doc/refman/8.4/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. (If no CTE refers to itself, RECURSIVE is permitted ...The following discussion describes how to write statements that use ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Source is killing the zombie dump thread(thread_id) has been improved to Upon reconnection with the replica, while initializing the dump thread for UUID uuid, an existing dump thread with the same UUID was detected. Group Replication: In some cases, ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
When a file of an unrecognized file type exists under a subdirectory in the server's data directory, it will be backed up by mysqlbackup unless the --only-known-file-types option is used. Please refer to the MySQL Enterprise Backup 8.4 Release ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-single-file.html
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 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/server-repository-options.html
The specified directory must be non-existent or empty, or the restore operation will fail. The specified directory must be non-existent or empty, or the restore operation will fail. (External undo tablespaces are restored by default to the locations ... These repository options specify various parameters related to the database server to which a backup is ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-process.html
Existing attribute settings in the cluster must have process-level scope to be inherited by new processes added later; instance-level settings set for existing process instances prior to adding any new ones do not apply to any of the added processes. Any hosts referenced in the list must be members of the site to which the cluster ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-delete-site.html
delete site site_name The delete site command deletes an existing management site. If there are any packages referencing hosts belonging to the site, delete site fails with the error Packages exist in site site_name. The command does not stop or ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
Processing these results involves a different approach than for the single-statement case: After handling the result from the first statement, it is necessary to check whether more results exist and process them in turn if so. At the end of the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
ON DUPLICATE KEY UPDATE statements, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row is updated, and 0 if an existing row is set to its current values. If you specify the CLIENT_FOUND_ROWS flag, the ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-6.html
(Bug #37909595) CREATE TABLESPACE, when the specified logfile group did not exist, was rejected with error 723 No such table existed, which did not correctly identify the source of the problem with the SQL statement. already exists showed the table ... MySQL NDB Cluster 8.4.6 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...