请求帮助ERROR! MySQL server PID file could not be found!
网站：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 /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 Plugin 'InnoDB' init function returned error.
170424 17:11:31 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170424 17:11:31 Unknown/unsupported storage engine: InnoDB
170424 17:11:31 Aborting
170424 17:11:31 /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
1704259:34:03 InnoDB: The InnoDB memory heap is disabled
1704259:34:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1704259:34:03 InnoDB: Compressed tables use zlib 1.2.3
1704259:34:03 InnoDB: Initializing buffer pool, size = 16.0M
1704259: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!
1704259:34:03 InnoDB: Could not open or create data files.
1704259:34:03 InnoDB: If you tried to add new data files, and it failed here,
1704259: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
1704259:38:06 InnoDB: The InnoDB memory heap is disabled
1704259:38:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1704259:38:06 InnoDB: Compressed tables use zlib 1.2.3
1704259:38:06 InnoDB: Initializing buffer pool, size = 16.0M
1704259: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!
1704259:38:06 InnoDB: Could not open or create data files.
1704259:38:06 InnoDB: If you tried to add new data files, and it failed here,
1704259:38:06 InnoDB: you should now edit innodb_data_file_path in my.cnf back
1704259:38:06 InnoDB: to what it was, and remove the new ibdata files InnoDB created
1704259:38:06 InnoDB: in this failed attempt. InnoDB only wrote those files full of
1704259:38:06 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
1704259:38:06 InnoDB: remove old data files which contain your precious data!
1704259:38:06 Plugin 'InnoDB' init function returned error.
1704259:38:06 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
1704259:38:06 Unknown/unsupported storage engine: InnoDB
1704259:38:06 Aborting
1704259:38:06 /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
1704259:38:24 InnoDB: The InnoDB memory heap is disabled
1704259:38:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1704259:38:24 InnoDB: Compressed tables use zlib 1.2.3
1704259:38:24 InnoDB: Initializing buffer pool, size = 16.0M
1704259: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!
1704259:38:24 InnoDB: Could not open or create data files.
1704259:38:24 InnoDB: If you tried to add new data files, and it failed here,
1704259:38:24 InnoDB: you should now edit innodb_data_file_path in my.cnf back
1704259:38:24 InnoDB: to what it was, and remove the new ibdata files InnoDB created
1704259:38:24 InnoDB: in this failed attempt. InnoDB only wrote those files full of
1704259:38:24 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
1704259:38:24 InnoDB: remove old data files which contain your precious data!
1704259:38:24 Plugin 'InnoDB' init function returned error.
1704259:38:24 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
1704259:38:24 Unknown/unsupported storage engine: InnoDB
1704259:38:24 Aborting
1704259:38:24 /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
1704259:52:48 InnoDB: The InnoDB memory heap is disabled
1704259:52:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1704259:52:48 InnoDB: Compressed tables use zlib 1.2.3
1704259:52:48 InnoDB: Initializing buffer pool, size = 128.0M
1704259: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!
1704259:52:48 InnoDB: Could not open or create data files.
1704259:52:48 InnoDB: If you tried to add new data files, and it failed here,
1704259:52:48 InnoDB: you should now edit innodb_data_file_path in my.cnf back
1704259:52:48 InnoDB: to what it was, and remove the new ibdata files InnoDB created
1704259:52:48 InnoDB: in this failed attempt. InnoDB only wrote those files full of
1704259:52:48 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
1704259:52:48 InnoDB: remove old data files which contain your precious data!
1704259:52:48 Plugin 'InnoDB' init function returned error.
1704259:52:48 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
1704259:52:48 Unknown/unsupported storage engine: InnoDB
1704259:52:48 Aborting
1704259:52:48 /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 修改过 innodb_data_file_path 吗？
再改成原来的10M应该就可以了
看你innodb_log_buffer_size也改了，如果机器配置低，太大也会造成问题
回复 2# 的帖子
好的 谢谢 我改回来试试回复 2# 的帖子
# Uncomment the following if you are using InnoDB tablesinnodb_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
页:
[1]