InnoDB Buffer Pool Status

Hi,
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? And how to =
tuning up my server to get faster, stable, and reliable? Many thanks for =
any response.




sangprabv
sangprabv@gmail.com
http://www.petitiononline.com/froyo/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: InnoDB Buffer Pool Status

Willy Mularto wrote:
> Hi,
> 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? And how to tuning up my server to get faster, stable, and reliable? Many thanks for any response.
>
>
>
>
> sangprabv
> sangprabv@gmail.com
> http://www.petitiononline.com/froyo/
>
>
I'm a novice myself, so I can't offer much in the way of wise advice. I
can, however, point you to a neat script that might give you some useful
pointers.

[ https://launchpad.net/mysql-tuning-primer ]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: InnoDB Buffer Pool Status

--0016363105a17e91910490c2fa49
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Sep 21, 2010 at 12:49 PM, Willy Mularto wrote:

> Hi,
> 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
time.

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0016363105a17e91910490c2fa49--