通过本文主要向大家介绍了mysql profiling,profiling,profiling是什么意思,profiling翻译,racial profiling等相关知识,希望本文的分享对您有所帮助
</div>
1. show variables like '%profiling%';(查看profiling信息) </div>
</div>
</div>
</div>
3. 执行SQL查询 </div>
例:select goods_name from ecs_goods where goods_id <5000;</div>
</div>
</div>
</div>
</div>
4. show profile for query 4;</div>
</div>
</div>
SHOW PROFILE [type [, type] ... ]</div>
[FOR QUERY n]</div>
[LIMIT row_count [OFFSET offset]]</div>
</div>
type:</div>
ALL</div>
| BLOCK IO</div>
| CONTEXT SWITCHES</div>
| CPU</div>
| IPC</div>
| MEMORY</div>
| PAGE FAULTS</div>
| SOURCE</div>
| SWAPS </div>
</div>