Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
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 ...