Search Results
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made faster. It is theoretically possible to use partition pruning to improve concurrency by placing locks ...With non-transactional tables such as MyISAM, locks are placed on entire partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
This in turn enables the server to use that basedir when searching for server-related information such as the share directory containing error messages. Note This must be the first option on the command line if it is used, except that if the server ...The best way to ensure this is to list them in an option ... When you start the mysqld server, you can specify program options using any of the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-manual-editing.html
Migration Problems: This either reports problems or displays "No mapping problems found." As the following figure shows, this is an informational screen. Figure 10.57 MySQL Workbench migration: Manual Editing (Migration Problems) All Objects: An ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-byo-embedding-tables.html
GenAI lets you use tables containing your own vector embedding to run retrieval-augmented generation (RAG) with vector search. For example: mysql> ALTER TABLE demo_minilm_table SECONDARY_LOAD; This accelerates processing of vector distance function ...The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as filters for finding relevant tables for context ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
NdbOperation::equal() Description This method defines a search condition with an equality. This is the operation that is to be performed by an interpreted program; the interpreted program itself is assembled from various register, comparison, and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-mysql-instances-filtering.html
Figure 16.4 MySQL Instance Filter Table 16.8 MySQL Instance Filter Name Description Server Name Search on full or partial name of the server. Query Analyzer Search for servers on which the Query Analyzer is enabled, or not. Agent Version Search for ...For information on the named filters, see Section 14.3.5, “System and User-defined ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. These options cause ndb_blob_tool to check for orphaned BLOB parts, remove any orphaned BLOB parts, ...It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB or TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-config.html
This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf file. The dump can be produced in either text or XML format; ...By default, the management node is the source for the configuration data; to override the default, execute ndb_config with the --config-file or --mycnf ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. --ndb-nodeid Command-Line ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc are listed later in this section. For information about interpreting ... ndb_desc provides a detailed description of one or more NDB ...