[asterisk-users] MySQL InnoDB or MyISAM for CDR

Logan Bibby logan at keobi.com
Tue Sep 25 18:19:50 CDT 2012


Very good point. For revenue critical data like CDRs, being ACID compliant
is important.

MyISAM is compliant. And like InnoDB, can have the features making it
compliant turned off.
On Sep 25, 2012 6:12 PM, "Patrick Lists" <asterisk-list at puzzled.xs4all.nl>
wrote:

> On 09/25/2012 11:18 PM, Logan Bibby wrote:
>
>> MyISAM would be best, in my opinion. The features that cause the little
>> bit of performance overhead in InnoDB wouldn't be necessary for CDR
>> storage.
>>
>
> Iirc InnoDB is ACID compliant so might be preferable if MyISAM is not.
> More information here:
>
> http://en.wikipedia.org/wiki/**ACID <http://en.wikipedia.org/wiki/ACID>
>
> https://blogs.oracle.com/**MySQL/entry/comparing_innodb_**
> to_myisam_performance<https://blogs.oracle.com/MySQL/entry/comparing_innodb_to_myisam_performance>
>
> Regards,
> Patrick
>
>
> --
> ______________________________**______________________________**_________
> -- 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<http://lists.digium.com/mailman/listinfo/asterisk-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120925/b379b556/attachment-0001.htm>


More information about the asterisk-users mailing list