Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
Does the transportable tablespaces feature work with InnoDB data-at-rest encryption? A.17.12. How do I migrate data from a cleartext InnoDB tablespace to an encrypted InnoDB tablespace? A.17.1. It uses Electronic Codebook (ECB) block encryption mode ...Is data decrypted for users who are authorized to see it? ...
https://dev.mysql.com/doc/refman/8.4/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...Depending on how the data is distributed, the queries might perform less I/O and take up less cache memory because the relevant columns are packed together on ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-requirements.html
Convert any tables in other storage engines to use InnoDB before using the instance with Group Replication. Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
Each InnoDB table has a special index called the clustered index that stores row data. When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered index. If you do not define a PRIMARY KEY for a table, InnoDB uses the first UNIQUE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
If DML action is concentrated on a single table, purge operations for the table are performed by a single purge thread, which can result in slowed purge operations, increased purge lag, and increased tablespace file size if the DML operations ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
A standard installation of MySQL using the RPM packages result in files and resources created under the system directories, shown in the following table. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM ...