title: MySQL Profiler - No entries in show profile
body: <p>I am using MySQL profiler to help with diagnosis of some MySQL issues I am investigating.  However when I issue the <code>show profiles</code> command I do not get any results.</p>
  
  <p>This is how I am using it:</p>
  
  <pre><code>set profiling=1 --Enable profiling
  
  -- Run some selects / inserts etc
  select count(*) from mytable
  insert into mytable (mydata) values ('wibble')
  
  show profiles
  </code></pre>
  
  <p>I was expecting the <code>show profiles</code> command to give me the profile data for the selects etc that I performed after enabling profiling (Per the information <a href="http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html" rel="nofollow">from this MySQL dev page</a>), however all I get back is an empty resultset.  I do not see any errors when enabling/disabling profiling nor do I see any errors when attempting to view profiles.</p>
  
  <p>The following may or may not be relevant:</p>
  
  <ol>
  <li>The commands were issued via phpMyAdmin</li>
  <li>I am running MySQL 5.0.77</li>
  <li><code>select * from information_schema.profiling</code> returns no results</li>
  </ol>