请求帮助ERROR! MySQL server PID file could not be found!

affpay

网站：
Error establishing a database connection

重启lnmp：
ERROR! MySQL server PID file could not be found!

Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/var/vultr.guest.pid).



vultr.guest.err：

170424 16:21:50 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170424 16:21:50 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
170424 17:11:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170424 17:11:31 InnoDB: The InnoDB memory heap is disabled
170424 17:11:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170424 17:11:31 InnoDB: Compressed tables use zlib 1.2.3
170424 17:11:31 InnoDB: Initializing buffer pool, size = 16.0M
170424 17:11:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
170424 17:11:31 InnoDB: Could not open or create data files.
170424 17:11:31 InnoDB: If you tried to add new data files, and it failed here,
170424 17:11:31 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170424 17:11:31 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170424 17:11:31 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170424 17:11:31 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170424 17:11:31 InnoDB: remove old data files which contain your precious data!
170424 17:11:31 [ERROR] Plugin 'InnoDB' init function returned error.
170424 17:11:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170424 17:11:31 [ERROR] Unknown/unsupported storage engine: InnoDB
170424 17:11:31 [ERROR] Aborting

170424 17:11:31 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170424 17:11:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
170425 09:34:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170425  9:34:03 InnoDB: The InnoDB memory heap is disabled
170425  9:34:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170425  9:34:03 InnoDB: Compressed tables use zlib 1.2.3
170425  9:34:03 InnoDB: Initializing buffer pool, size = 16.0M
170425  9:34:03 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
170425  9:34:03 InnoDB: Could not open or create data files.
170425  9:34:03 InnoDB: If you tried to add new data files, and it failed here,
170425  9:34:0170425 09:34:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
170425 09:38:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170425  9:38:06 InnoDB: The InnoDB memory heap is disabled
170425  9:38:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170425  9:38:06 InnoDB: Compressed tables use zlib 1.2.3
170425  9:38:06 InnoDB: Initializing buffer pool, size = 16.0M
170425  9:38:06 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
170425  9:38:06 InnoDB: Could not open or create data files.
170425  9:38:06 InnoDB: If you tried to add new data files, and it failed here,
170425  9:38:06 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170425  9:38:06 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170425  9:38:06 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170425  9:38:06 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170425  9:38:06 InnoDB: remove old data files which contain your precious data!
170425  9:38:06 [ERROR] Plugin 'InnoDB' init function returned error.
170425  9:38:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170425  9:38:06 [ERROR] Unknown/unsupported storage engine: InnoDB
170425  9:38:06 [ERROR] Aborting

170425  9:38:06 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170425 09:38:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
170425 09:38:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170425  9:38:24 InnoDB: The InnoDB memory heap is disabled
170425  9:38:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170425  9:38:24 InnoDB: Compressed tables use zlib 1.2.3
170425  9:38:24 InnoDB: Initializing buffer pool, size = 16.0M
170425  9:38:24 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
170425  9:38:24 InnoDB: Could not open or create data files.
170425  9:38:24 InnoDB: If you tried to add new data files, and it failed here,
170425  9:38:24 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170425  9:38:24 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170425  9:38:24 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170425  9:38:24 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170425  9:38:24 InnoDB: remove old data files which contain your precious data!
170425  9:38:24 [ERROR] Plugin 'InnoDB' init function returned error.
170425  9:38:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170425  9:38:24 [ERROR] Unknown/unsupported storage engine: InnoDB
170425  9:38:24 [ERROR] Aborting

170425  9:38:24 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170425 09:38:24 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
170425 09:52:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170425  9:52:48 InnoDB: The InnoDB memory heap is disabled
170425  9:52:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170425  9:52:48 InnoDB: Compressed tables use zlib 1.2.3
170425  9:52:48 InnoDB: Initializing buffer pool, size = 128.0M
170425  9:52:48 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file /usr/local/mysql/var/ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
170425  9:52:48 InnoDB: Could not open or create data files.
170425  9:52:48 InnoDB: If you tried to add new data files, and it failed here,
170425  9:52:48 InnoDB: you should now edit innodb_data_file_path in my.cnf back
170425  9:52:48 InnoDB: to what it was, and remove the new ibdata files InnoDB created
170425  9:52:48 InnoDB: in this failed attempt. InnoDB only wrote those files full of
170425  9:52:48 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
170425  9:52:48 InnoDB: remove old data files which contain your precious data!
170425  9:52:48 [ERROR] Plugin 'InnoDB' init function returned error.
170425  9:52:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170425  9:52:48 [ERROR] Unknown/unsupported storage engine: InnoDB
170425  9:52:48 [ERROR] Aborting

170425  9:52:48 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

170425 09:52:48 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended

licess

修改过 innodb_data_file_path 吗？
再改成原来的10M应该就可以了

看你innodb_log_buffer_size也改了，如果机器配置低，太大也会造成问题

affpay

好的 谢谢 我改回来试试

affpay

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 128M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M

这两个参数我看了 没改过
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_buffer_size = 8M