[Bug 52777] user_properties table bloat

2014-08-23 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #20 from Helder he7d3r+b...@gmail.com --- (In reply to Nemo from comment #19) If you're willing to merge it, that's ok. But let's see how I1da936c786adb21e2c1802ef405bb904c9cf4918 goes. That patch was merged. -- You are

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bug 52777 depends on bug 64757, which changed state. Bug 64757 Summary: Remove searchlimit from user_properties with runBatchedQuery.php on all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64757 What|Removed

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bug 52777 depends on bug 64752, which changed state. Bug 64752 Summary: Remove vector-collapsiblenav from user_properties with runBatchedQuery.php on all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64752 What|Removed

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bug 52777 depends on bug 64753, which changed state. Bug 64753 Summary: Remove showjumplinks from user_properties with runBatchedQuery.php on all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64753 What|Removed

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bug 52777 depends on bug 64754, which changed state. Bug 64754 Summary: Remove ajaxsearch from user_properties with runBatchedQuery.php on all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64754 What|Removed

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bug 52777 depends on bug 64755, which changed state. Bug 64755 Summary: Remove disablesuggest from user_properties with runBatchedQuery.php on all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64755 What|Removed

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bug 52777 depends on bug 64756, which changed state. Bug 64756 Summary: Remove nocache from user_properties with runBatchedQuery.php on all wikis https://bugzilla.wikimedia.org/show_bug.cgi?id=64756 What|Removed

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #17 from Tim Starling tstarl...@wikimedia.org --- (In reply to Nemo from comment #14) Tim, it's still not clear to me what alternative you propose for bug 36316 not to be a problem. (We've been blocked one more year just to save

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Kunal Mehta (Legoktm) legoktm.wikipe...@gmail.com changed: What|Removed |Added CC|

[Bug 52777] user_properties table bloat

2014-07-09 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #19 from Nemo federicol...@tiscali.it --- Thanks Reedy for the cleanup. Tim said: Or just set watchdefault=1 by default for all users. If you're willing to merge it, that's ok. But let's see how

[Bug 52777] user_properties table bloat

2014-05-17 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||52542 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added CC||sprin...@wikimedia.org

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #15 from Umherirrender umherirrender_de...@web.de --- (In reply to Nemo from comment #14) How? Umherirrender, if there is a script already suitable for that[...] See comment #2: (In reply to Tim Starling from comment #2) You

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||64752 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||64753 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||64754 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||64756 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||64755 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||64757 -- You are

[Bug 52777] user_properties table bloat

2014-05-02 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #16 from Nemo federicol...@tiscali.it --- (In reply to Nemo from comment #14) [...] please file one shell request for each. I will not do that. The list is not closed, so maybe there are more preferences to be removed. Hence

[Bug 52777] user_properties table bloat

2014-01-16 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #13 from Umherirrender umherirrender_de...@web.de --- You can remove 'searchlimit' preference from the database, was removed from core with gerrit 105871. -- You are receiving this mail because: You are the assignee for the bug.

[Bug 52777] user_properties table bloat

2013-12-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #12 from Umherirrender umherirrender_de...@web.de --- Expand a existing maintenance script to clean up the database: gerrit 101233 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list

[Bug 52777] user_properties table bloat

2013-12-11 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #11 from Max Semenik maxsem.w...@gmail.com --- https://gerrit.wikimedia.org/r/100938 should improve the situation a bit. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug.

[Bug 52777] user_properties table bloat

2013-12-10 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #10 from Umherirrender umherirrender_de...@web.de --- You can remove 'nocache' preference from the database, was removed from core with gerrit 98276. -- You are receiving this mail because: You are the assignee for the bug. You

[Bug 52777] user_properties table bloat

2013-12-06 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #9 from Umherirrender umherirrender_de...@web.de --- You can remove 'disablesuggest' preference from the database, because it was removed from core with gerrit 99163 You may find more by looking at the fixed bugs which depends on

[Bug 52777] user_properties table bloat

2013-12-04 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #7 from Chad H. innocentkil...@gmail.com --- ajaxsearch doesn't seem to be used anymore either, there's another 769131 rows that can be dropped. -- You are receiving this mail because: You are the assignee for the bug. You are on

[Bug 52777] user_properties table bloat

2013-12-04 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Danny B. dann...@email.cz changed: What|Removed |Added CC||dann...@email.cz ---

[Bug 52777] user_properties table bloat

2013-10-26 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #6 from Umherirrender umherirrender_de...@web.de --- You can remove the 'vector-collapsiblenav' preference from database, because it was removed from vector extension and not migrated to core: gerrit 83591 -- You are receiving

[Bug 52777] user_properties table bloat

2013-10-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Bartosz DziewoƄski matma@gmail.com changed: What|Removed |Added Blocks||36316 -- You

[Bug 52777] user_properties table bloat

2013-08-23 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added CC|

[Bug 52777] user_properties table bloat

2013-08-22 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 db duplicate...@googlemail.com changed: What|Removed |Added CC|

[Bug 52777] user_properties table bloat

2013-08-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||performance

[Bug 52777] user_properties table bloat

2013-08-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 Nemo federicol...@tiscali.it changed: What|Removed |Added Blocks||29782 --- Comment #3

[Bug 52777] user_properties table bloat

2013-08-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 MZMcBride b...@mzmcbride.com changed: What|Removed |Added Depends on||52778 -- You are

[Bug 52777] user_properties table bloat

2013-08-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #1 from MZMcBride b...@mzmcbride.com --- Thank you for researching this. (In reply to comment #0) Sampling 1000 users with user_id10M, we find that the main culprits are: searchNs-1 : 968 users skin: 964 users thumbsize: 912

[Bug 52777] user_properties table bloat

2013-08-12 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=52777 --- Comment #2 from Tim Starling tstarl...@wikimedia.org --- (In reply to comment #1) I'm not sure correcting these database table row anomalies will require a maintenance script. The cleanup for searchNs-1 and thumbsize can probably be done