Re: How to change "long_query_time" with mySql 3.23
I wouldn't be surprised if this feature is broken in 3.23. You said you installed it yourself. Can you possibly upgrade to 4.1 instead? thomas Armstrong wrote: 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]
Re: How to change "long_query_time" with mySql 3.23
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]
Re: How to change "long_query_time" with mySql 3.23
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]
