Home >Database >Mysql Tutorial >Mysql自带profiling性能分析工具使用分享_MySQL
Mysql自带profiling性能分析工具使用分享_MySQL
- WBOYOriginal
- 2016-06-01 13:23:081087browse
bitsCN.com
1. show variables like '%profiling%';(查看profiling信息) 
2. set profiling=1;（开启profiling） 
3. 执行SQL查询 例:select goods_name from ecs_goods where goods_id 
4. show profile for query 4;
show profile 的格式如下：
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 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql导入导出数据中文乱码解决方法小结_MySQLNext article：mysql 服务意外停止1067错误解决办法小结_MySQL