3

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.

Mark Basmayor
  • 163
  • 5

2 Answers2

2

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?

splattne
  • 28,508
  • 20
  • 98
  • 148
0

Also check exist of table INFORMATION_SCHEMA.PROFILING. In that table going profiling information.

Nikl
  • 101
  • 2