rebuild quick problem (& temporary file location)

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?

Re: rebuild quick problem (& temporary file location)

Forgot to add:  running MySQL 5.0.21 wrote:
Quoted text here. Click to load it

Site Timeline