Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-find.html
The find(SearchConditionStr) function is for searching documents in a collection, similar to the SELECT statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that should be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
This topic contains the following sections: Before You Begin Load External Data Using Lakehouse Auto Parallel Load with a New Table Load External Data Using Lakehouse Auto Parallel Load with an Existing Table What's Next Before You Begin Complete ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
If set, the routine searches for vector store tables in this schema. 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. This topic contains the ...If the routine cannot find a vector store, then it calls the ML_GENERATE routine and uses information available in LLM training data, which is primarily information that is available in public data sources, to generate a response for the entered ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
This improves the query plan, and provides improved performance (WL #15995) MySQL HeatWave Autopilot now includes Auto Indexing Advisor that offers indexing suggestions to improve the performance and latency of OLTP workloads running on the MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-1.html
This update extends the search capabilities of the ML_RAG, ML_RAG_TABLE, and HEATWAVE_CHAT routines to include your own embedding tables. MySQL HeatWave GenAI MySQL HeatWave MySQL HeatWave GenAI Context search in MySQL HeatWave GenAI now lets you ...
https://dev.mysql.com/doc/heatwave-aws/en/database-vector-store.html
The in-database vector store enables the use of Retrieval Augmented Generation (RAG), allowing the LLMs to search proprietary data with appropriate context to provide more accurate and relevant answers. You can learn more about the MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Replica_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
Type "Mysql Release Engineering" into the search box and press Search. When the import dialog is displayed, choose Okay, and this certificate should now be listed under the Imported Certificates tab. This requires files for both the packaged file, ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
If you are unsure of what a reasonable value is for optimizer_search_depth, this variable can be set to 0 to tell the optimizer to determine the value automatically. Because the difference in performance between “good” and “bad” plans can be ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte ...