Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
Dropping a table or deleting all rows from it is guaranteed to release the space to other users, but remember that deleted rows are physically removed only by the purge operation, which happens automatically some time after they are no longer needed ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-physical-structure.html
If the fill factor of an InnoDB index page drops below the MERGE_THRESHOLD, which is 50% by default if not specified, InnoDB tries to contract the index tree to free the page. With the exception of spatial indexes, InnoDB indexes are B-tree data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
For example: --innodb-temp-data-file-path=../../../tmp/ibtmp1:12M:autoextend Enabling innodb_read_only prevents table creation and drop operations for all storage engines. You can query InnoDB tables where the MySQL data directory is on read-only ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating system. To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
Dropping and re-adding an index can be expensive for a large table, whereas making it invisible and visible are fast, in-place operations. MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
For example, in the following statement, IF EXISTS is optional: DROP TABLE [IF EXISTS] tbl_name When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars (“|”). This is the Reference Manual for ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-general-info.html
A mysqld compiled without NDB support (that is, built without -DWITH_NDB or -DWITH_NDBCLUSTER_STORAGE_ENGINE) cannot function as a drop-in replacement for a mysqld that is built with it. MySQL NDB Cluster uses the MySQL server with the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
Table 25.33 Events relating to NDB Cluster schema operations Event Priority Severity Level Description CreateSchemaObject 8 INFO Schema objected created AlterSchemaObject 8 INFO Schema object updated DropSchemaObject 8 INFO Schema object dropped ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB Cluster”. These log messages also correspond to log ...