Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a FEDERATED table points to must exist before you try to access the table through the ...
https://dev.mysql.com/general-tablespaces.html
If the ADD DATAFILE clause is not specified when creating a tablespace, a tablespace data file with a unique file name is created implicitly. The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by ... A ...
https://dev.mysql.com/group-replication-deploying-locally.html
For each member you must ensure a unique address is specified, so use a unique port per instance for group_replication_local_address. The most common way to deploy Group Replication is using multiple server instances, to provide high availability.
https://dev.mysql.com/group-replication-options.html
The address or host name that you specify in group_replication_local_address is used by Group Replication as the unique identifier for a group member within the replication group. This section lists the system variables that are specific to the ...
https://dev.mysql.com/group-replication-view-changes.html
Randomly generating part of the identifier when the group is started from the beginning ensures that the data markers in the binary log remain unique, and an identical identifier is not reused after a full group shutdown, as this would cause issues ... When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section 17.1.3, “Replication with Global Transaction ...
https://dev.mysql.com/innodb-auto-increment-handling.html
In this lock mode, auto-increment values are guaranteed to be unique and monotonically increasing across all concurrently executing “INSERT-like” statements. InnoDB provides a configurable locking mechanism that can significantly improve ...
https://dev.mysql.com/innodb-locking-reads.html
For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. In MySQL, the specific task of generating a unique identifier actually can be accomplished using ...
https://dev.mysql.com/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/innodb-tables-table.html
For file-per-table tablespaces, this identifier is unique for tables across all databases in the instance. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table ...
https://dev.mysql.com/innodb-trx-table.html
The INNODB_TRX table has these columns: TRX_ID A unique transaction ID number, internal to InnoDB. TRX_UNIQUE_CHECKS Whether unique checks are turned on or off for the current transaction. The INNODB_TRX table provides information about every ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-unique-p-11.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
