3 Votes Vote

MySQL Profiler - No entries in show profile

Posted by topdog 484 days ago Questions| mysql show profiler All

I am using MySQL profiler to help with diagnosis of some MySQL issues I am investigating. However when I issue the show profiles command I do not get any results.

This is how I am using it:

set profiling=1 --Enable profiling

-- Run some selects / inserts etc
select count(*) from mytable
insert into mytable (mydata) values ('wibble')

show profiles

I was expecting the show profiles command to give me the profile data for the selects etc that I performed after enabling profiling (Per the information from this MySQL dev page), 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.

The following may or may not be relevant:

  1. The commands were issued via phpMyAdmin
  2. I am running MySQL 5.0.77

Originally asked by: MrEyes on Stack Overflow

Discuss Bury


Who Voted for this Question