SMS sending speed slows down when a new DB server connected
Biswajit Kumar <[email protected]> Mon, 17 Mar 2025 11:11:42 +0600
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Organization | Bangla Phone Limited |
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--------------2Y0Bg7VXHm8MTnm4rc0k4kfK
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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
<tel:+8801833103909>
--------------2Y0Bg7VXHm8MTnm4rc0k4kfK
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font face="Helvetica, Arial, sans-serif">Dear fellow users,</font></p>
<p><font face="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="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="Helvetica, Arial, sans-serif">My Kannel application
information is as below: <br>
<br>
</font><span
style="color: rgb(0, 0, 0); font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">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.</span></p>
<p><font face="Helvetica, Arial, sans-serif"><span
style="color: rgb(0, 0, 0); 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; -webkit-text-stroke-width: 0px; white-space: normal; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">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="Helvetica, Arial, sans-serif"><span
style="color: rgb(0, 0, 0); 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; -webkit-text-stroke-width: 0px; white-space: normal; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">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="Helvetica, Arial, sans-serif"><span
style="color: rgb(0, 0, 0); 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; -webkit-text-stroke-width: 0px; white-space: normal; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">Please
let me know if you need any further information.<br>
</span></font></p>
<div class="moz-signature">-- <br>
<span style="font-family: 'Book Antiqua';"><em>Thanks and Regards,</em>
</span><br>
<strong><span style="font-family: 'Trebuchet MS';"> Biswajit Kumar</span></strong>
| <span style="font-family: 'Book Antiqua';">AGM, P&D <a
href="http://www.banglaphone.net.bd/" target="_blank"
rel="noopener"><br>
<span style="color: #ff0000;">Bangla</span> <span
style="color:
#00ff00;">Phone</span> <span style="color: #0000ff;">Ltd.</span></a>
| <span style="color: #000000;"><a href="tel:+8801833103909"
target="_blank" rel="noopener"><span style="color: #000000;">+8801833103909</span></a></span></span></div>
</body>
</html>
--------------2Y0Bg7VXHm8MTnm4rc0k4kfK--