Jump to content
xisto Community
Sign in to follow this  
Followers 0
krap

Too Many Connections Created In Mysql By My Site

By krap, in Programming

Recommended Posts

krap    0

krap
Posted

Hi
i am hosted at Xisto - Web Hosting (which is great btw) but my site is causing mysql to hang because it is flooded and it causes my account to be suspended alot..
What is confusing is that not many users (7) are only when it happens and it is not a deliberate flooding. The mysql proccesslist when it gets too many connections:

| 7971 | andre_krap | localhost | andre_wap | Query | 439 | Sending data | SELECT unread,sentby,id FROM private WHERE sentto='Candi.Boi'
ORDER BY id DESC LIMIT 0,15 |
| 7973 | andre_krap | localhost | andre_wap | Query | 2 | Sending
data | SELECT COUNT(*) FROM posts WHERE forum='43' AND thread='1'
|
| 7975 | andre_krap | localhost | andre_wap | Sleep | 1 |
|
|
| 7987 | andre_krap | localhost | andre_wap | Query | 10 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND
sentto='fatal.' |
| 7992 | andre_krap | localhost | andre_wap | Query | 21 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='butta'
|
| 7996 | andre_krap | localhost | andre_wap | Query | 22 | closing
tables | SELECT COUNT(*) FROM private WHERE sentto='rap.pro'
|
| 8001 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND
sentto='PROPHETZ' |
| 8006 | andre_krap | localhost | andre_wap | Query | 21 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='at0z'
|
| 8009 | andre_krap | localhost | andre_wap | Sleep | 1 |
|
|
| 8012 | andre_krap | localhost | andre_wap | Sleep | 1 |
|
|
| 8015 | andre_krap | localhost | andre_wap | Sleep | 3 |
|
|
| 8016 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lacoste'
|
| 8029 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='rap.pro'
|
| 8030 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='angelfly'
|
| 8042 | andre_krap | localhost | andre_wap | Query | 24 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='at0z'
|
| 8052 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8073 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='angelfly'
|
| 8093 | andre_krap | localhost | andre_wap | Query | 20 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='angelfly'
|
| 8105 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='candi.boi'
|
| 8106 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8107 | andre_krap | localhost | andre_wap | Query | 21 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='at0z'
|
| 8121 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8123 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='angelfly'
|
| 8125 | andre_krap | localhost | andre_wap | Query | 24 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8138 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8139 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='candi.boi'
|
| 8143 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='angelfly'
|
| 8145 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8153 | andre_krap | localhost | andre_wap | Query | 21 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lacoste'
|
| 8166 | andre_krap | localhost | andre_wap | Query | 22 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8167 | andre_krap | localhost | andre_wap | Query | 22 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8175 | andre_krap | localhost | andre_wap | Query | 24 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='candi.boi'
|
| 8181 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8186 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lacoste'
|
| 8187 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8191 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lamyboy'
|
| 8199 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='thug_h.b.k'
|
| 8203 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lamyboy'
|
| 8204 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8211 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8222 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8226 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lacoste'
|
| 8231 | andre_krap | localhost | andre_wap | Query | 23 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND
sentto='fatal.' |
| 8244 | andre_krap | localhost | andre_wap | Query | 15 | Sending
data | SELECT unread,sentby,id FROM private WHERE sentto='M2' ORDER BY
id DESC LIMIT 0,15 |
| 8248 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lamyboy'
|
| 8267 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8268 | andre_krap | localhost | andre_wap | Query | 15 | Sending
data | SELECT unread,sentby,id FROM private WHERE sentto='M2' ORDER BY
id DESC LIMIT 0,15 |
| 8270 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='candi.boi'
|
| 8272 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='at0z'
|
| 8273 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='lacoste'
|
| 8295 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8315 | andre_krap | localhost | andre_wap | Query | 23 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='at0z'
|
| 8319 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8322 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='gattwo'
|
| 8333 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8337 | andre_krap | localhost | andre_wap | Query | 7 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND
sentto='fatal.' |
| 8339 | andre_krap | localhost | andre_wap | Query | 17 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND sentto='LAM'
|
| 8344 | andre_krap | localhost | andre_wap | Query | 7 | Sending
data | SELECT COUNT(*) FROM private WHERE sentto='tuli2'
|
| 8346 | andre_krap | localhost | andre_wap | Query | 10 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND
sentto='lacoste' |
| 8353 | andre_krap | localhost | andre_wap | Query | 3 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND sentto='At0z'
|
| 8354 | andre_krap | localhost | andre_wap | Query | 2 | Sending
data | SELECT COUNT(*) FROM private WHERE unread='y' AND

I have tried to make the timeout less which helped a bit but it still happened

And my .htaccess

php_value mysql.connect_timeout 20php_flag register_globals on
AddType application/vnd.nok-s40theme nth
ErrorDocument 404 http://forums.xisto.com/no_longer_exists/
ErrorDocument 503 http://forums.xisto.com/no_longer_exists/
ErrorDocument 403 http://forums.xisto.com/no_longer_exists/


i really dont know what to do :angry:
please help,,
thanks
Andre

Share this post

Link to post
Share on other sites

OpaQue    15

OpaQue
Posted

Hey Andre, Thanks for not making another topic in Xisto - Web Hosting section and ranting there. I really appreciate your trying to seek a solution to this problem.I'd recommend you try using PERSISTENT CONNECTIONS. And You close the connection properly at the end of your script.

Share this post

Link to post
Share on other sites

krap    0

krap
Posted

I'd recommend you try using PERSISTENT CONNECTIONS.

 

ok ive found how to do that with msql_pconnect()

And You close the connection properly at the end of your script.

 

But i found this in php.net..

msql_pconnect() acts very much like msql_connect() with two major differences.

 

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host. If one is found, an identifier for it will be returned instead of opening a new connection.

 

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (msql_close() will not close links established by this function).

Now im confused :blink::lol:

 

Andre

Share this post

Link to post
Share on other sites

gameratheart    0

gameratheart
Posted

If you use persistent connections, it will not stop MySql even if you tell it to. You have to stop it being persistent. (Anyone know how?)

Share this post

Link to post
Share on other sites

krap    0

krap
Posted

I was editing my script to use pconnect but i discovered i was using it already hmmm

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

  I accept