PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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 15.1.15, ...
https://dev.mysql.com/doc/refman/8.0/en/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 ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/group-replication-distributed-recovery-connections.html
It is recommended that operating systems running MySQL have a properly configured unique host name, either using DNS or local settings. In this situation you can use MySQL Server's report_host system variable to configure a unique host name to be ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.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/doc/refman/8.0/en/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 19.1.3, “Replication with Global Transaction ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-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 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-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 ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...