打印

mysql 重启出错

mysql 重启出错

军哥:   今天把阿里云重启了一下,结果 数据启动不起来了

结果重新全部卸载了LNMP 然后重新装,结果  提示
MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
Active Internet connections (only servers)

启动的时候,MYSQL有这样的错误
下面的错误如何解决

170802 19:27:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var


2017-08-02 19:27:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).


2017-08-02 19:27:42 3361 [Note] Plugin 'FEDERATED' is disabled.


2017-08-02 19:27:42 7f443ba74740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.


2017-08-02 19:27:42 3361 [Note] InnoDB: Using atomics to ref count buffer pool pages


2017-08-02 19:27:42 3361 [Note] InnoDB: The InnoDB memory heap is disabled


2017-08-02 19:27:42 3361 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins


2017-08-02 19:27:42 3361 [Note] InnoDB: Memory barrier is not used


2017-08-02 19:27:42 3361 [Note] InnoDB: Compressed tables use zlib 1.2.3


2017-08-02 19:27:42 3361 [Note] InnoDB: Using CPU crc32 instructions



2017-08-02 19:27:42 3361 [Note] InnoDB: Initializing buffer pool, size = 16.0M


2017-08-02 19:27:42 3361 [Note] InnoDB: Completed initialization of buffer pool


2017-08-02 19:27:42 3361 [Note] InnoDB: Setting log file /usr/local/mysql/var/ib_logfile101 size to 5 MB


2017-08-02 19:27:42 7f443ba747402017-08-02 19:27:42 3361 [ERROR] InnoDB: Failure of system call pwrite(). Operating system error number is 28.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html


2017-08-02 19:27:42 3361 [ERROR] InnoDB: Cannot set log file /usr/local/mysql/var/ib_logfile101 to size 5 MB


2017-08-02 19:27:42 3361 [ERROR] Plugin 'InnoDB' init function returned error.


2017-08-02 19:27:42 3361 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.


2017-08-02 19:27:42 3361 [ERROR] Unknown/unsupported storage engine: InnoDB


2017-08-02 19:27:42 3361 [ERROR] Aborting

TOP

上面日志有说明,当前磁盘或分区满了,没有可用空间了

TOP