Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
In this case, you should remove all redo log files, start your MySQL 8.3 server on the same data directory, and fix the cause of any errors. Warning Applying SQL extracted from a previous MySQL release to a new MySQL release may result in errors due ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_webauthn'; +-------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... Note WebAuthn authentication is an ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-restrictions.html
The parser recognizes these window constructs which nevertheless are not supported: The GROUPS frame units specifier is parsed, but produces an error. The EXCLUDE clause for frame specification is parsed, but produces an error. The SQL standard ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-osb.html
sbt_error_msg: Error message, when an error occurs while retrieving information for the tape backup. sbt_error_code: Error code, when an error occurs while retrieving information for the tape backup. Tape drives are affordable, high-capacity ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-troubleshooting.html
If mysqlbackup encounters problems during operating system calls, it returns the corresponding OS error codes. You might need to consult your operating system's documentation for the meaning of those error codes and how to handle them. By default, ... To troubleshoot issues regarding backup and restore with the MySQL Enterprise Backup product, consider the following aspects: Before troubleshooting any problem, familiarize yourself with the known limits and restrictions on the product, in Appendix B, Limitations of MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
MaxNoOfSavedMessages: Maximum number of error messages to write in error log and maximum number of trace files to retain. MaxStartFailRetries: Maximum retries when data node fails on startup, requires StopOnError = 0. RestartOnErrorInsert: Control ... ApiFailureHandlingTimeout: Maximum time for API node failure handling before ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-collect-logs.html
When the name of a cluster (cluster_name) is supplied with the command, it collects all the log files (.log) as well as the configuration files (.ini, .cnf), error files (.err), and trace files (.trace.log.*) used by all processes belonging to the ... collect logs [cluster_name] This command collects log files and other related files from all ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-procedure.html
Perform a test run of the proposed migration using import cluster with the --dryrun option, which causes MySQL Cluster Manager to check for errors, but not actually migrate any processes or data. Repeat the dry run from the previous step to ensure ... The importing process consists generally of the steps listed here: Prepare the “wild” cluster for ...