With CentOS 7 you need to increase file limits and file descriptors for max connections to work
Increase Max File Limit
#Modify Following File /etc/sysctl.conf #Add following to file fs.file-max = 100000
Increase Soft / Hard Limits
#Modify Following File /etc/security/limits.conf #Add following to file soft nproc 65535 hard nproc 65535 soft nofile 65535 hard nofile 65535 mysql hard nofile 65535 mysql soft nofile 65535 #Commit the above settings sysctl -p
Edit MySQL SystemD Service Limits
#Modify Following File /usr/lib/systemd/system/mysqld.service #Add following to file below [service] LimitNOFILE=65535 LimitNPROC=65535 #Reload the daemon with above settings systemctl daemon-reload
Edit MySQL Configuration file with settings required:
#Modify following file: /etc/my.cnf #Add following information (change if required) open_files_limit = 1024 max_connections = 1000 #Restart MySQL to commit systemctl restart mysqld #Log into mysql and run show variables like "max_connections"; to check max connections is correct
Add new attachment
Only authorized users are allowed to upload new attachments.
«
This page (revision-1) was last changed on 24-May-2017 15:30 by Hyve Support