Why isn't the MySQL Profiler working for me?

Hi,

I'm trying to analyse my database but I can't get profiler to work. According to the mysql documentation it should be available since MySQL 5.0.37 and turning it on is as simple as executing the following statement

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

However when I try it, I'm get this error: ERROR 1193 (HY000): Unknown system variable 'profiling'

I'm using a more recent version of MySQL so I'm assuming that profiler should be available.

mysql> select version();
+-----------------------------+
| version()                   |
+-----------------------------+
| 5.1.22-rc-Debian_2~ppa5-log | 
+-----------------------------+

Am I missing something here?

Thanks.

From serverfault Mark Basmayor

• Seems that - according to this discussion on mysql.com - newer versions (Community Server) don't include the profiler.

  If you execute

   select @@version;  
   show variables;
  

  is there "profiling" in the output?

  Mark Basmayor : Bad news for me, you're right. Thanks for the help.
  From splattne