PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
This statement is meant to be used for a clean start; it clears the replication metadata repositories, deletes all the relay log files, and starts a new relay log file. To use RESET REPLICA, the replication SQL thread and replication I/O (receiver) ... RESET REPLICA [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET REPLICA makes the replica forget its position in the source's binary ...
https://dev.mysql.com/doc/refman/8.0/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. These include ...The ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of MySQL. To determine whether your system supports symbolic links, check the ...For files used by tables for other storage engines, you may get strange problems if you try to use symbolic ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The following discussion enumerates the sources of process information, the privileges required ...The other sources have negative performance consequences because they require a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
row *************************** Id: 10 User: root Host: replica1:58371 db: NULL Command: Binlog Dump Time: 777 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Because it is the replica that drives the replication ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
The replication group must therefore be restarted beginning with the most up to date member, that is, the member that has the most transactions executed and certified. You must therefore restart each member to check the transactions, compare all the ...As long as the remaining members are a majority of the group they can elect a new primary and continue to function as a ... Group Replication is designed to ensure that the database service is continuously available, even if ...
https://dev.mysql.com/doc/refman/8.0/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. Installation using the native packaging system on many platforms, including Debian Linux, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. LOCK IN SHARE MODE causes shared row locks to be used; FOR UPDATE causes exclusive row locks to be used. See Section 25.6.8.4, “NDB Cluster Backup ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
In NDB 8.0.37 and later, you can obtain similar information about individual transporters from the transporter_details table. Connections to API and management nodes which are configured but not currently connected to the cluster are shown with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
SUM_ERROR_HANDLED This column aggregates the number of times the error was handled by an SQL exception handler. FIRST_SEEN, LAST_SEEN Timestamp indicating when the error was first seen and most recently seen. The Performance Schema maintains ...For ...