MYSQ挂掉的问题

winnieji

昨天MYSQL又挂鸟。

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



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

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

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

licess

out of memory
是内存不足了

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

winnieji

军哥，完整日志：

licess

2016-02-21 18:01:07 364 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2016-02-21 18:01:07 364 [Note] 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 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11
2016-02-21 18:01:09 364 [Note] 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 [ERROR] InnoDB: Unable to lock /usr/local/mysql/var/ibdata1, error: 11

检查一下权限，把mysqld kill之后重启再看看