Due to T50693: Gadget settings cannot be changed on Mediawiki 1.22wmf4 there are a bunch of useless rows in the form of "gadget--foo" in the user_properties table (I counted 2758 on enwp). These will go away over time whenever users update their preferences, but since they're now showing upon the new Special:GadgetUsage page, we should delete these rows using runBatchedQuery.php.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T340453 [Epic] FY 2023-24 Growth Maintenance Work | |||
| Resolved | KStoller-WMF | T347840 [Epic] Q2 FY 2023-24 Growth Maintenance Work | |||
| Open | None | T54777 user_properties table bloat | |||
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | Krenair | T117440 Clean up "gadget--%" rows from user_properties on Wikimedia wikis |
Event Timeline
Comment Actions
foreachwiki runBatchedQuery.php "delete from user_properties where up_property like 'gadget--%' limit 500;"?
Comment Actions
Confirmed that Gadgets may not start with a - character: https://test.wikipedia.org/w/index.php?title=MediaWiki%3AGadgets-definition&type=revision&diff=247769&oldid=246456
Comment Actions
krenair@mw1152:~$ foreachwiki runBatchedQuery.php "delete from user_properties where up_property like 'gadget--%' limit 500;" | grep Batch | grep -v " 0 rows" commonswiki: Batch 1: 500 rows commonswiki: Batch 2: 246 rows dewikisource: Batch 1: 1 rows dewikivoyage: Batch 1: 9 rows enwiki: Batch 1: 500 rows enwiki: Batch 2: 500 rows enwiki: Batch 3: 500 rows enwiki: Batch 4: 500 rows enwiki: Batch 5: 500 rows enwiki: Batch 6: 258 rows enwikibooks: Batch 1: 22 rows enwikinews: Batch 1: 4 rows enwikisource: Batch 1: 2 rows enwikiversity: Batch 1: 6 rows enwikivoyage: Batch 1: 5 rows enwiktionary: Batch 1: 1 rows eswikinews: Batch 1: 2 rows eswikiquote: Batch 1: 2 rows eswikisource: Batch 1: 1 rows frwikiquote: Batch 1: 3 rows frwiktionary: Batch 1: 8 rows incubatorwiki: Batch 1: 7 rows labswiki: Batch 1: 5 rows mediawikiwiki: Batch 1: 63 rows metawiki: Batch 1: 35 rows plwiktionary: Batch 1: 6 rows ptwikibooks: Batch 1: 10 rows ptwikisource: Batch 1: 5 rows ruwikiquote: Batch 1: 8 rows specieswiki: Batch 1: 1 rows ukwikinews: Batch 1: 1 rows ukwikisource: Batch 1: 2 rows ukwikivoyage: Batch 1: 3 rows viwikibooks: Batch 1: 3 rows wikidatawiki: Batch 1: 27 rows