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/mysql-shell-tutorial-python-documents-index.html
Add a Nonunique Index To create a nonunique index, pass an index name and the index information to the create_index() method. Add a Unique Index To create a unique index, pass an index name, the index definition, and the index type “unique” to ... Indexes are used to find documents with specific field values ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This read-only value serves as a unique build ID, and is written into the server log at startup. It applies to evaluation of expressions that have either of these equivalent forms, where the optimizer uses a nonunique index to look up col_name ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after plugin startup contains the server description and startup options. Elements ...
https://dev.mysql.com/doc/refman/8.0/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 ... Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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 ...