chuzhaoqian 发表于 2016-10-26 15:16:00

无法开启mysql日志

/etc/my.cnf
log-error=/usr/local/mysql/log/error.log
log=/usr/local/mysql/log/mysql.log
long_query_time=2
log-slow-queries= /usr/local/mysql/log/slowquery.log

sudo /etc/init.d/mysql restart

[....] Restarting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
failed!


系统ubuntu 16lnmp1.3mysql 5.7.11

[ 本帖最后由 chuzhaoqian 于 2016-10-26 15:17 编辑 ]

licess 发表于 2016-10-26 16:59:11

mysql 5.7好像是没有log-slow-queries 参数，慢日志的看官网资料http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_slow_query_log
log-error默认就有，不需要在设置
具体要看mysql日志
页: [1]
查看完整版本: 无法开启mysql日志