From: Marten Lehmann (lehmanncnm.de)
Date: Mon Mar 31 2008 - 08:55:26 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]