[CentOS] MySQL query profiling

Thu Mar 22 16:46:36 UTC 2012
Johnny Hughes <johnny at centos.org>

On 03/22/2012 11:32 AM, Johnny Hughes wrote:
> 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.

This is the difference beween the spec files:
--- mysql.spec    (revision 4056)
+++ mysql.spec    (revision 4522)
@@ -1,11 +1,11 @@
 Name: mysql
-Version: 5.0.77
-Release: 4%{?dist}.6
+Version: 5.0.95
+Release: 1%{?dist}.1
 Summary: MySQL client programs and shared libraries
 Group: Applications/Databases
 URL: http://www.mysql.com
 # exceptions allow client libraries to be linked with most open source SW,
-# not only GPL code.
+# not only GPL code.  See README.mysql-license
 License: GPLv2 with exceptions
 # Regression tests take a long time, you can skip 'em with this
@@ -16,6 +16,7 @@
 Source3: my.cnf
 Source4: scriptstub.c
 Source5: my_config.h
+Source7: README.mysql-license
 # Working around perl dependency checking bug in rpm FTTB. Remove later.
 Source999: filter-requires-mysql.sh
 Patch1: mysql-libdir.patch
@@ -28,36 +29,19 @@
 Patch8: mysql-install-test.patch
 Patch9: mysql-bdb-link.patch
 Patch10: mysql-strmov.patch
-Patch11: mysql-html-bug.patch
+Patch12: mysql-s390-truncate.patch
 Patch13: mysql-no-dbug.patch
 Patch15: mysql-stack-guard.patch
 Patch16: mysql-expired-certs.patch
-Patch17: mysql-format-string.patch
-Patch18: mysql-name-const.patch
-Patch19: mysql-cve-2009-4019.patch
-Patch20: mysql-cve-2009-4028.patch
-Patch21: mysql-cve-2009-4030.patch
 Patch22: mysql-cve-2010-1626.patch
-Patch23: mysql-cve-2010-1848_1850.patch
-Patch24: mysql-cve-2010-3677.patch
 Patch25: mysql-cve-2010-3680.patch
 Patch26: mysql-cve-2010-3681.patch
-Patch27: mysql-cve-2010-3682.patch
-Patch28: mysql-cve-2010-3833.patch
-Patch29: mysql-cve-2010-3835.patch
-Patch30: mysql-cve-2010-3836.patch
-Patch31: mysql-cve-2010-3837.patch
-Patch32: mysql-cve-2010-3838.patch
 Patch33: mysql-cve-2010-3839.patch
-Patch34: mysql-cve-2010-3840.patch
-Patch35: mysql-large-blobs.patch
-Patch36: mysql-explain-crash.patch
-Patch37: mysql-bug42037.patch
 Patch38: mysql-more-blobs.patch
 BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root
-Prereq: /sbin/ldconfig, /sbin/install-info, grep, fileutils, chkconfig
-BuildRequires: gperf, perl, readline-devel, openssl-devel
+Requires: /sbin/ldconfig, /sbin/install-info, grep, fileutils, chkconfig
+BuildRequires: perl, readline-devel, openssl-devel
 BuildRequires: gcc-c++, ncurses-devel, zlib-devel
 BuildRequires: libtool automake autoconf gawk
 # make test requires time
@@ -81,7 +65,7 @@
 Summary: The MySQL server and related files
 Group: Applications/Databases
-Prereq: /sbin/chkconfig, /usr/sbin/useradd
+Requires: /sbin/chkconfig, /usr/sbin/useradd
 Requires: %{name} = %{version}-%{release}
 Requires: sh-utils
 # mysqlhotcopy needs DBI/DBD support
@@ -145,31 +129,14 @@
 %patch8 -p1
 %patch9 -p1
 %patch10 -p1
-%patch11 -p1
+%patch12 -p1
 %patch13 -p1
 %patch15 -p1
 %patch16 -p1
-%patch17 -p1
-%patch18 -p1
-%patch19 -p1
-%patch20 -p1
-%patch21 -p1
 %patch22 -p1
-%patch23 -p1
-%patch24 -p1
 %patch25 -p1
 %patch26 -p1
-%patch27 -p1
-%patch28 -p1
-%patch29 -p1
-%patch30 -p1
-%patch31 -p1
-%patch32 -p1
 %patch33 -p1
-%patch34 -p1
-%patch35 -p1
-%patch36 -p1
-%patch37 -p1
 %patch38 -p1
 libtoolize --force
@@ -312,6 +279,9 @@
 mkdir -p $RPM_BUILD_ROOT/etc/ld.so.conf.d
 echo "%{_libdir}/mysql" >
+# copy additional docs into build tree so %%doc will find them
+cp %{SOURCE7} README.mysql-license
@@ -354,7 +324,7 @@
+%doc README COPYING README.mysql-license
@@ -519,6 +489,11 @@
+* Sat Feb  4 2012 Tom Lane <tgl at redhat.com> 5.0.95-1.el5_7.1
+- Update to 5.0.95, to get the last upstream bugfixes in this release
+  including numerous CVEs announced in January 2012
+Resolves: #787140
 * Thu Apr 28 2011 Tom Lane <tgl at redhat.com> 5.0.77-4.el5_6.6
 - Add fix for regression with input lines over 1MB (caused by fix for
 Resolves: #700497

I do not see anything specifically in there that would modify the
behavior of that (there is no profil in that text or in either the
5.0.77 or 5.0.95 spec file) ... nor is profil in any patch in the
SOURCES directory.

Johnny Hughes

-------------- 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/69c53dfc/attachment-0004.sig>