[Kamailio-Users] avpops OR sqlops

[Daniel-Constantin Mierla]

Hello,

On 12/30/09 4:53 PM, 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.
no, that is the number of slots (buckets) in the hash table, not the 
number of items that can be loaded -- some more technical aspects of 
hash tables:

http://en.wikipedia.org/wiki/Hash_table

The number of items in htable is only a matter of shared memory. The 
number of slots controls access speed -- higher number gives less 
collisions.

You said at a moment that you could start, but htable was returning only 
null: put a sht_print() in config to see the content of the htable (you 
probably need high debug level: debug=5) with the first sip request.

Cheers,
Daniel


>
>
>
> 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/
>
>

-- 
Daniel-Constantin Mierla
* http://www.asipto.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/users/attachments/20091230/507ab765/attachment-0001.htm>