Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
The use_secondary_engine variable can be set as shown: Using a SET statement before running queries: mysql> SET SESSION use_secondary_engine = FORCED; Using a SET_VAR optimizer hint when issuing a query: mysql> SELECT /*+ ... This topic describes ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
The output looks similar to the following: | { "text": " AutoML is a machine learning technique that uses algorithms to automatically generate and optimize models for specific tasks, without the need for manual intervention. It involves using ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching values”. When the optimizer can make use of partition pruning in performing ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
It involves using algorithms and techniques to automatically identify the best model for a given dataset and optimize its hyperparameters without requiring manual intervention from data analysts or ML practitioners. The source data is read from ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
--ndb-optimization-delay=milliseconds Command-Line Format --ndb-optimization-delay=# System Variable ndb_optimization_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum Value 0 Maximum Value 100000 Unit ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
Users must have this privilege to execute OPTIMIZE LOCAL TABLE and OPTIMIZE NO_WRITE_TO_BINLOG TABLE statements. When upgrading from a previous release series, users having the SYSTEM_USER privilege are automatically granted the OPTIMIZE_LOCAL_TABLE ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
If the select attempt occurs within a derived table, you can avoid this error by setting the derived_merge flag of the optimizer_switch system variable to force the subquery to be materialized into a temporary table, which effectively causes it to ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/internals/en/system-variables-controlling-trace.html
A brief overview from "mysqld --verbose --help": --optimizer-trace=name Controls tracing of the Optimizer: --optimizer-trace-features=name Enables/disables tracing of selected features of the Optimizer: ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
When EXPLAIN is used with an explainable statement, MySQL displays information from the optimizer about the statement execution plan. TREE provides tree-like output with more precise descriptions of query handling than the TRADITIONAL format; it is ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
The optimizer takes into account the primary key columns of the extended secondary index when determining how and whether to use that index. The optimizer can use extended secondary indexes for ref, range, and index_merge index access, for Loose ...