VPS侦探论坛

 找回密码
 注册
查看: 3523|回复: 1

无法开启mysql日志

[复制链接]
发表于 2016-10-26 15:16:00 | 显示全部楼层 |阅读模式

/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 16  lnmp1.3  mysql 5.7.11

[ 本帖最后由 chuzhaoqian 于 2016-10-26 15:17 编辑 ]
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 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日志
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-16 18:11 , Processed in 0.025314 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表