<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1505" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=562555912-10082005>Mnesia
is different from MySQL in several ways. Whether or not the differences are in
Mnesia's favour certainly depends on what you need to do:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=562555912-10082005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=562555912-10082005>- No
semantic gap for erlang programmers. Mnesia operates directly on Erlang
terms</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=562555912-10082005> and uses Erlang semantics for
accesses</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=562555912-10082005>- Low
latency. E.g. dirty_read from a mnesia table takes only a few microseconds.
There is no way you </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=562555912-10082005>
can read a MySQL object as quickly. This assumes that your application is
written in erlang, of course.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=562555912-10082005>-
In-service upgrade. Mnesia can be upgraded without service
interruption.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=562555912-10082005>-
Small memory footprint (not that I know how much MySQL uses)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=562555912-10082005><FONT face=Arial color=#0000ff size=2>There
are certainly other differences. I'll let someone else
continue.</FONT></SPAN></DIV>
<DIV><SPAN class=562555912-10082005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=562555912-10082005><FONT face=Arial color=#0000ff
size=2>/Uffe</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
owner-erlang-questions@erlang.org
[mailto:owner-erlang-questions@erlang.org]<B>On Behalf Of </B>Inswitch
Solutions<BR><B>Sent:</B> den 10 augusti 2005 14:56<BR><B>To:</B>
erlang-questions@erlang.org<BR><B>Subject:</B> Mnesia vs
MySQL<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MySql database has been improved a lot and
we are evaluating it using ODBC Erlang application.</FONT></DIV>
<DIV><FONT face=Arial size=2>As far as I know MySql has all mnesia features
(</FONT><FONT face=Arial size=2>replicas, distribution, ..), plus GUI
administration and SQL.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What points in favour does Mnesia database have
over MySQL? Perfomarnce issues?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks, Eduardo</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<TABLE width="77%" border=0>
<TBODY>
<TR>
<TD vAlign=top width="16%"><IMG src="cid:562555912@10082005-15ca"></TD>
<TD vAlign=top width="84%">
<P><B><FONT face=Verdana color=#000099 size=1>Prepaid Expertise -
Programmable Switches <BR>Powered by Ericsson Licensed
Technology<BR>Eng. Eduardo Figoli - Development Center - IN Switch
Solutions Inc.<BR>Headquarters - Miami-U.S.A. Tel: 1305-3578076 Fax:
1305-7686260<BR>Development Center - Montevideo - Uruguay Tel/Fax:
5982-7104457<BR>e-mail: <A
href="mailto:eduardo@inswitch.us">eduardo@inswitch.us</A></FONT><FONT
face=Verdana color=blue
size=1><BR></FONT></B></P></TD></TR></TBODY></TABLE><B><FONT face=Verdana
color=blue size=1></FONT></B></DIV></BLOCKQUOTE></BODY></HTML>