mysql 不能重启_mysql服务不能重启，请大神帮忙。-问答-阿里云开发者社区-阿里云...

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

文艺的龙猫

2015-04-02 23:17:08

17382

请问，我在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

大神请帮忙看看，谢谢了！

关系型数据库

MySQL

Linux

C语言

添加回答

分享到