Welcome Guest ( Log In | Register )



2 Pages V  < 1 2  
Reply to this topicStart new topic
> Mysql Error Never Seen On My Site Before (too Many Connections).
Quatrux
post Jul 29 2006, 08:12 PM
Post #11


the Q
Group Icon

Group: [HOSTED]
Posts: 1,133
Joined: 13-July 05
From: Lithuania, Vilnius
Member No.: 7,059
myCENTs:5.70



QUOTE(pyost @ Jul 29 2006, 09:26 PM) *

Nope, you can use only those that are predefined in the AdSense control panel.


As a matter of fact I saw Google ads which looked a bit customized, I don't know how they did it, but I think they just added javascript, but maybe this is special ads of somekind, they really pointed to google adsense links, can't remember the site, so maybe it is possible, you always can email google adsense team, but I don't know what they could answer, it is better to ask if it is possible and not if I can, I think biggrin.gif
Go to the top of the page
 
+Quote Post
vujsa
post Jul 31 2006, 05:46 AM
Post #12


Absolute Newbie
Group Icon

Group: Admin
Posts: 888
Joined: 20-February 05
From: Indianapolis, Indiana, USA (Midwest)
Member No.: 2,714
myCENTs:35.43



QUOTE(cyborgxxi @ Jul 29 2006, 09:04 AM) *
I had this problem like a thousand times on my website before. I mean, I thought it would be some sort of an uptime/downtime problem but I have no idea what the heck is going on!!

Please pardon me if I'm being very explosive but when it last happened and I posted a problematic thread/post on the hosted members' support page, I don't believe I got any help on it.

I saw other people's posts about the same thing / incident but I don't believe they got any help either.

What's going on?

The reason you received no help on the matter is because by the time someone noticed the post, the problem was gone. SO in order to reply to your particular post, "Please wait and do not refresh your website over and over and see how things are in about an hour if the problem hasn't already be resolved."

We all share the same MySQL server. The too many connections refers to everyones connections usually. While there is a cap on the number of connections each website may have at once, the entire server also has a cap which is not as large as all of the individual accounts put together so if 10% or more of the websites are at or near their maximum, then the server could be overwhelmed. I'm not sure what the exact figures are for these settings but this is usually what happens. This usually clears up in a few minutes unless we get a few impatient people trying to get the pages to load. Now not only did you have too many connections on the server to begin with, everybody is trying to refresh the error page to get the webpage to load correctly. Few people realize that by repeatedly trying to get the page to load they are actually making the problem worse. Most database connections last less than a secondso in order to have too many connections, there has to be a lot of connection requests all at the same second for the most part.

Probably the biggest cause of this error to begin with is poor script optimization. Basicaly Joe Blow writes a script that accesses the database in a sloopy way. As a result, his sloopy code on his rather poorly designed website can have the same impact on the server as Bill's really busy and well designed website. So Joe's site kills the server then Bill's users keep the server over taxed with their page refreshes and reloads.

OpaQue tries to identify websites on the server that have this kind of negative impact on the rest of the accounts and either work with the account holder to correct the problem or if need be remove the problem file.

So my suggestion to you is to create a backup page for your website that you can use to relieve the server burden. Some kind of "Technical Difficulties" message that you can set all of your webpages to redirect to via your .htaccess file. Then when this proble comes up, just switch over to your message page and that will prevent your users from continuing the connection flood on the database server.

Better yet, rewrite your scripts to respond better to the Too Many Connections Error. If this happens instead of telling the user right away, make the script sleep for a few seconds so they don't refresh right away. A five second pause for everyone on your site could be just what the server needs to get caught up. Using a random number between 5 and 10 seconds would also keep everyone from your website from having the opportunity to refresh at the same time.

One additional suggestion, let your user know what the problem and the solution is. If you tell your user that the problem is caused by too many connections at the same time and inform them that refreshing the page will only make the problem worse, they will be less likely to add to the problem. Kindly ask them to wait a minute before they try to refresh and most will at leat give it 10 seconds. tongue.gif Usually, the serve doesn't need a big break, just enough to get caught up and it will be fine.

For best results, you should use all of these techniques together. If everyone used just one of these suggestions, then the server would never be down. This is particularly true for a server pause when this error occurs since the server just needs a second or two without a connection request.

Hope this helps. cool.gif

vujsa
Go to the top of the page
 
+Quote Post
Chesso
post Jul 31 2006, 06:59 AM
Post #13


Teh Coder
Group Icon

Group: Members
Posts: 1,053
Joined: 18-April 06
From: Australia
Member No.: 12,833
myCENTs:89.25



Was probably too many global wide connections. The home page only makes like 2 mysql_query's that are relativly simple select statements for one field of a row.
Go to the top of the page
 
+Quote Post
vhortex
post Jul 31 2006, 08:28 PM
Post #14


Guilty Until Proven Innocent
Group Icon

Group: Members
Posts: 372
Joined: 13-April 05
Member No.: 3,937



i think the choking points of the database server is starting to become frequent..
i dont know what is going on but judging on the number of shared hostings here..

3 malfuntioning scripts specially if they are on cron can crashed the server almost instantly...
the negative impacts of shared hosting..
Go to the top of the page
 
+Quote Post

2 Pages V  < 1 2
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Wrong Password/username - Fatal Error In Horde(4)
  2. Adsense Ad(1)
  3. MySQL - Can't Connect(1)
  4. Google Sitemaps Not Verifying My Site...(4)
  5. Problem With MySQL Not Being Able To Connect(9)
  6. Weird MySQL Message(4)
  7. Mail Delevery System Error(6)
  8. Problems With PHP/Joomla On Hosted Site(7)
  9. Help Me!(3)
  10. Site Unavailable!(7)
  11. Error Accessing Forum Topics(1)
  12. Something Odd On My Site......(9)
  13. Mysql Connect Error, Too Many Connections.(1)
  14. Php And Mysql Version.(7)
  15. Problems With cPanel(9)
  1. Problem With MySQL(5)
  2. What Is The MySQL Version @ Asta ?(16)
  3. Server Or Me?(5)
  4. My Site Is Suspended(8)
  5. Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql(3)
  6. Strange Error (maybe Directoryindex Glitch?)(6)
  7. Site / Account Not Working(10)
  8. Mysql Server Not Stable After Hard Disk Swap On April 6th(2)
  9. Site Not Working(5)
  10. Connecting To Astahost's Mysql(8)
  11. Can't Access Any Site Hosted On The Server(4)
  12. Site Down Again, Help Or Suggestions?(6)
  13. Time Travel?(4)


 



- Lo-Fi Version Time is now: 5th December 2008 - 05:49 PM