Thanks for clearing that up. You are right, I don't want the general
log or the mysql shell history.
I'm not happy that I can't get at the Query Cache. I am sure there are
tools which MySql developers must use to test the cache. I'll have to
look at the source code directories...
> 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