[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Mark A. Hershberger m...@everybody.org changed: What|Removed |Added CC||m...@everybody.org Target Milestone|1.21.x release |--- --- Comment #25 from Mark A. Hershberger m...@everybody.org --- Removing target milestone that was in the past. If you want this in a specific release, have a good reason AND you are willing to find resources to fix this bug, feel free to change it to something appropriate. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords|easy| -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Brad Jorsch bjor...@wikimedia.org changed: What|Removed |Added CC||bjor...@wikimedia.org Blocks||49188 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Nemo federicol...@tiscali.it changed: What|Removed |Added Target Milestone|1.21.0 release |1.21.x release -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Rob Lanphier ro...@wikimedia.org changed: What|Removed |Added CC||ro...@wikimedia.org Assignee|s...@reedyboy.net|wikibugs-l@lists.wikimedia. ||org Severity|normal |enhancement --- Comment #24 from Rob Lanphier ro...@wikimedia.org --- Unassigning from Reedy since he's not working on it. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #22 from Asher Feldman afeld...@wikimedia.org --- Yes, I am so long as the interface doesn't provide pagination based on limit+offset queries. mysql:root@db1051 [enwiki] select count(*) from revision where rev_page = 1952670; +--+ | count(*) | +--+ | 941113 | +--+ 1 row in set (0.68 sec) mysql:root@db1051 [enwiki] select count(1) as count, rev_user from revision where rev_page = 1952670 group by rev_user order by count desc limit 1; ++--+ | count | rev_user | ++--+ | 139166 | 6327251 | ++--+ mysql:root@db1051 [enwiki] explain select * from revision where rev_page = 1952670 and rev_user = 6327251 order by rev_timestamp desc limit 25; +--+-+--+--+---++-+---+-+-+ | id | select_type | table| type | possible_keys | key| key_len | ref | rows| Extra | +--+-+--+--+---++-+---+-+-+ |1 | SIMPLE | revision | ref | PRIMARY,page_timestamp,user_timestamp | page_timestamp | 4 | const | 2707632 | Using where | +--+-+--+--+---++-+---+-+-+ 1 row in set (0.03 sec) 2707632 looks bad, but: mysql:root@db1051 [enwiki] flush status; mysql:root@db1051 [enwiki] select * from revision where rev_page = 1952670 and rev_user = 6327251 order by rev_timestamp desc limit 25; mysql:root@db1051 [enwiki] show status like 'Handler_read%'; +--+---+ | Variable_name| Value | +--+---+ | Handler_read_first | 0 | | Handler_read_key | 1 | | Handler_read_last| 0 | | Handler_read_next| 0 | | Handler_read_prev| 151 | | Handler_read_rnd | 0 | | Handler_read_rnd_deleted | 0 | | Handler_read_rnd_next| 0 | +--+---+ 8 rows in set (0.02 sec) That example is for the most edited page and the user with the most edits. The worst case for the current schema would be a user with only one edit of the most edited page. mysql:root@db1051 [enwiki] explain select * from revision where rev_page = 1952670 and rev_user = 4305640 order by rev_timestamp desc limit 25; +--+-+--+--+---++-+---+--+-+ | id | select_type | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+-+--+--+---++-+---+--+-+ |1 | SIMPLE | revision | ref | PRIMARY,page_timestamp,user_timestamp | user_timestamp | 4 | const | 479 | Using where | +--+-+--+--+---++-+---+--+-+ 1 row in set (0.03 sec) mysql:root@db1051 [enwiki] flush status; Query OK, 0 rows affected (0.03 sec) mysql:root@db1051 [enwiki] select * from revision where rev_page = 1952670 and rev_user = 4305640 order by rev_timestamp desc limit 25; +---+--+-+-+--+---+++-+-+---+-+ | rev_id| rev_page | rev_text_id | rev_comment | rev_user | rev_user_text | rev_timestamp | rev_minor_edit | rev_deleted | rev_len | rev_parent_id | rev_sha1| +---+--+-+-+--+---+++-+-+---+-+ | 134864881 | 1952670 | 134137447 | /* User-reported */ | 4305640 | AM01NU06 | 20070531180220 | 0 | 0 |1905 | 134864494 | l2ac4niowr2u88gl84ii3vz9cbrkc6t | +---+--+-+-+--+---+++-+-+---+-+ 1 row in set (0.13 sec) mysql:root@db1051 [enwiki] show status like 'Handler_read%'; +--+---+ | Variable_name| Value | +--+---+ | Handler_read_first | 0 | | Handler_read_key | 1 | | Handler_read_last| 0 | | Handler_read_next| 0 | | Handler_read_prev| 480 | | Handler_read_rnd | 0 | | Handler_read_rnd_deleted | 0 | | Handler_read_rnd_next| 0 |
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Aaron Schulz aschulz4...@gmail.com changed: What|Removed |Added CC||aschulz4...@gmail.com --- Comment #23 from Aaron Schulz aschulz4...@gmail.com --- Note that the revision PRIMARY KEY is just rev_id for new tables for MediaWiki. No one ever got around to changing existing ones already. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #21 from Andre Klapper aklap...@wikimedia.org --- (In reply to comment #20) tl;dr: the page_user_timestamp index is _not_ on the Wikimedia databases. Asher: are you comfortable with user interface exposure of this functionality without this index? Asher: ping? -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added CC||hexm...@gmail.com -- You are receiving this mail because: You are watching all bug changes. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #16 from Liangent liang...@gmail.com 2012-11-17 09:56:16 UTC --- *** Bug 42217 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Dereckson dereck...@espace-win.org changed: What|Removed |Added Blocks||42217 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #17 from MZMcBride b...@mzmcbride.com 2012-11-17 17:19:42 UTC --- What's going on with this bug? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 MZMcBride b...@mzmcbride.com changed: What|Removed |Added Keywords||easy Component|History/Diffs |General/Unknown Version|1.20|unspecified AssignedTo|wikibugs-l@lists.wikimedia. |s...@reedyboy.net |org | Target Milestone|--- |1.21.0 release Severity|enhancement |normal --- Comment #18 from MZMcBride b...@mzmcbride.com 2012-11-17 17:31:05 UTC --- Okay, so it looks like tables.sql in master has the relevant index: CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); The question becomes whether this index has been applied to Wikimedia wikis or whether it needs to be (cf. comment 15), then? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #19 from Sam Reed (reedy) s...@reedyboy.net 2012-11-17 17:39:01 UTC --- The question becomes whether this index has been applied to Wikimedia wikis or whether it needs to be (cf. comment 15), then? mysql:wikiadmin@db63 [enwiki] show indexes from revision\G *** 1. row *** Table: revision Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: rev_page Collation: A Cardinality: 100127178 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 2. row *** Table: revision Non_unique: 0 Key_name: PRIMARY Seq_in_index: 2 Column_name: rev_id Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 3. row *** Table: revision Non_unique: 0 Key_name: rev_id Seq_in_index: 1 Column_name: rev_id Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 4. row *** Table: revision Non_unique: 1 Key_name: rev_timestamp Seq_in_index: 1 Column_name: rev_timestamp Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 5. row *** Table: revision Non_unique: 1 Key_name: page_timestamp Seq_in_index: 1 Column_name: rev_page Collation: A Cardinality: 62579486 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 6. row *** Table: revision Non_unique: 1 Key_name: page_timestamp Seq_in_index: 2 Column_name: rev_timestamp Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 7. row *** Table: revision Non_unique: 1 Key_name: user_timestamp Seq_in_index: 1 Column_name: rev_user Collation: A Cardinality: 27813105 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 8. row *** Table: revision Non_unique: 1 Key_name: user_timestamp Seq_in_index: 2 Column_name: rev_timestamp Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 9. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 1 Column_name: rev_user_text Collation: A Cardinality: 1053970 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 10. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 2 Column_name: rev_timestamp Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 11. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 3 Column_name: rev_user Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 12. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 4 Column_name: rev_deleted Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 13. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 5 Column_name: rev_minor_edit Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 14. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 6 Column_name: rev_text_id Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 15. row *** Table: revision Non_unique: 1 Key_name: usertext_timestamp Seq_in_index: 7 Column_name: rev_comment Collation: A Cardinality: 500635893 Sub_part: NULL Packed: NULL Null: YES Index_type: BTREE Comment: 15 rows in set (0.27 sec) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Version|unspecified |1.21-git -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #20 from MZMcBride b...@mzmcbride.com 2012-11-17 17:50:56 UTC --- tl;dr: the page_user_timestamp index is _not_ on the Wikimedia databases. Asher: are you comfortable with user interface exposure of this functionality without this index? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Asher Feldman afeld...@wikimedia.org changed: What|Removed |Added CC||afeld...@wikimedia.org --- Comment #15 from Asher Feldman afeld...@wikimedia.org 2012-06-20 00:05:41 UTC --- I don't think we currently need the new revision index in order to support user edits per page queries. From testing queries like: select * from revision where rev_page = 1952670 and rev_user_text = HBC AIV helperbot7 order by rev_timestamp desc limit 50; where that page id = http://en.wikipedia.org/wiki/Wikipedia:Administrator_intervention_against_vandalism with 800k edits and that user has 122k edits and it ran in ~30ms on a prod enwiki db. I got similar times against frequent editors of the India article, and when querying both with non-existent rev_user_text values. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Sam Reed (reedy) s...@reedyboy.net changed: What|Removed |Added Keywords|easy| AssignedTo|s...@reedyboy.net|wikibugs-l@lists.wikimedia. ||org --- Comment #14 from Sam Reed (reedy) s...@reedyboy.net 2012-05-08 21:05:31 UTC --- TODO: (In reply to comment #12) Reopening per comment 11. Database index supporting this filter has been added. But interface (HistoryAction, SpecialContributions and possibly some API modules as well) still needs to be done. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #13 from Sam Reed (reedy) s...@reedyboy.net 2012-03-06 16:23:30 UTC --- Indeed, per my IRC comment straight afterwards wondering why I actually closed it, and my cut off question asking what else needs doing -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 MZMcBride b...@mzmcbride.com changed: What|Removed |Added Keywords|schema-change, shell| --- Comment #9 from MZMcBride b...@mzmcbride.com 2012-03-05 23:53:49 UTC --- (In reply to comment #7) (In reply to comment #1) I'm committing a schema change for this now. It will require a new index on the revision table, so it probably won't be live for quite some time even once the code to do it is written. This was committed in r25267. And reverted in r25290, apparently. I guess I'll remove a few keywords now. From a coding point-of-view, this is (still) a pretty easy bug to resolve, it appears. So we'll keep the easy keyword. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 MZMcBride b...@mzmcbride.com changed: What|Removed |Added AssignedTo|wikibugs-l@lists.wikimedia. |s...@reedyboy.net |org | -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Sam Reed (reedy) s...@reedyboy.net changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #10 from Sam Reed (reedy) s...@reedyboy.net 2012-03-06 00:12:34 UTC --- r113109, r113110, r113111 brings this back into life It'll get added to WMF later in the 1.20 cycle, maybe before deployment Are there other -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #11 from MZMcBride b...@mzmcbride.com 2012-03-06 02:15:48 UTC --- (In reply to comment #10) r113109, r113110, r113111 brings this back into life It'll get added to WMF later in the 1.20 cycle, maybe before deployment Are there other Comment 0 was about getting Special:Contributions to do this. I don't see any commits to that part of the code. (You just need a page title input on Special:Contributions/user. It should be trivial.) Should this bug be re-opened or should a separate ticket be filed? -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Krinkle krinklem...@gmail.com changed: What|Removed |Added Status|RESOLVED|REOPENED CC||krinklem...@gmail.com Resolution|FIXED | --- Comment #12 from Krinkle krinklem...@gmail.com 2012-03-06 02:27:55 UTC --- Reopening per comment 11. Database index supporting this filter has been added. But interface (HistoryAction, SpecialContributions and possibly some API modules as well) still needs to be done. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 MZMcBride b...@mzmcbride.com changed: What|Removed |Added Keywords||easy CC||b...@mzmcbride.com --- Comment #6 from MZMcBride b...@mzmcbride.com 2012-03-03 23:16:49 UTC --- So all that's missing for this now is hacking up SpecialContributions.php? Is that right? If so, this can probably be marked easy, right? Doing so. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 --- Comment #7 from MZMcBride b...@mzmcbride.com 2012-03-03 23:32:17 UTC --- (In reply to comment #1) I'm committing a schema change for this now. It will require a new index on the revision table, so it probably won't be live for quite some time even once the code to do it is written. This was committed in r25267. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 MZMcBride b...@mzmcbride.com changed: What|Removed |Added Keywords||schema-change, shell Priority|Low |Normal Version|unspecified |1.20-svn --- Comment #8 from MZMcBride b...@mzmcbride.com 2012-03-03 23:44:39 UTC --- (In reply to comment #3) (In reply to comment #1) I'm committing a schema change for this now. It will require a new index on the revision table, so it probably won't be live for quite some time even once the code to do it is written. Removing schema-change keyword on the assumption that it's already happened: the comment is from 2007 and the API manages to do this just fine (prop=revisionsrvuser=Catropetitles=Main_Page). Re-adding schema-change keyword and adding shell keyword (someone has to apply the change, after all). Also targeting this for 1.20 and bumping importance a bit, per my reasoning at bug 2667 comment 4. The assumption here is faulty, I think. Or at least this is easily answerable. I asked in #wikimedia-tech if the index INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp) was on the revision table. DaB. said that the Toolserver didn't have this index, so it was likely that the masters don't either. Based on this, I'd like hard evidence to be able to say that a schema change isn't necessary here still. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 MZMcBride b...@mzmcbride.com changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=2667 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Chad H. innocentkil...@gmail.com changed: What|Removed |Added CC||liang...@gmail.com --- Comment #5 from Chad H. innocentkil...@gmail.com 2010-07-12 09:48:28 UTC --- *** Bug 24345 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10788] Filter page histories by user, or contributions by title
https://bugzilla.wikimedia.org/show_bug.cgi?id=10788 Roan Kattouw roan.katt...@home.nl changed: What|Removed |Added CC||roan.katt...@home.nl Keywords|schema-change | --- Comment #3 from Roan Kattouw roan.katt...@home.nl 2008-12-21 19:37:19 UTC --- (In reply to comment #1) I'm committing a schema change for this now. It will require a new index on the revision table, so it probably won't be live for quite some time even once the code to do it is written. Removing schema-change keyword on the assumption that it's already happened: the comment is from 2007 and the API manages to do this just fine (prop=revisionsrvuser=Catropetitles=Main_Page). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
