mysql启动失败，但没有error信息，请问如何解决？

Question

服务器环境：centos 6.4
启动代码：

# service mysqld start
Starting MySQL... ERROR! The server quit without updating PID file (/mnt/data/mysql/mysql.pid).

检查日志文件，也没有error：

131026 11:25:45 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql
2013-10-26 11:25:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-10-26 11:25:46 13682 [Note] Plugin 'FEDERATED' is disabled.
2013-10-26 11:25:47 7feddd850720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2013-10-26 11:25:47 13682 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-26 11:25:47 13682 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-10-26 11:25:47 13682 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-26 11:25:47 13682 [Note] InnoDB: CPU does not support crc32 instructions
2013-10-26 11:25:47 13682 [Note] InnoDB: Using Linux native AIO
2013-10-26 11:25:47 13682 [Note] InnoDB: Initializing buffer pool, size = 10.0M
2013-10-26 11:25:47 13682 [Note] InnoDB: Completed initialization of buffer pool
131026 11:25:47 mysqld_safe mysqld from pid file /mnt/data/mysql/mysql.pid ended

检查目录权限：

# ls -l /mnt/data/
总用量 656020
drwxr-xr-x 7 mysql mysql      4096 10月 26 11:24 mysql

Answer 1

1. 請給出啟動失敗與所展示的日誌間的時間關係；
2. 請檢查 /var/log 下的通用日誌，例如 messages、daemon.log 之類；
3. 你的伺服器啟動腳本似乎是自己寫的或修改過，貼一下？

Answer 2

ls -lZ 檢查mysql datadir 的SELinux權限

如果是SELinux權限的問題可以用以下方法恢復 假設你的datadir是/var/lib/mysql:

semanage fcontext -a -t mysqld_db_t "/var/lib/mysql(/.*)?"
restorecon -Rv /var/lib/mysql

Answer 3

這個問題我也碰到過幾次。我把我做的內容寫一下，可能對你來說不一定有用。

1. 查看 /etc/my.cnf 配置中 datadir，pid-file，stocket 路徑是否正確
2. pid，socket 的目錄，都檢查下mysql的權限
3. 實在不行就pid，sock檔都放/tmp目錄下

不知道對你有沒有用

Answer 4

cat /var/log/messages

說明記憶體不夠,
top檢查下那些程式佔用記憶體,
或/etc/my.cnf調小buffer pool
或sync && echo 1 > /proc/sys/vm/drop_caches釋放記憶體