[MCOL-717] Number of threads that ColumnStore use Created: 2017-05-12  Updated: 2017-06-05  Resolved: 2017-06-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: Documentation
Affects Version/s: None
Fix Version/s: Icebox

Type: Task Priority: Major
Reporter: Seungmin Yang Assignee: David Thompson (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

I wonder how many threads run, for example, while PrimProc is running.
How many threads do MariaDB ColumnStore execute?
Does it equate to the number of CPU cores?

In addition, could you let me know how I can limit the number of threads if it's possible?

Thank you!



 Comments   
Comment by David Thompson (Inactive) [ 2017-05-12 ]

Please review: https://mariadb.com/kb/en/mariadb/mariadb-columnstore-performance-related-configuration-settings/

This covers the main tuning parameters. These are not necessarily directly correlated with the number of threads utilized. In general columnstore will try to create as many threads as possible to reduce processing time of the primitive tasks.

Can i ask why you want to limit the the number of threads? Generally columnstore is designed to consume the resources available to it. You could artifically do this using virtual machines if you are trying to share a very large physical server.

Generated at Thu Feb 08 02:23:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.