[Bug 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added Status|RESOLVED|VERIFIED --- Comment #24 from Nemo federicol...@tiscali.it --- Thanks! $ curl https://tools.wmflabs.org/quentinv57-tools/tools/sulinfo.php?username=SieBot /dev/null % Total% Received % Xferd Average Speed TimeTime Time Current Dload Upload Total SpentLeft Speed 100 100k0 100k0 0 33092 0 --:--:-- 0:00:03 --:--:-- 33109 -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Bug 53987 depends on bug 55929, which changed state. Bug 55929 Summary: Separate replica datacenter causes high query latency https://bugzilla.wikimedia.org/show_bug.cgi?id=55929 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Cyberpower678 cybernet...@yahoo.com changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED --- Comment #23 from Cyberpower678 cybernet...@yahoo.com --- I'm now closing this as fixed. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Cyberpower678 cybernet...@yahoo.com changed: What|Removed |Added CC||quentin...@gmail.com Component|tools |Quentinv57's tools Assignee|m...@uberbox.org|cybernet...@yahoo.com Product|Wikimedia Labs |Tool Labs tools --- Comment #22 from Cyberpower678 cybernet...@yahoo.com --- It's been highly optimized and now also moved to eqiad. Shouldn't take more that a few seconds to load SUL profiles. High profile users may take a bit longer but the max I got for such users was 5-6 seconds. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #19 from Cyberpower678 cybernet...@yahoo.com --- For the record, quentinv57's tool has been migrated to https://tools.wmflabs.org/quentinv57-tools/tools/sulinfo.php -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #20 from Cyberpower678 cybernet...@yahoo.com --- (In reply to comment #19) For the record, quentinv57's tool has been migrated to https://tools.wmflabs.org/quentinv57-tools/tools/sulinfo.php But it is also suffering from the latency issue. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #21 from Cyberpower678 cybernet...@yahoo.com --- (In reply to comment #20) (In reply to comment #19) For the record, quentinv57's tool has been migrated to https://tools.wmflabs.org/quentinv57-tools/tools/sulinfo.php But it is also suffering from the latency issue. This tool is highly depended by ACC, so I was wondering when this can be resolved? Sorry for constantly posting btw. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #18 from Marc A. Pelletier m...@uberbox.org --- *** Bug 58890 has been marked as a duplicate of this bug. *** -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added Blocks||58788 -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||58890 -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Bug 53987 depends on bug 58890, which changed state. Bug 58890 Summary: Provide sql-sX-rr.labsdb and sql-sX-userdb.labsdb dns entries to access DBs by shard https://bugzilla.wikimedia.org/show_bug.cgi?id=58890 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added See Also|https://bugzilla.wikimedia. | |org/show_bug.cgi?id=55929 | -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #17 from MZMcBride b...@mzmcbride.com --- The Toolserver tool doesn't seem to be doing so great... when I tried to access https://toolserver.org/~quentinv57/sulinfo/Nemo_bis earlier today, it took 9m30.186s for curl to finish. I just tried again and it took 15m47.230s. :-/ -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #12 from Marc A. Pelletier m...@uberbox.org --- Regardless of popularity, this cannot be made faster as it is currently written before labs move save by changing the laws of physics. The tools makes ~1000 database queries serially; unless and until it is made to do them with at least some parallelism, it will remain highly dependent on latency. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #13 from MZMcBride b...@mzmcbride.com --- I hadn't realized until recently that [[m:Special:CentralAuth/Nemo_bis]] now includes an edit count column. What additional functionality is needed before we can point the sulinfo interwiki prefix to Special:CentralAuth? -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #14 from Nemo federicol...@tiscali.it --- (In reply to comment #12) Regardless of popularity, this cannot be made faster as it is currently written before labs move save by changing the laws of physics. Platonides already pointed out on the mailing lists some solutions which require far less than breaking laws of physics. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #15 from MZMcBride b...@mzmcbride.com --- (In reply to comment #13) I hadn't realized until recently that [[m:Special:CentralAuth/Nemo_bis]] now includes an edit count column. What additional functionality is needed before we can point the sulinfo interwiki prefix to Special:CentralAuth? This should read sulutil where it says sulinfo. (I could've sworn it was sulinfo) I've formally proposed this change at [[m:Special:Permalink/6129569#sulutil]] if anyone following this bug is interested. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 MZMcBride b...@mzmcbride.com changed: What|Removed |Added See Also||https://bugzilla.wikimedia. ||org/show_bug.cgi?id=55929 --- Comment #16 from MZMcBride b...@mzmcbride.com --- (In reply to comment #12) Regardless of popularity, this cannot be made faster as it is currently written before labs move save by changing the laws of physics. I'm reminded of bug 55929. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added Depends on||55929 -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #11 from Nemo federicol...@tiscali.it --- In Toolserver top50 with about 16k requests per day, for the records. http://lists.wikimedia.org/pipermail/toolserver-l/2013-October/006337.html That's about 20 % of September 2013 Tool Labs hits. http://tools.wmflabs.org/awstats/cgi-bin/awstats.pl?month=09year=2013output=urldetailconfig=tools.wmflabs.orgframename=index -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Priority|Normal |Lowest --- Comment #10 from Andre Klapper aklap...@wikimedia.org --- Setting lowest priority, then. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Marc A. Pelletier m...@uberbox.org changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WONTFIX --- Comment #8 from Marc A. Pelletier m...@uberbox.org --- The 26ms of overhead it takes to have a query result cannot be circumvented; it is the actual network roundtrip between the database replicas and where the tool labs is currently located (in different data centers). Moving tool labs to eqiad (where the replicas live) is on the roadmap for 4Q 2013, but in the meantime there is - literally - nothing that can be done to improve this short of increasing the speed of light. That said, tools can exploit parallelism of the databases to good effect to circumvent the problem (i.e.: selecting from several databases in one query), or simply make the queries asynchronously (the results will still take 26ms to get back, but if you do them simultaneously rather than sequentially that is not an issue anymore). I'm closing as WONTFIX since there isn't a Unfixable-in-the-current-setup-but-will-not-be-an-issue-once-labs-moved resolution. :-) -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WONTFIX |--- --- Comment #9 from Nemo federicol...@tiscali.it --- (In reply to comment #8) I'm closing as WONTFIX since there isn't a Unfixable-in-the-current-setup-but-will-not-be-an-issue-once-labs-moved resolution. :-) I think --- is the best resolution for should be fixed at some point but we'll need to check. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 MZMcBride b...@mzmcbride.com changed: What|Removed |Added CC||b...@mzmcbride.com --- Comment #6 from MZMcBride b...@mzmcbride.com --- (In reply to comment #0) This tool is a must have [...] We already have [[m:Special:CentralAuth/Nemo_bis]]. If Special:CentralAuth is insufficient, I think we should focus on making it better rather than waste time porting tools between non-production hosts. If this is a must have, as you say. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Cyberpower678 cybernet...@yahoo.com changed: What|Removed |Added Priority|Unprioritized |Normal CC||cybernet...@yahoo.com -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #7 from Nemo federicol...@tiscali.it --- (In reply to comment #6) (In reply to comment #0) This tool is a must have [...] We already have [[m:Special:CentralAuth/Nemo_bis]]. If Special:CentralAuth is insufficient, I think we should focus on making it better rather than waste time porting tools between non-production hosts. If this is a must have, as you say. Feel free to propose a redesign of the special page and/or to submit patches. Tools are not going to disappear. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Nemo federicol...@tiscali.it changed: What|Removed |Added CC||t...@tim-landscheidt.de Component|[other] |tools Assignee|wikibugs-l@lists.wikimedia. |m...@uberbox.org |org | Product|Tool Labs tools |Wikimedia Labs --- Comment #4 from Nemo federicol...@tiscali.it --- (In reply to comment #2) If this requires fixing on an Labs Infrastructure level, please move to Wikimedia Labs tools. Thanks! -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #5 from Nemo federicol...@tiscali.it --- As I said, this is almost surely the same problem as in http://lists.wikimedia.org/pipermail/labs-l/2013-September/001572.html A tool is 30 times slower on TL than on TS: until an alternative implementation/actionable solution is suggested to the maintainer, I consider this a bug in TL. (In reply to comment #3) (I've no idea why I'm listed as maintainer) Ah, sorry. No idea how to get that fixed. -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #1 from Andre Klapper aklap...@wikimedia.org --- Nemo: Why is this under the Other component instead of tools (or Tool labs tools product) if it's hosted on tools.wmflabs.org/* ? -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 --- Comment #3 from Yuvi Panda yuvipa...@gmail.com --- (I've no idea why I'm listed as maintainer) -- 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 53987] sulinfo is unusable (takes tens of seconds)
https://bugzilla.wikimedia.org/show_bug.cgi?id=53987 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Component|(other) |[other] Product|Wikimedia Labs |Tool Labs tools --- Comment #2 from Andre Klapper aklap...@wikimedia.org --- [Moving to Tool Labs tools as this is about a specific tool and not the general Wikimedia Tool Labs infrastructure. Petr and Yuvi are listed as maintainers on http://tools.wmflabs.org/ and hence CC'ed.] If this requires fixing on an Labs Infrastructure level, please move to Wikimedia Labs tools. Thanks! -- 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
