Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Jiří Činčura
>You must commit transaction before you can see new monitoring snapshot. Yes, I know that. -- Mgr. Jiří Činčura Independent IT Specialist -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.n

Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Jiří Činčura
> MON$ATTACHMENTS never returns stale data (provided you query it in a new > transaction every time), unless you forced abnormal disconnection at the Sure, it's always a new transaction. > network layer and the server's TCP stack didn't yet discover the > connection as lost. In this case Firebird

Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Dimitry Sibiryakov
21.08.2015 13:05, Jiří Činčura wrote: > Selecting from mon$attachments gets sometimes stale data even after few > seconds. You must commit transaction before you can see new monitoring snapshot. -- WBR, SD. -- Fi

Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Ivan Arabadzhiev
Why not setup a dummy db with triggers on connect/disconnect? Whether they update a count field or log the event - it should be fast enough for the purpose. 2015-08-21 14:05 GMT+03:00 Jiří Činčura : > Hi *, > > Is there a way to somewhat get a number of connections to given database > that's alwa

Re: [Firebird-devel] Number of connections to DB

2015-08-21 Thread Dmitry Yemanov
21.08.2015 14:05, Jiří Činčura wrote: > > Is there a way to somewhat get a number of connections to given database > that's always (or in some predefined interval, known in advance) up to date? > Selecting from mon$attachments gets sometimes stale data even after few > seconds. Maybe there's som