Search Results
https://dev.mysql.com/doc/refman/8.4/en/table-corruption.html
If you get a lot of these errors, without mysqld having died unexpectedly just before, then something is wrong and needs to be investigated further. When the server detects MyISAM table corruption, it writes additional information to the error log, ... If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-configuration.html
otel_log_level Command-Line Format --otel_log_level Type Enumeration Default Value ERROR Valid Values ERRORSILENTWARNINGINFODEBUG Controls which OpenTelemetry logs are printed in the server logs otel_resource_attributes Command-Line Format ...Server ...
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/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 ...