MySQL Bugs: #28288: Query Profiler not available in MySQL 5.1 and 6.0

Bug #28288	Query Profiler not available in MySQL 5.1 and 6.0
Submitted:	7 May 2007 21:29	Modified:	29 Aug 2007 15:25
Reporter:	Markus Popp	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.18-BK, 6.0.1-BK	OS:	Any
Assigned to:	MC Brown	CPU Architecture:	Any

Description:
The Query Profiler, as introduced in MySQL 5.0.37, is not available in the most recent MySQL 5.1 and 6.0 sources yet.

It should be possible to assume that a feature available in an older version is also available in a newer version (unless it has been deprecated, which is certainly not the case here). Therefore it may be legitimate to consider the lack of a feature in a newer version a bug.

How to repeat:
[mpopp@falcon ~]$ mysql
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 5.1.18-beta-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set profiling=1;
ERROR 1193 (HY000): Unknown system variable 'profiling'

Thank you for the bug report.

This is intentional. Why a feature is present in 5.0.37 community release and is not present in 5.1 is explained in, for example, here: http://www.planetmysql.org/kaj/?p=64

(but if you'll tell that this information must be in the manual, not in the blog, I'll agree)

Sorry, I don't get it.

The Query Profiler is available in the 5.0.37 Community Edition. Now see here:

[mpopp@falcon ~]$ mysql
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 148
Server version: 5.1.17-beta-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set profiler=1;
ERROR 1193 (HY000): Unknown system variable 'profiler'

This version is as well described as Community Server. So it seems logical to me that the feature available in 5.0.37 Community should as well be available in 5.1.17 Community.

5.1 is not yet a community or enterprise, it wasn't split yet.
Ok, let's reopen it in the Documentation category - the manual shouldn't leave the place for such confusion.

Bug http://bugs.mysql.com/bug.php?id=28634 was marked as duplicate
of this one.

Updated documentation (Closed)

Hi,

Could you provide clarification on where in the documentation this has been updated?  I can't seem to find it.  Bottom line is, is this coming back for 5.1 and 6.0?  I really hope so.

Thanks,
Paul

Below the output I got with current releases:

[miguel@hegel mysql-5.1.28-rc-linux-x86_64-glibc23]$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.28-rc MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

[miguel@hegel mysql-6.0.7-alpha-linux-x86_64-glibc23]$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.7-alpha MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

mysql>

To clarify: 

Profiling is now available in Community *and* Enterprise builds from versions 5.0.82, 5.1.24-rc, 5.1.23-ndb-6.3.11,(6.0.5-alpha) (ref. bug #24795).

Note however that:

'SHOW PROFILES and SHOW PROFILE were added in MySQL 5.1.24 (but were not added to binary distributions by default until 5.1.28).'
http://dev.mysql.com/doc/refman/5.1/en/show-profiles.html