[Labs-l] Tool Labs slow + MySQL connection errors

[Hedonil]

Ah, keep on hammering s6 ;)
Also reminds me to fully publish the pageviews-api for those who want
fast access to pageview data without requesting direct access to the
database.
In a nutshell
-
https://de.wikipedia.org/wiki/Benutzer_Diskussion:Hedonil#Wikiviewstats_API

The db-issues (lost connection) occurred when accessing tools-db.

--Hedonil


On 29/08/14 17:59, Morten Wang wrote:
> If the performance issues are related to s6, it might be because I've
> been hammering that database a bit, for about 4 days until midnight
> UTC last night.  Don't think they should result in connection
> problems, though.
>
> As I'm thinking about grabbing more data (I left a message on your
> talk page on de-WP regarding redirects), I'll do some testing to
> figure out how to treat the database more kindly.
>
>
> Regards,
> Morten
>
>
>
> On 29 August 2014 08:48, Hedonil <hedonil at action.ms
> <mailto:hedonil at action.ms>> wrote:
>
>     In the last ~ 4 days there has been a noticeable decrease in
>     performance, esp. longer lasting periods of lag
>     Since yesterday additionally MySQL connection errors. Logs are
>     full with
>     stuff like:
>     oursql.OperationalError: (2013, 'Lost connection to MySQL server
>     during
>     query', None)
>
>     Any maintenance going on? New power-players in Tools? An app
>     running wild?
>
>     -Hedonil
>
>     _______________________________________________
>     Labs-l mailing list
>     Labs-l at lists.wikimedia.org <mailto:Labs-l at lists.wikimedia.org>
>     https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20140831/45cda79f/attachment.html>