HELP - mySQL question

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jinn
    Confirmed User
    • Nov 2001
    • 72
    #1

    HELP - mySQL question

    My server is running FreeBSD + apache + php + mySQL. Recently, I keep getting error messages like this:
    Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

    When I check the memory and cpu usage, there are a couple hundreds of MB ram free. But the cpu idle is 0.0%! And mysqld is taking 95% or more of the cpu time. The server was running well and there is no new scripts installed and no significant increase in traffic. Anyone can provide some insight about what went wrong here? I don't know if it's related, but the problem started just a couple days after the recent internet worm attack.

    Any help please? Thanks!

    Jin
    Tags: None
    • gothweb
      Confirmed User
      • Jun 2002
      • 8849
      #2

      Photos by Ian X.: Distinctive photos of goth babes.
      Blood Money:Your traffic, my sites, our money.
      MojoHost: Still the best.

        Comment

        • FuqALot
          Confirmed User
          • Dec 2001
          • 3817
          #3
          Yes, this could be indeed the sql worm, I suggest you contact your system admin or something :-P.

          http://www.microsoft.com/Downloads/d...7-2DE45CFA6A89
          Last edited by FuqALot; 02-04-2003, 12:11 PM.

            Comment

            • DrGuile
              Confirmed User
              • Jan 2002
              • 2025
              #4
              are you running the latest version?





              ahahhahah, this as no chance to be the SLAMMER worm...

              its an MS-SQL worm...
              LiveBucks / Privatefeeds - Giving you money since 1999
              Up to 50% Commission!
              25% Webmaster Referal
              Powered by Gamma

                Comment

                • Jinn
                  Confirmed User
                  • Nov 2001
                  • 72
                  #5
                  I am running mysql version 3.23.49. Do you think the upgrade will help here? I don't believe it's from the slammer worm, either.

                    Comment

                    • Backov
                      Confirmed User
                      • Mar 2001
                      • 1600
                      #6
                      Jesus fucking christ.

                      It's not the SQL worm, that only affects MS SQL.

                      You are probably running out of connections.. And if mysql is taking 100% of your CPU, then whatever script you are running was written by a retarded monkey. You wouldn't believe the abuse I can put mysql through before it even starts to break a sweat.

                      The short of it: Talk to your sysadmin. He'll be able to up your connections, or restart the server, or whatever has gone wrong with MySQL.

                      Cheers,
                      Backov
                      <embed src="http://banners.spotbrokers.com/button.swf" FlashVars="clickURL=http://banners.spotbrokers.com" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="120" height="60"></embed>

                        Comment

                        • gothweb
                          Confirmed User
                          • Jun 2002
                          • 8849
                          #7
                          Actually... Could the worm be causing traffic that would explain the load on a non-MS SQl server?

                          Photos by Ian X.: Distinctive photos of goth babes.
                          Blood Money:Your traffic, my sites, our money.
                          MojoHost: Still the best.

                            Comment

                            • wwwcashmountain
                              Confirmed User
                              • Dec 2002
                              • 194
                              #8
                              Jesus fucking christ.

                              It's not the SQL worm, that only affects MS SQL.

                              Heh.

                              You'll get this error if

                              a) all your mysql connections are taken up
                              b) mysql isnt running

                              I'd say you have a slow process running. Restart the DB and sit in a mysql window doing a 'show processlist' to see what's going on.

                              Rob.
                              SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

                                Comment

                                • boldy
                                  Macdaddy coder
                                  • Feb 2002
                                  • 2806
                                  #9
                                  try todo a 'show processlist' to see which queries are fucking up your system.

                                  May b one of your indexes is corrupt, try todo a

                                  mysqlcheck -o --all-databases -p
                                  MacDaddy Coder.

                                    Comment

                                    Previous template Next
                                    Working...