Home  >  Article  >  Database  >  mysql配置查询配置_MySQL

mysql配置查询配置_MySQL

WBOY
WBOYOriginal
2016-06-01 13:11:16959browse

命令行登入.

#开启慢查询

mysql>show variables like '%long%';

mysql>set global long_query_time=2;

mysql>show variables like '%slow%';

slow_query_log    off    #if  slow_query_log is off

mysql>set global show_query_log='ON';

slow_query_log    ON



参考:linux下开启mysql慢查询,分析查询语句

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