Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
For example, consider the following statements with no explicit BEGIN, session.startTransaction() or similar call: session.setSavepoint('testsavepoint'); session.releaseSavepoint('testsavepoint'); If autocommit mode is enabled on the server, these ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
If you encounter out of memory errors when running a query, try running the query with the MIN_MEM_CONSUMPTION strategy by setting by setting rapid_execution_strategy prior to executing the query: SET SESSION rapid_execution_strategy = ...Most MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using Incremental Load”. This adds an include list to exactly specify the tables and columns to load for a set ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
Set to false to disable truncation and instead throw an error when a text segment that is too large for the embeeding model is found. In this case, the entire load fails and exits with an error. This section describes how to generate vector ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
Setting use_secondary_engine=FORCED does not cause the statement to fail with an error. If you set use_secondary_engine=FORCED, the operation fails and generates an offload error. This topic describes how to run a SELECT query and insert the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Before MySQL 9.0.1-u1, the limit for the Lakehouse error message count is 100. MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
If MySQL HeatWave execution is not possible for a query due to unsupported syntax or any other reason as mentioned in Diagnose Query Offload, the query is executed by the "DB System", and no errors are generated. If the query is not supported by ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
To determine why a query is not offload, refer to Diagnose Query Offload Errors or MySQL HeatWave Issues to diagnose and resolve the offloading error. This topic describes how to use the EXPLAIN statement to analyze query execution and verify ...