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. Matt
Date: Tue, 25 Sep 2012 18:19:50 -0500 From: lo...@keobi.com To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] MySQL InnoDB or MyISAM for CDR 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 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 -- _____________________________________________________________________ -- 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
-- _____________________________________________________________________ -- 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