python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - firebird2.1

How to kill Firebird (2.1) attachment/connection if VPN was used for database session

I am using VPN (Endpoint Security, Check Point) to establish connection to the Firebird 2.1 database from IBExpert on my computer. Sometimes I just forget disconnect from database and I cancel/disonne...
test-img

TomR

firebird

vpn

database-deadlocks

firebird2.1

Votes: 0

Answers: 1

Latest Answer

In Firebird 2.5 and later, you can delete a connection from MON$ATTACHMENTS to kill a connection. This is not supported with the monitoring tables in Firebird 2.1 as far as I'm aware. Given even Fireb...
test-img

Mark Rotteveel

How to detect the cpu-peak-inducing transaction/statements (mostly read/select) from mon$... data?

I can see that the Firebird 2.1 process (on Linux) (for our program) reaches 97% CPU load, the load may be distributed, e.g. the server can have 4 cores and 2 cores are consumed with 97% load and the ...
test-img

TomR

performance

monitoring

firebird

database-performance

firebird2.1

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs