Flexible Parallelism
SingleStore supports Flexible Parallelism, which allows multiple cores on the same node to access the same database partition.
With Flexible Parallelism, as database partitions are created, they are divided into sub-partitions.
As an example, if you are currently at one partition per core with Flexible Parallelism, doubling the size of your workspace and then rebalancing will result in two cores for each partition.
Typically, analytic or hybrid transactional/analytic workloads will gain some benefits from Flexible Parallelism, especially over time as you add more hardware and rebalance workspaces.
As you add cores to your SingleStore system, you can reach a point where you have more cores than database partitions on each leaf node.
Note
When Flexible Parallelism is enabled, all new databases created will use Flexible Parallelism.
Flexible Parallelism is enabled by default for new workspaces in SingleStore Helios with the following settings:
-
One physical partition per leaf core at database creation time
-
16 sub-partitions per physical partition
-
One thread per leaf core per query
If you’re an existing customer who began using SingleStore Helios before May 2022, and wish to have Flexible Parallelism enabled for new databases, contact Support.
Note
SingleStore recommends lowering parallelism by setting query_
for high-throughput search workloads.
The default setting query_
indicates a parallelism of one thread per core for each query.
Last modified: January 27, 2025