||Table options are part of table editing|
|With this module you can change the settings for MySQL tables.|
||Goes to this page and displays information about the option|
||Saves the changes to the table|
|DELAY_KEY_WRITE (Delayed writing of the indexes)|
Determines whether the index updates for the table should not be written until the table is closed.
|KEY_BLOCK_SIZE (Index block size)|
Specifies the index block size in bytes for MyISAM tables. The given size is a guideline. A different size can be used if necessary.
|PACK_KEYS (Index compression)|
For MyISAM tables. Compresses indexes, which typically makes updates slower and reads on the table faster.
|ENGINE_ATTRIBUTE (Engine attribute)|
Available to specify column attributes for primary storage engines. The options are reserved for future SQL Server versions.
|SECONDARY_ENGINE_ATTRIBUTE (Second engine attribute)|
Available to specify column attributes for secondary storage engines. The options are reserved for future SQL Server versions.
Generates a live checksum for all table rows when the table changes. This will make the table update a bit slower, but it will make it easier to find corrupted tables
The compression algorithm for InnoDB tables can be specified here: Zlib / LZ4 / None.
|ENCRYPTION (Table encryption)|
Enables or disables data encryption for InnoDB tables. An encryption plugin must be installed and configured before encryption can be enabled.
|ENCRYPTION_KEY_ID (Encryption key)|
For MariaDB: Defines the identifier for the encryption type to be used.
The connection string for FEDERATED tables.
This option is not used.
|AUTOEXTEND_SIZE (Automatic table enlargement)|
Defines the size by which InnoDB tables expand their memory when they need to grow. The setting is a multiple of 4 MB. The default is 0, which increases table memory by default.
|MIN_ROWS (Minimum number of rows)|
The minimum number of data rows to store in the table. The value is used as an indication of minimum memory usage.
|MAX_ROWS (Maximum number of rows)|
Specifies the likely maximum number of table rows to be stored in the table partition. The value is used as an indication of the maximum memory usage.
|AVG_ROW_LENGTH (Average row length)|
An approximation of the average row length for tables. Can be set for large tables with variable row length.
|DATA DIRECTORY (Data directory)|
Allows creating table data outside of the standard data directory. The full directory path must be specified.
|INDEX DIRECTORY (Index directory)|
Allows index data to be created outside of the default data directory. The full directory path must be specified.
|TABLESPACE (Table storage)|
Can be used to create a table in an existing table space, a file-per-table table space, or the system table space.
|STORAGE (Table storage type)|
This table option is only used with NDB tables and determines the storage type used (disk or memory) DISK / MEMORY.
|INSERT_METHOD (Insertion option for MERGE tables)|
When inserting data into a MERGE table, you can define here where the data should be inserted. Can be selected: NO / FIRST / LAST.
|STATS_PERSISTENT (Persistent InnoDB statistics)|
Enables persistent statistics for InnoDB tables.
|STATS_AUTO_RECALC (Recalculate InnoDB persistent statistics automatically)|
Persistent statistics for InnoDB tables are automatically recalculated.
|STATS_SAMPLE_PAGES (Number of index pages to be captured)|
Specifies the number of index pages to sample when estimating cardinality and other statistics for indexed columns.