Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. MATCH (col1,col2,...) AGAINST (expr ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
You can obtain the CREATE TABLE statement necessary to create an existing table using the SHOW CREATE TABLE statement. What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are ...
https://dev.mysql.com/doc/refman/8.4/en/gis-geometry-class-hierarchy.html
The instantiable subclasses of Geometry are restricted to zero-, one-, and two-dimensional geometric objects that exist in two-dimensional coordinate space. The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
Assume that referential integrity has been accidentally broken and there exists a row of countrylanguage without a corresponding row in country. The following discussion provides several examples of the ways in which MySQL detects functional ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
If a standard source-to-replica replication channel is running on the existing primary member in addition to the Group Replication channels, you must stop that replication channel before you can change the primary member. This section explains how ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-upgrade.html
Important Setting group_replication_allow_local_lower_version_join to ON does not make the new member compatible with the group; doing this allows it to join the group without any safeguards against incompatible behaviors by the existing members.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
For example, on Linux distributions that use systemd: s3> systemctl stop mysqld Preserve the two configuration files in the corrupted server's data directory, auto.cnf and mysqld-auto.cnf (if it exists), by copying them to a safe location outside of ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
For example, Group Replication's distributed recovery process creates a connection to an existing group member using the server's hostname and port. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-gtids.html
Extra Transactions If a joining member has transactions in its GTID set that are not present on the existing members of the group, it is not allowed to complete the distributed recovery process, and cannot join the group. Group Replication uses ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Limit on Group Size Limits on Transaction Size The following known limitations exist for Group Replication. Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a ...