PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-table-check-constraints.html
Consequently, CHECK constraint names must be unique per schema; no two tables in the same schema can share a CHECK constraint name. (Exception: A TEMPORARY table hides a non-TEMPORARY table of the same name, so it can have the same CHECK constraint ... CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
This means that each Disk Data object must be uniquely named (and not merely each Disk Data object of a given type). If the ADD DATAFILE clause is not specified when creating an InnoDB tablespace, a tablespace data file with a unique file name is ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-configuring-instances.html
server_id=1 gtid_mode=ON enforce_gtid_consistency=ON These settings configure the server to use the unique identifier number 1, to enable Section 19.1.3, “Replication with Global Transaction Identifiers”, and to allow execution of only ... This ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-requirements.html
Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key. Such keys are required as a unique identifier for every row within a table, enabling the ...
https://dev.mysql.com/doc/refman/9.7/en/information-functions.html
Every connection has an ID that is unique among the set of currently connected clients. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-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/doc/refman/9.7/en/innodb-analyze-table-complexity.html
For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
InnoDB Full-Text Index DOC_ID and FTS_DOC_ID Column InnoDB uses a unique document identifier referred to as the DOC_ID to map words in the full-text index to document records where the word appears. InnoDB creates a hidden FTS_DOC_ID column along ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-index-types.html
If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. Auto-increment column values are unique and are added automatically as new rows are inserted. If you do not define a PRIMARY ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/9.7/en/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 ...