[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.
>
> Thanks,
>
> Andy

After verifying this issue, we have made a bugs entry for CentOS:
http://bugs.centos.org/view.php?id=5615

and upstream:
https://bugzilla.redhat.com/show_bug.cgi?id=806365

We can build a version that has this enabled if there is a big need or a
long delay from upstream.


-------------- 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/20120323/f089e45b/attachment.sig>