Search Results
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-group-by-modifiers.html
(Available in MySQL HeatWave only.) A ROLLUP modifier as a preferred alternative to the WITH ROLLUP modifier. In the MySQL HeatWave secondary engine, the GROUP BY clause permits the following modifiers: A CUBE modifier in addition to the WITH ...
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 statments currently being executed in all MySQL active connections on the network. The pre-authenticated ...