Comment 2 for bug 671227

Sasha,

Yes. I think it is critical. It is easy to modify one query but it is hard
to inject couple of more
also (unless you use multi statement execution API) you're looking at
increasing number of round trips
which is very bad.

On Mon, Nov 8, 2010 at 10:47 AM, Sasha Pachev <email address hidden>wrote:

> On Thu, Nov 4, 2010 at 6:51 PM, Peter Zaitsev <email address hidden> wrote:
> > Public bug reported:
> >
> > Implement some functionality to limit query execution time, it could be
> >
> > SELECT ... SQL_TIMEOUT=60 .... in which query will be killed in 60
> > seconds.
> >
> > It would be also helpful to have max_query_time or similar variable so
> queries can be killed automatically.
> > This can be set as per session for interactive web sessions which know
> they should not be doing long queries.
> >
> > We may consider implementing this as user privilege to so we can restrict
> users from doing very long queries,
> > this would be good for hosting providers which have to prevent users from
> running very long queries and killing
> > system.
>
> Peter:
>
> Is there any benefit to SELECT ... SQL_TIMEOUT vs SET max_query_time
> 60 ; SELECT ; SET max_query_time = 0 ?
>
> If we skip SQL_TIMEOUT=60 we avoid have to maintain a parser patch.
>
> --
> Implement automatic query kill functionality
> https://bugs.launchpad.net/bugs/671227
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Percona Server with XtraDB: New
>
> Bug description:
> Implement some functionality to limit query execution time, it could be
>
> SELECT ... SQL_TIMEOUT=60 .... in which query will be killed in 60
> seconds.
>
> It would be also helpful to have max_query_time or similar variable so
> queries can be killed automatically.
> This can be set as per session for interactive web sessions which know they
> should not be doing long queries.
>
> We may consider implementing this as user privilege to so we can restrict
> users from doing very long queries,
> this would be good for hosting providers which have to prevent users from
> running very long queries and killing
> system.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/percona-server/+bug/671227/+subscribe
>

--
Peter Zaitsev, CEO, Percona Inc.
Tel: +1 888 401 3401 ext 501 Skype: peter_zaitsev
24/7 Emergency Line +1 888 401 3401 ext 911

Percona Training Workshops
http://www.percona.com/training/