Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
| | 3 | Optimizing MySQL | In this tutorial, we show ... | 0.7405621409416199 | | 3 | Optimizing Your Database | In this database tutorial ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-deleted-table.html
This value is used when you perform text searches, to skip rows in the INNODB_FT_INDEX_TABLE table before data for deleted rows is physically removed from the FULLTEXT index by an OPTIMIZE TABLE statement. The INNODB_FT_DELETED table stores rows ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-table-table.html
This is accomplished by running an OPTIMIZE TABLE operation on the indexed table with the innodb_optimize_fulltext_only system variable enabled. The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
The optimizer can perform a partial, in-place update of a JSON column instead of removing the old document and writing the new document in its entirety to the column. This optimization can be performed for an update statement that uses the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
If separate single-column indexes exist on col1 and col2, the optimizer attempts to use the Index Merge optimization (see Section 10.2.1.3, “Index Merge Optimization”), or attempts to find the most restrictive index by deciding which index ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-delete-all.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c connection_string ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. It is recommended that you use this utility only as an example for writing NDB API applications—see the ...