search

Home >Database >Mysql Tutorial >mysql学习之一_MySQL

mysql学习之一_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:34:40833browse

bitsCN.com

mysql学习之一

 

explain SQL语句：查询消耗的时间

select version()：查看mysql版本

 

show profiles：分析sql性能

set profiling=1：打开profiles功能，默认是关闭的

show profile for query x（x为query_id）：根据query_id 查看某个查询的详细时间耗费

show profile block io,cpu,memory,swaps,source,context switches for query x（x为query_id）：查看占用cpu、 io等信息

 

1.清除缓存

reset query cache ;

flush tables;

 

2.查看表的索引：

show index from 表名;

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：SQL Mode及相关问题_MySQL

Related articles

See more