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@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel


_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel

Reply via email to