Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
Every document has a unique identifier called the document ID, which can be thought of as the equivalent of a table's primary key. This section describes what a document ID is and how to work with it. The document ID value is usually automatically ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. res = mySession.sql('SELECT name, age FROM users').execute() row ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
The vector store tables created with MySQL HeatWave GenAI also persist in the block storage. MySQL HeatWave is a fully-managed cloud service that enables organizations to efficiently run analytics, transactional processing, machine learning, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
The mysql_tasks.config table stores the following key values that are used to define maximum task limits: The limits.maximumPreparedStmtAsyncTasks key specifies the maximum number of SQL statements that can run concurrently within the MySQL HeatWave ... As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
A query execution plan may have nodes for table scans, JOIN, GROUP BY and other operations. The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . CAST() from and to all the MySQL HeatWave supported numeric, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dynamic-query-offload.html
Before MySQL 9.0.0, MySQL HeatWave uses a query cost threshold to choose either INNODB or MySQL HeatWave as the execution engine for the query. As of MySQL 9.0.0, MySQL HeatWave uses dynamic query offload to choose the optimal execution engine for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
This helps improves the document parsing quality by extracting complex structures like tables, and enhances RAG as well as vector search queries. This section describes the Vector Store functionality available in MySQL HeatWave. About Vector Store ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-data-recovery.html
In the event of a problem where query processing stops or the MySQL HeatWave Cluster stops, the external tables are recovered when the Cluster resumes and begins processing queries again using the MySQL HeatWave recovery process. See the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
It also displays the latest query results from the query text from the performance_schema.rpd_query_stats table and retrieves all the MySQL statements currently being executed in all MySQL active connections on the network. The pre-authenticated ...