PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
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 without the other SIGHUP effects such as flushing the thread and host caches and writing a ... 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.0/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.0/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.0/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.0\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.0/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.0\data directory. It is the file ... The MySQL server can be started manually from the command ...
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/en/alter-table-partition-operations.html
The REBUILD keyword is expressly disallowed with subpartitions, and causes ALTER TABLE to fail with an error if so used. CHECK PARTITION and REPAIR PARTITION operations fail when the partition to be checked or repaired contains any duplicate key ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
Attempting to create an index on any other column results in an error. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Just edit your script to correct the error, then tell mysql to execute it again. In the previous sections, you ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...