Mnesia Load

Thinus Pollard <>
Thu Jan 5 09:02:03 CET 2006


Good day

We have a problem(?) with mnesia loading times. This application runs on a
dual xeon machine with a lot of memory. Upon startup we have to wait for
all our tables to become available:

=INFO REPORT==== 5-Jan-2006::09:19:49 ===
Waiting for mnesia to become available

=INFO REPORT==== 5-Jan-2006::09:31:05 ===
Mnesia load done

As you can see, it takes just over 11 minutes for it to load completely.

A mnesia:dump_to_textfile() is about 116Mb in size.

Is there any way to speed things up?

Thanks
Thinus

mnesia:info()
---> Processes holding locks <---
---> Processes waiting for locks <---
---> Participant transactions <---
---> Coordinator transactions <---
---> Uncertain transactions <---
---> Active tables <---
afm_connect    : with 1        records occupying 364      words of mem
afm_eft_hdr    : with 1305     records occupying 96958    words of mem
afm_adm_hdr    : with 148      records occupying 11618    words of mem
afm_eft_trl    : with 1293     records occupying 98860    words of mem
afm_adm_trl    : with 98       records occupying 5895     words of mem
afm_hdr        : with 1355     records occupying 131865   words of mem
afm_fti        : with 21       records occupying 2196     words of mem
afm_bin        : with 67902    records occupying 17970584 words of mem
afm_eft_det    : with 101184   records occupying 22059861 words of mem
afm_adm_det    : with 80319    records occupying 11627724 words of mem
schema         : with 12       records occupying 1859     words of mem
fsn_state      : with 1        records occupying 304      words of mem
===> System info in version "4.1.12", debug level = none <===
opt_disc. Directory "/home/afm/afm/trunk/db_data/afm" is used.
use fallback at restart = false
running db nodes   = ['']
stopped db nodes   = []
master node tables = []
remote             = []
ram_copies         = []
disc_copies        = [afm_adm_det,
                      afm_adm_hdr,
                      afm_adm_trl,
                      afm_bin,
                      afm_connect,
                      afm_eft_det,
                      afm_eft_hdr,
                      afm_eft_trl,
                      afm_fti,
                      afm_hdr,
                      fsn_state,
                      schema]
disc_only_copies   = []
[{'',disc_copies}] = [fsn_state,
                                                   schema,
                                                   afm_adm_det,
                                                   afm_eft_det,
                                                   afm_bin,
                                                   afm_fti,
                                                   afm_hdr,
                                                   afm_adm_trl,
                                                   afm_eft_trl,
                                                   afm_adm_hdr,
                                                   afm_eft_hdr,
                                                   afm_connect]
639 transactions committed, 0 aborted, 0 restarted, 309 logged to disc
0 held locks, 0 in queue; 0 local transactions, 0 remote
0 transactions waits for other nodes: []
ok




More information about the erlang-questions mailing list