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/start-replica.html
You must check the replica's error log for error messages generated by the replication threads, or check that they are running satisfactorily with SHOW REPLICA STATUS. START REPLICA [thread_types] [until_option] [connection_options] ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server-troubleshooting.html
If you have problems starting the server, here are some things to try: Check the error log to see why the server does not start. The default data directory location is hardcoded when the server is compiled. If you get Errcode 13 (which means ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP REPLICA instruction remains in effect. If the replica is stopped unexpectedly (for example due to an error in a worker thread, or another ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
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 ...