[asterisk-users] MySQL InnoDB or MyISAM for CDR

Lenz Emilitri lenz.loway at gmail.com
Thu Sep 27 03:23:35 CDT 2012

I'd go for MyISAM and would set up a remote replica if data integrity is

If you have like 1000 calls of (say) 30 seconds avg length, and you create
10 events per call, you would expect an event every three seconds. This is
about 300 inserts per second. Say 600 at peaks. This should be feasible
with server-grade hardware without much difficulty. Also as you always
INSERT it behaves as a log file (no seeking, no locking) if the table is

2012/9/26 Matt Hamilton <mistral9999 at hotmail.com>

> 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

Loway - home of QueueMetrics - http://queuemetrics.com
Test-drive WombatDialer beta @ http://wombatdialer.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120927/2f607cd6/attachment.htm>

More information about the asterisk-users mailing list