https://dev.mysql.com/prepared-statements-instances-table.html
For a prepared statement created by a stored program, these columns point to the stored program. The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed ...
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/replicaset-adopting.html
From this point you must administer the InnoDB ReplicaSet using only AdminAPI. As an alternative to creating a new InnoDB ReplicaSet, you can also adopt an existing replication setup using the adoptFromAR option with dba.createReplicaSet(). The ...
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 ...
