Search Results
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
In older versions of MySQL, the monitoring tables were INFORMATION_SCHEMA tables (see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”). The INFORMATION_SCHEMA tables are deprecated; expect them to be removed in a future version of MySQL.
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-information-schema-tables.html
Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of MySQL. You should use the versions available as Performance Schema tables instead. Applications should transition away from the old tables ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Attempting to use an obsolete SQL mode prevents MySQL 8.4 from starting. After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0) before attempting the upgrade again. Before upgrading to the latest MySQL 8.4 release, ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using WebAuthn authentication.
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #36421727) When attempting to transform a subquery to a derived table, certain cases were not always considered. Note These release notes were created with the assistance of MySQL HeatWave GenAI. Compilation Notes Configuration Notes InnoDB ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
Each table and its associated indexes are represented by a .ibd file that is deleted or emptied by these DDL operations. This section describes the performance considerations for backing up a database with MySQL Enterprise Backup. When optimizing ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Before backing up a particular database server for the first time, gather some information and use it to make some planning decisions, as outlined in the following table. Table 4.1 Information Needed to Back Up a Database Information to Gather ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
For details on how the MySQL server encrypts and decrypts InnoDB tablespaces, see InnoDB Data-at-Rest Encryption—it explains concepts like master key and tablespace keys, which are important for understanding how MySQL Enterprise Backup works with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
In the following illustration, we back up an entire MySQL instance to a single file using the backup-to-image command, which appears at the end of the sample command. We specify some of the connection information for the database using the --user ...