hi, there
Which cpu is best for memsql’s system?
Choose between 40 cores and 36 cores with better computing power.
I think 40 cores would be better to distribute more partitions per core since it’s an MPP structure, right?
I have another question.
Does the metadata stored in the aggregator remain in size? Is it increasing?
This is a question about how to configure the system with CA or MA.
Is nvme(ssd) recommended for MA or CA?
thanks in advance.
Hello chaeyoung.ko
Default partitions for a database is 8. So any multiple of 8 for number of cores is good.
The CA or MA does not store user data and hence disk space can be less than the leaves. Of course Metadata table size will depend on how many objects you have in your database. Recommend that you size accordingly.
Recommendations for disk types is here SingleStoreDB Cloud · SingleStore Documentation
We have some special commands for NVME drives.
Hope this helps,