Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
It is also possible to create an index on a JSON column using the JSON_VALUE() function with an expression that can be used to optimize queries employing the expression. A secondary index defined on a virtual column is sometimes referred to as a ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
For more information, see Section 27.5.2, “View Processing Algorithms”, as well as Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”. If the view does not exist, ...
https://dev.mysql.com/doc/refman/8.4/en/end-markers-in-json-system-variable.html
This variable affects both optimizer traces and the output of EXPLAIN FORMAT=JSON. When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's ...
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
If you use myisamchk for write operations such as repairing or optimizing tables, or if you use myisampack to pack tables, you must always ensure that the mysqld server is not using the table. External locking is the use of file system locking to ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
The optimization occurs because the query sent to the remote server includes the contents of the WHERE clause and is sent to the remote server and subsequently executed locally. To create a FEDERATED table you should follow these steps: Create the ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE statement. This section describes how MySQL responds to disk-full errors (such ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-query-expansion.html
| | 3 | Optimizing MySQL | In this tutorial we show ... Full-text search supports query expansion (and in particular, its variant “blind query expansion”). This is generally useful when a search phrase is too short, which often means that the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
Group Replication is based on an optimistic replication paradigm, where statements are optimistically executed and rolled back later if necessary. 20.1.3.2.3 Version Compatibility For optimal compatibility and performance, all members of a group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of Group Replication. Group Replication is versioned according to the MySQL Server version that the Group Replication plugin ...