DaB. (2013-02-15 21:38):
Hello,
At Friday 15 February 2013 21:32:53 DaB. wrote:
Seems like S2 is going crazy for few days:
http://toolserver.org/~bryan/stats/replag/?cluster=s2#s2-daily
Not sure if related, but at least the restart seem not to have helped
;-). I've even received the Query-Killer greetings for the first time
and what was more interesting, it was on a query that should take...
hm... 0 s as it should only work on indexes (rev_pag, rev_id).
I admit that there is still room for optimization (z-dat-s2-b is our first
Debian-db-server and I started with a clean config), but if you look at the
monthly or yearly graph you can see that there were also these peaks before.
I will look what I can do, but there are several things I have to care for in
parallel at the moment.
Hmm... I admit that there were peaks before, but this are not peaks[1]
it's a whole mountain range ;-). Previously there were peaks, some
rumbling and it went quiet. Currently it's just a crazy ride and even
queries like this can take seconds to complete (I know because this the
only query on my first page):
SELECT min(rc_timestamp) as rc_min, max(rc_timestamp) as rc_max FROM
`recentchanges`
Something must have changed. Some tool started going crazy or some
device is faulty.
[1] = <http://toolserver.org/~bryan/stats/replag/?cluster=s2#s2-monthly>
_______________________________________________
Toolserver-l mailing list ([email protected])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list:
https://wiki.toolserver.org/view/Mailing_list_etiquette
