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

[7 May 2007 21:29] Markus Popp
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'
[7 May 2007 23:25] MySQL Verification Team
Thank you for the bug report.
[8 May 2007 14:57] Sergei Golubchik
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)
[8 May 2007 15:20] Markus Popp
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.
[8 May 2007 16:21] Sergei Golubchik
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.
[24 May 2007 12:33] MySQL Verification Team
Bug http://bugs.mysql.com/bug.php?id=28634 was marked as duplicate
of this one.
[29 Aug 2007 15:25] MC Brown
Updated documentation (Closed)
[7 Feb 2008 7:14] Paul Rivers
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
[24 Oct 2008 13:28] MySQL Verification Team
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>
[10 Dec 2009 4:04] Roel Van de Paar
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).
[10 Dec 2009 4:08] Roel Van de Paar
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