Search Results
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
The following subqueries are transformed into antijoins: NOT IN (SELECT ... For more information about materialization, see Section 10.2.2.2, “Optimizing Subqueries with Materialization”. This affects queries that use the STRAIGHT_JOIN modifier ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.1 (2018-07-24)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-1.html
This resulted in an error and no new queries were displayed on the Query Analyzer. Functionality Added or Changed Bugs Fixed Functionality Added or Changed The usability of the Context and Target selection fields has been improved. As of this ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
Any changes made to the data in the DB System are automatically propagated to MySQL HeatWave Cluster, ensuring that queries always access the most up-to-date information. Figure 1.2 MySQL HeatWave Massively Parallel Architecture Push-Based ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The AUDIT_ABORT_EXEMPT privilege is available to permit a user account’s queries to always be executed even if an abort item would block them. Table 8.40 audit_log_policy_value Values Value Corresponding audit_log_policy Value 0 or "::none" NONE 1 ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-train.html
Run the ML_TRAIN routine on a training dataset to produce a trained machine learning model. Before training models, make sure to review the following: Additional AutoML Requirements Supported Data Types for AutoML Train a Model Machine Learning Use ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by default. If the routine cannot find a vector store, then it calls the ML_GENERATE routine and uses ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag.html
The ML_RAG routine performs retrieval-augmented generation (RAG) by: Taking a natural-language query. This routine aims to provide detailed, accurate, and contextually relevant answers by augmenting a generative model with information retrieved ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. schemas: specifies the databases to consider for generating and running SQL queries. tables: specifies the tables to consider for ...The routine also runs the generated SQL statement and displays the result ...