Skip to main content

KILL ANALYZE

KILL ANALYZE

Description

Cancels a running collection task, including manual and custom automatic tasks.

This statement is supported from v2.4.

Syntax

KILL ANALYZE <ID>

The task ID for a manual collection task can be obtained from SHOW ANALYZE STATUS. The task ID for a custom collection task can be obtained from SHOW ANALYZE SHOW ANALYZE JOB.

References

For more information about collecting statistics for CBO, see Gather statistics for CBO.