mysqld_safe Starting mysqld daemon with databases from /export/mysql_data/var
170612  5:22:10 InnoDB: The InnoDB memory heap is disabled
170612  5:22:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170612  5:22:10 InnoDB: Compressed tables use zlib 1.2.3
170612  5:22:10 InnoDB: Initializing buffer pool, size = 16.0M
170612  5:22:10 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
170612  5:22:10  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process


解决办法：
解决办法：

[root@DBA log]# ps -ef|grep mysql
root     11979     1  0 Jul11 ?        00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe --datadir=/opt/mysql/data --pid-file=/opt/mysql/data/dba.sky-mobi.com.hz.bj.pid
mysql    12742 11972  0 Jul11 ?        00:03:19 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/opt/mysql/data --plugin-dir=/opt/mysql/lib/mysql/plugin --user=mysql --log-error=/opt/mysql/log/alert.log --open-files-limit=65535 --pid-file=/opt/mysql/data/dba.sky-mobi.com.hz.bj.pid --socket=/opt/mysql/run/mysql.sock --port=3306
root     29331 29081  0 15:48 pts/1    00:00:00 grep mysql
看到有其它进程占用了 mysql的data文件夹
最快的处理方法是 kill 掉这些进程之后 ，重新启动 mysql 正常启动

 

总结: 再启动mysql之前 先查看一下是否有其它的进程 占用mysql的数据文件

如果有则杀掉占用的进程 再启动mysql