ITPub博客

首页 > Linux操作系统 > Linux操作系统 > mysql 问题处理二则

mysql 问题处理二则

原创 Linux操作系统 作者:aaqwsh 时间:2011-09-13 15:04:49 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-24

  • 博文量
    132
  • 访问量
    262616