数据库连接错误&数据库未正常关闭

Question

我需要一些wordpress站点数据库错误的解决方案。我一个月前就遇到了这个DB错误。我不知道这个数据库连接错误的原因是什么。请回顾我的error.log提供您的继承。

2018-06-19 15:59:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-06-19 15:59:16 4297 [Note] Plugin 'FEDERATED' is disabled.
2018-06-19 15:59:16 4297 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-06-19 15:59:16 4297 [Note] InnoDB: The InnoDB memory heap is disabled
2018-06-19 15:59:16 4297 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-06-19 15:59:16 4297 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-06-19 15:59:16 4297 [Note] InnoDB: Using Linux native AIO
2018-06-19 15:59:16 4297 [Note] InnoDB: Using CPU crc32 instructions
2018-06-19 15:59:16 4297 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2018-06-19 15:59:16 4297 [Note] InnoDB: Completed initialization of buffer pool
2018-06-19 15:59:16 4297 [Note] InnoDB: Highest supported file format is Barracuda.
2018-06-19 15:59:16 4297 [Note] InnoDB: The log sequence numbers 50223779105 and 50223779105 in ibdata files do not match the log sequence number 50225310342 in the ib_logfiles!
2018-06-19 15:59:16 4297 [Note] InnoDB: Database was not shutdown normally!
2018-06-19 15:59:16 4297 [Note] InnoDB: Starting crash recovery.
2018-06-19 15:59:16 4297 [Note] InnoDB: Reading tablespace information from the .ibd files...

Answer 1

首先检查您所在服务器的正常运行时间，因为某些原因您的服务器正在重新启动，如果正常运行时间，那么您需要检查是否有任何HDD或内存问题，检查错误块或ram错误。

您可以尝试使用"mysqlcheck -自动修复-o -所有数据库“修复mysql数据库/表。

您应该添加一个cron作业来每天备份数据，万一mysql恢复失败，则可以恢复。