MySQL find SQL time-consuming bottleneck show profiles

1. First check whether the profiling function is turned on

 like ' %pro% '

Or

SELECT @ @profiling

2. Open Profiling

SET Profiling=1

3. Execute SQL statements
For example:

SELECTTable_schema as 'Db Name',    ROUND(SUM(Data_length+Index_length)/ 1024x768 / 1024x768,3) as 'Db Size (MB)',    ROUND(SUM(Data_free)/ 1024x768 / 1024x768,3) as 'Free Space (MB)'   fromInformation_schema.tablesGROUP  byTable_schema;

4. View Results

SHOW profiles; SHOW Profile All  forQUERY94; 94 is the query ID number. Show Profiles syntax: Show profile[type [, type]...] [For QUERY N]      [LIMIT row_count [offset offset]] Type: All    |BLOCK IO|CONTEXT Switches|CPU|IPC|MEMORY|PAGE faults|SOURCE|SWAPS

This article turns from http://blog.csdn.net/k_scott/article/details/8804384

MySQL find SQL time-consuming bottleneck show profiles