Bug #9730 CHECK TABLE is not killable for Innodb tables

Submitted: 7 Apr 2005 20:29 Modified: 12 Jul 2005 8:06
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:all OS:
Assigned to: Marko Mäkelä CPU Architecture:Any

[7 Apr 2005 20:29] Peter Zaitsev 
Description:
CHECK TABLE is not killable when  is run on Innodb table. 

How to repeat:
Run CHECK TABLE on large Innodb table and try to kill it.
[7 Apr 2005 21:04] Heikki Tuuri 
Hi!

We should monitor thd->killed.

Regards,

Heikki
[8 Apr 2005 10:33] Marko Mäkelä 
I'm currently testing a fix. It would check the flag for every B-tree level being validated, and every 1,000 records being fetched, that is, every 10-20 seconds on typical hardware.
[20 Apr 2005 15:28] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24169
[12 Jul 2005 8:06] Marko Mäkelä 
Fixed in MySQL 5.0.9.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.