Home > Database > Mysql Tutorial > 监控mysql执行的sql语句_MySQL

监控mysql执行的sql语句_MySQL

WBOY
Release: 2016-06-01 13:42:28
Original
1157 people have browsed it

bitsCN.com 监控mysql执行的sql语句 为了做好配合开发做性能和功能测试,方便监控正在执行的sql语句,

可以在/etc/mysqld中添加如下:
 log =/usr/local/mysql/var21005/mysql.log就可以使用:tail -f mysql.log来监控了     如果需要监控慢查询可以添加如下内容:
 log-slow-queries = /usr/local/mysql/var21005/slowquery.loglong_query_time = 1   作者 gzh0222 bitsCN.com

Related labels:
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