mySQL error: Too many Connection

[mumbhaki]

it seems that more and more people are using my tracker for friendster...

and also comes this new scalability issue
mySQL error: Too many Connection

im just new to php and mysql, can somebody suggest some do's and dont's so that this problem be avoided

currently the tracker uses atleast 3 sql queries per hit, and will make ajax request(another 3 sql queries) per minute until the visitor leaves the profile...

 

[Flashgear]

You haven't done anything, its x10 servers, my forum is also displaying the same error message.

 

[mumbhaki]

oh, i thought it has something to do with my coding

 

[rickle42]

I was wondering about this myself. If you never create a single user on the database (other than admin) how does mysql react if 20 users are making queries? Seems like you would have to create some accounts and assign them to the users. You are saying this is not the case and that it is done for you?
Edit:
in addition, maybe youre code could check if connect went through and if not try again in 2 seconds and repeat...I have never dealt with massive trafffic either so i am just guessing