[Users] registrar table size

[Bogdan-Andrei Iancu]

Hi Kent,

you need to increase the private memory ( pkg memory) which is only 1M 
by default. See the config.h file:
    #define PKG_MEM_POOL_SIZE 1024*1024
try with 2M:
    #define PKG_MEM_POOL_SIZE 2*1024*1024

regards,
bogdan

Poppenhouse Kent-P28924 wrote:

>Is the purpose of writing to the db and the cache so if the SER is
>killed, it will load the location cache from the db on restart?  If I
>have 4000 users registered and written to the mysql database and kill
>and then restart SER, I get the following error:
>
>convert_row: No memory left
>convert_rows: Error while converting row #3628
>convert_result: Error while converting result
>preload_udomain(): Error while doing db_query
>register_udomain(): Error while preloading domain 'location'
>domain_fixup(): Error while registering domain
>
>If I go into mysql and remove all entries in the location table, and
>restart SER, it creates the openser_fifo and everything is fine, except
>of course I lose all registrations.
>
>
>
>
>-----Original Message-----
>From: Bogdan-Andrei Iancu [mailto:bogdan at voice-system.ro] 
>Sent: Thursday, April 13, 2006 2:17 AM
>To: Poppenhouse Kent-P28924; users openser.org
>Subject: Re: [Users] registrar table size
>
>Hi Kent,
>
>first of all, you cannot have partial caching into memory - usrloc 
>either cache all db content ,either nothing (that's the design).
>
>now, by size of the register table I understood the size of the hash 
>table used by usrloc - number of entries the hash has; but this does not
>
>affect how many records can be hold into usrloc table.
>
>so, what you are trying to do is not possible.
>
>regards,
>bogdan
>
>Poppenhouse Kent-P28924 wrote:
>
>  
>
>>Thank you for your quick reply.  I have been out of the office all last
>>week so I was just able to try it out.  I changed the new_udomain to 2
>>in the dlist.c file.  It didn't seem to change anything.  I was still
>>about to register 8000 users.  Let me explain what I'm trying to do,
>>maybe you can steer me the correct way.
>>
>>I have a mysql database created which the SER successfully updates with
>>the user registrations.  What I would like to have happen is have
>>100,000 users registered with the SER storing only 1000 users in memory
>>and performing database lookups to find the location of the other
>>    
>>
>users.
>  
>
>>These numbers are just made up but is something like this possible?  I
>>tried to register users yesterday and when it had registered 78682 it
>>said it ran out of memory.  How can I get the SER to store fewer users
>>in memory but still update the database for future lookups?
>>
>>Thank you for any help you can provide.
>>
>>Kent 
>>
>>-----Original Message-----
>>From: Bogdan-Andrei Iancu [mailto:bogdan at voice-system.ro] 
>>Sent: Friday, March 31, 2006 1:35 AM
>>To: Poppenhouse Kent-P28924
>>Cc: users at openser.org
>>Subject: Re: [Users] registrar table size
>>
>>Hi,
>>
>>the size of the hash table is hardcoded (no config option :( ). See  
>>modules/usrloc/dlist.c line 341, the call of new_domain() - second
>>    
>>
>param
>  
>
>>is the size.
>>Note that the size must be a power of 2!
>>
>>regards,
>>bogdan
>>
>>Poppenhouse Kent-P28924 wrote:
>>
>> 
>>
>>    
>>
>>>Does anyone know how to change the size of the location table used for
>>>   
>>>
>>>      
>>>
>> 
>>
>>    
>>
>>>the registrar?  I would like to reduce it from the default 512.
>>>
>>>----------------------------------------------------------------------
>>>      
>>>
>-
>  
>
>>>   
>>>
>>>      
>>>
>>-
>> 
>>
>>    
>>
>>>_______________________________________________
>>>Users mailing list
>>>Users at openser.org
>>>http://openser.org/cgi-bin/mailman/listinfo/users
>>>
>>>   
>>>
>>>
>>>      
>>>
>> 
>>    
>>
>>
>
>  
>