mysql-5.6 icon indicating copy to clipboard operation
mysql-5.6 copied to clipboard

advisable to use many databases or many more tables?

Open hiqsociety opened this issue 1 year ago • 0 comments

the way rocksdb works, there's working memory setup (write cache) per rocksdb database.

i was wondering how does the architecture for myrocks?

if i create 65k databases, will it use memory setting per db or just the mysql instance?

read also some caveats and limitations from https://news.ycombinator.com/item?id=24486748

personally i had issue with out of disk space error and rocksdb was difficult to get running again after disk space was used up.

possible to provide a heads up on what else need to look for in myrocks implementation.

i'm coming back 2 years from first exploring myrocks

hiqsociety avatar Apr 01 '23 14:04 hiqsociety