Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). For more ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
The following limitations are generally applicable to online DDL operations on large tables that involve rebuilding the table: There is no mechanism to pause an online DDL operation or to throttle I/O or CPU usage for an online DDL operation. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
Less disk space usage and I/O overhead than the table-copy method. The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Page Compression Limitations and Usage Notes Page compression is disabled if the file system block size (or compression unit size on Windows) * 2 > innodb_page_size. InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
In particular, the table locking involved with performing updates can slow down concurrent usage of MEMORY tables from multiple sessions. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ...