https://dev.mysql.com/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/referential-constraints-table.html
UNIQUE_CONSTRAINT_CATALOG The name of the catalog containing the unique constraint that the constraint references. UNIQUE_CONSTRAINT_SCHEMA The name of the schema containing the unique constraint that the constraint references. The ...
https://dev.mysql.com/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the master). This identifier is unique not only to the server on which it originated, but is unique across ...GTID assignment distinguishes between client transactions, which are committed on the master, and replicated transactions, which are reproduced on a ...
https://dev.mysql.com/replication-howto-additionalslaves.html
On the new slave, edit the configuration and give the new slave a unique server ID (using the server-id option) that is not used by the master or any of the existing slaves. Also display the server ID and server UUID and verify that these are ...
https://dev.mysql.com/replication-howto-slavebaseconfig.html
If the slave server ID is not already set, or the current value conflicts with the value that you have chosen for the master server, shut down the slave server and edit the [mysqld] section of the configuration file to specify a unique server ID. If ...If this has not already been done, this part of slave setup requires a server ...
https://dev.mysql.com/replication-options.html
For servers that are used in a replication topology, you must specify a unique server ID for each replication server, in the range from 1 to 232 − 1. “Unique” means that each ID must be different from every other ID in use by any other ... The ...
https://dev.mysql.com/replication-rbr-safe-unsafe.html
ON DUPLICATE KEY UPDATE statements on tables with multiple primary or unique keys. When executed against a table that contains more than one primary or unique key, this statement is considered unsafe, being sensitive to the order in which the ...
https://dev.mysql.com/show-slave-hosts.html
Master_id: The unique server ID of the master server that the slave server is replicating from. Slave_UUID: The globally unique ID of this slave, as generated on the slave and found in the slave's auto.cnf file. SHOW SLAVE HOSTS Displays a list of ...
https://dev.mysql.com/table-waits-summary-tables.html
The table_io_waits_summary_by_table table has these indexes: Unique index on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) TRUNCATE TABLE is permitted for table I/O summary tables. The table_io_waits_summary_by_index_usage table has these indexes: ...
https://dev.mysql.com/timestamp-lookups.html
For example: SET time_zone = 'MET'; Unique UTC values stored in the TIMESTAMP column are not unique in the session time zone due to DST shifts. If the index is not UNIQUE, it is possible for the table (and the index) to store multiple instances of a ... Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and ...
