From: Ben Clewett
Date: December 4 2006 1:46pm
Subject: Re: Query Cache
List-Archive: http://lists.mysql.com/mysql/203701
Message-Id: <457426CC.1000806@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi Mohsen,

Thanks for the reply.

I'm looking in the home directory, as well as the other directories used 
by mysql and I can't see any files which I do not recognise.  (I am UNIX 
so there are no hidden files.)

I am also a little confuses as the Query Cache is entirely a memory 
structure, does it use a file?

If you have the name of the Query Cache file, this would be very useful.

Regards,

Ben.


Mohsen Pahlevanzadeh wrote:
> Ben Clewett wrote:
> 
>> Dear MySql,
>>
>> Can you please tell me if there is a tool to view the queries stored 
>> in the Query Cache?
>>
>> Regards,
>>
>> Ben Clewett.
>>
>>
> Yes,If you see to mysql homeDIR,You see a hidden file that it's contain 
> of your queries.
>