Search Results
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
If corruption within the table data prevents you from dumping the entire table contents, a query with an ORDER BY primary_key DESC clause might be able to dump the portion of the table after the corrupted part. If a high innodb_force_recovery value ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
<collation name="latin1_fulltext_ci" id="1025"/> </charset> Declare the sort order for the collation in the latin1.xml file. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
For a transaction to commit, the majority of the group have to agree on the order of a given transaction in the global sequence of transactions. These provide a failure detection mechanism, a group membership service, and safe and completely ordered ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
The second member joining the group needs to ask the member that bootstrapped the group to dynamically change the configuration in order for it to be added to the group. Why does Group Replication use two bind addresses? Group Replication uses two ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
A joining member must have its initial connection to the group permitted by the allowlist in order to retrieve the address or addresses for distributed recovery. Note It is possible to configure different allowlists on different group members ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
While you are in the process of upgrading an online group, in order to maximize availability, you might need to have members with different MySQL Server versions running at the same time. Depending on your group, the effects of these policies might ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
The optimizer cannot use a hash index to speed up ORDER BY operations. (This type of index cannot be used to search for the next entry in order.) MySQL cannot determine approximately how many rows there are between two values (this is used by the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
PARTITION_ORDINAL_POSITION All partitions are indexed in the same order as they are defined, with 1 being the number assigned to the first partition. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-profiling-table.html
SEQ A sequence number indicating the display order for rows with the same QUERY_ID value. For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 WITH CHECK OPTION; Then the view definition looks like this: SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 CHECK_OPTION The value of the ...You ...