Comment 8 for bug 606811

Yasufumi, Vadim,

What performance gains are we getting when it is constant ?
Can it be variable which is computed once on start rather than
constant (it looks like this would be similar speed for me)

If we need to set it to constant what is the minimum buffer pool
with which it is going to work ?

I think we can safely increase minimum buffer pool to 64M or so
in Percona Server (and change default) - If we ever will need to support
customers with very small systems we can consider having special build for
these.

On Fri, Jul 23, 2010 at 12:17 AM, Yasufumi Kinoshita <
<email address hidden>> wrote:

> Vadim,
>
> The patch is not
> "Make BUF_READ_AHEAD_AREA a constant".
>
> But "Don't start up when small BP for which 64 page BUF_READ_AHEAD_AREA
> is too large".
>
> So. I don't understand "working with default BP" meaning.
> The patch is for "don't start up when small BP such as default".
>
> And for small BP, BUF_READ_AHEAD_AREA should not be 64. it is too large.
> (e.g. BP = 8MB, read ahed 1MB? why do you think it is needed?)
>
> --
> Make BUF_READ_AHEAD_AREA a constant
> https://bugs.launchpad.net/bugs/606811
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
>
> Status in Percona Server with XtraDB: In Progress
>
> Bug description:
> see
> http://bazaar.launchpad.net/~mysqlatfacebook/mysqlatfacebook/5.1/revision/3538
>
>
>

--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911

Percona Training Workshops
http://www.percona.com/training/