[asterisk-users] MySQL InnoDB or MyISAM for CDR

[Matt Hamilton]

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: logan at keobi.com
To: asterisk-users at 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-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



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 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120925/3bba39f1/attachment.htm>