查看“︁MySQL:SHOW PROFILE”︁的源代码

<pre>
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
</pre>
*refer:https://mariadb.com/kb/en/mariadb/show-profile/
<source lang="bash">
SET profiling = 1;
...do query
show profiles;
</source>
[[Category:Database]]