Issue Details (XML | Word | Printable)

Key: CORE-6178
Type: Improvement Improvement
Status: Open Open
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Pavel Zotov
Votes: 0
Watchers: 3

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

Trace: provide info about number of GEN_ID() calls, separately for each generator

Created: 31/Oct/19 11:48 AM   Updated: 01/Nov/19 02:53 PM
Component/s: Engine, TRACEMGR
Affects Version/s: None
Fix Version/s: None

File Attachments: None
Image Attachments:

1. trace-stat-for-number-of-gen_id-calls.png
(15 kB)

QA Status: No test

 Description  « Hide
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.

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