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 sangpr...@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=arch...@jab.org
Re: InnoDB Buffer Pool Status
Willy Mularto wrote: Hi, I got this result on InnoDB Buffer Pool Status: Free pages1 Dirty pages 2,040 Pages containing data 31,359 Pages to be flushed 457,083,205 Busy pages1,408 Read requests 31,348,288,497 Write requests7,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 sangpr...@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=arch...@jab.org
Re: InnoDB Buffer Pool Status
On Tue, Sep 21, 2010 at 12:49 PM, Willy Mularto sangpr...@gmail.com 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