List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 23 2012 2:58pm
Subject:Re: restrict Connect Time
View as plain text  
so. its more of inactive connections, right.
What do you mean by NEVER LOGOUT

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

>
>
> Am 23.07.2012 16:37, schrieb Ananda Kumar:
> > why dont u setup a staging env, which is very much similar to your
> > production and tune all long running sql
> >
>
> They are tuned and they are fast :) but the never logout and therefore
> the time get accumulated.
>
> re,
>  wh
>
>
> > 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