On 08/18/2016 06:26 PM, Vlad Khorsun wrote: > 18.08.2016 18:08, Dimitry Sibiryakov wrote: >> 18.08.2016 16:55, Vlad Khorsun wrote: >>> Global timeout is a last line of defense for DBA against bad apps, >>> wrong queries, >>> developer mistakes, unlucky days (dropped some indices last week but now >>> some queries >>> got crazy) and so on. It is *last* line, therefore it should be used with >>> maximum care. >> What can be an advantage of this feature over cron-ed script chat check >> monitoring >> tables and send DBA mail with list of bad queries? > - no need to create such script > - no need to create such script for every database > - no need to check mail > - no need to go to workplace and kill query by hand > - it just work and require no intervention
+1 it takes reasonable measure not waiting for slow (or 'missing' in many cases) DBA's manual action BTW, requiring much less resources compared with analysis of monitoring tables ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
