Unknown system variable ‘profiling’

[url]http://bugs.mysql.com/bug.php?id=40542[/url]
[url]http://dev.mysql.com/doc/refman/5.1/en/news-5-1-28.html[/url]

[6 Nov 2008 10:20] Shane Bester

Description:
According to the 5.1.28 change history, profiling feature should be included.
Solaris build contained the feature, but not windows build:

on windows 5.1.28:

mysql> set profiling=1;
ERROR 1193 (HY000): Unknown system variable 'profiling'
mysql> show global variables like '%profil%';
Empty set (0.00 sec)

on solaris 5.1.28:

mysql> show global variables like '%profil%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| profiling              | ON    |
| profiling_history_size | 15    |
+------------------------+-------+

How to repeat:
[url]http://dev.mysql.com/doc/refman/5.1/en/news-5-1-28.html[/url]

"Added the SHOW PROFILES and SHOW PROFILE statements to display statement profile data"

"These options are enabled by default;"...

set profiling=1;

Suggested fix:
windows is a major platform, and this feature must be implemented/built in these builds.

[6 Nov 2008 10:44] Valeriy Kravchuk

Verified with 5.1.29 also:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -proot -P3310 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.29-rc-community MySQL Community Server (GPL)

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

mysql> set profiling=1;
ERROR 1193 (HY000): Unknown system variable 'profiling'
mysql> show global variables like '%profil%';
Empty set (0.16 sec)

mysql> show profile;
ERROR 1289 (HY000): The 'SHOW PROFILE' feature is disabled; you need MySQL built
 with 'enable-profiling' to have it working
mysql>