Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 2 down vote accepted

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?

share|improve this answer
    
Bad news for me, you're right. Thanks for the help. –  Mark Basmayor Jun 26 '09 at 9:42

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.