Measuring MySQL Actual Runtime

Question

How can I measure the execution time of a request without measuring the time it spends, waiting for the lock to be released, etc.? My only idea was to constantly measure the same query and record the fastest time.

Answer 1

Run the profiler with

SET profiling = 1; 

Then complete your request.

FROM

 SHOW PROFILES; 

you see a list of queries for which the profiler has statistics. And finally, you choose which request to check with

 SHOW PROFILE FOR QUERY 1; 

or any number of your request.

What you get is a list where exactly how much time was spent during the request.

Additional information in the manual.

Answer 2

The answer becomes invalid ...

SHOW PROFILE[S] deprecated from MySQL 5.6.7 and will be removed in a future release of MySQL. Use a performance scheme instead; see http://dev.mysql.com/doc/refman/5.6/en/performance-schema-query-profiling.html