Trace: provide elapsed time for event START_TRANSACTION
-------------------------------------------------------

                 Key: CORE-4450
                 URL: http://tracker.firebirdsql.org/browse/CORE-4450
             Project: Firebird Core
          Issue Type: Improvement
          Components: TRACEMGR
    Affects Versions: 3.0 Alpha 2
            Reporter: Pavel Zotov
            Priority: Minor


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
. . .

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their 
applications. Written by three acclaimed leaders in the field, 
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to