That all depends on how you have configured your caching, but it is easy
to do.
'mysqld --help':
--query_cache_type=#
0 = OFF = Don't cache or retrieve results. 1 = ON = Cache
all results except SELECT SQL_NO_CACHE ... queries. 2 =
DEMAND = Cache only SELECT SQL_CACHE ... queries.
(http://dev.mysql.com/doc/mysql/en/select.html)
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 7 Jun 2005, qin lei wrote:
> I am running a test on mysql. In a specific conditiob I need avoid using
> the cache system in mysql how can I do this? If I can't, is there anyway to
> remove the cached tables from cache manually?
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
