Re: [CentOS] MySQL query profiling

2012-03-23 Thread Johnny Hughes
On 03/22/2012 11:18 AM, Andy Taylor wrote: > Hi, > > I recently upgraded to the latest MySQL 5.0.95 package as part of the > CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for > performance testing. However, if I try to use any of the profiling > functionality I get this erro

Re: [CentOS] MySQL query profiling

2012-03-22 Thread Leonard den Ottolander
Hello Johnny, Andy, On Thu, 2012-03-22 at 12:01 -0500, Johnny Hughes wrote: > On 03/22/2012 11:46 AM, Johnny Hughes wrote: > OK ... I have verified that it is now turned off and that it was on in > 5.0.77 > > from 5.0.95 build log: > <..> > checking whether query profiling should be incl

Re: [CentOS] MySQL query profiling

2012-03-22 Thread Karanbir Singh
On 03/22/2012 05:01 PM, Johnny Hughes wrote: > > So, profiling was indeed in 5.0.77 and it is indeed not in 5.0.95 The default in configure for 5.0.77 was to have it turned on, whereas in 5.0.95 the default has been to turn it off : +{ $as_echo "$as_me:$LINENO: checking whether query profiling

Re: [CentOS] MySQL query profiling

2012-03-22 Thread Johnny Hughes
On 03/22/2012 11:46 AM, Johnny Hughes wrote: > On 03/22/2012 11:32 AM, Johnny Hughes wrote: >> On 03/22/2012 11:18 AM, Andy Taylor wrote: >>> Hi, >>> >>> I recently upgraded to the latest MySQL 5.0.95 package as part of the >>> CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for

Re: [CentOS] MySQL query profiling

2012-03-22 Thread Johnny Hughes
On 03/22/2012 11:32 AM, Johnny Hughes wrote: > On 03/22/2012 11:18 AM, Andy Taylor wrote: >> Hi, >> >> I recently upgraded to the latest MySQL 5.0.95 package as part of the >> CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for >> performance testing. However, if I try to use a

Re: [CentOS] MySQL query profiling

2012-03-22 Thread Johnny Hughes
On 03/22/2012 11:18 AM, Andy Taylor wrote: > Hi, > > I recently upgraded to the latest MySQL 5.0.95 package as part of the > CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for > performance testing. However, if I try to use any of the profiling > functionality I get this erro

[CentOS] MySQL query profiling

2012-03-22 Thread Andy Taylor
Hi, I recently upgraded to the latest MySQL 5.0.95 package as part of the CentOS 5.8 upgrade. I use MySQL query profiling on a regular basis for performance testing. However, if I try to use any of the profiling functionality I get this error: ERROR 1289 (HY000): The 'SHOW PROFILE' feature is