Search Results
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
The client queries the device to check if it supports Client-to-Authenticator Protocols (CTAP2) protocol. Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions.html
MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row. The following sections discuss how to use window functions, including descriptions of the OVER and WINDOW clauses. For ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
For general X Plugin monitoring, use the status variables that it exposes. For information specifically about monitoring the effects of message compression, see Monitoring Connection Compression for X Plugin. Monitoring SQL Generated by X Plugin ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
(Bug #37003342, Bug #36768046, Bug #36867372) Optimizer Notes Fixed an issue relating to SQL queries involving correlated scalar subqueries and JSON tables. Audit Log Notes Compilation Notes SQL Function and Operator Notes InnoDB Notes Optimizer ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
You can restore your database server to its state at an arbitrary time using the binary log files included in the backups. The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-history-table-update.html
Rename the original mysql.backup_history table to mysql.backup_history_old, and the mysql.backup_history_new table to mysql.backup_history. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-sbt-history-table-update.html
Rename the original mysql.backup_sbt_history table to mysql.backup_sbt_history_old, and the mysql.backup_sbt_history_new table to mysql.backup_sbt_history. Note If you are working with a multiprimary Group Replication setting, make sure these ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.verify.html
You can then execute SHOW statements to verify the database and table structures, and execute queries to verify further details of the database. You can check the integrity of your backup using the validate command. The following is a sample ...