[Asterisk-Dev] cdr*sql

[Mike Machado]

On a side note, have you thought about using innodb table types? Its
much friendlier when it comes to locks (row locks instead of table
locks).

On Fri, 2005-05-20 at 15:07 -0500, Matthew Simpson wrote:
> Howdy,
> 
> I'm using cdr_mysql on around 20 asterisk boxes dumping into one SQL 
> cluster.  I've noticed that if the SQL server locks the CDR table [when 
> doing a DELETE query, for instance] or gets busy otherwise from a large 
> select, that it causes call failures on the Asterisk boxes.  Running 
> channels get dropped and new channels can't/won't start.
> 
> I intend to work on a patch for cdr_mysql to fix this, but I don't know 
> enough about asterisk internals to understand why it causes so much havoc. 
> Is there a lock placed on the channel when a CDR is written ?
> 
> yours,
> matthew
> 
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev