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:[EMAIL PROTECTED] Sent: terça-feira, 17 de Julho de 2007 11:57 To: Toni Barata Cc: devel@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@openser.org > http://openser.org/cgi-bin/mailman/listinfo/devel > _______________________________________________ Devel mailing list Devel@openser.org http://openser.org/cgi-bin/mailman/listinfo/devel
