[asterisk-users] MySQL InnoDB or MyISAM for CDR

[Mitch Claborn]

If I remember correctly, INNODB offers row level locking while MyISAM 
does not.


On 09/26/2012 05:18 AM, Thorsten Göllner wrote:
> Am 26.09.2012 10:45, schrieb A J Stiles:
>> 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.
>
> You should not havy any problem on inserting into MyISAM or InnoDB - for
> my opinion. How many calls do you expect? And consider the following:
> the insert query is done by atserisk after hagnup. So your user will not
> notice it.
>
> --
> _____________________________________________________________________
> -- 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
>