On Tue, Sep 21, 2010 at 12:49 PM, Willy Mularto <sangprabv@stripped> wrote:
> I got this result on InnoDB Buffer Pool Status:
> Free pages 1
> Dirty pages 2,040
> Pages containing data 31,359
> Pages to be flushed 457,083,205
> Busy pages 1,408
> Read requests 31,348,288,497
> Write requests 7,913,407,934
> Read misses 39,736,110
> Write waits 0
> Read misses in % 0.13 %
> Write waits in % 0.00 %
> I see there are millions of Read misses. What's that mean?
Nothing much, in and of itself. Divide by your uptime, and you'll get a
vaguely meaningful number. Keep track of the counter over time, and you may
see something actually useful.
> And how to tuning up my server to get faster, stable, and reliable? Many
> thanks for any response.
By understanding how it works, what it does, and what the different counters
and variables mean. There's no magic trick for it - start by investing time
in reading the documentation; play with test systems; and if you've got the
dough, get mysql-sanctioned training.
Nothing in life is free. If it doesn't cost money, maybe you have to spend
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel