List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 23 2012 2:37pm
Subject:Re: restrict Connect Time
View as plain text  
why dont u setup a staging env, which is very much similar to your
production and tune all long running sql

On Mon, Jul 23, 2012 at 8:02 PM, walter harms <wharms@stripped> wrote:

>
>
> Am 23.07.2012 16:10, schrieb Ananda Kumar:
> > you can check the slow query log, this will give you all the sql's which
> > are taking more time to execute
> >
>
> Yes but you will see the results only when the query is finished.
> my first idea was to use something like this:
> select * from information_schema.processlist where state like 'executing'
> and time > 1000 ;
>
> unfortunately time i cumulative and i would kill long running processes
> that we have also.
> i guess i will make some assumptions about the statement and kill the rest.
>
> re,
>  wh
>
>
> > On Mon, Jul 23, 2012 at 7:38 PM, walter harms <wharms@stripped> wrote:
> >
> >>
> >>
> >> Am 23.07.2012 15:47, schrieb Ananda Kumar:
> >>> you can set this is in application server.
> >>> You can also set this parameter in my.cnf
> >>> wait_timeout=120 in seconds.
> >>> But the above parameter is only for inactive session
> >>>
> >>
> >>
> >> acutualy i want to catch scripts running wild.
> >>
> >> re,
> >>  wh
> >>
> >>>
> >>> On Mon, Jul 23, 2012 at 6:18 PM, walter harms <wharms@stripped>
> wrote:
> >>>
> >>>> Hi list,
> >>>> is there a switch where i can restrict the connect/execution time
> for
> a
> >>>> query ?
> >>>>
> >>>> re,
> >>>>  wh
> >>>>
> >>>> --
> >>>> MySQL General Mailing List
> >>>> For list archives: http://lists.mysql.com/mysql
> >>>> To unsubscribe:    http://lists.mysql.com/mysql
> >>>>
> >>>>
> >>>
> >>
> >
>

Thread
restrict Connect Timewalter harms23 Jul
  • Re: restrict Connect TimeAnanda Kumar23 Jul
    • Re: restrict Connect Timewalter harms23 Jul
      • Re: restrict Connect TimeAnanda Kumar23 Jul
        • Re: restrict Connect Timewalter harms23 Jul
          • Re: restrict Connect TimeAnanda Kumar23 Jul
            • Re: restrict Connect Timewalter harms23 Jul
              • Re: restrict Connect TimeAnanda Kumar23 Jul
                • Re: restrict Connect Timewalter harms23 Jul
                  • Re: restrict Connect TimeReindl Harald23 Jul
                    • Re: restrict Connect Timewalter harms23 Jul
                      • RE: restrict Connect TimeRick James23 Jul
                  • Re: restrict Connect TimeAnanda Kumar23 Jul