Hi,

 

here is the statistics after kamailio starts:

 

shmem:fragments = 28
shmem:free_size = 3800871312
shmem:max_used_size = 494132368
shmem:real_used_size = 494095984
shmem:total_size = 4294967296
shmem:used_size = 342642072

 

here it is after reload of the num table:

 

shmem:fragments = 9161531
shmem:free_size = 3654274496
shmem:max_used_size = 959885552
shmem:real_used_size = 640692800
shmem:total_size = 4294967296
shmem:used_size = 342654552

here is the cfg part for mtree:

 

#------- mtree params -------------
modparam("mtree", "db_url", CFGDB)
modparam("mtree", "mtree", "name=odr;dbtable=service_odr_view;type=0;")
modparam("mtree", "mtree", "name=oper;dbtable=service_oper_type;type=0;")
modparam("mtree", "mtree", "name=permis;dbtable=service_permisions_to_oper;type=0;")
modparam("mtree", "mtree", "name=num;dbtable=service_numbers_to_areas_view;type=0;")
modparam("mtree", "char_list", "0123456789")
modparam("mtree", "pv_value", "$avp(mtval)")
modparam("mtree", "pv_values", "$avp(mtvals)")

 

here is the number of raws from the DB:

 

SELECT count(*) FROM `service`.`service_numbers_to_areas_view` = 4195528

 

i have the memory log in a file if needed

 

thanks,

Uri

 

On Fri, Sep 7, 2012 at 10:26 AM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

is this taken only after startup? Get one at startup and another one after reload, so it can be compared.

Cheers,
Daniel

On 9/6/12 9:22 AM, Uri Shacked wrote:

Hi,

 

here:

 

shmem:fragments = 143898

shmem:freesize = 3446570952

shmem:max_used_size = 861854768

shmem:real_used_size = 848396344

shmem:total_size = 4294967296

shmem:used_size = 319676976

 

On Thu, Sep 6, 2012 at 9:49 AM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Hello,

On 9/5/12 3:06 PM, Uri Shacked wrote:

Hi,
I use MTREE to load 5 million rows from the database. it takes about 30 sec to start kamailio and it is running great.
Whern I check the shmem usage I see the data take about 0.8G out of 4G i set on shmem.
When i reload the data while kamailio is running, the memory usage rises to 1.3G and stays there (the second and next reloads stays on 1.3G as well).
Why doesn't it return to 0.8G after the reload is completed?

can you send the statistics related to shmem?

kamctl fifo get_statistics shmem:

There are different values there, some usage come from overhead of memory chunks management.

Cheers,
Daniel

--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - http://asipto.com/u/kat
Kamailio Advanced Training, Miami, USA, Nov 12-14, 2012 - http://asipto.com/u/katu

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 5-8, 2012 - http://asipto.com/u/kat
Kamailio Advanced Training, Miami, USA, Nov 12-14, 2012 - http://asipto.com/u/katu