Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
How does the Thread Pool limit and manage concurrent sessions and transactions for optimal performance and throughput? A.15.3. How does the Thread Pool limit and manage concurrent sessions and transactions for optimal performance and throughput? The ...What is the Thread Pool and what problem does it solve? ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Implements SQL functions using a highly optimized class library that should be as fast as possible. An EXPLAIN statement to show how the optimizer resolves a query. MySQL Server has built-in support for SQL statements to check, optimize, and repair ... This section describes some of the important characteristics of the MySQL Database ...
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 ...