On Wed, Oct 26, 2011 at 10:18 PM, Platonides platonides@gmail.com wrote:
Marlen Caemmerer wrote:
Rosemary (one of the enwiki-DB-Hosts) seems to bring the maximum of the I/O that is possible, disk graphs are clipping there. In the MySQL traffic graph you can see there is clipping too. Strange thing about this is that this phenomenon started in the middle of september. Can anyone remember any important change in this time? That is not the case with thyme (other enwiki DB Host) so it'd be a question wether we could share the load better. Also I enabled query caching and will see if this is useful in any way.
Maybe there's some job/tool which started at that time which loaded rosemary so much?
In the last three hours, I got no less than 21 immensely useless mails from the query killer. The following query, apparently, was killed after running for a whooping 71 minutes:
SELECT /* SLOW_OK */ /* GLAMOROUS */ gil_wiki,gil_page_title,gil_page_namespace,gil_to from globalimagelinks,page,categorylinks where gil_to=page_title and cl_to ="Images_from_the_National_Archives_and_Records_Administration" AND page_id=cl_from AND page_namespace=6 AND gil_page_namespace=""
This queries, and others like it, have not caused problems for the last one (two? I can't remember) years they've been in place. Something has changed for the far, far worse.
Magnus