List:General Discussion« Previous MessageNext Message »
From:Kyong Kim Date:June 10 2010 2:54am
Subject:Re: Questions regarding Query cache usage
View as plain text  
Absolutely. You don't want to obscure the cause by just throwing more
hardware at things.
That approach just buys you time until a bigger pile hits the fan if
the underlying issue remains unresolved.
At the same time, though, 8 MB production innodb buffer pool
allocation should be fairly high on the list of things to scrutinize.

On Wed, Jun 9, 2010 at 12:12 PM, Johan De Meersman <vegivamp@stripped> wrote:
> On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim <kykimdba@stripped> wrote:
>> If the memory is available, why not use it? It seems like the default
>> buffer pool size out of the box was just never changed.
> Agreed, of course, but if something happens on a system that is out of
> the ordinary, it's very good practice to hunt the cause down before it
> makes more undesireable things happen.
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
Questions regarding Query cache usageMachiel Richards9 Jun
  • Re: Questions regarding Query cache usageKyong Kim9 Jun
    • Re: Questions regarding Query cache usageJohan De Meersman9 Jun
      • Re: Questions regarding Query cache usageKyong Kim10 Jun