Search Results
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. This is because when a server joins a replication group, it must make the initial ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
Figure 20.14 Losing Quorum To understand this type of network partition the following section describes a scenario where there are initially 5 servers working together correctly, and the changes that then happen to the group once only 2 servers are ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
Changing the lower_case_table_names setting after the server is initialized is prohibited. In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
Suppose that an account is granted roles as follows: GRANT 'r1', 'r2' TO 'u1'@'localhost'; SET DEFAULT ROLE ALL TO 'u1'@'localhost'; In sessions for u1, the initial CURRENT_ROLE() value names the default account roles. It may be used to time how ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
This means, for example, that the name of a data file created with ALTER TABLESPACE ts ADD DATAFILE 'data_2.dat' INITIAL SIZE 256M is shown as ./data_2.dat. INITIAL_SIZE For InnoDB: The initial size of the file in bytes. This is the same value that ... The FILES table provides information about the files in which MySQL tablespace data is ...
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-tablestats-table.html
ANALYZE TABLE clears table statistics and sets the STATS_INITIALIZED column to Uninitialized. STATS_INITIALIZED The value is Initialized if the statistics are already collected, Uninitialized if not. row *************************** TABLE_ID: 71 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
InnoDB sets an exclusive lock on the end of the index associated with the AUTO_INCREMENT column while initializing a previously specified AUTO_INCREMENT column on a table. InnoDB fetches the value of a previously initialized AUTO_INCREMENT column ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
If up-to-date statistics are required immediately, run ANALYZE TABLE to initiate a synchronous (foreground) recalculation of statistics. If you run ANALYZE TABLE to initiate a synchronous recalculation of statistics, the statement is replicated ...