bluehost, query cache

[The14thGOD]

I just recently discovered this:

http://dev.mysql.com/doc/refman/5.0/en/query-cache-operation.html

 

And did some researching, it looks like its enabled by default (the settings were already what was in the configuration page: http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html).

 

So is that all there is to it? I don't have to do anything with my SQL statements or php pages? It looks like there's an optional SQL_CACHE function but the setting for query_cache_type is 1.

 

Thanks for clearing this up!

 

Justin

[jskywalker]

you should have:

have_query_cache  = YES

 

not have this:

query_cache_size = 0

 

and there's another setting which can influence things:

query_cache_limit

 

The proper values depend a lot on what the server is doing for you

[fenway]

Assuming the QC is on, every non-deterministic query makes it way into the cache -- which isn't always a good thing.