Re: [Toolserver-l] performance issues

2011-11-23 Thread Carl (CBM)
On Wed, Nov 23, 2011 at 6:13 PM, Platonides wrote: >> UPDATE  tmpcategories >> SET c_category = 'A-Class_Water_supply_and_sanitation_articles', >> c_ranking = '425', c_replacement = 'A-Class' >> WHERE c_project = 'Water_supply_and_sanitation' and c_rating= 'A-Class' >> and c_type = 'quality' > > I

Re: [Toolserver-l] performance issues

2011-11-23 Thread Platonides
On 23/11/11 15:16, Carl (CBM) wrote: > One more DB performance report/question. I am seeing some UPDATE > queries that only change one row but take much, much longer than they > ought to. Is anyone else seeing this? > > For example, the following type of query is getting killed from time to > ti

Re: [Toolserver-l] performance issues

2011-11-23 Thread Carl (CBM)
One more DB performance report/question. I am seeing some UPDATE queries that only change one row but take much, much longer than they ought to. Is anyone else seeing this? For example, the following type of query is getting killed from time to time in the p_enwp10 database on sql-s1. The query

Re: [Toolserver-l] performance issues

2011-10-30 Thread Carl (CBM)
On Wed, Oct 26, 2011 at 9:50 AM, Ja Ga wrote: > So, is anyone else seeing really horrible mysql performance on s1? I heard > a mysql upgrade introduced regressions, but I'm seeing queries take 2x - 3x > as long, sometimes worse. > > Anoth

Re: [Toolserver-l] performance issues

2011-10-29 Thread DaB.
Hello, At Saturday 29 October 2011 16:24:30 DaB. wrote: > Something has changed very recently. > I had occasionally received a cron error of > > > Unable to run job: got no response from JSV script > > "/sge62/default/common/jsv.sh". we try to find the reason for this at the moment. Sincerly, Da

Re: [Toolserver-l] performance issues

2011-10-29 Thread Magnus Manske
On Sat, Oct 29, 2011 at 2:18 PM, DaB. wrote: > Hello, > At Saturday 29 October 2011 15:04:30 DaB. wrote: >> 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. > > have

Re: [Toolserver-l] performance issues

2011-10-29 Thread Platonides
DaB. schrieb: > have you ever thought about the possiblity that maybe there are more users on > the TS and more people who use the toolserver now than 2 years ago? Or maybe > it is just people like you, who let a query for a WEBTOOL run for 71 minutes! > > We are just short on hardware at the mo

Re: [Toolserver-l] performance issues

2011-10-29 Thread DaB.
Hello, At Saturday 29 October 2011 15:04:30 DaB. wrote: > 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. have you ever thought about the possiblity that maybe there a

Re: [Toolserver-l] performance issues

2011-10-29 Thread Christian Thiele
Hi, Am 29.10.2011, 13:25 Uhr, schrieb Magnus Manske : > 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: > This queries, and others like it, have not caused pro

Re: [Toolserver-l] performance issues

2011-10-29 Thread Magnus Manske
On Wed, Oct 26, 2011 at 10:18 PM, Platonides 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

Re: [Toolserver-l] performance issues

2011-10-26 Thread Platonides
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 > s

Re: [Toolserver-l] performance issues

2011-10-26 Thread Marlen Caemmerer
Hello, I am not sure if I can already be helpful since I am new to the environment but I have some strange findings in the monitoring graphs. First I'd be interested in the MySQL host you ask. Then: this is the graph. http://munin.toolserver.org/Database/rosemary/mysql_bytes.html Rosemary (one

Re: [Toolserver-l] performance issues

2011-10-26 Thread Krinkle
On Wed, Oct 26, 2011 at 6:29 PM, Carl (CBM) wrote: > the following query of mine was killed after 1700 seconds: > > SELECT ns_id, ns_name FROM toolserver.namespacename where (ns_type = > 'canonical' or ns_type = 'primary') and dbname = 'enwiki_p' > > That should be an extremely fast query; the

Re: [Toolserver-l] performance issues

2011-10-26 Thread Carl (CBM)
On Wed, Oct 26, 2011 at 9:50 AM, Ja Ga wrote: > So, is anyone else seeing really horrible mysql performance on s1? I heard > a mysql upgrade introduced regressions, but I'm seeing queries take 2x - 3x > as long, sometimes worse. > Yes. On the 25th, the following query of mine was killed after 17

Re: [Toolserver-l] performance issues

2011-10-26 Thread Petr Onderka
Hi, I noticed unusually high replag on s1 in the past week, that's probably related. But I didn't hear about any any recent upgrades. They are usually announced, because they cause some downtime. Petr Onderka [[en:User:Svick]] ___ Toolserver-l mailing

[Toolserver-l] performance issues

2011-10-26 Thread Ja Ga
So, is anyone else seeing really horrible mysql performance on s1? I heard a mysql upgrade introduced regressions, but I'm seeing queries take 2x - 3x as long, sometimes worse. - Jason ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) h