<div dir="ltr"><div><div><div><br></div>1. Would say CDR_ODBC has a greater chance than CDR_CUSTOM (if I may call them both as such) to become a bottleneck under pressure ?<br><br></div>2. I didn't know about batch mode existence. Thanks for presenting it.<br></div>In such batch mode, where are stored CDRs before being written to files or database ? Does it also apply to data later found in cdr-scv/Master.csv file ?<br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-02-22 18:14 GMT+01:00 Richard Mudgett <span dir="ltr"><<a href="mailto:rmudgett@digium.com" target="_blank">rmudgett@digium.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><span class="">On Thu, Feb 22, 2018 at 5:23 AM, Olivier <span dir="ltr"><<a href="mailto:oza.4h07@gmail.com" target="_blank">oza.4h07@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>I'm load testing a new Asterisk 13 system (Debian Stretch, packaged asterisk).</div><div>One system writes CDR though an ODBC connection to a local Postgres database over the LAN.</div><div><br></div><div><br></div><div>When sending 50 new calls per second with SIPp, I'm seeing one system outputs :</div><div>taskprocessor.c: The 'subm:cdr_engine-00000003' task processor queue reached 5000 scheduled tasks again.<br></div><div><br></div><div>This [1] thread mentions such limit.</div><div><br></div><div>I was thinking of simply writing CDR entries to a local file before centralizing them into my database.</div><div><br></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">What would you suggest on this topic ?</span></div></div></blockquote><div><br></div></span><div>You should get better CDR performance enabling batch mode which is disabled by default for legacy reasons.<br></div><div><br></div><div>The CDR code processes all call events in one thread to create CDRs. This thread is what processes the <br>'subm:cdr_engine-00000003' task processor queue you mention above. If you don't have batch mode enabled <br>then that same thread also has to immediately write the CDRs to each back end configured. If you do have <br>batch mode enabled then the CDRs are passed to another thread to write to the back ends.<br><br></div><div>You need to be using at least v13.19.1 or v15.2.1 to also have some CDR performance enhancements to <br>help CDR processing of call events.<br><br></div><div>For information about ODBC connection pooling performance problems see [2].<br></div><div></div><div><br></div><div>Richard<br><br>[2] <a href="http://blogs.asterisk.org/2016/06/15/asterisk-odbc-connections/" target="_blank">http://blogs.asterisk.org/<wbr>2016/06/15/asterisk-odbc-<wbr>connections/</a><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span class=""><div dir="ltr"><div><br></div><div><br></div><div>Best regards</div><div><br></div><div>[1] <a href="http://lists.digium.com/pipermail/asterisk-dev/2016-June/075607.html" target="_blank">http://lists.digium.com/pi<wbr>permail/asterisk-dev/2016-June<wbr>/075607.html</a></div></div>
<br></span><span class="">--<br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.org<wbr>/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/wiki<wbr>/display/AST/Getting+Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailm<wbr>an/listinfo/asterisk-users</a><br></span></blockquote></div><br></div></div>
<br>--<br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br></blockquote></div><br></div>