MySQL profiler - no entries in the displayed profile

Question

I use the MySQL profiler to help diagnose some of the MySQL problems that I am studying. However, when I issue a command show profiles, I get no results.

Here is how I use it:

set profiling=1 --Enable profiling

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

show profiles

I expected the command to show profilesgive me profile data for selects, etc., which I performed after enabling profiling (for the information from this MySQL dev page ), however, all I get is an empty result set. I do not see errors when turning on / off profiling and I see no errors when trying to view profiles.

The following may or may not be relevant:

• Commands issued via phpMyAdmin
• I am running MySQL 5.0.77
• select * from information_schema.profiling does not return results

Answer 1

...

, MySQL, , MySQL. , phpMyAdmin , . , .

MySQL SSH . .

, . , , (.. -), .

(.. MSSQL). my.cnf, SSH:

log=/var/log/mysqldquery.log

, , .

Answer 2

, .

PhpMyAdmin, TRANSACTION ( ?)

:

START TRANSACTION;

set profiling=1; --Enable profiling

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

show profiles;

COMMIT; --or rollback

,

Answer 3

, . , / , . .