[Kamailio-Users] avpops OR sqlops

[Alex Balashov]

No, the size means 16384 unique buckets, not total capacity.  It's just 
that the efficiency of a hash table breaks down and approaches a linear 
search as the size of the data vastly exceeds the capacity of the table, 
as a unique distribution is not possible and almost all lookups require 
collision list searches.

On 12/30/2009 10:53 AM, alex pappas wrote:

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


-- 
Alex Balashov - Principal
Evariste Systems
Web     : http://www.evaristesys.com/
Tel     : (+1) (678) 954-0670
Direct  : (+1) (678) 954-0671