Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table ...The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text ...
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 ...For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. The ...For usage ...row *************************** TABLE_ID: 97 NAME: #sql8c88_43_0 N_COLS: 4 SPACE: 76 Notes This table is useful primarily for expert-level ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
In that case you need to add 'innodb_data_file_path=ibdata1:12M:autoextend' to the target server configuration. Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and ...Use, for ... To ...For the various options that you can specify for this operation, see Section 19.3, “Restore ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cached-indexes-table.html
SELECT tables.NAME AS table_name, indexes.NAME AS index_name, cached.N_CACHED_PAGES AS n_cached_pages FROM INFORMATION_SCHEMA.INNODB_CACHED_INDEXES AS cached, INFORMATION_SCHEMA.INNODB_INDEXES AS indexes, INFORMATION_SCHEMA.INNODB_TABLES AS tables ... The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
row *************************** page_size: 16384 compress_ops: 0 compress_ops_ok: 0 compress_time: 0 uncompress_ops: 0 uncompress_time: 0 Notes Use these tables to measure the effectiveness of InnoDB table compression in your database. The ...row ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmpmem-table.html
row *************************** page_size: 16384 buffer_pool_instance: 0 pages_used: 0 pages_free: 0 relocation_ops: 0 relocation_time: 0 Notes Use these tables to measure the effectiveness of InnoDB table compression in your database. The ...row ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
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 contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
Before an in-place online DDL operation can finish, it must wait for transactions that hold metadata locks on the table to commit or roll back. This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. The INNODB_FIELDS table has these columns: INDEX_ID An identifier for the index associated with this key field; the same value as INNODB_INDEXES.INDEX_ID.