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/switchable-optimizations.html
Specifying any given opt_name more than once in the value is not permitted and causes an error. Any errors in the value cause the assignment to fail with an error, leaving the value of optimizer_switch unchanged. Its value is a set of flags, each of ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
For example, you cannot select from the mysql.schemata table directly: mysql> SELECT * FROM mysql.schemata; ERROR 3554 (HY000): Access to data dictionary table 'mysql.schemata' is rejected. The statements are now transactional and either succeed for ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.0/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.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 ...