You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2018/07/04 12:01:00 UTC
[jira] [Updated] (IGNITE-8925) SQL: Limit default number of threads
for CREATE INDEX to 4
[ https://issues.apache.org/jira/browse/IGNITE-8925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov updated IGNITE-8925:
------------------------------------
Description:
Currently we allocate {{CPUs/4}} cores for index creation. On powerful machines we may allocate too much threads, so that "Maximum number of retries" error start to appear in {{BPlusTree}}.
We need to limit default number of allocated cores to 4, because:
- Our original benchmarks shown that >4 cores do not give significant boost (due to retries and page splits)
- Avoid "too much retries" error
was:
Currently we allocate {{CPUs / 4}} cores for index creation. On powerful machines we may allocate too much threads, so that "Maximum number of retries" error start to appear in {{BPlusTree}}.
We need to limit default number of allocated cores to 4, because:
- Our original benchmarks shown that >4 cores do not give significant boost (due to retries and page splits)
- Avoid "too much retries" error
> SQL: Limit default number of threads for CREATE INDEX to 4
> ----------------------------------------------------------
>
> Key: IGNITE-8925
> URL: https://issues.apache.org/jira/browse/IGNITE-8925
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Vladimir Ozerov
> Assignee: Vladimir Ozerov
> Priority: Major
> Fix For: 2.7
>
>
> Currently we allocate {{CPUs/4}} cores for index creation. On powerful machines we may allocate too much threads, so that "Maximum number of retries" error start to appear in {{BPlusTree}}.
> We need to limit default number of allocated cores to 4, because:
> - Our original benchmarks shown that >4 cores do not give significant boost (due to retries and page splits)
> - Avoid "too much retries" error
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)