Jcrespo has uploaded a new change for review. https://gerrit.wikimedia.org/r/297560
Change subject: Update s4 partitioning in preparation for db1056 pooling ...................................................................... Update s4 partitioning in preparation for db1056 pooling Change-Id: Idb4706ba8a8f10511ae4a661f44e6b32225f178f --- M dbtools/s4-pager.sql 1 file changed, 28 insertions(+), 18 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/software refs/changes/60/297560/1 diff --git a/dbtools/s4-pager.sql b/dbtools/s4-pager.sql index 844b1b0..6e3c9aa 100644 --- a/dbtools/s4-pager.sql +++ b/dbtools/s4-pager.sql @@ -18,48 +18,53 @@ union select 9999999 as n, count(rev_user) from commonswiki.revision where rev_user >= 4000000; -- --- results on 2015-12-29: +-- results on 2016-07-06: -- -- +---------+-----------------+ -- | n | count(rev_user) | -- +---------+-----------------+ --- | 1 | 2312096 | --- | 10000 | 11038216 | --- | 20000 | 5254160 | --- | 30000 | 3460782 | --- | 40000 | 2351946 | --- | 50000 | 4844739 | --- | 100000 | 14958145 | --- | 200000 | 16239187 | --- | 300000 | 13011323 | --- | 400000 | 14644094 | --- | 500000 | 5853173 | --- | 1000000 | 19852423 | --- | 2000000 | 29449241 | --- | 3000000 | 8517747 | --- | 4000000 | 15687869 | --- | 5000000 | 2938461 | +-- | 1 | 2467291 | +-- | 10000 | 11701314 | +-- | 20000 | 5551361 | +-- | 30000 | 3695045 | +-- | 40000 | 2637797 | +-- | 50000 | 5223923 | +-- | 100000 | 15495476 | +-- | 200000 | 17436977 | +-- | 300000 | 13942075 | +-- | 400000 | 15903408 | +-- | 500000 | 6163418 | +-- | 1000000 | 21067980 | +-- | 2000000 | 32877326 | +-- | 3000000 | 9822336 | +-- | 4000000 | 17395118 | +-- | 9999999 | 5647314 | -- +---------+-----------------+ --- 16 rows in set (10 min 23.22 sec) +-- 16 rows in set (29 min 4.75 sec) ALTER TABLE commonswiki.logging DROP PRIMARY KEY, ADD PRIMARY KEY (log_id, log_user) PARTITION BY RANGE (log_user) ( PARTITION p1 VALUES LESS THAN (1), + PARTITION p5000 VALUES LESS THAN (5000), PARTITION p10000 VALUES LESS THAN (10000), PARTITION p20000 VALUES LESS THAN (20000), PARTITION p30000 VALUES LESS THAN (30000), PARTITION p40000 VALUES LESS THAN (40000), PARTITION p50000 VALUES LESS THAN (50000), + PARTITION p75000 VALUES LESS THAN (75000), PARTITION p100000 VALUES LESS THAN (100000), PARTITION p150000 VALUES LESS THAN (150000), PARTITION p200000 VALUES LESS THAN (200000), + PARTITION p250000 VALUES LESS THAN (250000), PARTITION p300000 VALUES LESS THAN (300000), + PARTITION p350000 VALUES LESS THAN (350000), PARTITION p400000 VALUES LESS THAN (400000), PARTITION p500000 VALUES LESS THAN (500000), PARTITION p750000 VALUES LESS THAN (750000), PARTITION p1000000 VALUES LESS THAN (1000000), + PARTITION p1500000 VALUES LESS THAN (1500000), PARTITION p2000000 VALUES LESS THAN (2000000), PARTITION p3000000 VALUES LESS THAN (3000000), PARTITION p4000000 VALUES LESS THAN (4000000), @@ -72,19 +77,24 @@ ADD PRIMARY KEY (rev_id, rev_user) PARTITION BY RANGE (rev_user) ( PARTITION p1 VALUES LESS THAN (1), + PARTITION p5000 VALUES LESS THAN (5000), PARTITION p10000 VALUES LESS THAN (10000), PARTITION p20000 VALUES LESS THAN (20000), PARTITION p30000 VALUES LESS THAN (30000), PARTITION p40000 VALUES LESS THAN (40000), PARTITION p50000 VALUES LESS THAN (50000), + PARTITION p75000 VALUES LESS THAN (75000), PARTITION p100000 VALUES LESS THAN (100000), PARTITION p150000 VALUES LESS THAN (150000), PARTITION p200000 VALUES LESS THAN (200000), + PARTITION p250000 VALUES LESS THAN (250000), PARTITION p300000 VALUES LESS THAN (300000), + PARTITION p350000 VALUES LESS THAN (350000), PARTITION p400000 VALUES LESS THAN (400000), PARTITION p500000 VALUES LESS THAN (500000), PARTITION p750000 VALUES LESS THAN (750000), PARTITION p1000000 VALUES LESS THAN (1000000), + PARTITION p1500000 VALUES LESS THAN (1500000), PARTITION p2000000 VALUES LESS THAN (2000000), PARTITION p3000000 VALUES LESS THAN (3000000), PARTITION p4000000 VALUES LESS THAN (4000000), -- To view, visit https://gerrit.wikimedia.org/r/297560 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Idb4706ba8a8f10511ae4a661f44e6b32225f178f Gerrit-PatchSet: 1 Gerrit-Project: operations/software Gerrit-Branch: master Gerrit-Owner: Jcrespo <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
