List:General Discussion« Previous MessageNext Message »
From:walter harms Date:July 23 2012 2:32pm
Subject:Re: restrict Connect Time
View as plain text  

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