Hi,<br><br>I don't see where the mysql is stacking but if I read correctly in <a 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><br>Cheers<br>Alex<br><br><br><br><div class="gmail_quote">On Wed, Dec 30, 2009 at 5:32 PM, Daniel-Constantin Mierla <span dir="ltr"><<a 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 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></div><div class="h5">
-- <br>
Daniel-Constantin Mierla<br>
* <a href="http://www.asipto.com/" target="_blank">http://www.asipto.com/</a><br>
<br>
</div></div></blockquote></div><br>