Posted by: major in Database
The default is 100, but sometimes that’s not enough!
For MySQL 3.x:
# vi /etc/my.cnf
set-variable = max_connections = 250
For MySQL 4.x and 5.x:
# vi /etc/my.cnf
max_connections = 250
Restart MySQL once you’ve made the changes and verify with:
echo “show variables like ‘max_connections’;” | mysql
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.
This entry was posted on Wednesday, January 24th, 2007 at 11:21 am and is filed under Database.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Entries (RSS)