mlsamuelson.com

profiling queries with the MySQL Profiler

Submitted by mlsamuelson on Tue, 10/26/2010 - 23:48

set profiling=1;

Turn the profiler on.

Now run a query or two. Then...

show profile;

To show the last profiled query.

Or...

show profiles;

To get a list of profiled queries, including durations.

Then you can...

show profile for query 4;

To show the profile for one of the listed queries.

More info on this very helpful functionality:

And of course, don't forget about using EXPLAIN on your queries...