https://dev.mysql.com/xa-statements.html
Each XA transaction must have a unique xid value, so the value must not currently be used by another XA transaction. For this reason, gtrid values must be globally unique so that there is no ambiguity about which global transaction a given XA ... To ...
https://dev.mysql.com/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/alter-table-partition-operations.html
This includes the rules governing the relationship between any unique keys (including any primary key) that the table might have, and the column or columns used in the partitioning expression, as discussed in Section 23.6.1, “Partitioning Keys, ...
https://dev.mysql.com/ansi-diff-foreign-keys.html
A FOREIGN KEY constraint that references a non-UNIQUE key is not standard SQL but rather an InnoDB extension. In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row.
https://dev.mysql.com/clone-plugin-remote.html
The following prerequisites also apply: Undo tablespace file names on the donor must be unique. To view undo tablespace file names on the donor to ensure that they are unique, query INFORMATION_SCHEMA.FILES: mysql> SELECT TABLESPACE_NAME, FILE_NAME ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...
https://dev.mysql.com/create-spatial-reference-system.html
The combination of the ORGANIZATION org_name and org_id attribute values must be unique. srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit ...
https://dev.mysql.com/data-size.html
If it is very likely that a long string column has a unique prefix on the first number of characters, it is better to index only this prefix, using MySQL's support for creating an index on the leftmost part of the column (see Section 13.1.15, ...
https://dev.mysql.com/events-statements-current-table.html
The THREAD_ID and EVENT_ID values taken together uniquely identify the row. The value is unique for the server instance because these IDs are generated using a global counter that is incremented atomically. The table stores one row per thread ...
https://dev.mysql.com/events-waits-current-table.html
The THREAD_ID and EVENT_ID values taken together uniquely identify the row. With single-row reporting, the total number of instrumented operations is: 10 + (10 * 20) + (10 * 20 * 30) = 6210 A significant reduction in the number of instrumented ...
https://dev.mysql.com/faqs-storage-engines.html
What are the unique benefits of the ARCHIVE storage engine? A.2.1. What are the unique benefits of the ARCHIVE storage engine? The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects ...
