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/replication-administration-status.html
The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the source. The SHOW REPLICA STATUS statement, which you must execute on each replica, ...The Performance Schema has replication tables that provide this information in a more accessible ...
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/show-engines.html
For information about MySQL storage engines, see Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. In the latter case, the error log should contain a reason indicating why the option is disabled. SHOW [STORAGE] ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. The grammar shown here is based on that given in the sql/sql_yacc.yy file of ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
INFORMATION_SCHEMA is an information database, so its name is included in the output from SHOW DATABASES. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure ...Several SHOW statements accept a WHERE clause that provides more flexibility in specifying which rows to ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
Loadable functions, as the name implies, must be loaded into the server before they can be used. For example: CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; The file base name depends on your platform. For this reason, CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-remote-connections.html
To accept IPv6 connections from clients outside the local network, the server host must have a public address. For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as ... The following procedure shows how to configure MySQL to permit IPv6 connections by remote ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-options.html
Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 29.4, ...Options ...
https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html
To make the global system variable setting permanent so that it applies across server restarts, you must set it in an option file. Replication works because events written to the binary log are read from the source and then processed on the replica. The events are recorded within the binary log in different formats according to the type of ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
The following characteristics are relevant for this purpose: READ ONLY READ WRITE ISOLATION LEVEL WITH CONSISTENT SNAPSHOT Available Session State Trackers To support the session-tracking activities, notification is available for these types of ...A ...Transaction state tracking enables this, which is useful for applications that may wish to move transactions from a busy server to one that is less ...