PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/performance-schema-clone-progress-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_progress table shows progress information for the current or last executed cloning operation only. The table therefore only ever contains seven rows of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-status-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.17. The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains one row of data, or is empty. The ...PID ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table (available as of MySQL 8.0.24) 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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-keys-table.html
As of MySQL 8.0.16, the keyring_keys table exposes metadata for keys in the keyring. 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 ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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 ...