Core question: where does MySQL create temporary files in a quick
rebuild? ( I thought I knew the answer, but now can't find them.)

I'm trying to rebuild a file using "repair table <tablename> quick".
It's worked fine in the past, but it doesn't seem to be rebuilding.

"show processlist" does report the State is "Repair by sorting". I've
been trying to monitor progress by looking at the temporary files being
used in the rebuild, but I can't find them!

I have looked

1. in the mysql database directory (where the table is stored)
2. /tmp
3. /usr/tmp
4. /var/tmp

my.cnf does not specify a tmp file directory and "show variables"
reports that "tmpdir" has no value.

Any clue where the files are?

Forgot to add: running MySQL 5.0.21

pcos...@gmail.com wrote:
> Core question: where does MySQL create temporary files in a quick
> rebuild? ( I thought I knew the answer, but now can't find them.)
>
> I'm trying to rebuild a file using "repair table <tablename> quick".
> It's worked fine in the past, but it doesn't seem to be rebuilding.
>
> "show processlist" does report the State is "Repair by sorting". I've
> been trying to monitor progress by looking at the temporary files being
> used in the rebuild, but I can't find them!
>
> I have looked
>
> 1. in the mysql database directory (where the table is stored)
> 2. /tmp
> 3. /usr/tmp
> 4. /var/tmp
>
> my.cnf does not specify a tmp file directory and "show variables"
> reports that "tmpdir" has no value.
>
> Any clue where the files are?