Max number of collections / indexes with PerconaFT

[flozano]

I’ve tried to find the information myself but I couldn’t, so here it goes:

What is the max number of collections+indexes a single node can have when using PerconaFT? WiredTiger uses file per collection + file per index, which effectively limits the amount substantially. RocksDB works well for huge numbers (N millions), and I would like to confirm PerconaFT engine’s technical limits on this.

[luis.contreras]

Hi Flozano,

By default its 24000 names spaces in the 16 MB file, also each collection can only have 64 indexes. This means if you have 1 index per collection you can have 24k collections but at 64 indexes per collection you can have 375.

I hope that info helps you.

regards,