https://dev.mysql.com/primary-key-optimization.html
These unique IDs can serve as pointers to corresponding rows in other tables when you join tables using foreign keys. The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance ...
https://dev.mysql.com/range-optimization.html
The optimizer estimates the cost of reading qualifying rows for equality range comparisons as follows: If there is a unique index on col_name, the row estimate for each range is 1 because at most one row can have the given value. Otherwise, any ...
https://dev.mysql.com/replication-bugs.html
For example, if you update the slave outside of the slave thread, the data goes out of synchrony, and you can have unique key violations on updates. When you have determined that there is no user error involved, and replication still either does ...
https://dev.mysql.com/replication-channels.html
Each replication channel must have a unique (nonempty) name (see Section 17.2.3.4, “Replication Channel Naming Conventions”). Replication channels represent the path of transactions flowing from a master to a slave. This section describes how ...
https://dev.mysql.com/replication-group-member-stats-table.html
This also serves as a key because it is unique to each member. The replication_group_member_stats table has the following columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this group. This has a ...
https://dev.mysql.com/replication-group-members-table.html
This also serves as a key because it is unique to each member. This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should not be ...
https://dev.mysql.com/replication-gtids-failover.html
Each identifier uniquely identifies a set of binary log events that together make up a transaction. There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new slave which can ...
https://dev.mysql.com/replication-options-gtids.html
GTID transactions have a unique identifier that is used to refer to transactions. The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see ...
https://dev.mysql.com/replication-options-reference.html
The following two lists provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. The command-line options and system variables in the following list relate to replication ...
https://dev.mysql.com/replication-problems.html
Verify that the server_id system variable was set at startup on both the master and slave and that the ID value is unique on each server. If you have followed the instructions but your replication setup is not working, the first thing to do is ...
