mariadb10.2 mysql5.7_【MySQL基础】MySQL安装第三弹-mariadb-10.2.8

[root@localhost ~]# 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) 7861

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) 7861

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

#open files最大打开文件数限制

#max user processes 每个用户最大processes数量

vim /etc/security/limits.conf

* soft nofile 65535

* hard nofile 65535

* soft nproc 65535

* hard nproc 65535

[root@localhost ~]# ulimit -a

open files (-n) 65535

max user processes (-u) 65535

#每个操作系统修改方式可能不一样，参考一个操作系统的官方文档或google一下

2.3io调度器修改

io调度器修改为deadline