Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 2 down vote accepted

Seems that - according to this discussion on - 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


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.