<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Our top priority is the raw Write (INSERT) performance, Read (SELECT) performance is not important. Strict ACID compliance is not necessary either. MySQL (on a separate database server) should be able to handle inserting CDR records (approximately up to 10 records for each call) for about 1000 concurrent calls coming from an Asterisk cluster. <br> <br>Matt<br><br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">Date: Tue, 25 Sep 2012 18:19:50 -0500<br>From: logan@keobi.com<br>To: asterisk-users@lists.digium.com<br>Subject: Re: [asterisk-users] MySQL InnoDB or MyISAM for CDR<br><br><p dir="ltr">Very good point. For revenue critical data like CDRs, being ACID compliant is important.</p>
<p dir="ltr">MyISAM is compliant. And like InnoDB, can have the features making it compliant turned off. </p>
<div class="ecxgmail_quote">On Sep 25, 2012 6:12 PM, "Patrick Lists" <<a href="mailto:asterisk-list@puzzled.xs4all.nl">asterisk-list@puzzled.xs4all.nl</a>> wrote:<br><blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex">
On 09/25/2012 11:18 PM, Logan Bibby wrote:<br>
<blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex">
MyISAM would be best, in my opinion. The features that cause the little<br>
bit of performance overhead in InnoDB wouldn't be necessary for CDR storage.<br>
</blockquote>
<br>
Iirc InnoDB is ACID compliant so might be preferable if MyISAM is not. More information here:<br>
<br>
<a href="http://en.wikipedia.org/wiki/ACID" target="_blank">http://en.wikipedia.org/wiki/<u></u>ACID</a><br>
<br>
<a href="https://blogs.oracle.com/MySQL/entry/comparing_innodb_to_myisam_performance" target="_blank">https://blogs.oracle.com/<u></u>MySQL/entry/comparing_innodb_<u></u>to_myisam_performance</a><br>
<br>
Regards,<br>
Patrick<br>
<br>
<br>
--<br>
______________________________<u></u>______________________________<u></u>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/<u></u>mailman/listinfo/asterisk-<u></u>users</a><br>
</blockquote></div>
<br>--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users</div> </div></body>
</html>