Re: [Kamailio-Users] avpops OR sqlops

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 &lt;miconda(a)gmail.com <mailto:miconda@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(a)lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users