Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional ...On the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-instances-table.html
The file_instances table lists all the files seen by the Performance Schema when executing file I/O instrumentation. When a file is deleted from the disk, it is also removed from the file_instances table. The file_instances table has these indexes: ...If a file on disk has never been opened, it is not shown in ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the keyring is not being used, or is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-keys-table.html
The keyring_keys table does not expose any sensitive keyring data such as key contents. MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. Key metadata ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-communication-information-table.html
This table shows group configuration options for the whole replication group. The replication_group_communication_information table has these columns: WRITE_CONCURRENCY The maximum number of consensus instances that the group can execute in ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-configuration-version-table.html
This table displays the version of the member actions configuration for replication group members. The replication_group_configuration_version table has these columns: NAME The name of the configuration. Whenever a member action is enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-actions-table.html
This table lists the member actions that are included in the member actions configuration for replication group members. The replication_group_member_actions table has these columns: NAME The name of the member action. You can reset the member ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. The rwlock_instances table has these columns: NAME The instrument name associated with the lock. The ...An rwlock ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 7.6.3, “MySQL Enterprise Thread Pool”). The Performance Schema thread pool tables are implemented by the thread pool plugin and ...