It looks like mySQL is taking ok the "long_query_time" value by using -------- set-variable=long_query_time=5 --------
If I display mySQL parameters: ------ long_query_time current value: 10 ------ However, there are tons of lines like this one: ------ # [EMAIL PROTECTED]: root[root] @ localhost [] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 20 -------- This is not a slow query, is it? On 10/4/07, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote: > On Thursday 04 October 2007 14:06, 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. > > Try to remove the spaces in the two lines. If my memory is correct, I had the > same problem some time ago and it went away when removing the spaces. > > -- > Jørn Dahl-Stamnes > homepage: http://www.dahl-stamnes.net/dahls/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
