Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-savepoints.html
X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert to. By setting savepoints within a transaction, you can later use the rollback functionality to undo any statements issued after setting ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert to. By setting savepoints within a transaction, you can later use the rollback functionality to undo any statements issued after setting ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
Most MySQL HeatWave variable settings are managed by OCI and cannot be modified directly. bulk_loader.data_memory_size Command-Line Format --bulk_loader.data_memory_size=# System Variable bulk_loader.data_memory_size Scope Global Dynamic Yes SET_VAR ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Data placement keys are used to partition table data among MySQL HeatWave nodes when loading tables. Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and privileges.
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() Bit functions and operators. Rewrite queries that use named time zones with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel Table Import Utility, manually loading data into MySQL HeatWave Cluster, and running queries. This quickstart contains the following sections: ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-recommendation-model-types.html
You can create recommendation models based on either explicit or implicit feedback. See Recommendation Models to review models that support either implicit or explicit feedback. Recommendation Models with Explicit Feedback Recommendation models ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-1-0-u2.html
MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML progress tracking can now track the progress with finer granularity, and show the overall progress as well as the progress of subcomponents, see: Track ...