Mohsen Pahlevanzadeh wrote:
> Ben Clewett wrote:
>> 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?
You're talking about different things.
Mohsen thinks you want to see the the last queries that were run, which
are stored in the ~/.mysql_history file.
Ben wants to see what queries are stored in the query cache
I don't think you can get a list of queries that mysql has stored in the