Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. Tables are created or their structure modified, and data is inserted, deleted, and updated according to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
The RESET REPLICA ALL statement removes channel specific replication filters that were set on channels deleted by the statement. When the deleted channel or channels are recreated, any global replication filters specified for the replica are copied ... This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
For example, if the user table grants you the DELETE privilege, you can delete rows from any table in any database on the server host. After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
For a server where binary logging is enabled (log_bin is ON), RESET BINARY LOGS AND GTIDS deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. Issuing RESET ... Note This statement takes the place of the old RESET MASTER statement, which is no longer ...
https://dev.mysql.com/doc/refman/8.4/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET BINARY LOGS AND GTIDS Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. Also ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL Account”. If you know the root ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
If you delete or rename the table, the files that its symbolic links point to also are deleted or renamed. When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
Status The plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETING, or DELETED. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. Update_time displays ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...