I AM running a MLM site on the dedicated server having more than 30k members. I am getting error already has more than 'max_user_connections' active connections I increased the max_user_connections from default 25 to 200 but still i am getting the problem. I also tried by using mysql_close() fucntion but the problem is still same. Someone suggested me that there is problem in script... What could be the problem ? Is it the problem of script ? If yes please tell me the solution. or tell me the server setting if it needed. I will be very Thankfull for saving my site.
If all the members are connecting at the same time and stay longer, you might ahve to configure the timeout depending on your needs or it's time to expand. You may want to have mysqltuner.pl and tuning-primer.sh installed. They'll tell you what specs you need to change sql qise and give tips and advises and probably values.
Make sure that colse the connection once the operation is finished. If you are using java technology try using connection pool. Also Increase MySQL connection Limit.