[CentOS] MySQL query profiling

Fri Mar 23 15:05:51 UTC 2012
Johnny Hughes <johnny at centos.org>

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:

and upstream:

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-0004.sig>