InnoDB安装完后，正常运行2个月后，突然无法启动

xdop

InnoDB安装完后，正常运行2个月后，突然无法启动（magento应用）


root报错提示、domain.com.err，my.cnf分别如下：


[root@domain var]# service mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/domain.com.pid).


domain.com.err
2015-03-29 08:53:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-03-29 08:53:00 22117 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2015-03-29 08:53:00 22117 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-03-29 08:53:00 b7763740 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.
2015-03-29 08:53:00 22117 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-29 08:53:00 22117 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-29 08:53:00 22117 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-03-29 08:53:00 22117 [Note] InnoDB: Memory barrier is not used
2015-03-29 08:53:00 22117 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-29 08:53:00 22117 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-29 08:53:00 22117 [Note] InnoDB: Initializing buffer pool, size = 64.0M
2015-03-29 08:53:00 22117 [Note] InnoDB: Completed initialization of buffer pool
2015-03-29 08:53:00 22117 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-29 08:53:00 22117 [Note] InnoDB: The log sequence numbers 3534478356 and 3534478356 in ibdata files do not match the log sequence number 3611202148 in the ib_logfiles!
2015-03-29 08:53:00 22117 [Note] InnoDB: Database was not shutdown normally!
2015-03-29 08:53:00 22117 [Note] InnoDB: Starting crash recovery.
2015-03-29 08:53:00 22117 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-03-29 08:53:00 22117 [Note] InnoDB: Restoring possible half-written data pages
2015-03-29 08:53:00 22117 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 752, file name mysql-bin.000033
2015-03-29 08:53:00 22117 [ERROR] InnoDB: Table mysql/innodb_index_stats in the InnoDB data dictionary has tablespace id 2, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2015-03-29 08:53:00 22117 [ERROR] InnoDB: Table mysql/innodb_table_stats in the InnoDB data dictionary has tablespace id 1, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2015-03-29 08:53:00 22117 [ERROR] InnoDB: Table mysql/slave_master_info in the InnoDB data dictionary has tablespace id 4, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
2015-03-29 08:53:00 22117 [ERROR] InnoDB: Table mysql/slave_relay_log_info in the InnoDB data dictionary has tablespace id 3, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be 150329 08:53:00 mysqld_safe mysqld from pid file /usr/local/mysql/var/domain.com.pid ended


my.cnf
[client]
#password = your_password
port  = 3306
socket  = /tmp/mysql.sock
# The MySQL server
[mysqld]
port  = 3306
socket  = /tmp/mysql.sock
datadir = /usr/local/mysql/var
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
# binary logging format - mixed recommended
binlog_format=mixed
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# 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 = 64M
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_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

[ 本帖最后由 xdop 于 2015-3-30 00:03 编辑 ]

licess

可能数据库目录权限有问题，执行 chown mysql:mysql /usr/local/mysql/var 后再重启试一下