https://dev.mysql.com/privilege-changes.html
The in-memory tables become effective for access control at that point. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant ...
https://dev.mysql.com/problems-with-null.html
If you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that ...
https://dev.mysql.com/regexp.html
An equivalence class may not be used as an endpoint of a range. A character class may not be used as an endpoint of a range. You should keep in mind that positional indexes are based on 16-bit chunks and not on code points. This section discusses ...
https://dev.mysql.com/rename-table.html
Foreign key constraint names that point to the renamed table are automatically updated unless there is a conflict, in which case the statement fails with an error. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must ...
https://dev.mysql.com/replication-binlog-encryption-scope.html
Existing binary log files and relay log files that were present on the server when you started encryption are not encrypted. You can purge these files when they are no longer needed. Data in motion in the replication event stream, which is sent to ...
https://dev.mysql.com/replication-features-transaction-inconsistencies.html
That is, all transactions up to point N have been applied, and no transactions after N have been applied, but Exec_master_log_pos has a value smaller than N. Inconsistencies in the sequence of transactions that have been executed from the relay log ...
https://dev.mysql.com/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between master and slave. When GTIDs are in use, all the information that the slave needs for synchronizing with the ...
https://dev.mysql.com/replication-howto-masterstatus.html
To configure the slave to start the replication process at the correct point, you need to note the master's current coordinates within its binary log. Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for ...
https://dev.mysql.com/replication-options-reference.html
slave_checkpoint_period: Update progress status of multithreaded slave and flush relay log info to disk after this number of milliseconds. The following two lists provide basic information about the MySQL command-line options and system variables ...
https://dev.mysql.com/replication-privilege-checks-recover.html
For instructions to do this, see Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”. If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the ...
