Home >Database >Mysql Tutorial >监控mysql执行的sql语句_MySQL
监控mysql执行的sql语句_MySQL
- WBOYOriginal
- 2016-06-01 13:42:281163browse
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
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如何使用临时表_MySQL