Re: How to change "long_query_time" with mySql 3.23

[thomas Armstrong]

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 <tarmstrong@stripped> 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.
>