<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="monospace">Hi Denys.<br>
      <br>
      That is rather weird, 250 certificates in 1 min. I assume it is
      not a DB issue (considering the db_text backend), so can you try
      to do multiple sequential "opensips-cli -x trap" to try to
      understand what is going on ?<br>
      <br>
      Regards,<br>
    </font>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
  <a class="moz-txt-link-freetext" href="https://www.siphub.com">https://www.siphub.com</a></pre>
    <div class="moz-cite-prefix">On 02.05.2024 11:41, Denys Pozniak
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+x3AxreQHiK6dG5HxCdYFTfAfsqMr92NzvXrRO2Ucf=fDm4KQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hello!
        <div><br>
        </div>
        There is a task to divide a single tls/ssl letsencrypt
        certificate for white labels into specific ones.
        <div>I entered about ~250 certificates into db_text, but as it
          turned out, for OpenSIPS this is a rather complex operation to
          load them and takes about 1 minute and a heavy CPU load is
          noticeable.
          <div><br>
          </div>
          <div>I would appreciate any advice on how to avoid this.<br>
          </div>
          <div><br>
          </div>
          <div># wc -l dbtext/tls_mgm<br>
            253 dbtext/tls_mgm<br>
          </div>
          <div><br>
          </div>
          <div># time opensips-cli -x mi tls_reload
            <div>"OK"</div>
            <div>real 0m52.034s</div>
            <div>user 0m1.419s</div>
            <div>sys 0m0.433s</div>
            <div><br>
            </div>
            <div># time systemctl restart opensips<br>
              real    0m58.198s<br>
              user    0m0.024s<br>
              sys     0m0.055s<br>
              <div><span class="gmail_signature_prefix"><br>
                </span></div>
              <div><span class="gmail_signature_prefix"># opensips -V<br>
                  version: opensips 3.4.4 (x86_64/linux)<br>
                  flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP,
                  PKG_MALLOC, Q_MALLOC, F_MALLOC, HP_MALLOC, DBG_MALLOC,
                  FAST_LOCK-ADAPTIVE_WAIT<br>
                  ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
                  MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535<br>
                  poll method support: poll, epoll, sigio_rt, select.<br>
                  git revision: 036d02961<br>
                </span></div>
              <div><span class="gmail_signature_prefix"><br>
                </span></div>
              <div><span class="gmail_signature_prefix">-- </span><br>
                <div dir="ltr" class="gmail_signature"
                  data-smartmail="gmail_signature">
                  <div dir="ltr"><br>
                    <div>
                      <div>BR,</div>
                      <div>Denys Pozniak<br>
                      </div>
                      <div><br>
                      </div>
                      <div><br>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="moz-mime-attachment-header"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>