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
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
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] @
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