Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
Note With the exception of the INNODB_FT_DEFAULT_STOPWORD table, these tables are empty initially. INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-internal-data.html
This is not like user tables, where the data changes only when application-initiated updates occur. The data exposed by the transaction and locking tables (INFORMATION_SCHEMA INNODB_TRX table, Performance Schema data_locks and data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
row *************************** TABLE_ID: 71 NAME: test/t1 STATS_INITIALIZED: Initialized NUM_ROWS: 1 CLUST_INDEX_SIZE: 1 OTHER_INDEX_SIZE: 0 MODIFIED_COUNTER: 1 AUTOINC: 0 REF_COUNT: 1 The STATS_INITIALIZED field indicates whether or not statistics ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
The table definition stored in the InnoDB shared tablespace includes the database name. Restoring from a Logical Backup You can use a utility such as mysqldump to perform a logical backup, which produces a set of SQL statements that can be executed ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-multi-versioning.html
In the clustered index, the record's DB_TRX_ID is checked, and the correct version of the record is retrieved from the undo log if the record was modified after the reading transaction was initiated. It keeps information about old versions of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. Concurrent DML makes changes to the table that are allowed with the original table definition, ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
For example, for page compression to work on Windows, you could build the file system with a cluster size of 512 Bytes (which has a compression unit of 8KB) and initialize InnoDB with an innodb_page_size value of 16K or greater. InnoDB supports ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-read_ahead.html
If the number of pages read sequentially from an extent is greater than or equal to innodb_read_ahead_threshold, InnoDB initiates an asynchronous read-ahead operation of the entire following extent. A read-ahead request is an I/O request to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-physical-structure.html
The page size is determined by the innodb_page_size setting when the MySQL instance is initialized. With the exception of spatial indexes, InnoDB indexes are B-tree data structures. Spatial indexes use R-trees, which are specialized data structures ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
When a file-per-table or general tablespace is created with a non-zero AUTOEXTEND_SIZE setting, the tablespace is initialized at the specified AUTOEXTEND_SIZE size. By default, when a file-per-table or general tablespace requires additional space, ...