30 Dec
2009
30 Dec
'09
6:01 p.m.
Hello,
On 12/30/09 4:53 PM, alex pappas wrote:
Hi,
I don't see where the mysql is stacking but if I read correctly in
http://kamailio.org/docs/modules/1.5.x/htable.html
_/The number of entries in the table is 2^size/_ : 2^14=16384 rows
data and i have 2.000.000 rows so maybe it is not possible to load
them..But you know better of course.
no, that is the number of slots (buckets) in
the hash table, not the
number of items that can be loaded -- some more technical aspects of
hash tables:
http://en.wikipedia.org/wiki/Hash_table
The number of items in htable is only a matter of shared memory. The
number of slots controls access speed -- higher number gives less
collisions.
You said at a moment that you could start, but htable was returning only
null: put a sht_print() in config to see the content of the htable (you
probably need high debug level: debug=5) with the first sip request.
Cheers,
Daniel
On Wed, Dec 30, 2009 at 5:32 PM, Daniel-Constantin Mierla
<miconda(a)gmail.com <mailto:miconda@gmail.com>> wrote:
Hello,
On 12/30/09 4:05 PM, alex pappas wrote:
Hi,
The error I get is the following:
ERROR:db_mysql:db_mysql_submit_query: driver error on query:
Lost connection to MySQL server during query
ERROR:core:db_do_query: error while submitting query
ERROR:htable:ht_db_load_table: Error while querying db
ERROR:core:init_mod: failed to initialize module htable
ERROR:core:main: error while initializing modules
I'm running kamailio with 8M private memory per process and
2048M shared memory.
When kamailio is getting the data from mysql is passing it all
the data chunk in private memory and then in the shared memory?
It is loaded in chunks of rows -- you can tune it with a module
parameter:
http://kamailio.org/docs/modules/3.0.x/modules_k/htable.html#id2529075
Try to play with it to see if you get better results. You do not
need more private memory, 8MB is ok.
Maybe the mysql server is closing due to lot of loaded data. Have
you got any figure what is the number of rows when it starts
losing the connection?
Cheers,
Daniel
because if this is the case then I need more than 1000M in
private memory.
Cheers
Alex
P.S. i don't get any errors from mysql.
--
Daniel-Constantin Mierla
* http://www.asipto.com/
--
Daniel-Constantin Mierla
* http://www.asipto.com/