can't turn off mysql query cache on mac (macports install)

Question

I'm trying to turn off mysql query cache on my local mac dev machine.

I've tried via the CL:

SELECT sql_no_cache;
RESET query cache;
SET SESSION query_cache_type = OFF;

and also in the config:

query-cache-type = 0

I installed it via macports. There are about 10 my.cnf files so maybe I'm not even editing the correct on?

/private/etc/my.cnf
/Users/dj/Downloads/mysql-5.1.41-osx10.5-x86_64/mysql-test/suite/federated/my.cnf
/Users/dj/Downloads/mysql-5.1.41-osx10.5-x86_64/mysql-test/suite/ndb/my.cnf
/Users/dj/Downloads/mysql-5.1.41-osx10.5-x86_64/mysql-test/suite/rpl/my.cnf

etc ...

I would think the command line stuff should work though.

I think I've tried everything I've found online to no avail. Really appreciate any help. Thanks!

Answer 1

sql_no_cache usage is to add it ater every select statement (query) you do.

Such as:

select  sql_no_cache * from mytable;

You can be sure this would not be cached. However there are a lot of other caches involved in the process of retrieving data from tables, from the harddrives and/or controllers themselves to the operating system caching frequent used files, to the storage engines mysql uses (such as innodb's buffer).

Why do you want your queries not to be cached?

If it's for benchmarking, I'd suggest restart mysql server before each execution.

my.cnf should be located at /etc/my.cnf.