mysql 問題處理二則

1    解決 Mysql 錯誤日誌出現 "Error in accept: Too many open files"

open_files_limit=20000

[root@db-13 ~]# cat /etc/security/limits.conf

*   soft   nofile    131072
*   hard   nofile    131072
oracle   soft   nofile    131072
oracle   hard   nofile    131072
oracle   soft   nproc    131072
oracle   hard   nproc    131072
oracle   soft   core    unlimited
oracle   hard   core    unlimited
oracle   soft   memlock    70000000
oracle   hard   memlock    70000000

2      解決mysql由於SELINUX啟動失敗：

[root@db-71 ~]# cat /etc/issue
Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
Kernel \r on an \m

1  iptables
chkconfig --list iptables

2 SELINUX=enforcing
[root@db-71 ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#       enforcing - SELinux security policy is enforced.
#       permissive - SELinux prints warnings instead of enforcing.
#       disabled - SELinux is fully disabled.
SELINUX=enforcing
# SELINUXTYPE= type of policy in use. Possible values are:
#       targeted - Only targeted network daemons are protected.
#       strict - Full SELinux protection.
SELINUXTYPE=targeted
[root@db-71 ~]# vi  /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#       enforcing - SELinux security policy is enforced.
#       permissive - SELinux prints warnings instead of enforcing.
#       disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
#       targeted - Only targeted network daemons are protected.
#       strict - Full SELinux protection.
SELINUXTYPE=targeted

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/758322/viewspace-707338/，如需轉載，請註明出處，否則將追究法律責任。