Versioning monitoring tables in Firebird 2.1/2.5
Posted by mariuz on 30 Jul 2008 10:03 am. Filed under General news.
Firebird 2.1 added the long-awaited monitoring tables. By querying special system tables starting with MON$, you get a snapshot of the current activities in your database like who is connected to your database, which transactions and statements are running and so on. You even can cancel a running query by executing a DELETE statement on MON$STATEMENTS. Firebird 2.5 will also allow you to cancel an entire attachment via a DELETE on MON$ATTACHMENTS.
Loading ...Leave a Reply
You must be logged in to post a comment.