DOS Games Message Board
DOS Games Discussion
A message board to talk about DOS games, get help, and find old games.
Do NOT post warez or abandonware requests please
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


The return of the "server is acting wonky" thread

 
Post new topic   Reply to topic    DOS Games Discussion Forum Index -> Announcements
Author Message
emmzee
Site Admin
Site Admin


Offline
Joined: 14 Sep 2002
Posts: 2402
Location: Ontario, Canada

PostPosted: Fri Nov 26, 2004 9:55 pm     Post subject: The return of the "server is acting wonky" thread Reply with quote

Yea over the past two days the mySQL part of the server has decided to stop working twice ... it's been running fine for months, so I have no idea why it would decide to start screwing up now. Sarcastic Anyways I'll try to investigate this wkend. A temporary solution may be to just have the server reboot once per day. (Rebooting solves the problem of course.)

As always a new hella-fast server is always an option, although that would of course be more cash out of my pocket so I want to avoid that if possible Wink I'll post again if I have other news to report ... thanks for your patience, and thanks especially goes to those of you who emailed/msg'd me to let me know the server was acting up. Benevolent
Back to top
Amro
Way too much free time
Way too much free time


Offline
Joined: 24 Sep 2002
Posts: 479
Location: nth world

PostPosted: Sun Nov 28, 2004 5:22 pm     Post subject: Reply with quote

Did you update your MySQL database? Because my host upgraded to the latest version, and they had a million problems because of incompatibility. In fact, a whole lot of other sites were down because of MySQL problems.
Back to top
emmzee
Site Admin
Site Admin


Offline
Joined: 14 Sep 2002
Posts: 2402
Location: Ontario, Canada

PostPosted: Sun Nov 28, 2004 5:31 pm     Post subject: Reply with quote

Nope, nothing has been upgraded ...

The problem seems to be the logfiles ... they were huge (200+megs) and whenever they were generated (once a day) the server slowed to a crawl ... I found out where the max sizes for each of the sites was specified and modified them to be much smaller ... so far no more crashes so hopefully (*crosses fingers*) the problem is solved for now ...
Back to top
Joris
Way too much free time
Way too much free time


Offline
Joined: 27 Jul 2003
Posts: 388
Location: the Netherlands

PostPosted: Tue Nov 30, 2004 10:03 am     Post subject: Reply with quote

Good work emmzee Congratulatory

200+ megs of logs, that's really a lot Meh I hope there won't be any problems with the MySQL databases again, but the future will tell us...
Back to top
emmzee
Site Admin
Site Admin


Offline
Joined: 14 Sep 2002
Posts: 2402
Location: Ontario, Canada

PostPosted: Sun Dec 05, 2004 11:42 pm     Post subject: Reply with quote

Update ...

I've made lots of tweaks lately to how the server runs ... I've even converted most of my site play.vg to static html pages to reduce the number of MySQL queries going on ... however the server still seems to be rather full.

So, just in case ... has anyone hosted here installed any new scripts lately like ad-serving or hits tracking or anything? Or added new code to their site, specifically code that uses MySQL? Not blaming anyone of course, just trying to narrow down exactly where the problem is ...

For now the server seems to be gradually "filling up", in terms of resources. If I reboot every 48hrs or so it will probably be fine but that's a rather lame "solution" so I'd rather get it fixed. I'll continue to tweak where I can to get it working properly ... we'll see how it goes ... if the site goes down again, don't worry I will look into it as soon as I possibly can (keeping in mind I do have a full time job now heh). Thanks all Happy
Back to top
Kazer0
Mercenary Dishwasher


Offline
Joined: 17 Sep 2002
Posts: 2704
Location: In an igloo with my pet penguin, eh?

PostPosted: Sun Dec 05, 2004 11:55 pm     Post subject: Reply with quote

I havnt installed anything new. I cant, i ran outta space. The only 2 real things I have going are my Bio, and my support forums. Support forums with less than 100 people signed up, and my Bio had only 30,000 hits (And its php/HTML, no MySQL).
Back to top
emmzee
Site Admin
Site Admin


Offline
Joined: 14 Sep 2002
Posts: 2402
Location: Ontario, Canada

PostPosted: Mon Dec 06, 2004 12:17 am     Post subject: Reply with quote

Added 20megs more to your account ... actually I happened to notice you were running out of space about 5mins before I came back here and read your msg Happy
Back to top
Joris
Way too much free time
Way too much free time


Offline
Joined: 27 Jul 2003
Posts: 388
Location: the Netherlands

PostPosted: Mon Dec 06, 2004 1:38 pm     Post subject: Reply with quote

I haven't done anything at dosgamesonline.com since Septembre 30, although Erik was working on an IP block system today for dosgamesonline.com (someone placed comments and was talking a lot of rubbish, and he typed something about allah etc...).
Back to top
Kazer0
Mercenary Dishwasher


Offline
Joined: 17 Sep 2002
Posts: 2704
Location: In an igloo with my pet penguin, eh?

PostPosted: Mon Dec 06, 2004 2:05 pm     Post subject: Reply with quote

emmzee wrote:
Added 20megs more to your account ... actually I happened to notice you were running out of space about 5mins before I came back here and read your msg Happy


You're a good man emmzee.
Back to top
Cakephatt
Expert
Expert


Offline
Joined: 10 Oct 2004
Posts: 195
Location: i live in a box

PostPosted: Fri Dec 24, 2004 8:21 pm     Post subject: Reply with quote

http://dogs.pos.to/spanky_20011118.html
Merry Christmas
Back to top
Elign
Moderator
Moderator


Offline
Joined: 18 Dec 2004
Posts: 270

PostPosted: Thu Dec 30, 2004 2:15 pm     Post subject: Reply with quote

Looks like the new server is faster than ever.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    DOS Games Discussion Forum Index -> Announcements All times are GMT - 5 Hours
Page 1 of 1

 
Free Windows games


Powered by phpBB © 2001, 2005 phpBB Group and Ask an Expert
Also powered by Darren and the other admin and mods' hard work! ;)