I must confess that this was nothing more than the result of a little Googling. My instincts tell me that there must be something to stop long running queries. I run postgres and have set it to log all queries which take over 1/4 second but I know very little about mysql.
Caleb Paul Libbrecht wrote: > Caleb, > > Very interesting but... > The last release is of 2004, are you using this with a contemporary > mysql? > > paul > > > Le 17-janv.-10 à 16:49, Caleb James DeLisle a écrit : > >> I think at the database level you can tell it to cease if there is a >> query >> which goes on for more than x milliseconds. >> >> http://mtop.sourceforge.net/ >> mkill can kill long running mysql queries. >> >> In postgres it's a configuration parameter: >> http://www.postgresql.org/docs/8.3/static/runtime-config-client.html#GUC-STATEMENT-TIMEOUT >> >> Caleb >> >> Flavius Olaru wrote: >>> Hi, >>> >>> I've done a installation on my localhost (Windows XP machine) of XE >>> 2.1.1, Tomcat 6 and MySQL 5.1. >>> After this i wrote a bad hql query and executed it which brought >>> MySQL >>> to spyke the CPU usage to 100% and even more rendering both the >>> localhost and database unusable. >>> >>> {{velocity}} >>> #set($badhql = ", BaseObject obj, StringProperty stringprop, >>> LargeStringProperty largestringprop where (doc.name like '%$text%' or >>> doc.content like '%$text%') or (obj.name=doc.fullName and >>> stringprop.id.id=obj.id and stringprop.value like '%$text%') or >>> (obj.name=doc.fullName and largestringprop.id.id=obj.id and >>> largestringprop.value like '%$text%')") >>> #set($ok = $list.addAll(0, $xwiki.searchDocuments("$badhql"))) >>> >>> {{include document="XWiki.Results"/}} >>> {{/velocity}} >>> >>> The bad thing is that $xwiki.searchDocuments brought me to this state >>> (no programming rights.). >>> Now my question is: Are there any remedies against this? MySQL >>> configuration statements that prevent this kind of behaviour? >>> >> _______________________________________________ >> users mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/users > > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
