[OpenSER-Devel] presence load tests: 1.2.1 vs trunk with mysql

[Daniel-Constantin Mierla]

Hello,

just to have it in mind, perhaps we should make a list will all select 
queries in openser modules, to see if we can optimize by adding some 
indexes.

Cheers,
Daniel


On 07/18/07 19:46, Henning Westerholt wrote:
> On Tuesday 17 July 2007, Toni Barata wrote:
>   
>> Hi all,
>>
>> I am using MySQL 5.0.22 database for persistent storage and I have
>> preformed some presence load tests for publish messages, and observed
>> that in trunk version if I have more than 2 messages per second the
>> mysqld process runs out the CPU with 99,9% of his capacity.
>>
>> In the 1.2.1 version there is no such problem when performing the same
>> load tests.
>>
>>
>>
>> What difference between version 1.2.1 and trunk have made the mysqld
>> process became obsessive?
>>     
>
> Hello Toni,
>
> i did some cleanups in the database interface in svn trunk. Did you experience 
> also a slowdown with some other non presence modules?
>
> Cheers,
>
> Henning
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>
>