Search Results
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/refman/8.4/en/x-plugin-connection-compression.html
X Plugin supports compression of messages sent over X Protocol connections. Connections can be compressed if the server and the client agree on a mutually supported compression algorithm. Enabling compression reduces the number of bytes sent over ...
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-commands-single-file.html
Besides the commands for creating and restoring single-file backups (namely, backup-to-image and copy-back-and-apply-log), mysqlbackup provides a number of other commands for you to work with single-file backups. Note image-to-backup-dir only ...