Not the answer you need?
Register and ask your own question!

Max number of collections / indexes with PerconaFT

flozanoflozano EntrantCurrent User Role Beginner
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.

Comments

  • luis.contrerasluis.contreras Member Inactive User Role Beginner
    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,
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.