Search Results
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including replicas. If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
You can set up replication channels to assign a GTID to replicated transactions that do not already have one. This feature enables replication from a source server that does not have GTIDs enabled and does not use GTID-based replication, to a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, cloning or copying of the data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the channel. Details of the error and the last applied transaction are recorded in the Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication topology. Replication filters can be global or specific to a channel, enabling you to configure ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement. The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing ...
https://dev.mysql.com/doc/refman/8.4/en/reset.html
reset_option: { BINARY LOGS AND GTIDS | REPLICA } The RESET statement is used to clear the state of various server operations. For information about the RESET PERSIST statement that removes persisted global system variables, see Section 15.7.8.7, ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...