Board logo

标题: [求助] MYSQL数据库突然挂了,重启服务器也不行,不知道咋回事,谁帮看看啊 [打印本页]

作者: 创新名公子    时间: 2017-12-19 17:47     标题: MYSQL数据库突然挂了,重启服务器也不行,不知道咋回事,谁帮看看啊

  1. 171219 14:28:36 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.69/var
  2. 171219 14:28:36 [ERROR] /www/wdlinux/mysql-5.1.69/libexec/mysqld: unknown variable 'innodb_additional_mem_pool_size=64M'
  3. 171219 14:28:36 [ERROR] Aborting

  4. 171219 14:28:36 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: Shutdown complete

  5. 171219 14:28:36 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/VM_160_226_centos.pid ended
  6. 171219 15:19:49 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.69/var
  7. 171219 15:19:49 [ERROR] /www/wdlinux/mysql-5.1.69/libexec/mysqld: unknown variable 'innodb_additional_mem_pool_size=64M'
  8. 171219 15:19:49 [ERROR] Aborting

  9. 171219 15:19:49 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: Shutdown complete

  10. 171219 15:19:49 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/VM_160_226_centos.pid ended
  11. 171219 16:03:32 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.69/var
  12. 171219 16:03:33 [ERROR] /www/wdlinux/mysql-5.1.69/libexec/mysqld: unknown variable 'innodb_additional_mem_pool_size=64M'
  13. 171219 16:03:33 [ERROR] Aborting

  14. 171219 16:03:33 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: Shutdown complete

  15. 171219 16:03:33 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/VM_160_226_centos.pid ended
复制代码
MySQL 的PID无法生成?重启服务器和数据库PID文件也会自动消失,怎么回事啊
作者: chensir    时间: 2017-12-20 09:45

修改下配置文件
作者: chensir    时间: 2017-12-20 09:46

我QQ382317712,可以联系我,我看下配置文件
作者: 创新名公子    时间: 2017-12-21 21:49

  1. 171220  8:54:21 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: Normal shutdown

  2. 171220  8:54:21 [Note] Event Scheduler: Purging the queue. 0 events
  3. 171220  8:54:21 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: Shutdown complete

  4. 171220 08:54:22 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/VM_160_226_centos.pid ended
  5. 171220 08:54:23 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.69/var
  6. 171220  8:54:23 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
  7. 171220  8:54:23 [Note] Event Scheduler: Loaded 0 events
  8. 171220  8:54:23 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
  9. Version: '5.1.69-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  10. 171220 19:03:11 mysqld_safe Number of processes running now: 0
  11. 171220 19:03:12 mysqld_safe mysqld restarted
  12. 171220 19:04:58 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
  13. 171220 19:06:18 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/VM_160_226_centos.pid ended
  14. 171221 07:57:15 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.69/var
  15. 171221  7:57:15 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
  16. 171221  7:57:16 [Note] Event Scheduler: Loaded 0 events
  17. 171221  7:57:16 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
  18. Version: '5.1.69-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  19. 171221 19:03:30 mysqld_safe Number of processes running now: 0
  20. 171221 19:04:18 mysqld_safe mysqld restarted
  21. 171221 19:05:28 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
  22. 171221 19:06:37 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.69/var/VM_160_226_centos.pid ended
  23. 171221 21:20:41 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.69/var
  24. 171221 21:20:41 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
  25. 171221 21:20:42 [Note] Event Scheduler: Loaded 0 events
  26. 171221 21:20:42 [Note] /www/wdlinux/mysql-5.1.69/libexec/mysqld: ready for connections.
  27. Version: '5.1.69-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
复制代码
不知道咋回事,一到晚上就挂,白天重启一下MYSQL好了,晚上就又挂了
作者: jekliu    时间: 2018-1-24 09:29

Wdcp的MySql好像确实有挺多问题
作者: m238200    时间: 2018-3-23 11:05

ln -sf /www/wdlinux/init.d/httpd /etc/rc.d/init.d/httpd
作者: m238200    时间: 2018-3-23 11:10

此命令有注释吗?




欢迎光临 WDlinux官方论坛 (http://www.wdlinux.cn/bbs/) Powered by Discuz! 7.2