2013-12-11 18:43:21 |
Andrew Gaul |
bug |
|
|
added bug |
2013-12-11 18:52:07 |
Andrew Gaul |
branch linked |
|
lp:~gaul/percona-server/purge-changed-page-bitmaps |
|
2013-12-12 01:54:05 |
Andrew Gaul |
description |
log_online_purge_changed_page_bitmaps only considers the start LSN of a given bitmap when purging a given bitmap. If it is less than the provided LSN, XtraDB removes the bitmap. Consider this example:
$ ls -1 /var/lib/mysql/*.xdb
ib_modified_log_1_0.xdb
ib_modified_log_2_66075588.xdb
ib_modified_log_3_133835964.xdb
$ echo PURGE CHANGED_PAGE_BITMAPS BEFORE 70000000 | mysql -u root
$ ls -1 /var/lib/mysql/*.xdb
/var/lib/mysql/ib_modified_log_3_133835964.xdb
Instead, XtraDB should consider the start LSN of the subsequent bitmap to infer the end LSN of the current bitmap. With my patch:
$ ls -1 *.xdb
ib_modified_log_1_0.xdb
ib_modified_log_2_63575115.xdb
ib_modified_log_3_131771008.xdb
$ echo PURGE CHANGED_PAGE_BITMAPS BEFORE 70000000 |
mysql -u root
$ ls -1 *.xdb
ib_modified_log_2_63575115.xdb
ib_modified_log_3_131771008.xdb
Without my patch, XtraBackup must perform a full table scan in incremental mode since the bitmap files do not represent the entire range of LSNs. |
log_online_purge_changed_page_bitmaps only considers the start LSN of a given bitmap when purging a given bitmap. If it is less than the provided LSN, XtraDB removes the bitmap. Consider this example:
$ ls -1 /var/lib/mysql/*.xdb
ib_modified_log_1_0.xdb
ib_modified_log_2_66075588.xdb
ib_modified_log_3_133835964.xdb
$ echo PURGE CHANGED_PAGE_BITMAPS BEFORE 70000000 | mysql -u root
$ ls -1 /var/lib/mysql/*.xdb
/var/lib/mysql/ib_modified_log_3_133835964.xdb
Instead, XtraDB should consider the start LSN of the subsequent bitmap to infer the end LSN of the current bitmap. With my patch:
$ ls -1 *.xdb
ib_modified_log_1_0.xdb
ib_modified_log_2_63575115.xdb
ib_modified_log_3_131771008.xdb
$ echo PURGE CHANGED_PAGE_BITMAPS BEFORE 70000000 | mysql -u root
$ ls -1 *.xdb
ib_modified_log_2_63575115.xdb
ib_modified_log_3_131771008.xdb
Without my patch, XtraBackup must perform a full table scan in incremental mode since the bitmap files do not represent the entire range of LSNs. |
|
2013-12-12 06:18:01 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.1 |
|
2013-12-12 06:18:01 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.1 |
|
2013-12-12 06:18:01 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.5 |
|
2013-12-12 06:18:01 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.5 |
|
2013-12-12 06:18:01 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.6 |
|
2013-12-12 06:18:01 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.6 |
|
2013-12-12 06:18:08 |
Laurynas Biveinis |
percona-server/5.1: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
2013-12-12 06:18:10 |
Laurynas Biveinis |
percona-server/5.5: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
2013-12-12 06:18:12 |
Laurynas Biveinis |
percona-server/5.6: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
2013-12-12 06:18:22 |
Laurynas Biveinis |
tags |
|
bitmap |
|
2013-12-12 06:33:45 |
Laurynas Biveinis |
percona-server/5.1: status |
New |
In Progress |
|
2013-12-12 06:33:48 |
Laurynas Biveinis |
percona-server/5.1: importance |
Undecided |
Medium |
|
2013-12-12 06:33:50 |
Laurynas Biveinis |
percona-server/5.5: importance |
Undecided |
Medium |
|
2013-12-12 06:33:52 |
Laurynas Biveinis |
percona-server/5.6: importance |
Undecided |
Medium |
|
2013-12-12 11:19:24 |
Laurynas Biveinis |
percona-server/5.1: status |
In Progress |
Fix Committed |
|
2013-12-12 11:19:27 |
Laurynas Biveinis |
percona-server/5.5: status |
New |
In Progress |
|
2013-12-12 11:19:35 |
Laurynas Biveinis |
percona-server/5.1: milestone |
|
5.1.73-14.11 |
|
2013-12-12 11:19:20 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug1260035-5.1 |
|
2013-12-12 11:35:00 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug1260035-5.5 |
|
2013-12-12 11:36:26 |
Laurynas Biveinis |
percona-server/5.5: status |
In Progress |
Fix Committed |
|
2013-12-12 11:36:29 |
Laurynas Biveinis |
percona-server/5.6: status |
New |
In Progress |
|
2013-12-12 11:36:31 |
Laurynas Biveinis |
percona-server/5.5: milestone |
|
5.5.35-33.0 |
|
2013-12-12 11:36:34 |
Laurynas Biveinis |
percona-server/5.6: milestone |
|
5.6.15-63.0 |
|
2013-12-12 12:07:40 |
Laurynas Biveinis |
percona-server/5.6: status |
In Progress |
Fix Committed |
|
2013-12-12 12:12:57 |
Laurynas Biveinis |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug1260035-5.6 |
|
2013-12-17 09:32:43 |
Laurynas Biveinis |
percona-server/5.1: status |
Fix Committed |
Fix Released |
|
2013-12-17 09:32:45 |
Laurynas Biveinis |
percona-server/5.5: status |
Fix Committed |
Fix Released |
|
2013-12-17 09:32:47 |
Laurynas Biveinis |
percona-server/5.6: status |
Fix Committed |
Fix Released |
|