Trace: provide info about number of GEN_ID() calls, separately for each
generator
---------------------------------------------------------------------------------
Key: CORE-6178
URL: http://tracker.firebirdsql.org/browse/CORE-6178
Project: Firebird Core
Issue Type: Improvement
Components: Engine, TRACEMGR
Reporter: Pavel Zotov
Priority: Minor
Attachments: trace-stat-for-number-of-gen_id-calls.png
It will be useful to show new kind of information in the trace log: number
(frequency) of GEN_ID() calls which could lead to low-level contention for
generators page under heavy concurrent workload.
Currently one may to see such contention in the output of fb_lock_print by
analyzing data related to pending requests count.
But even when we found it, the name of problematic sequence remain unknown. The
real problem is that *single* generator page contains data of hundred
sequences. So, if one application decide to intensively change some "dedicated"
sequence then all other connections will get influence of this activity.
Display of runtime statistics after each statement and PSQL block (proc, func,
trigger) will be useful for searching of bottle-neck places in application
design. This new block of statistics can be shown in form from attached picture.
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
