Hello Shachi, > I thought you always have to go to the physical location and delete > the tmp files manually. These are created in tmp folder. > > I am not sure if restarting helps...
since I am using InnoDB, there is no tmp folder. The Ibdata file after killing alter table commands: -rw-rw---- 1 mysql mysql 85G 2008-12-04 12:04 ibdata1 The Ibdata file before all alter table commands: -rw-rw---- 1 mysql mysql 60G 2008-12-03 18:04 ibdata1 Greets, Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]