Skip to main content
Version: 2.5

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​

SHOW ANALYZE STATUS

SHOW ANALYZE JOB

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