Search Results
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...
https://dev.mysql.com/doc/refman/8.4/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-communication.html
To check the group's communication protocol version, issue the following statement on any member: SELECT @@version, group_replication_get_communication_protocol(); +------------------------------------------------------------+ | @@version | ... A ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
This section explains the configuration settings required for MySQL Server instances that you want to use for Group Replication. Storage Engines Replication Framework Group Replication Settings Storage Engines For Group Replication, data must be ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-online-group.html
To use the functions, connect to a member of the running group and invoke the function with the SELECT statement. You can configure an online group while Group Replication is running by using a set of functions, which rely on a group action ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery.html
Group Replication automatically selects the best combination of these methods for state transfer after you issue START GROUP_REPLICATION on the joining member. Whenever a member joins or rejoins a replication group, it must catch up with the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
Example: SELECT group_replication_set_as_primary(‘00371d66-3c45-11ea-804b-080027337932’, 300); This function waits for all ongoing transactions and DML operations to finish before electing the new primary. The following function enables you to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-observability.html
For example, you can connect to a single server in the group and obtain both local and global information by issuing select statements on the Group Replication related Performance Schema tables. There is a lot of automation built into the Group ...