Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Indexes can improve the query performance of SELECT statements, but index management can increase the overhead of DML operations, INSERT, UPDATE, and DELETE. Autopilot Indexing obtains workloads from the statement digest history stored in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-kill.html
Syntax mysql> SELECT mysql_tasks.kill_app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36); Following are kill_app_task parameters: app_user_id (VARCHAR(255)): specifies the unique ID of the application user who owns the task. Syntax ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-list.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_list( IN 'app_user_id' VARCHAR(255), IN 'task_type' VARCHAR(80), IN offset IN UNSIGNED, IN limit INT UNSIGNED); Following are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-logs.html
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 'task_id' VARCHAR(36), IN 'newer_than_log_time' TIMESTAMP(6)); Following are app_task_logs ... The app_task_logs routine returns a list of logs associated with an application-level ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-brief.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_status_brief( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36)); Following are app_task_status_brief parameters: app_user_id ... The app_task_status_brief routine returns the brief status of an application task, including a subset of information about the task and its last log ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-status-list.html
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), IN 'task_type' VARCHAR(90), IN offset INT UNSIGNED, IN limit INT UNSIGNED); Following ...
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 ...task_id ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36)); Following are app_task parameters: app_user_id (VARCHAR(255)): specifies ... The app_task routine returns information about a single application ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The second statement SELECT JSON_OBJECT("Task result", "Finished...") into @task_result generates an output that is stored in the reserved session variable @task_result. The execute_prepared_stmt_from_app_async routine creates an asynchronous task ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-logs.html
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' TIMESTAMP(6)); Following are task_logs parameters: task_id (VARCHAR(36)): ...