Percona Server with XtraDB

innodb_lru_dump_restore.patch: buf_LRU_file_dump() holds LRU_list_mutex while doing file I/O

Reported by Alexey Kopytov on 2010-12-07
50
This bug affects 6 people
Affects Status Importance Assigned to Milestone
Percona Server
Medium
George Ormond Lorch III
5.1
Medium
George Ormond Lorch III
5.5
Medium
George Ormond Lorch III

Bug Description

buf_LRU_file_dump() holds LRU_list_mutex when writing to the dump file. This basically means that all operations on buffer pool are blocked for the duration of the dump.

We can easily improve this by first copying offsets to memory while holding the mutex, and then release it before the actual dump.

Related branches

lp:~percona-dev/percona-server/fb_changes_auto_lru_dump
Vadim Tkachenko: Needs Fixing on 2011-01-12
Fred Linhoss: Pending (documentation) requested 2011-01-12
Yasufumi Kinoshita: Pending requested 2011-01-12
Changed in percona-server:
importance: Undecided → Low
Stewart Smith (stewart) wrote :

marking as in progress due to merge req existing

Changed in percona-server:
status: New → In Progress
assignee: nobody → Alexey Kopytov (akopytov)
Stewart Smith (stewart) wrote :

Status of this patch?

Vojtech Kurka (vojtech-kurka) wrote :

Is there any plan to fix this? I see the bugreport is more than 1 year old.

Alexey Kopytov (akopytov) wrote :

I don't have bandwidth to work on this. Unassigning, hope someone else can either update my original MP, or fix this specific issue with LRU dump.

I'll take it since I was recently in that area and have a pretty good
idea of what the fix is.

On 6/27/2012 8:22 AM, Alexey Kopytov wrote:
> I don't have bandwidth to work on this. Unassigning, hope someone else
> can either update my original MP, or fix this specific issue with LRU
> dump.
>
> ** Also affects: percona-server/5.5
> Importance: Low
> Assignee: Alexey Kopytov (akopytov)
> Status: In Progress
>
> ** Changed in: percona-server/5.5
> Status: In Progress => Triaged
>
> ** Changed in: percona-server/5.1
> Importance: Low => Medium
>
> ** Changed in: percona-server/5.5
> Importance: Low => Medium
>
> ** Changed in: percona-server/5.1
> Assignee: Alexey Kopytov (akopytov) => (unassigned)
>
> ** Changed in: percona-server/5.5
> Assignee: Alexey Kopytov (akopytov) => (unassigned)
>

--
George O. Lorch III
Software Engineer, Percona Inc.
+1-888-401-3401 x542 US/Arizona (GMT -7)
skype: george.ormond.lorch.iii

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

Duplicates of this bug

Other bug subscribers