sysctl mysql_MySQL的Linux环境设置

MySQL的Linux环境设置

关闭selinux

查看selinux状态：

[root@betacat selinux]# sestatus

SELinux status: enabled

SELinuxfs mount: /sys/fs/selinux

SELinux root directory: /etc/selinux

Loaded policy name: targeted

Current mode: enforcing

Mode from config file: disabled

Policy MLS status: enabled

Policy deny_unknown status: allowed

Max kernel policy version: 28

在配置文件中设置关闭selinux：

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 - No SELinux policy is loaded.

SELINUX=enforcing

# SELINUXTYPE= can take one of three two values:

# targeted - Targeted processes are protected,

# minimum - Modification of targeted policy. Only selected processes are protected.

# mls - Multi Level Security protection.

SELINUXTYPE=targeted

将SELINUX=enforcing改成SELINUX=disabled

系统IO调度模式改为deadline

查看当前模式：

[root@betacat ~]# dmesg | grep -i scheduler

[ 0.334857] io scheduler noop registered

[ 0.334860] io scheduler deadline registered

[ 0.334899] io scheduler cfq registered (default)

如果默认已经是deadline就不需要改。

修改：

[root@betacat ~]# grubby --update-kernel=ALL --args="elevator=deadline"

重启系统

上面两点都是需要重启系统后才生效的：

[root@betacat ~]# reboot

设备swap分区大小

查看：

[root@betacat ~]# cat /proc/sys/vm/swappiness

20

[root@betacat ~]# sysctl -a | grep swap

sysctl: reading key "net.ipv6.conf.all.stable_secret"

sysctl: reading key "net.ipv6.conf.default.stable_secret"

sysctl: reading key "net.ipv6.conf.ens33.stable_secret"

sysctl: reading key "net.ipv6.conf.lo.stable_secret"

vm.swappiness = 20

修改：

[root@betacat ~]# vi /etc/sysctl.conf

# sysctl settings are defined through files in

# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.

#

# Vendors settings live in /usr/lib/sysctl.d/.

# To override a whole file, create a new file with the same in

# /etc/sysctl.d/ and put new settings there. To override

# only specific settings, add a file with a lexically later

# name in /etc/sysctl.d/ and put new settings there.

#

# For more information, see sysctl.conf(5) and sysctl.d(5).

vm.swappiness=30

修改操作系统限制

查看：

[root@betacat ~]# ulimit -a

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 7215

max locked memory (kbytes, -l) 64

max memory size (kbytes, -m) unlimited

open files (-n) 1024 ###

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 8192

cpu time (seconds, -t) unlimited

max user processes (-u) 7215 ###

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

修改系统的软硬限制：

[root@betacat ~]# vi /etc/security/limits.conf

加入以下内容,然后重启系统：

#

#

#

#* soft core 0

#* hard rss 10000

#@student hard nproc 20

#@faculty soft nproc 20

#@faculty hard nproc 50

#ftp hard nproc 0

#@student - maxlogins 4

* soft nproc 65535

* hard nproc 65535

* soft nofile 65535

* hard nofile 65535

# End of file