Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
Autopilot Indexing obtains workloads from the statement digest history stored in the Performance Schema, evaluates them, and identifies potential indexes that can help improve workload performance. Indexes can improve the query performance of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-kill.html
The kill_app_task routine kills an active or scheduled task using its task ID. 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-list.html
The app_task_list routine returns a paginated list of asynchronous tasks associated with an application user. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_list( 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-brief.html
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 entry. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> ...
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-apptask.html
The app_task routine returns information about a single application task. 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' ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The execute_prepared_stmt_from_app_async routine creates an asynchronous task associated with a specific application user. Application-level asynchronous task lets you filter and track tasks for individual application users using an ...
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' ...