Hello,

Marten, in my experience, these are most often temporary files leftover from an incomplete operation.

They might be from a long-running query that was canceled, or from a table repair operation that errored out or was interrupted.

In my experience it is safe to delete them, provided you take care to not delete one that is in use (i.e. mysql is actively writing to it). The modification dates should let you watch for that.

thanks. Mysql 5 seems a bit buggy then, because I have never seen this behavior in mysql 4.1. And from the logs I couldn't see that mysql crashed or restartet. In fact, our mysql 5 server is mostly idling around (in contrary to our mysql 4.1 servers).

Kind regards
Marten

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to