https://wiki.riguz.com/index.php?action=history&feed=atom&title=MySQL%3ASHOW_PROFILE
MySQL:SHOW PROFILE - 版本历史
2026-06-02T21:33:25Z
本wiki上该页面的版本历史
MediaWiki 1.42.3
https://wiki.riguz.com/index.php?title=MySQL:SHOW_PROFILE&diff=2046&oldid=prev
imported>Soleverlee：以“<pre> SHOW PROFILE [type [, type] ... ] [FOR QUERY n] [LIMIT row_count [OFFSET offset]] type: ALL | BLOCK IO | CONTEXT SWITCHES | CPU | IPC |...”为内容创建页面
2017-01-14T06:18:17Z
<p>以“<pre> SHOW PROFILE [type [, type] ... ] [FOR QUERY n] [LIMIT row_count [OFFSET offset]] type: ALL | BLOCK IO | CONTEXT SWITCHES | CPU | IPC |...”为内容创建页面</p>
<p><b>新页面</b></p><div><pre><br />
SHOW PROFILE [type [, type] ... ]<br />
[FOR QUERY n]<br />
[LIMIT row_count [OFFSET offset]]<br />
<br />
type:<br />
ALL<br />
| BLOCK IO<br />
| CONTEXT SWITCHES<br />
| CPU<br />
| IPC<br />
| MEMORY<br />
| PAGE FAULTS<br />
| SOURCE<br />
| SWAPS<br />
</pre><br />
*refer:https://mariadb.com/kb/en/mariadb/show-profile/<br />
<source lang="bash"><br />
SET profiling = 1;<br />
...do query<br />
show profiles;<br />
</source><br />
[[Category:Database]]</div>
imported>Soleverlee