MySQL connections
- ~Z~
- Sofa King Admin
- Posts: 13007
- Joined: Tue Oct 12, 2004 2:14 pm
- Location: Grand Rapids, MI
- Contact:
MySQL connections
After getting this MySQL error message on and off for the past two days, I just changed how this message board connects to the main database that has all of the forum posts in it. Please let me know if you notice any kind of change in speed, errors, or problems with the shoutbox. Trying some tweaking and hoping this will help those issues.
Webmaster
Railroad photos on Railroadfan.com
Railroad photos on Railroadfan.com
- ~Z~
- Sofa King Admin
- Posts: 13007
- Joined: Tue Oct 12, 2004 2:14 pm
- Location: Grand Rapids, MI
- Contact:
is anyone noticing any kind of difference at all? is it running the same for you?
Webmaster
Railroad photos on Railroadfan.com
Railroad photos on Railroadfan.com
- ~Z~
- Sofa King Admin
- Posts: 13007
- Joined: Tue Oct 12, 2004 2:14 pm
- Location: Grand Rapids, MI
- Contact:
Well, decided to reverse this and back up even further. Turned on in more places what's called "persistant connections." What this is supposed to do is keep you connected to the big MySQL database that holds all the text and information for the message board and gallery.
I'm working within a small window from the host of mine that eats banannas. If too many people are have been accessing the SQL database, we'll get some errors said "error, max connections blah blah blah"
By making your windows persisant, each user should only use one connection, so things might be fine now... Hopefully you won't notice any speed issues.
I also hope this takes care of a problem the host had with us users lately...seems as though if you opened up 30 or more pages on the site within a short time, you got blocked by your IP address, and pretty much were banned from the site... i can think of at least 10 people that this happened to, including MYSELF, recently.
Anyway, let me know if you see any errors come up... keep this email address for reference in case you have problems:
zysegur@hotmail.com
That's an external address that should always work, even when the site goes down.
I'm working within a small window from the host of mine that eats banannas. If too many people are have been accessing the SQL database, we'll get some errors said "error, max connections blah blah blah"
By making your windows persisant, each user should only use one connection, so things might be fine now... Hopefully you won't notice any speed issues.
I also hope this takes care of a problem the host had with us users lately...seems as though if you opened up 30 or more pages on the site within a short time, you got blocked by your IP address, and pretty much were banned from the site... i can think of at least 10 people that this happened to, including MYSELF, recently.
Anyway, let me know if you see any errors come up... keep this email address for reference in case you have problems:
zysegur@hotmail.com
That's an external address that should always work, even when the site goes down.
Webmaster
Railroad photos on Railroadfan.com
Railroad photos on Railroadfan.com
-
- Yooper Foamer
- Posts: 1527
- Joined: Wed Aug 30, 2006 12:00 am
- Location: Marquette, MI