<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hello,<br>
<br>
On 12/30/09 4:53 PM, alex pappas wrote:
<blockquote
cite="mid:88b5e74c0912300753h129bcf97j9ea31d3fb1eb0986@mail.gmail.com"
type="cite">Hi,<br>
<br>
I don't see where the mysql is stacking but if I read correctly in <a
moz-do-not-send="true"
href="http://kamailio.org/docs/modules/1.5.x/htable.html">http://kamailio.org/docs/modules/1.5.x/htable.html</a>
<br>
<br>
<u><i>The number of entries in the table is 2^size</i></u> :
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.<br>
</blockquote>
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:<br>
<br>
<a class="moz-txt-link-freetext" href="http://en.wikipedia.org/wiki/Hash_table">http://en.wikipedia.org/wiki/Hash_table</a><br>
<br>
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.<br>
<br>
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.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
<blockquote
cite="mid:88b5e74c0912300753h129bcf97j9ea31d3fb1eb0986@mail.gmail.com"
type="cite"><br>
<br>
<br>
<div class="gmail_quote">On Wed, Dec 30, 2009 at 5:32 PM,
Daniel-Constantin Mierla <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:miconda@gmail.com">miconda@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">Hello,<br>
<br>
On 12/30/09 4:05 PM, alex pappas wrote:<br>
</div>
<div class="im">
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>
<br>
The error I get is the following:<br>
<br>
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Lost
connection to MySQL server during query<br>
ERROR:core:db_do_query: error while submitting query<br>
ERROR:htable:ht_db_load_table: Error while querying db<br>
ERROR:core:init_mod: failed to initialize module htable<br>
ERROR:core:main: error while initializing modules<br>
<br>
I'm running kamailio with 8M private memory per process and 2048M
shared memory.<br>
<br>
When kamailio is getting the data from mysql is passing it all the data
chunk in private memory and then in the shared memory?<br>
</blockquote>
</div>
It is loaded in chunks of rows -- you can tune it with a module
parameter:<br>
<a moz-do-not-send="true"
href="http://kamailio.org/docs/modules/3.0.x/modules_k/htable.html#id2529075"
target="_blank">http://kamailio.org/docs/modules/3.0.x/modules_k/htable.html#id2529075</a><br>
<br>
Try to play with it to see if you get better results. You do not need
more private memory, 8MB is ok.<br>
<br>
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?<br>
<br>
Cheers,<br>
<font color="#888888">Daniel</font>
<div class="im"><br>
<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
because if this is the case then I need more than 1000M in private
memory.<br>
<br>
Cheers<br>
Alex<br>
<br>
P.S. i don't get any errors from mysql.<br>
<br>
<br>
<br>
</blockquote>
<br>
</div>
<div>
<div class="h5">-- <br>
Daniel-Constantin Mierla<br>
* <a moz-do-not-send="true" href="http://www.asipto.com/"
target="_blank">http://www.asipto.com/</a><br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
* <a class="moz-txt-link-freetext" href="http://www.asipto.com/">http://www.asipto.com/</a>
</pre>
</body>
</html>