From: Paul J. Boyes
Date: May 11 2007 10:34pm
Subject: Query Cache Behavior
List-Archive: http://lists.mysql.com/mysql/206737
Message-Id: <4644EF8D.4070700@paulboyes.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

I am hoping to get pointed in the right direction/save some time...

I have a db in which some web services are constantly inserting/updating 
data.  However, when I run selects from the command line mysql app, I do 
not see the changes that these services have made unless I do a flush 
tables.  This is even true if I log out and log back in.  So, I am 
guessing that it has to do with caching.   Any idea why this is happening?

Thanks,

Paul