Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
Important Downgrade from MySQL 8.4 to MySQL 8.3, or from a MySQL 8.4 release to a previous MySQL 8.4 release, is not supported. The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables.
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
It is important to understand the impact of each of these to existing applications. MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
When selecting primary key columns, choose columns with the following characteristics: Columns that are referenced by the most important queries. InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump utilities. Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. VALUES row_constructor_list [ORDER BY column_designator] [LIMIT ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
When creating a passwordless-authentication account, it is important to include the INITIAL AUTHENTICATION IDENTIFIED BY clause in the CREATE USER statement. Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Limiting Common Table Expression Recursion It is important for recursive CTEs that the recursive SELECT part include a condition to terminate recursion. A common table expression (CTE) is a named temporary result set that exists within the scope of ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The algorithm names zstd_stream, lz4_message, and deflate_stream can be specified in any combination, and the order and lettercase are not important. X Plugin supports compression of messages sent over X Protocol connections. Connections can be ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-single-file.html
Important Even with all files extracted from the backup image, extract only creates a raw backup directory, which is NOT ready to be restored by the copy-back command. Besides the commands for creating and restoring single-file backups (namely, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-message-logging-options.html
mysqlbackup writes important progress and error information to the stderr stream. The information is often very valuable for tracking down problems that occur during an operation. Starting from MySQL Enterprise Backup 3.9, the output to the stderr ...