https://dev.mysql.com/innodb-indexes-table.html
Index identifiers are unique across all the databases in an instance. Most indexes created implicitly by InnoDB have consistent names but the index names are not necessarily unique. 0 = nonunique secondary index; 1 = automatically generated ...For ...
https://dev.mysql.com/innodb-locking.html
Gap locking is not needed for statements that lock rows using a unique index to search for a unique row. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for ...
https://dev.mysql.com/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. If the memcached server is used for multiple applications, or with more than one InnoDB ...
https://dev.mysql.com/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. For a unique index with a unique ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/invisible-indexes.html
For example, an index continues to be updated per changes to table rows, and a unique index prevents insertion of duplicates into a column, regardless of whether the index is visible or invisible. A table with no explicit primary key may still have ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/mysql-cluster-mgm-definition.html
Id Table 22.9 This table provides type and value information for the Id management node configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units unsigned Default [none] Range 1 - 255 Restart Type IS Each node in the cluster ... The [ndb_mgmd] section is used to configure the behavior of the management ...
https://dev.mysql.com/mysql-cluster-option-tables.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. The following table provides a list of the command-line options, server and status variables applicable ...
https://dev.mysql.com/mysql-cluster-params-ndbd.html
MaxUIBuildBatchSize: Maximum scan batch size to use for building unique keys. Increasing this value may speed up builds of unique keys but impacts ongoing traffic as well. NodeId: Number uniquely identifying the data node among all nodes in the ...
https://dev.mysql.com/mysql-installer-workflow.html
The ID of each server instance within a cluster must be unique; however, you can reuse the same number in a different cluster. The ID of each server instance within a cluster must be unique; however, you can reuse the same number in a different ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-indexes-create.html
For example, the following query will perform better with an index: mysql-js> db.countryinfo.find("demographics.Population < 100") ...[output removed] 8 documents in set (0.00 sec) The createIndex() method creates an index that you can define as ...
