Total Pageviews

Monday, 24 November 2008

Increase MySQL connection limit

The default is 100, but sometimes that’s not enough!

For MySQL 3.x:
# nano /etc/my.cnf
set-variable = max_connections = 250

For MySQL 4.x and 5.x:
# nano /etc/my.cnf
max_connections = 250

Restart MySQL once you’ve made the changes and verify with:
echo “show variables like ‘max_connections’;” | mysql

No comments: