[asterisk-users] MySQL InnoDB or MyISAM for CDR

Mitch Claborn mitch_ml at claborn.net
Wed Sep 26 09:08:09 CDT 2012

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

More information about the asterisk-users mailing list