-none- 2007-10-04 - By thomas Armstrong
Back
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@(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/mysql?unsub=mysql@(protected)
|
|
