Golfreeze.packetlove.com: Life style of Golfreeze Canon400D Family kammtan.com Jazz Freebsd Unix Linux System Admin guitar Music

All about unix linux freebsd and FAQ for Packetlove.com Web hosting , Mail hosting , VoIP + IP PBX server => all application on unix knowledges by golfreeze => Topic started by: golfreeze on มกราคม 15, 2019, 08:16:33 PM

Title: max_connections in mysqld.cnf not change from 214 in ubuntu 16.04 mysql 5.7
Post by: golfreeze on มกราคม 15, 2019, 08:16:33 PM
วันนี้เจอเคส เมื่อ
max_connections in mysqld.cnf not change from 214 in ubuntu 16.04 mysql 5.7

#### Begin Fixed max_connections =5120 in /etc/mysql/mysql.conf.d/mysqld.cnf ####
Follow the following steps:

cp /lib/systemd/system/mysql.service /etc/systemd/system/
echo -e "\r\nLimitNOFILE=infinity" >> /etc/systemd/system/mysql.service
echo "LimitMEMLOCK=infinity" >> /etc/systemd/system/mysql.service
sudo systemctl daemon-reload
sudo service mysql restart
And change or add he following line into file /etc/mysql/mysql.conf.d/mysqld.cnf :

[mysqld]
max_connections=110
#### Finish Fixed max_connections =5120 in /etc/mysql/mysql.conf.d/mysqld.cnf ####