Report LRU Age in Buffer Pool

Bug #590293 reported by Peter Zaitsev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Wishlist
Unassigned

Bug Description

Innodb seems to track age of accesses to the pages in LRU as part of its old/new pages replacement policy.
Investigate if it is possible to print the age of last page in buffer pool (how old it has not been accessed)

Having this number we can understand how much pressure buffer pool has - if page gets removed after being idle for 1 minute it is different vs it is being removed after 30 minutes.

Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

I think the last page of LRU list is not the oldest page always.
It may be imprecise data.
Do you want it even it is imprecise?

Revision history for this message
Peter Zaitsev (pz-percona) wrote : Re: [Bug 590293] Re: Report LRU Age in Buffer Pool

Yasufumi,

It is OK if it is not 100% percise. Really we're looking for order of
magnitude here.

On Sun, Jun 6, 2010 at 6:41 PM, Yasufumi Kinoshita <
<email address hidden>> wrote:

> I think the last page of LRU list is not the oldest page always.
> It may be imprecise data.
> Do you want it even it is imprecise?
>
> --
> Report LRU Age in Buffer Pool
> https://bugs.launchpad.net/bugs/590293
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Percona Server with XtraDB: New
>
> Bug description:
> Innodb seems to track age of accesses to the pages in LRU as part of its
> old/new pages replacement policy.
> Investigate if it is possible to print the age of last page in buffer pool
> (how old it has not been accessed)
>
> Having this number we can understand how much pressure buffer pool has -
> if page gets removed after being idle for 1 minute it is different vs it is
> being removed after 30 minutes.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/percona-server/+bug/590293/+subscribe
>

--
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/

Changed in percona-server:
status: New → Confirmed
importance: Undecided → Wishlist
Stewart Smith (stewart)
Changed in percona-server:
status: Confirmed → Triaged
tags: added: low-hanging-fruit
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2315

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.