Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_COLUMNS where TABLE_ID = 71\G *************************** 1. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-datafiles-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE SPACE = 57\G *************************** 1. The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general tablespaces. For related usage ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FIELDS WHERE INDEX_ID = 117\G *************************** 1. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-cols-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS WHERE ID = 'test/fk1'\G *************************** 1. The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. For related usage information and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------------------+ | KEY | VALUE | +---------------------------+-------------------+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 0 | | ... The ...
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. For information about the default InnoDB stopword list and how to define your own stopword lists, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-deleted-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DELETED; +--------+ | DOC_ID | +--------+ | 6 | | 7 | | 8 | +--------+ Notes You must have the PROCESS privilege to query this table. The INNODB_FT_DELETED table stores rows that are deleted ...
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 ...