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-l...@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> >
-- _____________________________________________________________________ -- 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