Search Results
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has ...
https://dev.mysql.com/doc/refman/8.4/en/show-engine.html
SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
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 ...