Search Results
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-kill.html
The kill_task routine terminates an active or scheduled task using its task ID. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> CALL mysql_tasks.kill_task(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR(36)) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-logs.html
The task_logs routine returns a list of logs associated with a task. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_logs( IN 'task_id' VARCHAR(36), IN 'newer_than_log_time' ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-brief.html
The task_status_brief routine returns the brief status of a task, including a subset of information about the task and its last log entry. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task_status(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR 36) parameter specifies the unique task ID (UUID) of the task whose information ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.task(IN 'task_id' VARCHAR(36)); The task_id (VARCHAR(36)) parameter specifies the unique task ID (UUID) of the task whose information is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
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 new query shares query execution plan nodes with previously executed queries, the statistics ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
This topic describes how to prepare your data for loading into MySQL HeatWave. Prepare Data Before loading data, ensure that you meet the following requirements: The tables you intend to load must be set to ENGINE=InnoDB tables. You can manually ...