MySQL connections

Questions and updates for http://www.railroadfan.com are posted here. If anyone has suggestions, either post here or email me at zack@railroadfan.com.

MySQL connections

Unread postby ~Z~ » Fri Oct 26, 2007 8:41 am

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
User avatar
~Z~
Sofa King Admin
 
Posts: 10705
Joined: Tue Oct 12, 2004 1:14 pm
Location: Grand Rapids, MI

Unread postby ~Z~ » Fri Oct 26, 2007 1:09 pm

is anyone noticing any kind of difference at all? is it running the same for you?
Webmaster
Railroad photos on Railroadfan.com
User avatar
~Z~
Sofa King Admin
 
Posts: 10705
Joined: Tue Oct 12, 2004 1:14 pm
Location: Grand Rapids, MI

Unread postby CAT345C » Fri Oct 26, 2007 1:11 pm

funny, I took a screen shot of what it did, but I didn't save it. The shout box looked like it was written in Microsoft word (never a good thing) No formating, just white, with huge font.
Making the railroad all Catywompus since 2008

https://www.flickr.com/gp/66353741@N07/02EZ1e
CAT345C
RedNeck Train Chaser
 
Posts: 4077
Joined: Sat Jul 30, 2005 7:42 pm
Location: Dehli Twp

Unread postby Norm » Fri Oct 26, 2007 3:21 pm

No change here; everything running smoothly.

Glad you know your SQL commands. I administer an aviation forum using UBB threads, and worry about using them. One wrong move, and things can get screwed up in a hurry.
Norm
User avatar
Norm
Railroadfan...fan
 
Posts: 1845
Joined: Sun Dec 17, 2006 7:03 am
Location: Waterford, MI

Unread postby J T » Fri Oct 26, 2007 6:57 pm

I can use two cans and wire to communicate.
User avatar
J T
Hates Supper
 
Posts: 10499
Joined: Mon Dec 11, 2006 7:23 pm
Location: Grand Rapids

Unread postby ~Z~ » Thu Dec 13, 2007 3:57 pm

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.
Webmaster
Railroad photos on Railroadfan.com
User avatar
~Z~
Sofa King Admin
 
Posts: 10705
Joined: Tue Oct 12, 2004 1:14 pm
Location: Grand Rapids, MI

Unread postby i995impalass » Thu Dec 13, 2007 7:34 pm

I had a bit of a thing sending PM about a week ago. It said message could not be sent error Debugging.

Been working great since tho...
User avatar
i995impalass
Yooper Foamer
 
Posts: 1504
Joined: Tue Aug 29, 2006 11:00 pm
Location: Marquette, MI


Return to Web Site updates, questions, and suggestions

Who is online

Users browsing this forum: No registered users and 4 guests

cron

x