Some new mnesia benchmarking results
Wed Nov 7 13:13:00 CET 2001
I just spent some time benchmarking mnesia for huge disk_copies tables with
the latest versions. Measurements on a SPARC 400MHz with Veritas FS.
Create a table with 1 million rows:
R7B-1 with mnesia-3.10.0 310 secs
R8B with mnesia-4.0 315 secs
R8B with 10 threads 270 secs
Beam process size afterwards
R8B threads 158M
R7B-1 with mnesia-3.10.0 155 secs (and whole node is blocked)
R8B with mnesia-4.1 3.7 secs
R8B threads 15 secs
Start mnesia and wait for 1M row table to be available
R7B-1 25 to 50 secs
R8B 30 secs
R8B threads 56 secs
Subsequent stop of mnesia
R7B-1 1.9 secs
R8B 12 secs
R8B threads 25 secs
Start up mnesia after CTRL-C CTRL-C stopping node which is writing as fast
as possible. (Noting disk log repair of DCL file messages on startup).
R7B-1 40 secs maximum.
R8B 40 secs
R8B threads 61 secs
Apart from quite a lot of variability in timer:tc results it would appear
that the old behaviour of mnesia where it could potentially take hours to
rebuild tables from badly closed dets tables has been completely cured.
Perhaps someone could confirm that this is always the case and I have not
just been lucky in the timing of my node kills!
I wonder also if anyone knows of any other reasons not to use mnesia for
large databases now?
NOTICE AND DISCLAIMER:
This email (including attachments) is confidential. If you have received
this email in error please notify the sender immediately and delete this
email from your system without copying or disseminating it or placing any
reliance upon its contents. We cannot accept liability for any breaches of
confidence arising through use of email. Any opinions expressed in this
email (including attachments) are those of the author and do not necessarily
reflect our opinions. We will not accept responsibility for any commitments
made by our employees outside the scope of our business. We do not warrant
the accuracy or completeness of such information.
More information about the erlang-questions