How to cancel a long-running tabulation manually, using MySQL Control Center?

If a tabulations job runs longer than the expected time, you can manually cancel the tabulations, using MySQL Control Center or using pure SQL.

Procedure

To cancel a tabulation manually, using MySQL Control Center, complete the following steps:

  1. Connect to the MySQL server using the MySQL Control Center.
  2. Right-click the Server Administration (located below all of the databases for the server), and then select the SHOW PROCESSLIST option.
  3. Locate the process that is related to the tabulations. To identify the tabulations process easily, consider the following points:
    • If PlinthOS is configured for a single worker, there should be only one Tabulation process.
    • The process will be interacting with various tabulations_<something> tables.
    • The majority of the queries for Tabulation start with INSERT and also contain SELECT <CrossTab ID>
  4. In the left column under ID, select the check box for the Tabulation process.
  5. On the toolbar, click Kill Process. Now the Tabulation is canceled, and the status of the Tabulation is set to FAILED.
Parent topic: Frequently Asked Questions

How to cancel a tabulation manually, using pure SQL

If a tabulations job runs longer than the expected time, you can manually cancel the tabulations, using MySQL Control Center or using pure SQL.

Procedure

To cancel a Tabulation manually, using pure SQL, complete the following steps:

  1. Log on to the MySQL Sever.
  2. Issue the query: SHOW FULL PROCESSLIST
  3. Identify the Tabulation process as described in step 3 of the previous procedure.
  4. Note the ID number of the Tabulation. This appears in the first column.
  5. Issue the query: KILL <D number>

Results

Now the Tabulation is canceled, and the status of the Tabulation is set to FAILED.