Search Results
https://dev.mysql.com/doc/refman/8.4/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
When a table with instantly added or dropped columns is rebuilt due to a table-rebuilding ALTER TABLE or OPTIMIZE TABLE operation, the value is reset to 0. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
It is ready to be dropped or made active again by an ALTER UNDO TABLESPACE ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing changes. Each row in this table corresponds to an individual partition or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
You can create and drop indexes and perform other DDL operations with much less impact on performance and availability. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
For general tablespaces, keep in mind that dropping a table does not reduce the size of the general tablespace .ibd file, nor does it return disk space to the operating system. Compressed tables can be created in file-per-table tablespaces or in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
In this case, you can restore the tablespace data file from a backup or drop the table to remove the information about it from the data dictionary. There are different reasons for creating InnoDB tables externally; that is, creating tables outside ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text file, drop the table, and reload it from the dump file. Random insertions into or deletions from a secondary index can cause the index to become ...