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

Am 23.07.2012 17:38, schrieb Reindl Harald:
> 
> 
> Am 23.07.2012 17:35, schrieb walter harms:
>>
>>
>> Am 23.07.2012 16:58, schrieb Ananda Kumar:
>>> so. its more of inactive connections, right.
>>> What do you mean by NEVER LOGOUT
>>>
>>
>> The programms watch certain states in the database,
>> the connect automatic at db startup, disconnecting
>> is an error case.
> 
> so why do you want to restrict connect time
> if this is a error-case for you?
> 

no, this is a misunderstanding,
i want to catch "running" querries that already run longer than
a certain time. When i use my simple approach like:
select * from information_schema.processlist where state like 'executing' and time >
1000 ;
it did work work as intended.

Unfortunately 'time' is cumulative meaning there is a real risk catching
legitimate users. I guess i could filter it based on 'info' (what contains the query)
but i was hoping that there is a more simple way.

re,
 wh
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