Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
To use this feature, define data placement keys on the most frequently used JOIN keys and the keys of the longest running queries. Tip For data placement key recommendations, use MySQL HeatWave Autopilot Advisor after loading tables into MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
Subqueries, parameters, variables, stored functions, and loadable functions are not permitted. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
Searches are specified as before, with no changes needed for queries. The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using the GenAI feature of MySQL AI: Before You Begin Generating Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
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 query). The following discussion uses ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Only run Advisor on multiple schemas if the queries access tables in multiple schemas. exclude_query: Defines the IDs of queries to exclude when Advisor analyzes query statistics. query_insights: Provides runtime information for successfully ...
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 ...