<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="gmail_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 type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 09/25/2012 11:18 PM, Logan Bibby wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;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>