Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-requirements.html
The prepared XA transaction can be committed or rolled back by another connection, and the current session can then initiate another XA transaction or local transaction without waiting for the transaction that was just prepared to complete.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-rejoin.html
The events_stages_summary_global_by_event_name table shows the number of times the server instance has initiated the auto-rejoin procedure (in the COUNT_STAR column). The group_replication_autorejoin_tries system variable makes a member that has ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, “Server-Side Help Support”). HELP 'search_string' The HELP statement returns online information from the ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
Initially, the host name is set to NULL and the flag is false. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The Performance Schema host_cache table exposes ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
The initial parts of a multiple-part name act as qualifiers that affect the context within which to interpret the final identifier. An unqualified name is permitted in contexts where interpretation of the name is unambiguous. A qualified name ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to initialize the pattern for the string and then uses this pattern to perform the search more quickly. Understanding the B-tree and hash data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
For character columns in multibyte character sets, this length value is the maximum length in bytes needed to represent a definition such as VARCHAR(N); that is, it might be 2*N, 3*N, and so on depending on the character encoding. DEFAULT_VALUE The ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-being-deleted-table.html
The INNODB_FT_BEING_DELETED table provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. 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 contains ...