Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). To ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/8.4/en/while.html
Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-2.html
Bugs Fixed InnoDB: In some cases, following the creation of a very large number of tables (8001 or more), the server could not be restarted successfully. (Bug #110402, Bug #35200385) Group Replication: Running a CREATE TABLE ... (Bug #36808732) ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backing-up.html
This section explains the preparations you need for creating backups with MySQL Enterprise Backup, the typical backup-verify-restore cycle, and the different backup scenarios for using MySQL Enterprise Backup. It also includes sample commands and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-apply-log.html
A directory backup, just like a single-file backup, can be prepared and restored using the copy-back-and-apply-log command as explained at the beginning of Section 5.1, “Performing a Restore Operation”. Example 5.10 Restoring a Backup Directory ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-validate.html
To ensure the integrity of the backup data, MySQL Enterprise Backup provides a validate command for validating a backup by the checksum values of its data pages after the backup is created or transferred to another system. mysqlbackup [STD-OPTIONS] ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-storage.html
To make mysqlbackup create these subdirectories automatically, specify the --with-timestamp option each time you run mysqlbackup. Most mysqlbackup operations, including those on single-file backups, write data or metadata to a designated directory ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.compatibility.html
To work with backups created by MySQL Enterprise Backup 8.4.2 and earlier, always use the MySQL Enterprise Backup of the same release number. MySQL Enterprise Backup 8.4.6 supports the MySQL Server 8.4.x series for back up and restore for release ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/exec-option.html
This command can copy or create additional files in the backup directory. The --exec-when-locked option of mysqlbackup lets you specify a command (together with the desired command arguments) to run near the end of the backup while the database's ...