[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 --- Comment #9 from Cyberpower678 --- (In reply to Sean Pringle from comment #7) > A user_timestamp index has been added the archive base tables on > labdb100[123] for all wikis. Thanks for the fix, but I think revision might still have some p

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 --- Comment #10 from Cyberpower678 --- Take note that the time field is in seconds it took to execute the query. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikib

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 --- Comment #8 from Cyberpower678 --- (In reply to Sean Pringle from comment #7) > A user_timestamp index has been added the archive base tables on > labdb100[123] for all wikis. Awesome sauce. Now I just need to wait for the new internet to

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 Sean Pringle changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 Sean Pringle changed: What|Removed |Added Assignee|wikibugs-l@lists.wikimedia. |sprin...@wikimedia.org

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 Sean Pringle changed: What|Removed |Added CC||sprin...@wikimedia.org --- Comment #6 f

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 --- Comment #5 from metatron --- Additional explanation on this (as Cyberpower678 pointed out) `rev_user_text` && `ar_user_text` may give wrong results, if a user has been renamed -- You are receiving this mail because: You are the assignee

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 --- Comment #4 from metatron --- s/Indeces/Indices/ -- 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

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 metatron changed: What|Removed |Added CC||metat...@online.ms --- Comment #3 from meta

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 --- Comment #2 from Cyberpower678 --- For clarity I'm not trying to use rev_user_text, or ar_user_text. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug.

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 Cyberpower678 changed: What|Removed |Added Severity|major |normal -- You are receiving this mail

[Bug 63777] archive_userindex on replication server not indexed well. Takes 10s of seconds to execute a query.

https://bugzilla.wikimedia.org/show_bug.cgi?id=63777 Cyberpower678 changed: What|Removed |Added Priority|Unprioritized |High CC|