RE: Why doesn't mySQL stop a query when the browser tab is closedL

e going for longer than X seconds are re-niced or something >>> to not bog down the system? Ideally I'd assume you'd want each query to >>> "peg >>> the CPU" so that they're in and out quickly and the user can get on with >>> their l

Re: Why doesn't mySQL stop a query when the browser tab is closedL

ced or something >>> to not bog down the system? Ideally I'd assume you'd want each query to >>> "peg >>> the CPU" so that they're in and out quickly and the user can get on with >>> their life. But these long running ones at some point X are

Re: Why doesn't mySQL stop a query when the browser tab is closedL

e server with 135% CPU usage and killing the experience for any >> other user on the web site -- and for a duration too! >> >> >> > -Original Message- >> > From: Darryle Steplight [mailto:dstepli...@gmail.com] >> > Sent: Wednesday, June 03, 2009 8:41 AM &

Re: Why doesn't mySQL stop a query when the browser tab is closedL

er user on the web site -- and for a duration too! > > > > -Original Message- > > From: Darryle Steplight [mailto:dstepli...@gmail.com] > > Sent: Wednesday, June 03, 2009 8:41 AM > > To: Jerry Schwartz > > Cc: Jay Blanchard; Daevid Vincent; mysql@lists

RE: Why doesn't mySQL stop a query when the browser tab is closedL

t obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: dae...@daevid.com > To: mysql@lists.mysql.com > Subject: RE: Why doesn't mySQL stop a query when the browser

RE: Why doesn't mySQL stop a query when the browser tab is closedL

uration too! > -Original Message- > From: Darryle Steplight [mailto:dstepli...@gmail.com] > Sent: Wednesday, June 03, 2009 8:41 AM > To: Jerry Schwartz > Cc: Jay Blanchard; Daevid Vincent; mysql@lists.mysql.com > Subject: Re: Why doesn't mySQL stop a query when the brow

Re: Why doesn't mySQL stop a query when the browser tab is closedL

rd [mailto:jblanch...@pocket.com] >>Sent: Wednesday, June 03, 2009 8:46 AM >>To: Daevid Vincent; mysql@lists.mysql.com >>Subject: RE: Why doesn't mySQL stop a query when the browser tab is >>closedL >> >>[snip] >>I just noticed a horrible thing. >>[/snip] &

RE: Why doesn't mySQL stop a query when the browser tab is closedL

>-Original Message- >From: Jay Blanchard [mailto:jblanch...@pocket.com] >Sent: Wednesday, June 03, 2009 8:46 AM >To: Daevid Vincent; mysql@lists.mysql.com >Subject: RE: Why doesn't mySQL stop a query when the browser tab is >closedL > >[snip] >I just n

RE: Why doesn't mySQL stop a query when the browser tab is closedL

[snip] I just noticed a horrible thing. [/snip] Keep in mind that the query event is server side and is not tied to the browser (client side) once it has begun because of the statelessness of the connection. You would have to have some sort of onClose() event from the browser that would trigger a

Why doesn't mySQL stop a query when the browser tab is closedL

I just noticed a horrible thing. I have a query (report) that can take 15 minutes or more to generate with mySQL. We have > 500 Million rows. This used to be done in real time when we had less rows, but recently we got a big dump of data that shot it up. So, noticing via myTop the query taking