PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...These rules also apply to existing nonpartitioned tables that you wish to partition using ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
Group Replication operates either in single-primary mode or in multi-primary mode. The group's mode is a group-wide configuration setting, specified by the group_replication_single_primary_mode system variable, which must be the same on all members. ON means single-primary mode, which is the default mode, and OFF means multi-primary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write mode. All the other members in the group are set to read-only mode (with super_read_only=ON). All other servers that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
NBT_UPDATED_ONLY_MINIMAL and NBT_UPDATED_FULL_MINIMAL can be used with NDB$EPOCH(), NDB$EPOCH2(), and NDB$EPOCH_TRANS(), because these do not require “before” values of columns which are not primary keys. This function has no effects on ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
MySQL can build a hash index on a prefix of any length of the key defined for the B-tree, depending on the pattern of searches against the index. The authentication server (AS) combined with a TGS make up a key distribution center (KDC). These ...
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column ...Query performance benefits from the NOT NULL optimization, because it cannot include any NULL ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. MySQL supports an IGNORE keyword for INSERT, UPDATE, and so forth. If you use it, MySQL ignores ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
If a transaction executes against a table that has foreign keys with cascading constraints, then its commit fails when synchronizing itself with the group. In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...