Rechercher dans le manuel MySQL

Displaying 101 to 110 of 294 total 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 ...
Displaying 101 to 110 of 294 total results

Rechercher dans le manuel MySQL

Traduction non disponible

Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.

Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-fct-unique-p-11.html

L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.

Références

  1. Consulter le document html Langue du document :en Manuel MySQL : https://dev.mysql.com/

Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.

Table des matières Haut