[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:
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;"...
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:
[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>