Search Results
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
Authentication involves one party establishing its identity to the satisfaction of a second party. Multifactor authentication (MFA) is the use of multiple authentication values (or “factors”) during the authentication process. MFA provides ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgmd.html
The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request it. Management clients can connect to the management server and check the cluster's status. All ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. By default, it waits for the cluster to achieve STARTED ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable Optimizations”). Changes to this variable affect execution of all subsequent queries; to affect one query differently ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 7.6.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...