Loading...
Real Time Issues

General Mysql Server Settings

Check below Mysql settings for several MySQL process to run without any interruption.

  • cat /etc/httpd/conf.modules.d/00-mpm.conf

LoadModule mpm_prefork_module modules/mod_mpm_prefork.so
StartServers 11
MinSpareServers 20
MaxSpareServers 50
ServerLimit 1500
MaxClients 1500
MaxRequestsPerChild 10000

  • cat /etc/my.cnf

max-connections = 50000

sudo systemctl daemon-reload

  • cat /etc/systemd/system/mysqld.service

LimitNOFILE = infinity
LimitMEMLOCK = infinity

Leave a Reply

Your email address will not be published. Required fields are marked *