Home > Database > Mysql Tutorial > mysql配置查询配置_MySQL

mysql配置查询配置_MySQL

WBOY
Release: 2016-06-01 13:11:16
Original
982 people have browsed it

命令行登入.

#开启慢查询

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慢查询,分析查询语句

source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template