<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi guys,</p>
<p>is it possible to use the opensips drouting module as an MNP
lookup tool?</p>
<p>I'm currently trying to use the dr_rules table for a combination
of traditional longest match + single number MNP matching.
Therefore the prefixes are up to 15 digits long. In my table every
prefix is unique. shmem fragments going up extremely high after 20
minutes of loading time (do_routing "L"-Flag doesn't change
loading time). During this time is_from_gw always fails. Am I
doing something wrong or is the module just not supposed to handle
so many unique routes?</p>
<p>8.4mio unique prefixes like this in dr_rules table:</p>
<p>
<span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">+---------+---------+----------------+---------+----------+---------+--------+----------+--------------+-----------+-------------+</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| ruleid
| groupid | prefix | timerec | priority | routeid |
gwlist | sort_alg | sort_profile | attrs | description |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">+---------+---------+----------------+---------+----------+---------+--------+----------+--------------+-----------+-------------+</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322958
| 10 | 43650 | NULL | 0 | NULL |
#1551 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322959
| 10 | 43660 | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322960
| 10 | 4366100 | NULL | 0 | NULL |
#1551 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322961
| 10 | 4366110 | NULL | 0 | NULL |
#1551 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322962
| 10 | 4366303 | NULL | 0 | NULL |
#1522 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322963
| 10 | 4366305 | NULL | 0 | NULL |
#5729 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322964
| 10 | 4366306 | NULL | 0 | NULL |
#1522 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322965
| 10 | 4366363 | NULL | 0 | NULL |
#1522 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322966
| 10 | 43664 | NULL | 0 | NULL |
#1522 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322967
| 10 | 4366565 | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322968
| 10 | 4366566 | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322969
| 10 | 4366567 | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322970
| 10 | 4366599 | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322971
| 10 | 4366600 | NULL | 0 | NULL |
#1074 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322972
| 10 | 4366719 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322973
| 10 | 4366733 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322974
| 10 | 4366744 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322975
| 10 | 4366766 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322976
| 10 | 4366776 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322977
| 10 | 4366777 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322978
| 10 | 4366778 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322979
| 10 | 4366779 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322980
| 10 | 4366788 | NULL | 0 | NULL |
#3555 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322981
| 10 | 436688001xxx | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322982
| 10 | 436688064xxx | NULL | 0 | NULL |
#1746 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322983
| 10 | 436688183xxx | NULL | 0 | NULL |
#1746 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322984
| 10 | 436688269xxx | NULL | 0 | NULL |
#1746 | N | NULL | MOBILE | NULL |</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">| 8322985
| 10 | 436688269xxx | NULL | 0 | NULL |
#1524 | N | NULL | MOBILE | NULL |</span></span></p>
<p>Memory stats:</p>
<p>
<span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">root@vie-ix-voip-sbc:/etc/opensips#
opensips-cli -x mi get_statistics all</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">{</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"shmem:total_size": 10737418240,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"shmem:max_used_size": 4885538240,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"shmem:free_size": 5851889480,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"shmem:used_size": 2771791520,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"shmem:real_used_size": 4885528760,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"shmem:fragments": 37744704,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"rpmem:rpm_total_size": 0,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"rpmem:rpm_used_size": 0,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"rpmem:rpm_real_used_size": 0,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"rpmem:rpm_fragments": 0,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"rpmem:rpm_max_used_size": 0,</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
<span style="color:#000000;background-color:#ffffff;">
"rpmem:rpm_free_size": 0,</span><br>
<span style="color:#000000;background-color:#ffffff;"></span><br>
</span></p>
<p>Thanks,</p>
<p>Malte</p>
</body>
</html>