Chris,
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...
Regards,
Ben
Chris wrote:
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
(http://dev.mysql.com/doc/refman/4.1/en/query-cache.html).
I don't think you can get a list of queries that mysql has stored in the
cache.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
