开发者社区> 问答> 正文

mysql服务不能重启,请大神帮忙。

请问,我在putty 里 service mysql restart,然后报错:
ERROR! MySQL server PID file could not be found!
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/iZ23ssjxaufZ.pid).




我用的是wordpress镜像,下午挂载了数据盘,然后就成这样了。重启了服务器还是不行。


下面是日志:





150402 22:49:40 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


150402 22:49:40 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ23ssjxaufZ.pid ended
150402 23:08:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
150402 23:08:18 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
150402 23:08:18 [Note] Plugin 'FEDERATED' is disabled.
150402 23:08:18 InnoDB: The InnoDB memory heap is disabled
150402 23:08:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150402 23:08:18 InnoDB: Compressed tables use zlib 1.2.3
150402 23:08:18 InnoDB: Using Linux native AIO
150402 23:08:18 InnoDB: Initializing buffer pool, size = 128.0M
150402 23:08:18 InnoDB: Completed initialization of buffer pool
150402 23:08:18 InnoDB: highest supported file format is Barracuda.
150402 23:08:18  InnoDB: Waiting for the background threads to start
150402 23:08:19 InnoDB: Error: tablespace size stored in header is 3840 pages, but
150402 23:08:19 InnoDB: the sum of data file sizes is only 640 pages
150402 23:08:19 InnoDB: Cannot start InnoDB. The tail of the system tablespace is
150402 23:08:19 InnoDB: missing. Have you edited innodb_data_file_path in my.cnf in an
150402 23:08:19 InnoDB: inappropriate way, removing ibdata files from there?
150402 23:08:19 InnoDB: You can set innodb_force_recovery=1 in my.cnf to force
150402 23:08:19 InnoDB: a startup if you are trying to recover a badly corrupt database.
150402 23:08:19 [ERROR] Plugin 'InnoDB' init function returned error.
150402 23:08:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150402 23:08:19 [ERROR] Unknown/unsupported storage engine: InnoDB
150402 23:08:19 [ERROR] Aborting


150402 23:08:19 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


150402 23:08:19 mysqld_safe mysqld from pid file /usr/local/mysql/data/iZ23ssjxaufZ.pid ended




大神请帮忙看看,谢谢了!








展开
收起
文艺的龙猫 2015-04-02 23:17:08 18236 0
3 条回答
写回答
取消 提交回答
  • Remysql服务不能重启,请大神帮忙。
    一样的问题,你的现在解决了吗?
    2016-03-18 10:05:54
    赞同 展开评论 打赏
  • Remysql服务不能重启,请大神帮忙。
      
    2015-04-22 17:35:08
    赞同 展开评论 打赏
  • 分享阿里云支持与服务团队最佳实践、经典案例与故障排查。
    您好,查看您已经提交工单反馈此问题,查看mysql服务是正常应用的,同时建议您卸载其中一个mysql服务,如果还有问题可以再联系我们。
    2015-04-03 11:54:44
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像