Hi Machiel, The below link will help you. mk-query-digesthttp://www.xaprb.com/blog/category/maatkit/
Regards, Krishna On Tue, Feb 16, 2010 at 12:51 PM, Machiel Richards <machi...@rdc.co.za>wrote: > 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 > >