[Kamailio-Users] avpops OR sqlops

[alex pappas]

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.

Cheers
Alex



On Wed, Dec 30, 2009 at 5:32 PM, Daniel-Constantin Mierla <miconda at 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/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20091230/a959af30/attachment.htm>