[pLog-svn] Database layout

Oscar Renalias oscar at renalias.net
Mon May 22 05:33:12 GMT 2006


I suppose you have other applications running, but what do you get if
you type this at a mysql console prompt:

show status like 'qc%';

It should show number of cache hits, etc.

On 5/20/06, Jon Daley <plogworld at jon.limedaley.com> wrote:
> On Sat, 20 May 2006, Oscar Renalias wrote:
> > By the way, does anybody have MySQL's query cache enabled? I was playing with
> > it a couple of days ago and the results where quite good (most of the queries
> > were being cached and served a lot faster from the cache!)
>
> Debian's defaults are the following. I have not played with the settings
> at all.
>
> query_cache_limit   = 1048576
> query_cache_size        = 16777216
> query_cache_type        = 1
>
>
> **************************************
> Jon Daley
> http://jon.limedaley.com/
>
> A fellow can't keep people from having a bad opinion of him,
> but he can keep them from being right about it. -- Unknown
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>


More information about the pLog-svn mailing list