Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Machiel Richards (machielrrdc.co.za)
Date: Tue Feb 16 2010 - 01:21:39 CST
I hope that someone can assist me with this.
We have a client with a production MySQL database running
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
mysql> set global log_slow_queries=ON;
ERROR 1238 (HY000): Variable 'log_slow_queries' is a read only variable
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.