[MCOL-797] Need to clear some doubts Created: 2017-07-03  Updated: 2020-11-09  Resolved: 2020-11-09

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Developer Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

I need to clear few concepts and doubts as below.
1 > How MariaDB Columnstore behave when I will run 3 queries at a same time (parallel)?
2 > Does mariaDB support parallel processing of queries? If yes what configurations I need to do?
3 > Is there any performance difference in single server (UM and PM on same server having 16 cores) and multi server (1 UM and 3 PM having each PM 4 cores and UM 8 cores) architecture?
Please help me to clear concepts.

Thank You.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-07-03 ]

1. If they are SELECT queries then it will behave fine. Writes are locking so multiple write queries at the same time on the same table will wait until another one has completed.
2. Yes it does, it breaks the queries down into job steps and executes those steps in parallel. You do not need to change the configuration for this.
3. RAM quantity and disk performance also plays a factor so it is difficult to gauge just on CPU count. The PMs will use all the cores available though.

Comment by Developer [ 2017-07-04 ]

Thank You Andrew.

Can you suggest what should be best hardware configuration to accelerate my query performance?
You can get idea about my query details from issue #790
https://jira.mariadb.org/browse/MCOL-790

FYI, We have upgraded system to 1 UM and 3 PM having each PM 8 cores and UM 8 cores and all has 32 GB RAM. For storage we have external HD as AWS EFS system. All our UM and PM are AWS instances.

Also suggest me some key variables on mariadb which we can change to improve query performance. Variables LIKE sort_buffer_size

Thank You.

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