Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.5Mb
PDF (A4) - 31.6Mb
PDF (RPM) - 30.1Mb
EPUB - 7.7Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.5Mb
HTML Download (RPM) - 6.5Mb
Eclipse Doc Plugin (TGZ) - 8.2Mb
Eclipse Doc Plugin (Zip) - 10.1Mb
Man Pages (TGZ) - 181.4Kb
Man Pages (Zip) - 292.4Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
Excerpts from this Manual

13.7.5.32 SHOW PROFILES Syntax

SHOW PROFILES

The SHOW PROFILES statement, together with SHOW PROFILE, displays profiling information that indicates resource usage for statements executed during the course of the current session. For more information, see Section 13.7.5.31, “SHOW PROFILE Syntax”.

Note

These statements are deprecated as of MySQL 5.6.7 and will be removed in a future MySQL release. Use the Performance Schema instead; see Chapter 22, MySQL Performance Schema.


User Comments
  Posted by Mark Callaghan on November 6, 2008
The disclaimer about getrusage() should be more explicit. You cannot get per-thread resource stats from getrusage() on Linux today. PeterG provides some details on this -- http://blogs.mysql.com/peterg/2008/11/06/show-profile-information_schemaprofiling/
  Posted by Jiju Thomas Mathew on April 10, 2009
Open PHP MyProfiler (http://www.php-trivandrum.org/open-php-myprofiler) is just a trial to run query profiling on a php-mysql application, without changing the architecture too much. Thanks to the built in profiler
  Posted by Morgan Tocker on December 10, 2013
I have written an example replacement for SHOW PROFILES using performance_schema here:
http://www.tocker.ca/2013/12/10/testing-the-union-all-optimization-in-mysql-5.7-dmr3.html

This may be helpful for users not wanting to rely on deprecated features (SHOW PROFILES is deprecated from 5.6, and may be removed in a future version).
Sign Up Login You must be logged in to post a comment.