[erlang-questions] How to speed up mnesia startup?
Thu Apr 12 11:26:30 CEST 2012
Hmm, the first thing that stands out is the inordinate number of tables.
Out of curiosity, I tried figuring out what is considered a reasonable number of tables for other database management systems:
- Oracle: over 10,000 tables considered insane
- Postgres: 10,000 tables works fine; practical limit (on ext3) probably 32k
- MySQL Server: no apparent problems
There may be some serialization happening that slows down the table loads. Mnesia is not optimized for this many tables.
On 12 Apr 2012, at 10:35, Kyungho Yun wrote:
> It usually takes 50 minutes to startup mnesia.
> It is too long.
> Here is my conditions:
> - DB exists local
> - more than 60000 tables
> - sum size is about 28 Giga Bytes.
> - most tables created options with record_name, attributes(and record_info()) and disc_only_copies.
> - startup after normal exit (not crash)
> - R14B04, no_table_loaders 10000
> I've searched many websites, read documents here and other places, changed options.
> but the elapse of mnesia startup wasn't decrease.
> Here is what I controlled:
> - ulimit -n
> - no_table_loader, +A, +K, +P, +zdbbl, dc_dump_limit
> - add option local_content when create table
> - io schedule type
> finally, I am curious mnesia I/O ability.
> few blocks/s value(about 2000) is shown in iostat during mnesia startup,
> but it's very big blocks/s value (bigger than 100000) is shown during copy something.
> How to speed up mnesia startup?
> Tell me a clue please.
> erlang-questions mailing list
Ulf Wiger, Co-founder & Developer Advocate, Feuerlabs Inc.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the erlang-questions