Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
All these properties are key to creating a system which ensures that data is consistently replicated across the group of servers. The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
For Group Replication, note the following key points and differences: The donor (an existing group member) and the recipient (the joining member) must have the clone plugin installed and active. The donor and the recipient must have the Group ... If ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
Some key issues that can require administrator intervention are when a member is in ERROR status and cannot rejoin the group, or when a network partition causes the group to lose quorum. Group Replication is designed to create fault-tolerant ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
To employ the HANDLER interface to refer to a table's PRIMARY KEY, use the quoted identifier `PRIMARY`: HANDLER tbl_name READ `PRIMARY` ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } ...
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
ibd2sdi --dump-file=file_name ../data/test/t1.ibd --skip-data, -s Command-Line Format --skip-data Type Boolean Default Value false Skips retrieval of data field values from the serialized dictionary information (SDI) and only retrieves the id and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
Example mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G *************************** 1. The INNODB_TEMP_TABLE_INFO table provides information about user-created ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
For ANALYZE TABLE operations that update the key distribution, failure may occur even if the operation updates the table itself (for example, if it is a MyISAM table). The information_schema_stats_expiry system variable defines the period of time ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-adaptive-hash.html
Based on the observed pattern of searches, a hash index is built using a prefix of the index key. The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient ...