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.