mysql 有報錯 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

標籤：engine   lin   release   warning   mysqld   fail   tar   init   plugin   

 

sh-4.1# /etc/init.d/mysqld status ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) existssh-4.1# /etc/init.d/mysqld startStarting MySQL. ERROR! The server quit without updating PID file (/data1/mysql/mysql.pid).

sh-4.1# rm mysql sh-4.1# /etc/init.d/mysqld status ERROR! MySQL is not runningsh-4.1# /etc/init.d/mysqld startStarting MySQL. ERROR! The server quit without updating PID file (/data1/mysql/mysql.pid).

看了一下mysql的日誌有如下錯誤:

170104  9:44:06 [Note] /apps/mysql-5.5.38/bin/mysqld: Shutdown complete170104 09:44:06 mysqld_safe mysqld from pid file /data1/mysql/mysql.pid ended170104 09:46:12 mysqld_safe Starting mysqld daemon with databases from /data1/mysql/170104  9:46:12 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.170104  9:46:12 [Note] Plugin ‘FEDERATED‘ is disabled.170104  9:46:12 InnoDB: The InnoDB memory heap is disabled170104  9:46:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins170104  9:46:12 InnoDB: Compressed tables use zlib 1.2.3170104  9:46:12 InnoDB: Using Linux native AIO170104  9:46:12 InnoDB: Initializing buffer pool, size = 2.0GInnoDB: mmap(2197815296 bytes) failed; errno 12170104  9:46:12 InnoDB: Completed initialization of buffer pool170104  9:46:12 InnoDB: Fatal error: cannot allocate memory for the buffer pool170104  9:46:12 [ERROR] Plugin ‘InnoDB‘ init function returned error.170104  9:46:12 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed.170104  9:46:12 [ERROR] Unknown/unsupported storage engine: InnoDB170104  9:46:12 [ERROR] Aborting170104  9:46:12 [Note] /apps/mysql-5.5.38/bin/mysqld: Shutdown complete170104 09:46:12 mysqld_safe mysqld from pid file /data1/mysql/mysql.pid ended

從err日誌，可以看出，我分配的Initializing buffer pool, size = 2.0G，使得機器無法初始化。導致mysql啟動不起來。

這個值=>my.cnf的innodb_buffer_pool_size

sh-4.1# grep "innodb-buffer-pool-size" /etc/my.cnf innodb-buffer-pool-size        = 1G#innodb-buffer-pool-size        = 2G

問題解決啟動成功！！！！

mysql 有報錯　 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists