Issue Details (XML | Word | Printable)

Key: CORE-4450
Type: Improvement Improvement
Status: Open Open
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Trace: provide elapsed time for event START_TRANSACTION

Created: 06/Jun/14 04:49 AM   Updated: 06/Jun/14 06:34 AM
Component/s: TRACEMGR
Affects Version/s: 3.0 Alpha 2
Fix Version/s: None


 Description  « Hide
It will be useful to see the time which is spent for starting of Tx in case when all attachments starts it with TIL = SNAPSHOT. Each Tx in such TIL must get own copy of TIP's active part and this action can take non-zero time when the gap (Next - OAT) has a big value and we have many concurrent attachments.
Currently we can`t see any info about elapsed time on START_TRANSACTION event:

. . .
2014-06-06T08:38:04.3700 (12862:0x7f1f86065988) START_TRANSACTION
        oltp30 (ATT_4291, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
        C:\MIX\firebird\fb25\bin\isql.exe:3772
                (TRA_3513899, CONCURRENCY | WAIT | READ_WRITE)

2014-06-06T08:38:04.3710 (12862:0x7f1f86065988) PREPARE_STATEMENT
. . .

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.