I also tried with:
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:
> 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.