If you kill the process in the middle of huge alter. It will take some time to
reverse them back. It will be fast if you have good memory.
Thanks,
Saravanan
--- On Wed, 6/11/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
From: Ananda Kumar <[EMAIL PROTECTED]>
Subject: kill process id.
To: "mysql" <mysql@lists.mysql.com>
Date: Wednesday, June 11, 2008, 6:05 PM
Hi All,
I killed a process with
kill <process id>;
This processid i got from show processlist.
But the process is in KILLED state for long time, is there a way to kill it
instantaneously.
Below is the job i have killed, as it started doing REPAIR BY KEYCACHE
Alter Table ebay_research_temp enable keys Repair with keycache
please let me know.
regards
anandkl
