Re: #sql files
>I can imagine these files are for temporary tables MySQL has to create to execute your queries >after you dropped your indexes.
That may be the gist of it, but it looks more subtle.
The same file has existed for 3 days and lived thru 2 reboots of MySQL. It is very active.
Queries come and go, but the file sticks around.
I think of a temporary file used for a query as something that only persists as long as the query
is active and shows up in the process list as "Using temporary". I'm not seeing this kind of query
showing up in the process list.
Is it being recycled? Strange that it started showing up after the drop index. It was also named
something different than what it is now 4-5 days ago.
Mike
Subject
Views
Written By
Posted
8371
July 29, 2005 02:50PM
4440
July 29, 2005 03:29PM
Re: #sql files
4426
July 29, 2005 04:32PM
3835
August 02, 2005 03:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.