美文网首页
mysql max_connections on ubuntu(

mysql max_connections on ubuntu(

作者: 早安明天_8731 | 来源:发表于2021-03-18 15:48 被阅读0次

一、mysql 5.7 on ubuntu 16.04

(1)sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
max_connections=10000
(2)sudo vim /lib/systemd/system/mysql.service
LimitNOFILE=infinity
LimitMEMLOCK=infinity
(3)sudo systemctl daemon-reload
(4)sudo service mysqld restart

二、0x02 mysql 8.0 on ubuntu 20.04

(1)sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
max_connections=10000
(2)sudo service mysqld restart

相关文章

网友评论

      本文标题:mysql max_connections on ubuntu(

      本文链接:https://www.haomeiwen.com/subject/wnovcltx.html