Posts

Showing posts from October, 2006

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