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 <mico...@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/ > >
_______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users