Increase MySQL max concurrent connection limit

MySQL max default concurrent connection limit is 100. We should increase for high-performance system.

Edit /etc/my.cnf

[mysqld]

set-variable=max_connections=250

------------------------------------------------------------------------------------

If your application is php program, you might want to prevent persistent links.

Edit /etc/php.ini

[MySQL]

; Allow or prevent persistent links.

mysql.allow_persistent=Off

----------------------------------------------------------------------------------

Note: Applicable to MySQL 3.x