[CentOS] MySQL query profiling

[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 error:
>
> ERROR 1289 (HY000): The 'SHOW PROFILE' feature is disabled; you need 
> MySQL built with 'enable-profiling' to have it working
>
> Oddly enough, profiling is enabled in the MySQL package bundled with 
> CentOS 6.2, and was enabled in the package before on CentOS 5 (5.0.77 I 
> think)
>
> I'm assuming this is probably an upstream decision, but does anyone 
> know of any way around this other than compiling my own RPM/using a 
> different RPM from another repository? Query profiling is essential 
> functionality in my opinion, so I'm surprised it hasn't been enabled in 
> the package.
>

I will double check the spec file and see if they have turn it off on
purpose and post what I find out.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.centos.org/pipermail/centos/attachments/20120322/932a626f/attachment.sig>