From: Machiel Richards (machielrrdc.co.za)
Date: Tue Feb 16 2010 - 01:21:39 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi All

                I hope that someone can assist me with this.

                We have a client with a production MySQL database running
MySQL 5.0.

                Their slow query counts have skyrocketed over the last week
and I found that their slow query logs are not enabled.

                However when trying to configure this I get the following
message:

mysql> set global log_slow_queries=ON;

ERROR 1238 (HY000): Variable 'log_slow_queries' is a read only variable

mysql>

                I did the same thing many times before on other databases
but this specific one gives me this message.

                Can anyone perhaps give me some insight as to why i'm
getting this and how to enable it (preferably without having to restart the
database seeing it is a high availability production system)?

                Help is much appreciated.

Regards

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]