Can a MemSQL Columnstore fall into enterprise edition?

Help
1

MemSQL provides a free tier with 128GB RAM utilization, I was searching but didn’t get appropriate result for my questions below,

  1. Does RAM utilization include all the process memory the executing the queries?
  2. If yes, if the process required more memory will the process be qued or will force to occupy extra memory?
  3. Finally, Can a MemSQL Columnstore fall into enterprise edition?

Thanks in advance.

2

Hi Jilani,

Please see answers to your questions below.

  1. Does RAM utilization include all the process memory the executing the queries?
    The 128GB RAM limit on free tier corresponds to the total RAM on all hosts/nodes. For example, 4 nodes with 32gb RAM each. This RAM can be used to store data in rowstore tables and execute queries.

  2. If yes, if the process required more memory will the process be qued or will force to occupy extra memory?
    If a particular query runs out of memory, it will try to utilize swap space if enabled. If it still isn’t able to secure enough memory, it will fail with an OOM error.

  3. Finally, Can a MemSQL Columnstore fall into enterprise edition?
    Yes, like all our other enterprise features, columnstore is available on free tier. Any free tier cluster can be converted into an enterprise cluster by updating the license key which will allow you to surpass the 128GB/4-node limit.

1 Like