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