Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
ICP is not supported with secondary indexes created on virtual generated columns. Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-check-constraints-table.html
CREATE TABLE supports the core features of table and column CHECK constraints; the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. You can cause such information to be hidden by setting show_gipk_in_create_table_and_information_schema = OFF. The related ST_GEOMETRY_COLUMNS ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-per-index-table.html
Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out. The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
Pages are compressed whenever an empty page is created or the space for the uncompressed modification log runs out. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-datafiles-table.html
If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. This is not used if you override the default stopword processing with either the ...For information about the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...