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
and attached is the memory log.
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