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 AM Biswajit Kumar <biswa...@banglaphone.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 AM Biswajit Kumar < > biswa...@banglaphone.net.bd> 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 stores >> 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 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. >> >> 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. >> >> 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. >> >> 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 >> > -- Sincerely, Sayed Hadi Rastgou Haghi
