Search Results
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
SIGUSR1 causes the server to flush the error log, general query log, and slow query log. The server response to SIGUSR1 is a subset of the response to SIGHUP, enabling SIGUSR1 to be used as a more “lightweight” signal that flushes certain logs ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
Check for errors and warnings in the MySQL error log and application logs. MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
In this case, remove all redo log files and restart the MySQL 8.3 server on the existing data directory to address the errors. After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0) before attempting the upgrade ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
The WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() SQL function, deprecated in MySQL 8.0 has been removed; attempting to invoke it now causes a syntax error. In MySQL 8.4, setting any of these to NULL is specifically disallowed, and attempting to do is ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
If validate_password rejects the new password, it reports an error indicating the minimum number of characters that must differ. The value cannot be set less than the value of this expression: validate_password.number_count + ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-elements.html
Otherwise, the plugin returns an error to the client and the statement fails. If the server has a different state when a client sends a statement, the client receives an error. Version Tokens is based on a plugin library that implements these ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
Then the view replicates properly, and can be dumped and reloaded without causing an error. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...