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 th
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim 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 t
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> I would like to try and find out how you can see what is using the
> query cache.
>
>
>
> My reason for asking is the following:
>
>
>
> On one of our client databases, the quer
Good morning all
I would like to try and find out how you can see what is using the
query cache.
My reason for asking is the following:
On one of our client databases, the query cache is set to
128Mb and the usage always varied between 5% and 53%
