How to know the number of partitions for each database?

Help
1

How to know the number of partitions in a cluster?
How does the total number of partitions of all databases impact the performance of the cluster?

How many cpu cores are allocated to a single partitions and the memory allocated to a partition?

1 Like
2

Hello Navin,
By default the number of partitions in a cluster when a database is created should match your number of CPUs with the ratio 1:1. This is our recommendation. You can get more information about partitions in your database by using the function
SHOW PARTITIONS EXTENDED ON <database_name>;

More information about this command here : SHOW PARTITIONS · SingleStore Documentation

1 Like