Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
The information in this section is to help you configure a replication group to optimize the automatic handling of any recurring issues that you experience on your particular systems, such as transient network outages or workloads and transactions ... Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
ANALYZE TABLE, CACHE INDEX, CHECK TABLE, FLUSH, LOAD INDEX INTO CACHE, OPTIMIZE TABLE, REPAIR TABLE, RESET (but not RESET PERSIST). The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-statistics-table.html
For information about histogram statistics, see Section 10.9.6, “Optimizer Statistics”, and Section 15.7.3.1, “ANALYZE TABLE Statement”. The COLUMN_STATISTICS table provides access to histogram statistics for column values. You can see ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run stops. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------------------+ | ... The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
When a table with instantly added or dropped columns is rebuilt due to a table-rebuilding ALTER TABLE or OPTIMIZE TABLE operation, the value is reset to 0. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablestats-table.html
This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This information is derived from in-memory data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
It does not provide information about internal InnoDB temporary tables used by the optimizer. The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact. Each row in this table corresponds to an individual partition or subpartition of a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...