Re: SMS sending speed slows down when a new DB server connected
Sayed Hadi Rastgou Haghi <[email protected]> Thu, 27 Mar 2025 12:33:25 +0330
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <CADEkTo1zFEtGrhvxa=--q2f6NJgLYTa2gwNRgGFwmpK76GhwgA@mail.gmail.com> |
--000000000000abb37106314f3aa9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Dear Biswajit, you may disable mysql dns lookups to remove unnecessary time used for remote host lookups by mysql thus improving speed. https://nixcp.com/skip-name-resolve/ On Tue, Mar 18, 2025 at 6:52=E2=80=AFAM Biswajit Kumar <biswajit@banglaphon= e.net.bd> wrote: > Hi, > > Kannel application is on Ubuntu 20.04, as it had compilation error in > Ubuntu 22.04. > *Thanks and Regards,* > * Biswajit Kumar* | AGM, P&D > Bangla Phone Ltd. <http://www.banglaphone.net.bd/> | +8801833103909 > On 3/18/2025 4:24 AM, Mesbahuddin Malik wrote: > > How did Compile Kannel on Ubuntu 22.04 with which gcc version ? > > Regards > Mesbah > +8801833055942 > > On Mon, Mar 17, 2025 at 11:12=E2=80=AFAM Biswajit Kumar < > [email protected]> wrote: > >> Dear fellow users, >> >> I am having a peculiar problem trying to replace the MySQL database >> server which works on my Kannel application server. >> >> I have Kannel application in separate VM, and MySQL database in another. >> So far I understood and have been working with Kannel is that my Kannel = has >> SQLBox installed, which picks SMS from kannelDb.send_sms table and store= s >> in local redis, then sends to SMPP smsc and writes to kannelDb.sent_sms >> table of the MySQL server. >> >> My Kannel application information is as below: >> >> Kannel bearerbox version `1.4.5'. Build `Jan 10 2024 17:30:02', compiler >> `9.4.0'. System Linux, release 5.4.0-170-generic, version #188-Ubuntu SM= P >> Wed Jan 10 09:51:01 UTC 2024, machine x86_64. Hostname localhost, IP >> 127.0.0.1. Libxml version 2.9.10. Using OpenSSL 1.1.1f 31 Mar 2020. >> Compiled with MySQL 5.7.42, using MySQL 5.7.42. Using hiredis API 1.2.0 >> Using native malloc. >> >> Kannel application server is installed on a Ubuntu 20.04.6 LTS. And my >> running MySQL server is running on a Ubuntu 22.04.3 LTS, MySQL version >> 8.0.36 (VM1). Now, when the application is running with this DB server, = the >> performance is smooth. The throughput of my SMPP SMSC are 100 each in 4 >> separate SMSC, so I see that kannelDb.send_sms table clears up almost >> instantly. But, I have a problem with the running DB server VM physical >> host machine; and for this, I need to shift the DB server in another VM.= I >> have tried with two separate VMs: one with Ubuntu 22.04.3 LTS with MySQL >> 8.0.36 (VM2) and another with Ubuntu 22.04.3 with MySQL 8.0.41 (VM3). Bu= t >> strangely whenever I try to run Kannel with VM2 or VM3, the performance >> gets really low. Entries of kannelDb.send_sms does not get cleared as fa= st >> as it does with VM1; instead, I get only around 10 TPS in sending SMS. >> >> Can anyone please suggest what can be the issue? I have the same >> configuration for MySQL in all the three database server VMs. And I use = the >> working IP address of VM1 whenever I try with either VM2 or VM3. But can= not >> find out the reason for the problem. Please help. >> >> Please let me know if you need any further information. >> -- >> *Thanks and Regards,* >> * Biswajit Kumar* | AGM, P&D >> Bangla Phone Ltd. <http://www.banglaphone.net.bd/> | +8801833103909 >> > --=20 Sincerely, Sayed Hadi Rastgou Haghi --000000000000abb37106314f3aa9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Dear Biswajit,<div>you may disable mysql dns lookups to re= move unnecessary=C2=A0time used for remote host lookups by mysql thus impro= ving speed.</div><div><br></div><div><a href=3D"https://nixcp.com/skip-name= -resolve/">https://nixcp.com/skip-name-resolve/</a></div><div><br></div></d= iv><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" cl= ass=3D"gmail_attr">On Tue, Mar 18, 2025 at 6:52=E2=80=AFAM Biswajit Kumar &= lt;<a href=3D"mailto:[email protected]">[email protected].= bd</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margi= n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex= "><u></u> =20 =20 =20 <div> <p><font face=3D"Helvetica, Arial, sans-serif">Hi,</font></p> <p><font face=3D"Helvetica, Arial, sans-serif">Kannel application is on Ubuntu 20.04, as it had compilation error in Ubuntu 22.04.<br> </font></p> <div><span style=3D"font-family:"Book Antiqua""><em>Thanks an= d Regards,</em> </span><br> <strong><span style=3D"font-family:"Trebuchet MS""> Biswaji= t Kumar</span></strong> | <span style=3D"font-family:"Book Antiqua"">AGM, P&D <= a href=3D"http://www.banglaphone.net.bd/" rel=3D"noopener" target=3D"_blank= "><br> <span style=3D"color:rgb(255,0,0)">Bangla</span> <span style=3D"c= olor:rgb(0,255,0)">Phone</span> <span style=3D"color:rgb(0,0,255)">Ltd.</sp= an></a> | <span style=3D"color:rgb(0,0,0)"><a href=3D"tel:+8801833103909" r= el=3D"noopener" target=3D"_blank"><span style=3D"color:rgb(0,0,0)">+8801833= 103909</span></a></span></span></div> <div>On 3/18/2025 4:24 AM, Mesbahuddin Malik wrote:<br> </div> <blockquote type=3D"cite"> =20 <div dir=3D"ltr">How did Compile Kannel on Ubuntu 22.04 with which gcc version ? <div><br> </div> <div>Regards</div> <div>Mesbah</div> <div>+8801833055942<br> </div> </div> <br> <div class=3D"gmail_quote"> <div dir=3D"ltr" class=3D"gmail_attr">On Mon, Mar 17, 2025 at 11:12=E2=80=AFAM Biswajit Kumar <<a href=3D"mailto:biswajit@ba= nglaphone.net.bd" target=3D"_blank">[email protected]</a>> wrote:<br> </div> <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex= ;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <div> <p><font face=3D"Helvetica, Arial, sans-serif">Dear fellow users,</font></p> <p><font face=3D"Helvetica, Arial, sans-serif">I am having a peculiar problem trying to replace the MySQL database server which works on my Kannel application server.</font><= /p> <p><font face=3D"Helvetica, Arial, sans-serif">I have Kannel application in separate VM, and MySQL database in another. So far I understood and have been working with Kannel is that my Kannel has SQLBox installed, which picks SMS from kannelDb.send_sms table and stores in local redis, then sends to SMPP smsc and writes to kannelDb.sent_sms table of the MySQL server. <br> </font></p> <p><font face=3D"Helvetica, Arial, sans-serif">My Kannel application information is as below: <br> <br> </font><span style=3D"color:rgb(0,0,0);font-family:"Time= s New Roman";font-size:medium;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;word-spacing:0px;white-spa= ce:normal;text-decoration-style:initial;text-decoration-color:initial;float= :none;display:inline">Kannel bearerbox version `1.4.5'. Build `Jan 10 2024 17:30:02&= #39;, compiler `9.4.0'. System Linux, release 5.4.0-170-generic, version #188-Ubuntu SMP Wed Jan 10 09:51:01 UTC 2024, machine x86_64. Hostname localhost, IP 127.0.0.1. Libxml version 2.9.10. Using OpenSSL 1.1.1f 31 Mar 2020. Compiled with MySQL 5.7.42, using MySQL 5.7.42. Using hiredis API 1.2.0 Using native malloc.</span></p> <p><font face=3D"Helvetica, Arial, sans-serif"><span style=3D"c= olor:rgb(0,0,0);font-size:medium;font-style:normal;font-variant-ligatures:n= ormal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-a= lign:start;text-indent:0px;text-transform:none;word-spacing:0px;white-space= :normal;text-decoration-style:initial;text-decoration-color:initial;float:n= one;display:inline">Kannel application server is installed on a Ubuntu 20.04.6 LTS. And my running MySQL server is running on a Ubuntu 22.04.3 LTS, MySQL version 8.0.36 (VM1). Now, when the application is running with this DB server, the performance is smooth. The throughput of my SMPP SMSC are 100 each in 4 separate SMSC, so I see that kannelDb.send_sms table clears up almost instantly. But, I have a problem with the running DB server VM physical host machine; and for this, I need to shift the DB server in another VM. I have tried with two separate VMs: one with Ubuntu 22.04.3 LTS with MySQL 8.0.36 (VM2) and another with Ubuntu 22.04.3 with MySQL 8.0.41 (VM3). But strangely whenever I try to run Kannel with VM2 or VM3, the performance gets really low. Entries of kannelDb.send_sms does not get cleared as fast as it does with VM1; instead, I get only around 10 TPS in sending SMS.</span></font></p> <p><font face=3D"Helvetica, Arial, sans-serif"><span style=3D"c= olor:rgb(0,0,0);font-size:medium;font-style:normal;font-variant-ligatures:n= ormal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-a= lign:start;text-indent:0px;text-transform:none;word-spacing:0px;white-space= :normal;text-decoration-style:initial;text-decoration-color:initial;float:n= one;display:inline">Can anyone please suggest what can be the issue? I have the same configuration for MySQL in all the three database server VMs. And I use the working IP address of VM1 whenever I try with either VM2 or VM3. But cannot find out the reason for the problem. Please help.</span></font></p> <p><font face=3D"Helvetica, Arial, sans-serif"><span style=3D"c= olor:rgb(0,0,0);font-size:medium;font-style:normal;font-variant-ligatures:n= ormal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-a= lign:start;text-indent:0px;text-transform:none;word-spacing:0px;white-space= :normal;text-decoration-style:initial;text-decoration-color:initial;float:n= one;display:inline">Please let me know if you need any further information.<br> </span></font></p> <div>-- <br> <span style=3D"font-family:"Book Antiqua""><em>Than= ks and Regards,</em> </span><br> <strong><span style=3D"font-family:"Trebuchet MS""> Biswajit Kumar</span></strong> | <span style=3D"font-fami= ly:"Book Antiqua"">AGM, P&D <a href=3D"http://www.banglaphone.net.bd/" rel=3D"n= oopener" target=3D"_blank"><br> <span style=3D"color:rgb(255,0,0)">Bangla</span> <span st= yle=3D"color:rgb(0,255,0)">Phone</span> <span style=3D"color:rgb(0,0,255)">= Ltd.</span></a> | <span style=3D"color:rgb(0,0,0)"><a href=3D"tel:+88018331= 03909" rel=3D"noopener" target=3D"_blank"><span style=3D"color:rgb(0,0,0)">= +8801833103909</span></a></span></span></div> </div> </blockquote> </div> </blockquote> </div> </blockquote></div><div><br clear=3D"all"></div><div><br></div><span class= =3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s= ignature"><div dir=3D"ltr">Sincerely,<br><br>Sayed Hadi Rastgou Haghi<br></= div></div> --000000000000abb37106314f3aa9--