Can Anyone Help With A Mysql Problem/installation?

StormLiongStormLiong Join Date: 2002-12-27 Member: 11569Members
in Off-Topic
<div class="IPBDescription">its making the server move to a crawl</div> I do not know wat triggered it. The week before the website server was running fine. And then this week, each time page that accesses the database (whihc is like nearly every page) is viewed, the mysql program "mysql-nt.exe" starts to jump to 100% CPU Usage. I just don't get it. I have been looking at my scripts. I havent done any major or anything at all to them.

Just wondering if anyone here coudl give a clue to the solution to this problem. <!--emo&:D--><img src='http://www.unknownworlds.com/forums/html//emoticons/biggrin-fix.gif' border='0' style='vertical-align:middle' alt='biggrin-fix.gif' /><!--endemo-->

THanks
Off Topic Disagree Agree Awesome

Comments

  • AeaAea Join Date: 2003-10-09 Member: 21552Members
    Forcefull reboots solve 95% of windows problems <!--emo&:p--><img src='http://www.unknownworlds.com/forums/html//emoticons/tounge.gif' border='0' style='vertical-align:middle' alt='tounge.gif' /><!--endemo-->
    Off Topic Disagree Agree Awesome
  • StormLiongStormLiong Join Date: 2002-12-27 Member: 11569Members
    already rebooted the server like 3-4 times already and each time it still produces the exact same problem eventually.
    Off Topic Disagree Agree Awesome
  • DOOManiacDOOManiac Worst. Critic. Ever. Join Date: 2002-04-17 Member: 462Members, NS1 Playtester
    check what queries are running. Perhaps you have a query stuck in a loop or something?

    Have you tried re-installing mysql?
    Off Topic Disagree Agree Awesome
  • StormLiongStormLiong Join Date: 2002-12-27 Member: 11569Members
    thanks for yours help.

    Got the problem fixed. Problem was more worse than I thought. Somehow some hacker was using the mail component of the server to act as a mail forwarding for spam. There was like 52000+ mail he was trying to send (from the outbox logs). Shut that down and deleted all the mail. Now I gots to get the server locked down tight to avoid another incident and do a proper investigations.
    Off Topic Disagree Agree Awesome
  • DOOManiacDOOManiac Worst. Critic. Ever. Join Date: 2002-04-17 Member: 462Members, NS1 Playtester
    Ouch.

    You didn't have open routing (or whatever its called, Its been awhile since I messed w/ mail servers) turned on did you?
    Off Topic Disagree Agree Awesome
  • TalesinTalesin Our own little well of hate Join Date: 2002-11-08 Member: 7710NS1 Playtester, Forum Moderators
    The down side to running a webserver (or any externally-accessible... or human-accessible machine) on a microsoft OS. The exploits are known, and this crud happens. <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html//emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo-->
    Off Topic Disagree Agree Awesome
  • Dorian_GrayDorian_Gray Join Date: 2004-02-15 Member: 26581Members, Constellation
    edited September 2004
    <!--QuoteBegin-Talesin+Sep 29 2004, 02:14 AM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (Talesin @ Sep 29 2004, 02:14 AM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> The down side to running a webserver (or any externally-accessible... or human-accessible machine) on a microsoft OS. The exploits are known, and this crud happens. <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html//emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo--> <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
    Indeed. Some nub called me because his windoze SMTP server was slow. So I plug in a monitor (terminal services timed out because of the lag) and his SMTP daemon was sending thousands of spam messages. Yeah. Worst bit was that EVERY SINGLE ONE was scanned by Norton AntiVirus on the way out. The backlog was somewhere about 1 million messages, since it took 10 seconds to scan each one.

    Edit: the SMTP daemon itself was crap too. It couldn't be configured, the only options were a button to see the queue and a button to see the log. No relay configuration or anything.
    Off Topic Disagree Agree Awesome
  • JHunzJHunz Join Date: 2002-11-15 Member: 8815Members, Constellation
    After you tighten your relay settings, you'll probably want to check to see if you're on any of the higher-profile DNS blacklists like ORBS, SPEW, or njabl. Almost all blacklists allow you to request a retest that will remove your site if the test returns negative.

    Except Blars. Grr.
    Off Topic Disagree Agree Awesome
Sign In or Register to comment.