Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. For an example specific to full-text indexing, see Section 14.9.7, “Adding a User-Defined Collation for Full-Text ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
In this example, we set a user variable @schema to the value of a JSON schema for geographical coordinates, and another one @document to the value of a JSON document containing one such coordinate. In this example, we set a user variable @schema to ... MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
The collation is designed for a scenario involving a Web application for which users post their names and phone numbers. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row ...If, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
tmp_tables The number of internal in-memory temporary tables created by the current statement. tmp_disk_tables The number of internal on-disk temporary tables created by the current statement. The MySQL process list indicates the operations ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/preface.html
GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle ... This document contains release notes for the changes in MySQL ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
When performing ALTER TABLE operations, mysqld creates intermediate tables (whose names are prefixed with #sql-). When managing NDB Cluster 8.0.19 and later, the restore cluster command does not restore shared users and grants to the ...Stop the ...