Subject | Performance stats |
---|---|
Author | sboydlns |
Post date | 2004-09-10T12:59:55Z |
Does there exist, or are there any plans to implement, a means of
accumulating performance related stats for a Firebird database.
Useful items would include, but not necessarily be limited to:
1) Active connections and what IP address they originate from.
2) Current or last active SQL command for each connection.
3) Execution time of above command.
4) # of IOs done by last command.
5) Total execution time for connection.
6) Total IOs done by connection.
7) Total length of time connection active.
8) Current transaction #.
9) Length of time current transaction active.
This would be a big help while trying to find the cause of Firebird
related performance problems.
accumulating performance related stats for a Firebird database.
Useful items would include, but not necessarily be limited to:
1) Active connections and what IP address they originate from.
2) Current or last active SQL command for each connection.
3) Execution time of above command.
4) # of IOs done by last command.
5) Total execution time for connection.
6) Total IOs done by connection.
7) Total length of time connection active.
8) Current transaction #.
9) Length of time current transaction active.
This would be a big help while trying to find the cause of Firebird
related performance problems.