Is it OK to manually delete stray .ibd temporary file after crash?

[chris claydon]

I'm using InnoDb, file per table and mysql (5.0.45) crashed while building an index on a table.

Mysql recovered OK after a restart, except I'm now left with the following temporary files (or I assume they are) along with the table files in the folder for that database:
-rw-rw---- 1 mysql mysql 9728 Aug 7 13:29 #sql-1167_4c53f07.frm
-rw-rw---- 1 mysql mysql 7864320000 Aug 7 16:02 #sql-1167_4c53f07.ibd

Can I assume that mysql has forgotten all about them and delete them with the 'rm' command or is it more complicated? They are wasting nearly 8GB of disc space so I would really like to get rid of them!

From the timestamp on the files it is clear that mysql has not written to them since the crash, but maybe it still reads from them or needs them to exist? It would be a disaster if I had to restore this table from backup so I need to be sure it is safe before I delete them.

Many thanks for any help you can offer.

Chris



Edited 2 time(s). Last edit at 08/09/2008 06:50PM by chris claydon.