Free MySQL Profiler [closed]

Question

My Background is with MS-SQL and not MySQL and I am struggeling to figure out how to debug something,

I need to see exactly what querys (actually inserts) a webservice is executing in a MySQL database, However I cannot find an equivelent to MS-SQL Profiler that is free (we have no budget). Does anyone have any suggestions?

Thanks

Ian

Answer 1

Try that:

mysql> SET profiling = 1;

mysql> SELECT * FROM {your_table}

mysql> SHOW PROFILES;

or

mysql> SHOW PROFILE;

More info: http://dev.mysql.com/doc/refman/5.0/en/show-profile.html