Search Results
https://dev.mysql.com/doc/refman/8.4/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%test_plugin%'; ...This ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
MySQL handles errors during trigger execution as follows: If a BEFORE trigger fails, the operation on the corresponding row is not performed. An error during either a BEFORE or AFTER trigger results in failure of the entire statement that caused ...
https://dev.mysql.com/doc/refman/8.4/en/using-stack-trace.html
On some operating systems, the error log contains a stack trace if mysqld dies unexpectedly. A stack trace in the error log looks something like this: mysqld got signal 11; Attempting backtrace. You can use this to find out where (and maybe why) ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/refman/8.4/en/windows-server-first-start.html
If you omit the --console option, the server writes diagnostic output to the error log in the data directory (C:\Program Files\MySQL\MySQL Server 8.4\data by default). The error log is the file with the .err extension, and may be set using the ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-command-line.html
If mysqld doesn't start, check the error log to see whether the server wrote any messages there to indicate the cause of the problem. By default, the error log is located in the C:\Program Files\MySQL\MySQL Server 8.4\data directory. It is the file ... The MySQL server can be started manually from the command ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
If the current session tries to commit or roll back a given XA transaction (even one which it prepared) after another connection has already done so, the attempt is rejected with an invalid XID error (ER_XAER_NOTA) since the requested xid no longer ... An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
Errors were returned similar to the following: Assertion failure: row0pread.h:306:active >= n_threads (Bug #38325137) Under certain circumstances, a virtual index rollback could fail on 32-bit builds of MySQL Server. Errors were returned similar to ... Audit Log Notes Compilation Notes SQL Function and Operator Notes InnoDB Notes Optimizer Notes Packaging Notes Performance Schema Notes Bugs Fixed Audit Log Notes Fixed an issue related to audit log ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-other.html
mysqlbackup --error-code=CODE print-message print-message Prints the associated exit message for a mysqlbackup exit code to the stdout stream. Use the --error-code option to supply the exit code for which you want to receive the associated exit ...
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 ...