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 <[EMAIL PROTECTED]> 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. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]