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-status-variables.html
Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last started. The counter is reset to 0 when the MySQL HeatWave Cluster is restarted (when the rapid_bootstrap state changes from OFF or IDLE ...
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-async-add-task-log.html
The add_task_log routine add a log entry for the task with the specified ID. You can use this routine with an application-level task as well and it does not require an application-managed user ID. Syntax mysql> CALL mysql_tasks.add_task_log( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-logs.html
The app_task_logs routine returns a list of logs associated with an application-level task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_logs( IN 'app_user_id' VARCHAR(255), IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-list.html
The app_task_status_list routine returns a paginated list of application task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status_list( IN 'app_user_id' VARCHAR(255), ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR (36); Following are app_task_status parameters: app_user_id ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
The execute_prepared_stmt_async routine creates a task that executes SQL statements asynchronously within an event stored in the schema_name schema. schema_name (VARCHAR(255)): specifies the schema to run the given SQL statements. If the schema is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue without waiting for these SQL statements or tasks to complete. It is particularly helpful for long-running ...