From: thomas Armstrong Date: October 4 2007 12:13pm Subject: Re: How to change "long_query_time" with mySql 3.23 List-Archive: http://lists.mysql.com/mysql/209391 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I also tried with: ------- set-variable=long_query_time=5 ------ mySQL starts ok, but all queries within the file are: # Query_time: 0 Lock_time: 0 Rows_sent: 119 Rows_examined: 238 The aren't slow queries, are they? On 10/4/07, thomas Armstrong wrote: > Hi. > > I'm suffering a severe slowness of my server (mySQL 3.23), and want to > detect Slow Queries. > > I installed mySQL on '/usr/local/mysql', and works ok. But if I insert > this line into '/etc/my.cnf': > ----- > log-slow-queries = /usr/local/mysql/log/slow-queries.log > long_query_time = 5 > ----- > it won't restart. If I comment the second line, it works ok. > > Does anybody know how to set the slow queries time? Thank you very much. >