asterisk users - Sep 2012 - MySQL InnoDB or MyISAM for CDR

Which one (InnoDB or MyISAM) is preferred for CDR as far as write performance is
concerned?

Thanks,
Matt
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120925/867917e8/attachment.htm>

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.

- Logan
On Sep 25, 2012 4:15 PM, "Matt Hamilton" <mistral9999 at
hotmail.com> wrote:
> Which one (InnoDB or MyISAM) is preferred for CDR as far as write
> performance is concerned?
>
> Thanks,
> Matt
>
> --
> _____________________________________________________________________
> -- 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/21bd3477/attachment.htm>

On Tuesday 25 September 2012, Matt Hamilton wrote:
> Which one (InnoDB or MyISAM) is preferred for CDR as far as write
> performance is concerned?
> 
> Thanks,
> Matt
MyISAM is faster  (on Linux anyway);  but you'd better have a UPS on the 
machine, because it is not very tolerant of unclean shutdowns.

-- 
AJS

Answers come *after* questions.