[Kamailio-Users] avpops OR sqlops

Daniel-Constantin Mierla miconda at gmail.com
Wed Dec 30 16:32:19 CET 2009


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/





More information about the sr-users mailing list