Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-floatvalues.html
Comparisons of floating-point values might yield different results on source and replica servers due to differences in computer architecture, the compiler used to build MySQL, and so forth. With statement-based replication, values are converted ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-reserved-words.html
For listings of reserved words by MySQL version, see Keywords and Reserved Words in MySQL 8.0, in the MySQL Server Version Reference. You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. For example, you may want to distribute different sales data to different departments to help spread the load during data ...
https://dev.mysql.com/doc/refman/9.7/en/resource-group-statements.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. This section describes the SQL ...
https://dev.mysql.com/doc/refman/9.7/en/shared-key-cache.html
Shared access to the key cache enables the server to improve throughput significantly. Threads can access key cache buffers simultaneously, subject to the following conditions: A buffer that is not being updated can be accessed by multiple sessions. A buffer that is being updated causes sessions that need to use it to wait until the update is ...
https://dev.mysql.com/doc/refman/9.7/en/show-parse-tree.html
Note This statement is available only in debug builds, or if the MySQL server was built using -DWITH_SHOW_PARSE_TREE. SHOW PARSE_TREE select_statement SHOW PARSE_TREE displays a representation of the parse tree for the input SELECT statement, in ...
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-unused-indexes.html
This view is most useful when the server has been up and processing long enough that its workload is representative. These views display indexes for which there are no events, which indicates that they are not being used. Otherwise, presence of an ...