Hi guys,

is it possible to use the opensips drouting module as an MNP lookup tool?

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?

8.4mio unique prefixes like this in dr_rules table:

+---------+---------+----------------+---------+----------+---------+--------+----------+--------------+-----------+-------------+
| ruleid  | groupid | prefix         | timerec | priority | routeid | gwlist | sort_alg | sort_profile | attrs     | description |
+---------+---------+----------------+---------+----------+---------+--------+----------+--------------+-----------+-------------+
| 8322958 | 10      | 43650          | NULL    |        0 | NULL    | #1551   | N        |         NULL |  MOBILE | NULL        | | 8322959 | 10      | 43660          | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        | | 8322960 | 10      | 4366100        | NULL    |        0 | NULL    | #1551   | N        |         NULL |  MOBILE | NULL        | | 8322961 | 10      | 4366110        | NULL    |        0 | NULL    | #1551   | N        |         NULL |  MOBILE | NULL        | | 8322962 | 10      | 4366303        | NULL    |        0 | NULL    | #1522   | N        |         NULL |  MOBILE | NULL        | | 8322963 | 10      | 4366305        | NULL    |        0 | NULL    | #5729   | N        |         NULL |  MOBILE | NULL        | | 8322964 | 10      | 4366306        | NULL    |        0 | NULL    | #1522   | N        |         NULL |  MOBILE | NULL        | | 8322965 | 10      | 4366363        | NULL    |        0 | NULL    | #1522   | N        |         NULL |  MOBILE | NULL        | | 8322966 | 10      | 43664          | NULL    |        0 | NULL    | #1522   | N        |         NULL |  MOBILE | NULL        | | 8322967 | 10      | 4366565        | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        | | 8322968 | 10      | 4366566        | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        | | 8322969 | 10      | 4366567        | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        | | 8322970 | 10      | 4366599        | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        | | 8322971 | 10      | 4366600        | NULL    |        0 | NULL    | #1074   | N        |         NULL |  MOBILE | NULL        | | 8322972 | 10      | 4366719        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322973 | 10      | 4366733        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322974 | 10      | 4366744        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322975 | 10      | 4366766        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322976 | 10      | 4366776        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322977 | 10      | 4366777        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322978 | 10      | 4366778        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322979 | 10      | 4366779        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322980 | 10      | 4366788        | NULL    |        0 | NULL    | #3555   | N        |         NULL |  MOBILE | NULL        | | 8322981 | 10      | 436688001xxx   | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        | | 8322982 | 10      | 436688064xxx   | NULL    |        0 | NULL    | #1746   | N        |         NULL |  MOBILE | NULL        | | 8322983 | 10      | 436688183xxx   | NULL    |        0 | NULL    | #1746   | N        |         NULL |  MOBILE | NULL        | | 8322984 | 10      | 436688269xxx   | NULL    |        0 | NULL    | #1746   | N        |         NULL |  MOBILE | NULL        | | 8322985 | 10      | 436688269xxx   | NULL    |        0 | NULL    | #1524   | N        |         NULL |  MOBILE | NULL        |

Memory stats:

root@vie-ix-voip-sbc:/etc/opensips# opensips-cli -x mi get_statistics all
{
   "shmem:total_size": 10737418240,
   "shmem:max_used_size": 4885538240,
   "shmem:free_size": 5851889480,
   "shmem:used_size": 2771791520,
   "shmem:real_used_size": 4885528760,
   "shmem:fragments": 37744704,
   "rpmem:rpm_total_size": 0,
   "rpmem:rpm_used_size": 0,
   "rpmem:rpm_real_used_size": 0,
   "rpmem:rpm_fragments": 0,
   "rpmem:rpm_max_used_size": 0,
   "rpmem:rpm_free_size": 0,

Thanks,

Malte
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to