Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
Syntax Examples for Recommendation Training The following example defines a model handle, trains a recommendation model with no specified model type, and then queries the automatically selected model_type for the trained model from the model catalog. Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
If the WHERE clause contains range predicates (see the discussion of the range join type in Section 10.8.1, “Optimizing Queries with EXPLAIN”), a Loose Index Scan looks up the first key of each group that satisfies the range conditions, and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
In MySQL 8.4, index dive skipping is possible for queries that satisfy all these conditions: The query is for a single table, not a join on multiple tables. Range Optimization of Row Constructor Expressions The optimizer is able to apply the range ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
At the beginning of subqueries (including derived table subqueries): SELECT ... This is useful for queries that perform transitive closures, to avoid infinite loops. For queries that execute and thus recurse slowly or in contexts for which there is ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
Now, execute your other queries and then refresh the pinned tab (there is a "refresh" icon in the result grid's menu). How do I proceed? By default, Workbench is configured to not execute DELETE or UPDATE queries that do not include a WHERE clause ... FAQ Categories Basic Usage MySQL Workbench Functionality Data Management General Basic Usage ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-internal-error.html
The following list enumerates all NDB errors of type IE (Internal error). The index needs to be dropped and recreated NDB error code 914 MySQL error DMEC Error message Invalid index stats request NDB error code 916 MySQL error DMEC Error message ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in parallel. embed_model_id: specifies the embedding model to use for embedding the input queries. If you are providing the query embeddings, then set ...The output generated for every input query is the same as the output generated by the ML_RAG ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. This is useful when you want to log some queries to a file, but not others. mysql sends each SQL statement that you ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
If you use statement-based or mixed binary logging format, do not use cross-database queries, and do not specify database names in queries. For both DDL and DML statements, rely on the USE statement to specify the current database, and use only the ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...