Issue Details (XML | Word | Printable)

Key: CORE-4215
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 2
Watchers: 5
Operations

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

Execution of SET STATISTICS INDEX statement could block or slow execution of concurrent attachments

Created: 11/Sep/13 10:24 AM   Updated: 21/Aug/16 05:54 AM
Component/s: Engine
Affects Version/s: 2.1.0, 2.1.1, 2.0.5, 2.1.2, 2.1.3, 3.0 Initial, 2.0.6, 2.5.0, 2.1.4, 2.5.1, 2.0.7, 2.1.5, 2.5.2, 2.1.5 Update 1, 2.5.2 Update 1, 3.0 Alpha 1
Fix Version/s: 3.0 Alpha 2, 2.5.3

QA Status: Deferred
Test Details:
Creation of huge table on the fly is not allowed - we can not waste time for this while all tests running.
Database with huge table should be preliminary created (seperately for every ODS) and committed on test running host.
It seems to me that this is also undesirable.
Waiting for other suggestions how to implement such test.


 Description  « Hide
BTR_selectivity() walks the whole leaf level of given index b-tree to calculate index selectivity.
During whole process rescheduling points in the engine happens only at disk IO operations.
Therefore concurrent attachment's AST requests such as page lock requests, monitoring,
cancellation, etc could wait too long.

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