how do i take the most out of my max_user_connections?
Posted: Thu Dec 28, 2006 4:12 pm
I am using mysql and i will continue using because that's what my hosting service provides me.
Today i ran into an unexpected trouble.
max_user_connections exeded
I thought it could be a DDOS, but i checked my stats and it didnt look so at all.
I am on a shared server, i think the reason was: the database got slow to repply so a lot of connections were made and... boom! site down
I took the site out of the air for a while and now i put is back again and things are going ok, so far...
Ok, i need ideas not to be spammed down.
I never use mysql_close(); should i star using it? isnt the connection closed after the script execution anyway? will i gain some miliseconds by using it?
Any other idea?
I might be doing some comon mistake, if you know those please let me know about them.
thanks in advance
Today i ran into an unexpected trouble.
max_user_connections exeded
I thought it could be a DDOS, but i checked my stats and it didnt look so at all.
I am on a shared server, i think the reason was: the database got slow to repply so a lot of connections were made and... boom! site down
I took the site out of the air for a while and now i put is back again and things are going ok, so far...
Ok, i need ideas not to be spammed down.
I never use mysql_close(); should i star using it? isnt the connection closed after the script execution anyway? will i gain some miliseconds by using it?
Any other idea?
I might be doing some comon mistake, if you know those please let me know about them.
thanks in advance