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

[Toni Barata]

Hi Daniel, Anka,

I have enabled logging of slow queries in mysql conf file (/etc/my.cnf):
[mysqld]
long_query_time=1
log-slow-queries=/var/log/mysql-slow.log

Restarted the mysql server and checked that de configuration was updated (mysqladmin variables):
...
| log_slow_queries                | ON                                       
| long_query_time                 | 1
...

And after a long period of load tests (with mysql process at 99,9% CPU) the log file was still empty!

This means that all the queries have taken less than a second to accomplish or the configuration I have used on mysql server is not correct.

Regards,
Toni
  

 
 

-----Original Message-----
From: Daniel-Constantin Mierla [mailto:daniel at voice-system.ro] 
Sent: terça-feira, 17 de Julho de 2007 11:57
To: Toni Barata
Cc: devel at openser.org
Subject: Re: [OpenSER-Devel] presence load tests: 1.2.1 vs trunk with mysql

Hello,

On 07/17/07 13:47, 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?
>
we should identify if there was introduced such big overhead. Can you 
enable logging of slow queries to spot quickly where the issue comes from?

Best regards,
Daniel

>  
>
> Regards,
>
> Toni
>
>  
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>