Execution of SET STATISTICS INDEX statement could block execution of concurrent
attachments
-------------------------------------------------------------------------------------------
Key: CORE-4215
URL: http://tracker.firebirdsql.org/browse/CORE-4215
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2,
2.1.5, 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 3.0 Initial, 2.1.3, 2.1.2, 2.0.5,
2.1.1, 2.1.0
Reporter: Vlad Khorsun
BTR_selectivity() walks the whole leaf level of given index b-tree to calculate
index selectivity.
During whole process there is no resheduling points in the engine. It block's
concurrent
attachment's AST requests such as page lock requests, monitoring, cancellation
etc.
--
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
------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
