Hello im currently running a website which is getting inexcess of 10,000 hits an hour from both real users and Googlebots (had 150,000 GB hits last week alone!) of late i have started running into database issues. I often go to the site and get an error message saying something like 'cannot connect to sel too many connections' i need to get this fixed as it is losing my site business. I have mysql 4.1 running does anyone know how i can increase the maxium no of connections, i run the site from a 2.4 dual xeon dedicated with 1gb ram so i have plenty of resources to hike it right up. any help or if you could point me to a guide would be most welcome thanks, carl
Add max_connections to your my.ini or my.cnf Sample: [mysqld] # The maximum amount of concurrent sessions the MySQL server will # allow. One of these connections will be reserved for a user with # SUPER privileges to allow the administrator to login even if the # connection limit has been reached. max_connections=100
I would recommend letting your web host do that for you. In fact, ask them to optimize your my.cnf for you, based on your server's resources.