Elliot B. Posted June 26, 2002 Share Posted June 26, 2002 NeoBond etc., disable the guest accounts! That'll free up some resources! Also, how about deleting accounts that have been inactive for longer than 30/50 days? Link to comment Share on other sites More sharing options...
Apollo Posted June 26, 2002 Share Posted June 26, 2002 Originally posted by King Mustard NeoBond etc., disable the guest accounts! That'll free up some resources! Also, how about deleting accounts that have been inactive for longer than 30/50 days? i don't think freeing the guests is a good idea but for sure delete the inactive accounts for at least 60 days! Link to comment Share on other sites More sharing options...
Glowstick Posted June 26, 2002 Share Posted June 26, 2002 Ok, who of you if DDoSing the server now? :D Ah just compact the tables, should be nuff. Link to comment Share on other sites More sharing options...
Tim Dorr Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 Originally posted by Tom Servo Ah just compact the tables, should be nuff. i've gone through them all. they've all been optmized (there is not true compact table command under mysql) and we're not going to turn off guests, becuase we will no longer grow... it's a double edged sword really... Link to comment Share on other sites More sharing options...
sailgreg Posted June 26, 2002 Share Posted June 26, 2002 What are the spects one the server running this site? Do you have the latest version of MySQL installed, this may help a little. Link to comment Share on other sites More sharing options...
fangtu Posted June 26, 2002 Share Posted June 26, 2002 it's weird that Neowin is always like this these days....><" Link to comment Share on other sites More sharing options...
1n$an3 Posted June 26, 2002 Share Posted June 26, 2002 I've been getting the same Server Busy crap the past couple of days. I too think you should delete the inactive accounts but no the guest accounts. Link to comment Share on other sites More sharing options...
Tim Dorr Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 Originally posted by sailgreg What are the spects one the server running this site? Do you have the latest version of MySQL installed, this may help a little. no we don't, we have .46 and the latest is .51. i'm goign to see about getting shell access for myself so I can a) upgrade mysqld, and b) compile it on our server so I'm sure we have the optimal settings to run under... Link to comment Share on other sites More sharing options...
Malechai Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 moved to site & forum issues Link to comment Share on other sites More sharing options...
kennisonxgs Posted June 26, 2002 Share Posted June 26, 2002 How about limiting guests? Link to comment Share on other sites More sharing options...
Impulfusion Posted June 26, 2002 Share Posted June 26, 2002 i get that message too since yesturday... today most of the day the server was "busy"...:mad: Link to comment Share on other sites More sharing options...
SuperJediMedia Posted June 26, 2002 Share Posted June 26, 2002 Yeah... You should email (as a curtesy, not a spam or annoyance) anyone who didn't come here for over 3 months. Just ask them if they are still interested to come back, if not their account will be deleted. And you tell them why (because server is down too much) Sometimes, people too busy with life forget about places they visited and they also don't want to be erased. Link to comment Share on other sites More sharing options...
Steven P. Administrators Posted June 26, 2002 Administrators Share Posted June 26, 2002 Yeah we dont need Guest's :cheeky: How do you think "Guest's" became members? I'm sorry but we can disable everything and become a crap site too if you want. Link to comment Share on other sites More sharing options...
Timan Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 Maybe that AOL Server move wasn't a good idea like back in aprile :rolleyes: Link to comment Share on other sites More sharing options...
Impulfusion Posted June 26, 2002 Share Posted June 26, 2002 Originally posted by Neobond Yeah we dont need Guest's :cheeky: How do you think "Guest's" became members? I'm sorry but we can disable everything and become a crap site too if you want. well what u want? better for guests or no more service for members? we grow up and the server dont grow as we grow... if neowin start doing this everyday... i'll change forums... Link to comment Share on other sites More sharing options...
Timan Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 Originally posted by Impulfusion well what u want? better for guests or no more service for members? we grow up and the server dont grow as we grow... if neowin start doing this everyday... i'll change forums... Well hey if we lose you that means the server gets faster ;) j/j Link to comment Share on other sites More sharing options...
REBELinBLUE Posted June 26, 2002 Share Posted June 26, 2002 I think disabling guests is a bad idea, as well as disabling old accounts. It basically gives the "Post or be deleted" attitude. People don't like that. Anyway inactive accounts aren't causing the problem, it's actually active accounts cause it is to do with the server load, i.e. the number of users who are logged in and using the board increase the server load Link to comment Share on other sites More sharing options...
Redmak Administrators Posted June 26, 2002 Administrators Share Posted June 26, 2002 It's not the size of the database that's the problem here , mysql databases can be gigabytes before they slow down (ours is less than 250Mb) . It's the number of hits on the server (sql and http) Link to comment Share on other sites More sharing options...
Impulfusion Posted June 26, 2002 Share Posted June 26, 2002 Originally posted by unsanity Well hey if we lose you that means the server gets faster ;) j/j :right: very funny... but it's real... it gets really annoying! Link to comment Share on other sites More sharing options...
Timan Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 it all started when yall posted that sp1 link :( damn you BETAS :rolleyes: Link to comment Share on other sites More sharing options...
Impulfusion Posted June 26, 2002 Share Posted June 26, 2002 Originally posted by unsanity it all started when yall posted that sp1 link :( damn you BETAS :rolleyes: yeah i noticed that too... but it started doing this yesturday... Link to comment Share on other sites More sharing options...
sorlag Posted June 26, 2002 Share Posted June 26, 2002 Originally posted by timdorr i've gone through them all. they've all been optmized (there is not true compact table command under mysql) then use a separate tool/script to compact the database. Link to comment Share on other sites More sharing options...
Timan Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 Originally posted by Impulfusion yeah i noticed that too... but it started doing this yesturday... well guess what happened yesturday another sp1 link posted HRMMMMM Link to comment Share on other sites More sharing options...
Tim Dorr Veteran Posted June 26, 2002 Veteran Share Posted June 26, 2002 Originally posted by sorlag then use a separate tool/script to compact the database. but mysql doesn't do compacts at all... optmize is close enough anyways... Link to comment Share on other sites More sharing options...
Impulfusion Posted June 26, 2002 Share Posted June 26, 2002 Originally posted by unsanity well guess what happened yesturday another sp1 link posted HRMMMMM but are the files on the neowin's server? Link to comment Share on other sites More sharing options...
Recommended Posts