MySQL 总是无缘无故死机

MySQL 总是无缘无故死机

我正在寻找具有以下规格的 VPS:Centos 6、50GB HDD 和 512MB 内存。

我遇到的问题是 MySQL 不断无缘无故崩溃。我仔细检查了日志文件,发现以下情况:

Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
140217 15:12:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140217 15:12:40 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
140217 15:12:40  InnoDB: Initializing buffer pool, size = 8.0M
140217 15:12:40  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140217 15:12:40  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140217 15:12:41  InnoDB: Started; log sequence number 0 1613784
140217 15:12:41 [Note] Event Scheduler: Loaded 0 events
140217 15:12:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

当我重新启动服务时,它返回“另一个 MySQL 守护进程已使用相同的 unix 套接字运行。”。为了解决这个问题,我只需重命名/删除 sock 文件即可。MySQL 服务器启动,但在几个小时或几天内它又崩溃了。

关于如何调试或解决此问题有什么建议吗?这可能与内存使用有关吗?

相关内容