winnieji 发表于 2016-2-22 19:47:57

MYSQ挂掉的问题

昨天MYSQL又挂鸟。

当时VPS上不去，阿里云后台用终端连上后显示内存不足KILL了MYSQL（我2G内存）：



然后，MYSQL错误日志报的错是：

InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11

军哥，这是什么原因呀，难道是为MYSQL分配的内存过量？

licess 发表于 2016-2-22 21:04:21

out of memory
是内存不足了

日志发完整别就发这一条
有可能mysql数据库目录权限，有可能硬盘满了，也有可能是其他原因

winnieji 发表于 2016-2-22 21:46:28

军哥，完整日志：

licess 发表于 2016-2-24 12:52:49

2016-02-21 18:01:07 364 InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2016-02-21 18:01:07 364 InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-02-21 18:01:08 364 InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2016-02-21 18:01:09 364 InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2016-02-21 18:01:10 364 InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11

检查一下权限，把mysqld kill之后重启再看看
页: [1]
查看完整版本: MYSQ挂掉的问题