Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
For Group Replication, note the following key points and differences: The donor (an existing group member) and the recipient (the joining member) must have the clone plugin installed and active. Note that remote cloning operations use the server's ... If you want to use remote cloning operations for distributed recovery in a group, you must set up existing members and joining members beforehand to support this ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
Note If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. Refer to the notes at the end of this section for information regarding other ...The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits frequently used data to be accessed directly from memory, which speeds up processing. On dedicated servers, up to 80% of ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
Note MySQL supports regular expression patterns in JSON schema, which supports but silently ignores invalid patterns (see the description of JSON_SCHEMA_VALID() for an example). MySQL supports validation of JSON documents against JSON schemas ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
Note This discussion uses JSON in monotype to indicate specifically the JSON data type and “JSON” in regular font to indicate JSON data in general. | +-----------------------------------------+ Note The previous example does not work as shown if ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
Note For a discussion of MySQL server options for NDB Cluster, see Section 25.4.3.9.1, “MySQL Server Options for NDB Cluster”. (Bug #45921) Note This parameter can be overridden using the NDB API. Note To add new SQL or API nodes to the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
Note NDB Cluster never saves the user-furnished password or generated encryption key. Note If you use the SNAPSHOTSTART option with START BACKUP, and the CompressedBackup parameter is enabled, only the data and control files are compressed—the log ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html
Note A unique index update operation can generate multiple PK read and write operations on the index table and on the base table. Note A single transaction may operate on data stored in multiple LQH blocks. The NDB management client's CLUSTERLOG ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-definition.html
Note If neither the ExecuteOnComputer nor the HostName parameter is present, the default value localhost is assumed for both. Note Not every facility is necessarily supported by every operating system. Note After making changes in a management ...